Sandfield Order

Orders are passed through in the following Xml format.   These orders will be uploaded into the specified system (Unleashed, TradeGecko, Dear Inventory, Cin7, Shopify, Magento). 

One order can be for multiple stores, or an order can be for a single store.   All elements are required unless stated otherwise. 

Partner codes will be provided on request

<Order>

  <PartnerCode>PartnerCode</PartnerCode>

  <System>System Sending to (Dear In this case)</System>

  <OrderNumber>Order Number</OrderNumber>

  <ReferenceNumber>Unique reference number if different to order number</ReferenceNumber>

  <CustomerReference>Reference number given to Customer</CustomerReference>

  <InvoiceNumber>Populate if specific invoice number is required to go back</InvoiceNumber>

  <OrderDate>Date of Ordered</OrderDate>

  <Status>Current Status</Status>

  <DespatchAdviceSent></DespatchAdviceSent>

  <InvoiceSent></InvoiceSent>

  <DueDate></DueDate>

  <SubTotal>Order Total Without Tax</SubTotal>

  <TaxTotal>Order Tax Total</TaxTotal>

  <Total>Order Total with Tax</Total>

  <Currency>Currency code used</Currency>

  <TaxRate>Tax Rate for Order (0.2 for 20%)</TaxRate>

  <TaxCode>Tax Code in Dear if required (EG, VAT)</TaxCode>

  <DropShip></DropShip>

  <ShippingMethod>Shipment method required (eg, next day delivery)</ShippingMethod>

  <ETD>Estimated date of delivery</ETD>

  <ETA>Estimated date of arrival</ETA>

  <PaymentDueDate>Date the Payment is due by</PaymentDueDate>

  <ShipmentDueDate>Date the shipment is due by</ShipmentDueDate>

  <CustomerCode>Populate if relating to specific customer within Dear system</CustomerCode>

  <WarehouseCode>Populate if you want to use a specific warehouse listed within Dear system</WarehouseCode>

  <RetailerSupplierNumber></RetailerSupplierNumber>

  <DepartmentNumber></DepartmentNumber>

  <Comments>Order Comments</Comments>

  <ContractNumber></ContractNumber>

  <Store>

    <StoreCode>Delivery Address code (aka Uniquie Key)</StoreCode>

    <Name></Name>

    <Address1></Address1>

    <Address2></Address2>

    <City></City>

    <PostalCode></PostalCode>

    <State></State>

    <Country></Country>

    <Phone></Phone>

    <DCCode></DCCode>

    <StoreOrder>

      <StoreOrderNumber>Unique Order Number if the item going to multiple addresses</StoreOrderNumber>

      <StoreOrderStatus>Current Status for this order</StoreOrderStatus>

      <Notes></Notes>

      <StoreOrderProduct>

        <OrderLineNumber>Line Number (1, 2, 3, etc)</OrderLineNumber>

        <QuantityOrdered>Quantity Ordered</QuantityOrdered>

        <LineTax>Line Tax</LineTax>

        <LineTotal>Line Total</LineTotal>

        <LineProductPrice>Line Unit Price</LineProductPrice>

        <LineDiscount>Line Discount (if required)</LineDiscount>

        <Batch></Batch>

        <ExpiryDate></ExpiryDate>

        <PromotionStartDate></PromotionStartDate>

        <GiftWrap></GiftWrap>

        <Comments>Comments for the specific product</Comments>

        <ReturnMethod></ReturnMethod>

        <LinePackSize></LinePackSize>

        <SystemOrderLineItemID>Unique ID in your system for your product if you have an ID different to the product code</SystemOrderLineItemID>

        <Product>

          <SystemProductCode></SystemProductCode>

          <SupplierProductCode></SupplierProductCode>

          <PurchaserProductCode></PurchaserProductCode>

          <SKU></SKU>

          <Price>Unit Price</Price>

          <RetailPrice></RetailPrice>

          <WarehousePrice></WarehousePrice>

          <Description></Description>

          <Weight></Weight>

          <Volume></Volume>

          <UnitOfMeasure>Unit of measure type (Eg, box, EA for each, CA for Case, etc)</UnitOfMeasure>

          <TaxRule>Tax Charge on Product (eg 0.2 for 20%)</TaxRule>

          <PackSize>QTY Per Pack</PackSize>

          <IndividualPackCode></IndividualPackCode>

          <BuyersCatalogNumber></BuyersCatalogNumber>

        </Product>

      </StoreOrderProduct>

  <StoreOrderProduct>

        <OrderLineNumber>Line Number (1, 2, 3, etc)</OrderLineNumber>

        <QuantityOrdered>Quantity Ordered</QuantityOrdered>

        <LineTax>Line Tax</LineTax>

        <LineTotal>Line Total</LineTotal>

        <LineProductPrice>Line Unit Price</LineProductPrice>

        <LineDiscount>Line Discount (if required)</LineDiscount>

        <Batch></Batch>

        <ExpiryDate></ExpiryDate>

        <PromotionStartDate></PromotionStartDate>

        <GiftWrap></GiftWrap>

        <Comments>Comments for the specific product</Comments>

        <ReturnMethod></ReturnMethod>

        <LinePackSize></LinePackSize>

        <SystemOrderLineItemID>Unique ID in your system for your product if you have an ID different to the product code</SystemOrderLineItemID>

        <Product>

          <SystemProductCode></SystemProductCode>

          <SupplierProductCode></SupplierProductCode>

          <PurchaserProductCode></PurchaserProductCode>

          <SKU></SKU>

          <Price>Unit Price</Price>

          <RetailPrice></RetailPrice>

          <WarehousePrice></WarehousePrice>

          <Description></Description>

          <Weight></Weight>

          <Volume></Volume>

          <UnitOfMeasure>Unit of measure type (Eg, box, EA for each, CA for Case, etc)</UnitOfMeasure>

          <TaxRule>Tax Charge on Product (eg 0.2 for 20%)</TaxRule>

          <PackSize>QTY Per Pack</PackSize>

          <IndividualPackCode></IndividualPackCode>

          <BuyersCatalogNumber></BuyersCatalogNumber>

        </Product>

      </StoreOrderProduct>

    </StoreOrder>

