Post by BanditXXL » Fri Mar 11, 2016 7:22 pm

I get an error when trying to import previously exported xlsx product list:
Uploaded spreadsheet file has validation errors!
See also 'System > Error Logs' for more details.
No server data has been changed.

in the system log is:
2016-03-08 22:39:52 - Export/Import: Worksheet 'Rewards' cannot use product_id '181' because it is not listed in worksheet 'Products'!

In the exported list of products there was no product with 181 ID. Product with this ID was removed from my store a long time ago.

Please let me know the solution because I need to update my product database with new products.

Newbie

Posts

Joined
Wed Mar 05, 2014 11:45 pm

Post by Cue4cheap » Sat Mar 12, 2016 4:13 am

As it says: "Worksheet 'Rewards' cannot use product_id '181' "

Remove that line from the rewards worksheet.

cue4cheap not cheap quality


Expert Member

Posts

Joined
Fri Sep 20, 2013 4:45 am

Post by BanditXXL » Mon Mar 14, 2016 4:51 am

No, it's not a solution because this product_id is in the exported file and deleting it does not help.

After upgrading to 2,31 version I exported products and tried to import the exported file again and i get the following error:

Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!
See also 'System > Error Logs' for more details.
No server data has been changed.

2016-03-13 22:40:31 - error_unlisted_product_id

I didn't change the exported file.

Newbie

Posts

Joined
Wed Mar 05, 2014 11:45 pm

Post by JNeuhoff » Tue Mar 15, 2016 9:50 pm

Your database is corrupted, and your upgrade to 2.31 wasn't complete, either. The error_unlisted_product_id isn't possible because this text string is clearly listed in the admin/language/english/tool/export_import.php. I suggest you do a proper re-install of the Export/Import tool!

As regards the database: Remove all entries from of oc_product_reward where product_id = '181', using PHPMyAdmin.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by BanditXXL » Wed Mar 16, 2016 7:43 pm

I use polish language,
Ok,
I solved the problem witj 181 ID.

I have exported the product's using "Products (including product data, options, specials, discounts, rewards and attributes)" option.

After export i did import usingexported file and I get an error:

Uploaded spreadsheet file has validation errors!
See also 'System > Error Logs' for more details.
No server data has been changed.

System logs:
2016-03-16 12:40:25 - Export/Import: Undefined attribute_name 'Rozmiar' for attribute_group_name 'Haczyki' used in worksheet 'ProductAttributes'!
2016-03-16 12:40:25 - Export/Import: Undefined attribute_name 'Rozmiar' for attribute_group_name 'Haczyki' used in worksheet 'ProductAttributes'!
2016-03-16 12:40:25 - Export/Import: Undefined attribute_name 'Rozmiar' for attribute_group_name 'Haczyki' used in worksheet 'ProductAttributes'!
2016-03-16 12:40:25 - Export/Import: Undefined attribute_name 'Rozmiar' for attribute_group_name 'Haczyki' used in worksheet 'ProductAttributes'!
2016-03-16 12:40:25 - Export/Import: Undefined attribute_name 'Rozmiar' for attribute_group_name 'Haczyki' used in worksheet 'ProductAttributes'!
2016-03-16 12:40:25 - Export/Import: Undefined attribute_name 'Rozmiar' for attribute_group_name 'Haczyki' used in worksheet 'ProductAttributes'!
2016-03-16 12:40:25 - Export/Import: Undefined attribute_name 'Rozmiar' for attribute_group_name 'Haczyki' used in worksheet 'ProductAttributes'!
2016-03-16 12:40:25 - Export/Import: Undefined attribute_name 'Rozmiar' for attribute_group_name 'Haczyki' used in worksheet 'ProductAttributes'!

I've checked the attributes. everything seems to be ok. attribute_name 'Rozmiar' for attribute_group_name 'Haczyki' is correct and defined for such product group.

Newbie

Posts

Joined
Wed Mar 05, 2014 11:45 pm

Post by JNeuhoff » Thu Mar 17, 2016 1:00 am

Please check your Attribute definitions for attribute group 'Haczyki' and attribute 'Rozmiar'. In particular make sure there are no leading nor trailing white spaces used in their names!

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by BanditXXL » Thu Mar 17, 2016 5:35 pm

There was a trailing white space at attribute 'Rozmiar'. I've done the test export na import and everything seems to be ok. Import was a success.

Thank You for Your help.

Newbie

Posts

Joined
Wed Mar 05, 2014 11:45 pm
Who is online

Users browsing this forum: No registered users and 2 guests