1 Comment

Get a list of products with Tiered or special pricing

Custom price tier module - save goes to infinite loop
how to resolve conflicts between layouts

Recently updated pricing for the year and have had a couple issues with customers making transactions with last years lower tiered pricing. Is there a way to quickly detect which products have tiered pricing? So we can review them.

An SQL query would work fine.

Related Posts

  • update products based on attribute value (2)
    I am writing a cron job to update products, I cannot use SKU as that is magento only. For every product in magento I have an attribute auto_cool_number I need to update it by that value (which is varchar). I found this script on magepsycho which is awesome, it works great and […]
  • SQL to update price and special price based on specific store (1)
    I have a Magento Enterprise 1.14.2.1 multi-site and what I want is lets say I have two store views setup store "store_US" and "store_AU" I want to run a php file that would get each sku, price and special price from the "store_US" and then multiple the price used in the store_us […]
  • Is there a way to get Tier Price List in our custom module template file (1)
    As we use in : /opt/lampp/htdocs/magento_composer/vendor/magento/module-catalog/view/base/templates/product/price/tier_prices.phtml How can i use getTierPriceList() in my custom module's template file ? also is it available in product collection ? I tried a lot but is unable to […]
  • Sorting issue while getting product from category ID using REST Api (1)
    I am reviewing Magento 2 REST API. I am trying to get all the products from its category ID using below API: GET /V1/categories/:categoryId/products Some how I am unable to get product details (Can't even get its name and price) and it simply return product SKU, ID and […]
  • Possible raw SQL statement detected (2)
    Magento 2. Custom module. I have to run some raw SQLs. It works and doesn't show any error. But when I'm trying to upload module to Magento 2 Market Place (developer.magento.com/extension) it shows in technical report a dozen of such errors: Possible raw SQL statement 'UPDATE `' […]
  • /rest/V1/products filtering by price and special price (1)
    I am using the Rest API to query for products. When I set the order by to "price" it orders everything properly while also taking into account currently active special prices. My issue is that when I try filtering by "price" it ignores special price. I was thinking I could add […]
  • Can I add a special price on my standard tier pricing? (0)
    I have set a promotional action in the magento admin by adding a special price on product level. The products have also a tierpricing system. I would like to also add a special price on the tierprice values as part of the promotional action. I am eagered to hear advice on how to […]
  • how to properly save EAV attributes for all store views at once? (1)
    We have right now three store views with different locales and plan to extend their quantity in a future. We encountered issue when some attributes (price, name, etc) are properly received when we saving them with storeId = 0, then, according to […]
  • How do you add strict tier pricing? (2)
    I have an issue where I need to have strict tiered pricing. Right now you can order based on tier like... Order 250 and above pay 1.77 Order 500 and above pay 1.64 Order 1000 and above pay 1.54 but what i need is more like... Order 250 pay 1.77 Order 500 pay 1.64 Order 1000 […]
  • Magmi 0.7.23. Group Price Import does not update prices (0)
    I am using Magmi 0.7.23. The Group Price Import(0.0.2) which was with Magmi 0.7.23 fails to update group prices from a csv file. Everything looks like it is running and finishes but when I check the product records the group prices did not update. The tier and price routines work […]
Custom price tier module - save goes to infinite loop
how to resolve conflicts between layouts

1 Comment on this article

  • User November 12, 2016

    Tier prices are stored in DB table: catalog_product_entity_tier_price

    select DISTINCT (entity_id ) from catalog_product_entity_tier_price
    

    The above query should give you all the product ids that have tier pricing setup.

    Reply

Add a comment

To create code blocks or other preformatted text, indent by four spaces:

    This will be displayed in a monospaced font. The first four 
    spaces will be stripped off, but all other whitespace
    will be preserved.
    
    Markdown is turned off in code blocks:
     [This is not a link](http://example.com)

To create not a block, but an inline code span, use backticks:

Here is some inline `code`.

For more help see http://daringfireball.net/projects/markdown/syntax