Rating 5 stars - 1 votes

Magento tier price multi editor for massive edits

Magento Tier Price is a perfect way to boost your sales by offering customers quantity-based discounts. From now on it is possible to add, edit or remove Magento tier price rules massively using Magento Tier Price Multi Editor, built in Store Manager application. It was developed to simplify managing tier pricing for a big number of products with a lot of conditions. This tool provides you with all necessary instruments allowing to perform the procedure in a convenient way.


Magento Tier Price Multi Editor functionality is available starting from version 3.14.0.2159 of Store Manager.

Magento Tier Price Multi Editor has two configuration modes: simple and advanced (advanced mode is available only in Adobe Commerce (Magento Enterprise) Edition). Let's figure out how to set tier prices for your Magento products with each of the above modes one by one.

Where to Find Tier Price Multi Editor?

There are a few ways to open Magento Tier Price Multi Editor window in Store Manager for Magento application:

  • launch it from the Products toolbar using the Multi Editors drop-down menu;

  • launch magento tier price multi editor
    Magento Tier Price Multi Editor for Massive Edits


  • on the products grid, select the items you need to edit and right-click on them. Select from the options Multi Editors>>Tier Price Multi Editor or Tier Price>>Tier Price Multi Editor.

  • magento_tier_price_multi_editor_start
    Magento Tier Price Multi Editor for Massive Edits


Setting Magento Tier Prices in Simple Mode

What actions can be performed in Simple Mode?

  • Set relations between product quantity and product prices selecting a specific modifier type (+/- value, percentage or fixed value);
  • Apply tier prices on selected websites;
  • Enable/disable tier prices for particular customer groups.

magento tier price multi editor simple mode
Magento Tier Price Multi Editor for Massive Edits


