Discussion

eCommerce - 1.7.0 - Attribute Inventory, Export/Import, and Currencies

Product Attributes
- Added Inventory control to Product Attributes - Docs
- Pricing of Product Attributes is now controlled per currency, rather than 1 charge for all currencies
- CSV Import/Export is now available from the Product List view
Added the ability to use custom parameters with PayPal - Docs
We've opened up our eCommerce Order flow, so you can add custom functions before and after payment is successfully taken. More information to follow...

Full changelog here

6 replies

Liked by Dean Vizer and 5 others

Where am I?

In Siteglide Community Forum you can ask and answer questions and share your experience with others!

Matt Walter Siteglide

last month

This covers most of the features spoken of here -> https://forum.siteglide.com/post/upcoming-ecommerce-work-tied-to-bc-eol-6127e69c771a872ca1f07774

Luke Wakefield Siteglide Admin

last month

@Nick Fenmor Collins @Nick Fenmor Collins I know you've got quite a few eCommerce sites you need this for so wanted to check you see it!

Nick Fenmor Collins

last month

Yes....all over it ...as you can imagine!

Thanks again :-)

Julia O'Reilly

last month

I’m excited about the implementation of Product Attribute imports/exports, though I need some further clarification.

I've got a small test batch of products that I've manually added Attributes for. When I exported the Attributes spreadsheet to test adding attributes to more products or to edit existing records, I find that the ID and Parent ID keys have been added in such a way that it’s not possible to know which line goes with which product - which makes the data impossible to manage. So I tried to edit them to make them more manageable and intuitive. Maybe this isn’t possible?

QUESTIONS

WHAT IS THE LINKING KEY/field for adding new attributes to products via spreadsheet? (That is: which field/column actually links (Keys) the Product to the Attribute?)
Aren't Attribute items supposed to overwrite if the data in the spreadsheet import is different in any field? If so, this is not working in my tests.
What is the relationship of the ID and Parent ID? That is: to what does the Parent ID refer - what is this field? Is it the child of the ID?
These two fields are not required fields, according to the instructions. Is that true?
How to best add new attributes to products with no existing products, via spreadsheet import? How will the product db find them? What is the Key that links the two tables of products and attributes?
(The External ID doesn’t appear to key the rows for importing to the products? What is its role?)

To manage the Attributes via spreadsheet, we need to know which Type/Name groups go together so that options are correctly assigned to the right attribute and product. The spreadsheet export assigns ID and Parent ID numbers, but I'm not seeing a logical connection between them which links the Attribute to the Option.

I tried replacing the Parent ID with a unique ID number progression. Failed to import.
I tried replacing the ID with a unique ID number progression. Failed to import.
I tried removing the ID completely. Failed to import or overwrite.

Hope some of this makes sense. I might be missing something really obvious. Thanks for any thoughts.

Matt Walter Siteglide

last month

If the Type is 'attribute', then the Parent ID should be the ID of a Product.
If the Type is 'option', then the Parent ID should be the ID of an Attribute.

You can run an export of Products to find the IDs you need, and then copy them over into this new sheet.

If you want to add a new Attribute and Options for that Attribute, then you should first just import the Attribute so and ID can be generated for it. Then do a 2nd import for the Options.

When adding new items in an import, then you shouldn't set the ID field, as the system hasn't yet assigned one.

Julia O'Reilly

last month

Thanks much, Matt, this helps a lot. I'll give it a shot.

eCommerce - 1.7.0 - Attribute Inventory, Export/Import, and Currencies

Where am I?

Related Discussions

Share Post