Print Page - import CSV file to the database

Title: import CSV file to the database
Post by: tounse on December 14, 2011, 17:30:22 PM

Hello

i want to create a shop on line with VirtueMart
i'ave 7000 products

can i easely import from a csv fiel all these products ?

thank you

Philippe

Title: Re: import CSV file to the database
Post by: sticcino1 on December 14, 2011, 21:29:02 PM

I did it the manual way
Imported 300 categories
48,000! Products

Using ms access As my bridge to MySQL from ms SQL
was a lot of work but it worked

Title: Re: import CSV file to the database
Post by: CranialBlaze on December 19, 2011, 15:28:36 PM

CSVImproved will be capable of doing this once VM2 has gone final and they are ready to make the required updates.
Only other way would be directly into the DTB via phpmyadmin or similar, you will just need to format your csv correctly in order to do it, you may need to break it up though, depending on your server config it may time out before 7000, CSVI used to recommend 1000 lines at a time

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: tounse on December 14, 2011, 17:30:22 PM