Spreadsheet Master
Spreadsheet Master
Manage your online shop in a spreadsheet.
  • Shop
  • Guides
    • Working with attributes
    • Create configurable products
    • Translate your Magento products
    • Bulk image import
    • Magento 2 bulk update prices and tier prices
  • Price List
  • Privacy Policy App
  • Imprint
  • Shop
  • Guides
    • Working with attributes
    • Create configurable products
    • Translate your Magento products
    • Bulk image import
    • Magento 2 bulk update prices and tier prices
  • Price List
  • Privacy Policy App
  • Imprint

Magento 2 bulk update prices and tier prices

A new feature in our extension is the possibility to update tier prices. For this we have a special syntax. The simplest way to provide tier prices is this:

Manage tier prices in a spreadsheet.
Absolute discount for tier prices.

If you look in the first row you see the price which is 30 EUR (the currency depends on your shop settings). When the user is buying 10 pieces the price drops to 20 and if he buys 30 pieces it will be 15 EUR.

This was an example to provide a tier price with an absolute value. But in the Magento System it is also possible to provide a tier price with a percentage value. If you want to do something like this you can use the following syntax:

Bulk update the percentage value of the tier prices.
Percentage discount for tier prices.

This statement means after the amount 10 you are getting 5% discount and after the quantity 30 there will be 10% discount. It is also possible to mix the things. The first tier has an absolute discount and the second tier a percentage discount value.

Contact

[email protected]

https://spreadsheet-master.com

Follow Us

Contact Us