SQL Insert for New Products?

[Guest]

Greetings, All!

 

I'm looking for a way to insert new products directly into the database using an SQL statement.

 

Long story short, I am interfacing with my vendors and need to be able to manually insert new products into the database directly without going through admin.

 

I can work out the SQL statement on my own easy enough, it's the products_id that concerns me. I don't know how to insert a unique number, or the order in which OsC inserts these values.

 

Any ideas, anyone?

 

Many thanks in advance,

 

Isaac

[♥geoffreywalton]

SQL will allocated the next sequential no.

 

You could create a csv file and then use a cron job to import/update using Easy Populate.