Overview – import tier pricing
Elovate supports adding and updating tier pricing through the Global import profile.
Although there is a dedicated Tier pricing profile for more complex imports, this guide focuses on using the global profile with legacy tier pricing fields.
Step 1 – Prepare your import file
Your file should contain the tier pricing fields alongside your standard product data.
Example:
sku | tier_price_website | tier_price_group | tier_price_qty | tier_price_price |
PRODUCT-001 | all | ALL GROUPS | 200 | 6.95 |
PRODUCT-001 | all | ALL GROUPS | 500 | 5.95 |
PRODUCT-002 | all | ALL GROUPS | 200 | 7.95 |
Field details:
tier_price_website – Usually
allif applying to all websites.tier_price_group – Customer group name as in Magento (e.g.,
ALL GROUPS,Wholesale).tier_price_qty – Quantity threshold for the tier price.
tier_price_price – Price to apply when the quantity threshold is met.
Step 2 – Add the data to an import job
Go to Import → Add import job.
Select Global as the import profile.
Upload your prepared CSV, Excel, or Google Sheet.
Step 3 – Validation
When you validate the file:
Elovate will check that the tier pricing fields are in the correct format.
Any mismatches or missing headers will result in a validation error.
Step 4 – Run or schedule the import
If validation passes, you can run the import immediately.
If you are importing via a URL, you can schedule the import for recurring updates.
Notes and recommendations
Consistency – If you have multiple tier prices for a single SKU, ensure all data for that SKU is grouped correctly.
Customer groups – Names must exactly match the ones in Magento.
Preferred method – For large-scale or recurring tier pricing updates, consider using the Tier pricing import profile instead, as it offers improved structure and error handling.
Example use case
A supplier sends you a file with quantity-based discounts.
Instead of manually entering them in Magento, you add the tier pricing columns to your existing global import file, upload it to Elovate, and apply the changes in one run.