Help & Resource Center

TylerNet Integration XML Files

Overview

Modern Retail's integration with TylerNet passes XML file back and forth to synchronize the data between TylerNet and the store's website.  For an explanation of how this integration works, please read:

The purpose of this article is to describe the fields being used in the integration and the key decisions that need to be answered to make the integration work for a particular store's implementation.

Key Decisions

The following key decisions need to be determined when setting up a new store:

  1. Retail Price Field
    • Need to ask the store which Price Field is being used for the main retail price on the website.  This will either be Price Field 16, 17, 18, 19, 20 or 21. This field will be mapped to the retail price on the website.
  2. Sale Price Field
    • Need to ask the store which Price Field is being used for the sale price on the website.  This will either be Price Field 16, 17, 18, 19, 20 or 21. This field will be mapped to the sale price on the website.
  3. Inventory Fields
    • Need to determine if the "company" QOH field will be used or the individual "store" QOH fields should be used.  If the retailer has multiple locations, then the "store" fields will be used.

Once the above questions are answered, Modern Retail can map the appropriate fields to get TylerNet integrated with your ecommerce platform.

Product Fields & Feed

The following XML file is sent from TylerNet to Modern Retail's FTP server so products and inventory can be updated on the website.

  • <Inventory>
  • <Product>
  • <ItemNumber></ItemNumber>
    • Unique key used to identify the product.  ItemNumber must be sent when sending order information TylerNet.
  • <UPC></UPC>
    • Universal Product Code (UPC) is a barcode symbology that is widely used in the United States, Canada, the United Kingdom, and many other countries for tracking goods in stores.
  • <MFGPartNumber></MFGPartNumber>
    • This is the manufacture's part number, also known as Field 26 in TylerNet.
  • <MFGGeneric></MFGGeneric>
  • <Description></Description>
    • Main description of the product.
  • <Description2></Description2>
    • Secondary description of the product.
  • <BrandCode></BrandCode>
  • <BrandName></BrandName>
  • <DepartmentCode></DepartmentCode>
  • <DepartmentName></DepartmentName>
  • <ProductTypeCode></ProductTypeCode>
  • <ProductTypeName></ProductTypeName>
  • <Cost></Cost>
    • This is the Unit Cost of the product.
  • <SellingPrice1></SellingPrice1>
    • This maps to Price Field 16 in TylerNet.
  • <SellingPrice2></SellingPrice2>
    • This maps to Price Field 17 in TylerNet.
  • <SellingPrice3></SellingPrice3>
    • This maps to Price Field 18 in TylerNet.
  • <SellingPrice4></SellingPrice4>
    • This maps to Price Field 19 in TylerNet.
  • <SellingPrice5></SellingPrice5>
    • This maps to Price Field 20 in TylerNet.
  • <SellingPrice6></SellingPrice6>
    • This maps to Price Field 21 in TylerNet.
  • <Priority></Priority>
    • Maps to Field 8 in TylerNet.
  • <CompanyAvailable></CompanyAvailable>
    • QOH for this product across all locations, excluding those products being used for promotional purposes.  Fro example, products that are currently being used for in-store displays will be subtracted from inventory.
  • <CompanyOnHand></CompanyOnHand>
    • QOH for this product across all locations, includes those products being used for promotional purposes.  In the above example it would include those products being used for in-store displays.
  • <Store>
    • The next 3 fields will be listed for every every store.  This allows us to know how much products are sitting in individual stores, which is useful when doing "in-store pickup".
  • <StoreID></StoreID>
    • Branch ID for the store that has the inventory.
  • <ONHand></ONHand>
    • QOH for this product in this store, includes those products being used for promotional purposes.
  • <Available></Available>
    • QOH for this product in this store, excludes those products being used for promotional purposes.
  • </Store>
  • </Product>
  • </Inventory>

Order Fields & Feed

