Top
Developers Your place to code all things handmade

Welcome to the Shopclues Developer Platform

We believe in code as craft. Join the community of developers, creators and build tools that enrich the ways you can shop, sell and connect with the India's largest merchant base most easily.

Get Started

Register, Upload, Search and Connect

Explore Shopclues' marketplace of over 8.5 million products from over 3.5 lakh merchants. Connect buyers with the items they'll love.

Learn More About Catalog Management

Login, Integrate and Create

Build the best tools for Shopclues merchants. Simply login, Integrate and start developing you own apps.

Learn More About Start Developing
<
>
Jump to: navigation, search

Get Order API

This API is used to view the list of all placed orders and to view the details of an already placed order.

Method= GET

Headers

Field name Description Mandatory
Header - “Authorization” Access token is passed to identify the user. Eg- ”Bearer bc1f461de4f193" Yes
Header - “Content-Type” Input Content Type here it would be “application/json" Yes

Response Fields Description

Sr.No Field Visibility Level Type Description
1. order_id Private Int Order ID of the order placed
2. is_parent_order Private Char Returns Y or N, which indicates whether or not it is a parent order
3. exempt_from_billing Private Int Flag status=1 means there will be no billing
Flag status=0 means the billing will be done
4. parent_order_id Private Int If there are multiple products(of different merchants) in an order,
the merchants are given respective child order id's and the parent
order id is provided to customer. Returns 0 if the products
are of a single merchant
5. company_id Private Int Company ID of the merchant
6. timestamp Private Int Time at which the order was placed in timestamp format
7. status Private Char Status of the order placed
8. total Private Float Total amount of the order placed
9. subtotal Private Float Total amount without discount and tax (if any)
10. s_city Private String Shipping city
11. s_state Private String Shipping state
12. s_zipcode Private Int Shipping zipcode
13. label_printed Private Char Returns Y or N, which indicates the label has been printed or not
14. gift_it Private Char Returns Y or N, which indicates whether or not the customer has opted

for gifting the order

15. firstname Private String First name of the user
16. lastname Private String Last name of the user
17. items_list Private JSON Array List of items in the order
18. credit_used Private Float Amount of credit used
19. product_name Private String Name of the product
20. product_id Private Int Product ID of the product placed in order
21. quantity Private Int Quantity of the products placed in the order.
22. selling_price Private Float Selling price of the product
23. payment_type Private String Payment option selected (COD or Prepaid)

Sample JSON Response

Details of Return Parameters

Fields Description
status API status
1: implies API responded successfully
0: implies validation failed
code
message Text response message
data Detailed information of the order with all required parameters.
extra It shows total records as well as pagination link
Total:
First:
Last:
Previous:
Next:

Using Filters

Get list of orders on the basis of defined filters by passing field names and values like this:

Filter Response Fields Description

Sr.No Field Name Value Link Sample
1. status status mapping bleow
http://sandbox.shopclues.com/api/v1/
order?status=N
2. sort_order 1) asc (Ascending order)
2)desc (Descending order)
http://sandbox.shopclues.com/api/v1/
order?sort_order=asc
3. time_from & time_to timestamp for both time_from and time_to http://sandbox.shopclues.com/api/v1/order?
time_from=1484908875&time_to=1484908875
5. E-mail http://sandbox.shopclues.com/api/v1/order?
email=anuj@gmail.com
6. cname Firstname http://sandbox.shopclues.com/api/v1/order?
cname=testname

Production URL -
 http://developer.shopclues.com/api/v1/order (All orders list) 
Sandbox environment-
 http://sandbox.shopclues.com/api/v1/order (All orders list) 

sample response

