So I am basically trying to create a small scale, specific to my business wep app / content management system, which will be used to manage information about my products.. The first step I need to figure out, is how I can upload an XML file containing a list of products to my MySql table. (this will primarily be product quantity and SKU information.
Im using Quickbooks point of sale and I have a program that extracts all my inventory data as an XML file, but basically, I cant track enough information in QBPOS or through my websites storefront provider (prostores), so I am trying first to update a MYSQL table containing basic product information, which will be overwritten by my XML file upload each day. (and then I will worry about the second table which will contain the actual product information additional details which will be linked to the first.)
Anyways - Onto the specifics.
My mysql table primary key = ProductSKU and the qty value is ProductQty
I will load the XML format all of my products are in below in the code section. But basically all I need is a simple form and a script that can connect to my mysql database, parse the XML file and update the mysql database with the loaded data.
<?xml version="1.0" encoding="UTF-8">