Post by UnKn0wN_Binary » Tue Jun 23, 2015 8:09 am

When I try and Export and Import without editing anything on my site locally I get the error:

2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Meat' used in worksheet 'ProductOptions'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Rice' used in worksheet 'ProductOptions'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Toppings' used in worksheet 'ProductOptions'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Veggie' used in worksheet 'ProductOptions'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Beans' used in worksheet 'ProductOptions'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Meat' used in worksheet 'ProductOptionValues'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Meat' used in worksheet 'ProductOptionValues'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Meat' used in worksheet 'ProductOptionValues'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Meat' used in worksheet 'ProductOptionValues'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Rice' used in worksheet 'ProductOptionValues'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Rice' used in worksheet 'ProductOptionValues'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Toppings' used in worksheet 'ProductOptionValues'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Toppings' used in worksheet 'ProductOptionValues'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Toppings' used in worksheet 'ProductOptionValues'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Toppings' used in worksheet 'ProductOptionValues'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Toppings' used in worksheet 'ProductOptionValues'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Veggie' used in worksheet 'ProductOptionValues'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Beans' used in worksheet 'ProductOptionValues'!
2015-06-23 1:17:55 - Export/Import: Undefined option_name 'Beans' used in worksheet 'ProductOptionValues'!


I have checked and uploaded the Options Sheet By itself and this still happens. Any idea as to why it would export the options in the sheet but would not upload them even without editing the sheet? Any help is appreciated.

I am using the latest version of Opencart and the latest version of Import/Export. As well as the latest version of all WAMP plugins.


Posts

Joined
Fri Oct 10, 2014 9:13 am

Post by zastil » Thu Jun 25, 2015 6:57 pm

Have you checked the CASE for each option name i.e. meat or Meat or MEAT

Newbie

Posts

Joined
Thu Jun 25, 2015 6:56 pm

Post by UnKn0wN_Binary » Sat Jul 04, 2015 12:10 am

It is all the same. I export the Excel File, do not make changes to it, import it again and get the errors. So it is an Issue with the way the file is exported, or the way it reads what Opencart Options are there.


Posts

Joined
Fri Oct 10, 2014 9:13 am

Post by kittykat » Wed Jul 08, 2015 10:12 pm

Could it be that you checked:

Use option_id instead of option name in worksheets 'ProductOptions' and 'ProductOptionValues'
Use option_value_id instead of option_value name in worksheet 'ProductOptionValues'

So the mod is looking for the IDs rather than names?

Newbie

Posts

Joined
Mon Mar 18, 2013 8:04 am

Post by UnKn0wN_Binary » Mon Jul 13, 2015 10:20 am

No everything is default with the Plugin. I have looked everywhere and cannot find a solution.


Posts

Joined
Fri Oct 10, 2014 9:13 am

Post by ArtGallery » Wed Jul 10, 2019 1:27 am

For those who might stumble on this thread, the default settings for the mod version I am using is set use the Value Name not the Value ID and it fails to import an unmodified export spreadsheet with similar errors. I had to change the settings (Third tab to the right) in the mod menu to Value ID in order to get the import to work.

I checked these two and left the others unchecked then clicked Update Settings at the bottom. Imports now worked with no errors.
Use option_id instead of option name in worksheets 'ProductOptions' and 'ProductOptionValues'
Use option_value_id instead of option_value name in worksheet 'ProductOptionValues'


The mod I have installed: Export/Import Tool (V3.20) for OpenCart 3.x mhccorp.com
I am running OpenCart 3.0.3.1

New member

Posts

Joined
Sat Apr 21, 2018 7:54 am
Who is online

Users browsing this forum: No registered users and 4 guests