ODBC Driver for eBay

Build 24.0.8963

AddItem

Create and publish a new Item Listing on an eBay site.

ストアドプロシージャ固有の情報

Item Listing の作成が成功すると、Item Id がレスポンスとして返され、アイテムのリスティングの推定手数料が返されます。アイテムを追加後、ItemListing テーブルで更新、削除およびクエリが可能です。

アイテムの追加に必要な項目は以下です:Title、Description、CategoryId、StartPrice、ConditionId、Country、Currency、DispatchTimeMax、ListingDuration、ListingType、PaymentMethod、PayPalEmailAddress、Quantity、Location、およびReturnsAcceptedOption。

Shipping タイプの選択には、いくつかのインプットを指定する必要があります:Flat、もしくはCalculated。どちらのShipping タイプでもShippingService を指定する必要があります。

アイテムの追加

次の手順でSQL を通じて必須の値を取得し、アイテムを追加することができます。

  1. Categories ビューを使って、例えばBooks のようなトップレベルカテゴリを選択します。次のクエリを使うことができます:
    SELECT * FROM Categories
  2. Categories ビューを使って、例えばFiction & Literature のようなサブカテゴリを選択します。アイテムの追加には、サブカテゴリID が必要です。次のようなクエリを使うことができます。
    SELECT * FROM Categories WHERE CategoryParentId = '267'
  3. ShippingService ビューを使って、Shipping Service を選択します。ValidForSellingFlow カラムの値はtrue に設定する必要があります。そうしなければ特定のShipping Service は有効ではなくなり、リスティングから購入者が購入することができなくなります。

Flat Shipping の選択

Flat Shipping タイプには、次のインプットが必要です:ShippingType、ShippingService、ShippingServicePriority、およびShippingServiceCost。

CalculatedShipping の選択

Calculated Shipping タイプは、パッケージstats に関する追加の情報を要求します。このShipping タイプには、次のインプットが必要です:ShippingType、WeightMajor、WeightMinor、OriginatingPostalCode、ShippingService、およびShippingServicePriority。

Note:このプロシージャは、インデックス付きパラメータを使用します。 インデックス付きパラメータは、プロシージャの入力として単一のパラメータを複数のインスタンスに提供することを容易にします。

Param# という名前の入力パラメータがあるとします。このようなインデックス付きパラメータの複数のインスタンスを入力するには、次のように実行します。

EXEC ProcedureName Param#1 = "value1", Param#2 = "value2", Param#3 = "value3"

以下の表では、インデックス付きの入力パラメータは、名前の末尾に '#' 文字が付きます。

Input

