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
  • 3 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
  • 10,140 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
  • 16,123 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

Certified CS-Cart RU Developer | Сертифицированный разработчик на CS-Cart Русская Версия

 

Posted 22 December 2017 - 02:21 AM #4

Hello,

 

I have tried to use the API and tested all GET, POST, PUT, and DELETE. however, I can't find answer for one question on DOCs or on forums.

 

I am trying to build categories with level. for example, when POST, it's ok, gives ID for the category when parent_id is 0. but how to GET category_id while giving category name?

 

for example;

 

/api/categories?limit=1&category=Folders

 

what I am trying to do is, I want to GET the category_id for the Folders category. Folders category is under Home/Office/Folders, Binders & Indexes / Folders

 

for example, I want to POST category under the Folders category. If I could GET category_id, then I could POST under it, isn't?

 

Did I miss anything?