Magento – Database table for price/quantity (tier prices)

databaseproductquantitytierprice

Where is the table in tho database that manages the role product/quantity?

I need to synchronize this to another table in another database.

Best Answer

The tier prices are stored in the catalog_product_entity_tier_price table. There is also an index table of the tier prices (catalog_product_index_tier_price) which contains aggregated data from the former table combined with catalog price rules if I remember correctly.

But you probably want to use the catalog_product_entity_tier_price

Related Topic