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.

 

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 ,
                      AgreementNumberQual? ,
                      AgreementNumber? ,
                      PromoAcceptInd? ,
                      PromoAppliedShowInd? ) >

                <!ELEMENT AssignedID                (#PCDATA) >
                <!ELEMENT OrderLevel                (#PCDATA) >
                <!ELEMENT RefIDQual                 (#PCDATA) >
                <!ELEMENT RefID                     (#PCDATA) >
                <!ELEMENT AgreementNumberQual       (#PCDATA) >
                <!ELEMENT AgreementNumber           (#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>10226038</RefID>
                  <AgreementNumberQual>VAN</AgreementNumberQual>
                  <AgreementNumber>3S5S PROMO</AgreementNumber>
            </LineInfo>
            <LineInfo>
                  <RefIDQual>VP</RefIDQual>
                  <RefID>10044868</RefID>
                  <AgreementNumber>0003724151</AgreementNumber>
            </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
AgreementNumberQual O Three character code identifying the Agreement Number type that was contained in the Price and Availability submit document.  It identifies the Agreement Number type that is contained in the proceeding <AgreementNumber> element. If passed empty then the proceeding <AgreementNumber> element will be considered as Promotion Number .
• ResponseVersion of 1.6 or higher
Value Meaning
VAN Vendor Agreement Number
UAN Promotion Number
{Empty} Promotion Number
A 3
AgreementNumber O The Promotion Number or the Vendor Agreement Number if VAN was used as AgreementNumberQual.
• ResponseVersion of 1.6 or higher
A/N 10
PromoAcceptInd O Obsolete, disregard this value A 1
PromoAppliedShowInd O Obsolete, disregard this value A 1
Summary O Obsolete, disregard this value
NbrOfSegments R Obsolete, disregard this value    
Note 1
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? ,
                    PromotedPricePerUnit? ,
                    PromoEndDate? ,
                    RequiredEndUserInfo? ,
                    RequiredLicenseInfo? ,
                    PromoAppliedInd? ,
                    ProductWeight? ,
                    ProductNotes? ,
                    ItemStatus? ,
                    VolumePricing? ,
                    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 PromotedPricePerUnit  (#PCDATA) >
                <!ELEMENT PromoEndDate          (#PCDATA) >
                <!ELEMENT RequiredEndUserInfo   (#PCDATA) >
                <!ELEMENT RequiredLicenseInfo   (#PCDATA) >
                <!ELEMENT PromoAppliedInd       (#PCDATA) >
                <!ELEMENT ProductWeight         (#PCDATA) >
                <!ELEMENT ProductNotes          (#PCDATA) >
                <!ELEMENT ItemStatus            (#PCDATA) >

                <!ELEMENT VolumePricing ( PriceLevel+ ) >

                    <!ELEMENT PriceLevel(
                          BeginQty ,
                          VolumePrice ) >

                    <!ELEMENT BeginQty          (#PCDATA) >
                    <!ELEMENT VolumePrice       (#PCDATA) >

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

                    <!ELEMENT IDCode            (#PCDATA) >
                    <!ELEMENT WhseCode          (#PCDATA) >
                    <!ELEMENT Qty               (#PCDATA) >
                    <!ELEMENT Qty2               (#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>000000000010226038</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>
            <PromotedPricePerUnit>$174.76</PromotedPricePerUnit>
            <PromoEndDate>01/31/2013</PromoEndDate>
            <ProductWeight>10.000</ProductWeight>  
            <ItemStatus> ACTIVE</ItemStatus>
            <WhseInfo>
                 <IDCode>SUWANEE, GA</IDCode>
                 <WhseCode>A021</WhseCode>
                 <Qty>4485</Qty>
                 <Qty2>440</Qty2>
                 <TotalOnOrderQty>10</TotalOnOrderQty>
                 <OnOrderQty>10</OnOrderQty>
                 <OnOrderETADate>11/30/03</OnOrderETADate>
            </WhseInfo>
            <WhseInfo>
                 <IDCode>SWEDESBORO, NJ</IDCode>
                 <WhseCode>A031</WhseCode>
                 <Qty>310</Qty>
                 <Qty2>12</Qty2>
                 <TotalOnOrderQty>110</TotalOnOrderQty>
             </WhseInfo>
             <WhseInfo>
                 <IDCode>FONTANA, CA</IDCode>
                 <WhseCode>A061</WhseCode>
                 <Qty>0</Qty>
                 <Qty2>0</Qty2>
            </WhseInfo>          
         </LineInfo>
   </Detail>
   <Summary>
       <NbrOfSegments></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 The customer’s base price N 15(2)
PriceIDCode2 O A fixed value of ‘MSR’ A 3
UnitPrice2 O Manufacturer’s Suggested Retail Price N 15(2)
PromotedPricePerUnit O The price of one of the items after the promotion has been applied N 15(2)
PromoEndDate O The last date the promotion is available. Promotions are available until the expiration date or while supplies last. N 10
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

• 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
ProductNotes O Product Notes associated with the requested item
• ResponseVersion of 1.8 or higher
A  
ItemStatus O Tech Data status of the requested item. Possible values include:
  • NEW
  • ACTIVE
  • PHASEDOUT
  • ALLOCATED
  • COMPONENTS
• ResponseVersion of 1.3 or higher
A 14
VolumePricing O Present it item has volume pricing
• ResponseVersion of 1.7 or higher
   
PriceLevel R Contains volume pricing information for the item
• ResponseVersion of 1.7 or higher
   
BeginQty R The beginning minimum quantity that must be ordered for volume pricing to be applicable
• ResponseVersion of 1.7 or higher
N 6
VolumePrice R The price of one of the items after this volume pricing has been applied
• ResponseVersion of 1.7 or higher
N 15(2)
WhseInfo O
IDCode R Warehouse location name, i.e. SUWANEE, GA, SWEDESBORO, NJ, 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 4
Qty O Quantity of item in the warehouse. N 15
Qty2 O Quantity of items that are in process in the warehouse.
• ResponseVersion of 1.9 or higher
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    
Note 1
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.
©2015 Tech Data Corporation. All Rights Reserved. Tech Data proprietary and confidential