The problem is new attribute's values identifiers must be set to 0 (column ProductAttributeValueId) when importing, because sql server assigns identifiers by itself to new entities
Sorry for the delayed reply Serge, I had to go overseas. I have just tried what you said for one item and it seems to have worked! Hopefully I can do the rest now. Thanks so much for your advice!
The problem is new attribute's values identifiers must be set to 0 (column ProductAttributeValueId) when importing, because sql server assigns identifiers by itself to new entities
Would it cause an issue if all product value identifiers are set to 0 even if they already exist?
For example if I have 30 products already in nop that I want to update and a further 30 I want to add using the same spreadsheet and all product value identifiers were set to 0.
I'm attempting to knock up a spreadsheet that would allow me to modify product attributes for all of the same type of product.
This post helped get an import of product with attribute values, but we're still missing a way to import products with attribute combinations - including SKU and Overridden price. If i want to track inventory by product attributes, i would have to add all the combinations for each product one at a time.
We have developed a Bulk Import Plugin with features:
1) Bulk Upload of Product, Categories, Manufacturers, Product Attributes. 2) Bulk Upload of pictures in Product. 3) Bulk Import of new categories, manufacturers, product attributes in product. Once new categories, manufacturers and product attributes are imported the products can be imported in bulk mapping with new categories and manufacturers etc. 4)User can upload 10,000 records in 120 minutes.
We have developed a Bulk Import Plugin with features:
1) Bulk Upload of Product, Categories, Manufacturers, Product Attributes. 2) Bulk Upload of pictures in Product. 3) Bulk Import of new categories, manufacturers, product attributes in product. Once new categories, manufacturers and product attributes are imported the products can be imported in bulk mapping with new categories and manufacturers etc. 4)User can upload 10,000 records in 120 minutes.