SSIS Components for Yahoo Shopping

Build 20.0.7587

Inventory

Stock database of inventory data in Yahoo! Shopping.

Select

The 本製品 will use the Yahoo Shopping API to process WHERE clause conditions built with the following columns and operators, ItemCode is required. The rest of the filter is executed client side within the 本製品.

  • ItemCode and SellerId support the = operator.
For example, the following queries are processed server side:
SELECT * FROM Inventory WHERE ItemCode = 'CD001' 
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 unfiltered data to be pushed.

Insert

Insert is not supported by Inventory

Update

Yahoo Shopping allows updates for the AllowOverdraft, Quantity and StockClose columns.

UPDATE Inventory SET AllowOverdraft = 1,  Quantity= '15',StockClose = 0 Where ItemCode='CD001' 

Batch Update

Yahoo Shopping allows updates for the same columns.

INSERT INTO Inventory#TEMP (AllowOverdraft, ItemCode, Quantity, StockClose)  VALUES (1, 'CD0001', '12', 0)

INSERT INTO Inventory#TEMP (AllowOverdraft, ItemCode, Quantity, StockClose)  VALUES (1, 'CD0002', '32', 0)

UPDATE Inventory SET (AllowOverdraft, ItemCode, Quantity, StockClose) SELECT AllowOverdraft, ItemCode, Quantity, StockClose FROM [Inventory#Temp]

Delete

Delete is not supported by Inventory

Columns

Name Type ReadOnly References Description
ItemCode [KEY] String False

Products.ItemCode

Product code. In INSERT or UPDATE: For products that do not have individual product codes, please specify only the product code. For products with individual item codes, please connect the product code and individual product code with a colon ':'.

SellerId String False

Id of the store account. In UPDATE: If the number has a plus sign '+', the value will be added and it will be subtracted if minus sign '-' is attached. If only numeric value is written, the field will be updated with that value.

SubCode String True

Individual product code. If the product does not have individual product code, this will be empty.

Status Integer True

Stock acquisition status. 0: No stock information, 1: Stock information available.

使用できる値は次のとおりです。0, 1

Quantity String False

Quantity of inventory. If this value is empty, this means that the number of stock is infinite.

AllowOverdraft Integer False

The excess purchase setting. 0: Excessive purchase impossible, 1: Excess purchase possible.

使用できる値は次のとおりです。0, 1

IsPublished Integer True

The product reflection flag. 0: Product not reflected, 1: Product reflected.

使用できる値は次のとおりです。0, 1

UpdateTime Datetime True

Last update date.

StockClose Integer False

Stock Close Flag. 0: Normal State, 1: Stock Closed State

使用できる値は次のとおりです。0, 1

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