Post by deltaguns » Wed May 15, 2013 9:59 am

Is there a feature or plugin on opencart in which I can import my inventory? I have over 120,000 products that need to be imported onto my opencart site. Doing them one by one is not practical.

I have my entire inventory in ASCII delimited text file created by MS Excel ready to be uploaded.

New member

Posts

Joined
Wed Apr 24, 2013 7:03 pm

Post by merry » Wed May 15, 2013 11:16 pm

Yes, of course, Deltaguns.

There are several Import/Export tool extensions available but I always recommend those done by VQmod:

http://www.opencart.com/index.php?route ... ort%20tool

This is a $15 add-on, just a token IMHO for VQmod's hard work and keeping it updated. However there are also free tools as well as some costing $80.

Merry

Most answers are from my OpenCart 1.5 User Manual CURRENT TO 1.5.5.1 and includes free updates.
FREE HELP! 60-page user guide with OpenCart Admin Menu Cheatsheet, Install Guide & 30 Minute QuickStart Guide: http://showmeguides.com/


User avatar
Active Member

Posts

Joined
Thu Dec 09, 2010 12:51 am
Location - Mexico and sometimes Texas

Post by merry » Wed May 15, 2013 11:19 pm

Deltaguns, also - any import tool generally needs you to EXPORT THE DATABASE STRUCTURE from OpenCart, use that for the filename, fieldnames, fieldtypes and the field order.

Since you already have a spreadsheet you will need to do the export, then copy and paste the columns in the order of the Export file, being careful to not change fieldnames or types. ALWAYS BACKUP FIRST!! :) :) :)

mERRY

Most answers are from my OpenCart 1.5 User Manual CURRENT TO 1.5.5.1 and includes free updates.
FREE HELP! 60-page user guide with OpenCart Admin Menu Cheatsheet, Install Guide & 30 Minute QuickStart Guide: http://showmeguides.com/


User avatar
Active Member

Posts

Joined
Thu Dec 09, 2010 12:51 am
Location - Mexico and sometimes Texas

Post by bbaccessories » Sat Jul 06, 2013 3:07 pm

Hi there Merry, we have a similar query (all our inventory is on csv). We are trying to follow the link to the tool you gave on May 15, but the link is broken. Would you kindly re-add or give the full name of the tool so we can search for it?

Thanks!

Newbie

Posts

Joined
Fri Dec 02, 2011 4:56 pm
Who is online

Users browsing this forum: No registered users and 10 guests