dashCommerce

Hello all,

I was wondering if it's possible to insert product information into the database without using the admin site enter product page?

 The reason I ask is that I have a client that have wants an store online and he has over three thousand items in his list. It would take a year to enter and maintain all those items one by one. I want to do a batch insert into the products tables all the products in his list. The thing is I don't know if this is possible and if it is which tables do I use to insert the information.

sure it is, it's just data.   I did the same thing as I have an existing site too with 10,000 items in it.   I created a C# win app that referenced subsonic and I set up my app.config to work with subsonic and pointed to my new and old databases.  Then I read in a record from my old database, created a new Product record, and inserted.  You'll discover that you also need to insert data into the foreign key tables (manufacturer, category, sku, image, etc).

If you add your tables to a new sql database diagram (right inside SSMS), it will graphically show you the table relationships.   It helped me to see how all the tables related to each other.

Good luck,

Scott