What is Buying Multiples?
Buying multiples on products are normally set to 1. This means a product exists as one single unit, to be purchase and sold as units.
But if the product being added is to be broken up and the items sold individually, the buying multiple can be used to represent the sell-able units within the pack size. This allows the product to be Purchased as Packs and Sold as Units.
Example: when you order 1 box of Telfa pads it contains 100 units which are then sold individually, so the buying multiple would be set to 100). The Standard cost and Sell price set should be for one item – not the pack, and the "Calc buy multi" option must be set to prevent pricelist updates resetting the buying multiple.
With the above configuration, Toniq will automatically divide the Pricelist Std Cost and RPP, by the buying multiple assigned.
e.g. If the Pricelist Std Cost = $60. Toniq will set the Std Cost on the product to $0.60
Pricelist Assigned Buying Multiples
From version 5.45, Toniq Pricelists will apply known buying multiples to products where the Standard Pricelist assigned to the product contains this information. Ensure that your Std Pricelist assigned to the product matches the supplier's pricelist you intend to purchase from.
Toniq is working with suppliers to further enrich product data so that stores do not need to read notes and configure all products which require buying multiples manually.
This means any pricelists which contain buying multiples, can be seen when pressing/viewing [F5 Pricelist] on the product.
Ordering stock with buying multiples
When a Buy Multiple products is placed in an order, you need to order FULL packs.
- To add an item to an order you can type in the actual quantity (e.g. 12 for the Protein Bar Caramel bars) and the program will change it to 1P (e.g., if you type in 24 the program will change it to 2P) or you can simply type in 1P.
- When using automatic ordering you should set the Margin to 0.30 on the initial order type screen. A margin of 0.3 means that Retail will only order a pack if the calculated order deems that MORE than 0.3 of that full pack is needed.
- When receiving an order, the quantity should be in full packs (e.g. 1P) and the Cost should be for the Full Pack cost..
Resolving Buying Multiples to Correct Bad Reporting
Incorrect Buying Multiple set-ups are one of the main causes of poor GP figures and the first indication may be from a Sales Analysis or Key Indicator Report. These reports can be ranked by Bottom Markup % for investigation purposes.
- From Main Menu:
2 [Stock Control]
3 [Stock Maintenance]
2 [Maintain Products]
- Recall the item under investigation. We will use Telfa Pads as our example product
o Telfa pads are brought as a box of 100 but sold individually
- Buying Multi – this should be the individual unit quantity counts (not 1). Edit this now.
o For Telfa pads this should be 100
- Std Cost – this should be the individual selling unit Std cost (eg full pack divided by single unit count). Edit this now.
o For Telfa pads this will be about 0.35 cents each
- Sell Price – this should be individual unit Sell price (to the customer)
o For Telfa pads this will be about $1 each
- Last Cost – this should be the individual Last cost (eg full cost divided by the buying multiple/single unit count)
Last cost should be corrected in the Purchase history screen – F6 [Stats], F8 [Purchase history]
It is a good idea to review the Purchase history even if it currently looks correct (someone may have manually over typed the Last Cost figure on page 1 but not fixed the history which is what the reports look to for calculations)
Once at the Purchase History screen change the quantities accordingly so that the unit cost reflects a single unit cost and the quantity is for an individual item
o For Telfa pads quantity would be 100 for each box purchased, unit cost will be becoming approx. 0.25 to 0.35 cents
- If the product has always sold as an individual unit correct all history, F12 [Accept]
- If the product changed to a buy multi correct the history back until this date then F12 [Accept]. If unsure go back and review the Sales History – F6 [Stats], F7 [Sales History]
- F12 and Apply changes
- Check that the SOH figure is for the individual units. If incorrect F4 [Stock] and correct the SOH figure
- F12 [Accept Details] to save the product changes
Another example - GLOVES Latex Non Sterile Small 100
Pharma code: 2247674
This was how the product default was displayed. The product is a pack, however the buying multiple within Retail is always set to 1 by default.
The purchase history should be checked as well, and you can see the Quantity ordered is per pack, not per unit.
Buying multiple altered from 1 to 100
You could calculate the correct Last & Std costs now and enter manually, OR update the Std Pricelist
Buying multiple quantities are updated (not the Cost) and the Unit cost should correctly reflect the changes.