Sales Orders


GET OrderHistories

The GET orderHistories request allows the developer to retrieve past events from specific orders.

Request

Parameters Description Type Mandatory
ESPOrderNumber The Volo order number to be returned. Int Optional

Example Request

GET https://mydomain.esellerpro.com/eSellerProAPI/services/api/rs/orderHistories.json?EspOrderNumber=1001

Response

Name Description Type
ESPOrderNumber The Volo order number. Int
HistoryEntry Description = description of event | Type = event type | UserName = the user that actioned the event | TimeStamp = Time and date at which the event took place string

Example Response

{
   "responseStatus": "OK",
   "responseMessage": null,
   "timestamp": 1435572239035,
   "OrderHistories": {"OrderHistory": [   {
      "ESPOrderNumber": 1001,
      "HistoryEntry":       [
                  {
            "Description": "Invoice Number Allocated",
            "Type": "PRINTED",
            "UserName": null,
            "TimeStamp": 1409217324000
         },
                  {
            "Description": "Invoice Number Allocated: 41240",
            "Type": "NOTE",
            "UserName": null,
            "TimeStamp": 1409217324000
         },
                  {
            "Description": "Added a new OrderItem - 000-0125-38",
            "Type": "NOTE",
            "UserName": "support.acb:import",
            "TimeStamp": 1405689046000
         },

                  {
            "Description": "Added: 'Endura Out & Back' - 1 @ £ 12.00 (price was overridden)",
            "Type": "NOTE",
            "UserName": "support.sw",
            "TimeStamp": 1389784961000
         },
                  {
            "Description": "Manual Order Added",
            "Type": "ORDER_IN",
            "UserName": "support.sw",
            "TimeStamp": 1389784924000
         }
      ]
   }]}
}


GET orders

Request

Parameters Description Values Mandatory
newOrdersOnly Return new orders only. True = new orders only | False = all orders Boolean Optional
startDate To define orders returned in a specific date range DateTime Optional
endDate To define orders returned in a specific date range DateTime Optional
paidOnly To return orders that are in balance. 1 = paid | 0 = all orders Boolean Optional
EntriesPerPage The number of orders to return in the request Int Optional
PageNumber Used with the EntriesPerPage arg to determine which orders are returned. Int Optional
customerEmail To define orders returned by a specific customer email address String Optional
customerId To define orders returned by a specific customer ID Int Optional

Example Request

GET https://mydomain.esellerpro.com/eSellerProAPI/services/api/rs/orders.json?NewOrdersOnly=false&StartDate=2014-01-15T11:20:21.869+01:00&EndDate=2014-01-16T11:20:21.869+01:00

Response

Name Description Type
OrderType Fixed to 'Order'. string
ESPOrderNo The returned Volo order number(s). Int
InvoiceNumber The returned Volo invoice number(s). Int
ExternalReference The maketplace order number. string
Date The date that the order was placed returned as an Epoch value (ms since 01/01/1970 00:00:00). Int
CustomerCompany The buyers billing company name varchar
CustomerName The buyers billing full customer name varchar
CustomerAddress1 The buyers billing address line 1 varchar
CustomerAddress2 The buyers billing address line 2 varchar
CustomerCity The buyers billing city varchar
CustomerCounty The buyers billing county/state varchar
CustomerPostcode The buyers billing postcode/zipcode varchar
CustomerCountry The buyers billing country varchar
CustomerEmail The buyers email address varchar
CustomerNotes The buyer instructions/notes as populated at the marketplace checkout. varchar
DeliveryCompany The recipient's shipping company name varchar
DeliveryName The recipient's shipping full name varchar
DeliveryAddress1 The recipient's shipping address line 1 varchar
DeliveryAddress2 The recipient's shipping address line 2 varchar
DeliveryCity The recipient's shipping city varchar
DeliveryCounty The recipient's shipping county/state varchar
DeliveryPostcode The recipient's shipping postcode/zipcode varchar
DeliveryCountry The recipient's shipping country varchar
DeliveryTelephone The delivery phone number varchar
ShippingCost The total shipping amounr double
Insurance The total insurance amount paid by the customer double
Discount he total discount amount applied to the whole order double
OrderTotal The total order value double
PaymentComplete A true or false value to indicate whether the payment amount balances to the order total. String
Payments PaymentMethod, PaymentReference, PayPalProtectionEligibility - contained within the nested 'Payment' group varchar
CurrencyCode The ISO currency code e.g. GBP varchar
SellerUsername The seller account name where the order was placed. varchar
CourierProfileName The name given to the courier profile associated with the order. The courier profile contains data on courier, service, weight, package type, etc. and is usually assigned to orders based on the 'Courier Rules' matrix table. VarChar
WebProductID The website item referemce. varchar
StockNumber The Volo stock number contained in the order varchar
ItemNumber The marketplace item reference. int
ProductTitle The title of the product as populated on the given marketplace. varchar
Quantity The quantity or items ordered int
UnitCost The price of the item as paid for by the buyer. double
TaxRate The tax percentage amount as applied to the item e.g. 20 Int
UnitCostIncludesTax Y or N. Whether the UnitCost of the item value includes or excludes tax Boolean
Weight THe weight of the ordered item in grams int
BuyerId The buyer's marketplce account name varchar