How to use?

  1. Check the 'Modify quantity by'/'Modify price by' boxes to input products quantity and price values. Select the Modifier type: +/- value, percentage (for prices only) or fixed value.

  2. magento tier price multi editor modify by
    Magento Tier Price Multi Editor for Massive Edits


  3. Use Websites drop-down to specify the website the changes must be applied to. Then check or uncheck the 'All groups' box and select 'Customers group' from the drop-down.

  4. magento_tier_price customer
    Magento Tier Price Multi Editor for Massive Edits


    Note: If both 'All Groups' and 'Not Logged In' options are activated, the configurations will be applied to all customer groups. In case both of them are not selected, the changes will not be displayed in any of the groups.

    There are three 'Action' options you can select:

    • Skip - do not apply the updates to the current column;
    • Modify - edit tier price data of current column;
    • Delete - remove tier price from the product.

    • magento tier price multi editor action
      Magento Tier Price Multi Editor for Massive Edits


      Example

      Let's say, you sell watches for $100 each. Recently you created a discount for your wholesalers offering them to pay -$10 for each item, when buying at least 10 product items, or -$30 when buying at least 50 items.


      Tier prices can be added this way: select necessary products and switch to 'Tier Price' tab in the lower grid. After that press 'Add' button and configure the quantity and price relations in the separate 'Tier Price' window.

      magento tier price add example
      Magento Tier Price Multi Editor for Massive Edits


      For some reasons you decided to increase that -$10 discount to -$15 and -$30 to -$35. What should you do? First, highlight necessary products and launch Tier Price Multi Editor. After that input fixed value '10' into 'Modify quantity by' field and '-5' value into 'Modify price by' field.


      magento tier price multi editor set example
      Magento Tier Price Multi Editor for Massive Edits


      Select Wholesale customer group from the drop-down and the website to apply tier price rules to. Select Modify action from the drop-down for those -$10 tier price rules.

      Perform the same operation with -$30 discount rules, setting Modify action for them. Now your tier price rules are changed.

      Configuring Tier Price in Advanced Mode (available in Adobe Commerce (Magento Enterprise) Edition only)

      What is Advanced mode used for?

      Beside simple mode functions, in this mode you can use expression editor and customize tier price configuration by applying your own SQL commands.


      How to use?

      Start Tier Price Multi Editor using one of the mentioned ways and switch the mode to advanced in the left upper corner of the window.


      magento tier price multi editor advanced mode
      Magento Tier Price Multi Editor for Massive Edits

      The editor window looks the same as in Simple mode and includes the same columns except of additional 'Expression for price*' function. In order to open expression editor, press the browse button.


      magento tier price multi editor expression editor
      Magento Tier Price Multi Editor for Massive Edits


      Here you can create your own expressions and run them pressing the 'Execute Expression' button or F9 hotkey. Select the necessary action to be performed in each of the product fields.

      'Add to Selected Products' function

      Selecting this option will transfer you to a separate window. Here you can set tier prices specifying data in the columns (the ones marked with asterisks are required to be filled) and apply them to the highlighted products.


      magento tier price filter
      Magento Tier Price Multi Editor for Massive Edits


      Copy/Paste or Massively Delete Magento Tier Prices (EE only)

      You can clone or massively delete Magento Tier Prices only in Adobe Commerce (Magento Enterprise) Edition of Store Manager.

      In order to append existing tier price rules to other merchandise, follow these steps:

      1. Highlight necessary items in the products list and select Tier Price tab in the lower grid. Press 'Copy Selected' button and click on the product you want to paste the copied tier price to.

      2. magento_tier_price_add_example
        Magento Tier Price Multi Editor for Massive Edits


      3. From the context menu select Tier Price>>Paste Selected.

      4. magento copy tier price
        Magento Tier Price Multi Editor for Massive Edits


      5. There will show up a pop-up window asking you to select the exact action to be accomplished:
      • Delete and Paste (clear the existing tier prices from the product and insert the copied ones);
      • Just Paste (add the selected tier prices to the current ones, if there are any);
      • Cancel.

      magento clone tier price
      Magento Tier Price Multi Editor for Massive Edits


      In order to delete tier prices for a bulk of products, use the following context menu options: Tier Price>>Delete Selected.


      magento paste tier price
      Magento Tier Price Multi Editor for Massive Edits


      Tier Price filter

      In addition, another new option is available now: you can check what products have tier prices by filtering them using Custom Columns drop-down. The ones with tier prices will be marked by a specific sign.


      magento tier price multi editor delete
      Magento Tier Price Multi Editor for Massive Edits


      Using Magento Tier Price Multi Editor you can easily handle tier price rules for either 100 or 10 000 products and change those rules in few clicks! Take advantage of this multifunctional and handy tool and set up Magento Tier Prices massively.


Edit Magento Tier Prices Massively with Store Manager for Magento

Buy Now



Related Articles:


copy paste magento tier prices in bulk tutorial

Copy/Paste Magento Tier Prices in Bulk

Learn how to copy Magento tier price from one product and paste it to another product in a few clicks. Read More...

7 examples of widely used magento promotions

7 Examples of Most Widely-Used Magento Promotions

Explanation of most often used Magento promotions (Buy 1 Get 1, Free shipping etc) and guidance on their configuration. Read More...

generate magento 2 cross sell products basing on customer behavior

Automatically Generate Magento 2 Cross-Sells

Generate cross-sell products by multiple conditions (order status/date, category, product type, stock availability etc). Read More...

add change magento special prices for multiple products

Add/Change Magento Special Prices in Mass

Find out how to use multi-editor to modify special prices in bulk and how to import special prices for multiple goods. Read More...


COMMENTS
Francesco
Francesco • 08/21/2018

Why Tier Price Multi editor doesn't showing? I have version 3.3.1

Magento Store ManagerMod Francesco • 10/13/2018

Hello, Francesco! Thank you for your question. Tier Price Multi Editor is available starting from version 3.14.0.2159. Here you may check the details - https://www.mag-manager.com/discover-the-latest-updates-of-store-manager-for-magento/release-notes-v-3-archive/

Live Chat