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 ProductSubcodes WHERE ItemCode = 'CD001'

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

Insert

ItemCode, Code, OptionName, OptionValue are required for an Insert

INSERT INTO ProductSubcodes (Code, LeadTimeInStock, LeadTimeOutStock, OptionName, OptionValue, ItemCode) VALUES ('001', '1000', '4000', 'Color', 'Red', 'CD000001') 

Update

Yahoo Shopping allows updates for the Code, OptionName, OptionValue, LeadTimeInStock, LeadTimeOutStock columns. CodeOptionId is required. This is a composite key containing the subcode code and the option name.

UPDATE [ProductSubcodes] SET Code = '002', LeadTimeInStock = '2000', LeadTimeOutStock = '4000', OptionName = 'Size', OptionValue = 'Small' WHERE CodeOptionId = '001|Color' AND ItemCode = 'CD000001'

Delete

A product subcode can be deleted by providing the ItemCode and CodeOptionId and issuing a DELETE statement

DELETE FROM ProductSubcodes WHERE ItemCode = 'CD000001' AND CodeOptionId = '002|Color' 

Columns

Name	Type	ReadOnly	References	Description
ItemCode [KEY]	String	True		Product code
SellerId	String	True		Id of the seller.
CodeOptionId [KEY]	String	True		Id of the subcode option.
Code	String	False		Individual product code.
Quantity	Integer	True		Subcode quantity.
StockClose	Integer	True		Subcode stock close indicator.
OptionName	String	False		Option name.
OptionValue	String	False		Option value.
LeadTimeInStock	String	False		Inventory ship date value.
LeadTimeOutStock	String	False		Out of stock value of shipment date.