Product Tables

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

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.

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)?

Please take a look

http://docs.cs-cart.com/4.4.x/user_guide/shipping_and_taxes/shipping_methods/index.html

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.

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

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"

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??

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.

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)