Retrieve and query information related GoodsInventory info.

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

• ItemNo supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM GoodsInventoryOption WHERE ItemNo=621050268

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.

Insert

Required fields for an insert are ItemNo, Name1, Value1, Price and Quantity.
Optional: Name2, Value2, Name3, Value3, ItemTypeCode.

INSERT INTO GoodsInventoryOption (ItemNo, Name1, Value1, Price, Quantity) values ('621050268','Color', 'Red', '93', '971')

Update

Qoo10 allows updates for the Price and Quantity columns.

UPDATE GoodsInventoryOption SET Price=172,Quantity=332 WHERE ItemNo=621068441
UPDATE GoodsInventoryOption SET Price=172,Quantity=332 WHERE ItemNo=621068441 AND ItemTypeCode='CD0000091'
UPDATE GoodsInventoryOption SET Price=150,Quantity=150 WHERE ItemNo=621050268 AND OptionNo='Size:-:XL:-:Color:-:Blue'

Delete

GoodsInventoryOption can be deleted by providing the ItemNo or ItemNo and ItemTypeCode or ItemNo and OptionNo.

DELETE FROM GoodsInventoryOption WHERE ItemNo=621068441
DELETE FROM GoodsInventoryOption WHERE ItemNo=621068441 AND ItemTypeCode='CD0000091'
DELETE FROM GoodsInventoryOption WHERE ItemNo=625522959 AND OptionNo='Color:-:Red'

Columns

Name	Type	ReadOnly	Description
ItemNo [KEY]	String	True	The item code of Qoo10.
OptionNo [KEY]	String	True	Code of the option.
Name1	String	True	OptionName1
Value1	String	True	OptionValue1
Name2	String	True	OptionName2
Value2	String	True	OptionValue2
Name3	String	True	OptionName3
Value3	String	True	OptionValue3
Price	Decimal	False	OptionPrice
Quantity	Integer	False	Quantity
ItemTypeCode	String	False	Item Type Code