database table question

['Woger]

Hello,

I found out that some of my items have not all carriers listed. So I want to check all my products if this is true. Now I can check every product one by one, or I'll check the corresponding table in the database and check all products at once. But I can't find the right table. Does anyone know which table I have to check?

Second question: I was looking in the products table and saw a field called "quantity discount". Does anybody know where I can set a quantity discount?

 

Thanks again,

 

Roger

[bellini13]

I found out that some of my items have not all carriers listed. So I want to check all my products if this is true. Now I can check every product one by one, or I'll check the corresponding table in the database and check all products at once. But I can't find the right table. Does anyone know which table I have to check?

 

Have you looked at ps_product_carrier?

 

Second question: I was looking in the products table and saw a field called "quantity discount". Does anybody know where I can set a quantity discount?

 

I do not believe this field is used.  The field is defined as a boolean in the Product class and searching the code it is never used.  Creating actual product discounts can be done in the Prices tab of the product, or in the Catalog Rules

['Woger]

Have you looked at ps_product_carrier?

 

I do not believe this field is used.  The field is defined as a boolean in the Product class and searching the code it is never used.  Creating actual product discounts can be done in the Prices tab of the product, or in the Catalog Rules

Yes, nothing interesting in there ;-) just 2 fields.

I was using "Unit price" under products>price, but that isn't working anymore.

 

Thanks,

Roger

[bellini13]

ps_product_carrier would be empty, unless you have specific carrier rules for a given product.  So if you are having issues with a product, then you should probably look closer at this table.

 

i don't know what you are trying to point out with unit price

['Woger]

Ah ok,

So only when there are specific carrier rules for a product they are in this table. If not it is empty. That makes sense.

 

I was using "unit price" to give a discount when ordered 4 items. I did f.e. €16,49 per 4 and then it would recalculate it to €19,95. When customers ordered 4 of these it automatically recalculated the price to €19,95. However, since a few weeks (not sure after upgrading to 1.6.08) it stopped working. I now have to recalculate using Cart rules.