Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Upload entire catalog in one shot


SteveoSupremo

Recommended Posts

ok this might have been asked and answered like a million times and if so I must not be searching for the right phrase or something like that.

 

anyway I am looking for a way that I can more or less upload some sort of file to my store so that I don?t have to enter each and every single item manually.

 

I have a lot of items and they change monthly.

 

I get the product list to me in an excel spreadsheet with prices and variations (color and size) and it would be easer for me to enter all the items by uploading that file or converting it some how.

 

Just something that I don?t have to wait for the site to update every time I make a small change.

 

Any ideas please let me know!

 

Thanks

S

Link to comment
Share on other sites

ok this might have been asked and answered like a million times and if so I must not be searching for the right phrase or something like that.

 

anyway I am looking for a way that I can more or less upload some sort of file to my store so that I don?t have to enter each and every single item manually.

 

I have a lot of items and they change monthly.

 

I get the product list to me in an excel spreadsheet with prices and variations (color and size) and it would be easer for me to enter all the items by uploading that file or converting it some how.

 

Just something that I don?t have to wait for the site to update every time I make a small change.

 

Any ideas please let me know!

 

Thanks

S

 

If you have items or products in your database first you need to backup your databases.

 

If you don't have items or products in your database if you are trying to upload your store I advise you to use FTP client like "SmartFTP, Leech".

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Link to comment
Share on other sites

If you have items or products in your database first you need to backup your databases.

 

If you don't have items or products in your database if you are trying to upload your store I advise you to use FTP client like "SmartFTP, Leech".

 

 

There are two contributions that do an excellent job of this, but they both need to be handled with care.

 

If you have products with attributes, the better of the two is the Easy Populate contribution. You will probably have to do some minor modifications in making sure the fields match your database. It was written to be used with some of the other contributions such as the header tag contributions.

 

However, once you have the fields you don't need removed and any you might need added. It works great.

 

The other is the Excel Import contribution. For straight import of item, price, product number, etc., this is slick and easy. One warning, if you are changing prices on items that already exist, you need to export all your data, drop the table and re-import into a clean empty table.

 

Both a great. Which one you use depends on your specific needs.

Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!!

 

Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience.

 

The quickest way to learn is to forget to BACKUP!

Link to comment
Share on other sites

Steve,

The easypopulate util will allow you to upload mass data...using a CVS

file that you can create using a spread sheet util...I would a one record

to the data base then download that record using the easypopulate...it

will give you a template to go by...

I hope this helps...

dittone.com

Roman

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...