Skip to main content
All CollectionsImport / ExportImport
How to add tier pricing?
How to add tier pricing?
Updated over a week ago

Elovate supports importing and adding tier pricing and staffel to products. There are 5 steps you have to undergo to add tier pricing or staffel; this can be done in large quantities.

Screenshot 2023-11-09 at 09.44.41.png

Step 0 - Export

Create a CSV/EXCEL/SHEET file with products you wish to add tier pricing to. This can be easily done using the export tool. It's important to include the following attributes: SKU and Price.

Step 1 - Adding fields to your file

After the export is completed, follow these steps in your file: Create new headers for your tier pricing. It's crucial to include an underscore "_" followed by a number for the headers. This format helps Elovate recognise that these values are for mapping tier pricing. In the provided example, check the image where I've added it after the price: _9, _24, _49, _99, and _199. This will enable Elovate to map the "tier price" in the import.
​

Screenshot 2023-12-20 at 11.42.14.png

Step 2 - Adding formula

When working with big sheets and an immense amount of rows, it's recommended to make use of formulas, which you can create in Excel. This way, you can create one row and drag it for all existing rows. In this example, you can see the following for SKU - 280319:
​
Staffel 9: =B2*0,96
Staffel 24: =B2*0,94
Staffel 49: =B2*0,92
Staffel 99: =B2*0,9
Staffel 199: =B2*0,88
Staffel 299: =B2*0,86
​
Once you've completed this step you can select and drag it to the remaining SKU's

Step 3 - Elovate import job with mapping

Complete the standard fields in the Elovate import tool and upload the file you've generated. Ensure that the file headers are accurately mapped to the corresponding import values. Specifically, map SKU to SKU, price to price, and for the newly created tier pricing, ensure they are mapped to Tier Pricing. This alignment is crucial for a successful import process.

Step 4 - How it looks in practice

Below you see an example what has been described in step 3.

Screenshot 2023-12-20 at 11.46.46.png

Step 5 - Validate and import

All that's left to do is press validate import and then run the import. You have now successfully added tier pricing to your products!

Screenshot 2023-12-20 at 12.11.09.png
Did this answer your question?