Retrieve ItemCode, ItemStatus and SellerCode related goods.

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

• 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.

Columns

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.