Excel Add-In for Qoo10

Build 22.0.8479


Returns data regarding orders. ShippingStatus column is required to be specified for this view.


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


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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479