Unshipped Orders from a Specific Profile


When to Use

  • To retrieve order data only on orders that have not yet shipped.

    • Recommend use of Export Status to help manage imported vs not yet imported orders.
  • See more on all the options for filtering, querying, expanding data under the Getting and Filtering Data page.

Resource URL / Endpoint

GET https://api.channeladvisor.com/v1/Orders?$filter=ShippingStatus eq 'Unshipped' and ProfileID eq ProfileID

Important and/or Required Parameters

PropertyRequiredNote
$filter=ShippingStatus eq 'Unshipped'RequiredRequired to fulfill goal. Include in URL. Defines the first property to be filtered (ShippingStatus) should equal 'Unshipped'.
andRequiredRequired to fulfill goal. Include in URL. Allows for an additional filter to be applied.
ProfileID eq ProfileIDRequired

Required to fulfill goal. Include in URL. Defines the second property to be filtered (ProfileID) should equal ProfileID.
Replace this value with numeric integer representing the Profile ID.

Example Request
GET https://api.channeladvisor.com/v1/Orders?access_token=xxxxxxxxxx&$filter=ShippingStatus eq 'Unshipped' and ProfileID eq 12345678
Example Response (Success)
200 OK
{
  "@odata.context": "https://api.channeladvisor.com/v1/$metadata#Orders",
  "value": [
    {
      "ID": 19918546,
      "ProfileID": 12345678,
      "SiteID": 576,
      "SiteName": "eBay Fixed Price US",
      "SiteOrderID": "19918546",
      "SecondarySiteOrderID": "",
      "SellerOrderID": null,
		// Additional fields omitted
      "Items": [
        {
          "ID": 22235854,
          "ProfileID": 12345678,
          "OrderID": 19918546,
          "ProductID": 22120969,
          "SiteOrderItemID": "",
          "SiteListingID": "AuctionId_57915f23-4333-4e6d-80c7-7d1df32e93b1",
          "Sku": "CG0001",
          "Title": "Colby Germond Create Test Product CG0001",
          "Quantity": 5,
          "UnitPrice": 50,
			// Additional fields omitted
        }
      ],
      "Fulfillments": [
        {
          "ID": 11280613,
          "ProfileID": 12345678,
          "OrderID": 19918546,
          "CreatedDateUtc": "2016-02-12T14:54:39Z",
          "UpdatedDateUtc": "2016-02-12T14:52:41.077Z",
          "Type": "Ship",
          "DeliveryStatus": "NoChange",
          "TrackingNumber": null,
          "ShippingCarrier": "eBay",
          "ShippingClass": "Standard",
          "DistributionCenterID": 149,
          "ShippedDateUtc": null,
          "SellerFulfillmentID": null
			// Additional fields omitted
        }
      ]
    }
}