Post by LawrenceG » Wed Jul 01, 2015 1:05 pm

I get this coming up when I try to import an excel product list.
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.

Attachments


Newbie

Posts

Joined
Thu Jun 18, 2015 8:17 am

Post by LawrenceG » Fri Jul 03, 2015 6:44 am

OK - no replies. Well I've sorted that problem.
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.

Newbie

Posts

Joined
Thu Jun 18, 2015 8:17 am

Post by salairajesh » Mon Sep 21, 2015 3:10 pm

Hi friend, Just go to export in Export / Import in tools tab
:ponder:

In export
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

In Import
7. Now import. it works fine :good:

Tenet Varsity Lab, PDKT
The R&D Unit of Tenet Technetronics
Bangalore

http://www.tenetvarsitylab.com


User avatar
Newbie

Posts

Joined
Mon Sep 21, 2015 2:27 pm

Post by EvaP76 » Fri Jan 15, 2016 8:28 pm

I experience the same problem.Unfortunately the suggested solutions do not work for me.
I keep getting the 'Export/Import: Missing product_ids in worksheet 'Products'!' error

Newbie

Posts

Joined
Fri Jan 15, 2016 8:26 pm

Post by Zanato » Tue Jan 26, 2016 7:10 pm

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'

Newbie

Posts

Joined
Fri Oct 04, 2013 4:58 am

Post by wbd » Thu Jul 21, 2016 8:13 pm

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'
Had the same problem (using the Import/Export Tool for OC v2.2.0.0) and converting all cells to 'Text' in the spreadsheet prior to importing worked for me too - thanks Zanato. :good:

wbd
New member

Posts

Joined
Sat Mar 26, 2011 1:34 pm
Location - Australia

Post by JNeuhoff » Thu Jul 21, 2016 8:28 pm

This issue is often there because of using MS Excel instead of LibreOffice or OpenOffice Calc.

MHC Web Design
Override Engine * Integrated VQMod * Multilingual SEO * Instant Option Price Calculator * TrustPilot Reviews * Download Options * Free Download Buttons * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by wbd » Thu Jul 21, 2016 8:41 pm

JNeuhoff wrote:This issue is often there because of using MS Excel instead of LibreOffice or OpenOffice Calc.
Sure, I understand.
I haven't quite taken the final leap off the MS train wreck yet (still finalising my escape route :laugh: ), 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.

wbd
New member

Posts

Joined
Sat Mar 26, 2011 1:34 pm
Location - Australia

Post by JNeuhoff » Thu Jul 21, 2016 8:51 pm

wbd wrote: I haven't quite taken the final leap off the MS train wreck yet (still finalising my escape route :laugh: ), so I'm still using some of the Office products.
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.

MHC Web Design
Override Engine * Integrated VQMod * Multilingual SEO * Instant Option Price Calculator * TrustPilot Reviews * Download Options * Free Download Buttons * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by wbd » Thu Jul 21, 2016 8:57 pm

JNeuhoff wrote:There is nothing to prevent you from using LibreOffice or OpenOffice Calc right now, even on Windows.
True.
I think I'm just lazy... :-\

wbd
New member

Posts

Joined
Sat Mar 26, 2011 1:34 pm
Location - Australia

Post by farooqfsd » Wed Sep 13, 2017 9:55 pm

Save as OpenDocument Spreadsheet *.ods format and than import. It works.

Newbie

Posts

Joined
Mon Sep 11, 2017 7:57 pm
Who is online

Users browsing this forum: No registered users and 7 guests