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