OrderCount
Acquire the number of new orders and new pre-order orders.
Select
The 本製品 will use the Yahoo Shopping API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- SellerId supports the = operator.
SELECT * FROM OrderCount WHERE SellerId = 'store'
Columns
Name | Type | References | Description |
SellerId [KEY] | String | Specify the store account. | |
NewOrder | Integer | New order number (order details unread number). | |
NewReserve | Integer | Number of new reservations. | |
WaitPayment | Integer | Number of queue waiting. | |
WaitShipping | Integer | Number of items waiting for shipment. | |
Shipping | Integer | Number of shipping processes. | |
Reserve | Integer | Number of reservations. | |
Holding | Integer | Number of holds. | |
WaitDone | Integer | Order completion wait count. | |
Suspect | Integer | Number of mischievous orders. | |
SettleError | Integer | Number of settlement errors. | |
Refund | Integer | Number of refundable items. | |
AutoDone | Integer | Auto orders completed. | |
AutoWorking | Integer | Automatic order hold cancel count. | |
Release | Integer | Number of scheduled release orders. | |
NoPayNumber | Integer | Payment number not issued. | |
StoreStatus1 | Integer | Store status 1 number. | |
StoreStatus2 | Integer | Store status 2 number. | |
StoreStatus3 | Integer | Store status 3 number. | |
StoreStatus4 | Integer | Store status 4 number. | |
StoreStatus5 | Integer | Store status 5 number. | |
StoreStatus6 | Integer | Store status 6 number. | |
StoreStatus7 | Integer | Store status 7 number. | |
StoreStatus8 | Integer | Store status 8 number. | |
StoreStatus9 | Integer | Store status 9 number. | |
StoreStatus10 | Integer | Store status 10 number. |