Units Per Case - SKU Setup for Ordering and Receiving in Portal
Last updated
Last updated
UNITS PER CASE - SKU SETUP FOR ORDERING AND RECEIVING IN PORTAL
To import major Vendor invoices and export orders from Barnet correctly, SKUs need to have the correct ‘Deposit’ and ‘Units Per Case’. If you sell any SKU in a format that’s different than it is sold to you, ‘Units per pack’ and ‘Single’ settings must also be correct in <Product Maintenance>. If SKUs are not setup correctly then invoices won’t balance, costs will be wrong, and orders and invoices will have SKUs with the wrong quantity. It is best practice to review your orders before you place them and check that your invoices balance, including deposit.
Units Per Case
Most SKUs are sold in stores the same way they are sold to stores by Vendors. In this case ‘Units Per Case’ is the most important field. SKUs should be setup with the same Units Per Case that they came with from the Vendor. Most wine comes at 12 per case, 6 packs are 4 per case, 8 packs are 3 per case, etc. You can take a look at the Pricelist if you are unsure.
Deposits on the SKUs must match your in-store selling unit. If you sell in a different format than the SKU comes from the Vendor, make sure to set the appropriate deposit.
If you sell any SKUs differently than expected, additional setup is required, and this may vary depending on the Vendor. For orders and invoices, only the number of cases matters, not the configuration of selling units in the case. ‘Units per pack’ or the ‘Single’ flag are used to change SKU setup. You only need to check the Single flag if a SKU does not usually come as a single.
12 packs of 710ML beer from BDL as single 710ML cans? You must set the SKU up as a single. Deposit should be .10.
Units Per Case should be 1 – Vendor’s SKU price is for all 12 cans as 1 unit
Units per pack should be 12 – you are selling them as 12 separate units
Single should be checked – check this to tell Barnet to divide the SKU cost by the Units per pack
24 packs of 473ML Tall Cans as single tall cans? You must set the SKU up as a single. Deposit should be .10.
Units Per Case should be 1 – Vendor’s SKU price is for all 24 cans as 1 unit
Units per pack should be 24 – you are selling them as 24 separate units
Single should be checked – check this to tell Barnet to divide the SKU cost by the Units per pack
4 packs that you sell as single cans? You must set the SKU up as a single. Deposit should be .10. This works with Vendors that you order and receive by cases like Connect Logistics. You can also order and receive from craft breweries by case.
Units Per Case should be 6 – Vendor’s SKU price is for all 4 cans as 1 unit
Units per pack should be 4 – you are selling them as 4 separate units
Single should be checked – check this to tell Barnet to divide the SKU cost by the Units per pack
