ODBC Driver for Yahoo Shopping

Build 23.0.8839

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.
For example, the following queries are processed server side:
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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839