Uploading 1000 products - how?

[dynamok]

I'm confused as to how do I upload that many products. I know there are some contributions for this, the one I looked at was "osc-import"

This is what I'm suppose to do:

 

The CSV file should look like this:

"12";"1555";"10000";;"101.00";"2002-04-22 17:17:01";NULL;NULL;"1.00";"1";"1";"1";"1"

"22";"2555";"20000";;"102.00";"2002-04-22 17:17:02";NULL;NULL;"2.00";"2";"2";"2";"2"

"32";"3555";"30000";;"103.00";"2002-04-22 17:17:03";NULL;NULL;"3.00";"3";"3";"3";"3"

 

 

Each value should be enclosed in a unique character (e.g. single or double quote: ' or ")

Fields must be separated by a unique character (e.g. comma or semicolon)

Lines must be terminated with an enter or newline character.

Fields with no value must stay empty: eg ..."01";;"text";"anothertext";;"1"... or they can be represented by NULL

Please notice: 0 (zero) is not an empty value!

 

When importing products, following fields are possible:

"products_id?

"products_quantity"

"products_model"

"products_image"

"products_price"

"products_date_added"

"products_last_modified"

"products_date_available"

"products_weight"

"products_status"

"products_tax_class_id"

"manufacturers_id"

"products_ordered"

 

My question is how do I assign categories to the product? I have 5 categories and supcategories go 2 deep, so say if I upload the CSV where do the products go, to what category?

Also, if I have a Excel file with the product list in it, how do I make a CSV file out of it with all this junk:

eg ..."01";;"text";"anothertext";;"1"...

 

I really need help on this.

Thank you

[♥Loaded Commerce]

You will need to create data files for the catagories and the other products table products description.

 

Here is a little graphic i made that shows the basic relationship between the nessacary tables.

 

NOTE: this is based on the loaded snapshot with triple images, your products table may not have as many image fields.

 

 

http://osc.chainreactionweb.com/import-fields.gif

[dynamok]

I have a programer that is working on a new contribution for importing the products. It will automatically put the products into categories and subcategories.

I'll post it as soon as he's done.

[rebayona]

Geez, it is taking long, isn't it? ;)

[tkeats]

Yup, seems like it...

I tried the osc-import and nothing seems to be showing in either the user area OR the admin product area...

 

Thomas

[Maggilove]

dynamok's contribution.... http://www.oscommerce.com/community/contributions,485

[selmaboyd]

dynamok's contribution.... http://www.oscommerce.com/community/contributions,485

 

 

I agree Maggi, DYnamok's contributin is an excellent one. It worked for me where everything else failed... :-"

[mjsmikey]

I used the Excel-Populate one... Since I have all my products on a spread sheet all i had to do was order them in the order it asked then save as a Text file... then use my admin/excel.php program to add them in.

[tunersedge]

I've been trying to solve a similar issue with our new site. We have a large number of products we're trying to load up, and it's all in Excel right now. Also, I don't like the idea of trying to manage this list, and add to it, from the admin module. My solution is in development right now. I plan on using Excel, Access and VBA to do it. I know, I know, very MS, but it's an easy, scalable solution. I've recreated the product/category/mfg tables from OSC in Access. I'm using Excel as a front end to pull in the lists and write the changes. I then basically keep a live version of the product/cat/mfg list in my Access database. From there, I can just use ODBC to update my live OSC tables on the web server.

 

It's all very MS-centric, and it's all very local to my PC. But, writing a few lines of VBA is way easier for me than making my own php-mysql tool. Plus, Excel really is a great thing. I'm still working on it, and I'll post my outcome once I finish.

 

Aaron

[StormIT]

This is a great a contribution, is there anyway that it can be set to "overwrite current data" though?

[Guest]

This is a great a contribution, is there anyway that it can be set to "overwrite current data" though?

 

 

I try this contribution today and it looks like as a good one.

But the Overwrite issue is valid... is there any way we can have the option like "Overwrite/Newdata"

so if you want to re-install your whole itens, just "NewData" would delete the whole table and install only what you have on the Excel.

if you want to add products, the Overwrite will add news ones as well overwrite the old ones that you may have on the excel file.

 

Any hope?

[clane]

I used the Excel-Populate one... Since I have all my products on a spread sheet all i had to do was order them in the order it asked then save as a Text file... then use my admin/excel.php program to add them in.

 

Easy Populate may be the answer you are looking for. I haven't tried it with hundreds or thousands of products. I am still testing it out with a small handful until I am sure that I haven't messed anything up. Here is the link: http://www.oscommerce.com/community/contri...h,easy+populate or search for "Easy Populate" in Community Contributions section of this web site.

[jdice]

dynamok's contribution.... http://www.oscommerce.com/community/contributions,485

 

Hi...not sure if you can help....but I get these errors after I upload this contribution:

 

Warning: include(easypopulate_functions.php) [function.include]: failed to open stream: No such file or directory in /home/electron/public_html/catalog/admin/excel.php on line 5

 

Warning: include(easypopulate_functions.php) [function.include]: failed to open stream: No such file or directory in /home/electron/public_html/catalog/admin/excel.php on line 5

 

Warning: include() [function.include]: Failed opening 'easypopulate_functions.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/electron/public_html/catalog/admin/excel.php on line 5

 

AND I also get this one:

 

Fatal error: Call to undefined function tep_get_uploaded_file() in /home/electron/public_html/catalog/admin/excel.php on line 489

 

Here is my line 489-492 in my excel.php file:

 

$file = tep_get_uploaded_file('usrfl');
if (is_uploaded_file($file['tmp_name'])){
echo "<p class=smallText>";
echo "File uploaded (temp filename: " . $file['tmp_name']. ")<br>";

 

 

Any help would be great...I used this same contribution on another site of mine...it worked great...but now I am getting errors uploading it to this site. I am doing everything the same...I think. I am at a loss for what I have done different....unless I damaged the original file around line 489 somehow and accidentially changed the code. Also...as for the first error....I am not sure I even have a easypopulate function. I didn't download a contribution for a easypopulate function...so this confuses me. I didn't download an easypopulate function on the other site I built and this contribution worked fine...I think...it has been so long between building both sites...I can't remember what all I did.

 

Janet

[rx7world]

I have the same problem did you figure this one out? Thanks Ernst

[drm03271963b]

I guess no one has as of yet

I am also getting the following error

 

Fatal error: Call to undefined function: tep_get_uploaded_file() in /home/content/d/r/m/drm03271963b/html/admin/excel.php on line 489

 

489 $file = tep_get_uploaded_file('usrfl');

490 if (is_uploaded_file($file['tmp_name'])){

491 echo "<p class=smallText>";

492 echo "File uploaded (temp filename: " . $file['tmp_name']. ")<br>";

[socal_kl]

has anyone thought of trying easy populate ..

[Guest]

I totally have the same problem... THis looks like a GREAT thing... I have over 10,000 to upload... and yep... I have been uploading ONE, BY ONE, BY ONE... OMG... the pain... So I am going to try to down load the addons that you guys have listed here and see if that can get me any where...

 

Thx...

 

Cupids House of Toys

www.cupidshouseoftoys.com

Monty Miller

[tjeonline]

has anyone thought of trying easy populate ..

 

I upload over 10,000 products using Easy Populate. When I first installed it, I admit that I was having minor issues. For the most part, as long as you follow every single step, and make the updated changes, you should be fine. However, when you first upload your product list, you need to split it up into smaller files. 5 files should be enough. Updating your products is easy, and can be done all at once.

 

Good Luck. :o

[Netcaster]

Easy Populate may be the answer you are looking for. I haven't tried it with hundreds or thousands of products. I am still testing it out with a small handful until I am sure that I haven't messed anything up. Here is the link: http://www.oscommerce.com/community/contri...h,easy+populate or search for "Easy Populate" in Community Contributions section of this web site.

 

That's nice but is there any chance of getting it in English? ;)

[Inferno32]

If you have all of your products you need listed on a website, how would you download them all, have all the descriptions included, as well as pictures?

 

I also have thousands of items to upload, and so far have been doing them one by one.

[chimol]

subscribing, I'm in the same boat.

[♥geoffreywalton]

What boat is that?

 

Uploading 000's of products is very easy using Easy Populate.

 

You do need to follow all the installation steps and read the documentation as it does so much!!

[chimol]

What boat is that?

 

Uploading 000's of products is very easy using Easy Populate.

 

You do need to follow all the installation steps and read the documentation as it does so much!!

 

Well, I have easypopulate and can upload, but as you know it doesn't do pictures. I was wondering how everyone that uses easypopulate to load 1,000's of products, puts the pictures in.