How to Setup Prices and Price Breaks

Written by PromoMagic on 05 June 2015. Posted in Data Guides

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_1	price_title_1_qty_2	price_title_1_qty_3	price_title_1_qty_4	price_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_1	price_title_2_qty_2	price_title_2_qty_3	price_title_2_qty_4	price_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_title	price_title_1	price_title_2	price_title_3	price_title_4	price_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