Imported products do not have their prices printed on tickets

[G.W.Green]

After importing products into SellerDeck EPOS, you may find that products do not have their prices printed on tickets. See the solution to this below:

1. Close the EPOS program.
2. Take a back up copy of the Data.mdb file and keep somewhere safe.
3. To run the SQL:
4. Open Windows Explorer
5. Browse to: C:\Checkout
6. Open up “Data.mdb” in Access.
7. Go to 'View | Database Objects | Queries
8. Click 'New'
9. Select 'Design' view
10. Click 'close' on the 'Show Table' window
11. Then go to 'View | SQL view'
12. Copy and paste the SQL statement below into the page, replacing “SELECT;” if that is already in the page:
    
    UPDATE tblProduct SET Region = 1
    
    
13. To run the query, go to 'Query | Run'
14. Now close the SQL query Window
15. Do the same as above (from point 5) for another SQL:
    
    UPDATE tblProduct_Barcode SET Region = 1
    
    
16. Close the Access Database
17. Restart EPOS