Hi, I am currently designing a website using Zen-cart. Most of the website's design has gone through flawlessly. I have some relative knowledge of mysql and database structure. Enough to get by installing and configuring the website. But I have ran into a problem.
My problem is that most of the products I receive are via second party as I would be a parts dealer. I receive my parts from a dealer that I order off of. They send me the products in an xml format. I was wondering if there was anyway that I could possibly change the xml database format to fit into the mysql database of Zen-cart.


This is the link to my xml products. They are in a zip file at my website at http://www.d-lperformance.com/downloads/xmldatabase.zip

After you download the xml database you will knotice it is much different from the sql database, including many products (around thousands). This database is constantly being updated monthly. What I need is some way to convert them from that format (xml) to the sql database to show up on my website.

If you are looking at the xml files column D is the products name. The individual folders they are in are their categories (drivetrain, exterior, interior, misc, performance). Column C is their description and Column B is their Products Model. H is the units weight. I have the retail and then our price that deducts the price. (some addon I found on zen-cart). Column E would be the MSRP price then column F would be our price. If there could be any way of transferring these files to an easier readable layout for my database I would appreciate any suggestions. Thank you.

My website can be found at http://d-lperformance.com/store/