Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

SQL Insert for New Products?


Recommended Posts

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,



Link to comment
Share on other sites

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.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile


Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.


For links mentioned in old answers that are no longer here follow this link Useful Threads.


If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites


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

  • Create New...