Announcement

Collapse
No announcement yet.

Imported products do not have their prices printed on tickets

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

    Imported products do not have their prices printed on tickets

    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
Working...
X