Qty Group

Big Business has several Pricing features. Many do not appear until enabled. Qty Pricing (prices based on quantity being purchased), for example, adds a tab to the Item card and includes tools for Update, Import, etc. once you turn it On in the Item Prefs.

This Solution can be used as a starting point. Click the links below to review related entries. (6844)

To enable the Qty Pricing tab:
1. Go to the Item Prefs.
2. Click the checkbox, Use Qty Pricing
3. Click OK to save

To use Qty Pricing:
1. Go to an Item Card to the Qty Pricing tab
2. Click Add to add a new row
3. Enter a Qty and Prices
4. Click OK to save

Entering a Qty on a Quote, Sales Order, or Invoice will use the matching price.


  Qty Pricing Options

Big Business includes several options for selling different Quantities at different prices.

There is a optional feature (for a paving stone distributor) that lets you key in one unit (square feet) on one row and converts to other units (pallets and eaches) on split rows. This works with Qty Pricing to automatically set bulk price (pallet) on bulk rows.

There is another feature (for beverage distributor) for splitting one item (drink cases) into other items (individual drinks) automatically, so the inventory is kept up-to-date. This does not require Qty Pricing because each item (cases and eaches) has its own item card to automatically avoid fractional items (one case minus one bottle leaves 23).


  Chapter 612 Qty Pricing

Qty Pricing is a feature you turn on to add quantity price breaks on sales transactions. An Order for 20 units of an item might be regular price while 100 gets a special price.

Qty Pricing is a complete feature set you turn on to enable:
• Qty Pricng tab on the Item card for entering Qty's and their Prices
• Import and Export options for bulk updates to Qty Pricing
• Qty Group for counting across grouped items to determine pricing


  Qty Pricing

Big Business 8.5.0 adds a Pricing tab on the Item Card for entering Quantity Pricing, that is price breaks or discounts to the Item's Price when a higher Qty is entered on sales transactions.

This solution describes using this feature. (6262)

To enable the Qty Pricing tab:
1. Go to the Item Prefs.
2. Click the checkbox, Use Item Price Tab
3. Click OK to save

To use Qty Pricing:
1. Go to an Item Card to the Pricing tab
2. Click Add to add a new row
3. Enter a Qty and Prices
4. Click OK to save

Entering a Qty on a Quote, Sales Order, or Invoice will use the matching price.


  Qty Pricing Import

Big Business 8.5.1 adds an Import for Item Pricing, for adding quantity price breaks or discounts, and the options to Export and Delete existing entries.

This solution describes using this feature. (6279)

To Import Item Pricing:
1. Go to the Maintenance toolbar to the Import tool
2. Open a Tab-Text file to import
3. Select Item Pricing (at the bottom of Import list)
4. Map the import fields (highlight and click Insert)
5. Click OK to Import

To create a Tab-Text file to import:
1. Create a new spreadsheet
2. Add columns for Item Code, Qty, and Prices
3. Save As... Tab-Text

To Export Item Pricing:
1. Go to Item Search and find Items
2. Hold Shift and Option/Alt keys
3. Click Export

To Delete Item Pricing:
1. Go to Item Search and find Items
2. Click Apply
3. Choose Item Pricing in the first pulldown and Delete will appear in the middle
4. Click OK to proceed
5. Choose Apply Changes in the confimation dialog

To use Qty Pricing, you must select Use Qty Pricing in the Item Prefs.


  Qty Pricing Group

Qty Pricing lets you set pricing based on quantity, such as lower price for buying 100. Turn on this feature in Item Prefs by clicking Use Qty Pricing to add a Qty Pricing tab.

Qty Group lets you group items to use their combined quantity to choose Qty Pricing. An invoice for grouped items with Qty 70 and 30 would use 100 Qty Pricing for both.

Once you enable Qty Pricing, choose Show List in the Qty Group dropdown to create. Then use Update on the Items Search to set multiple Items to use the new Qty Group.


  Qty Prices

Qty Prices are being updated for Big Business 14 to help reliably entering price breaks.

Pictured is the Item Card with many options for MRP, Price Level, Shopify and more. Qty Pricing is a separate option for quantity price breaks including across group items.


  Qty Pricing Tab

Big Business 14 updates the Qty Pricing Tab on the Item Card to improve useability.

Qty Pricing is separated from Item Pricing for clarity. As pictured, you see your price breaks for Qty's (10, 100, 200) sorted in ascending order. Click Add (+) for a new blank row and it goes on top (highlighted).

Qty Pricing is one of many optional tabs for items along with Item MRP, Price Levels, BigCommerce, and Shopify, pictured. Each is turned on separately so there are only three tabs to start. Go to Item Prefs, click Qty Pricing, and this will enable this feature.


  Qty Pricing Import

Big Business 14 renames the Qty Pricing Import (was Item Pricing) to improve clarity.

Qty Pricing is a complete feature set, turned on in Item Prefs, that lets you offer price breaks on quantities purchased. The import speeds the process of adding Qty Pricing.

Use the Update in the Items Search to delete old Qty Pricing before importing new. Use imports for items to change regular prices or assign Qty Group for mix & match.