Price discounts on all products


https://forum.kartris.com/Topic1617.aspx
Print Topic | Close Window

By rocknet - Tue 27 Mar 2012
Is there a way to discount all products.

e.g reduce all prices by 20%

Steve
By Neil - Wed 28 Mar 2012
I don't think there is functionality built in to the backend to do this. You will need to run some SQL against the db in configuration>database admin > run query.

Something like this:


DISABLE Trigger trigKartrisVersions_DML ON [your DB name].[dbo].[tblKartrisVersions]
UPDATE [your DB name].[dbo].[tblKartrisVersions]
set V_Price = enter price change here

ENABLE Trigger trigKartrisVersions_DML ON [
your DB name].[dbo].[tblKartrisVersions]
GO


Backup first
By Mohammad - Sun 1 Apr 2012
This functionality will be available in v1.4, not too long to be released.