Announcement

Collapse
No announcement yet.

Quantity Based Pricing

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Quantity Based Pricing

    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

    #2
    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.
    Code:
    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.
    Norman - www.drillpine.biz
    Edinburgh, U K / Bitez, Turkey

    Comment

    Working...
    X