Quantity Based Pricing

[hazelann]

How do I enter Quantity Based Pricing for individual products available for all customers into a Hierarchical Spreadsheet as I have over 5000 products and would take a long time to do them all individually

I have a database from which I produce the Hierarchical export - but it wont import the retail prices

[NormanRouxel]

Here's an example of a minimal file that updates a product. It's for the demo site where the Three Diamond Ring usually has a single price of £20. Now we'll create a minimal import file to set quantity 5 to £17.50 and quantity 10 to £15.
Import with "Update" selected and that's the job done.

Version:16
Header:Product,Product Reference,Short Description
Header:Price,Customer Group,Price,Generated,Can be Ordered,Product Visible,Minimum,Customer Message,IsDeleted
Product,"1","Three Diamond Ring"
Price,Retail,1750,0,1,1,"5","",0
Price,Retail,1000,0,1,1,"10","",0

Note that the price is in pennies.

Best test on a spare system before committing it to a live site.