Name Type Required Description
Title String False Name of the item as it appears in the listing or search results.
Description String False The description of the item by the seller. In listing requests, you can use CDATA tags to submit your description if you want to use HTML or XML-reserved characters in the description.
CategoryId String False Category Id for the first (or only) category in which the item is listed (or will be listed, if the item is new).
StartPrice String False The original price of the item at listing or relisting time. If this value changes when the item is revised, the new value becomes the original price.
ConditionId String False An identifier for the condition of the item. For example, 1000 for New or 3000 for Used.
Country String False Defines the 2-letter ISO 3166 country code.
Currency String False Currency associated with the price information of the item. 3-letter ISO 4217 currency code.
DispatchTimeMax String False Specifies the maximum number of business days the seller commits to for preparing an item to be shipped after receiving a cleared payment. This time does not include the shipping time (the transit time of the carrier). Including this field fulfills 'Handling time' being required for input.
ListingDuration String False Describes the number of days the seller wants the listing to be active (available for bidding/buying).
ListingType String False The format of the listing the seller wants to use, such as Chinese auction or fixed price.
Location String False Indicates the geographical location of the item (along with Country). When you revise a listing, you can add or change this value only if the listing has no bids (or no items have sold), and it does not end within 12 hours.
ReturnsAcceptedOption String False Indicates whether the seller allows the buyer to return the item. One of the following values: ReturnsAccepted or ReturnsNotAccepted. If you specify ReturnsNotAccepted, the View Item page will indicate that returns are not accepted instead.
SubTitle String False Subtitle to use in addition to the title.
Quantity String False The Quantity value for auction listings must always be 1. For a fixed-price listing, the Quantity value indicates the number of identical items the seller has available for sale in the listing.
Sku String False A SKU (Stock Keeping Unit) value is a seller-defined identifier for a product.
UUID String False Universally unique constraint tag. Use UUID to ensure that you only list a particular item once, particularly if you are listing many items at once.
ScheduleTime String False Allows the user to specify the time that the listing becomes active on eBay.
PaymentMethod String False Identifies the payment method (such as PayPal) that the seller will accept when the buyer pays for the item. Use the CategoryFeatures view to find the available payment methods for a category.
PayPalEmailAddress String False The PayPal email address of the seller.
LiveAuction String False This field must be included and set to true if the listing will be a part of a Live Auction. This boolean field is returned as true in the ItemList table if the listing is part of a Live Auction. See the eBay Live Auctions home page for more information about Live Auctions on eBay.com.
LotSize String False A lot is a set of two or more similar items included in a single listing that must be purchased together in a single order line item. The LotSize value is the number of items in the lot. This field is required if two or more items are including in one listing.
PostalCode String False Postal code of the place where the item is located. This value is used for proximity searches.
TaxCategory String False Tax exception category code.
UseTaxTable String False Indicates whether the tax table of the seller is to be used when applying and calculating sales tax for an order line item.
VIN String False This field displays the Vehicle Identification Number, which is a unique serial number for a motor vehicle.
VRM String False Vehicle Registration Mark, which is a unique identifier for a motor vehicle in the UK.
CategoryMappingAllowed String False Controls how eBay handles cases in which the category no longer exists in the current category structure: If true, eBay will use the new Id for the listing; if false, an error is returned.
UseRecommendedProduct String False If true, and the item details in the request match a product in the eBay catalog, the matching product is used to list the item.
ShippingType String False The shipping cost model offered by the seller.
ShippingService String False A shipping service option being offered by the seller to ship an item to a buyer. For a list of valid ShippingService values, query the ShippingServices view; the ShippingService returned must have a value of true in the ValidForSellingFlow column.
ShippingServicePriority String False This integer value controls the order (relative to other shipping services) in which the corresponding ShippingService will appear in the View Item and Checkout page. Sellers can specify up to four domestic shipping services.
ShippingServiceCost String False The base cost of shipping the item by using the shipping service specified in the ShippingService field, if one was specified. This column includes the packaging and handling cost for flat and calculated shipping. If this is for calculated shipping for a listing that has not yet ended, note that the cost cannot be determined until the listing has ended and the buyer has specified a postal code. This value reflects savings from a promotional shipping service option. Also applicable to Half.com.
ShippingServiceAdditionalCost String False The cost of shipping each additional item if the same buyer purchases multiple quantities of the same line item. If less than ShippingServiceCost, this column gives the buyer a shipping discount. This field is required when creating a multiple-quantity fixed-price listing. This field is not applicable for single-quantity listings.
FreeShipping String False Specifies that the seller wants to offer free shipping. This applies only to the first specified domestic shipping service and is ignored if set for any other shipping service.
ShippingPackage String False The nature of the package used to ship the item(s). Required for calculated shipping only.
ShippingIrregular String False Whether a package is irregular and therefore cannot go through the stamping machine at the shipping service office and thus requires special or fragile handling.
MeasurementUnit String False Specifies the unit type of the weight and dimensions of a shipping package. If MeasurementUnit is used, it overrides the system specified by measurementSystem. If MeasurementUnit and measurementSystem are not specified, the following defaults will be used: English: US Metric: CA, CAFR, AU.
MeasurementSystem String False System of Measurement for PackageDepth, PackageLength, PackageWidth, WeightMajor, and WeightMinor (English or Metric).
PackageDepth String False Depth of the package needed to ship the item.
PackageDepthUnit String False Unit of measurement for PackageDepth (e.g., in, cm).
PackageLength String False Length of the package needed to ship the item.
PackageLengthUnit String False Unit of measurement for PackageLength (e.g., in, cm).
PackageWidth String False Width of the package needed to ship the item.
PackageWidthUnit String False Unit of measurement for PackageWidth (e.g., in, cm).
WeightMajor String False The major unit used to specify the weight of a shipping package. For example, lbs.
WeightMajorUnit String False Unit of measurement for WeightMajor.
WeightMinor String False The minor unit used to specify the weight of a shipping package. For example, oz.
WeightMinorUnit String False Unit of measurement for WeightMinor.
BestOfferEnabled String False This field indicates whether or not the Best Offer feature is enabled for this item.
ShipToRegistrationCountry String False The seller includes and sets this field to true as a mechanism to block bidders who reside (according to their eBay primary shipping address) in countries that are on the ship-to exclusion list.
StoreCategoryId String False Unique identifier of a primary custom category in which to list the item.
StoreCategoryName String False Category name of a primary custom category in which to list the item.
StoreCategoryId2 String False Unique identifier for the secondary custom category in which to list the item.
StoreCategoryName2 String False Name of the secondary custom category in which to list the item.
DaysToFullPayment String False This integer value indicates the number of days that a buyer has (after he/she commits to buy) to make full payment to the seller and close the remaining balance on a motor vehicle. Valid values are 3, 7 (default), 10, and 14.
Brand String False The brand of the product. eBay searches against the names that are publicly available in its product catalogs. This means you can specify the well-known brand name that an average user would recognize. Both Brand and MPN must be specified if the BrandMPN column is used.
BrandMPN String False The manufacturer part number of the product. Use the value specified by the manufacturer.
EAN String False Applicable for listing use cases only (not buy-side searching). EAN is a unique 8 or 13 digit identifier that many industries (such as book publishers) use to identify products.
IncludeeBayProductDetails String False This boolean field controls whether or not an eBay catalog product is used to help create or revise an item listing.
IncludeStockPhotoURL String False If true, indicates that the item listing includes the stock photo.
ISBN String False Applicable for listing use cases only (not buy-side searching). ISBN is a unique identifer for books (an international standard). Specify a 10 or 13 character ISBN.
ProductReferenceId String False The short global reference Id for a catalog product.
UPC String False Applicable for listing use cases only (not buy-side searching). UPC is a unique, 12-character identifier that many industries use to identify products.
UseStockPhotoURLAsGallery String False If true, indicates that the stock photo for an item (if available) is used as the gallery thumbnail. IncludeStockPhotoURL must also be true and Item.
PaymentProfileId String False The unique identifier of a Business Policies payment profile. A PaymentProfileId or PaymentProfileName can be specified.
PaymentProfileName String False The name of a Business Policies payment profile. A PaymentProfileId or PaymentProfileName can be specified.
ReturnProfileId String False The unique identifier of a Business Policies return policy profile. A ReturnProfileId or ReturnProfileName can be specified.
ReturnProfileName String False The name of a Business Policies return policy profile. A ReturnProfileId or ReturnProfileName can be specified.
ShippingProfileId String False The unique identifier of a Business Policies shipping policy profile. A ShippingProfileId or ShippingProfileName can be specified.
ShippingProfileName String False The name of a Business Policies shipping policy profile. A ShippingProfileId or ShippingProfileName can be specified.
BusinessSeller String False If true, this indicates that the seller is a business user and intends to use listing features that are offered to business users only.
RestrictedToBusiness String False If true, this indicates that the seller elects to offer the item exclusively to business users. If false or not specified, this indicates that the seller elects to offer the item to all users.
VATPercent String False VAT rate for the item, if any.
PhotoDisplay String False Specifies the type of image display used in a listing. Some options are only available if images are hosted through eBay Picture Services (EPS).
PictureUrl# String False Source of the picture. Use this input to add multiple pictures. PictureUrl#1, PictureUrl#2, PictureUrl#3 etc.
GalleryURL String False This field is used internally only. The Gallery image is always the first PictureURL passed in and this field is set to that value.
ItemSpecificName# String False Item specifics' name (for example ItemSpecificName#1 Release Title, ItemSpecificName#2 Publisher...). Combine this with ItemSpecificValue.
ItemSpecificValue# String False Item specifics' value (for example ItemSpecificValue#1 Title, ItemSpecificValue#2 PublisherName...). Combine this with ItemSpecificName.
ProductCompliancePolicyId String False This field is used if the seller wants to apply one or more seller-created global product compliance policies that will be used in a listing.
ProductCountryPolicy String False Defines the 2-letter country code set.
ProductCountryPolicyId String False The policy Id specifying product compliance policy information.
TakeBackCountryPolicy String False Defines the 2-letter country code set.
TakeBackCountryPolicyId String False The policy Id specifying take-back policy information.
TakeBackPolicyId String False This field is used if the seller wants to apply a global take-back policy to the listing.
ConditionAdditionalInfo String False This text provides additional information about a condition descriptor.
ConditionName String False A numeric ID is passed in this field. This numeric ID maps to the name of a condition descriptor.
ConditionValue String False A numeric ID is passed in this field. This numeric ID maps to the value associated with a condition descriptor name.

Result Set Columns

Name Type Description
ItemId String The unique identifier of the created item.
StartTime String Starting date and time for the new listing.
EndTime String Date and time when the new listing is scheduled to end based on the start time and the listing duration value that was set in the ListingDuration field at listing time.
FeesAggregate String An array of fees associated with the creation of the listing.
DiscountReason String One or more listing fee/upgrade discount types being offered by eBay to the seller. Applicable values: CustomCode, Promotion, SpecialOffer.

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