I am using Openbravopos and would like to keep track of current inventory.
So, I need a way to easily update the quantity of each product by running an import of a list of products using PRODUCT.CODE as the unique identifier.
I am using MySQL database.
So I need an import script that will do this:
For each product in the list, check if product exists in PRODUCT table by matching on CODE.
If product does not exist:
a) add product into PRODUCT table
b) update STOCKCURRENT and STOCKDIARY with Qty of product
If product exists:
a) update PRODUCT.PRICESELL with new selling price
b) update STOCKCURRENT and STOCKDIARY with additional Qty of product
Please bid only if you have experience with Openbravo POS.
When you bid, please explain whether you recommend to use SQL or PHP to write this script.