The CSV only needs to contain the SKU column and 4 Tier Pricing Columns.
Website for Tier Pricing - Always "all" as the value
Customer Group ID for the tier price:
Quantity & Above that Tier Price gets applied to
Price applied to the quantity & above.
Note: If the tier_price_price value is Higher than the price or special_price, it will not work on your store.
Once your CSV has been Created, proceed to Import & Export > Import Products
- Entity Type = Products
- Import Type = Append Complex Data
- Upload your CSV file
- Click "Check Data" button in top right of screen
- If everything looks good, you will have a green bar with a button to import
If you encounter errors during the check data step, please read our KB article on Import Errors
Updated over 1 year ago