|
Posted by Joie on December 15, 2008, 9:56 am
Please log in for more thread options 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
>
> 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 30=30
> if 3Qty price is $25.00 (enter 25.00 in Reg Price Col ) on POS it will be
> 3X 25=75
> if 6Qty price is $20.00 (enter 20.00 in Reg Price Col ) on POS it will be
> 6X 20=120
> if 12Qty price is $15.00 (enter 20.00 in Reg Price Col ) on POS it will be
> 12X 15=180
> I hope this will help you.
>
> "Joie" wrote:
>
>> I think you have to set the price break table for that item from the item
>> properties
>>
>>
>>
>> >I am using RMS Store Operations Ver: 2.0 and would like to effect a
>> >discount scheme. When a customer purchases 3 or more items he is
>> >entitled
>> >to a wholesale price which I have set up as Price A. Can anyone assist
>> >me
>> >in making this work?
>> >
>> > --
>> > Best Regards,
>> >
>> > Errol Leu - Retail Account Manager
>> > Retail Services Department
>> > Tel: (592) 226-1066
>> > Fax: (592) 225-6053
>> > Mobile: (592) 612-7658
>> >
>> > Please copy all mail to:
>> > errol_leu@hotmail.com
>> >
>>
>>
>>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap