Quantity Discount

I think you have to set the price break table for that item from the item properties

Hi Errol Leu

Quantity Discount Set as under: Click Mix & match unit price if 1Qty price is $30.00 (enter 30.00 in Reg Price Col ) on POS it will be

1X 300 if 3Qty price is $25.00 (enter 25.00 in Reg Price Col ) on POS it will be 3X 25u if 6Qty price is $20.00 (enter 20.00 in Reg Price Col ) on POS it will be 6X 200 if 12Qty price is $15.00 (enter 20.00 in Reg Price Col ) on POS it will be 12X 150 I h> I think you have to set the price break table for that item from the item > properties

Hi Errol,

you said you have 7000 items to update !!

I assume you use only Store Operations because I dont know anything about HQ

If you open RMS edit Item Properties you will see :

1) Tab "Pricing" 2) Tab "Discount"

The usage of price levels A B C in these 2 tabs are DIFFERENT So you need to understand it before starting to make changes

If we look at tab "Pricing" we see 4 prices Price, Level A, B, C.

example: Item name : Football Price : $15 Price level A: $14 (at Pricing tab)

I am the customer, and you are the cashier.

consider this scenario I am buying 1 piece of football you set the transaction level to A by Selecting "Shift+F3" in your POS (i.e DISCOUNT button) Now I pay $14

I am buying 3 pieces of footballs you set the transaction level to A by Selecting "Shift+F3" in your POS Now I pay 3 x $14 = $52

Now suppose in addition to setting price at "Pricing" tab you are setting the price Break table on the "Discount" tab by selecting "Use a quantity discount pricing table"

for item football Quantity 3 Unit price $14.5, Level A $ 13

Now if I shop for 3 pieces of football You dont set any discount I pay 3x$14.5 = $53.5

Now if I shop for 3 pices of footbal you set the transaction level to A by Selecting "Shift+F3" in your POS I pay 3x$13 = $39

I hope that helps to understand the usage

Now as how to bulk update the prices first you have to understand the table affected To do it in SQL script you may need help from your Database administrator or someone who is more familiar with SQL

There are 2 tables: Item table and QuantityDiscount table

Table ITEM column "QuantityDiscountID" is the link to the table QUANTITYDISCOUNT column ID

Table QUANTITYDISCOUNT column Id is the table primary key and it is auto generated (1, 2, 3 and so on) Table ITEM column Id is the table primary key and it is auto generated Table ITEM column QuantityDiscountID is NOT autogenerated you have to find a way to link it if you want to update using SQL

So heres what i think

1) First find all the 7000 Item names that you want to update, get their item IDs (this is not the item lookup code) 2) Insert 7000 rows into table QUANTITYDISCOUNT with values on column Quantity1 = 3, Price1 = your so called Wholesale price 3) Update the each row in table ITEM column QuantityDiscountID with corresponding Table QUANTITYDISCOUNT column Id

To actually do that, i think you may need to create an Excel Spreadsheet so you can align the content of the table ITEM with content of table QUANTITYDISCOUNT After that you can just use Excel string functions to build up the SQL statements strings to Insert or update the 2 tables

Hope that helps !!!

rgds, Joie