Importing products from my distributors CSV file stock list... 87,000+ variations...

Hi there,

I Have got a question and hope someone can point my in the right direction.
(Im using the latest / clean install of zen cart)

Ive been asked to setup an online Tyre shop, where customers can purchase car, lorry, motorcycle tyres online.
My client has a pysical shop premises, and at the shops computers they work from a CSV file containing all the different variations / manufacturers / prices and current stock availability. (85,000+) products in total.

My question is how would I go about using that CSV database and importing it into zen-cart as products online?

Obviously adding 85,000 products manually into zen-cart is not an option, but as MySQL allows for CSV imports then im guessing it would be acheivable with a little modification.

Can someone point me in the right direction please?

You would either have to use one of the Easy Populate mods in he contribution section and re-arrange the file manually to fit the mods requirements, or do like I am doing now. I am soliciting for someone to write a custom import script that will use the data in the suppliers format.

Hey Stuff4Toys,

Thanks for the reply, I am aware of Easy Populate but wasnt sure if a 3rd party / distributors list would work.

So basicly without editing the CSV file to make it compatible with Easy Populate this isnt acheivable?

My client needs the CSV / Product list to be updated every 6 hours, so manually editing is out of the question.

I was kinda hoping hoping there was an option in Easy Populate to define which tables to use in the CSV for certain easy cart values like product name, price etc..

Any other suggestions?