{ 
  "status": 1, 
  "code": 200, 
  "message": "success", 
  "data": [ 
    { 
      "order_id": "77037265", 
      "is_parent_order": "N", 
      "exempt_from_billing": "0", 
      "parent_order_id": "0", 
      "company_id": "14", 
      "timestamp": "1463038112", 
      "status": "N", 
      "total": "2798.00", 
      "subtotal": "2798.00", 
      "details": "", 
      "payment_id": "29", 
      "s_city": "delhi", 
      "s_state": "NCR", 
      "s_zipcode": "123456", 
      "label_printed": "n", 
      "gift_it": "N", 
      "firstname": "test order", 
      "lastname": "l test_name", 
      "items_list": [ 
        { 
          "credit_used": "0.00", 
          "product_name": "Ultra Luxury Classic Triple Hemstitch Pillow Sham Pair - CALMA", 
          "product_id": "31276", 
          "quantity": "2", 
          "selling_price": "1399.00", 
          "image_path": "cdn.shopclues.com/images/thumbnails/1/320/320/31276UltraLuxuryClassicTr1002050.000.CLM13218638874eca0acf81e34.png" 
        } 
      ], 
      "payment_type": "prepaid" 
    }, 
    { 
      "order_id": "77037264", 
      "is_parent_order": "N", 
      "exempt_from_billing": "0", 
      "parent_order_id": "0", 
      "company_id": "14", 
      "timestamp": "1463037470", 
      "status": "N", 
      "total": "2798.00", 
      "subtotal": "2798.00", 
      "details": "", 
      "payment_id": "29", 
      "s_city": "delhi", 
      "s_state": "NCR", 
      "s_zipcode": "123456", 
      "label_printed": "n", 
      "gift_it": "N", 
      "firstname": "test order", 
      "lastname": "l test_name", 
      "items_list": [ 
        { 
          "credit_used": "0.00", 
          "product_name": "Ultra Luxury Classic Triple Hemstitch Pillow Sham Pair - CALMA", 
          "product_id": "31276", 
          "quantity": "2", 
          "selling_price": "1399.00", 
          "image_path": "cdn.shopclues.com/images/thumbnails/1/320/320/31276UltraLuxuryClassicTr1002050.000.CLM13218638874eca0acf81e34.png" 
        } 
      ], 
      "payment_type": "prepaid" 
    }, 
    { 
      "order_id": "77037263", 
      "is_parent_order": "N", 
      "exempt_from_billing": "0", 
      "parent_order_id": "0", 
      "company_id": "14", 
      "timestamp": "1462964050", 
      "status": "N", 
      "total": "6198.00", 
      "subtotal": "6198.00", 
      "details": "", 
      "payment_id": "29", 
      "s_city": "delhi", 
      "s_state": "NCR", 
      "s_zipcode": "123456", 
      "label_printed": "n", 
      "gift_it": "N", 
      "firstname": "test order", 
      "lastname": "l test_name", 
      "items_list": [ 
        { 
          "credit_used": "0.00", 
          "product_name": "Everyday Luxury Satin Cuff KING SIZE Bed Sheet Set - CALMA", 
          "product_id": "31281", 
          "quantity": "2", 
          "selling_price": "3099.00", 
          "image_path": "cdn.shopclues.com/images/thumbnails/1/320/320/31281EverydayEssentialSati1002034.000.CLM13218638864eca0aceb5818.png" 
        } 
      ], 
      "payment_type": "prepaid" 
    } 
 ], 
  "extra": { 
    "total": "21", 
    "first": "", 
    "last": "", 
    "previous": "", 
    "next": "" 
  } 
}

Sample ERROR Response

{  
    "status": "401",  
    "message": "Error",  
    "data": null  
}

http://sandbox.shopclues.com/api/v1/order?field_name=value Note- Please replace field_name and value with the below mentioned Field Name and Value.

Status Maping Status mapping

