New Intro - help needed

[TruckTechniques]

Hello!

 

I have been surfing the forum for a while and am just starting up my first OSCommerce webpage.

 

I currrently run a self built retail webpage using the Paypal Shopping Cart code (yes, I know but it was free and I was very new).

 

I now have an OSCommerce store started through my ISP. I am using phpMyAdmin 2.6.4 pl4

The company I am buying my products from has sent me a databasae dump of their catalog. I am having issues uploading their content into my oscommerce site.

 

I am authenticating into phpMyAdmin using my admin account (DBA Access), I select the new database I just created, I select SQL and use 'Location of the text file' to upload the catalog the supplier sent me.

 

I get a successfully uploaded message but have no idea where to go from here.

 

Can someone please point this newbie in the right direction?

 

Untimately my catalog will end up here http://www.TruckTechniques.com/catalog

 

I have manually uploaded 8 items but I want to see the catalog supplied to me in this format. I am sure I am overlooking some things here.

 

Thanks in advance!!!

 

Joe

[Guest]

All of the field names will have to be in the right places (and numbers) and you'll have to load to the correct tables as well. products, products_descriptions, attributes etc. Try pulling a csv file of your existing product tables and compare them to the ones from them. cut, paste, rename the data from them and upload. There's also a Contribution called Easy Polulate that might make this easier for you. (Linked above in Community)

[TruckTechniques]

I am starting from scratch.

Should the tables be in the export file provided by my part supplier?

Will I need to manually create the table(s) to use?

[Guest]

The data provided by your supplier will have to be manipulated to match the corresponding tables in the db in order to work in osCommerce. The other option is to recode a zillion lines. I think you best route to start would be to install Easy Populate. It will allow you to upload a single csv file that will populate your db tables for you. So, install it, use it to download the products you have already loaded (view in your favorite spreadsheet tool like Excel) and cut and paste your manufacturers file to match. Then use the tool to upload the changed csv file from them.

[TruckTechniques]

I'm back :D

 

I found there is a tool I can use, Easy Populate -

http://www.oscommerce.com/forums/index.php?showtopic=204098

 

It appears I can download this here:

http://www.oscommerce.com/community/contributions,500

 

When I click the download link for version 2.81b, all I get is a zip file with one .php file, is this correct?

 

I assume I need to incoroprate this php file with my version of OSCommerce I am using through my ISP?

 

I am new at this. Can someone point me in the right direction to use this tool to help my import my product database?

 

Thanks!