A Speed-Quote XML Import file (Mattel Version) has an <MAIN> tag as it's root tag, followed by a <PRODUCT_INFO> tag for each product to update/create.
The <PRODUCT_INFO> node has multiple child tags with only the <TOY_NUM> tag being required. The <TOY_NUM> tag (along with the optional <DASH_CODE> tag) is the database key columns that define a product in Speed-Quote. Most fields are simply child tags under the <PRODUCT_INFO> tag, but there are some exceptions. Please see the mattelspeedquotefields.xls excel file for complete information of all fields. You can also see an interactive version of the Master Entry Sheet that shows the Table/Field/XMLImport names at: http://www.apptastic.com/support/sqmasterinfo/sqmaster01.html
Some fields such as <WARRANTY_INCL> are boolean fields. The values for these tags can be the following:
Assortment information is added to the xml file by adding an <ASSORTMENT_INFO> tag and <ASSRTCHILD_XXX> child tags for an assortment products. For example:
<ASSORTMENT_INFO> <ASSRTCHILD_STYLENUM>12345</ASSRTCHILD_STYLENUM> <ASSRTCHILD_DESC>Assortment 1</ASSRTCHILD_DESC> <ASSRTCHILD_UPC>12345678901234</ASSRTCHILD_UPC> </ASSORTMENT_INFO> <ASSORTMENT_INFO> <ASSRTCHILD_STYLENUM>55445</ASSRTCHILD_STYLENUM> <ASSRTCHILD_DESC>Assortment 2</ASSRTCHILD_DESC> <ASSRTCHILD_UPC>12345678955567</ASSRTCHILD_UPC> </ASSORTMENT_INFO>
The preferred method of including addresses is to include a .addr file alongside the .xml file for import. More information can be found on the XML Import for Mattel Speed-Quote page.
Place the xml file and the addr file into the SQEnterprise/Admin/XMLImport/ folder on the server computer. Speed-Quote will create a new database or update an existing database using the basename of the xml file (e.g. MAPSdb.xml will create a database called MAPSdb).
The XML Import task schedule is set using the Speed-Quote Administration Tool as per our online manual: http://www.apptastic.com/manual/events.htm