Fully Customized Product Database

[thenomad]

*Noob question* I have a database with five tables of about 100,000 products and images (thumbs and full-sized) of the products. Is it possible to use oscommerce and completely customize it to use the data I already have and is it worth it time/cost wise to do so?

 

Thanks a lot for the help.

 

Next question: is there anyone out there who would be interested in working on such a project?

[dave111]

You should do it by using easy populate, which allows you to upload/download excel files of products and categories.

 

Did recommend you install easy populate (only takes like 2minutes) and see how difficult it would be to put your data into the easy populate excel sheet.

 

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

[MPeace]

Easy populate is one way of doing it, but I wouldn't have said that it would be very easy for 100,000 products.

 

Most servers are setup to allow PHP code to run for 30-60 seconds which would allow you to upload approx 300 or so entries in my experience. I have over 30,000 products in my database and what I did to get around the problem is write a simple C++ programe that converted the csv file data into a new file or files of SQL statements, upload it to the server and then use SSH to run the sql script directly from the shell.

 

It was the first C++ program that I wrote and anyone who can understand the logic needed to create dynamic HTML pages can write a simple C++ program to edit and create text files. I used Bloodshed Dev-C++ to write my files its freeware.

[wizardsandwars]

You can do the same thing in php if you telnet or ssh in and run the scripts directly rather than running them through the browser.

[♥Monika in Germany]

what database are your product in right now? I'm an expert with getting stuff out of one database into another, while dividing data into the appropriate tables.