"orders_status": [
      {
        "status": "1",
        "description": "RMA - Received",
        "definition": "Your returned product is received at the fulfilment centre"
      },
      {
        "status": "10",
        "description": "Cancellation Request By Customer - Other",
        "definition": "Order Cancellation requested by Customer\r\n"
      },
      {
        "status": "100",
        "description": "CBD–Payment Pending",
        "definition": "Any order that is placed using Cash Before Delivery payment option will move to CBD – Payment Pending"
      },
      {
        "status": "101",
        "description": "Cancellation Request by SC – CBD Not Confirmed",
        "definition": "Order for which payment is not confirmed after 120 hours. Refund will be initiated and customer will be informed"
      },
      {
        "status": "102",
        "description": "Canceled by SC – CBD Not Confirmed",
        "definition": "End status for CBD not confirmed order"
      },
      {
        "status": "103",
        "description": "NSS Order",
        "definition": ""
      },
      {
        "status": "104",
        "description": "Handed Over to Courier",
        "definition": "We have dispatched your order via our courier partner"
      },
      {
        "status": "105",
        "description": "EDD Breached",
        "definition": "The shipment of your ordered product is delayed and hence, would reach you post the expected delivery date"
      },
      {
        "status": "106",
        "description": "Handed over to Co-Loader",
        "definition": "After packaging, your product has been handed over to the courier partner for shipment"
      },
      {
        "status": "107",
        "description": "Order Confirmed-In StockRoom",
        "definition": "Any Advance inventory available in Stock Room can be processed faster through the stock room itself and can be processed same day"
      },
      {
        "status": "108",
        "description": "RTM Shipping label Printed",
        "definition": "Your returned product is made ready for dispatch to the merchant"
      },
      {
        "status": "109",
        "description": "RMA - RTM - Hold By Courier",
        "definition": "RTM shipment is on hold due to one of the following reasons:\r\n1. Merchant is not accepting.\r\n2. Merchant not reachable.\r\n3. Merchant was not found at the address given.\r\n4. Address mismatch"
      },
      {
        "status": "11",
        "description": "Cancellation Request By Merchant",
        "definition": "Merchant is unable to fulfill your Order and hence, it has been cancelled\r\n"
      },
      {
        "status": "110",
        "description": "RMA – RTM - Delivered to FC",
        "definition": "Your returned product has been shipped to the ShopClues Fulfilment Centre, due to non-delivery to the merchant\r\n"
      },
      {
        "status": "111",
        "description": "RMA - RTM Re-Attempted",
        "definition": "Your returned product is being shipped to the merchant"
      },
      {
        "status": "112",
        "description": "RMA - No Pick - Partial Refund",
        "definition": "Your return request is processed and the partial refund has been initiated"
      },
      {
        "status": "113",
        "description": "RMA – Shipment Hold at FC",
        "definition": "Returned order in Hold at ShopClues FC. Information shared with the seller to arrange pickup for the order"
      },
      {
        "status": "114",
        "description": "RMA – Shipment Return to Courier",
        "definition": "Returned order received Damaged/Missing/Empty/Wrong from courier. So shipment is handed over to courier and debited to courier partner"
      },
      {
        "status": "115",
        "description": "RMA - Pending with Claim Team",
        "definition": "This order status will be used when QC team at reverse FC is not sure to mark the shipment \"RMA-RTM Eligible\" or \"RMA RTM Not Eligible\" as shipment got damaged in forward transit and debit confirmation is pending with claim team. This stage will give claim team some time for investigation so that or"
      },
      {
        "status": "116",
        "description": "Received at CC",
        "definition": ""
      },
      {
        "status": "117",
        "description": "Delivery Confirmed by Customer",
        "definition": "Product is delivered and customer confirmed the delivery before filing the return"
      },
      {
        "status": "118",
        "description": "Cancellation Request by SC - HTC Delay",
        "definition": "Cancellation request is initiated as the merchant is not able to dispatch the product(Within SLA) after manifest."
      },
      {
        "status": "119",
        "description": "RMA Shipped Back to Customer",
        "definition": "Return Order- Shipped"
      },
      {
        "status": "12",
        "description": "Canceled by Merchant",
        "definition": "Merchant is unable to fulfill your Order and hence, it has been cancelled\r\n"
      },
      {
        "status": "120",
        "description": "RMA Delivered To Customer",
        "definition": "Return Order-Delivered"
      },
      {
        "status": "121",
        "description": "Cancellation Request By Merchant - OOS",
        "definition": ""
      },
      {
        "status": "122",
        "description": "Cancelled by Merchant - OOS",
        "definition": ""
      },
      {
        "status": "123",
        "description": "Order-On Hold",
        "definition": ""
      },
      {
        "status": "124",
        "description": "Dispatched to India by International Merchant",
        "definition": "In-Transit"
      },
      {
        "status": "125",
        "description": "In Transit Delay - Heavy Rain/ Fog/Bad Weather",
        "definition": ""
      },
      {
        "status": "126",
        "description": "In Transit Delay - Shipment Misrouted",
        "definition": ""
      },
      {
        "status": "127",
        "description": "In Transit Delay - Natural Disaster",
        "definition": ""
      },
      {
        "status": "128",
        "description": "In Transit Delay - ODA Location/ Area Not Accessible",
        "definition": ""
      },
      {
        "status": "129",
        "description": "In Transit Delay - Political Disturbance/ Bandh / Strike",
        "definition": ""
      },
      {
        "status": "13",
        "description": "Canceled by Customer - Shipment Delays ",
        "definition": "Your Order cancellation request has been accepted"
      },
      {
        "status": "130",
        "description": "In Transit Delay - Security Checks",
        "definition": ""
      },
      {
        "status": "131",
        "description": "In Transit Delay - Vehicle breakdown",
        "definition": ""
      },
      {
        "status": "132",
        "description": "Delivery Attempted - Out Of Delivery Area",
        "definition": ""
      },
      {
        "status": "133",
        "description": "Delivery Attempted - Address Issue/Wrong Address",
        "definition": "Order Undelivered"
      },
      {
        "status": "134",
        "description": "Delivery Attempted - COD Not ready",
        "definition": "Delivery Attempted -COD Not ready"
      },
      {
        "status": "135",
        "description": "Delivery Attempted - Customer Not Available/Contactable ",
        "definition": "Delivery Attempted -Customer Not Contactable "
      },
      {
        "status": "136",
        "description": "Delivery Attempted - Customer Refused To Accept Delivery",
        "definition": "Refused to Accept Delivery"
      },
      {
        "status": "137",
        "description": "Delivery Attempted - Requested for Future Delivery",
        "definition": "Delivery Attempted -Requested for Future Delivery"
      },
      {
        "status": "138",
        "description": "Delivery Attempted - Requested For Open Delivery",
        "definition": ""
      },
      {
        "status": "139",
        "description": "Delivery Attempted - Others",
        "definition": ""
      },
      {
        "status": "14",
        "description": "Canceled by Customer - COD",
        "definition": "Your Order with Cash On Delivery, has been cancelled, upon your request"
      },
      {
        "status": "19",
        "description": "Canceled by ShopClues - NSS Delivery",
        "definition": "Your Order has been cancelled since the address is flagged as Non-Serviceable Station (NSS) by our courier partner"
      },
      {
        "status": "20",
        "description": "Canceled by ShopClues - NSS Pick-Up",
        "definition": "NSS - Cancelled by SC because of no serviceability by courier partners"
      },
      {
        "status": "21",
        "description": "Canceled by ShopClues - COD Not Confirmed",
        "definition": "No confirmation was received on your COD order and hence, it has been cancelled"
      },
      {
        "status": "22",
        "description": "Canceled by ShopClues - Fraud Alert",
        "definition": "The Order could has been cancelled, for it is flagged as Fraud Alert by our banking partners"
      },
      {
        "status": "23",
        "description": "Canceled by ShopClues - Excess Sold - Backorder",
        "definition": "Your Order has been canceled by ShopClues due to insufficient inventory with the merchant"
      },
      {
        "status": "24",
        "description": "Canceled by ShopClues - OSLA ",
        "definition": "Due to delay in processing your Order, it has been cancelled"
      },
      {
        "status": "25",
        "description": "Canceled by ShopClues - Policy Violation by Seller",
        "definition": "Your Order has been cancelled by ShopClues as no confirmation was received from the merchant"
      },
      {
        "status": "26",
        "description": "ShopClues Exception - Lost",
        "definition": "The Order has been cancelled as it could not be traced at the Fulfilment Center"
      },
      {
        "status": "27",
        "description": "MilkRun Received - on Hold",
        "definition": "We are packing your order for shipment "
      },
      {
        "status": "28",
        "description": "MilkRun Complete - On Hold",
        "definition": "We are performing a Quality Check on your order"
      },
      {
        "status": "29",
        "description": "RTO  - RTM Complete Reused",
        "definition": "When we reuse the product for different order is so original order would be in stage of  RTO-RTM complete Reused"
      },
      {
        "status": "3",
        "description": "RTM - Complete",
        "definition": "Your return request has been processed and the product has been delivered to the merchant"
      },
      {
        "status": "30",
        "description": "RMA - RTM Not Eligible",
        "definition": "Your Order's return process has been completed"
      },
      {
        "status": "31",
        "description": "RTO - RTM Not Eligible",
        "definition": "When we recived Damaged or empty product from courier and not eligible to returned the product back to merchant"
      },
      {
        "status": "32",
        "description": "MilkRun Handover By Merchant",
        "definition": "The Order is being processed and has been picked up from the merchant"
      },
      {
        "status": "33",
        "description": "MilkRun Received at Fulfillment Center",
        "definition": "Your Order has reached our fulfillment centre, after being picked from the merchant"
      },
      {
        "status": "34",
        "description": "Cancellation Request by SC - NSS Delivery",
        "definition": "The Order is kept on hold, as the serviceability to the address is not confirmed by our courier partner"
      },
      {
        "status": "35",
        "description": "Cancellation Request by SC - NSS Pick-Up",
        "definition": "Your Order has been cancelled, as the address is not serviceable by our courier partner"
      },
      {
        "status": "36",
        "description": "Cancellation Request by SC - Incomplete Order Information",
        "definition": "Since complete information was not shared while placing the order, it is kept on hold"
      },
      {
        "status": "37",
        "description": "Cancellation Request by SC - OSLA",
        "definition": "Cancellation has been initiated by ShopClues as there is a slight delay in processing your Order"
      },
      {
        "status": "38",
        "description": "Canceled by ShopClues - Policy Violation by Buyer",
        "definition": "Due to violation of policies, followed by ShopClues, your Order has been cancelled"
      },
      {
        "status": "39",
        "description": "Cancellation Request  by SC - Excess Sold/Backorder",
        "definition": "Order is kept on hold, due to insufficient inventory"
      },
      {
        "status": "4",
        "description": "RTO Rejected by Merchant",
        "definition": "The returned product(s) have been rejected by the merchant and are received at our Fulfilment Centre"
      },
      {
        "status": "40",
        "description": "Cancellation Request by Customer - COD",
        "definition": "The cancellation request for your COD Order has been received and will be processed"
      },
      {
        "status": "41",
        "description": "Cancellation Request by Customer - Other (Self Service)",
        "definition": "Cancellation request of your Order, with reason selected as: 'Other' is received"
      },
      {
        "status": "42",
        "description": "Cancellation Request by SC - Fraud Alert",
        "definition": "Due to 'Fraud Alert' by our banking partners, we are verifying your Payment details, while keeping the Order on hold"
      },
      {
        "status": "43",
        "description": "Cancellation Request by SC - COD Not Confirmed",
        "definition": "ShopClues is initiating a Cancellation request, since no confirmation is received on your COD Order"
      },
      {
        "status": "44",
        "description": "Cancellation Request by ShopClues - Policy Violation by Buyer",
        "definition": "Cancellation request has been initiated, due to policy violation at your end"
      },
      {
        "status": "45",
        "description": "Cancellation Request by SC - Policy Violation by Seller",
        "definition": "Your Order's cancellation request has been initiated, due to no response from the merchant"
      },
      {
        "status": "46",
        "description": "Cancellation Request by SC - Wrong HTC",
        "definition": "Cancellation on your Order has been initiated, since it could not be traced after being shipped"
      },
      {
        "status": "47",
        "description": "Cancellation Request by ShopClues - Shipment Delay",
        "definition": "Cancellation has been initiated by ShopClues, due to delay in transit"
      },
      {
        "status": "48",
        "description": "Cancellation Request by ShopClues - Wrong Address Delivery",
        "definition": "Cancelled by SC because of Wrong address delivery"
      },
      {
        "status": "49",
        "description": "Cancellation Request by ShopClues - Empty Box",
        "definition": "Cancelled by SC because the box was empty"
      },
      {
        "status": "5",
        "description": "RMA Rejected by ShopClues",
        "definition": "Your return request is declined, because either the Order is not covered under Buyer Protection, or the returned product (or it's condition) differs from the Buyer's claim"
      },
      {
        "status": "50",
        "description": "Cancellation Request by ShopClues - Shipment Lost",
        "definition": "Cancellation request is generated to your Order, since the product is lost in transit"
      },
      {
        "status": "51",
        "description": "Canceled by ShopClues - Wrong HTC",
        "definition": "Your Order has been cancelled because the product could not be traced during transit"
      },
      {
        "status": "52",
        "description": "Canceled by ShopClues - Shipment Delay",
        "definition": "Order is canceled by ShopClues because shipment is getting delayed"
      },
      {
        "status": "53",
        "description": "Canceled by ShopClues - Wrong Address Delivery",
        "definition": "Cancelled by SC because of Wrong address delivery"
      },
      {
        "status": "54",
        "description": "Canceled by ShopClues - Empty Box",
        "definition": "Cancelled by SC because the box delivered was empty."
      },
      {
        "status": "55",
        "description": "Cancellation Request by Customer - OSLA",
        "definition": "Cancellation request is received, due to delay in order processing.\r\n"
      },
      {
        "status": "56",
        "description": "Canceled by Customer - OSLA",
        "definition": "Your Order is cancelled, as requested, due to delay in order processing"
      },
      {
        "status": "57",
        "description": "RMA Initiated",
        "definition": "We have initiated the Return of your Order."
      },
      {
        "status": "58",
        "description": "RMA Approved",
        "definition": "We have approved your Return Request"
      },
      {
        "status": "59",
        "description": "RMA Picked-Up",
        "definition": "Your requested return has been picked up by our courier partner"
      },
      {
        "status": "6",
        "description": "RMA - NoPick",
        "definition": "We have approved your Return Request. Your Refund amount will be credited to you soon."
      },
      {
        "status": "60",
        "description": "RMA Replaced",
        "definition": "Replacement of the requested order is completed"
      },
      {
        "status": "61",
        "description": "RMA to be Refunded",
        "definition": "Depricated orders state."
      },
      {
        "status": "62",
        "description": "RMA Refunded",
        "definition": "Depricated orders state."
      },
      {
        "status": "64",
        "description": "RMA Manifested",
        "definition": "Your returned Order has been packed for dispatch to the merchant"
      },
      {
        "status": "65",
        "description": "RMA Shipped to Merchant",
        "definition": "The Order returned has been shipped to the merchant"
      },
      {
        "status": "66",
        "description": "RMA Rejected by Merchant",
        "definition": "Your returned product is delivered, but rejected by the merchant"
      },
      {
        "status": "67",
        "description": "RMA Complete",
        "definition": "Return requested on your Order is completed"
      },
      {
        "status": "68",
        "description": "RMA Salvaged",
        "definition": "It is an end state. Where we have sold or scrapped the order to an external vendor."
      },
      {
        "status": "69",
        "description": "RTO to be Refunded",
        "definition": "We have initiated the refund on your undelivered/returned order"
      },
      {
        "status": "7",
        "description": "RTO - ReAttempted",
        "definition": "Prepaid Order was returned due to nondelivery. The original order is moved to ReAttempted and a clone order is created and shipped to the Buyer again."
      },
      {
        "status": "70",
        "description": "RTO Refunded",
        "definition": "The amount on your underlivered/returned Order is being refunded to your account\r\n"
      },
      {
        "status": "72",
        "description": "Shipped Untraceable",
        "definition": "Your Order has been shipped, but it is not yet traceable on our Courier Partner's website"
      },
      {
        "status": "73",
        "description": "Canceled by SC - Incomplete Order Information",
        "definition": "Order has been canceled due to Incomplete information provided by you"
      },
      {
        "status": "74",
        "description": "Cancellation request by SC - Other ",
        "definition": "Order Cancellation request has been initiated, due to reason marked as 'Other'"
      },
      {
        "status": "75",
        "description": "Canceled by ShopClues - Other",
        "definition": "Order has been canceled due to the reason selected as 'Other'"
      },
      {
        "status": "78",
        "description": "RTO - RTM Eligible",
        "definition": "Your Order, which could not be delivered, is checked for quality and being returned to the merchant"
      },
      {
        "status": "79",
        "description": "RTO Delivered to Merchant",
        "definition": "Your Order, being undelivered, has been returned to the merchant"
      },
      {
        "status": "80",
        "description": "RMA Delivered to Merchant",
        "definition": "Your returned product has been delivered to the merchant"
      },
      {
        "status": "81",
        "description": "RMA - RTM Eligible",
        "definition": "Your returned product is checked for quality and is eligible for dispatch to the merchant"
      },
      {
        "status": "82",
        "description": "EDD Breach Alert",
        "definition": "There is a slight delay in shipment of your Order, in transit"
      },
      {
        "status": "83",
        "description": "Cancellation Request by Customer - Shipment Delay",
        "definition": "Cancellation request to your Order is received and in-process, due to delay in shipment"
      },
      {
        "status": "84",
        "description": "Canceled by ShopClues - Shipment Lost",
        "definition": "Your Order has been cancelled, since the product is lost in transit"
      },
      {
        "status": "85",
        "description": "RTO Complete",
        "definition": "Return request complete"
      },
      {
        "status": "86",
        "description": "MilkRun Mild Delay",
        "definition": "We are facing a delay in procuring your Order from the merchant"
      },
      {
        "status": "87",
        "description": "Merchant Manifest Delay",
        "definition": "We are facing a procurement delay with your order from our merchant’s end."
      },
      {
        "status": "88",
        "description": "MilkRun Delay OSLA",
        "definition": "We are facing an extended delay in procuring your Order from the merchant."
      },
      {
        "status": "89",
        "description": "Merchant Manifest OSLA",
        "definition": "We are facing an extended delay in procuring your Order from the merchant."
      },
      {
        "status": "9",
        "description": "RTO Shipped to Merchant",
        "definition": "Your undelivered/returned product has been shipped to merchant & is in transit"
      },
      {
        "status": "90",
        "description": "Cancellation Request by SC - OSLA (Auto)",
        "definition": "The Order has been kept on hold and Cancellation request has been initiated, due to procurement delay from the merchant"
      },
      {
        "status": "91",
        "description": "Canceled by SC - OSLA (Auto)",
        "definition": "Order has been cancelled due to delay in procurement of the product"
      },
      {
        "status": "92",
        "description": "COD Confirmed (Auto)",
        "definition": "Your Order with Cash on Delivery has been confirmed"
      },
      {
        "status": "93",
        "description": "COD - Confirmed (PGW Failure)",
        "definition": "We have confirmed your Order with Cash on Delivery, due to prepaid payment failure"
      },
      {
        "status": "94",
        "description": "Returned from Courier Hub",
        "definition": "Sometimes a shipment is returned to us by courier due to non-servicability of destination or Airlines/Courier Policies that disallow the product from traveling to the destination address. These orders are then re-shipped via different courier or alternate routes. "
      },
      {
        "status": "95",
        "description": "Canceled by SC - Wrong Price",
        "definition": "Order is Canceled by ShopClues due to wrong price on product"
      },
      {
        "status": "96",
        "description": "Cancellation Request by SC - Wrong Price",
        "definition": "Cancellation request has been initiated by ShopClues, due to wrong price on product"
      },
      {
        "status": "97",
        "description": "RMA - RTM Shipment Lost by Courier",
        "definition": ""
      },
      {
        "status": "98",
        "description": "RMA - RTM Shipment Lost by FC",
        "definition": ""
      },
      {
        "status": "99",
        "description": "RMA - Shipment Lost by Courier",
        "definition": ""
      },
      {
        "status": "A",
        "description": "Shipped",
        "definition": "Your order is in transit"
      },
      {
        "status": "B",
        "description": "Backordered",
        "definition": "Your order is kept on hold due to insufficient inventory of the product"
      },
      {
        "status": "C",
        "description": "Complete",
        "definition": "Upon confirmation, your Order has been delivered successfully"
      },
      {
        "status": "D",
        "description": "Declined",
        "definition": "You order has been declined"
      },
      {
        "status": "E",
        "description": "MilkRun Initiated",
        "definition": "Your order is confirmed. We have informed the Merchant to process your order"
      },
      {
        "status": "F",
        "description": "Failed",
        "definition": "For some reason, your payment could not be remitted successfully"
      },
      {
        "status": "G",
        "description": "MilkRun Complete",
        "definition": "Your order is received at our Fulfilment Centre. We have done a Quality Check. Now, it is ready to be shipped."
      },
      {
        "status": "H",
        "description": "Delivered",
        "definition": "We have received delivery confirmation from our courier partner"
      },
      {
        "status": "I",
        "description": "Canceled by Customer - Other",
        "definition": "Order cancelled by you, due to reason, mentioned as 'Other'"
      },
      {
        "status": "J",
        "description": "Return To Origin",
        "definition": "Your order has been returned to origin"
      },
      {
        "status": "K",
        "description": "Payment Pending",
        "definition": "Payment not confirmed or authorized"
      },
      {
        "status": "L",
        "description": "Manifested",
        "definition": "Processing Done! Your Order is ready for dispatch"
      },
      {
        "status": "M",
        "description": "Refunded",
        "definition": "Order amount refunded for your order"
      },
      {
        "status": "N",
        "description": "Checkout Incomplete",
        "definition": "We have not received the payment of your Order"
      },
      {
        "status": "O",
        "description": "Open",
        "definition": "Your Confirmation for Cash on Delivery order is pending"
      },
      {
        "status": "P",
        "description": "Paid",
        "definition": "Payment is successfully done"
      },
      {
        "status": "Q",
        "description": "COD - Confirmed",
        "definition": "Your Order is confirmed with Cash on Delivery"
      },
      {
        "status": "R",
        "description": "RTO - Received",
        "definition": "Post unsuccessful attempts of delivery of your product(s), the Order has been returned at our fulfillment Centre"
      },
      {
        "status": "S",
        "description": "RMA",
        "definition": "Your return request has been approved"
      },
      {
        "status": "U",
        "description": "ShopClues Rejects - legacy",
        "definition": ""
      },
      {
        "status": "V",
        "description": "Paid - On Hold",
        "definition": "Your payment is processed, however, until its validation, the Order is kept on Hold"
      },
      {
        "status": "W",
        "description": "RTO - Manifested",
        "definition": "Your undelivered/returned product is packed and is ready to be dispatched to the merchant"
      },
      {
        "status": "X",
        "description": "Shipped - Exception",
        "definition": "Order is cancelled by ShopClues, due to other reason.\r\n"
      },
      {
        "status": "Y",
        "description": "Canceled by ShopClues",
        "definition": "Your Order has been cancelled by ShopClues"
      },
      {
        "status": "Z",
        "description": "Canceled - Order Transfer",
        "definition": "Order is transferred to another merchant, since the current merchant was unable to fulfill the same"
      }
    ]
