Forums / General Questions / Is there a faster way to load 100.000+ products ?

Is there a faster way to load 100.000+ products ?

Locked

Started by artistic on 5 Aug 2009, 8:03 PM · Views: 1,592

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
5 Aug 2009, 8:03 PM
#1
artistic avatar

artistic

New Zenner

Join Date:
Jul 2009
Posts:
41
Plugin Contributions:
0

Is there a faster way to load 100.000+ products ?

Hi again guys let me know if is another way to add more then 100.000 products to the site in this moment i have added 1000 manualy
i have the lists of products in excel format.Let me know if is another way to add the products on the site

5 Aug 2009, 8:06 PM
#2
afo avatar

afo

Totally Zenned

Join Date:
Aug 2004
Location:
New York City
Posts:
6,800
Plugin Contributions:
0

Re: Is there a faster way to load 100.000+ products ?

This might help http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=1240

Search around on the forum for more info on Easy Populate. I haven't used it myself, so I'm not familiar with it.

Mary Ellen
I came; I saw; I Zenned
Taking over the world... one website at a time
Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

Holzheimer
Fan Odyssey

5 Aug 2009, 8:34 PM
#3
artistic avatar

artistic

New Zenner

Join Date:
Jul 2009
Posts:
41
Plugin Contributions:
0

Re: Is there a faster way to load 100.000+ products ?

My problem is how to add the product list more easyer than i do right now , manually.I know that is a script like xml that support to add the liste and when the manufactur change the price the price to our shom will automaticaly change.
The question is:

Can we have another way to add products not manually with product name description qty price picture etc ?

We got more then 10 excel files with 10.000 products.
The only way that i found is to conect 10 users to add 100 products per day wich mean 1000 products per day and we need 100 days to add 100.000 products :-) gosh

i have upload the files to my server but i do not understand how to create or wich csv to import can somebody tech me how can i add more products with this easy populate an picture example or something like this a link to can view what this option really do.
please
thanks

6 Aug 2009, 11:28 AM
#4
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: Is there a faster way to load 100.000+ products ?

afo mentioned Easy Populate in post #2. That's probably your best bet.

7 Aug 2009, 7:18 AM
#5
artistic avatar

artistic

New Zenner

Join Date:
Jul 2009
Posts:
41
Plugin Contributions:
0

Re: Is there a faster way to load 100.000+ products ?

Our company make commerce with electronics and IT&C
So this mean is more then 100000+ but we need to put just 100.000 in 25 categories and 200 subcategories.
I mean we do not add the products in one category of course we select the products type ,model , manufacturer wich criteria is included etc.

So i repet my question:

Does we have another way to add products not manyaly like we do right now?

I have 10 refrigereder i want to add them instantly without picture i can add picture manualy no problem i need the sort way to add detalies price stock and thats it.On the next category i will do the same. I hope u understand now what im talking about
Best wishes everyone :lamo:

7 Aug 2009, 8:32 AM
#6
ooba_scott avatar

ooba_scott

Zen Follower

Join Date:
Jul 2009
Posts:
218
Plugin Contributions:
0

Re: Is there a faster way to load 100.000+ products ?

As previous posts have said , Easy populate is your way forward.

Fantastic mod which i have used myself on afew shop sites now. I have used it to add in over 1000 prodcuts at once. And it works a treat.

You may need to break your files down into slightly smaller chunks as you do have a vast amount of proudcts to upload.

7 Aug 2009, 4:09 PM
#7
jdw1979 avatar

jdw1979

Zen Follower

Join Date:
Jun 2009
Location:
NC
Posts:
174
Plugin Contributions:
0

Re: Is there a faster way to load 100.000+ products ?

Easy Populate is the only way I know of to make this happen.

I have 50,000ish products and 245 categories and sub-categories. What you're trying to do is completely doable. The categorization process will get tedious, but it beats the crap out of adding products manually. You'd need a team of people working 40 hrs a week for months to get that done.

You will need these two things.

http://www.zen-cart.com/wiki/index.php/Easy_Populate

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=1240

In order to get a .csv template file, export the products you have already added via the Easy Populate area in Admin-->Tools-->Easy Populate.

As mentioned before, easy populate is the only way you're going to get this done. Best of luck to you.

Oh yeah, and as Ooba_Scott mentioned, you will need to break the items up into, at the most, 500-1000 product .csv's. This can be managed quite easily with a .csv splitter, which are available for free on lots of different sites. Just type in .csv splitter in your search engine, you'll find one.

Dale

Johnathan D. Walker
Wilburn Medical USA