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

Hello!

 

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
  • 10562 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
  • 17267 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

cscart_ult_product_descriptions

cscart_ult_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    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.