Return the list of options for the specified product.

Select

The 本製品 will use the Yahoo Shopping API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

• ItemCode and/or SellerId support the = operator.

For example, the following queries are processed server side:

SELECT * FROM ProductOptions WHERE ItemCode = 'CD001'

SELECT * FROM ProductOptions WHERE ItemCode = 'CD001' AND SellerId = 'store' 

Insert

ItemCode, Name, SpecName are required for an Insert

INSERT INTO ProductOptions (Name, SpecId, SpecName, SpecValue, ItemCode) VALUES ('optionName', '1234', 'optionSpecificationName', '3456', 'CD000001') 

Update

Yahoo Shopping allows updates for the Name, SpecId, SpecValue, SpecName columns. OptionValueId is required. This is a composite key containing the option name and the option specification value.

UPDATE [ProductOptions] SET Name = 'SizeRename', SpecId = '123', SpecName = 'Medium', SpecValue = '234' WHERE OptionValueId = 'Size|Small' AND ItemCode = 'CD000001'

Delete

A product option can be deleted by providing the ItemCode and OptionValueId and issuing a DELETE statement

DELETE FROM ProductOptions WHERE ItemCode = 'CD000001' AND OptionValueId = 'SizeRename|Medium' 

Columns

Name	Type	ReadOnly	References	Description
ItemCode [KEY]	String	False		Product code
SellerId	String	False		Id of the seller.
OptionValueId [KEY]	String	True		Id of the option value.
Type	Integer	True		Option type 1: Normal option (with inventory setting), 2: Normal option (no inventory setting). 使用できる値は次のとおりです。1, 2
Name	String	False		Option name.
SpecId	String	False		Option spec ID.
Length	String	True		Option length.
SpecValue	String	False		Specification value of option value.
SpecName	String	False		Specification name of option value.