GoodsOption
Retrieve and query information related ItemOption 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.
SELECT * FROM GoodsOption WHERE ItemNo=621052282You 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, Name, Value and Price.
Optional: OptionCode.
INSERT INTO GoodsOption (ItemNo,Name,Value,Price) values ('624988017','test-92','p33',3)
Update
Qoo10 allows updates for the Price and Qty columns.
UPDATE GoodsOption SET Price = '200', OptionCode='FFJ4HFH8HS8H' WHERE ItemNo='624988017' AND OptionNo='Jacket:-:CDATA'
Columns
Name | Type | ReadOnly | Description |
ItemNo [KEY] | String | True |
The item code of Qoo10. |
OptionNo [KEY] | String | True |
Code of the option. |
Name | String | True |
OptionName |
Value | String | True |
OptionValue |
Price | Decimal | False |
OptionPrice |
OptionCode | String | False |
OptionCode |