How to bulk update for quantity discount pricing

Hi all. I have RMS Store Operations V2.0 I hope anyone can help me on solution / procedural work to do bulk updates on quantiy discount table. I am familiar with SQL

I have a group of items, where the retail prices are set based on a formula based on item dimensions (thickness and width) The discounted prices are also based on a similar formula The number of items to update when prices changes is around 300 items

Here's what I notice from RMS

  1. When choose to use quantity discount pricing table from an item properties and entered accordingly, one entry is inserted into the database, table QuantityDiscount for example retail price of one item is 3600, if customer buy 20 the price is set to 3500, buy 50 then the price is set to 3339
  2. However when we open back the item properties and this time select do not use discount; the correponding QuantityDiscount entry is deleted.
  3. So when I select back to use the discount pricing table, I cant find my previous QuantityDiscount that I entered. So I have to retype the quantity discount pricing table again for this item

I was initially thinking of harcoding the item id and the quantitydiscount id. But my biggest problem would be if the manager change the discount method from item properties

Any idea will be appreciated !

Regards, Joie

Reply to
Joie
Loading thread data ...

Reply to
Akber Alwani

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.