Excel Add-In for Qoo10

Build 22.0.8479


Retrieve ItemCode, ItemStatus and SellerCode related goods.


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

  • ItemStatus supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM Goods WHERE ItemStatus='S2'
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
ItemNo [KEY] String The item code of Qoo10.
ItemStatus String Item Status. Possible values: S0(Unidentified), S1(Standby), S2(Active).

使用できる値は次のとおりです。S0, S1, S2

SellerCode String Item code managed by the seller.

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