Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Uploading 1000 products - how?


dynamok

Recommended Posts

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

Link to comment
Share on other sites

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.

 

import-fields.gif

 

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

Best Regards,

 

Salvatore Iozzia

 

Loaded Commerce - Oscommerce - All Loaded Up.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 1 year later...
  • 1 year later...

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

A signature is something that reflects its user. - The dictionary

 

The question is not, 'to code, or not to code'

the question is, 'if we do not code, are we really alive?'

-- anonymous

Link to comment
Share on other sites

  • 1 year later...

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.

Link to comment
Share on other sites

  • 1 month later...

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

Link to comment
Share on other sites

  • 2 weeks later...
  • 3 weeks later...
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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 1 month later...

 

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

Link to comment
Share on other sites

  • 3 months later...
  • 3 weeks later...

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>";

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 2 weeks later...
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

Link to comment
Share on other sites

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? ;)

Link to comment
Share on other sites

  • 1 month later...

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.

My Site!

Link to comment
Share on other sites

  • 5 months later...

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!!

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

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.

Steve

I appreciate all the help that everyone on this site has given me!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...