How to Manage Multiple Units of Measure for Sales in SuiteCommerce InStore (SCIS)

The solution involves creating a base inventory item in NetSuite ERP with defined Units of Measure (UOM) for purchasing and inventory tracking, and then creating separate kit items for each desired sales unit in SuiteCommerce InStore (SCIS).

1. Configure Base Unit of Measure (UOM) List

   Create a UOM list, for example, named “Wine”.

2. Create Base Inventory Item

   Create an inventory item in NetSuite ERP that will serve as the base unit for purchasing and inventory management. This item should have the following attributes:

   • Item name/Number: arbitrary name or number
   • UPC: the UPC code on the single bottle
   • Display Name/Code: Name of item as it will appear on the receipt when the base unit is sold on the POS (“Red Wine”)
   • Units Type: Wine
   • Stock Units: Bottles
   • Purchase Units: Cases
   • Sale Units: Bottle
   • Base Unit: bottle
   • Sales Description: description as you want it to appear when taking inventory, such as “Red Wine (single bottle)”

3. Create Kit Items for Sales Units

   To accommodate sales in various units of measure within SuiteCommerce InStore (SCIS), especially where dynamic UOM selection at the point of sale may be limited, create an additional Kit item to represent each desired sales UOM.

   • For a Glass: Create a kit item. Add the component “Red Wine” and set the quantity to 0.25 (each bottle of wine contains four glasses, thus 0.25).
   • For a Six-Pack: Create a kit item. Add the component “Red Wine” and set the quantity to 6.
   • For Easy Lookup: To facilitate lookup of cases and packs by scanning the single bottle's UPC, include the single-bottle UPC code in the Item Name/Number field of each kit item.

4. Example Item Configuration Chart

   The items should be configured as follows:

   Item Name/Number UPC Code Tax

   Bottle 1000 (arbitrary number) 123456789 from the UPC on physical wine bottle Base product, with UOM which will default to bottle (normal behavior) Taxable—normal rate

   Glass 123456789-g NO UPC code Kit composed of .25 of bottle Taxable – Prepared Food

   Pack 123456789-p 874563217 from the UPC printed on the physical pack Kit composed of 6 of bottle Taxable—normal rate

   Case 123456789-c 748596321 from the UPC printed on the physical case Kit composed of 24 of bottle Taxable—normal rate

5. Cashier Workflow in SuiteCommerce InStore (SCIS)

   This setup enables the following cashier workflows:

6. To ring up a single bottle, scan the UPC printed on the bottle; the item will be entered into the SCIS sale.

7. To ring up a case, pack, or glass:

   a. Press FIND, scan the UPC printed on the bottle, then choose the pack, case, or glass item from the lookup screen.

   b. Alternatively, scan the UPC code printed on the physical pack packaging.

8. Impact on Purchasing and Inventory

   • Purchasing: Only the base unit appears in the purchasing list.
   • Inventory: Only non-kit items show on the physical inventory sheet, preventing miscounts by employees.
   • Sales Reports: Sales will be reported by each individual kit item.