Need Database specialist

[bidawinner]

For "how" to incorporate 70,000 images and text flatfiles that contain the description etc of the images into /onto the website and also how to feed that into a shopping cart ?


I need a basic run down on how it's done here in the thread and anyone who is interested in ACTUALLY doing it..PM me a quote..

For Posters.Biz

 

[ilikebeer]

Forgive me if I oversimplify ...

Create a DB (SQL, Access, MySQL) and as long as you have your product list in a Excel spreadsheet or tab/comma delimited file, you can populate your DB really easily. For images, you could either add a field in your DB that references the image name (ie imagename.gif) OR you can name your images according to a unique identifier for the record (ie Product SKU, identity seed from DB).

As far as an actual 'cart' application ... www.asp101.com (ASP/Vbscript) has a really easy to configure one in their 'samples' section.

If I didn't make sense (most likely) .. shoot me a PM

 

[ilikebeer]

oh ... sorry, didn't read all your message - don't have time to do it for you (busy with other projects)

 

[bidawinner]

Originally posted by ilikebeer
Forgive me if I oversimplify ...

Create a DB (SQL, Access, MySQL) and as long as you have your product list in a Excel spreadsheet or tab/comma delimited file, you can populate your DB really easily. For images, you could either add a field in your DB that references the image name (ie imagename.gif) OR you can name your images according to a unique identifier for the record (ie Product SKU, identity seed from DB).

As far as an actual 'cart' application ... www.asp101.com (ASP/Vbscript) has a really easy to configure one in their 'samples' section.

If I didn't make sense (most likely) .. shoot me a PM

Ilikebeer,

The cd of images and text files comes with an "example" of how to import into MS access..
From my limited knowldege of databases I was under the impression that Access would be the slowest "retriver" of the 3...and probably not suitable for 70,000 images?

Whats your opinion of that ?

I have a reseller hosting account and in Cpanel cant I just create a MySQL databse..would that be easier?

I am also using 2checkout.com for processing?

I'm going to confuse you here because I am a bit confused

Isnt this shopping cart all I need ..
http://www.2checkout.com/demobuy.htm

isnt a shopping cart just a database correct ?
or do I need a seperate database for the cart to retrieve the images and text?

Cant I take my image and text cd and export it all to a shopping cart..I would still have to go back and add prices and taxes..but isnt that all I need to do ?

Thanks..

 

[mortario]

Bidwinner,
If you use 2checkout.com, you can use their free shopping cart. Since you have a lot of products, you need to send your images in a file to their customer support. It'll take 2-3 days for them to upload your products. Here's the file format requirement:
https://sellers.2checkout.com/uploadproducts.txt

You can login to your 2checkout account - click on "Products" then click on "Add products" for more info on Bulk Uploads.

If you use your own shopping cart, I think Cpanel has one from red hat.. depending on your host co, then you will need to upload your images to your local db. Don't forget to incorporate 2checkout in your shopping cart. Detail info can be found in your 2checout account under "shopping cart". Also, put your account under "Test" first before doing any testing.

Hope that's help.
Aldo

 

[name5]

If your database is stored on an access file and you want to convert it to your server based mysql database, first export it to excel and then use a piece of software called TWANG readily available and very cheap which converts the excel data into mysql statements which you can execute straight onto your sql database on your server.