Announcement

Collapse
No announcement yet.

Change all the prices of products in EPOS by a percentage

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Change all the prices of products in EPOS by a percentage

    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).

    1. First, backup all 6 EPOS databases. (Instructions here)
    2. Close Down SellerDeck EPOS on all PC’s
    3. On the main database EPOS PC, open Windows Explorer
    4. Browse to: C:\checkout
    5. Right click on “data.mdb”, and select “Open With” | “Microsoft Office Access”.
    6. Go to 'View | Database Objects | Queries
    7. Click 'New'
    8. Select 'Design' view
    9. Click 'close' on the 'Show Table' window
    10. Then go to 'View | SQL view'
    11. 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;

    12. To run the query, go to 'Query | Run'
    13. Now close the SQL query Window
    14. Close the Access Database


    If you find any problems as a result of this SQL, revert to your backup immediately.
Working...
X