How to change discounts on (many) articles?

[ampos]

I have PS 1.6.1.11 and need some (batch) changes in my producs database:

1.- In distributor ONE change all discounts to 20%

   FOR EACH product UNTIL END

      IF distributor="ONE" THEN discount=20

   NEXT product

 

2.- ANOTHER distributor, currently has a few discounts: 5, 12, 15, 20... even discount for quantity: 1-15%, 2-18% and +3-20%. I need to change all discounts to 20% but the ones with 5%:

   FOR EACH product UNTIL END

      IF distributor="TWO" and discount<>5 THEN

         REMOVE discounts

         discount=20

      ENDIF

   NEXT product

 

My webmaster has access to the database, but we need to know which database file and field we need to change. Any help will be greatly wellcomed. Thanks.

 

PS: Don't you love my pseudo code?