Bah! The lack of a mySQL or any other type of SQL structure for FoxyCart’s XML datafeed on this great interwebs has prompted me to post the one I created. Feel free to use it. Save some precious time.
This FoxyCart to mySQL db design should be viewed mainly as a solid start (I certainly modified it past this) and also as a good representation of FoxyCart’s version .8 XML datafeed in a usable database structure. If you found this by searching Google, then you know what you’re looking at and know what to do with it… if otherwise, just email me. I’m glad to help.