Thanks, Stefan, I really appreciate your consideration & assistance with this.
Chinavasion's product database process is comprehensive, to say the least. The API & Datafeed resource links on their website may assist you with a solution:
CSV & XML FORMATTED DATA FILES
Chinavasion Data Feeds, RSS, API & Product Status Log
Chinavasion API Overview
Register For API Access & Key
Chinavasion API FAQ
Seriously, the XML & CSV versions of the product data (from Chinavasion itself) look a whole lot more workable & standardised to me than data files I've accessed from numerous other merchants — direct from their websites or through their affiliate network.
But then, you guys are the database/code gurus, not me!
See how you go, ta.
PS Happy New Year!