November 6th, 2013, 07:45 AM
Sync EPOS Database with Mysql database Problem
I have an EPOS till software which I use in my business premises and have the option to sync it with my online shops database remotely. The idea being if I sell an item in my bricks and mortar shop it updates the product totals on my on-line shop and vice versa.
The problem I have is the EPOS software needs to sync with the product price, product id and product quantity but not all this information is in one table.
The product id and quantity are in the "ps_stock_available" table and the product id, quantity and price are in the a"ps_stock" table.
The problem is that it's the quantity field in "ps_stock_available" that actually updates the quantities but this table does not contain the product price.
Is there some way to enable my EPOS database and on-line database sync properly given that the information required is in 2 different tables.
November 6th, 2013, 09:08 AM
try using a view that contains the necessary join query
(except that this only syncs in one direction, from mysql out)
November 6th, 2013, 09:33 AM
Originally Posted by r937
Just read the help file again for the EPOS software (EPOS Excel) and the info below explains it a lot better. I hope this helps with solving the problem.