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'

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