PrintPrice and Availability


Price and Availability Submit DTD

This service can be used to obtain both the availability and price of an item(s).  The availability that is returned is the same information that would be received in an Availability response document.  The price this is returned is your contract price with Tech Data for commercial resale.  If you participate in markets such as government or education, you can also receive those prices via XML. To obtain price and availability information for a product, you must create a Price and Availability submit data structure formatted according to the supplied Document Type Definition.

Note:
  Users can also use the PriceList transaction as an alternative to Price and Availability. PriceList returns the same data as this transaction along with all possible pricing options available as well as promotion details.

 

The following DTD defines the Price and Availability Submit document:

  <!ELEMENT XML_PriceAvailability_Submit (
      Header ,
      Detail ,
      Summary? ) >

    <!ELEMENT   Header (
                UserName ,
                Password ,
                TransControlID? ,
                ResponseVersion? ) >

        <!ELEMENT UserName                          (#PCDATA) >
        <!ELEMENT Password                          (#PCDATA) >
        <!ELEMENT TransControlID                    (#PCDATA) >
        <!ELEMENT ResponseVersion                   (#PCDATA) >

        <!ELEMENT Detail ( LineInfo+ ) >
            <!ELEMENT LineInfo (
                      AssignedID? ,
                      OrderLevel? ,
                      RefIDQual ,
                      RefID ,
                      PromoAcceptInd? ,
                      PromoAppliedShowInd? ) >

                <!ELEMENT AssignedID                (#PCDATA) >
                <!ELEMENT OrderLevel                (#PCDATA) >
                <!ELEMENT RefIDQual                 (#PCDATA) >
                <!ELEMENT RefID                     (#PCDATA) >
                <!ELEMENT PromoAcceptInd            (#PCDATA) >
                <!ELEMENT PromoAppliedShowInd       (#PCDATA) >

 
Following is an example of a Price and Availability submit document:

  <XML_PriceAvailability_Submit>
      <Header>
            <UserName>INSERT_ID_HERE</UserName>  
            <Password>INSERT_PASSWORD_HERE</Password>
            <ResponseVersion>1.4</ResponseVersion>
      </Header>
      <Detail>
            <LineInfo>
                  <RefIDQual>VP</RefIDQual>
                  <RefID>296460</RefID>
            </LineInfo>
            <LineInfo>
                  <RefIDQual>VP</RefIDQual>
                  <RefID>180054</RefID>
            </LineInfo>
      </Detail>
  </XML_PriceAvailability_Submit>


Note:
  XML should be used as a supplement to the Product Catalog found on Tech Data’s Web site.  The Product Catalog is updated every business day and the download can be automated with the getprod.exe utility.  The Product Catalog is also available via an EDI 832 transaction. 
XML should
not
 be used for updating your entire electronic catalog database.
  Tech Data reserves the right to restrict access to the XML service for customers who do not use this service appropriately.

Price and Availability Submit Data Fields

The following table provides a detail description of each element defined in the XML_PriceAvailability_Submit.dtd

Element Name
Optional
Required
Description
Data
Type
Max Len
Header R
UserName R EC logon ID assigned by Tech Data A/N Note 1
Password R Password assigned by Tech Data A/N Note 1
TransControlID O Unique tracking identifier assigned by the customer for each Price and Availability document submitted A/N 100
ResponseVersion O Designates the Response DTD version that will be returned.
  • If omitted, the oldest supported Response DTD version is returned
  • In order to receive the latest functionality, you should specify the “highest” available (newest) Response DTD version number
  • Using older version numbers will generate legacy Response documents with reduced data content and functionality
A/N 20
Detail R
LineInfo R Minimum of 1 per Price and Availability submit document is required, but multiple are allowed
AssignedID O Unique tracking identifier assigned by the customer for each detail line (item) requested within the Price and Availability submit document A/N 100
OrderLevel O This element is only used when Government or Education pricing is desired. 

Order Level codes for U.S. Customers

Value Meaning
EF Education (Student & Staff)
EH Education (Higher)
EL Education (K-12)
ER Education (Erate)
FE Federal
FG Federal GSA
ST State
MD Medical

Order Level codes for Canadian Customers

Value Meaning
EF Education (Student & Staff)
EH Education (Higher)
EL Education (K-12)
FE Federal
LO Local
PR Provincial
A 2
RefIDQual R Two character code identifying the part number type that was contained in the Price and Availability submit document.  It identifies the part number type that is contained in the proceeding <RefID> element.
Value Meaning
VP Tech Data item number
BP Buyer Part (customer’s) item number
MG Manufacturer’s item number
UP UPC (Universal Product Code)
A 2
RefID R The item number A/N 20
PromoAcceptInd O A Y/N value which indicates whether or not promotions will be accepted A 1
PromoAppliedShowInd O A Y/N value which indicates whether or not the response will show where promotions have been applied, (using the PromoAppliedInd) A 1
Summary O Obsolete, no longer needed
NbrOfSegments R Obsolete (being phased out), disregard this value    
The actual maximum length is not documented.  Include on each XML document submitted the UserName and Password values assigned by your Master/Admin user.

Price and Availability Response DTD

The following DTD defines the Price and Availability Submit document:

<!ELEMENT XML_PriceAvailability_Response (
      Header ,
      Detail ,
      Summary ) >

      <!ELEMENT   Header (
                  TransSetIDCode ,
                  TransControlID? ,
                  ResponseVersion? ) >

          <!ELEMENT TransSetIDCode              (#PCDATA) >
          <!ELEMENT TransControlID              (#PCDATA) >
          <!ELEMENT ResponseVersion             (#PCDATA) >

      <!ELEMENT   Detail ( LineInfo+ ) >
          <!ELEMENT LineInfo (
                    AssignedID? ,
                    RefIDQual1? ,
                    RefID1? ,
                    RefIDQual2? ,
                    RefID2? ,
                    RefIDQual4? ,
                    RefID4? ,
                    ProductDesc? ,
                    PriceIDCode1? ,
                    UnitPrice1? ,
                    PriceIDCode2? ,
                    UnitPrice2? ,
                    RequiredEndUserInfo? ,
                    RequiredLicenseInfo? ,
                    PromoAppliedInd? ,
                    ProductWeight? ,
                    ItemStatus? ,
                    WhseInfo* ,
                    ErrorInfo* ) >

                <!ELEMENT AssignedID            (#PCDATA) >
                <!ELEMENT RefIDQual1            (#PCDATA) >
                <!ELEMENT RefID1                (#PCDATA) >
                <!ELEMENT RefIDQual2            (#PCDATA) >
                <!ELEMENT RefID2                (#PCDATA) >
                <!ELEMENT RefIDQual4            (#PCDATA) >
                <!ELEMENT RefID4                (#PCDATA) >
                <!ELEMENT ProductDesc           (#PCDATA) >
                <!ELEMENT PriceIDCode1          (#PCDATA) >
                <!ELEMENT UnitPrice1            (#PCDATA) >
                <!ELEMENT PriceIDCode2          (#PCDATA) >
                <!ELEMENT UnitPrice2            (#PCDATA) >
                <!ELEMENT RequiredEndUserInfo   (#PCDATA) >
                <!ELEMENT RequiredLicenseInfo   (#PCDATA) >
                <!ELEMENT PromoAppliedInd       (#PCDATA) >
                <!ELEMENT ProductWeight         (#PCDATA) >
                <!ELEMENT ItemStatus            (#PCDATA) >

                <!ELEMENT WhseInfo (
                          IDCode ,
                          WhseCode? ,
                          Qty ,
                          TotalOnOrderQty? ,
                          OnOrderQty? ,
                          OnOrderETADate? ) >

                    <!ELEMENT IDCode            (#PCDATA) >
                    <!ELEMENT WhseCode          (#PCDATA) >
                    <!ELEMENT Qty               (#PCDATA) >
                    <!ELEMENT TotalOnOrderQty   (#PCDATA) >
                    <!ELEMENT OnOrderQty        (#PCDATA) >
                    <!ELEMENT OnOrderETADate    (#PCDATA) >
               
                <!ELEMENT ErrorInfo (
                          RefIDQual3 ,
                          RefID3 ,
                          ErrorDesc ) >

                    <!ELEMENT RefIDQual3        (#PCDATA) >
                    <!ELEMENT RefID3            (#PCDATA) >
                    <!ELEMENT ErrorDesc         (#PCDATA) >

    <!ELEMENT Summary ( NbrOfSegments ) >
        <!ELEMENT NbrOfSegments                 (#PCDATA) >


Following is an example of a Price and Availability response document sent from the XML system:

<XML_PriceAvailability_Response>
   <Header>
       <TransSetIDCode>846REC</TransSetIDCode>
       <TransControlID>10000</TransControlID>
       <ResponseVersion>1.4</ResponseVersion>
   </Header>
   <Detail>
       <LineInfo>
            <AssignedID>001</AssignedID>
            <RefIDQual1>VP</RefIDQual1>
            <RefID1>180054</RefID1>
            <RefIDQual2>MG</RefIDQual2>
            <RefID2>GSX-230</RefID2>
            <ProductDesc>GSX-230 24-PIN PRINTER</ProductDesc>
            <PriceIDCode1>CON</PriceIDCode1>
            <UnitPrice1>$194.18</UnitPrice1>
            <PriceIDCode2>MSR</PriceIDCode2>
            <UnitPrice2>$299.00</UnitPrice2>
            <ProductWeight>10.000</ProductWeight>  
            <ItemStatus> ACTIVE</ItemStatus>
            <WhseInfo>
                 <IDCode>MIAMI, FL</IDCode>
                 <WhseCode>A1</WhseCode>
                 <Qty>4485</Qty>
                 <TotalOnOrderQty>10</TotalOnOrderQty>
                 <OnOrderQty>10</OnOrderQty>
                 <OnOrderETADate>11/30/03</OnOrderETADate>
            </WhseInfo>
            <WhseInfo>
                 <IDCode>SWEDESBORO, NJ</IDCode>
                 <WhseCode>A3</WhseCode>
                 <Qty>310</Qty>
                 <TotalOnOrderQty>110</TotalOnOrderQty>
             </WhseInfo>
             <WhseInfo>
                 <IDCode>FONTANA, CA</IDCode>
                 <WhseCode>A6</WhseCode>
                 <Qty>0</Qty>
            </WhseInfo>          
         </LineInfo>
   </Detail>
   <Summary>
       <NbrOfSegments>9</NbrOfSegments>
   </Summary>
</XML_PriceAvailability_Response>

Price and Availability Response Data Fields

The following table provides a detail description of each element defined in the XML_PriceAvailability_Response.dtd

Element Name
Optional
Required
Description
Data
Type
Max Len
Header
TransSetIDCode R Fixed value of ‘846REC’ A/N 6
TransControlID O Unique tracking identifier assigned by the customer for each Price and Availability submit document submitted. The content of the element sent by the customer within the XML document is returned as is to the customer within the Response document.  The primary function of these types of elements is for tracking purposes. A/N 100
ResponseVersion O Designates the Response DTD version A/N 20
Detail
LineInfo R For each item number (<RefID>) submitted, one LineInfo node will be returned
AssignedID O Unique tracking identifier assigned by the customer for each detail line (item) requested within the Price and Availability document. The content of the element sent by the customer within the XML message is returned as is to the customer within the Response document.  The purpose of this element is for tracking purposes. A/N 100
RefIDQual1 O Two character code identifying the part number type that was contained in the Price and Availability submit document.  It identifies the part number type that is contained in the following <RefID1> element. 
Value Meaning
VP Tech Data item number
BP Buyer Part (customer’s) item number. See Note 1 at the end of this  table.
MG Manufacturer’s item number
UP UPC (Universal Product Code)
A 2
RefID1 O The item number A/N 20
RefIDQual2 O Two character code identifying the part number type that was contained in the Price and Availability submit document.  It identifies the part number type that is contained in the following <RefID2> element. 
Value Meaning
VP Tech Data item number
BP Buyer Part (customer’s) item number. See Note 1 at the end of this  table.
MG Manufacturer’s item number
UP UPC (Universal Product Code)
A 2
RefID2 O This element will contain the manufacturer’s part number when preceded by a <RefIDQual2> value of ‘MG’ A/N 20
RefIDQual4 O Two character code identifying the part number type that was contained in the Price and Availability submit document.  It identifies the part number type that is contained in the following <RefID4> element. 
Value Meaning
VP Tech Data item number
BP Buyer Part (customer’s) item number. See Note 1 at the end of this  table.
MG Manufacturer’s item number
UP UPC (Universal Product Code)
• ResponseVersion of 1.3 or higher
A 2
RefID4 O Alternate part number for which an availability request is being submitted.
• ResponseVersion of 1.3 or higher
A/N 20
ProductDesc O Description of requested item A/N 50
PriceIDCode1 O A fixed value of ‘CON’ A 3
UnitPrice1 O Customer’s price N 15(2)
PriceIDCode2 O A fixed value of ‘MSR’ A 3
UnitPrice2 O Manufacturer’s Suggested Retail Price N 15(2)
RequiredEndUserInfo O A Y/N value which indicates if end user information would be required or not when an order for this item is submitted. This element is ALWAYS populated.
Value Meaning
Y End user information is required when ordering this item
N End user information is not required
DIRECT SHIPMENTS (DROP SHIPMENTS) FROM VENDOR NOT ALLOWED The item can not be ordered in drop ship (warehouse 99) mode
INVALID SHIP TO SUFFIX, CONTACT EC SUPPORT An error exists with your customer information, contact EC support to have it corrected
CREDIT CARD ORDERS NOT ALLOWED FOR DIRECT VENDOR SHIPMENTS (DROP SHIPMENTS) Credit cards can not be used when ordering this item in drop ship mode

• ResponseVersion of 1.3 or higher
A 1
RequiredLicenseInfo O A Y/N value which indicates if end user license information would be required or not when an order for this item is submitted.
Value Meaning
Y End user information is required
N End user information is not required
This element is only populated when the requested item was specified with a government/education order level in the Price and Availability submit.
• ResponseVersion of 1.3 or higher
A 1
PromoAppliedInd O A Y/N value which indicates whether or not promotions were applied
• ResponseVersion of 1.3 or higher
A 1
ProductWeight O Weight of the requested item
• ResponseVersion of 1.3 or higher
N 9
ItemStatus O Tech Data status of the requested item. Possible values include:
  • NEW
  • ACTIVE
  • PHASED OUT
  • ALLOC
  • COMPON
  • DIS-TD
  • DIS-VN
  • SP-ORD
• ResponseVersion of 1.3 or higher
A 6
WhseInfo O
IDCode R Warehouse location name, i.e. MIAMI, FL, NORCROSS, GA, etc. For a complete list of Tech Data’s logistic centers, refer to the Warehouse Codes heading found in the Order submit section. A/N 25
WhseCode O Tech Data warehouse identifier.  For a complete list of Tech Data’s logistic centers, refer to the Warehouse Codes heading found in the Order submit section of this document.
• ResponseVersion of 1.4 or higher
A/N 2
Qty O Quantity of item in the warehouse.
  • A negative value indicates the item is on back order
  • 9999 indicates warehouse 99
  • -9999 indicates limited availability so you will have to call Sales
N 15
TotalOnOrderQty O The total number on order for the warehouse.
• ResponseVersion of 1.3 or higher
N 12
OnOrderQty O The earliest Expected-To-Arrive quantity for the warehouse. Is a sub-set of TotalOnOrderQty.
• ResponseVersion of 1.3 or higher
N 10
OnOrderETADate O The earliest Expected-To-Arrive date for the warehouse. (format mm/dd/yy)
• ResponseVersion of 1.3 or higher
A/N 8
ErrorInfo
RefIDQual3 O A fixed value of  ‘1Q’ A/N 2
RefID3 O A fixed value of  ‘0’ N 1
ErrorDesc O Error description A/N 250
Summary
NbrOfSegments R Obsolete, disregard this value    
If Buyer Part numbers are to be submitted, contact your Tech Data Sales team to have your Buyer Part number to Tech Data Item number cross-reference established on our system.
©2005 Tech Data Corporation. All Rights Reserved. Tech Data proprietary and confidential