Selling Items by the Case

In Artisan, it is easy to sell items by various quantities, such as case, 10-pack, or whatever variations you want. For example, you can sell soda by single, 6-pack, 12-pack, or case of 24. If the case has its own UPC code, you can add that UPC code to the variant, and then the case will automatically ring up when scanned into the sales screen.

If you ring up the “base product,” then Artisan will prompt you for all the various quantities you sell it. If you print out barcodes from Artisan, then those will bring up the exact quantity if you have them pre-packaged.

You always track inventory by the smallest unit you sell. For soda, it would be singles. The total quantity on hand would be 24 if you had 4 6-packs, and 23 if you had split a 6-pack to sell 1 single. There isn’t a way to track the number of cases and the number of singles (unless you use different base item records). However, some reports can do the math for you to show you how many cases you have, even if that number is fractional, such as 3.83 in our example of 23 singles.

Often when you setup these items, you actually buy them by the case. You can specify that unit of measure in the item record as shown in the following example. Although this is often the case, it isn’t required as part of the process. Scroll to the bottom of the article to find out about this method (buying by “each“).

Setting Standard Cost to “Case”

  1. Under the “Standard Cost” drop down, change the default “each” to “case.”

 Set how many items are in each case and how much each costs.

2. Leave the “Pricing Model” as “Set Price Manually.” Choosing a different pricing scheme will cause the retail price to lock, and you won’t be able to change it.

By setting the price manually, we can adjust the number to whatever price we want.

For example, if we choose the “Keystone Markup” pricing scheme, it locks our retail price in place–notice that it is now grayed out. It took the standard cost and doubled it.

By setting the “Pricing Model” as “Set Price Manually,” we can control the retail price and enter whatever amount we want.

3. Once the pricing is finished, create a product variant template. From the dropdown, select “Edit List” and add a new record.

4. Give the template a name. Decide which fields you want to be editable for each product in the variant. 

5. Next, give your attribute a name and press “Enter.” 

6. Enter the variant information. You’ll notice that the SKU suffix and description automatically default for you. 

7. To change the prices in this attribute section, you’ll need to look at “Track Inventory (QOH) of Individual Variant Item Records?” Turn this to “No.”

8. Now, you’ll be able to edit the price. You’ll also want to edit the “QTY” section to reflect the number of items in the pack (ex. single is 1, 6-pack is 6, and 12-pack is 12.) This “QTY” section is NOT the same as quantity on hand.

9. Searching for the item in the Item Records screen, you’ll notice the base product listed as well as the variants we just created. 


Setting Standard Cost to “Each”

If you don’t want to include items by the case using the method we showed in the previous steps, you can follow this other method.

Instead of setting the item record’s standard cost to “case,” set the item as “each.

Create a product variant template following steps 3-9 above.