Sandbox URL:
 http://sandbox.shopclues.com/api/v1/order?status=N&sort_order=desc&email=anuj@gmail.com&cname=test order&time_from=1462867608&time_to=1462867627 

Sample JSON Response </pre> {

 "status": 1,
 "code": 200,
 "message": "success",
 "data": [
   {
     "order_id": "77037264",
     "is_parent_order": "N",
     "exempt_from_billing": "0",
     "parent_order_id": "0",
     "company_id": "14",
     "timestamp": "1463037470",
     "status": "N",
     "total": "2798.00",
     "subtotal": "2798.00",
     "details": "",
     "payment_id": "29",
     "s_city": "delhi",
     "s_state": "NCR",
     "s_zipcode": "123456",
     "label_printed": "n",
     "gift_it": "N",
     "firstname": "test order",
     "lastname": "l test_name",
     "items_list": [
       {
         "credit_used": "0.00",
         "product_name": "Ultra Luxury Classic Triple Hemstitch Pillow Sham Pair - CALMA",
         "product_id": "31276",
         "quantity": "2",
         "selling_price": "1399.00",
         "image_path": "cdn.shopclues.com/images/thumbnails/1/320/320/31276UltraLuxuryClassicTr1002050.000.CLM13218638874eca0acf81e34.png"
       }
     ],
     "payment_type": "prepaid"
   }
 ],
 "extra": {
   "total": null,
   "first": "",
   "last": "",
   "previous": "",
   "next": ""
 }

} </pre>

Looking for ShopClues Apps?

Check out our new
App Gallery!

It's the best way to find cool and useful tools built upon Shopclues's API.