The objective it to do the following :
Replace available quantity and price from a local foxpro .DBF database to a online hosted Prestashop MySQL database on certain selected products,
User selectable family of products to do de query from, search that products and replace 2 fields , price and quantity to be replaced in mySQL database from local .DBF database data.
at the end, make a report of the changed products and the not found products, also report all product with a "0" inventory.
be able to select from .DBF database which products to do the export to SQL database
only the products from the selected ¨Families" should be considered
This should be programmed on an automated scrip so it runs periodically fromo our local server, 2003 windows server.
more details on the attached file