Orders
Returns data regarding orders. ShippingStatus column is required to be specified for this view.
Select
The 本製品 will use the Qoo10 API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- ShippingStatus supports the '=' operator.
- SearchCondition supports the '=' operator.
- Date supports the '=', '<' and '>' operators.
SELECT * FROM Orders WHERE ShippingStatus='1' SELECT * FROM Orders WHERE ShippingStatus=1 AND SearchCondition='2' AND Date>'2017-04-24' AND Date<'2019-04-23'You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.
Columns
Name | Type | Description |
OrderNo [KEY] | String | Code of the order. |
SellerID | String | Id of the seller. |
PackNo | String | The code of pack. |
PackingNo | String | Number of the packing. |
ShippingStatus | String | Status of the shipping. 1 : Waiting for Shipping 2 : Request Shipping 3 : Check Order. |
OrderDate | Datetime | Date of the order. |
PaymentDate | Datetime | Date of the payment. |
Buyer | String | Person who made the order. |
BuyerGata | String | Buyer gata. |
BuyerTel | String | Telephone number of the buyer. |
BuyerMobile | String | Mobile number of the buyer. |
BuyerEmail | String | Email of the buyer. |
OrderType | String | Type of the order. |
ItemCode | String | The item code of Qoo10. |
ItemTitle | String | Title of the item. |
Option | String | Order option. |
OptionCode | String | Option code. |
OrderPrice | Decimal | Price of the order. |
OrderQty | Integer | Quantity of the order. |
Discount | Decimal | Discount of the order. |
Total | Decimal | Total price of the order. |
SettlePrice | Decimal | Settle price of the order. |
Receiver | String | Receiver of the order. |
ReceiverGata | String | Receiver of the order. |
ReceiverTel | String | Telephone number of the receiver. |
ReceiverMobile | String | Mobile number of the receiver. |
SenderName | String | Name of the sender. |
SenderTel | String | Telephone number of the sender. |
SenderNation | String | Nation of the sender. |
SenderZipCode | String | ZipCode of the sender. |
SenderAddr | String | Address of the sender. |
RelatedOrder | String | Related order. |
SellerDeliveryNo | String | Number of the delivery. |
VoucherCode | String | Code of the voucher. |
PaymentNation | String | Payment nation. |
PaymentMethod | String | Method of the payment. |
CodPrice | Decimal | Cod price. |
CartDiscountSeller | Decimal | Cart Discount Seller. |
CartDiscountQoo10 | Decimal | Cart Discount Qoo10. |
Currency | String | Currency. |
Date | Date | Date range. |
SearchCondition | String | Inquiry Date Type. 1: (Order date), 2:(Payment date), 3 :(Shipping date), 4 :(Delivered date). Default :1. |