JDBC Driver for Yahoo Shopping

Build 20.0.7587

ProductOptions

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587