ERROR : Invalid header in the ProductOptionValues worksheet
Pls guide. How i can resolve the above issue?
Thanks
Vishal
Second, because it is an extension, you should ask the developer first.
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
http://www.opencart.com/index.php?route ... _license=0
Please guide i am unable to import products and getting following error while importing products:
Export/Import: Invalid header in the ProductOptionValues worksheet
https://opencartforum.com/topic/50947-п ... port-tool/
if so, you would have answerred your question already, because you added some Value,
not beeing part of the default OC-Setup, by default.
Ernie
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
The problem is occuring with the extension. When i export data it runs successfully whereas when i used same excel files to import the data to my new server then error occurs while importing product file.
(1) First of all, create export sample file on the server you want to import data.
(2) Open the Import file which you have created previously and copy exactly all the top header lines from the export file created in Step 1.
(3) Re-Save the import files.
Now, you can import data successfully without facing "Invalid Header Column" Error.
Thanks all for your support .
Vishal
Thank you so much!!!vssoft wrote: ↑Wed Oct 05, 2016 10:11 pmFinally with the great support of developer of this module, I have resolved this error. For other users who are facing the same error : "Invalid Column Header" . Pls do the following steps to resolve this issue:
(1) First of all, create export sample file on the server you want to import data.
(2) Open the Import file which you have created previously and copy exactly all the top header lines from the export file created in Step 1.
(3) Re-Save the import files.
Now, you can import data successfully without facing "Invalid Header Column" Error.
Thanks all for your support .
Vishal
here is the code-> admin/model/extension/export_import.php please check Attachments
If you're indeed using JNeuhoff's Free Export/Import Tool, then their FAQ page might come in handy.
Quoted from there:
If this doesn't help with your scenario, please be more specific in what you are trying to achieve, what you have tried and what your attempts resulted in.Can I move products from an older to a newer OpenCart server?
Yes, you can! However, the formats of the old and new spreadsheet's worksheets will be slightly different, so it won't be a simple Export off the old server plus Import to the new server. Instead, follow these steps:
Also bear in mind to define all your options, attributes, and filters before you use them in products or categories data. Therefore, when importing data to a new server, do the Imports in the following order:
- Do an Export of your Categories, Products, and other data off your new server.
- Do an Export of your Categories, Products, and other data off your old server.
- Copy the old data, column by column, from your worksheets from step 2 and paste it to the corresponding worksheet columns of your new worksheets from step 1.
- Import the updated spreadsheet files from steps 1 and 3 to your new OpenCart server.
- Option definitions
- Attribute definitions
- Filter definitions
- Categories
- Products
I hope this helps,
Gergely
You need to define the options first before using them in the products import. You can do that with the Export/Import tool, too. Or you can your missing options via the OpenCart admin backend at: Catalog > Options > Edit or Addkanchan1995 wrote: ↑Mon Nov 15, 2021 1:31 pmI added 3 fields in productOptionValues tab for export is works properly but how to do changes for import functionality please guide
here is the code-> admin/model/extension/export_import.php please check Attachments
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
- Export/Import: Invalid header in the ProductOptions worksheet
- Export/Import: Invalid header in the ProductOptionValues worksheet
I have running it on WAMP with php 8.2
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Apologies for my earlier report, it was not entirely correct.
I had done an export with Dutch products in the old shop. The English language was completely switched off here.
English was enabled in the new shop, which is why the headers did not match.
That issue has now been resolved.
Another small bug I encountered: When an option ends with a space, the 'import of the options' works fine. And when you then import the products, it cannot match them with the options that originally (accidentally) had a space behind them.
Other question: Your tool doesn't allow us to export and import orders? Is that correct? Must be a good reason?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Users browsing this forum: No registered users and 41 guests