Post by nemogirl » Wed Jun 24, 2015 2:07 am

Using OC 2.0.1.1 with Import/Export Tool v.2.26

Theme: Pavilion/Shoppica by Themeburn

I have Vqmod installed - apparently I didn't need this anyway, could this be a problem?

What I did:
1 Exported demo theme products.
2 Opened in MS Excel Starter.
3 Changed a price on one product.
4 Saved.
5 Tried to import back to OC - Failed.
6 Go to error log:
2015-06-23 18:56:57 - Export/Import: Missing product_ids in worksheet 'Products'!
7 Checked through the products spreadsheet, cannot find any error. ???
8 Go to Import/Export tool settings, cannot find anything that would cause this. ???

Any idea what's going on here? Help appreciated! ;)

Ninax

Newbie

Posts

Joined
Wed Jun 24, 2015 1:45 am

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

I was getting the same message as you were.
Check my posting in Export/Import tool.
I saved the XLSX file as a CSV file. Reloaded the CSV file then saved it over the original XLSX file.
It removed some extraneous formatting. Maybe this could help.

The bad news is that it isn't showing up in opencart, even though it said the upload was successful.

Newbie

Posts

Joined
Thu Jun 18, 2015 8:17 am

Post by GF2 » Thu Sep 10, 2015 12:56 am

I am having the same problem.

Saving it as a CSV got it to say it uploaded successfully but now the products don't appear in the admin or in the front end of the store.

Did you ever find a solution to fix this?

GF2
Newbie

Posts

Joined
Tue Mar 10, 2015 2:50 am
Who is online

Users browsing this forum: No registered users and 6 guests