ADO.NET Provider for Yahoo Shopping

Build 20.0.7587

ProductSubCodes

Return the list of options for the specified product.

Select

The {i 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 {i.

  • 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' 
You 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 unfiltered data to be pushed.

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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587