Excel Add-In for Qoo10

Build 22.0.8479

Claims

Returns data regarding claim info. ClaimStaus column is required to be specified for this view. ClaimStaus = 4 by default. Possible values are 1,2,3,4,5,6.

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 本製品.

  • ClaimStatus supports the '=' operator.
  • Date supports the '=', '<' and '>' operators.
For example, the following query is processed server side:
SELECT * FROM Claims WHERE ClaimStatus=2
SELECT * FROM Claims WHERE ClaimStatus=4 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
ClaimStatus String Processing state. 1-Cancel request. 2-Cancelling. 3-Cancel completed. 4-Return request. 5-Returning. 6-Return completed.

使用できる値は次のとおりです。1, 2, 3, 4, 5, 6

CancelRefundDate Datetime Cancel / Return / Exchange Completion Date.
Reason String Reason for return, exchange.
RequestDate Datetime Request date for cancellation / return / exchange.
OrderDate Datetime Date of the order.
PaymentDate Datetime Date of the payment.
ShippingDate Datetime Shipping date.
DeliveredDate Datetime Delivered date.
OrderNo [KEY] String Code of the order.
PackNo String The code of pack.
ItemCode String The item code of Qoo10.
SellerItemCode String Merchant product code.
ItemTitle String Product name.
OrderQty Integer Quantity of the order.
PaymentNation String Payment nation.
Currency String Currency.
PaymentAmount String Settlement amount.
DeliveryCompanyReturn String Delivery company return.
TrackingNoReturn String Tracking code return.
ZipCode String ZipCode.
PaymentReturnShipping String Payment return shipping.
ItemCondition String Condition of the item.
Receiver String Receiver of the order.
ReceiverTel String Telephone number of the receiver.
ReceiverMobile String Mobile number of the receiver.
Buyer String Person who made the order.
BuyerTel String Telephone number of the buyer.
BuyerMobile String Mobile number of the buyer.
CODCancelPrice Decimal COD cancel price.
CODQrefundPrice Decimal COD refound price.
CODCancelRelatedOrder String COD cancel related order.
Date Date Date range.

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