Import/Export Tool giving error when importing
Posted: Wed May 20, 2015 5:17 am
Hello, I have installed the import/export tool and tested it out. I exported the first 500 products and the file downloaded properly. I looked at it and all of the entries seemed correct. I then attempted to import the same file without changing it to see if every thing is working correctly and I got this error:
2015-05-19 14:14:25 - Export/Import: Worksheet 'AdditionalImages' cannot use product_id '103' because it is not listed in worksheet 'Products'!
2015-05-19 14:14:25 - Export/Import: Worksheet 'AdditionalImages' cannot use product_id '211' because it is not listed in worksheet 'Products'!
2015-05-19 14:14:25 - Export/Import: Worksheet 'AdditionalImages' cannot use product_id '229' because it is not listed in worksheet 'Products'!
2015-05-19 14:14:25 - Export/Import: Worksheet 'Rewards' cannot use product_id '103' because it is not listed in worksheet 'Products'!
2015-05-19 14:14:25 - Export/Import: Worksheet 'Rewards' cannot use product_id '211' because it is not listed in worksheet 'Products'!
2015-05-19 14:14:25 - Export/Import: Worksheet 'Rewards' cannot use product_id '229' because it is not listed in worksheet 'Products'!
What am I doing wrong? We are using OC v.1.5.5.1
Edit* I tried to do the same thing by exporting the options and then importing, and it worked just fine.
The error log says this:Uploaded spreadsheet file has validation errors!
See also 'System > Error Logs' for more details.
No server data has been changed.
2015-05-19 14:14:25 - Export/Import: Worksheet 'AdditionalImages' cannot use product_id '103' because it is not listed in worksheet 'Products'!
2015-05-19 14:14:25 - Export/Import: Worksheet 'AdditionalImages' cannot use product_id '211' because it is not listed in worksheet 'Products'!
2015-05-19 14:14:25 - Export/Import: Worksheet 'AdditionalImages' cannot use product_id '229' because it is not listed in worksheet 'Products'!
2015-05-19 14:14:25 - Export/Import: Worksheet 'Rewards' cannot use product_id '103' because it is not listed in worksheet 'Products'!
2015-05-19 14:14:25 - Export/Import: Worksheet 'Rewards' cannot use product_id '211' because it is not listed in worksheet 'Products'!
2015-05-19 14:14:25 - Export/Import: Worksheet 'Rewards' cannot use product_id '229' because it is not listed in worksheet 'Products'!
What am I doing wrong? We are using OC v.1.5.5.1
Edit* I tried to do the same thing by exporting the options and then importing, and it worked just fine.