Post by balzdeep » Sat Dec 17, 2011 8:35 am

I have OpenCart v1.4.9.3 with Import/Export module opencart-1-4-9-x-27-export-import

I can export the manually entered catalog from OpenCart, make changes to items and import the spreadsheet again and that works OK.

When I add new products to the spreadsheet and import that, the tools says "Success: You have successfully imported your categories and products!", but it creates no new records in the products table in the database, in the catalog ui or on the website. I seen no opencart or import/export related warnings or errors in the logs.

If it matters, I am using Google Docs as a spreadsheet software and saving as "Excel". Note this is working fine when I edit existing records in an export and re-import it.

I have attached an .xls file with a record from the spreadsheet i am trying to upload. Can anyone tell me what if anything is wrong with it?

thanks.

Attachments

sample row from the spreadsheet i am trying to upload.


Newbie

Posts

Joined
Sat Dec 17, 2011 7:42 am

Post by balzdeep » Tue Dec 20, 2011 5:14 am

Am I in the right forum? If anyone can tell me where I'd be likely to get help for this please let me know. Thanks.

Newbie

Posts

Joined
Sat Dec 17, 2011 7:42 am

Post by theemstra » Fri Jan 27, 2012 5:33 am

Hello,

I have that exact same problem, guess you're in the right forum.
I'm converting an old store inventory to opencart, hoping I can get it to work.

Does anybody know how to solve this?

Thanks,
Thom

By the way: I use the newest version of opencart (1.5.1.3)
Last edited by theemstra on Sun Jan 11, 2015 6:23 am, edited 1 time in total.

Newbie

Posts

Joined
Fri Jan 27, 2012 5:31 am

Post by rockmoth » Wed Feb 29, 2012 10:49 pm

Hi all,

I am also having exactly the same problem.

the file exports ok and then i add new products to the spreadsheet.

When i import it confirms it imported ok, however no new products are displayed.

Am i correct in thinking that you shouldnt create a product_id? as this maybe generated automatically?

Thanks

Rob

Newbie

Posts

Joined
Wed Feb 29, 2012 10:47 pm

Post by theemstra » Thu Mar 01, 2012 3:06 am

I got the problem fixed, it DID was successful, but was imported in the wrong language, make sure you check it out!

Newbie

Posts

Joined
Fri Jan 27, 2012 5:31 am
Who is online

Users browsing this forum: No registered users and 2 guests