HeavyTruckParts XML Export

From ISoft Wiki
Revision as of 15:08, 14 March 2014 by Broy (talk | contribs) (Created the first draft specification for the XML export to HTP.)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

We support a generalized XML export file for importing inventory into HeavyTruckParts.Net.

The commented specification. Tags are marked with brackets ([]) if they are optional. Contents and attributes are identified with "123" if they take numbers and "ABC123" for text strings.

<?xml version="1.0" ?>
<!-- Begin the export; the companyid is a company "product code" issued by ISoft -->
<export companyid="123"> 
    <!-- Begin the list of inventory; the version is the version of this XML specification you're using.  
         The exporttype is an advisory request as to whether this is a complete export, or a partial export. -->
    <inventory version="1.0" exporttype="partial/complete"> 

            <!-- Begin an inventory item.  Both the inventory id and the store id are optional but strongly recommended.
                 The inventoryid is a unique value that represents the inventory item in your inventory system.  
                 The storeid is the store number, if you have multiple stores, that the item comes from.  
                 If the inventoryid is 0 or unspecified, HTP will attempt to generate values for you.  
                 If the storeid is unspecified, HTP will use store 1. -->
            <item [inventoryid="123"] [storeid="123"]> 

            <!-- The optional tag number you use to refer to this inventory item.  
                 If this is not specified, HTP will use the inventory id of the item. -->
            [<tagnumber>ABC123</tagnumber>]

            <!-- The optional stock number of the vehicle this item has been pulled from -->
            [<vehiclestocknumber>123</vehiclestocknumber>] 

            <!-- The REQUIRED part type of this item.  typeid refers to the type number in ISoft's ITrack system.  
                 The text is a text description of that part type.  If you require a cross reference
                 from your types to ITrack types, contact ISoft Data Systems, for assistance. -->
            <parttype typeid="123">ABC123</parttype> 

            <!-- The optional year of manufacture for the part -->
            [<year>123</year>]

            <!-- The optional make of the vehicle the part came off of -->
            [<vehiclemake>ABC123</vehiclemake>]

            <!-- The optional model of the vehicle the part came off of -->
            [<vehiclemodel>ABC123</vehiclemodel>] 

            <!-- The optional manufacturer of this part, if appropriate -->
            [<partmanufacturer>ABC123</partmanufacturer>] 

            <!-- The optional model of this part, if appropriate -->
            [<partmodel>ABC123</partmodel>]

            <!-- A description of this part -->
            <description>ABC123</description>

            <!-- The category this part falls under, such as "USED", "OEM", "NEW", or "REMAN" -->
            [<category>ABC123</category>]

            <!-- The optional condition of the part -->
            [<condition>ABC123</condition>]

            <!-- Optional notes concerning the part; these aren't generally shown to users. -->
            [<notes>ABC123</notes>]

            <!-- The optional "side" the part belongs on: Left, Right, Both, or N/A.  
                 Values other than these will be ignored. -->
            [<side>ABC123</side>]

            <!-- Up to 4 of these optional tags may be specified.  
                   These are "more" fields or "Question and answer" fields, 
                   where "label" is the "question" and the content is the "answer" -->
            [<qa label="ABC123">ABC123</qa>]

             <!-- The optional VIN of the vehicle this item came off of -->
            [<vin>ABC123</vin>] 

            <!-- The optional OEM number of this item -->
            [<oemnumber>ABC123</oemnumber>] 

            <!-- The optional serial number of this item
            [<serialnumber>ABC213</serialnumber>]

            <!-- The REQUIRED quantity of this item on hand. -->
            <quantity>123</quantity>

            <!-- The optional cost of the item -->
            [<cost>123.123</cost>]

            <!-- The optional core price of the item -->
            [<coreprice>123.123</coreprice>]

            <!-- The optional wholesale price of the item -->
            [<wholesaleprice>123.123</wholesaleprice>]

            <!-- The REQUIRED retail price to be shown to users -->
            <retailprice>123.123</retailprice>
        </item>
    </inventory>
</export>


For the best results, specify at least the partmanufacturer and partmodel or vehiclemake and vehiclemodel. When a field is optional, it may be omitted, or included with empty contents. If you do not specify inventoryid values for all items, we only support complete exports, where all of your inventory will be removed from HeavyTruckParts.Net and replaced with the contents of the export file. If inventoryid values are specified for all items in the export, ISoft supports the concept of a "partial export," which can update items already listed, or add new items without affecting already uploaded inventory.


A sample export file with three items:

<export companyid="12345">
    <inventory version="1.0">
        <item inventoryid="1" storeid="1">
            <tagnumber>1</tagnumber>
            <vehiclestocknumber></vehiclestocknumber>
            <parttype typeid="3000">Engine Assembly</parttype>
            <year>2003</year>
            <vehiclemake>Freightliner</vehiclemake>
            <vehiclemodel>FLD120</vehiclemodel>
            <partmanufacturer>CAT</partmanufacturer>
            <partmodel>3306C</partmodel>
            <description>Good runner</description>
            <category>USED</category>
            <condition>Excellent</condition>
            <qa label="Jake">No</qa>
            <qa label="HP">230</qa>
            <vin>1234567890ABCDEF</vin>
            <oemnumber>ABC123</oemnumber>
            <serialnumber>123456789</serialnumber>
            <quantity>2</quantity>
            <cost>600.00</cost>
            <coreprice>200.00</coreprice>
            <wholesaleprice>800.00</wholesaleprice>
            <retailprice>1100.00</retailprice>
        </item>
        <item inventoryid="2" storeid="1">
            <tagnumber>2</tagnumber>
            <vehiclestocknumber>4</vehiclestocknumber>
            <parttype typeid="4000">Transmission Assembly</parttype>
            <year>1996</year>
            <vehiclemake>Freightliner</vehiclemake>
            <vehiclemodel>FLD120</vehiclemodel>
            <partmanufacturer>ROCKWELL</partmanufacturer>
            <partmodel>RM0-12A</partmodel>
            <description>Good runner</description>
            <category>USED</category>
            <condition>Excellent</condition>
            <notes></notes>
            <side></side>
            <qa label="Speed"></qa>
            <qa label="INPUT SHAFT"></qa>
            <qa label="pump"></qa>
            <qa label="BM#"></qa>
            <vin>1234567890ABCDEF</vin>
            <oemnumber>ABC123</oemnumber>
            <serialnumber>123456789</serialnumber>
            <quantity>1</quantity>
            <cost>575.00</cost>
            <coreprice></coreprice>
            <wholesaleprice>650.00</wholesaleprice>
            <retailprice>800.00</retailprice>
        </item>
        <item inventoryid="3" storeid="1">
            <tagnumber>TG123</tagnumber>
            <vehiclestocknumber></vehiclestocknumber>
            <parttype typeid="1200">Door Assembly, Front</parttype>
            <year></year>
            <vehiclemake>Ford</vehiclemake>
            <vehiclemodel>L7000</vehiclemodel>
            <partmanufacturer></partmanufacturer>
            <partmodel></partmodel>
            <description>LH door, ding in side</description>
            <category>USED</category>
            <condition>Good</condition>
            <notes></notes>
            <side>Left</side>
            <qa label="Color">Yellow</qa>
            <qa label="Power Window">No</qa>
            <vin></vin>
            <oemnumber></oemnumber>
            <serialnumber></serialnumber>
            <quantity>1</quantity>
            <cost>330.00</cost>
            <coreprice>0.00</coreprice>
            <wholesaleprice>500.00</wholesaleprice>
            <retailprice>600.00</retailprice>
        </item>
    </inventory>
</export>