Modern Retail creates the following XML file which is picked up and read by TylerNet so orders can be inserted into their system.

  • <Ticket>
  • <TylerTicket xmlns="TylerTicketContainer">
  • <TicketDate></TicketDate>
    • Required, Max Length = 19
    • Ticket Date CCYY-MM-DDThh:mm:ss
  • <Branch></Branch>
    • Required, Max Length = 4
    • Branch number that will process the order
  • <TicketNumber></TicketNumber>
    • Required, Max Length = 8
    • Web Order Number
  • <TicketType>DD</TicketType>
    • Required, Max Length = 2
    • Set TicketType to DD
  • <DeliveryDate></DeliveryDate>
    • Not Required, Max Length = 8
    • Delivery Date (CCYYMMDD)
  • <Salesman></Salesman>
    • Required, Max Length = 5
    • Sales Person Number
  • <BillTo>
    • Required
    • NOTE: If no Ship to Address is given, it will assume the Bill to Address is the ship to address.
  • <CustomerNumber></CustomerNumber>
    • Required, Max Length = 11
    • Customer Master Number or Primary Phone Number
  • <CompanyPerson></CompanyPerson>
    • Not Required, Max Length = 1
    • P = Person
    • C = Company
  • <Name></Name>
    • Required, Max Length = 25
    • Bill To Name
  • <Address1></Address1>
    • Required, Max Length = 32
  • <Address2></Address2>
    • Not Required, Max Length = 25
  • <City></City>
    • Required, Max Length = 15
  • <State></State>
    • Required, Max Length = 2
  • <Zip></Zip>
    • Required, Max Length = 9
  • <HomePhone></HomePhone>
    • Required, Max Length = 11
  • <CellPhone></CellPhone>
    • Not Required, Max Length = 11
  • <WorkPhone></WorkPhone>
    • Not Required, Max Length = 11
  • <Email></Email>
    • Required, Max Length = 40
  • </BillTo>
  • <ShipTo>
    • Not Required
    • NOTE: If no Ship to Address is given, it will assume the Bill to Address is the ship to address.
  • <CustomerNumber></CustomerNumber>
  • <CompanyPerson></CompanyPerson>
  • <Name></Name>
    • Required, Max Length = 25
    • Ship To Name
  • <Address1></Address1>
    • Required, Max Length = 32
  • <Address2></Address2>
    • Not Required, Max Length = 25
  • <City></City>
    • Required, Max Length = 15
  • <State></State>
    • Required, Max Length = 2
  • <Zip></Zip>
    • Required, Max Length = 9
  • <HomePhone></HomePhone>
    • Required, Max Length = 11
  • <CellPhone></CellPhone>
    • Not Required, Max Length = 11
  • <WorkPhone></WorkPhone>
    • Not Required, Max Length = 11
  • <Email></Email>
    • Required, Max Length = 40
  • </ShipTo>
  • <Payment>
  • <PaymentType></PaymentType>
    • Required
    • Payment Type = CHECK, CC or AR (Obviously for web orders it will be CC).
  • <Amount></Amount>
    • Required
  • <ARAccountNumber></ARAccountNumber>
    • Account Receivable Account Number, Max Length = 10
    • If PaymentType is AR, then this field is required.
  • <CheckNumber></CheckNumber>
    • Not Required
  • <CardType></CardType>
    • Required when PaymentType is CC, Max Length = 2
    • Credit Card Type = VI, MC, AX or DS,
  • <CCLast4></CCLast4>
    • Required when PaymentType is CC, Max Length = 4
    • Last 4 digit of credit card number.
  • <AuthNumber></AuthNumber>
    • Required when PaymentType is CC, Max Length = 6
    • Credit Card Authorization Number.
  • </Payment>
  • <ShipVia></ShipVia>
    • Not Required, Max Length = 6
    • Ship Via: UPS, FEDEX, USPS
  • <ShipType></ShipType>
    • Not Required, Max Length = 15
  • <Taxable></Taxable>
    • Required, Max Length = 1
    • Taxable = Y or N
  • <TaxCode></TaxCode>
      • Not Required
  • <TotalSale></TotalSale>
    • Required
    • Total Sale includes tax & shipping.
  • <TaxAmount></TaxAmount>
    • Required
    • Sale Tax Amount
  • <Freight></Freight>
    • Required
    • Shipping Amount
  • <PONumber></PONumber>
    • Not Required, Max Length = 16
    • Purchase Order Number
  • <TrackingNumber></TrackingNumber>
    • Not Required, Max Length = 30
    • Shipping Tracking Number
  • <SoldAtBranch></SoldAtBranch>
    • Required, Max Length = 4
  • <LineDetail>
    • Required
  • <LineNumber></LineNumber>
    • Required, Max Length = 3
    • Ticket Line Number
  • <Quantity></Quantity>
    • Required
  • <ItemNumber></ItemNumber>
    • Required, Max Length = 14
    • Item Number (If BarCode number is provided, then ItemNumber is not required.)
  • <UPC></UPC>
    • Not Required, Max Length = 14
  • <Description></Description>
    • Required, Max Length = 30
  • <PickUpBranch></PickUpBranch>
    • Not Required, Max Length = 4
  • <SellingPrice></SellingPrice>
    • Required
    • Price the item for on the website.
  • <SerialNumber></SerialNumber>
    • Not Required, Max Length = 15
  • </LineDetail>
  • </TylerTicket>
  • </Ticket>