Jump to content

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

Product Tables Rate Topic   - - - - -

 
  • jeta
  • Senior Member
  • Trial users
  • Join Date: 01-Apr 16
  • 153 posts

Posted 01 February 2017 - 02:58 PM #1

Hello!

 

I am trying to undertsand better the logic of how the products added in my website are stored in my web database. In   cscart_products_categories   table is a link_type column that i am not very clear of what it does, it takes 2 values: M or A as i can see.

 

There are some columns that i can't understand in the cscart_products table. To be more specific the product_type, status and shipping_freight.

 

Can anyone help me, i am trying to import some products from one database to my web database.

 

 

Thanks in advance



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

Posted 01 February 2017 - 10:34 PM #2

M = 'main category'

A = 'alternate categores'

 

There should only be one 'M' category for each product.

 

The product_type column are for things like EDP (electronic products), etc.

 

Shipping_freight is a shipping surcharge applied to the shipping cost for that product.  I.e. there might be environmental packaging or some other unique shipping need for a particular product.


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.


 
  • jeta
  • Senior Member
  • Trial users
  • Join Date: 01-Apr 16
  • 153 posts

Posted 02 February 2017 - 09:38 AM #3

M = 'main category'

A = 'alternate categores'

 

There should only be one 'M' category for each product.

 

The product_type column are for things like EDP (electronic products), etc.

 

Shipping_freight is a shipping surcharge applied to the shipping cost for that product.  I.e. there might be environmental packaging or some other unique shipping need for a particular product.

Thank you for answering, but i am still trying to understand how the shipping cost works (how its calculated in cs-cart)?



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

Posted 02 February 2017 - 02:23 PM #4

Please take a look

 

http://docs.cs-cart....hods/index.html


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 руб.


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

Posted 02 February 2017 - 06:56 PM #5

Thank you for answering, but i am still trying to understand how the shipping cost works (how its calculated in cs-cart)?

Well, your original post didn't ask anything about shipping cost, you asked about category types and the shipping_freight value.  Both of which I answered.


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.


 
  • jeta
  • Senior Member
  • Trial users
  • Join Date: 01-Apr 16
  • 153 posts

Posted 20 February 2017 - 01:01 PM #6

Hello!

 

I am trying to understand where the discount prices are stored in database. I can see that thare are 2 tables: cs_cart_products that has a list_price column and cs_cart_product_prices that has a price column: according to tests in cs-cart when i add a new product it seems that the price stores the discount price and list_price stores the price before the discount, but if i try applying another discount where it's stored??

 

I will be very grateful if someone helps me.

thanks in advance



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

Posted 20 February 2017 - 02:13 PM #7

Hello!

 

I am trying to understand where the discount prices are stored in database. I can see that thare are 2 tables: cs_cart_products that has a list_price column and cs_cart_product_prices that has a price column: according to tests in cs-cart when i add a new product it seems that the price stores the discount price and list_price stores the price before the discount, but if i try applying another discount where it's stored??

 

I will be very grateful if someone helps me.

thanks in advance

 

If you mean quantity discount, you should use the cscart_product_prices table (check by lower limit and user group)

 

If you mean promotions, they are calculated "on the fly"


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 руб.


 
  • jeta
  • Senior Member
  • Trial users
  • Join Date: 01-Apr 16
  • 153 posts

Posted 20 February 2017 - 02:39 PM #8

If you mean quantity discount, you should use the cscart_product_prices table (check by lower limit and user group)

 

If you mean promotions, they are calculated "on the fly"

Yes i am talking about quantity discount, it means that the discount price it's stored under cscart_product_prices table right??



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

Posted 20 February 2017 - 09:39 PM #9

That is where all prices used in calculations for the cart are stored.  The list price is only used for one thing and that is the calculation of the list price discount used on the product details page and some of the list templates.  Otherwise it is not used in cs-cart.


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
  • 19775 posts

Posted 21 February 2017 - 05:36 AM #10

Yes i am talking about quantity discount, it means that the discount price it's stored under cscart_product_prices table right??

 

Right. Check values by product_id, lower limit and user group ( 0 for all users)


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 руб.