Import/Export Mod for 15,000 products?

I searched the forum first for answers but only found older posts.

I've got approximately 15,000 product to add to my store. So far, I've got about 6000+ products uploaded, and have another 9000+ or so to go. I'm having to upload category by category right now because of so many tweeks between the original spreadsheet from the supplier, to the OpenCart Import function. I upload them, see the changes that need to be made once they're uploaded to the store, and adjust accordingly.

I'm being told now not to keep adding to the store as it stands, and that I need the Import/Export Mod. That's fine, but I'm also being told that I need to upload the ENTIRE spreadsheet with the 15,000 products and after that I will have to make changes one product at a time.

That would mean either taking several months to edit the original sheet, or upload everything as it is now and then modify one product at a time?

Really? There has to be a way?

You are making life difficult for yourself

Create a table in mysql name data_tmp

create fields that match your csv header in table data_tmp

upload the csv to a mysql table

run mysql query
LOAD DATA LOCAL INFILE "C:\\myfiles\\file.csv" REPLACE INTO TABLE data_tmp FIELDS TERMINATED BY ',' IGNORE 1 LINES;

this will import the data

then run this query example change the values

update table set field = replace (field,'BLACK DRAGON','Black Dragon');
update table set field1 = replace (field1,'85','22');
update table set field2 = replace (field2,'9.99','8.46');

example
1st find BLACK DRAGON replace with Black Dragon
2nd find 85 replace with 22
3rd find 9.99 replace with 8.46

if its html you need to change you can still use the find & replace feature in mysql

change table to the table name
change field to the field name

once done export as csv then import with the import pro extension

http://www.opencart.com/index.php?route ... order=DESC

The 1st part creating all of the find & replace queries is all the hard work

Hope this helps

Slasher,

I now have a CSV Import/Export tool installed that I can't use. Apparently it's for an older version than mine, which is v. 1.5.1.3

Anyone know of a way around this?

I'd recommend you purchase the other module as it's going to save you so much time

http://www.opencart.com/index.php?route ... order=DESC

I haven't used any other import module so I couldn't comment but I use the above mod & it's almost perfect

Just make sure the csv doesn't include any commas use the find & replace mysql to get rid of them before exporting as a CSV

i.e.
update table set field = replace (field,',','');

Takes me about 25 secs minutes to import or update 3000 products once the csv is formatted correctly

Slasher,

I did end up buying the CSV Import Pro but we are having so many troubles trying to figure things out. Importing the entire spreadsheet is a breeze. But then no way to export ? We tried to export in xml using the default export/import tool, saying it in CSV and re-importing, but that doesn't work.

Do you know how to get around this? Is it possible to upload the sheet using ftp to cPanel? And exporting from there as well? We have 16,000 products. We really need to be able to export too.

Thanks