What's New

Help Topics

Customer Support

Download Orders

Order download is a query you sent to Teapplix, which will return a list of "Order" JSON data to be returned from the body.

Method and Endpoint

Order download uses "GET" REST method, and the URL is the same as inbound "OrderNotification":

https://api.teapplix.com/api2/OrderNotification

Parameters

Parameters to limit which orders to download from Teapplix are passed in the query string part of the URL.

TxnId ==> Unique OrderId in Teapplix

StoreType ==> marketplace, like ebay, amazon, walmart, etc

StoreKey ==> for shopping carts and marketplaces without seller id, the 3 letter prefix you used when linking the shopping cart

SellerId ==> for ebay and amazon, SellerId is your username or Amazon merchant id. Note that you should specify only one of SellerId and StoreKey.

SeqStart: for txn_seq >= 12345, txn_seq is a unique number assigned to each order per Teapplix account. Based on the sequence that the order is created or pulled into Teapplix. You can remember the previous maximum number you have received, and use this to incrementally download large number of orders.

SeqEnd: 12346 => for txn_seq <= 12346. Use this to control which set of orders to download.

PaymentDateEnd: 2012/01/31 => for orders with payment date <= 2012/01/31 (note that since 2012/01/31 02:55:12 is greater than 2012/01/31, all orders placed on 01/31 is excluded)

UpdateDateStart: 2019/05/10 ==> for orders with LastUpdateDate >= value(inclusive). Teapplix order has LastUpdatedDate that starts out the date order is downloaded, and each time order is updated (address, payment status). Notice that setting shipping options, queue id, shipping the order, exporting the orders to QuickBooks will not change LastUpdateDate on the order.

NotShipped: (optional, 1 or 0) ==> if set to 1, only obtain orders not shipped

Combine: "combine|original|all", depending on value, the following orders are included or excluded

combine: we will provide all "non cancelled" orders. If 2 orders are combined into 1, the combined result order will be in the result, the original order will not

original: we will provide all "non cancelled" orders. If 2 orders are combined into 1, the original order will be in the result, the combined result will not be.

all: all orders, including combined results, cancelled orders, etc, will be in the result.

DetailLevel: "shipping|inventory|dropship|none", certain aspect of Orders are not normally returned, and the detail level controls turning on outputing these aspects of orders:

shipping: this will cause Teapplix to do remember weight lookup for unshipped orders, and then return ShippingDetail and Options array.

inventory: this will cause Teapplix to do inventory lookup, and return ItemSKU and ItemLocation. ItemLocation follows these rules:

if order item has a "saved location", then it will be returned

if not the location set on the "product" will be returned

for ItemSKU, this is the mapped Product Name. If no mapping is done, the return is same as Name.

dropship: if the order is submitted from another Teapplix account here to be dropshipped, this will cause Teapplix to return 'DropShipDetails', which contain markups and fees associated with the handling of the dropship order.

PageSize & PageNumber:

PageSize is the number of orders in each return response, default is 100 and maximum your can set is 1000. If the total number of orders to download is more than PageSize, they will be splitted into multiple pages.

PageNumber: In order to retrieve all the orders in each page, you need to provide different PageNumber parameter value in each call, such as PageNumber=1, PageNumber=2, etc. until the returned number of orders is less than the PageSize.

Miminum list of parameters: you must specify one of: PaymentDateStart, ShipDateStart, SeqStart, NotShipped,PageNumber