Post by Lobart78 » 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 :D

Newbie

Posts

Joined
Tue Jan 03, 2012 11:33 pm

Post by justinv » Thu Mar 22, 2012 10:29 am

The CSV or Total Import PRO modules can handle this situation nicely.

Documentation: OpenCart User Guide
Mods: Total Import PRO | CSV Import PRO | Ecom Tracking | Any Feed | Autosuggest | OpenCart CDN
Image


Active Member

Posts

Joined
Tue Oct 12, 2010 1:24 pm

Post by lexxos » Wed Mar 28, 2012 9:53 pm

CSV Import Pro works like a charm !

i just imported a huge 7+ meg file

result : Success: Added 12262 products, Updated 0 products, Skipped 0 products, Missed 0 products.


Worth the money ! :)

Newbie

Posts

Joined
Wed Mar 28, 2012 9:11 pm

Post by sergiy90 » Mon Aug 20, 2012 9:39 pm

Try to use File2Cart.. Maybe it will come in handy....

Newbie

Posts

Joined
Mon Aug 20, 2012 9:33 pm
Who is online

Users browsing this forum: No registered users and 3 guests