How to Setup Prices and Price Breaks

Setting up your pricing correctly can make or break the quality level of your product data. Having done some research on enquiries at several suppliers and distributors we have worked out that 93% of all enquiries could be quoted instantly if we had a minimum of 5 price breaks.  This is from data collected over a 6 month period. As with all the product data formats we have allowed for scalability.


The standard titles would be Plain, 1 Colour Print, 2 Colour Print, 3 Colour Print, 4 Colour Print, Full Colour Print. However by adding the ability to define a title we give ourselves much more versatility in what we can use the fields for. Engraving/Embroidery or whatever you want to use them for. Some suppliers just give a plain stock price and then a matrix with costs for additional colours.  That's fine as its easily convertible into any other format that you client needs. 

A few Points to note:

  • Always include 5 price breaks
  • Don't leave blanks in the pricing matrix

How not to setup your price matrix.

500
1000
 2500
5000
10000
N/A
1.50  1.25 1.10 0.90
The quantity is fixed for each column, this leaves gaps all over the place and many products end up with missing price breaks

Setting up Price Breaks - The Right Way

 
If you lay out your quantities like this then you should never have any gaps in the pricing matrix and your client will always have 5 price breaks.
 
price_quantity_1
price_quantity_2
price_quantity_3
price_quantity_4
price_quantity_5
100
250 500 1000 2500
500  1000 2500 5000 10000
1000  2500 5000  10000 25000
These prices line up with the quantities as assigned in the columns above.
 
price_plain_q1
  price_plain_q2
 price_plain_q3
 price_plain_q4
 price_plain_q5
1.20
 1.15 1.10 1.05  1.00
You should always include a plain stock price, and then build on it from there.

Prices for a 1 Colour Print

price_title_1_qty_1price_title_1_qty_2price_title_1_qty_3price_title_1_qty_4price_title_1_qty_5
0.20 0.19 0.18 0.17 0.16
 
Using this format we can then build up a highly versatile data set.  Rather than being limited to 1-4 colours we can give the title any value we want.  This works in exactally the same way as creating additional cost elements.
For any additional price titles just increase the number by +1
If you want to display more price breaks just increase the number by +1
E.g.
price_title_2_qty_1price_title_2_qty_2price_title_2_qty_3price_title_2_qty_4price_title_2_qty_5
0.20 0.19 0.18 0.17 0.16

We have separated additional costs from price title elements, because this information is part of the core data set and should not really be used for minor additional cost elements

price_plain_titleprice_title_1price_title_2price_title_3price_title_4price_title_5
Plain Stock Printed 1 Colour Printed 2 Colours Printed 3 Colours Printed 4 Colours Printed Full Colour

As with all other parts of the format everything is scalable. You can add as many price breaks as you need and as many print options as you need. It's then down to the distributor to extract what they want to use.

Point to Note:

  • The title elements should be able to solve 90% of all price queries.
  • The values should be the the combined cost of the product and the print.
If you have a different personalisation method then use the same format as above, just state in the column header what the price is actually for i.e Embroidered or Engraved
 


Copyright © 2020 PromoMagic Ltd | +44 (0)1795859639 | This email address is being protected from spambots. You need JavaScript enabled to view it.

Registered in England and Wales Company Number: 11970723 -