How do I deal with items I purchase by the box but sell individually?
MPQ - Adjusting an item imported via SIM as an outer box item, but which is sold individually
Some items imported using SIM are purchased as boxed quantities, but the contents are sold as single items. Examples might be nutrition products or inner tubes. These items may import with the cost of the box, but the retail price of a single item.
In this situation, the item card needs to be configured to account for this, using the MPQ (Multi-Pack Quantity) feature. This is done on the item record in Cloud POS backoffice.
The example below shows how a newly-imported item might look on your system:
In this situation, we need to change the cost to equal that of a single item, and tell the system that this item is an MPQ item.
1) In the main menu in Cloud POS backoffice, select Create & Manage Items, then Items;
2) Use the filter options to locate the item you wish to amend, then click Edit next to the item;
3) On the item record, scroll to the Inventory section, select Edit next to the store in which you are working, and then amend the Cost field.
The figure you enter in the Cost field should be the price you would pay your supplier for a single item. For example, if there are 15 items in the box and you pay the supplier £15.00 for the box, the cost for the single item is £1.00.
Click Update to save the changes.
4) The next step is to amend the item to calculate from the box quantity. Scroll to the Suppliers section and click Edit to amend the record.
In the Unit Cost field, enter the cost of a single item;
In the MPQ field, enter the number of products which are contained in the box;
As you update these figures, the Pack Cost field will be automatically calculated. This may not equate to the actual exact cost of a box, due to the rounding used in the calculation, but the figure will update when you next receive a box via a Purchase Order.
5) Click Update to save your changes, then scroll to the foot of the item page and click Save to save the whole item record.
With these records set, the item can be sold individually as normal, and Cloud POS will now calculate the correct quantity to order when the item is placed on a Purchase Order for that supplier, as in the screenshot example below. Here we can see that the system now understands that one pack contains 15 items. We can also use this opportunity to set the exact cost price of the item by editing the Line Cost field:
Once the purchase order is placed and we have moved to the Goods In phase of receiving stock, we again need to check that the Pack Cost field is accurate, and amend this if necessary, according to the price we have paid the supplier.
Now that the item has been received on a purchase order, we can check the item record and will see that the Average Weighted Cost field has updated to the cost of a single item, rather than the pack cost:
The Pack Cost on the Suppliers section of the item record has also updated to reflect the cost price we entered when receiving the item on the purchase order: