How to import csv with many products that is too big?
Posted: Tue Jan 03, 2012 11:53 pm
Hi, 
I've been trying to import a .csv file with 28 000 products.
Because I have like 5-line description in average to each product I'm not able to import them at once since the file has too many rows or size or w/e.
I know solution may be by splitting the .csv file.
I did to 8 parts, but everytime I upload next file, products from previous are deleted.
Next solution could look silly.
I've created 28000 txt files, each with description to one product using Excel VBA.
I have now 1.txt, 2.txt ... etc but I don't know how to point at them in "product_description.description" column.
When I enter data/1.txt to the column, on the product page there's just "data/1.txt" not the content of the file.
And the final solution I've been thinking about.
Just to copy the .csv file to the ftp server and somehow point to read product_description from it. That way I could bypass the max limit of the column count. Nevertheless, I don't know how to do this too.
Other files - product.csv, product_to_category.csv, product_to_store.csv are imported succesfully (they are quite small).
I'm using CSV RAW IMPORT 1.5.x
http://www.opencart.com/index.php?route ... on_id=4094
and OpenCart 1.5.1
If anybody could help me I would be very thankful
I've been trying to import a .csv file with 28 000 products.
Because I have like 5-line description in average to each product I'm not able to import them at once since the file has too many rows or size or w/e.
I know solution may be by splitting the .csv file.
I did to 8 parts, but everytime I upload next file, products from previous are deleted.
Next solution could look silly.
I've created 28000 txt files, each with description to one product using Excel VBA.
I have now 1.txt, 2.txt ... etc but I don't know how to point at them in "product_description.description" column.
When I enter data/1.txt to the column, on the product page there's just "data/1.txt" not the content of the file.
And the final solution I've been thinking about.
Just to copy the .csv file to the ftp server and somehow point to read product_description from it. That way I could bypass the max limit of the column count. Nevertheless, I don't know how to do this too.
Other files - product.csv, product_to_category.csv, product_to_store.csv are imported succesfully (they are quite small).
I'm using CSV RAW IMPORT 1.5.x
http://www.opencart.com/index.php?route ... on_id=4094
and OpenCart 1.5.1
If anybody could help me I would be very thankful