Post by Danijel82 » Mon Oct 12, 2015 1:30 am

Hi, I installed the export/import extension, and exported my products to a xlsx file and added more products to that file. When I try to import the file back, I get this message : Export/Import: Missing product_ids in worksheet 'Products'!
Can someone help? What I am doing wrong?

I am using opencart 2.0.3.1
extension url : http://www.opencart.com/index.php?route ... load_id=37

Here is a picture of my xlsx file. Product Id's are in the first coloumn and they are formated as a text.
Any help would be appriciated!!

Attachments

op.jpg

op.jpg (86.82 KiB) Viewed 1532 times


Newbie

Posts

Joined
Thu Feb 23, 2012 4:37 pm

Post by IP_CAM » Tue Oct 13, 2015 7:55 am

You are only able to IMPORT 'DB-Predefined' DATA, if something DOES NOT HAVE
it's reserved 'Table/Section' defined, in a DB, it cannot be placed. Like, if you have no
ROOM Reservation, in the Hotel, as planned, then, you possibly have no place to stay... :o
Ernie
bigmax.ch/shop/

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by SubatWest » Tue Nov 03, 2015 4:28 am

Hi

I am using (V2.27) import/export on OC Version 2.1.0.1 under win 10.
Have a question as to how it imports manufacturers. I have a large list of manufacturers but when I import products with manufacturers name included. It ignores the names already in the database and adds a duplicate of the name.

I have tried the first option 'Yes (Update and/or add da'ta)'
and the second option 'No (Delete all old data before Import)'

Both do the same thing.
Have used excel 2010 and open office but to no avail. The issue is the same.

I have checked the name in the product upload is the same as the name in the manufacturer's database.

Can you shed any light on the issue?

Many thanks

Subatwest

Active Member

Posts

Joined
Fri Oct 31, 2014 1:29 am
Who is online

Users browsing this forum: No registered users and 10 guests