Price discounts on all products

Posted By rocknet Tue 27 Mar 2012
Add to Favorites0
Author Message
rocknet
 Posted Tue 27 Mar 2012
Supreme Being

Supreme Being - (14,329 reputation)Supreme Being - (14,329 reputation)Supreme Being - (14,329 reputation)Supreme Being - (14,329 reputation)Supreme Being - (14,329 reputation)Supreme Being - (14,329 reputation)Supreme Being - (14,329 reputation)Supreme Being - (14,329 reputation)Supreme Being - (14,329 reputation)

Group: Forum Members
Last Active: Tue 15 Jul 2014
Posts: 26, Visits: 67
Is there a way to discount all products.

e.g reduce all prices by 20%

Steve
Neil
 Posted Wed 28 Mar 2012
Supreme Being

Supreme Being - (123,567 reputation)Supreme Being - (123,567 reputation)Supreme Being - (123,567 reputation)Supreme Being - (123,567 reputation)Supreme Being - (123,567 reputation)Supreme Being - (123,567 reputation)Supreme Being - (123,567 reputation)Supreme Being - (123,567 reputation)Supreme Being - (123,567 reputation)

Group: Forum Members
Last Active: Sat 3 Nov 2018
Posts: 192, Visits: 5,220
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
Mohammad
 Posted Sun 1 Apr 2012
Kartris Expert

Kartris Expert - (78,917 reputation)Kartris Expert - (78,917 reputation)Kartris Expert - (78,917 reputation)Kartris Expert - (78,917 reputation)Kartris Expert - (78,917 reputation)Kartris Expert - (78,917 reputation)Kartris Expert - (78,917 reputation)Kartris Expert - (78,917 reputation)Kartris Expert - (78,917 reputation)

Group: Administrators
Last Active: Sun 27 Sep 2015
Posts: 115, Visits: 706
This functionality will be available in v1.4, not too long to be released.

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top