1

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

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

1
  • have you need shopping cart rules tables?
    – Abdul
    Dec 22 '15 at 11:07
4

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

6
  • i inserted the new role in cart: if sku is product-test and qty is 10000 --> price euro 20. I watched the table catalog_product_entity_tier_price, catalog_product_index_tier_price, catalog_product_entity_tier_price but it's is empty Dec 17 '15 at 8:19
  • @AlessandroGnola, this is probably a Shopping Cart Price Rule you have set, right? These are in the salesrule* tables. This is not tierpricing...
    – 7ochem
    Dec 22 '15 at 10:58
  • 1
    @7ochem gotta love pricing in Magento ;) would be nice to have a diagram of pricing structure, ever came across something like that?
    – Sander Mangel
    Dec 22 '15 at 11:03
  • @AnnaVölkl's database diagram is a start ;) But seriously, yeah, there should be some flow charts of the more complex processes added to the docs.
    – 7ochem
    Dec 22 '15 at 11:09
  • @7ochem right?! maybe something we could do at a hackathon for M2
    – Sander Mangel
    Dec 22 '15 at 11:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.