Example Response

{
   "responseStatus": "OK",
   "responseMessage": null,
   "timestamp": 1435577347247,
   "OutgoingOrders": {"Order":    [
            {
         "OrderType": "Order",
         "ESPOrderNo": 1001,
         "InvoiceNumber": "41240",
         "ExternalReference": "",
         "Date": 1389784920000,
         "CustomerCompany": "",
         "CustomerName": "steveie",
         "CustomerAddress1": "example",
         "CustomerAddress2": "example",
         "CustomerCity": "example",
         "CustomerCounty": "example",
         "CustomerPostcode": "BS11 1NS",
         "CustomerCountry": "UK",
         "CustomerEmail": "example@example.com",
         "CustomerNotes": "",
         "DeliveryCompany": "",
         "DeliveryName": "example",
         "DeliveryAddress1": "example",
         "DeliveryAddress2": "example",
         "DeliveryCity": "example",
         "DeliveryCounty": "example",
         "DeliveryPostcode": "BS11 1NS",
         "DeliveryCountry": "UK",
         "DeliveryTelephone": "",
         "ShippingCost": 0,
         "Insurance": 0,
         "Discount": 0,
         "OrderTotal": 24,
         "PaymentComplete": false,
         "Payments": {"Payment": [         {
            "PaymentMethod": "Cheque",
            "PayPalProtectionEligibility": false
         }]},
         "CurrencyCode": "GBP",
         "OrderItems": {"Item":          [
                        {
               "WebProductID": "7862",
               "StockNumber": "000-0125-38",
               "ItemNumber": "0",
               "ProductTitle": "Endura Out & Back",
               "Quantity": 1,
               "UnitCost": 12,
               "TaxRate": 20,
               "UnitCostIncludesTax": "Y",
               "Weight": 1.6
            },
                        {
               "WebProductID": "7862",
               "StockNumber": "000-0125-38",
               "ItemNumber": "0",
               "ProductTitle": "Endura Out & Back",
               "Quantity": 1,
               "UnitCost": 12,
               "TaxRate": 0,
               "UnitCostIncludesTax": "Y",
               "Weight": 1.6
            }
         ]},
         "BuyerId": "CrazyCustomer_UK"
      }


PUT OrderHistories

The PUT OrderHistories method allows the developer to add notes/audit/event descriptions on specific orders.

Request

Parameters Description Type Mandatory
ESPOrderNumber The Volo order number to be returned. Int Optional
HistoryEntry Description = | Type = | Username = | TimeStamp = string Required

Response

Name Description Type
timestamp YYYY-MM-DDT11:38:23.539z string
ESPOrderNumber eSellerPro Order Number Int
HistoryEntry Description = description of event | Type = event type | UserName = the user that actioned the event | TimeStamp = Time and date at which the event took place string


PUT orders

The PUT orders request allows the developer to action an order in a number of ways. Depending on the parameters used in the request, it's possible to update the order status, add courier and/or tracking information or simply add notes. The request should be made by parsing XML.

Request

Parameters Description Type Mandatory
ESPOrderNo The Volo order number to update Int Required
OrderStatus Update the order to the defined status. Accepted values are; WAITING_FOR_DELIVERY, DELIVERED, CANCELLED or ON_HOLD String Optional
OnHoldNotes Updates the order status to 'On Hold' and adds an 'On Hold' reason to the order. String Optional
Courier Adds the courier name when the order is marked as delivered. The courier must be available within the 'Courier' dropdown list within the Sales Orders > Order Processing screen. String Optional
CourierService Not currently in use. String Optional
CourierTracking Used to specificy the tracking number for the order. String Optional
Notes Used to add notes internal to orders. String Optional

Example Request

<IncomingOrdersUpdate>
   <OrderUpdate>
      <ESPOrderNo>5440</ESPOrderNo>
      <OrderStatus>DELIVERED</OrderStatus>
      <OnHoldNotes>test order deliver</OnHoldNotes>
      <CourierTracking>7723744fdfg4s4</CourierTracking>
      <Notes>api note</Notes>
   </OrderUpdate>
</IncomingOrdersUpdate>

Example Response

{
   "responseStatus": "OK",
   "responseMessage": "Updated 1 orders.",
   "timestamp": 1436189621605
}