ADO.NET Provider for Yahoo Shopping

Build 20.0.7587

OrderCount

Acquire the number of new orders and new pre-order orders.

Select

The {i 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 {i.

  • SellerId supports the = operator.
For example, the following queries are processed server side:
SELECT * FROM OrderCount WHERE SellerId = 'store' 
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 unfiltered data to be pushed.

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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587