ADO.NET Provider for Yahoo Shopping

Build 24.0.9062

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062