Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Adding Products Directly By Editing Database Rate Topic   - - - - -

  • Tice
  • Newbie
  • Members
  • Join Date: 10-Dec 17
  • 14 posts

Posted 10 December 2017 - 09:48 AM #1



I'm developing an web application that adds products to CS cart via PHP-issued SQL statements. I'm adding records to cscart_products, cscart_products_categories and cscart_product_descriptions. What other tables to I need to modify / input data into?


Currently the products aren't seen in the cscart control panel.



  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11598 posts

Posted 10 December 2017 - 10:52 PM #2

Why don't you just use the API so you can keep up with it?  There are many other tables related to inventory, options, prices, etc.  These are in constant flux so using the API will give you some insulation from those changes and also allow you to apply more of the business logic (Ie. Settings) to the data.

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.

  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20682 posts

Posted 11 December 2017 - 07:15 AM #3

I vote for API. But if you still want to use your own logic, pay attention to the following tables


- cscart_product_prices



GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)