You’re offline. This is a read only version of the page.
Hello,
I am trying to assign a discount scheme to our clothing department 500+ items, need to have pricing discounted buy 1 item get 10% off, but 2 items get 20% off both and 3 items get 30% off all 3. Setting this in the database can be accomplished 1 item at a time but this is very time consuming. Is there a query to make this happen faster?
*This post is locked for comments
I have the same question (0)
Hi there.
First of all, if you do this with tSQL, then I suggest you do it first in a test environment and do it several times, until you are sure it's working correctly. This is IMPORTANT. Also, if you are not too knowledgable with tSQL quieries, you may want to talk to your RMS Partner on this issue...
OK, the process should be something like this:
1º) First You configure this discount in RMS SO Manager for one Item, let say your item ItemLookupCode is "12345". Test it in RMS SO POS, if it's correctly working and applying correctly the descounts.
2º) Then open RMS SO Admin or SQL Server Management studio and connect to the RMS Database. Open a new empty query and create a SELECT query that will filter your 500+ items, let say something like this
SELECT [ItemLookupCode] FROM Item WHERE DepartmentID = 1
, meaning all the Items that are in a specific Department. This part is crucial, You need to define correctly the WHERE part, 'coz these are all the items that will be updated with the discount scheme. Execute the query and see if the result is returning the Items you want to update
3º) Once you confirm the step 2º, then open a new query, for updating the Items. Copy / paste this next text:
UPDATE [Item]
SET [QuantityDiscountID] = (SELECT [QuantityDiscountID]
FROM [Item] WHERE [ItemLookupCode] = '12345')
WHERE [Item].[ID] in (SELECT [ID] FROM [Item] WHERE [DepartmentID] = 1)
Again, please do this first in test environment and even when doing in Live environment, do it when nobody is using the software and with previous database backup.
Contact your RMS Partner also.
Kind regards, A.
Share
Report
All responses (
Answers (
4,025
