It is possible to change the prices of all your products in SellerDeck EPOS by a percentage, such as if you want to increase the price of all your products by 5%. See the steps below to do this (You will need Microsoft Access):
Use the following SQL on data.mdb, all instances of the value '1.05' should be replaced with the desired
percentage (5% rise: 1.05).
If you find any problems as a result of this SQL, revert to your backup immediately.
Use the following SQL on data.mdb, all instances of the value '1.05' should be replaced with the desired
percentage (5% rise: 1.05).
- First, backup all 6 EPOS databases. (Instructions here)
- Close Down SellerDeck EPOS on all PC’s
- On the main database EPOS PC, open Windows Explorer
- Browse to: C:\checkout
- Right click on “data.mdb”, and select “Open With” | “Microsoft Office Access”.
- Go to 'View | Database Objects | Queries
- Click 'New'
- Select 'Design' view
- Click 'close' on the 'Show Table' window
- Then go to 'View | SQL view'
- Copy and paste the SQL statement below into the page, replacing “SELECT;” if that is already in the page:
UPDATE tblProduct_BarCode SET
tblProduct_BarCode.Region1 = tblProduct_BarCode!Region1*1.05,
tblProduct_BarCode.Wholesale = [tblProduct_BarCode]![Wholesale]*1.05,
tblProduct_BarCode.Region2 = [tblProduct_BarCode]![Region2]*1.05,
tblProduct_BarCode.Region3 = [tblProduct_BarCode]![Region3]*1.05,
tblProduct_BarCode.Region4 = [tblProduct_BarCode]![Region4]*1.05,
tblProduct_BarCode.Region5 = [tblProduct_BarCode]![Region5]*1.05,
tblProduct_BarCode.Region6 = [tblProduct_BarCode]![Region6]*1.05,
tblProduct_BarCode.Trade = [tblProduct_BarCode]![Trade]*1.05,
tblProduct_Barcode.RRP = tblProduct_Barcode.RRP *1.05,
tblProduct_Barcode.OnlinePrice = tblProduct_Barcode.OnlinePrice *1.05;
- To run the query, go to 'Query | Run'
- Now close the SQL query Window
- Close the Access Database
If you find any problems as a result of this SQL, revert to your backup immediately.