<BillToAddress>

<StoreCode>BillTo Address code (aka Uniquie Key)</StoreCode>

<Name></Name>

<Address1></Address1>

<Address2></Address2>

<City></City>

<PostalCode></PostalCode>

<State></State>

<Country>NZ</Country>

<Phone></Phone>

</BillToAddress>

  </Store>

  <Store>

    <StoreCode>Delivery Address code (aka Uniquie Key)</StoreCode>

    <Name></Name>

    <Address1></Address1>

    <Address2></Address2>

    <City></City>

    <PostalCode></PostalCode>

    <State></State>

    <Country></Country>

    <Phone></Phone>

    <DCCode></DCCode>

    <StoreOrder>

      <StoreOrderNumber>Unique Order Number if the item going to multiple addresses</StoreOrderNumber>

      <StoreOrderStatus>Current Status for this order</StoreOrderStatus>

      <Notes></Notes>

      <StoreOrderProduct>

        <OrderLineNumber>Line Number (1, 2, 3, etc)</OrderLineNumber>

        <QuantityOrdered>Quantity Ordered</QuantityOrdered>

        <LineTax>Line Tax</LineTax>

        <LineTotal>Line Total</LineTotal>

        <LineProductPrice>Line Unit Price</LineProductPrice>

        <LineDiscount>Line Discount (if required)</LineDiscount>

        <Batch></Batch>

        <ExpiryDate></ExpiryDate>

        <PromotionStartDate></PromotionStartDate>

        <GiftWrap></GiftWrap>

        <Comments>Comments for the specific product</Comments>

        <ReturnMethod></ReturnMethod>

        <LinePackSize></LinePackSize>

        <SystemOrderLineItemID>Unique ID in your system for your product if you have an ID different to the product code</SystemOrderLineItemID>

        <Product>

          <SystemProductCode></SystemProductCode>

          <SupplierProductCode></SupplierProductCode>

          <PurchaserProductCode></PurchaserProductCode>

          <SKU></SKU>

          <Price>Unit Price</Price>

          <RetailPrice></RetailPrice>

          <WarehousePrice></WarehousePrice>

          <Description></Description>

          <Weight></Weight>

          <Volume></Volume>

          <UnitOfMeasure>Unit of measure type (Eg, box, EA for each, CA for Case, etc)</UnitOfMeasure>

          <TaxRule>Tax Charge on Product (eg 0.2 for 20%)</TaxRule>

          <PackSize>QTY Per Pack</PackSize>

          <IndividualPackCode></IndividualPackCode>

          <BuyersCatalogNumber></BuyersCatalogNumber>

        </Product>

      </StoreOrderProduct>

    </StoreOrder>

  </Store>

</Order>