I've used the import/export template, double checked all spreadsheets ensuring all have product IDs.
I get this message.
Export/Import: Missing product_ids in worksheet 'Products'!
However, all items DO have product ID's.
I have been able to export, adjust and successfully import the existing small product database. It is when I input my bulk data that I get the error and no import. Excel does seem to want to show product ID as text, even after I have converted the product ID's to numbers. But not sure if this could be the problem, or how to fix it if it is.
My import file is attached.
It seems when I exported my product data from my accounting program, it must have introduced some invisible formatting to the product_ID field. Excel treated this as text and I could not reformat it into numericals.
I decided to save the XLSX file as a CVS file and the save as XLSX again to see if it dropped the errant formatting.
It worked, and the file uploaded successfully.
Only one issue. It doesn't display anywhere. I'll check through the forum to see if I can find an answer.
If not I'll open another subject.
If anyone reading this knows the answer, I'd appreciate the input.
1. select " Products (including product data, options, specials, discounts, rewards and attributes)"
2. Click Export
3. Now an Xlsx file containing the product details, lands into the downloads folder in your computer
4. In the Xlsx file, replace the list of products, you need to upload form the xlsx file created by you.
5. Check All the data entered in xlsx file is in text format only ( select it from format cell )
6. Save the file
7. Now import. it works fine
Tenet Varsity Lab, PDKT
The R&D Unit of Tenet Technetronics
Had the same problem (using the Import/Export Tool for OC v184.108.40.206) and converting all cells to 'Text' in the spreadsheet prior to importing worked for me too - thanks Zanato.Zanato wrote:Had the same problem after editing the .xlsx file and fixed it by selecting the whole products tab (be clicking the little box in the top left corner between A and 1) and in the 'numbers' options box in the ribbon, change from 'General' to 'Text'
Sure, I understand.JNeuhoff wrote:This issue is often there because of using MS Excel instead of LibreOffice or OpenOffice Calc.
I haven't quite taken the final leap off the MS train wreck yet (still finalising my escape route ), so I'm still using some of the Office products.
This simple workaround works well and will hopefully suffice until such time as I finally kiss MS goodbye forever.
Also, thanks for a great extension JNeuhoff, much appreciated.
There is nothing to prevent you from using LibreOffice or OpenOffice Calc right now, even on Windows. The spreadsheets used by the Export/Import tool only contain data, nothing fancy. We haven't used MS Office for years, never missed it.wbd wrote: I haven't quite taken the final leap off the MS train wreck yet (still finalising my escape route ), so I'm still using some of the Office products.
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus
You must clean the first empty rows for this.
For example; you write 50-100 rows than you change your mind for product filters and you want to clear the cells.
Export / Import gives an error when you try to import. Because it is thinking that empty cells must have a value.
Solution --> You must to DELETE all rows if you write and cleared cells under first empty row.
I hope you will understand what I mean. I found this solution after trying everything for a 50 min and it works like a charm for me.
Just try, you will see how its work.
Users browsing this forum: No registered users and 7 guests