Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Importing A Database?


3.5468416546876874564

Recommended Posts

Hi

I've just done this. I first created an Excel spreadsheet of my catalogue. Then I wrote SQL scripts for each of the records I wanted to insert into the MySQL database. I uploaded all of the images before running the scripts. Main problem is understanding the database structure so that you put the data in the correct place. Mine worked a treat - the first time I saw my catalogue was when it was all loaded - quite impressive. I've got 500 products each with a size variations so I couldn't have loaded the data any other way. There may be a better way to do it but since I've got database experience this was my prefererd route. If you haven't got database knowledge then you are a bit stuck

Hope this helps :D

Rob

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...