ODBC Driver for eBay

Build 24.0.8963

ItemVariations

Item Variations are multiple similar (but not identical) items in a single fixed-price listing. For example, a T-shirt listing could contain multiple items of the same brand that vary by color and size; each variation would specify a combination of one of these colors and sizes. Each variation can have a different quantity and price. You can buy multiple items from one variation at the same time. (That is, one order line item can contain multiple items from a single variation.)

テーブル固有の情報

Select

このId が表すアイテムのバリエーションを取得するには、item Id を指定する必要があります。

                                          
SELECT * FROM ItemVariations WHERE ItemId = '110187147205'

Insert

Insert に必須のフィールドは、ItemId、VariationSpecificsAggregate、StartPrice、およびQuantity です。VariationSpecificsAggregate は、XML 形式のvariation specifics 構造を含む必要があります。例えば、VariationSpecificsAggregate は、大きな青いアイテムを追加します。

<NameValueList>
  <Name>Color</Name>
  <Value>Blue</Value>
</NameValueList>
<NameValueList>
  <Name>Size</Name>
  <Value>L</Value>
</NameValueList>

次のクエリは、StartPrice 15、およびQuantity 100 で大きな青いアイテムのバリエーションを追加します。

                                          
INSERT INTO ItemVariations (ItemId, VariationSpecificsAggregate, Quantity, StartPrice) VALUES ('110188946596', '<NameValueList><Name>Color</Name><Value>Blue</Value></NameValueList><NameValueList><Name>Size</Name><Value>L</Value></NameValueList>', '100', '15')

Update

バリエーションのUpdate には、ItemId およびVariationSpecificsAggregate が必須です。オプションとして、バリエーションには、StartPrice およびQuantity などの他の詳細を含むことができます。VariationSpecificsAggregate は、XML 形式でバリエーションを特定するすべてのspecifics を含む必要があります。

                                          
UPDATE ItemVariations SET Quantity = '5' WHERE ItemId = '110188946596' AND VariationSpecificsAggregate = '<NameValueList><Name>Color</Name><Value>Blue</Value></NameValueList><NameValueList><Name>Size</Name><Value>L</Value></NameValueList>'

Delete

バリエーションのDelete には、ItemId およびVariationSpecificsAggregate が必須です。

                                          
DELETE FROM ItemVariations WHERE ItemId = '110188946596' AND VariationSpecificsAggregate = '<NameValueList><Name>Color</Name><Value>Blue</Value></NameValueList><NameValueList><Name>Size</Name><Value>L</Value></NameValueList>'

Columns

Name Type ReadOnly Description
ItemId [KEY] String False

The Id that uniquely identifies the item listing. The Id is generated by eBay after an item is listed. You cannot choose or revise this value.

VariationSpecificsAggregate [KEY] String False

A list of name/value pairs that uniquely identify the variation within the listing. All variations must specify the same set of names. For example, if the items vary by color and size, then every variation must specify Color and Size as names, and no two variations can specify the same combination of color and size values.

StartPrice Decimal False

The price of the item at listing or relisting time. If this value changes when the item is revised, the new value becomes this price.

Currency String False

Currency associated with the price information of the item. 3-letter ISO 4217 currency code.

Quantity Integer False

This value indicates the quantity of items in the specific variation that are available for purchase.

QuantitySold Integer False

The total number of items purchased so far. Subtract this from Quantity to determine the quantity available.

SKU String False

A SKU (stock keeping unit) is an identifier defined by a seller. It is only intended for the use of the seller (not for buyers).

EAN String False

This field is used if the seller wishes to identify each product variation within a multivariation listing by an EAN (European Article Number) value.

ISBN String False

This field is used if the seller wishes to identify each product variation within a multivariation listing by an ISBN (International Standard Book Number) value.

UPC String False

This field is used if the seller wishes to identify each product variation within a multivariation listing by a UPC (Universal Product Code) value.

ListingStatus String False

Specifies a listing with an active or ended status in the eBay processing workflow.

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