File Exchange
Advanced Template
Instructions
Copyright Statement
Copyright 2001 - 2012 eBay Inc. All rights reserved.The information contained in this document is
CONFIDENTIAL and PROPRIETARY in nature, and subject to the rights and ownership of eBay Inc. Any
and all unauthorized copying or use of the contents hereof is prohibited.
The eBay logo and experience are trademarks of eBay Inc. All other brand or product names are or may
be trademarks or registered trademarks of their respective owners.
Document Information
Version: 3.0
Date: October 2012
Company Information
eBay Inc. 2145 Hamilton Ave. San Jose, CA 95125 USA
phone: 408.558.7400; fax: 408.558.7401
Contents
What's New in File Exchange?......................................................................................9
New features..........................................................................................................................................9
Introduction...................................................................................................................10
How to use this guide..........................................................................................................................10
How to interpret text styles..................................................................................................................10
Using and managing template files............................................................................11
Understanding template structure.......................................................................................................11
Understanding file size and content rules............................................................................................12
Understanding the Action field values.................................................................................................12
Using Action values......................................................................................................................12
Understanding Action-specific required fields.....................................................................................16
Required template fields for each Action value............................................................................16
Using smart headers and quotation marks..........................................................................................17
Using smart headers....................................................................................................................17
Using quotation marks as text qualifiers.......................................................................................18
Using multiple actions and excess fields.............................................................................................18
Including multiple Actions in one file.............................................................................................18
Including excess fields for a given Action.....................................................................................18
Performing simple template tasks .............................................................................19
Adding a new field to a default template..............................................................................................19
Deleting a field from a default template...............................................................................................20
Deleting multiple field values...............................................................................................................20
Inserting new listings ..................................................................................................21
Enter data in the template fields..........................................................................................................21
Using product identifiers......................................................................................................................22
Using relationship fields for parts compatibility ...................................................................................24
Using eBay Product Identification numbers to list parts...............................................................26
Modifying compatibility information...............................................................................................26
Using relationship fields for variation ..................................................................................................27
Modifying the RelationshipDetails and PicURL of a variation.......................................................30
Modifying the Quantity and StartPrice of a variation....................................................................30
Modifying the Relationship and CustomLabel of a variation.........................................................31
Using a custom item specific field.......................................................................................................31
Using the ConditionID field..................................................................................................................32
Using the StoreCategory fields............................................................................................................33
Using store category numbers in a template................................................................................33
Looking up store category numbers.............................................................................................33
Using the auto-accept and auto-decline fields.....................................................................................33
Using international site visibility fields.................................................................................................34
Using buyer requirements....................................................................................................................35
Setting up buyer requirements.....................................................................................................35
Applying buyer requirements to listings........................................................................................35
Specifying payments, shipping, and returns ............................................................37
Using the payments fields....................................................................................................................37
iiiContents
File Exchange Advanced Template Instructions
Using shipping discount fields.............................................................................................................37
Combining payments to offer shipping discounts.........................................................................37
Adding shipping discount values to a template............................................................................38
Using return policy fields.....................................................................................................................38
Using shipment tracking number fields................................................................................................39
Using package weight and dimension fields........................................................................................40
Adding package weight information fields....................................................................................40
Adding package dimension information fields..............................................................................41
Using shipping rate tables...................................................................................................................41
Creating a domestic shipping rate table.......................................................................................41
Applying a shipping rate table to listings......................................................................................43
Updating your listings .................................................................................................44
Using revision files...............................................................................................................................44
Adding product identifiers to Active listings.........................................................................................45
Revising your Active listings.........................................................................................................45
Using advanced functions...........................................................................................46
Using programmatic instructions.........................................................................................................46
Requesting an eBay token...........................................................................................................46
Uploading files programmatically..................................................................................................46
Downloading files programmatically.............................................................................................46
Sample HTTP Post Request........................................................................................................47
HTTP Post Request Components................................................................................................47
Using metadata information.................................................................................................................48
Metadata cell information.............................................................................................................48
Overriding metadata values..........................................................................................................48
Site and template information.....................................................................................50
eBay site-specific information..............................................................................................................50
Site-specific template information.................................................................................................50
Default template metadata information................................................................................................52
Metadata values...........................................................................................................................52
Region names and country codes.......................................................................................................54
Template field definitions.............................................................................................59
Design and display fields.....................................................................................................................59
*Action..........................................................................................................................................59
BoldTitle.......................................................................................................................................59
BuyerRequirements:LinkedPayPalAccount..................................................................................59
BuyerRequirements:MaximumItemCount.....................................................................................60
BuyerRequirements:MaxItemMinFeedback..................................................................................60
BuyerRequirements:MaxUnpaidItemsCount................................................................................60
BuyerRequirements:MaxUnpaidItemsPeriod...............................................................................61
BuyerRequirements:MaxViolationCount.......................................................................................61
BuyerRequirements:MaxViolationPeriod......................................................................................61
BuyerRequirements:MinimumFeedbackScore.............................................................................61
BuyerRequirements:ShiptoRegCountry.......................................................................................62
BuyerUserID.................................................................................................................................62
*Category.....................................................................................................................................62
Category2.....................................................................................................................................62
*ConditionID.................................................................................................................................63
Country.........................................................................................................................................63
Contentsiv
File Exchange Advanced Template Instructions
CrossBorderTrade........................................................................................................................63
C:<item specific name>................................................................................................................63
CustomLabel................................................................................................................................64
DeleteFields.................................................................................................................................64
*Description..................................................................................................................................65
*Duration.......................................................................................................................................65
EndCode......................................................................................................................................65
Feedback......................................................................................................................................66
FeedbackType..............................................................................................................................66
FE:ListByDate..............................................................................................................................66
*Format.........................................................................................................................................66
GalleryDuration............................................................................................................................67
GalleryType..................................................................................................................................67
HitCounter....................................................................................................................................67
ItemID...........................................................................................................................................67
*Location......................................................................................................................................68
LotSize..........................................................................................................................................68
PhotoDisplay................................................................................................................................68
PicURL.........................................................................................................................................69
PostalCode...................................................................................................................................69
PrivateAuction..............................................................................................................................69
*Quantity.......................................................................................................................................69
Relationship..................................................................................................................................70
RelationshipDetails.......................................................................................................................70
ScheduleTime..............................................................................................................................71
StoreCategory..............................................................................................................................71
StoreCategory2............................................................................................................................71
Subtitle.........................................................................................................................................72
*Title.............................................................................................................................................72
TransactionID................................................................................................................................72
Packaging and handling fields.............................................................................................................72
*DispatchTimeMax.......................................................................................................................73
InternationalPackagingHandlingCosts..........................................................................................73
PackageDepth..............................................................................................................................73
PackageLength.............................................................................................................................73
PackageType................................................................................................................................74
PackageWidth..............................................................................................................................74
ShipFromZipCode........................................................................................................................74
ShipmentTrackingNumber............................................................................................................74
ShippedTime................................................................................................................................75
ShippingCarrierUsed....................................................................................................................75
ShippingIrregular..........................................................................................................................75
ShippingStatus.............................................................................................................................76
*ShippingType..............................................................................................................................76
ShipToLocations...........................................................................................................................76
WeightMajor.................................................................................................................................77
WeightMinor.................................................................................................................................77
WeightUnit....................................................................................................................................77
Payment and return fields....................................................................................................................78
vContents
File Exchange Advanced Template Instructions
AdditionalDetails...........................................................................................................................78
AmEx............................................................................................................................................78
Discover........................................................................................................................................78
ImmediatePayRequired................................................................................................................78
IntegratedMerchantCreditCard.....................................................................................................79
MOCashiers.................................................................................................................................79
PaymentInstructions.....................................................................................................................79
PaymentSeeDescription...............................................................................................................79
PaymentStatus.............................................................................................................................79
PayPalAccepted...........................................................................................................................80
PayPalEmailAddress....................................................................................................................80
PayUponPickup............................................................................................................................80
PersonalCheck.............................................................................................................................80
RefundOption...............................................................................................................................81
RestockingFeeValueOption..........................................................................................................81
*ReturnsAcceptedOption..............................................................................................................81
ReturnsWithinOption....................................................................................................................81
ShippingCostPaidBy.....................................................................................................................82
VisaMastercard............................................................................................................................82
Pricing and cost fields..........................................................................................................................82
BestOfferAutoAcceptPrice............................................................................................................82
BestOfferEnabled.........................................................................................................................82
BuyItNowPrice..............................................................................................................................83
Currency.......................................................................................................................................83
InternationalPackagingHandlingCosts..........................................................................................83
InternationalPromotionalShippingDiscount..................................................................................83
InternationalShippingDiscountProfileID........................................................................................84
MinimumBestOfferMessage.........................................................................................................84
MinimumBestOfferPrice................................................................................................................85
PackagingHandlingCosts.............................................................................................................85
PromotionalShippingDiscount......................................................................................................85
ReservePrice................................................................................................................................85
SalesTaxPercent...........................................................................................................................86
SalesTaxState..............................................................................................................................86
ShippingDiscountProfileID............................................................................................................86
ShippingInTax...............................................................................................................................87
*StartPrice....................................................................................................................................87
UseTaxTable.................................................................................................................................87
Product code and details fields............................................................................................................88
Product:Brand...............................................................................................................................88
Product:EAN.................................................................................................................................88
Product:EPID................................................................................................................................88
Product:ISBN................................................................................................................................89
Product:MPN................................................................................................................................89
Product:IncludePrefilledItemInformation.......................................................................................89
Product:IncludeStockPhotoURL...................................................................................................89
Product:ReturnSearchResultsOnDuplicates................................................................................90
Product:UPC................................................................................................................................90
Product:UseStockPhotoURLAsGallery........................................................................................90
Contentsvi
File Exchange Advanced Template Instructions
Shipping services fields.......................................................................................................................90
DomesticRateTable......................................................................................................................91
GlobalShipping.............................................................................................................................91
IntlShippingService-1:AdditionalCost...........................................................................................91
IntlShippingService-1:Cost...........................................................................................................92
IntlShippingService-1:Locations...................................................................................................92
IntlShippingService-1:Option........................................................................................................92
IntlShippingService-1:Priority.......................................................................................................93
IntlShippingService-2:AdditionalCost...........................................................................................93
IntlShippingService-2:Cost...........................................................................................................93
IntlShippingService-2:Locations...................................................................................................94
IntlShippingService-2:Option........................................................................................................94
IntlShippingService-2:Priority.......................................................................................................94
IntlShippingService-3:AdditionalCost...........................................................................................95
IntlShippingService-3:Cost...........................................................................................................95
IntlShippingService-3:Locations...................................................................................................95
IntlShippingService-3:Option........................................................................................................96
IntlShippingService-3:Priority.......................................................................................................96
ShippingService-1:AdditionalCost................................................................................................96
ShippingService-1:Cost................................................................................................................97
ShippingService-1:FreeShipping..................................................................................................97
ShippingService-1:Option.............................................................................................................97
ShippingService-1:Priority............................................................................................................98
ShippingService-1:ShippingSurcharge.........................................................................................98
ShippingService-2:AdditionalCost................................................................................................98
ShippingService-2:Cost................................................................................................................99
ShippingService-2:Option.............................................................................................................99
ShippingService-2:Priority............................................................................................................99
ShippingService-2:ShippingSurcharge.......................................................................................100
ShippingService-3:AdditionalCost..............................................................................................100
ShippingService-3:Cost..............................................................................................................100
ShippingService-3:Option...........................................................................................................101
ShippingService-3:Priority..........................................................................................................101
ShippingService-3:ShippingSurcharge.......................................................................................101
Shipping services field values...........................................................................................................102
Australia services options...........................................................................................................102
Austria services options.............................................................................................................103
Belgium (French) services options.............................................................................................103
Belgium (Dutch) services options...............................................................................................104
Canada services options............................................................................................................104
Canada (French) services options..............................................................................................105
China services options...............................................................................................................105
France services options..............................................................................................................106
Germany services options..........................................................................................................106
Hong Kong services options.......................................................................................................107
Ireland services options..............................................................................................................108
India services options.................................................................................................................108
Italy services options..................................................................................................................108
Malaysia services options..........................................................................................................109
viiContents
File Exchange Advanced Template Instructions
Netherlands services options.....................................................................................................109
Philippines services options.......................................................................................................109
Poland services options..............................................................................................................110
Singapore services options........................................................................................................110
Spain services options...............................................................................................................110
Switzerland services options......................................................................................................111
Taiwan services options.............................................................................................................111
United Kingdom services options...............................................................................................112
United States services options...................................................................................................112
Result and reports fields....................................................................................................................113
Active Listings report..................................................................................................................117
Awaiting Payment report.............................................................................................................118
Load Response Results report...................................................................................................120
Global Trade Item Number report...............................................................................................122
Paid and Awaiting Shipment report............................................................................................123
Paid and Shipped Items report...................................................................................................124
Product Inventory report.............................................................................................................126
Sold Listings report.....................................................................................................................126
Unsold Items report....................................................................................................................128
Report fields matrix....................................................................................................................129
Contentsviii
File Exchange Advanced Template Instructions
What's New in File Exchange?
Release date: July, 2012
New features
• RestockingFeeValue: When you opt in to the eBay return center, you can apply a restocking fee to
items. For more information, see Using return policy fields on page 38.
• Motorcycle fitment: Parts compatibility now applies to motorcycles.
• ePID Numbers in Parts Compatibility:You can now look up – and use – ePID numbers to list parts
on eBay Motors. For more information, see Using eBay Product Identification numbers to list parts
on page 26.
9What's New in File Exchange?
File Exchange Advanced Template Instructions
Introduction
This section describes this document’s purpose and explains where to find the File Exchange listing
templates.
How to use this guide
This guide explains how to use the File Exchange listing tool to post product listings to the eBay web
site.This guide was designed to be used with one of the standard templates available on the File
Exchange Select Template web page.
How to interpret text styles
The text in this document use these text styles in sentences to imply specific meanings:
• Bold signifies objects clicked to perform a function, such as menu commands, buttons, and keyboard
keys. Bold is also used to highlight a term or phrase before its explanation.
• Italic denotes names of pertinent objects, such as application windows, field names, hyperlinks, and
introductory terms.
• Monospace signifies programming objects, such as code examples, field values, and URLs.
• PlainCapitalLetters signify a general reference, such as "For Action, use the VerifyAdd value," and
"ReturnsAcceptedOption supports the ReturnsAccepted and ReturnsNotAccepted values."
Introduction10
File Exchange Advanced Template Instructions
Using and managing template files
This section explains the best practices for template use and management, and also offers tips and
techniques for using the File Exchange templates.
Understanding template structure
This section explains the field requirements and file format structure.
Product information can be manually entered into the appropriate template item by item or, if you
already have your product information documented in a database or spreadsheet file, you can map
your data directly into the template file. Whichever method you select, enter the data in the structure
specified, paying particular attention to the following:
• Required Field:You must provide data for each of the required fields specified in the tables. Each
required field name is preceded by an asterisk (*).
Note: New sellers are required to use a safe payment method, which means you accept PayPal
or a credit card such as American Express, Visa, or MasterCard. To choose a safe payment
option, see Payment and return fields on page 78.
• Character type, character limit, and values:The data must conform to the character types and limits
provided in the template data field definitions.
Important: File Exchange does not support newlines, line feeds, or carriage returns in field
values.These characters must be removed or an error will occur while attempting to process
the file. If separate lines are desired in the Description (or any) field, HTML text is required.
• Header field names are not case-sensitive: It does not matter whether you capitalize the letters in
the field names or not. For example, File Exchange will recognize both paypalaccepted and
PayPalAccepted as the same field. However, we recommend that you use the header (field) names
as they are provided in this manual.
• Field Relationships: Some fields are coupled with correlated fields. For example, if you enter a value
in the ShippingService-1:Option field for a specific item, then you must also enter a value in the
ShippingService-1:Cost field. In some instances, a field may be optional, technically speaking, but
it requires also using a related field because of their relationship. Improperly used fields can cause
inconsistent shipping and payment error messages in the results file.
• Using multiple values in one field: Some fields support having multiple values. Multiple values must
be separated by the pipe ( | ) character.
• Template variations across eBay sites: Not all default templates are supported on each eBay site.
For example, the Catalog template is not supported on certain sites.
Tip: For more information about site-specific support, refer to the Site-specific template
information on page 50.
• Smart Headers automatically apply values: If you create an item listing file for specific types of items,
such as books, all have the same value, you can enter the value in the header once instead of entering
the value for each listing multiple times.
The Action data field header includes metadata information like SiteID, Country, Currency, and other
data that are specific to the site from which the template is downloaded.These values should not be
11Using and managing template files
File Exchange Advanced Template Instructions
changed unless you are an advanced user who would like to list items on a different eBay site and
have the necessary permissions from Customer Support.
Understanding file size and content rules
This section explains the file and format requirements for using the File Exchange templates.
Follow these rules to minimize processing errors when using the File Exchange templates.
• Files must be in one of these formats: comma-separated (.csv), semicolon-delimited (.csv) or
tab-delimited (.txt).
• A single file cannot be larger than 15 MB or the upload will fail. Up to 5000 Actions can by uploaded
in a 24-hour period.
• Files must contain data for each required field. Each required data field is denoted with an asterisk
(*) before its name. All other fields are optional (although some contain dependencies, so that if you
include one, you may be required to include another; refer to Template field definitions on page 59
for more information).
• The Action field must always be the first cell and row in a file; it doesn’t matter what order the rest of
the data fields are in. Refer to Using Action values on page 12 for more information.
• Do not include headers in a row of data.
• If a field value has leading zeros (like 00856748589), change the cell format to Text. Cells using the
Number or General format will lose the leading zeros when the file is saved in CSV format.
• File Exchange does not support multi-line field values. Do not use blank lines, newline characters,
or carriage returns in field values. However, you can use HTML text with the <BR> and <P> tags to
create line breaks in the text.
Understanding the Action field values
This section explains how to use the Action field values in the File Exchange templates.
Using Action values
The following sections explain the purpose of the Action field values. Action values differ from Action
metadata; Action values determine how a listing is processed when uploaded; whereas, metadata
identifies site ID, country, and currency information.
Refer to the eBay Help Center for more information about eBay policies and instructions.
Action values include:
• Using the Add action on page 13
• Using the VerifyAdd action on page 13
• Using the Revise action on page 13
• Using the Relist action on page 14
• Using the AddToItemDescription action on page 14
• Using the End action on page 14
• Using the Status action on page 15
Using and managing template files12
File Exchange Advanced Template Instructions
Refer to Understanding Action-specific required fields on page 16 for the list of attributes that must
accompany each action in a template file.
This following sections explain the purpose for each Action.
Using the Add action
This action adds new listings to eBay, and returns a results file containing any associated fee data,
error warnings, etc. It also generates an Item ID for each new listing.The ItemID value is used when
you revise, relist, and end items.
Using the VerifyAdd action
This action tests your file format and listing information before you actually upload them to eBay File
Exchange. In other words, this action is exactly like an Add, but it doesn't result in an added listing. If
the listing has any errors, the errors will appear in the Upload Results file.
VerifyAdd verifies each record on the add file and returns a results file containing any associated fee
data, error warnings, etc. (If your VerifyAdd is successful, eBay File Exchange will return all the fee
amounts for each listing but no ItemIDs because nothing was actually added to the site.) When you're
ready, you can use the Add action using the same values as those in your VerifyAdd file, confident
that they are correct and that your items will be listed on eBay without any errors.
Using the Revise action
Revising your listings means making a change to the listing in some way; for example, changing the
BuyItNow price.
To avoid errors when you revise, include only the required fields, which are:
• Action=Revise
• ItemID=<eBay-generated ItemID for the listing, retrieved from the Load Results Report>
• <Modified fields>=<New values>
• <Revision dependent fields>=<Existing values>
An active listings report is available for download and contains a list of all active listings, including a
flag indicating that you can revise an item.
Revision dependent fields
Important: Certain fields have revision dependencies, meaning if you change one field, other
similar fields, even if unchanged, need to be included in the revised listing. Custom item specific
fields (C:<value name>), shipping fields, and payment fields have this dependency.
Shipping fields: If you revise a shipping field, you must include the other shipping fields if you wish
to retain them. For example, if you change the ShippingType field, you must include all other shipping
fields you want to use. If not, they will be dropped from the listing.
• ShippingService-n fields – any ShippingService-n fields not included (such as ShippingService-1:Cost
on page 97) will be dropped from the listing
• IntlShippingService-n fields – any IntlShippingService-n fields not included (such as
IntlShippingService-1:Option on page 92) will be dropped from the listing
• *ShippingType on page 76
• ShippingDiscountProfileID on page 86
• PromotionalShippingDiscount on page 85
13Using and managing template files
File Exchange Advanced Template Instructions
• InternationalShippingDiscountProfileID on page 84
• InternationalPromotionalShippingDiscount on page 83
• PaymentInstructions on page 79
• SalesTaxPercent on page 86
• SalesTaxState on page 86
• ShippingInTax on page 87
Payment fields: If you revise a payment method field, you must include the other payment methods
you wish to retain. For example, if you change PersonalCheck on page 80 to 1, you must include the
other payment methods you want to use (such as PayPalAccepted on page 80) ; if not, they will be
dropped from the listing.
• AmEx on page 78
• Discover on page 78
• IntegratedMerchantCreditCard on page 79
• MOCashiers on page 79
• PaymentSeeDescription on page 79
• PayPalAccepted on page 80
• PersonalCheck on page 80
• VisaMastercard on page 82
Using the Relist action
Relisting your ended items means listing an item for sale again after it did not sell the first time (You
cannot relist an item until either it ends, or you end the listing yourself.) If you sell a relisted item, eBay
automatically refunds one of the two relisting fees (some restrictions apply).
To avoid errors when you relist, include only the required fields, which are:
• Action=Relist
• ItemID=<eBay-generated ItemID for the listing, retrieved from the Load Results Report>
Using the AddToItemDescription action
Adding item description information to your listings means making a change to the listing description
only.
The AddToItemDescription action allows you to revise only the item description, whereas the Revise
action allows changing multiple details about your item. If you sell a relisted item, eBay automatically
refunds one of the two relisting fees (some restrictions apply).
To avoid errors when using this action, include only the required fields, which are:
• Action=AddToItemDescription
• ItemID=<eBay-generated ItemID for the listing, retrieved from the Load Results Report>. For example,
enter: 3500001016281.
• Description=<Additional information added to the listing description>. For example, enter: This
product is available in sizes small (S), medium (M), and large (L) only.
Using the End action
Use this action to remove your listings from eBay. To avoid errors when you end your listing, include
only the required fields, which are.
Using and managing template files14
File Exchange Advanced Template Instructions
• Action=End
• ItemID=<eBay-generated ItemID for the listing, retrieved from the Load Results Report>
• EndCode=Valid values include: LostorBroken, NotAvailable, Incorrect, or
OtherListingError.
Using the Status action
Using the Status action, you can mark items Paid and Shipped and also Leave Feedback for buyers
in bulk. In fact, you can do all three with just one Status action in one row of your file.
You can only use Status for items that have sold; you cannot use this action on unsold or active listings.
For details on these fields, refer to the Load Response Results report on page 120.
Payment status
To mark an item paid, include the following fields in your upload file:
• Action=Status
• ItemID=<eBay-generated ItemID for the listing, retrieved from the Load Results Report>
• PaymentStatus=1
Shipping status
To mark an item shipped, include the following fields in your upload file:
• Action=Status
• ItemID=<eBay-generated ItemID for the listing, retrieved from the Load Results Report>
• ShippingStatus=1
Leave Feedback status
To leave feedback for buyers, include the following fields in your upload file:
• Action=Status
• ItemID=<eBay-generated ItemID for the listing, retrieved from the Load Results Report>
• BuyerUserID=<Buyer's eBay member ID>
• TransactionID=<TransactionID from the Sold report>
• FeedbackType= Positive
• Feedback=<Textual description>
Using Info in the Action field
If you use "Info" in the first column of a row-which is always an Action field-this denotes that this row
is not requesting any action, but rather is an informational (or comment) row.You can use the Info
row to "comment out" notes about the flat file, without risking any processing errors. An example file
with Info rows is shown below.
15Using and managing template files
File Exchange Advanced Template Instructions
Figure 1: Info in the Action field
Understanding Action-specific required fields
This section explains the required field requirements for a given action in the File Exchange templates.
Required template fields for each Action value
Uploaded files must contain required fields. An asterisk (*) precedes each required field name in the
default catalog or a non-catalog (Basic or Item Specific) templates. All other fields are optional. Some
fields have dependencies. In other words, if you enter a value for an optional field, you may need to
also enter a value in another field.
Note: New sellers must specify a safe payment method such as PayPal or a merchant credit
card including American Express, Discover, MasterCard, or Visa.
Different File Exchange actions require different fields, as shown in the table below:
Action ValuesRequired Fields
StatusEndRelistReviseAddToItem
Description
Add or
VerifyAdd
(non-Catalog
Add or
VerifyAdd
(Catalog
X*Category on page 62
XX*Description on page 65
XX*Duration on page 65
XEndCode on page 65
XX*Format on page 66
XXXXXItemID on page 67
XX*Location on page 68
XX*Quantity on page 69
XX*StartPrice on page 87
X*Title on page 72
Using and managing template files16
File Exchange Advanced Template Instructions
Action ValuesRequired Fields
StatusEndRelistReviseAddToItem
Description
Add or
VerifyAdd
(non-Catalog
Add or
VerifyAdd
(Catalog
XX
*ReturnsAcceptedOption
on page 81dOption
XX
*DispatchTimeMax on
page 73 (Handling time)
XX
*ShippingType on page
76
XX
Shipping services field
values on page 102
XX
Payment and return fields
on page 78
Using smart headers and quotation marks
This section explains how to use special techniques for maximizing code efficiency in the File Exchange
templates.
Using smart headers
In eBay File Exchange, you can use smart headers, which set a global file-level default preference
per column within each file, using the “=” sign within the header to designate a default value for that
entire column.
For example, you can convert the PayPalEmailAddress header to
[email protected], to make the value of every subsequent row in
this column be [email protected].
If you use smart headers, follow these guidelines:
• Do not use spaces between the header name and the header value you provide. For example,
category 552 should be entered as Category=552.
• Follow the rules for the data field when entering a value. For example, the valid values for “BoldTitle=
are 1 (true) or 0 (false), the valid value for Description=” is any text up to 500,000 characters, and
so on.
• You cannot set a Smart Header for the Action field; you must explicitly list this value for every item
or row.
• If you include an “=” sign after the field header, but do NOT provide a value, eBay File Exchange will
treat this as a valid field header that has no default or global value associated with it and will look for
a value in each row for this field/column.
• Even if you set a Smart Header value, you can still override it on a row-by-row basis.
• If you provide an override value that is invalid for that field, the listing will fail and you will receive a
warning in the results file for that row.
• You can also override a Smart Header with a minus symbol “-” in individual cells. eBay File Exchange
will treat these cells as having no data at all.
17Using and managing template files
File Exchange Advanced Template Instructions
Using quotation marks as text qualifiers
When you use certain punctuation in CSV or .txt files in text fields, you must put quotation marks
around the text, as described in the table below.
Use plain quotation marks ("); do not use smart quotes (“”). If you save an Excel file in .CSV or .TXT
format, Excel automatically adds the required text qualifiers.
For ExampleWhere to put the QuotesPunctuation
"Brand new, with manufacturer
warranty"
Surround the text with quotation marks.Comma or semicolon.
"Clarence ""Lumpy"" Rutherford"Include the text field in quotation marks and then
surround the entire expression with quotation marks.
Quotation marks in a text field; for
example, to denote a nickname or
descriptive modifier.
Using multiple actions and excess fields
Explains how to use the Action field values in the File Exchange templates.
Including multiple Actions in one file
Your uploaded flat files can contain any combination of actions. For example, you can upload a file
that only adds listings; you can also upload a file that contains added listings and revised listings.
However, you can only perform one action per row. Do not attempt to submit a file that contains multiple
actions for the same item as this may cause errors.
Including excess fields for a given Action
If you submit a file that contains unsupported fields for a given action, then File Exchange will ignore
those unsupported fields and process the action if all other required and eligible fields are valid. For
example, if you try to remove a listing using the End action, but supply unnecessary fields like
Description, then File Exchange will ignore those fields and end the listing.
Using and managing template files18
File Exchange Advanced Template Instructions
Performing simple template tasks
This section teaches you how to add new and optional fields to File Exchange templates. The
instructions are based on Microsoft
®
Excel
®
; for different spreadsheet applications, use similar
functions.
Adding a new field to a default template
This section explains how to add new fields to a default File Exchange template.
The default File Exchange templates only contain a subset of all the supported fields; fields need to
be added for most of the optional fields, as well as for new features.This section explains how to add
a new field in one of the default templates, or in one of your working product listing files.
The File Exchange templates contain required and optional fields. Do not change or delete any of the
required field headers.The asterisk (*) is used to designate a required field name (*Action).
An optional field can be deleted, or renamed to serve as a new field that is not in the default templates.
For example, you may not want to use the Subtitle on page 72 field, but would like to offer free shipping
for this item, you can replace it with ShippingService-1:FreeShipping on page 97, and use it for that
purpose.
Another option for adding new fields is to add blank columns in the template, and then add the new
field names in the column header.
Tip: If you want to add multiple new fields that have similar field names, such as Product:MPN
on page 89 for Product:EPID on page 88, use this method:
1. Create a field with the new field name, like Product:MPN.
2. Copy and paste this whole column as many times as needed for your new fields.
3. Revise the appropriate portion of the replicated field names (MPN for EPID).
You do not have to remove unused fields, but doing so after creating and successfully uploading a
new listing file makes it easier to customize and manage different types of product listing files.
Field names must follow the format requirements explained in Template field definitions on page 59.
These instructions describe using Microsoft
®
Excel
®
; if you are using a different spreadsheet
application, use similar functions in that application to complete this procedure.
1. Open a default template or one of your working product listing files.
The default templates are available on the File Exchange Select Template page.
2. Add the following new header field names using one of these methods:
• Click on a field in the first row (except for Action) and select Insert > Column on the menu bar.
Enter a field name in the new column, such as Border, and then press Enter.
• Click on an optional field in the first row that you do not intend to use, such as Highlight. Enter
a new field name in its place, such as BoldTitle on page 59, and then press Enter.
3. Enter values (in the second row, below the field header) for the new fields, and then save the file.
19Performing simple template tasks
File Exchange Advanced Template Instructions
Deleting a field from a default template
This section explains how to remove fields from a default File Exchange template.
The File Exchange templates contain both required and optional fields. Unused optional fields can be
deleted to streamline your template files. Do not change or delete any of the required field headers.
Required fields are in bold type or have an asterisk (*) beside the field name.
Tip: Instead of deleting an unused optional field, it can be renamed to serve as a new field that
is not in the default templates. For example, you may not want to use the BoldTitle on page 59
field, but would like to offer free shipping for this item, you can replace it with
ShippingService-1:FreeShipping on page 97, and use it for that purpose.
To delete an unused optional field, select the column and select Edit > Delete.
Tip: If you want to delete multiple new fields, hold down the Ctrl button while clicking on columns
you want to delete, and then select Edit > Delete.
Deleting multiple field values
This section explains how to remove more than one field value from existing listings.
You can use the DeleteFields field to remove multiple fields, instead of deleting the values in each
field. For example, you want to remove the second category and subtitle from several listings. Instead
of deleting these values in multiple fields, you can delete the fields by entering the field names in the
DeleteFields field.
Not all fields can be deleted; refer to DeleteFields on page 64 for more information.
To delete multiple fields:
1. Open the listing file from which you want to delete certain fields.
2. Add a new blank column to the listing file, and then enter DeleteFields as the field (column)
name.
3. Enter the names of the fields you want to delete in a listing. For example, enter
Category2|Subtitle as the DeleteFields values for one or more listings.
Note: To delete multiple field values, you must separate the field names with the pipe
character "|".
4. Save the file in CSV format, and then upload it to eBay.
Performing simple template tasks20
File Exchange Advanced Template Instructions
Inserting new listings
This section explains how to add items to a template.
Enter data in the template fields
The default templates can be modified using any software program that reads comma-separated value
(CSV) format, such as a spreadsheet program or a text editor. We recommend using a spreadsheet
program, which structures the information in a table layout.
1. Use the fields below to enter data for your listings (asterisks (*) denote required fields):
ExampleAccepted ValuesPurposeHeader Field Name
ReviseAdd, Revise, Relist, End,
Status, VerifyAdd,
AddToItemDescription
Specifies the purpose of the
row.
*Action on page 59
Organic Body LotionOpen; user-defined
80 characters (including blank
spaces)
Specifies which terms are
found when buyers search
for products. Use multiple
terms so it's easy for buyers
to search for this product.
*Title on page 72
AppleOpen; user-definedSpecifies the product brand.Product:Brand on page 88
iPHONE3G8GBBLKATTREFOpen; user-definedSpecifies the manufacturer
part number.
Product:MPN on page 89
426351144531Open; user-definedSpecifies the product code
number or key used by the
Product:UPC on page 90
manufacturer to identify the
product.
6351144531942Open; user-definedSpecifies the product code
number or key used by the
Product:EAN on page 88
manufacturer to identify the
product.
5 -in-1 Printer, Fax,
Scanner, Copier, and
Card Reader
Open; user-defined
500,000 characters (including
blank spaces)
Specifies product details and
general information.To use
multiple line descriptions,
enter HTML text here, and
use the <BR> and <P> tags
to separate the lines.
*Description on page 65
10Open; user-definedSpecifies the number of this
type of item for sale.
*Quantity on page 69
Commas between integers
are not required for large
numbers.
10Only certain values are
allowed, and the choice of
Specifies how long the listing
will be posted on eBay.
*Duration on page 65
values depends on the listingChoose 1, 3, 5, 7, or 10 for
format.Valid Auction and Fixedall formats except
Price durations include: 1, 3,
StoresFixedPrice. Use 30 or
Good 'Til Cancelled for
StoresFixedPrice listings.
5, 7, and 10 (days). If you are
a qualified seller, you can also
21Inserting new listings
File Exchange Advanced Template Instructions
ExampleAccepted ValuesPurposeHeader Field Name
use (30) days, and GTC (for
the Good Til Cancelled) for
FixedPrice.
1Indicates that immediate
payment is required from the
Specifies whether immediate
payment is required.This is
ImmediatePayRequired on page
78
buyer. For more information,a boolean value, meaning 1=
see Requiring immediate
payment.
true, or "yes."
WorldofGood.com listings
require immediate payment,
so enter 1.
95124Open; user-defined
45 characters (including blank
spaces)
Indicates to the buyer the
location from where the item
will be shipped. Postal zip
codes are supported, or
include city, state (two-letter
*Location on page 68
abbreviation), and country
(three-letter abbreviation).
FlatOpen; user-definedDetermines whether you use
a standard (flat) or calculated
rate for shipping.
*ShippingType on page 76
Only Flat or Calculated are
valid entries. If Calculated is
used, no entry for
ShippingService-1:Cost on
page 97 is needed.
UPSGroundOpen; user-definedIdentifies the shipping
service carrier.
ShippingService-1:Option on
page 97
For valid shipping service
entries, refer to Shipping
services fields on page 90.
Must accompany an entry for
ShippingService-1:Cost on
page 97.
Note: Field values are sometimes required for only certain categories. For example, the
Service Provider field value is required for phones, but not video games. The Platform field
value is required for video games, but not phones.The upload response file denotes whether
required values are missing.
2. When you are done, save the file in CSV format to a location on your computer.
Using product identifiers
This section explains how to use the new product fields in one of the default templates, or in one of
your current listing files.
There are new Product fields you can use to enter product information into a listing.These new fields
enable you to leverage existing catalog information for your listings, and have replaced the
Inserting new listings22
File Exchange Advanced Template Instructions
ProductIDType and ProductIDValue fields.To learn more about the new product fields, refer to Product
code and details fields on page 88.
There are two types of product fields: Product:<code> and Product:<details>. The Product:<code>
fields define the type of product identifier; the Product:<details> fields define which product information
that you want to include in the listing.
For example, the Product:ISBN field will identify the product in our catalog, and add the title, description,
and stock photo when available.The Product:IncludePreFilledItemInformation field will add the publisher,
edition, author, and other product details in our eBay catalog.
The Product:<code> fields are:
• Product:Brand on page 88—Enter the Brand name in this field.The brand name is typically the
primary name you see on the product.
• Product:ISBN on page 89—Enter the International Standard Book Number (ISBN) in this field. To
find the number, look below the ISBN bar code on the book cover, or on the back of the title page in
the book.
• Product:MPN on page 89—Enter the Manufacturer Part Number (MPN) in this field.To find the
number, look on the outside of the product.The product Owner's Manual will tell you where the part
number is located.
• Product:EPID on page 88—Enter the eBay ePID in this field.
• Product:UPC on page 90—Enter the Universal Product Code (UPC) in this field.To find the number,
look below the UPC bar code on the outside of the product.
Note: The Brand and MPN fields must both be used for an item, but the other Product:<code>
fields must be used individually. For example, ISBN and UPC cannot both be used for the same
item.
The Product:<details> fields are:
• Product:IncludePrefilledItemInformation on page 89 – Enter a 1 in this field to use the industry-standard
information in our catalog.
• Product:IncludeStockPhotoURL on page 89 – Enter a 1 in this field to use the stock photo in our
catalog (when available).
Note: Some categories, like Coins and Paper Money, do not allow the use of stock photos.
• Product:UseStockPhotoURLAsGallery on page 90 – Enter a 1 in this field to use the stock photo in
our catalog (when available) as your Gallery picture.
Note: To use your own self-hosted photo as the Gallery picture, enter a 0 in this field, and use
the PicURL field to specify the picture to be used as your Gallery picture.
• Product:ReturnSearchResultsOnDuplicates on page 90 – Enter a 1 in this field to get definitive
information about the product when multiple matches are found in the catalog.You will need to
download a Load Response report in order to get the ePID that best matches your item.
To add product codes and details, follow these steps:
1. Open a new Catalog template file from the File Exchange Select Template page. If you are using
one of your existing Catalog templates, you will need to add the new product fields manually.
2. In the Product:UPC field, enter the UPC number for the item.
23Inserting new listings
File Exchange Advanced Template Instructions
3. In the Product:IncludePreFilledItemInformation field, enter 1. This will add the item information in
our catalog to your listing.
4. In the Product:IncludeStockPhotoURL field, enter 1.This will add the standard photo in our catalog
to your listing.
Using relationship fields for parts compatibility
This section explains how to use the new relationship fields in a generated listing template to add
compatibility information to a listing.
Use the relationship fields (Relationship on page 70 and RelationshipDetails on page 70) to add
automotive parts compatibility information to a listing on eBay Motors.These new fields enable you
to define the Make, Model, and Year of the vehicles that use the automotive parts you are selling.You
can match up to 300 vehicles per listing. Notes can be used to enter any additional information or
restriction, (e.g., "Only for automatic transmission") to a specific vehicle.
You can also list motorcycle parts.You can define the Make, Model, Year, and Submodel of the
motorcycles that use the parts you have to sell.You can match up to 1000 motorcycles per listing.
Unlike regular listings, the relationship fields use an item-variation hierarchical structure.The first (item)
row contains the typical listing information, like Action, Title, Quantity, and Price, while subsequent
(variation) rows use the Relationship and RelationshipDetails fields to contain the compatibility
information:
• Make:Toyota
• Model: Corolla
• Year: 2000
QuantityTitleRelationshipDetailsRelationshipCategoryAction
10Halogen
Headlights
170583Add
Make=Toyota|Model=Corolla|Year=2000Compatibility
Make=Toyota|Model=Camry|Year=2000Compatibility
Make=Honda|Model=Pilot|Year=2001Compatibility
To use compatibility information, you first need to download an Item Specifics template file:
1. Go to the File Exchange Select Template page.
2. Under Item Specifics Category template, click Select a Category.
3. On the Select Template: Item Specifics page, under Browse Categories, select the desired category.
For example, eBay Motors > Parts and Accessories.
4. Select the Parts category that best describes the part you are selling:
• For vehicles, select Car & Truck Parts
• For motorcycles, select Motorcycle Parts
5. Continue to select category options until the category number is displayed in the Category field.
For example:
• For a vehicle headlight, if you select Lighting & Lamps > Headlight, the Category field displays
44294
Inserting new listings24
File Exchange Advanced Template Instructions
• For a motorcycle saddlebag, if you select British & European > Luggage & Saddlebags, the
Category field displays 84148
6. Click Generate Template. A listing template is generated for you to download.
7. On the Generate Template page, click the Item Specifics Category Template link, and save the
file on your computer.You will use this file in the next procedure.
8. For vehicle listings only (not motorcycle listings), download the eBay Master Vehicle List (MVL)
compatibility information file that contains vehicle details such as make, model, year, trim and
engine information.To obtain the file and save it on your computer, go to the Parts Compatibility
Listings page.
To add compatibility information to a listing:
1. Open the new Item Specifics Category template that you downloaded in step 6 above.
2. In the first available listing row, enter Add in the Action field. Enter other listing information for the
item, like Title, Description, StartPrice, and Quantity (for starters).
3. In the next row, enter Compatibility in the Relationship field.
4. For vehicles only (not motorcycles), open the eBay MVL file you downloaded in step 7 above.
Search for the make, model, and year of the vehicle that the part fits. For example, Toyota Tundra
2002. (To organize the vehicle listings, you can sort each column in ascending or descending
order.) Multiple vehicle matches may occur that differ in certain ways, such as Trim, Engine, and
Drive Type. Identify the row(s) that contain the vehicle information associated with the part you are
selling.
Tip: Depending on the part, such as a headlight, you may be able to use more than one of
the vehicle matches found. Other parts, like a door handle, may only apply to vehicles with
a particular trim type (Trim differentiates model versions).
5. Once you've identified the rows that apply to your part, copy the text from the matching field(s).
Switch to the listing template file, and enter the information in the RelationshipDetails field. The
text should look like this:
RelationshipDetailsRelationshipTitleCategoryAction
Halogen Headlights44294Add
Toyota Tundra 2002 BaseCompatibility
Toyota Tundra 2002 LimitedCompatibility
Toyota Tundra 2002 SR5Compatibility
6. Copy Compatibility into the Relationship field for all the rows that contain RelationshipDetails
information and then modify the text in the RelationshipDetails field to use the proper syntax. For
vehicles, the eBay_Master_Vehicle_List_US.csv file contains the names (in the column headers)
that need to be coupled with the values you just pasted (like Make and Model).The following table
uses bold to indicate the text you need to add.Values for Make, Model, Year, and Trim are
mandatory, while values for DriveType, Engine,Body, and Notes are optional. Use the pipe character
( | ) to separate the name=value pairs.
Note: Be aware that when just using Make, Model, Year, and Trim, all the related vehicles
(all different Type, Engine, etc. combinations) that are in the MVL will be added automatically
to the compatibility table.The same thing happens when you add the Notes information.The
Notes will be added to each single vehicle.
25Inserting new listings
File Exchange Advanced Template Instructions
RelationshipDetailsRelationship
Make=Toyota|Model=Tundra|Year=2002|Trim=Base|Notes=Only for AutomaticCompatibility
Make=Toyota|Model=Tundra|Year=2002|Trim=Limited|Notes=Only for AutomaticCompatibility
Make=Toyota|Model=Tundra|Year=2002|Trim=SR5|Notes=Only for AutomaticCompatibility
7. To add compatibility information for all the other vehicles that the part fits, repeat steps 3-6 above.
8. To create other part listings, repeat steps 2-6 above to enter data in the next available blank rows.
9. Enter any required or desired field values for each item in the appropriate fields (like shipping and
payment information).
10. Save the file in the comma-separated value (CSV) format.
Using eBay Product Identification numbers to list parts
You can use an eBay Product Identification (ePID) number to list a part.When you use an eBay ePID
number to list a part, you need not use the Relationship or RelationshipDetails fields. Instead, use the
Product:EPID field. For more information about ePID numbers, see Using product identifiers on page
22. For example:
Product:EPIDTitleCategoryAction
EPID76904638ACDelco high beam halogen66471Add
To find an ePID number:
1. On the ePID Search Tool page, describe the part you want to find. Be as specific as possible.
When a description results in more than 10,000 hits, only the first 10,000 results are returned.
Should this occur, refine your criteria and repeat the search.
2. From the Search Catalog drop-down list, select US - Parts & Accessories, US - Rims, or US - Tires.
3. Do one of the following:
• To list parts with the matching ePID numbers, click Search.
• To copy the search results to a spreadsheet file, click Export to Excel.
4. To use the ePID number to list a part with the Product:EPID field, see the table above.
Modifying compatibility information
To change compatibility information, insert Revise in the Action field in the listing row, and insert
Delete in the Action field to remove the values you want to change.To replace the values you're
deleting, add values in the subsequent rows. For example, the rows with Delete in the Action field are
removed and replaced with the subsequent row (no Action value is specified).
In this example, the 2000 year information is replaced by the 2001 data.
TitleRelationshipDetailsRelationshipCategoryItemIDAction
Item 1101100296Revise
Make=Toyota|Model=Tundra|Year=2000CompatibilityDelete
Make=Toyota|Model=Tundra|Year=2000CompatibilityDelete
Make=Toyota|Model=Tundra|Year=2001Compatibility
Inserting new listings26
File Exchange Advanced Template Instructions
Make=Toyota|Model=Tundra|Year=2001Compatibility
Using relationship fields for variation
This section explains how to use the new relationship fields in a generated listing template for adding
variation information to a listing.
There are new relationship fields for adding varied product information to a multi-quantity listing.These
new fields enable you to sell products that are similar, like shirts, in a variety of colors and sizes, all
in the same listing.Variation helps you define products in addition to Item Specifics, and can leverage
the CustomLabel field for inventory references.
Unlike regular listings, the relationship fields use an item-variation hierarchical structure.The first (item)
row contains the normal listing information, like Action, Category, Format, and other shared information
(like shipping and payment options) that apply to all the variations in the listing.
The subsequent (variation) rows contain the information that applies to each variation, like Relationship,
RelationshipDetails, Quantity, StartPrice, CustomLabel, and PicURL fields.The following paragraphs
explain the item and variation row field requirements.
Relationship on page 70: Indicates variation information will be added to the listing when the Variation
value is used.
• Item row: Leave empty.
• Variation row: Enter Variation.
RelationshipDetails on page 70: Defines the variation details, like color and size, in the variation rows,
but must contain all possible variations in the item row. Do not add blank spaces between traits or
values in either row, or the upload will fail.
• Item row: Define all traits (like color and size) and their possible values (like Blue and Red, Medium
and Large). Use the format: Trait1=Value1;Value2|Trait2=Value1;Value2. For example:
Color=Blue;Red|Size=M;L.
• Variation row: Define the single value for each applicable trait for this variation. Use the format:
Trait1=Value1|Trait2=Value1. For example: Color=Blue|Size=M.
*Quantity on page 69: Specifies the number of items available for each variation.
• Item row: Leave empty.
• Variation row: Specify the quantity available for this variation. A value is required, and it must be
greater than zero.
*StartPrice on page 87: Specifies the price of the item.
• Item row: Leave empty.
• Variation row: Specify the Auction-style listing start price, or the purchase price for a FixedPrice
listing.Values in these fields are required.
The initial item and variation rows for a listing should look like this:
StartPriceQuantityRelationshipDetailsRelationshipCategoryAction
Size=S;M;L;XL|Color=Black;Pink;Red;Blue170583Add
7.995Color=Black|Size=XLVariation
27Inserting new listings
File Exchange Advanced Template Instructions
10.995Color=Red|Size=SVariation
8.994Color=Pink|Size=MVariation
Other fields also have item and variation row requirements:
CustomLabel on page 64: Specifies the SKU codes for certain variations.
• Item row: Specify the custom label (SKU) for the listing. This field is optional.
• Variation row: Specify the custom label (SKU) for this particular variation. This field is optional.
PicURL on page 69: Defines the image URL(s) for a variation. If you are only using a single image for
a variation, it can be a self-hosted image or hosted by eBay Picture Services (EPS). To use multiple
images in a variation, you must use EPS.
Image URLs must not contain blank spaces. For information about how to alleviate this issue, and
learn about other field requirements, refer to PicURL on page 69.
• Item row: Specify the item-level picture to show a typical example of the product or item.This image
will appear as the primary picture for all variations. For example,
• Variation row: Specify the specific picture(s) to use for this variation.To use more than one image
for a variation, separate the image URLs with a pipe character ( | ). For example, multiple pictures
for the same colored shirts would require multiple image URLs: Black=URL1|URL2|URL3.
Note: PicURL values for variations of a given item must use a single trait name. For example,
if one variation has Black=URL1|URL2|URL3 and the next variation has
Blue=URL4|URL5|URL6, these are valid combinations because the same trait (color) is used.
However, if one variation has Black=URL1|URL2|URL3, and the next variation has
Medium=URL4|URL5|URL6, this is an invalid combination because two traits (color and size)
are used.
Tip: If an item already has a variation row with pictures defined for a given trait value, you do
not need to re-define them again. For example, one variation has RelationshipDetails as
Color=Black|Size=Small and PicURL as Black=http://host.com/my.jpg. If the
next variation has RelationshipDetails as Color=Black|Size=Medium, you do not need
to put Black=http://host.com/my.jpg for the PicURL field again because the image for
Black has already been defined.
The optional item and variation rows for a listing should look like this:
PicURLCustomLabelStartPrice...Action
mens-shirts-c...Add
Black=URL1Black-XL7.99...
Red=URL2Red-S10.99...
Pink=URL3Pink-M8.99...
Below are examples of multiple images in the PicURL variation rows
mens-jackets-d...Add
Black=URL1|URL2|URL3Black-Leather199.99...
Brown=URL4|URL5Brown-Leather189.99...
Inserting new listings28
File Exchange Advanced Template Instructions
Red=URL6|URL7Red-Leather209.99...
Note: If an existing listing contains no variations, you cannot revise that listing to include
variations. Instead, you must end that listing, and then create a new listing with variations.
To use the new fields, you need to download a new Item Specifics Category template to get the new
fields, and add the variation values in the RelationshipDetails field from the Item Specifics Definition
file (generated alongside the template) .
1. Go to the File Exchange Select Template page.
2. Under Item Specifics Category template, click Select a Category and then under Browse Categories,
select a Clothing, Shoes and Accessories category (for example).
Note: Variation is not supported in all categories. For a list of supported categories, refer to
the category look-up page.
3. Select the category that best describes the item you are selling, like Men's Clothing, and keep
selecting category options until the category number is defined. For example, for a shirt, you would
select Shirts > Dress. The Category field displays the category number: 57991.
4. Click Generate Template. A listing template is generated for you to download.
5. On the Generate Template page, click the Item Specifics Category Template link, and save the
file on your computer.You will use this file in the procedure below.
Next, click the Item Specifics Definitions link on the Generate Template page.We recommend that
you use the variation information values from this Item Specifics Definition file, but you can also create
your own variations.
To add variation information to a listing:
1. Open the new Item Specifics Category template that you downloaded.
2. In the item row, enter Add in the Action field. Enter the shared listing information for the item, like
Categoryand Format (and others).
3. In the same row, enter all the possible variations an item may have in a listing. For example, enter
Size=S;M;L;XL|Color=Black;Pink;Red;Blue in the RelationshipDetails field.
4. In the variation row, enter Variation in the Relationship field.
5. Enter the variations used for items you're selling in the RelationshipDetails field, as shown in the
example below. For variations, enter values for Quantity, CustomLabel, PicURL (and others) in the
variation rows.
6. For additional item variations, repeat steps 2-5 in the subsequent rows.
7. Enter any other required or desired field values for the item in the appropriate fields (like payment
and return policy information), and then save the file in comma-separated value (CSV) format.
Once a listing is active, there are several things to consider. For example, what do you do if:
• the value for Quantity falls to zero?
• a pending transaction locks you out of a listing?
29Inserting new listings
File Exchange Advanced Template Instructions
Modifying the RelationshipDetails and PicURL of a variation
Neither the RelationshipDetails on page 70 nor the PicURL on page 69 of a variation can be modified
or deleted when one or more transactions are pending against the variation.
To revise the values for RelationshipDetails or PicURL, you must first delete the variation you want to
modify, and then add the new variation that replaces it. Use Revise in the Action field in the item row,
use Delete in the Action field in the variation row(s) that you want to change, and then add the row
that contains the modified RelationshipDetails or PicURL. For example, the second row (below) with
Delete in the Action field is removed and replaced in the subsequent row (with no Action value
specified).
TitleRelationshipDetailsRelationshipCategoryItemIDAction
Item 1Color=Black;Pink;Red;Blue; BlackStripes|Size=S;M;L;XL;XXL17058310110~Revise
Color=Black|Size=XLVariationDelete
Color=BlackStripes|Size=XLVariation
In this example, the Black-XL information is replaced with the BlackStripes-XL information.
Tip: To delete a variation, do not add a new row for the variation you want to delete. For example,
do not add the last row shown in the table above.
Modifying the Quantity and StartPrice of a variation
You can modify the values for Quantity and StartPrice even if one or more transactions are pending
against the variation.
To revise *Quantity on page 69 and *StartPrice on page 87, just update the desired values (in other
words, you need not first delete the existing variation and then replace it with the updated content).
For instance, when compared to the example shown earlier in this section, the table below updates
the values for Quantity and StartPrice specific to the variations of Color/Black|Size/XL and
Color/Red|Size/S.
Note: If you set the Quantity of a variation to zero (0), the variation will be shown as out-of-stock.
If no items of the variation have been sold, the variation will be removed.
StartPriceQuantityRelationshipDetailsRelationshipItemIDAction
Size=S;M;L;XL|Color=Black;Pink;Red;Blue10110~Revise
6.993Color=Black|Size=XLVariation
9.993Color=Red|Size=SVariation
8.994Color=Pink|Size=MVariation
Inserting new listings30
File Exchange Advanced Template Instructions
Modifying the Relationship and CustomLabel of a variation
When you delete or modify a variation, the CustomLabel on page 64 associated with the variation is
automatically deleted or modified (you need not modify it explicitly).
Lastly, since the value for Relationship on page 70 is not used for an eBay item, it cannot be modified.
Using a custom item specific field
This section explains how to add a new field for custom item specifics in one of the default templates,
or in one of your working product listing files.
Custom item specifics can be added to provide more details about your item in a listing. Item specific
fields need to be added to a default or existing listing template.You can either replace an unused field,
or add a new field column. For more information, refer to Adding a new field to a default template on
page 19.
Custom item specifics consist of a descriptive field name and correlated field values. For example,
the custom item specific Occasion could have one of several values, such as Casual, Business, or
Formal.
Some clothing and accessory categories require certain item specifics to be included in a listing, such
as:
• Brand
• Size Type
• Size
• Style
• Color
Refer to the look-up table to view the item specifics required by each category.Visit our size chart and
handbag measurement guide for size mapping and measurement instructions.To see how these
changes will impact your existing listings and the way you list, refer to Review category and item
specifics changes.
You can create up to 10 custom item specific fields per item, but each custom item specific field can
have only one value per item. Field names and values must be alphanumeric text strings.
When an item specific value contains a comma, as in the examples below, enclose the entire value
in quotation marks. If not, data that appears to the right of each comma (Chino, Navy, or Royal) will
be inserted into the next adjacent column in the template, thereby invalidating the entry and the
template.
"Khakis,Chino"
"Color=Dark Blue, Navy, Royal"
Custom item specifics can be added to the default templates, but generating an item specifics template
provides predefined custom item specifics tailored for that particular category. Some categories do
not yet support custom item specifics.
31Inserting new listings
File Exchange Advanced Template Instructions
Important: If you revise this field, you must include all of the custom item specific fields for this
listing in the uploaded file, even if the information has not changed. Otherwise; any excluded
custom item specific will be removed from the listing.
To add new custom item specific fields, follow these steps:
1. Open a template file and enter item listing information in the second and third rows. For example,
the listing in the second row might be for a casual shirt.The listing in the third row might be for a
formal shirt.
2. Add a new field column (or replace an unused field name with a custom item specific name). For
example, enter C:Style in the column header. Always use the C: prefix for a custom item specific
name.
3. Enter a value in the second row for the new custom item specific. For example, enter: Casual.
4. Enter a value in the third row for the new custom item specific. For example, enter: Formal.
5. Repeat steps 2-4 to add more custom item specific fields and values.
6. Enter any other required or desired field values for the item in the appropriate fields (like payment
and return policy information), and then save the file in comma-separated value (CSV) format.
Using the ConditionID field
This section explains how to use the ConditionID field in one of the default templates, or in one of your
working product listing files.
Condition values are now defined by *ConditionID on page 63 numbers. A ConditionID value, like
1000, has different meanings, depending on the category used. For example, 1000 means New in a
computer category listing, but means New with box in a shoes category listing.
Because values for ConditionID depend on category, refer to the item condition look-up page to see
if a category requires a condition value, and to see what the Condition definitions are for each category.
To obtain ConditionID values for categories, click the ConditionIDs by Category link on the File
Exchange Instructions and Resources page.
To get the ConditionID values for a particular category, go the File Exchange Select Template page
and generate an Item Specifics template.The generated template contains the new ConditionID field,
and the ConditionID numbers and literal values are defined in the Item Specifics Definitions file that
accompanies the generated template.
To get the available ConditionID values for a given category, follow these steps:
1. Go to the Select Template page, and under Item Specifics Category template, click Select a
category.
2. On the Select Template: Item Specifics page, select the category that best describes your item.
Continue to select sub-categories (to the right) until no more options appear.
Tip: If you already know the category number, enter it in the Category# field.
3. Click Generate Template.
4. On the Generate Template page, click the Item Specifics Category Template link to open the
file.
Inserting new listings32
File Exchange Advanced Template Instructions
5. Click the Item Specifics Definitions link to open the file.
6. In the Item Specifics Definitions file, select the appropriate ConditionID number for your item, and
copy it to the ConditionID field in the Item Specific Category template file.
Note: To update the item condition description in an existing listing template, change the
existing condition column name (A:Condition or C:Condition) to ConditionID and
then enter a numeric value.
7. Enter any other required or desired field values for the item in the appropriate fields (like payment
and return policy information), and then save the file in comma-separated value (CSV) format.
Using the StoreCategory fields
This section explains how to look up your eBay store category numbers and how to use the
StoreCategory and StoreCategory2 fields to include the store category numbers in your listings.
Using store category numbers in a template
When you maintain an eBay store, you can use the StoreCategory on page 71 and StoreCategory2
on page 71 fields to associate your eBay store category numbers with your listings. Entries in the
following table illustrate how to associate listings with eBay store category numbers:
StoreCategory2StoreCategoryTitleAction
301481201330147960131939 Irish Silver Half CrownAdd
301481301330147960131956 Moroccan Silver 500 Francs CoinAdd
Looking up store category numbers
To look up store category numbers:
1. Log in to My eBay.
2. Place the cursor on the Account tab label and select Manage My Store.
3. On the left navigation panel under Store Design, click Store Categories.
4. In the lower right corner of the Manage Store Categories page, click the All Categories link.
5. Take note of the category numbers you want to include in your File Exchange template.
Using the auto-accept and auto-decline fields
This section explains how to add new fields for the auto-accept and auto-decline option in one of the
default templates, or in one of your working product listing files.
To accept or decline best offers from buyers, the item listed must be in a format that supports Best
Offer. For format information about the auto-accept and auto-decline fields, refer to Pricing and cost
fields on page 82.These best offer fields can be added:
• BestOfferEnabled on page 82
33Inserting new listings
File Exchange Advanced Template Instructions
• BestOfferAutoAcceptPrice on page 82
• MinimumBestOfferPrice on page 85
• MinimumBestOfferMessage on page 84
In order to use the best offer function, you must add at least a new field for BestOfferEnabled.
1. Open a template file and add the new field columns (refer to Adding a new field to a default template
on page 19). If if you want to automatically accept or decline offers, you must also add the new
fields, respectively, for BestOfferAutoAcceptPrice and MinimumBestOfferPrice.
2. Enter values for the new fields. For example, enter 1 for BestOfferEnabled. To use the automatic
options, enter the amounts you would accept or decline in the appropriate fields. For example:
• BestOfferAutoAcceptPrice: Enter 15.00
• MinimumBestOfferPrice: Enter 10.00
The delta between the two amounts allows for negotiation with the buyer.
3. Enter any required or desired field values for the item, and then save the file.
Using international site visibility fields
This section explains how to add a new field for international site visibility in one of the default templates,
or in one of your working product listing files.
To have your listings appear in product search results in other countries, you must add the
CrossBorderTrade field to a default template (or a current listing file), and then enter a value for the
new field. Before using international site visibility, read about the qualifications and requirements on
the Showing your items in search results on other eBay sites page. For example, some category
listings allowed in the US may not be supported in other regions of the world.
International site visibility is currently only supported in the United States, Canada, Ireland, and Great
Britain. The list below describes to where each eBay site offers international site visibility:
• United States: UK (United Kingdom)
• Canada: UK (United Kingdom)
• Great Britain: North America (United States and Canada)
• Ireland: North America (United States and Canada)
For example, a seller in Canada would use UK as the CrossBorderTrade field value, whereas a seller
in Ireland would use North America.
To add international site visibility information, follow these steps:
1. Open a template file and add a new field column (refer to Adding a new field to a default template
on page 19). Enter CrossBorderTrade in the new field header.
2. Enter a region value for the new field. For example, if your primary eBay site is in the US, enter:
UK.
3. Enter values for any required shipping information fields. For example, shipping carrier and location
information need to be entered in the IntlShippingService-1:Option and
IntlShippingService-1:Locations fields, respectively. Similarly, using flat-rate shipping requires a
value in the IntlShippingService-1:Cost field.
4. Enter any required or desired field values for the item, and then save the file.
Inserting new listings34
File Exchange Advanced Template Instructions
Using buyer requirements
This section explains how to define buyer requirements on the eBay Site Preferences page and how
to use File Exchange to apply those requirements to your listings.
Setting up buyer requirements
You can optionally require that potential buyers meet a minimum set of benchmarks. Setting up these
minimum requirements to qualify your buyers can improve the quality of the bids you receive. On the
other hand, think carefully before blocking buyers.While defining buyer requirements may reduce your
exposure to buyers who might make transactions difficult, it will also reduce the number of potential
buyers.
You can also block specific buyers if you know their eBay user ID. To create a list of the eBay user
IDs you want to block from bidding on your listings, see Block bidders or buyers from your listings.
To define buyer requirements in My eBay:
1. Log in to eBay and go to My eBay > Account > Site Preferences.
2. Under Selling Preferences, find Buyer Requirements and click Show.
3. To display the Buyer Requirements page, next to Block Buyers Who, click Edit.
4. On the Buyer Requirements page, specify the restrictions you want to impose on buyers. For more
information about the options on this page, see Selecting buyer requirements.
5. To apply the settings to your active and future listings, select Apply Above Settings to Active and
Future Listings.
6. To prevent blocked buyers from contacting you, select Don't Allow Blocked Buyers to Contact Me.
7. To save your selections, click Submit.
8. To use File Exchange to apply your buyer restrictions to your listings, see Applying buyer
requirements to listings on page 35.
Applying buyer requirements to listings
You can use File Exchange to apply your buyer requirements choices to your listings.The table below
pairs buyer requirements options with the respective File Exchange fields:
File Exchange FieldBuyer Requirements Option
BuyerRequirements:LinkedPayPalAccount on page 59Buyers without a PayPal account
BuyerRequirements:MaxUnpaidItemsCount on page 60Buyers with unpaid item strikes
BuyerRequirements:MaxUnpaidItemsPeriod on page 61
BuyerRequirements:ShiptoRegCountry on page 62Buyers in locations to which I don't ship
BuyerRequirements:MaxViolationCount on page 61Buyers with policy violation reports
BuyerRequirements:MaxViolationPeriod on page 61
35Inserting new listings
File Exchange Advanced Template Instructions
BuyerRequirements:MinimumFeedbackScore on page 61Buyers with a negative feedback score
BuyerRequirements:MaximumItemCount on page 60
Buyers who may bid on several of my items and
not pay for them
BuyerRequirements:MaxItemMinFeedback on page 60
For example, entries in the following table block buyers from bidding on your listings when their primary
address falls outside your delivery area and when their minimum feedback score falls below -2:
BuyerRequirements:
MinimumFeedbackScore
BuyerRequirements:
ShiptoRegCountry
TitleAction
-21Canon Digital Rebel SLR 14MPAdd
-21Apple iPhone 3g 32MB WhiteAdd
To use File Exchange to apply your buyer requirements to your listings:
1. Download a File Exchange template.
2. For each item to which you want to apply buyer requirements, insert a column and add the desired
BuyerRequirements field.To view the respective field names, see the previous section entitled
Setting up buyer requirements on page 35.
3. Save the file.
When you upload the file to File Exchange, your listings automatically inherit the buyer requirements
you specify.
Inserting new listings36
File Exchange Advanced Template Instructions
Specifying payments, shipping, and returns
Use this section to learn how to set up payment, shipping, and return options in File Exchange.
Using the payments fields
This section explains how to use the payment fields in the default templates.
For more information about payment fields, see Payment and return fields on page 78.
Different sites support different payment options.To make payments easier to specify and to understand,
many eBay sites offer a standardized way to specify payment information.The list of payment options
appears below:
• AmEx on page 78
• Discover on page 78
• IntegratedMerchantCreditCard on page 79
• MOCashiers on page 79
• PayPalAccepted on page 80
• PersonalCheck on page 80
• VisaMastercard on page 82
To add payment information to your listing template:
1. In the template, insert a column for each payment type (or field) you want to offer.
2. For each item and in each payment column, enter a 1 (true) to denote the acceptable payment
options or 0 (false). For example:
PersonalCheckPayPalAcceptedMOCCPayUponPickupTitle
1111Samsung Galaxy Ace
0111Canon EOS 550D DSLR
0000Ancient Chinese Coin
0000Silver Ingot Poured 10 oz
3. Save your work.
Using shipping discount fields
This section explains how to create combined payments and shipping discounts rules and profiles,
and then add new fields for shipping discounts in one of the default templates. Follow this procedure
to use the InternationalShippingDiscountProfileID field as well as the
ShippingDiscountProfileID field.
Combining payments to offer shipping discounts
Useg shipping discounts to offer savings to buyers when they purchase multiple items from you at the
same time. Doing so may encourage buyers to buy additional items.To apply shipping discounts, you
37Specifying payments, shipping, and returns
File Exchange Advanced Template Instructions
must use combined payments. For an overview about shipping discount rules and profiles, refer to
Using Combined Payments and About Shipping Discounts.
To set up shipping discounts:
1. Log in to eBay and go to My eBay.
2. Go to Account > Site Preferences.
3. Under Selling Preferences, find Shipping Preferences, and click Show.
4. Locate Offer combined payments and shipping and select Edit.
5. To verify that this preference is enabled, find Combined payments. If so, verify that the number
days allowed for combined payments meets your expectations.To change the number of days,
click Edit, make the change, and click Save.
If combined payments are disabled, click Create, click the Allow box, and select the desired number
of days from the menu. When finished, click Save.
6. Under Combined Shipping Discounts, select Create under either Flat shipping rule or Calculated
shipping rule. For calculated shipping, the options differ but the process follows the same workflow
as for flat shipping.
7. On screen 1, select Add an amount for additional items or Subtract an amount for additional
items from the drop-down list and then enter a value next to Add. Alternatively, select Free Shipping
to ship additional for free.
8. To create a rule profile, select Add Profiles. Enter a profile name in the adjacent box and then
click Next.
9. On screen 2, review your shipping rule profile specifics. If you approve, click Save.
10. Make a note of the Shipping Discount Profile ID numbers that appear under Combined Shipping
Discounts.You will use these Profile ID numbers as ShippingDiscountProfileID field values
in the following section.
Adding shipping discount values to a template
Now that you've created the shipping discount rules and profile(s) for your eBay account, you're ready
to add the shipping discount fields and values to your product listing file (or default template). For
shipping discounts to apply to a product listing, you must add the shipping discount fields and values
for a new item before uploading the new product listing file.
1. Open a template file and look for the field ShippingDiscountProfileID.You need to know the profile
IDs for each of your discount profiles created for you're my eBay Site Preferences.
To locate your shipping profile ID numbers, go to My eBay > Account > Site Preferences >
Shipping Preferences > Show > Offer combined payments and shipping > Edit.The ID numbers
for each shipping rule are listed on the My eBay: Combined Payments and Shipping Discounts
page.
2. Enter the eight digit discount profile ID number. For example, enter 78038543 for
ShippingDiscountProfileID.
3. Enter any required or desired field values for the item, and then save the file.
Using return policy fields
This section explains how to add information for return policy fields in the default templates.
Specifying payments, shipping, and returns38
File Exchange Advanced Template Instructions
Before offering return policies to buyers, visit the eBay return policy page to learn basic return policy
strategies.
For details about each return policy field, see Payment and return fields on page 78.The return policy
fields are:
• AdditionalDetails on page 78
• RefundOption on page 81
• RestockingFeeValueOption on page 81
• *ReturnsAcceptedOption on page 81
• ReturnsWithinOption on page 81
• ShippingCostPaidBy on page 82
Different sites support different return policy options.To make return policies easier to specify and
understand, many eBay sites offer a standardized way to specify and display return policy information.
In addition to describing a return policy in the Description field of an item, you can also use predefined
return policy options.
Note: As a seller, you can elect not to accept returns for the items you list. However, keep in
mind that even if you specify No Returns Accepted, a buyer can still return an item should the
item not match the listing description and become eligible for coverage under eBay Buyer
Protection (items not covered by eBay Buyer Protection cannot be returned).
To use return policy fields:
1. Enter values for the return policy fields. For example:
• AdditionalDetails: (optional) Enter any additional information you want to convey to the buyer
• RefundOption: Enter MoneyBack or MoneyBackOrExchange
• RestockingFeeValueOption:To specify the percentage of the selling price you charge to restock
a returned item, enter Percent_10, Percent_15, Percent_20, or NoRestockingFee
• ReturnsAcceptedOption: Defines the duration a buyer has in which to notify the seller of a return.
Enter ReturnsAccepted or ReturnsNotAccepted
• ReturnsWithinOption: Enter Days_14, Days_30, or Days_60
• ShippingCostPaidBy: Enter Buyer or Seller
2. Enter any required or desired field values for the item, and then save the template.
Using shipment tracking number fields
This section explains how to add new fields for shipment tracking numbers in a blank template file.
To provide buyers with the tracking number and shipping service of a shipped item, you can add two
fields to a default template or working listing file. After you have shipped the item, copy the tracking
number so you can enter it into the template file.
1. Open a blank template file and add four new field columns (refer to Adding a new field to a default
template on page 19).
2. In the Action field, enter Status.
3. In the first blank field header, enter ItemID, and then enter the item ID of this item (in the Upload
Response file) for the value.
39Specifying payments, shipping, and returns
File Exchange Advanced Template Instructions
Note: For multi-quantity item shipments, also add a TransactionID field and the value
for each of the items.
4. In the second blank field header, enter ShippingStatus, and then enter 1 for the value.
5. In the third and fourth blank field headers, enter the field header names below, and then enter the
values for each field:
• ShipmentTrackingNumber: Enter the tracking number (from the shipping invoice) for the
item.
• ShippingCarrierUsed: Enter a valid carrier service (the text string value for the carrier used);
for shipping service values, refer to Shipping services field values on page 102.
6. Delete any other fields in the template.
7. Save the file, and then upload it to eBay.
Using package weight and dimension fields
This section explains the purpose of the packaging weights and dimension field values.
Adding package weight information fields
Packaging weight fields apply only to calculated shipping.
These package weight fields can be added:
• WeightMajor on page 77
• WeightMinor on page 77
• WeightUnit on page 77
Depending on your location, weight values can be imperial (lb, oz) or metric (kg, g). Some sites support
both types of measurements. For example, the Canadian eBay site supports imperial and metric
weights whereas the Australian eBay site supports metric weights only. For more information about
the weight fields, refer to Packaging and handling fields on page 72.
1. Open a template file and add the new field columns (refer to Adding a new field to a default template
on page 19). Add the new fields you want to use, such as WeighMajor, WeightMinor, and WeightUnit.
2. Enter values for the new fields. For example:
• WeightMajor: Enter 2 (pounds)
• WeightMinor: Enter 14 (ounces)
3. Enter values for any required shipping information fields. For example, shipping carrier and location
information need to be entered in the IntlShippingService-1:Option and
IntlShippingService-1:Locations fields, respectively. Similarly, using flat-rate shipping requires a
value in the IntlShippingService-1:Cost field.
4. Enter any required or desired field values for the item and then save the file.
Specifying payments, shipping, and returns40
File Exchange Advanced Template Instructions
Adding package dimension information fields
Packaging dimension fields apply only to calculated shipping.
These package weight fields can be added:
• PackageLength on page 73
• PackageType on page 74
• PackageWidth on page 74
Depending on your location, Dimension values can be imperial (in) or metric (cm). Some sites support
both measurements. For example, the Canadian eBay site supports imperial and metric dimensions
while Australian eBay site supports metric dimensions only. For more information about the dimension
fields, refer to Packaging and handling fields on page 72.
To add dimensions to your listings:
1. Open a template file and add the new field columns (refer to Adding a new field to a default template
on page 19 ) such as PackageLength, PackageDepth, and PackageWidth.
2. Enter values for the new fields. For example:
• PackageLength: Enter 20 (inches)
• PackageDepth: Enter 14 (inches)
• PackageWidth: Enter 18 (inches)
3. Enter values for the required shipping information fields. For example, shipping carrier and location
information must be entered in the IntlShippingService-1:Option and IntlShippingService-1:Locations
fields, respectively. Similarly, flat-rate shipping requires a value in the IntlShippingService-1:Cost
field.
4. Save the file.
Using shipping rate tables
Use this section to learn how to create a shipping rate table and apply the values it contains to your
listings on eBay.
Creating a domestic shipping rate table
You can optionally set up a single domestic shipping rate table to provide pricing and service time
details for orders delivered in-country. For example, you can create a rate table to specify shipping
costs to areas in the continental United States, Alaska/Hawaii, United States protectorates (Puerto
Rico, Guam), and to Army Post Office (APO) and Fleet Post Office (FPO) addresses in the United
States.
You can also exclude delivery to entire regions or specific countries. For more information, see Exclude
Shipping Locations.
When you set up a shipping rate table, you can specify a rate for each region and service level you
want to support.You can opt to specify shipping rates per item, per weight, or by surcharge. Only one
41Specifying payments, shipping, and returns
File Exchange Advanced Template Instructions
of these rate types can be implemented at a time. An example of each type is shown below. For a
shipping rate table to be valid, it must contain at least one value.
Note: When you update a shipping rate table, updates are automatically applied to new listings.
That is, updates are not applied to existing listings.
To create a per item shipping rate table, see the example below:
One-DayExpeditedStandardEconomyDomestic Region
1 day3-5 days7-9 days11-15 days
$20.00$10.00$7.50$5.00US Mainland
-$13.00$10.00$7.00Alaska/Hawaii
--$12.00-US Protectorates
Military MailMilitary MailMilitary MailMilitary MailAPO, FPO
--$12.00-
To create a shipping rate table based on weight, see the example below:
One-DayExpeditedStandardEconomyDomestic Region
1 day3-5 days7-9 days11-15 days
$20.00$10.00$7.50$5.00US Mainland
+ $2.00/lb+ $0.50/lb--
$17.00$13.00$10.00$7.00Alaska/Hawaii
+ $1.00/lb+ $0.75/lb+ $0.50/lb+ $0.50/lb
--$12.00$10.00US Protectorates
--+ $0.50/lb+ $0.50/lb
Military MailMilitary MailMilitary MailMilitary MailAPO, FPO
--$12.00-
--+ $0.60/lb-
To add a surcharge to a shipping rate table, see the example below. Surcharges can be applied only
when you have also specified a Flat rate for the class of service on the item.
One-DayExpeditedStandardEconomyDomestic Region
1 day3-5 days7-9 days11-15 days
+ $1.25+ $0.75--US Mainland
+ $1.50+ $1.00--Alaska/Hawaii
+ $1.50+ $1.00+ $0.50/lb+ $0.50/lbUS Protectorates
Military MailMilitary MailMilitary MailMilitary MailAPO, FPO
+ $1.50/lb+ $1.00/lb+ $0.50/lb+ $0.50/lb
To create a domestic shipping rate table:
Specifying payments, shipping, and returns42
File Exchange Advanced Template Instructions
1. Log in to eBay and go to My eBay > Account > Site Preferences.
2. Next to Shipping Preferences, click Show.
3. Next to Use Shipping Rate Tables, click Edit.
4. On the Shipping Rate Tables page, select the type of rate table you want to create – Item, Weight,
or Surcharge – from the Set Domestic Shipping Rates drop-down list.
5. Into the Domestic Rate Tables form, enter your shipping specifics.
For guidance, see the three examples presented above.The domestic shipping rate table must
contain at least one value. If not, an error will occur when you upload the template to File Exchange.
6. Save the template.
7. To upload values specified in the shipping rate table to File Exchange, see Applying a shipping
rate table to listings.
Applying a shipping rate table to listings
Using File Exchange, you can apply the rates contained in your shipping rate table to your listings in
eBay.To do so, you enter the following values into the fields entitled DomesticRateTable and
ShippingType:
ShippingTypeDomesticRateTableTitleCategoryAction
FlatDefaultCanon Digital Rebel SLR 14MP63850Add
FlatDefaultApple iPhone 3g 32MB White9355Add
To apply your domestic shipping rate table to listings:
1. Download a File Exchange template.
2. For each item to which you want to apply a rate contained in the shipping rate table, find the field
entitled DomesticRateTable and enter Default. Next, insert a new column entitled
ShippingType and enter the value Flat, as shown in the table above.
3. Save the template.
Once uploaded to File Exchange, your listings automatically include the shipping rates and service
times defined in the shipping rate table you created above in Creating a domestic shipping rate
table.
43Specifying payments, shipping, and returns
File Exchange Advanced Template Instructions
Updating your listings
Use this section to revise existing listings. For example, you can change the price, update the available
quantity, or modify the description.
Using revision files
This section explains how to simplify the revision process by downloading and then updating listing
files.
To simplify the revision process, you can download files that contain existing listing information, which
you can then update with only minimal changes before uploading those changes to eBay. File Exchange
allows up to 5,000 uploaded listings per day. To upload as many as 10,000 listings per day, contact
Customer Support.
For information about adding product identifiers to your active listings, see Adding product identifiers
to Active listings on page 45.
On the Create a Download Request page, you can download these types of revision files:
• Revise price and quantity: Use to update the SiteID, Currency, StartPrice, BuyItNowPrice, and
Quantity fields in Active listings.
• Revise payment status: Use to update the PaymentStatus field in Sold listings.
• Revise shipping status: Use to update the ShippingStatus, ShippingCarrierUsed, and
ShipmentTrackingNumber fields in Sold listings.
• Product Identifiers: Use to update the UPC/EAN/ISBN/Brand/MPN field in Active listings.
In addition to the fields you use to update your listings, the revision files provide the Action and ItemID
fields and values.These field values need not be changed.
You perform the same steps to download the Active Listings and Sold Listings revision files; the type
of revision file you use determines which fields are contained in the downloaded file.
To download a revision file:
1. Using a web browser, go to the Create a Download Request page.
2. Select Active Listings or Sold Listings from the Listing and Records drop-down menu.
3. Select File Exchange for the Download format, and then select the desired type of revision file
from the drop-down menu (such as Revise Price and Quantity or Add Unique Identifiers
(UPC/EAN/ISBN/Brand/MPN)).
4. UnderDate Range, select All Records to download all Active or Sold listings, or use another option
to refine the range of dates you want to include.
5. Verify your eBay account email address.
6. Click Save. Be sure to make a note of the download request reference number on the Create a
Download Request: Success page.This number identifies the revision file you just requested.
7. In the navigation bar, click Completed Downloads.The View Completed Downloads page provides
a link to download the revision files. After your request has been processed, you'll see the reference
number on this page. Click the adjacent Download link.
8. When prompted, open the file.When the file is opened in a spreadsheet application, save it on
your computer.
Updating your listings44
File Exchange Advanced Template Instructions
9. If you are using Microsoft Excel, to display the ItemID listing numbers select the ItemID column,
click the right-mouse button, and then select Format Cells. In the Format Cells window under
Category, select Number, set Decimal Places to 0, and then click OK.
10. To revise field values, update the fields you want to change, such as Title or Quantity.When you
are finished, save the file in CSV form and then close the file.
11. Using a web browser, go to the Upload Listings & Updates page and click the Browse button next
to File Location to select the file you saved in step 10 above.
12. Click Upload.
To verify that your changes were uploaded, click View Upload Results in the navigation bar.
Adding product identifiers to Active listings
This section describes how to use File Exchange to add unique product identifiers (UPI) to your eBay
listings. Its purpose is to help you revise your active listings so that your products on eBay can be
more easily found when buyers perform product searches.
Revising your Active listings
This procedure explains how to add product identifiers to your active listings.
1. To download your active listings, see the download procedure in Using revision files on page 44.
2. In the downloaded Active Listings file, right-click the ItemID column and select Format Cells >
Number. Change the Decimal Places value to 0, and then click OK.
3. If you know the eBay Product ID (ePID) for an item, enter this ID in the Product:EPID field first.
This alleviates the need to use the other product identifiers. If not, start with the Product:UPC
column, and enter the universal product code (UPC) for that item. If the item does not have a UPC,
then enter the ISBN or EAN next. For items that do not have these types of product identifiers,
enter the brand name and manufacturer part number (MPN).
4. When you are finished adding product identifiers for each item, save the file in CSV format with a
file name you can easily identify.
5. To upload the file, go to the Upload Listings & Updates page and click the Browse button next to
File Location to select the file you modified.
If the response file returns an error stating there are multiple UPC, EAN, or ISBN product identifiers
for your item (due to different versions, formats, or editions), perform a search for the item on eBay,
locate the ePID, and then enter it in the Product:EPID field. This will resolve the error.
Tip: Refer to Using product identifiers on page 22 for more information about each field.
45Updating your listings
File Exchange Advanced Template Instructions
Using advanced functions
This section provides expert-level information about using the File Exchange templates.
Using programmatic instructions
This section explains how to first acquire an eBay security token, and then programmatically upload
and download listing files to eBay using File Exchange.
Requesting an eBay token
As a non-Web authenticated user, you must use a token to upload data to File Exchange.To acquire
a token, go to the Grant Application Access - File Exchange page. After you sign in, click I Agree.
Under Your Token, copy the token and paste it into a separate file to be saved on a local disk in a
secure location (preferably behind a firewall). Do not share your token with anyone! When you post
your inventory data file, you will include the token.
The security token serves as a key for entry to File Exchange and is valid for one year, after which
you must request another one.
Uploading files programmatically
Caution: Advanced users only! Only experienced users can use this method to upload data to
File Exchange.
To upload your file programmatically, send an HTTP Post request to the File Exchange server to
accept the request:
1. Download and complete the appropriate File Exchange template.
2. Initiate an HTTPS connection and then post your data file with your token to the File Exchange
URL: https://bulksell.ebay.com/ws/eBayISAPI.dll?FileExchangeUpload
Tip: See Sample HTTP Post Request on page 47.
To indicate your data is processed, eBay sends an email message that includes the URL at which to
access the Load Results report.
To download the results, see Downloading files programmatically below.
Downloading files programmatically
Caution: Advanced users only! Only experienced users should use this method to download
data to the File Exchange website.
Using advanced functions46
File Exchange Advanced Template Instructions
To download your file programmatically, you must send an HTTP Get request to the eBay File Exchange
server to accept the request contents:
1. Download and complete the appropriate eBay File Exchange template.
2. Initiate an HTTPS connection and then post your data file with your token to the File Exchange
URL:
https://bulksell.ebay.com/ws/eBayISAPI.dll?FileExchangeProgrammaticDownload
Note: See Sample HTTP Post Request below.
After eBay has processed your data file, you will receive an email that includes a URL to access your
Load Results Report.You can also get your download results file by posting the following parameters:
• jobId
• token
Sample HTTP Post Request
POST /path/to/upload/script HTTP/1.0
Connection: Keep-Alive
User-Agent: My Client App v1.0
Host:
https://bulksell.ebay.com/ws/eBayISAPI.dll?FileExchangeUpload
Content-type: multipart/form-data;
boundary=THIS_STRING_SEPARATES
Content-Length: 256
--THIS_STRING_SEPARATES
Content-Disposition: form-data; name="token"
12345678987654321
--THIS_STRING_SEPARATES
Content-Disposition: form-data; name="file";
filename="listings.csv"
Content-Type: text/csv
... contents of listings.csv ...
--THIS_STRING_SEPARATES-
HTTP Post Request Components
The HTTP Post request must include the following components. In the first line, the method to be
applied to the resource, the identifier of the resource, and the protocol version in use:
POST /path/to/upload/script HTTP/1.0
The connection, user-agent and host information is next:
Connection: Keep-Alive
User-Agent: My Client App v1.0
47Using advanced functions
File Exchange Advanced Template Instructions
Host:https://bulksell.ebay.com/ws/eBayISAPI.dll?FileExchangeUpload
Header containing file content and length information:
Content-type: multipart/form-data; boundary=THIS_STRING_SEPARATES
Content-Length: 256
Contents, which includes your security token and then the actual file contents you want to upload:
--THIS_STRING_SEPARATES
Content-Disposition: form-data; name="token"
12345678987654321
--THIS_STRING_SEPARATES
Content-Disposition: form-data; name="file"; filename="listings.csv"
Content-Type: text/csv
... contents of listings.csv ...
--THIS_STRING_SEPARATES-
Using metadata information
This section explains how to use and modify the metadata in the Action field header of the default
templates.
Metadata cell information
Also known as data about data, metadata is the information that is encoded in, and describes the
aspects of, the listing template. For example, SiteID and Country metadata in the templates differ
according to the eBay site you use.
Metadata also provides a means to control each header's values. eBay File Exchange supplies the
metadata in the first row of the first column of each template, which is the Action field header. Metadata
includes:
• SiteID
• Country
• Currency
• API Compatibility Level
The metadata cell should begin with the word Action and the contents should follow within parentheses
in ASCII. Each piece of metadata should be separated by a pipe character “|” to isolate it from the
Action tag.
For example, the first cell of an eBay File Exchange template file contains the metadata in the example
shown below:
*Action(SiteID=<CountryName>|Country=<CountryCode>|Currency=<CurrencyCode>|Version=745)
Overriding metadata values
Caution: ADVANCED USERS ONLY!
Using advanced functions48
File Exchange Advanced Template Instructions
Changing metadata values can cause upload errors; do not override the metadata values in your
template files unless are an experienced user. If you change any values, do not add spaces between
the data.You can alter data in several ways:
• Manually edit the SiteID, Country and Currency values.
• Add a SiteID, Country or Currency field (column) to your file templates, which then overrides the
values in the metadata cell.
• Enter a data field and the corresponding value you want to set for it in your file. For example, if you
want every item in your file to have a StartPrice of $1.99, you can enter StartPrice=1.99 in the metadata
cell, and this value will be used for every item in your file.The metadata would look like this:
*Action(SiteID=US|Country=US|Currency=USD|Version=745|StartPrice=1.99)
49Using advanced functions
File Exchange Advanced Template Instructions
Site and template information
This section provides more in-depth information about site specifics, metadata, and field definitions in
the File Exchange templates.
eBay site-specific information
Explains which eBay sites support each type of template and the flat-file formats for each site.
Site-specific template information
Supported templates for each site
Not all eBay sites support every type of template; the table below shows the templates each eBay site
supports. If you try to list items using ISBN or UPCs on sites that do not support Catalog template
listings, you will receive an error.
Supported TemplateseBay Site
CatalogItem SpecificsBasic
XXXAustralia
XXXAustria
XXXBelgium (Dutch)
XXXBelgium (French)
XXXCanada (English)
XXXCanada (French)
XXXFrance
XXXGermany
XXHong Kong
XXXItaly
XXIndia
XXXIreland
XXMalaysia
XXXNetherlands
XXPhilippines
XXXPoland
XXSingapore
XXSpain
XXXSwitzerland
Site and template information50
File Exchange Advanced Template Instructions
Supported TemplateseBay Site
CatalogItem SpecificsBasic
XXXUnited Kingdom
XXXUnited States
Default template formats for each site
The table below explains the type of flat-file format used for template processing uploaded files at
each of the regional sites.
Flat-file Formats for Each Site
Flat-file formatSite
Semi-colon delimitedAT (Austria)
Comma-separatedAU (Australia)
Semi-colon delimitedBEFR (Belgium-French)
Semi-colon delimitedBENL (Belgium-Dutch
Comma-separatedCA (Canada-English)
Comma-separatedCAFR (Canada-French)
Semi-colon delimitedCH (Switzerland)
Semi-colon delimitedDE (Germany)
Semi-colon delimitedES (Spain)
Semi-colon delimitedFR (France)
Comma-separatedHK (Hong Kong)
Comma-separatedIE (Ireland)
Comma-separatedIN (India)
Semi-colon delimitedIT (Italy)
Comma-separatedMY (Malaysia)
Semi-colon delimitedNL (Netherlands)
Comma-separatedPH (Philippines)
Semi-colon delimitedPL (Poland)
Comma-separatedSG (Singapore)
Comma-separatedUK (United Kingdom)
Comma-separatedUS (United States)
51Site and template information
File Exchange Advanced Template Instructions
Default template metadata information
Defines these metadata values used in the Action field header: SiteID, Currency, Country, and API
compatibility.
Metadata values
SiteID
The SiteID represents the site where you want to list your items. The default SiteID is taken from the
site where you downloaded your template. For example, if you want to list on the German site, make
sure that SiteID=Germany.Valid values are provided in the table below.
SiteID ValuesSite
AustraliaAustralia
AustriaAustria
Belgium_DutchBelgium (Dutch)
Belgium_FrenchBelgium (French)
CanadaCanada (English)
CanadaFrenchCanada (French)
eBayMotorseBay Motors
FranceFrance
GermanyGermany
HongKongHong Kong
IndiaIndia
ItalyItaly
IrelandIreland
MalaysiaMalaysia
NetherlandsNetherlands
PhilippinesPhilippines
PolandPoland
SingaporeSingapore
SpainSpain
SwitzerlandSwitzerland
UKUnited Kingdom
USUnited States
Site and template information52
File Exchange Advanced Template Instructions
Country
The country (two-digit code) correlates to the site ID.The default country value provided is taken from
the site where you downloaded your template.
For example, templates downloaded from the United States will have Country=US and Currency=USD.
Valid values are provided in the table below.
Country ValueCountry (Language)
AUAustralia
ATAustria
BENLBelgium (Dutch)
BEFRBelgium (French)
CACanada (English)
CAFRCanada (French)
FRFrance
DEGermany
HKHong Kong
INIndia
IEIreland
ITItaly
MYMalaysia
PHPhillippines
PLPoland
NLNetherlands
SGSingapore
ESSpain
CHSwitzerland
GBGreat Britain
USUnited States
Currency
The currency represents the monetary system in which you want to list your items.The default currency
value provided is taken from the site where you downloaded your template.
For example, templates downloaded from the United States will have SiteID=US and Currency=USD.
Valid values are provided in the table below.
Currency ValueSite
USDUS Dollar
53Site and template information
File Exchange Advanced Template Instructions
Currency ValueSite
CADCanadian Dollar
GBPUK Pound Sterling
AUDAustralian Dollar
EUREuro
HKDHong Kong Dollar
MYRMalaysia Ringget
PHPPhilippine Peso
PLNPolish Zloty
CHFSwiss Franc
CNYRenminbi
INRIndian Rupee
API compatibility level
This refers to the eBay API (Application Program Interface); for example, Version=745.This metadata
is related to internal eBay system details.
Caution: Do not alter these values.
Region names and country codes
This section explains the region names and country codes you can use in the File Exchange templates
to define a location.These values differ from the metadata values used in the Action header to specify
country and SiteID.
Values for international location fields
Region names and some country codes can be used for the IntlShippingService-n:Locations field
value. Because they are case-sensitive, region names and country codes must be entered exactly as
they appear in the tables below.
The values available depend on the eBay site you use.The table below lists which sites support which
region names.The sites are listed according to country code.
Region NameseBay Sites
AU, Americas, Asia, CA, DE, Europe, EuropeanUnion, GB, JP, None, US, WorldwideAT
Americas, Asia, CA, DE, Europe, GB, HK, JP, NZ, None, US, WorldwideAU
Americas, Asia, CA, DE, Europe, EuropeanUnion, FR, GB, JP, NL, None, US, WorldwideBEFR
Americas, Asia, CA, DE, Europe, EuropeanUnion, FR, GB, JP, None, US, WorldwideBENL
AU, Americas, Asia, DE, Europe, FR, GB, JP, MX, None, TW, US, WorldwideCA
Site and template information54
File Exchange Advanced Template Instructions
Region NameseBay Sites
AT, AU, Americas, Asia, CA, DE, Europe, GB, JP, None, US, WorldwideCH
AU, Americas, Asia, CA, DE, Europe, FR, GB, IT, JP, None, US, WorldwideCN
AU, Americas, Asia, CA, DE, Europe, FR, GB, JP, MX, None, WorldwideCZ
AT, AU, Americas, Asia, CA, CH, Europe, EuropeanUnion, JP, None, US, WorldwideDE
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwideDK
Americas, Asia, CA, DE, Europe, EuropeanUnion, FR, GB, None, US, WorldwideES
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwideFI
AU, Americas, Asia, BE, CA, DE, Europe, EuropeanUnion, GB, JP, None, US, WorldwideFR
AU, Americas, Asia, CA, DE, Europe, EuropeanUnion, FR, IE, JP, None, US, WorldwideGB
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwideGR
Greater China, JP, None, WorldwideHK
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwideHU
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwideID
AU, Americas, Asia, CA, Europe, EuropeanUnion, GB, JP, None, US, WorldwideIE
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwideIL
AU, Americas, Asia, CA, DE, Europe, GB, JP, None, US, WorldwideIN
AU, Americas, Asia, CA, DE, Europe, EuropeanUnion, FR, GB, JP, None, US, WorldwideIT
AU, Americas, Asia, CA, DE, Europe, GB, JP, None, WorldwideJP
NoneMY
Americas, Asia, BE, CA, DE, Europe, EuropeanUnion, GB, JP, None, US, WorldwideNL
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwideNO
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwideNZ
AU, Americas, Asia, DE, Europe, GB, JP, MX, None, TW, US, WorldwidePE
NonePH
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwidePL
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwidePT
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwideRU
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwideSE
NoneSG
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwideTH
AU, Americas, Asia, DE, Europe, GB, HK, MX, None, US, WorldwideTW
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwideUS
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwideVN
55Site and template information
File Exchange Advanced Template Instructions
Region NameseBay Sites
AU, Americas, Asia, CA, DE, Europe, GB, JP, MX, None, WorldwideZA
Country codes
Country codes must be entered exactly as shown in the table below.
Valid
Values
Country/SiteValid
Values
Country/SiteValid
Values
Country/Site
NENigerDEGermanyAFAfghanistan
NGNigeriaGHGhanaALAlbania
NUNiueGIGibraltarDZAlgeria
NONorwayGRGreeceASAmerican Samoa
OMOmanGLGreenlandADAndorra
PKPakistanGDGrenadaAOAngola
PWPalauGPGuadeloupeAIAnguilla
PAPanamaGUGuamAGAntigua and Barbuda
PGPapua New GuineaGTGuatemalaUSAPO/FPO
PYParaguayQQGuernseyARArgentina
PEPeruGNGuineaAMArmenia
PHPhilippinesGWGuinea-BissauAWAruba
PLPolandGYGuyanaAUAustralia
PTPortugalHTHaitiATAustria
PRPuerto RicoHNHondurasAZAzerbaijan Republic
QAQatarHKHong KongBSBahamas
RER ionHUHungaryBHBahrain
RORomaniaISIcelandBDBangladesh
RURussian FederationINIndiaBBBarbados
RWRwandaIDIndonesiaBYBelarus
SHSaint HelenaIRIranBEBelgium
QQSaint Kitts-NevisIQIraqBZBelize
LCSaint LuciaIEIrelandBJBenin
PMSaint Pierre and MiquelonILIsraelBMBermuda
VCSaint Vincent and the
Grenadines
ITItalyBTBhutan
SMSan MarinoJMJamaicaBOBolivia
SASaudi ArabiaSJJan MayenBABosnia and Herzegovina
Site and template information56
File Exchange Advanced Template Instructions
SNSenegalJPJapanBWBotswana
RSSerbiaUKJerseyBRBrazil
SCSeychellesJOJordanVGBritish Virgin Islands
SLSierra LeoneKZKazakhstanBNBrunei Darussalam
SGSingaporeKEKenyaBGBulgaria
SKSlovakiaKIKiribatiBFBurkina Faso
SISloveniaKPKorea, NorthAFBurma
SBSolomon IslandsKRKorea, SouthBIBurundi
SOSomaliaKWKuwaitKHCambodia
ZASouth AfricaKGKyrgyzstanCMCameroon
ESSpainLALaosCACanada
LKSri LankaLVLatviaCVCape Verde Islands
SDSudanLBLebanon, SouthKYCayman Islands
SRSurinameLSLesothoCFCentral African Republic
SJSvalbardLRLiberiaTDChad
SZSwazilandLYLibyaCLChile
SESwedenLILiechtensteinCNChina
CHSwitzerlandLTLithuaniaCOColombia
SYSyriaLULuxembourgKMComoros
PFTahitiMOMacauZRCongo, Democratic Republic
of the
TWTaiwanMKMacedoniaCGCongo, Republic of the
TJTajikistanMGMadagascarCKCook Islands
TZTanzaniaMWMalawiCRCosta Rica
THThailandMYMalaysiaCICote d Ivoire (Ivory Coast)
TGTogoMVMaldivesHRCroatia, Democratic Republic
of the
TOTongaMLMaliCUCuba
TTTrinidad and TobagoMTMaltaCYCyprus
TNTunisiaMHMarshall IslandsCZCzech Republic
TRTurkeyMQMartiniqueDKDenmark
TMTurkmenistanMRMauritaniaDJDjibouti
USTurks and Caicos IslandsMUMauritiusDMDominica
UGUgandaYTMayotteDODominican Republic
UAUkraineMXMexicoECEcuador
57Site and template information
File Exchange Advanced Template Instructions
AFUnited Arab EmiratesMIMicronesiaEGEgypt
UKUnited KingdomQQMoldovaSVEl Salvador
USUnited StatesMCMonacoGQEquatorial Guinea
UYUruguayMNMongoliaQQEritrea
UZUzbekistanMEMontenegroEEEstonia
VUVanuatuMSMontserratETEthiopia
VAVatican City StateMAMoroccoFKFalkland Islands (Islas
Makvinas)
VEVenezuelaMZMozambiqueFJFiji
VNVietnamNANamibiaFIFinland
VIVirgin Islands (U.S.)NRNauruFRFrance
WFWallis and FutunaNPNepalGFFrench Guiana
EHWestern SaharaNLNetherlandsPFFrench Polynesia
WSWestern SamoaANNetherlands AntillesTFFrench Southern Territories
YEYemenNCNew CaledoniaGAGabon
YUYugoslaviaNZNew ZealandGMGambia
ZMZambiaNINicaraguaGEGeorgia
ZWZimbabwe
Site and template information58
File Exchange Advanced Template Instructions
Template field definitions
This section explains the field requirements and purpose by specifying character limits, data types,
and field relationships.
Design and display fields
This section explains the fields used to define how a listing appears on eBay, and also what types of
information is displayed.
For more information about adding the fields described below in your templates, see Enter data in the
template fields on page 21.
*Action
Required field in all templates. Determines the purpose of the row: add item, relist item, revise item,
end listing, mark an item's status, verify an added item, and add item description information.
N/ACharacter limit
Text stringType
Add, Revise, Relist, End, Status, VerifyAdd, or
AddToItemDescription
Valid Entry
Must enter all required field data for a particular type of action.Field Dependency
BoldTitle
Do you want to see your listing in boldface type? This field applies bold face type to the title of your
listing. Additional fees apply.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
BuyerRequirements:LinkedPayPalAccount
Do you want potential buyers to have PayPal accounts? Use this field to specify that only those buyers
with PayPal accounts can bid on your listing.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) The default value is 0 (false).
Valid Entry
59Template field definitions
File Exchange Advanced Template Instructions
BuyerRequirements:MaximumItemCount
If you are selling expensive items, do you want to limit the number of items on which any one buyer
can bid? This field lets you specify the number of items on which any one buyer can bid.
This field is ignored unless a value for BuyerRequirements:MaxItemMinFeedback is also provided.
BuyerRequirements:MaximumItemCount and BuyerRequirements:MaxItemMinFeedback must be
used together.
N/ACharacter limit
IntegerType
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 25, 50, 75, or 100.The
default value is 10.
Valid Entry
Use this field with BuyerRequirements:MaxItemMinFeedback.Field Dependency
BuyerRequirements:MaxItemMinFeedback
If you are selling expensive items and have blocked buyers from bidding on more than a set number
of items in a 10 day period (with BuyerRequirements:MaximumItemCount), do you also want to require
those buyers to have a minimum feedback score? If so, this field lets you specify that minimum feedback
score.
N/ACharacter limit
IntegerType
5, 4, 3, 2, 1 or 0.The default value is 5.
Valid Entry
Use this field with BuyerRequirements:MaximumItemCount.Field Dependency
BuyerRequirements:MaxUnpaidItemsCount
Do you want to exclude buyers once they reach a threshold of unpaid Items? This field lets you specify
the number of unpaid Items a buyer can incur in a set period of time (set with
BuyerRequirements:MaxUnpaidItemsPeriod) before they are prevented from bidding. For example, 4
(four) items.
N/ACharacter limit
IntegerType
2, 3, 4 or 5.The default value is 2.
Valid Entry
Use this field with BuyerRequirements:MaxUnpaidItemsPeriod.Field Dependency
Template field definitions60
File Exchange Advanced Template Instructions
BuyerRequirements:MaxUnpaidItemsPeriod
Do you want to exclude potential buyers when they reach a threshold of unpaid Items in a finite period
of time? This field lets you specify the length of time during which a buyer can incur a specific number
of unpaid Items before being prevented from bidding on your item. For example, 6 (six) months.
N/ACharacter limit
IntegerType
1, 6, or 12.The default value is 6 (months).
Valid Entry
Use this field with BuyerRequirements:MaxUnpaidItemsCount.Field Dependency
BuyerRequirements:MaxViolationCount
Do you want to exclude buyers once they receive a specific number of violation reports? This field lets
you specify the number of violation reports a buyer can incur within a set period of time (set with
BuyerRequirements:MaxViolationPeriod) before being prevented from bidding. For example, 7 (seven).
N/ACharacter limit
IntegerType
4, 5, 6 or 7.The default value is 4 (months).
Valid Entry
Use this field with BuyerRequirements:MaxViolationPeriod.Field Dependency
BuyerRequirements:MaxViolationPeriod
Do you want to exclude buyers who receive a specific number of violation reports in a defined period
of time? This field lets you specify the length of time during which a buyer can incur a specific number
of violation reports (set with BuyerRequirements:MaxViolationCount) before being prevented from
bidding. For example, 6 (months).
N/ACharacter limit
IntegerType
1 or 6.The default value is 1 (month).
Valid Entry
Use this field with BuyerRequirements:MaxViolationCount.Field Dependency
BuyerRequirements:MinimumFeedbackScore
Do you want to block buyers with a minimum feedback score? This field lets you explicitly set a minimum
feedback score that a buyer must meet before they can bid on your listing.
N/ACharacter limit
IntegerType
61Template field definitions
File Exchange Advanced Template Instructions
-1, -2, or -3
Valid Entry
BuyerRequirements:ShiptoRegCountry
Do you want to exclude buyers whose primary shipping address falls outside your shipping area? Use
this field to exclude buyers whose primary address lies outside your shipping area.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) The default value is 0 (false).
Valid Entry
BuyerUserID
Unique identifier (eBay User ID) denoting the user you want to leave feedback for.
N/ACharacter limit
Text stringType
eBay User IDValid Entry
*Category
Required field in the basic and item specifics templates only.
Numeric ID of the Category where the item is to be listed. Required for non-catalog items. To get
category IDs, go to the Category code page.
Max length 10Character limit
IntegerType
Category number, like 178 ( for Printers).
Valid Entry
Must use a valid eBay category number.Field Dependency
Category2
Numeric ID of an additional Category where the item is to be listed. To get category IDs, go to the
Category code page.
Max length 10Character limit
IntegerType
Category ID number, like 178 (for Printers).
Valid Entry
Must use a valid eBay category number.Field Dependency
Template field definitions62
File Exchange Advanced Template Instructions
*ConditionID
Describes the appearance and state of the product. Condition IDs are numeric, not textual, and vary
according to the respective category.To retrieve the Condition IDs in the Item Specifics Definition file,
generate an Item Specific template for a category.
N/ACharacter limit
IntegerType
Possible valid eBay ConditionID values include: 1000, 1500, 2000, 2500, 3000,
4000, 5000, 6000, and 7000. get
To get the ConditionID values for a particular category, go the File Exchange Select
Template page and generate an Item Specifics template.The generated template contains
Valid Entry
the new ConditionID field, and the ConditionID numbers and literal values are defined in
the Item Specifics Definitions file that accompanies the generated template.
To view the ConditionID values for all categories, click the ConditionIDs by Category
link on the File Exchange Instructions and Resources page.
Country
Are you planning to ship this item internationally? Specifies Country in the metadata section of the
Action field.
N/ACharacter limit
Text stringType
A default value is already included in the template metadata and is related to the site
where you downloaded your template. For example, AU, AT, BE, CA, CN, FR, DE, IT,
IN, NL, ES, CH, and US. Entry must be a valid Country code.
Valid Entry
CrossBorderTrade
Specifies the region and country (in addition to your location) where you want your listings to be found
in a product search on eBay.
N/ACharacter limit
Text stringType
NorthAmerica, UK.This field is only available in the United States, Canada (to
UK), or Great Britain and Ireland (to NorthAmerica).
Valid Entry
C:<item specific name>
How does your item differ from other similar items? Describes the specific characteristics of a product
that are not offered in the standard item specifics, such as Style, Occasion, or Feature.The field name
must begin with C:. For example, the field name for Style should be: C:Style.
63Template field definitions
File Exchange Advanced Template Instructions
Important: If you revise this field, you must include all of the custom item specific fields for this
listing in the uploaded file, even if the information has not changed. Otherwise; any excluded
custom item specific will be removed from the listing.
Some clothing and accessory categories require certain item specifics to be included in a listing, such
as:
• Brand
• Size Type
• Size
• Style
• Color
Refer to the look-up table to view the item specifics required by each category.Visit our size chart and
handbag measurement guide for size mapping and measurement instructions.To see how these
changes will impact your existing listings and the way you list, refer to Review category and item
specifics changes.
N/ACharacter limit
Text stringType
Any term or phrase that correlates with the item specific name. For example, the
C:Style item specific would have values such as Casual, Business, and
Formal.
Valid Entry
CustomLabel
Your unique identifier for the item, like a stock-keeping unit (SKU) number.The buyer does not see
this information.
Max length 50Character limit
Alphanumeric stringType
Text or numeric string.Valid Entry
DeleteFields
Specifies the field(s) to delete from a listing. Multiple fields can be deleted from a listing; use the pipe
character "|" to separate multiple field names. For example, enter Category2|Subtitle. Only the
fields noted below can be deleted.
N/ACharacter limit
Text stringType
Application Data, Attributes (Deletes ALL A: Attributes), BoldTitle,
BuyItNowPrice, Category2, Charity, ConditionID,
Valid Entry
CustomLabel, ItemSpecifics (Deletes ALL C: Item Specifics), Layout,
MinimumBestOfferPrice, PayPalEmailAddress, PicURL,
Template field definitions64
File Exchange Advanced Template Instructions
Product (Deletes ALL Product Details), ProPackBundle ,
ProPackPlusBundle , ValuePackBundle , Subtitle, Theme
*Description
Product information about the item. Include all relevant item and product specifications that may be
of interest to the buyer.
Note: File Exchange does not support line breaks and carriage returns in this field. If multiple
line descriptions are desired, you must paste HTML text into this field. Use the <BR> and <P>
HTML tags to separate lines into multiple paragraphs.
eBay provides a script that removes all carriage returns, escape quotes, and performs all necessary
changes to make your Description field text valid for File Exchange.To get the script and instructions
for using it, refer to the How to use the new File Exchange Item Description Utility Knowledge Base
page.
Max length 500,000Character limit
Text stringType
Sentences that accurately and completely describe the item.Valid Entry
This field is optional for catalog listings but required for non-catalog listings.Field Dependency
*Duration
How long would you like your listing to be posted on eBay? Enter the amount of days you'd like the
listing to be active.
Max length 3Character limit
IntegerType
Only certain values are allowed, and the choice of values depends on the listing format.
Valid Auction and Fixed Price durations include: 1, 3, 5, 7, and 10 (days). If you are a
Valid Entry
qualified seller, you can also use (30) days, and GTC (for the Good Til Cancelled) for
FixedPrice.
You can also refer to the Durations Table on the eBay developer site. (You must have
an eBay developer account to access these English-language only pages.)
EndCode
Required when using End in the Action field. Reason for ending a listing.
N/ACharacter limit
Text stringType
65Template field definitions
File Exchange Advanced Template Instructions
LostorBroken, NotAvailable, Incorrect, OtherListingError
Valid Entry
Feedback
Textual comment that explains, clarifies, or justifies the feedback rating. Still displayed if feedback is
withdrawn.
Max length 80Character limit
Text stringType
Explanation of the feedback.Valid Entry
FeedbackType
Rating of the feedback being left (Positive). Sellers cannot leave neutral or negative feedback for
buyers.
Max length 80Character limit
Text stringType
Positive
Valid Entry
FE:ListByDate
Specifies the date/time (up to 21 days) by which a listing action request must be completed; if the
listing action request is not completed by this time, the item action request fails and a corresponding
error code is noted in the results file.
N/ACharacter limit
DateType
YYYY-MM-DD HH:MM:SS. Hours are in 24-hour format (for example, 2:00:00pm
is shown as 14:00:00) and treated as GMT.
Valid Entry
*Format
Listing format for the item. For more information, see Selecting a selling format.
N/ACharacter limit
Text stringType
Auction (default), FixedPrice, ClassifiedAd, RealEstateAd
Valid Entry
Template field definitions66
File Exchange Advanced Template Instructions
GalleryDuration
Specifies whether the item is included in the Gallery, either in the general Gallery or in the special
“featured” section above it.
N/ACharacter limit
Text stringType
Days_7, Lifetime
Valid Entry
Featured must be entered in the GalleryType field.
Field Dependency
GalleryType
Indicates how and where images are displayed. The options are:
• Gallery: Image is included in the eBay search results.
• Plus: In addition to the benefits of 'Gallery', includes an icon in the eBay search results that, when
clicked or moused over, displays a large 400 x 400 pixel preview image of the item. Otherwise, your
image is shown at the standard size of 96 pixels.
• Featured: In addition to the benefits of 'Plus', your item is at the top of the search results in the
Featured section.
For more information, see About gallery upgrades.
N/ACharacter limit
Text stringType
None (default), Gallery, Plus,Featured.
Valid Entry
HitCounter
Do you want to keep track of the number of visits received by each item. If you pass any value, this
feature is applied.
N/ACharacter limit
Text stringType
NoHitCounter, HonestyStyle (US only), GreenLED (US only), Hidden
(US only), BasicStyle, RetroStyle, HiddenStyle
Valid Entry
ItemID
eBay generated ID that uniquely identifies the item.You cannot choose or revise this value.
N/ACharacter limit
AlphanumericType
67Template field definitions
File Exchange Advanced Template Instructions
Acquired from Revision file or Load Results Report.Valid Entry
Required when revising, relisting, and ending listings, and when checking status (using
Status in the Action field).
Field Dependency
*Location
Location of the item. Use the Postal Code, or City, State, Country.
Max length 45Character limit
AlphanumericType
Postal code, or other valid mailing addressValid Entry
LotSize
Do you want sell items together as a unit? Specifies that a single listing consists of two or more similar
items that must be purchased together.
N/ACharacter limit
IntegerType
Numeric amount, like 3, 25, and 100.
Valid Entry
If LotSize is greater than 1, then Quantity field indicates the number of lots being listed
and LotSize indicates the number of items in each lot.You can only use LotSize in
lot-enabled categories.
Field Dependency
PhotoDisplay
Specifies the type of image display used in a listing. Some options are only available if images are
hosted through eBay Picture Services (EPS). eBay determines this by parsing the associated PicURL
field value.The valid field entries are:
• None: No special image display options. Valid only for US Motors listings.
• PicturePack : Increases the number of images displayed. Only available for images hosted with
eBay. Picture Pack applies to all sites (including US Motors), except for NL (Site ID 146).You can
specify a minimum of one EPS picture, or no SuperSize-qualified EPS pictures in the request. For
the NL site, PicturePack is replaced with SuperSize.
• SuperSize : Increase the size of each image and allow buyers to enlarge images further. Only
available for site-hosted (EPS) images. Not valid for US Motors listings. For all sites that do not
automatically upgrade SuperSize to PicturePack (see note below), specifying no SuperSize-qualified
images is now accepted.
Note: SuperSize is automatically upgraded to PicturePack for the same SuperSize fee for the
US eBay Motors Parts & Accessories category, and the US, CA, and CAFR sites.This upgrade
applies only to EPS images (including Picture Manager images).
N/ACharacter limit
Template field definitions68
File Exchange Advanced Template Instructions
Text stringType
None (default), PicturePack, SuperSize.
Valid Entry
PicURL
URL of the image to add to your listing. If a Gallery upgrade is specified (Plus or Featured), the image
will be used for the search preview image. For best results, use an image that is in JPEG format and
is at least 1000 pixels wide.
A listing can have a maximum of 12 images hosted by EPS or 1 by a third party. Multiple URLs can
be separated by the '|' character. Images for a listing can either be hosted by eBay Picture Services
(EPS) or by a third party (but not both).To add images to EPS, the UploadSiteHostedPictures API
must be used (not directly supported in File Exchange).
Important: If an image URL has blank spaces, you must replace the blank spaces with %20;
otherwise, the image will not appear in the listing.
Max length 2048Character limit
Text stringType
http://hostedpics.com/image1.jpg|http://hostedpics.com/
image2.jpg, or http://hostedpics.com/images/item1.jpg
Valid Entry
PostalCode
The mail area code where you are actually located, which may differ from the item's shipping location.
N/ACharacter limit
Text stringType
User inputValid Entry
PrivateAuction
Do you want to sell this item in a private auction? Specifies whether or not this item will be offered in
a private auction.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
*Quantity
Quantity of the item available for sale. A quantity of more than one implies all the items are the exact
same.
69Template field definitions
File Exchange Advanced Template Instructions
Max length 45Character limit
IntegerType
Standard numbers, like 1, 15, and 100.
Valid Entry
If LotSize is greater than 1, then theQuantity field indicates the number of lots being listed
and LotSize indicates the number of items in each lot.You can only use LotSize in
lot-enabled categories.
Field Dependency
Relationship
This determines whether the Compatibility or Variation information (from the RelationshipDetails field)
is used in the listing. Use Compatibility to sell automotive parts for a variety of vehicles, like a type of
headlight that fits several different trucks.
N/ACharacter limit
Text stringType
Compatibility or
Valid Entry
Variation
Must accompany the RelationshipDetails field.Field Dependency
RelationshipDetails
Defines the name-value pairs that define the compatibility information used in a listing. For example,
Compatibility values look like: Make=Honda|Model=Accord|Year=2007
Defines the name-value pairs that define the variation information used in a listing. For example,
Variation values look like: Size=S;M;L;XL|Color=Black;Pink;Red;Blue
The equal sign (=) couples the name and its value, and multiple name-value pairs are separated by
pipe characters ( | ).The only difference is that variation names can have multiple values, which are
separated by semi-colons(;), as shown above.
N/ACharacter limit
Text stringType
For Compatibility values, view the file entitled eBay_Master_Vehicle_List_US.csv on the
Download tab.
Valid Entry
For Variation values, see the Item Specifics Definitions file that was created when you
generated an Item Specifics template for a category.
Must accompany the Relationship field.Field Dependency
Template field definitions70
File Exchange Advanced Template Instructions
ScheduleTime
Use this field to schedule a listing to start at a specific future time.
N/ACharacter limit
DateType
YYYY-MM-DD HH:MM:SS. Hours must be specified in 24-hour format (convert
2:00:00 PM to 14:00:00 GMT). For example:
2013-06-20 16:30:00
Valid Entry
StoreCategory
Numeric ID of a custom category in your eBay Store.
Maximum length is 10 digitsCharacter limit
IntegerType
Numeric value – Must be an integer between 1 and 10 digits, such as 5938 or
9346990. Invalid values (for example, 60040030111) are automatically reset to 1
(Other).Valid options are:
Valid Entry
• 0=Not an eBay Store item
• 1=Other
• 2=Category A
• 3=Category B
• 4=Category Z
StoreCategory2
Numeric ID of an additional custom category in your eBay Store (optional).
Maximum length is 10 digitsCharacter limit
IntegerType
Numeric value that must consist of an integer between 1 and 10 digits such as 5938
or 9346990. Invalid values (for example, 60040030111) are automatically reset to 1
(Other).Valid options are:
Valid Entry
• 0: Not an eBay Store item
• 1: Other
• 2: Category A
• 3: Category B
• 4: Category Z
71Template field definitions
File Exchange Advanced Template Instructions
Subtitle
In addition to the primary field of Title, this secondary field appears in search results for an item.
Note: Additional fees apply for using this field.
Max length 55Character limit
Alphanumeric stringType
Keywords and item descriptorsValid Entry
Tip: To remove a subtitle when revising or relisting an item, open a new Excel or CSV file. Enter
a column header for Action and ItemID. Under Action, enter Revise (or Relist), and under
ItemID, enter the Item ID value for this listing (from the Load Response file). In the third column,
enter DeletedFields=Item.Subtitle in the column header. Save in CSV format, and
upload the file.
*Title
Primary name that appears in the search results for an item.This field is required for non-catalog
listings and optional for catalog listings.
Max length 80Character limit
Alphanumeric stringType
Keywords and item descriptors, such as product name and model.Valid Entry
TransactionID
An eBay-generated ID used to uniquely identify the transaction for which feedback was provided.
N/ACharacter limit
IntegerType
Acquired from the Sold Listings report.Valid Entry
Packaging and handling fields
Explains the packaging, gift, and handling fields that determine how, when, and where the item is sent.
For more information about using these these fields, see Using package weight and dimension fields
on page 40.
Template field definitions72
File Exchange Advanced Template Instructions
*DispatchTimeMax
Specifies the handling time, defined as the maximum number of business days you usually take to
prepare an item for shipping to domestic buyers after receiving a cleared payment. *DispatchTimeMax
does not include the time required to ship the item (the carrier's transit time) to the buyer.
For same day delivery, enter 0 (zero), as presented in the following table:
N/ACharacter limit
IntegerType
1, 2, 3, 4, 5, 10, 15, 20, 30
Valid Entry
This field may be specified without specifying Shipping Service Costs.*DispatchTimeMax
is a required field for most categories and applies to Flat shipping only.
Field Dependency
InternationalPackagingHandlingCosts
Do you want the buyer to pay for extra shipping costs? Specifies Optional fees you want for shipping
the item internationally.
N/ACharacter limit
CurrencyType
Numeric amount, like .99, 1.00, 10.00.
Valid Entry
PackageDepth
The whole number portion of the package depth (top to bottom). For example, for a package depth of
10 inches or 10 centimetres, the value would be 10.
N/ACharacter limit
IntegerType
Whole number (in or cm)Valid Entry
Use this field only with ShippingType=Calculated (values for PackageWidth and
PackageLength must also be provided)
Field Dependency
PackageLength
The whole number portion of the package length (from side to side). For example, for a package length
of 20 inches or 20 centimetres, the value would be 20.
N/ACharacter limit
IntegerType
73Template field definitions
File Exchange Advanced Template Instructions
Whole number (in or cm)Valid Entry
Use this field only with ShippingType=Calculated (values for PackageWidth and
PackageDepth must also be provided)
Field Dependency
PackageType
Specifies the characteristics of the package to be shipped.
N/ACharacter limit
Text stringType
None, Letter, LargeEnvelope, LargePackage,
PackageThickEnvelope
Valid Entry
Use this field only when ShippingType=CalculatedField Dependency
PackageWidth
The whole number portion of the package width (front to back). For example, for a package width of
12 inches or centimetres, enter 12.
N/ACharacter limit
IntegerType
Whole number (in or cm)Valid Entry
Use this field only when ShippingType=Calculated (values for PackageDepth and
PackageLength must also be provided)
Field Dependency
ShipFromZipCode
Are you planning to use Calculated shipping? Specifies the ZIP code from which the item will be
shipped.Valid on the United States site only.
N/ACharacter limit
Numeric stringType
Must contain five or nine digits – for example 90210 or 90210-4141
Valid Entry
Must accompany ShippingType=CalculatedField Dependency
ShipmentTrackingNumber
Shipping carrier tracking number. Retrieve this number from the shipping order form from the shipping
carrier.
N/ACharacter limit
Template field definitions74
File Exchange Advanced Template Instructions
Text stringType
Valid tracking number on shipping invoice.Valid Entry
Requires also using the ShippingCarrierUsed field.Field Dependency
ShippedTime
Indicates the date and time the item was actually shipped.
If the field is in the template, and the value is omitted, it defaults to the time in which the file was
uploaded.This date and time is displayed in My eBay for the buyer as well as the seller.
The date and time must be in GMT ISO 8601 date and time format (YYYY-MM-DDTHH:MM:SS.SSSZ).
For example, if you live in California, and it's 03:09PM, the time conversion to military time is 03:09 +
12 hours = 15:09. Now PST = GMT - 7, so add 7 hours to make it 22:09.
N/ACharacter limit
DateType
Enter, for example, 2010-05-28T22:04:23.000Z. Do not enter a date or
time in the future.
Valid Entry
Can only be used with the Status action.
Field Dependency
ShippingCarrierUsed
Shipping service associated with the shipping tracking number.
N/ACharacter limit
Text stringType
Valid shipping carrier name, not the specific ShippingService-X:Option value. For example,
if the chosen ShippingService-X:Option value is UPSNextDay , then UPS is the valid
Valid Entry
ShippingCarrierUsed value. For non-specific ShippingService-X:Option carriers, use
Other for the ShippingCarrierUsed value.
If you use the Global Shipping Program for international shipping, use
GlobalShipping_MultiCarrier for the ShippingCarrierUsed value.
Requires also using the ShipmentTrackingNumber field.Field Dependency
ShippingIrregular
Does shipping the item require special carrier services? Specifies whether the item requires special
handling because it cannot go through the stamping machine at the shipping service office.
N/ACharacter limit
BooleanType
75Template field definitions
File Exchange Advanced Template Instructions
0 or 1 (0=false, 1=true) Default is 0
Valid Entry
Use this field only with ShippingType=CalculatedField Dependency
ShippingStatus
Do you want to inform buyers when an item has been shipped? Specifies whether or not the item has
been shipped.
N/ACharacter limit
BooleanType
0 or 1 (0=not shipped, 1=shipped) Default is 0.
Valid Entry
*ShippingType
The shipping types available for the item. Specifying Flat designates that Flat-rate shipping is available
for domestic shipping (and international if international shipping services are specified).
Important: When revising this field, you must also include certain field information for the listing
in the uploaded file, even if the information has not changed. Refer to Revision dependent fields
on page 13 for the names of the fields that need to be included in a revised listing.
To mix Flat and Calculated shipping options, use the FlatDomesticCalculatedInternational or
CalculatedDomesticFlatInternational values.
Note: FreightQuote.com is available for the United States eBay site only.
N/ACharacter limit
Text stringType
Flat (default), FreightFlat, Calculated ,
FlatDomesticCalculatedInternational ,
CalculatedDomesticFlatInternational .
Valid Entry
If you set this field to Calculated, you also must also provide a value for
ShipFromZipCode on page 74.
Field Dependency
ShipToLocations
What if a buyer wants to purchase your product but the international shipping service options do not
cover the buyer's geographical location? Use this field to offer buyers outside your standard delivery
area the ability to contact you for a shipping cost.
This field provides item-level specification with one or more ShipToLocations elements. When two or
more ShipToLocations options are used and one is set to None, all are ignored and a warning is
returned.
Template field definitions76
File Exchange Advanced Template Instructions
This field differs from the IntlShippingService-n:Locations field, which defines specific ship-to locations
for the selected international shipping service.
N/ACharacter limit
Text stringType
Worldwide, Americas, Europe, None.
Valid Entry
WeightMajor
Are you using calculated shipping? Specifies the whole number portion of the shipping weight. For
example, for a shipping weight of 3 lbs, 8 oz., enter 3.
N/ACharacter limit
IntegerType
Whole number such as 3, 75, and 100.
Valid Entry
Use this field only when ShippingType=Calculated.Field Dependency
WeightMinor
Sub-unit of shipping weight. If using imperial measures (lbs), this value should reflect ounces and, if
you use metric weight, this value should reflect the number of hundredths of kilograms. For example,
for a shipping weight of 3 lbs, 8 oz., the value would be 8.
N/ACharacter limit
IntegerType
Whole number, like 3 or 12.
Valid Entry
Use this field only when ShippingType=Calculated (sub-unit of WeightMajor).Field Dependency
WeightUnit
Are you using imperial or metric weights to factor shipping costs? Specifies the unit of measure for
shipping weight, whether imperial (lb) or metric (kg).
N/ACharacter limit
Text stringType
lb or kg
Valid Entry
Use this field only when ShippingType=Calculated.Field Dependency
77Template field definitions
File Exchange Advanced Template Instructions
Payment and return fields
This section explains the payment, return policy, and other transaction fields used to specify how
buyers pay for and return items.
For more information about using these fields, see Using the payments fields on page 37.
AdditionalDetails
Provides detailed explanation of your return policy.
Max 5000 charactersCharacter limit
Text stringType
User inputValid Entry
The *ReturnsAcceptedOption on page 81 field is required when you use this field.Field Dependency
AmEx
Do you accept American Express payments? Specifies whether or not American Express is accepted
as payment.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
Discover
Do you accept Discover payments? Specifies whether or not Discover is accepted as payment.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
ImmediatePayRequired
Indicates that immediate payment is required from the buyer. For more information, see Requiring
immediate payment.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
Template field definitions78
File Exchange Advanced Template Instructions
IntegratedMerchantCreditCard
Do you let your buyers pay for items with credit cards you issue? Use this field to indicate that you
accept an integrated credit card as payment.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
MOCashiers
Do you accept money orders and cashier's checks as payment? This field specifies that you accept
money orders and cashier's checks as payment.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.Valid Entry
PaymentInstructions
Do you want to provide payment instructions to a buyer? Informs buyers of payment contingencies.
Max length 500 charactersCharacter limit
Alphanumeric stringType
Null (default); use short descriptive sentences.Valid Entry
PaymentSeeDescription
Do you specify payment methods in the Description field? Specifies whether or not acceptable payment
methods are stated in the Description field. If you do not set any other payment method, you must
specify PaymentSeeDescription=1.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
PaymentStatus
Do you show buyers when a payment has been received? Specifies whether or not the item has been
paid for.
N/ACharacter limit
79Template field definitions
File Exchange Advanced Template Instructions
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
PayPalAccepted
Do you allow buyers to use PayPal to pay for your items? Although eBay does not require a specific
payment method for each listing, you must set at least one payment method to 1 (true).
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
This field can only be used for sites that support PayPal. If no value is provided for
PayPalAccepted and you have instructed eBay site preferences to offer PayPal on all
Field Dependency
listings, a warning messages indicates that PayPalAccepted has been added as a payment
method.
When you provide a value for PayPalAccepted, you must also provide a value for
PayPalEmailAddress on page 80.
PayPalEmailAddress
When you allow buyers to pay for items with PayPal, you must provide the email address associated
with your PayPal account.
N/ACharacter limit
Text stringType
A valid email address such as [email protected]
Valid Entry
When you provide a value forPayPalEmailAddress, you must also provide a value for
PayPalAccepted on page 80.
Field Dependency
PayUponPickup
Do you allow the buyer to pay for and pick up an item in person?
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid entry
PersonalCheck
Do you allow the buyer to pay with a personal check? Specifies that you accept a personal check as
payment.
Template field definitions80
File Exchange Advanced Template Instructions
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.Valid Entry
RefundOption
Defines how the buyer is to be compensated for a returned item.
N/ACharacter limit
Text stringType
MoneyBack or MoneyBackOrExchange
Valid Entry
The *ReturnsAcceptedOption on page 81 field is required when you use this field.Field Dependency
RestockingFeeValueOption
When you create a return policy on eBay, use RestockingFeeValueOption to specify the restocking
fee you charge when a buyer returns an item.The restocking fee can be set to Percent_10 (10%),
Percent_15 (15%), or Percent_20 (20%) of the price paid for an item.To indicate that you do not
charge a restocking fee, enter NoRestockingFee.
N/ACharacter limit
IntegerType
Percent_10, Percent_15, Percent_20, or NoRestockingFee.
Valid Entry
To use this field, you must create a return policy on the eBay site.Field Dependency
*ReturnsAcceptedOption
Indicates that a buyer can return the item.
N/ACharacter limit
Text stringType
ReturnsAccepted, ReturnsNotAccepted
Valid Entry
ReturnsWithinOption
The number of days after which the buyer receives an item that they have to notify you of their intent
to return it.
N/ACharacter limit
Text stringType
Days_14, Days_30, Days_60.
Valid Entry
81Template field definitions
File Exchange Advanced Template Instructions
*ReturnsAcceptedOption on page 81 must be set to ReturnsAccepted.
Field Dependency
ShippingCostPaidBy
Specifies who pays to return the item.
N/ACharacter limit
Text stringType
Buyer, Seller
Valid Entry
*ReturnsAcceptedOption on page 81 must be set to ReturnsAccepted.
Field Dependency
VisaMastercard
Do you allow buyers to pay with MasterCard or Visa? Specifies that you accept MasterCard or Visa
as payment.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
Pricing and cost fields
This section explains pricing, discount, and tax fields, which determine the final cost of the item.
For more information about using these fields, see Using the auto-accept and auto-decline fields on
page 33.
BestOfferAutoAcceptPrice
Specifies the amount that will be auto-accepted for a best offer from a buyer. For example, if you set
the value to 5.00, best offers of this amount and above will be accepted automatically.
Max length 16, including decimal point or commaCharacter limit
CurrencyType
Numeric amount, like .99, 1.00, 10.00.
Valid Entry
The BestOfferEnabled field must be set to 1 (true) for this field to be applicable.Field Dependency
BestOfferEnabled
Do you want to offer buyers the option to make a best offer? If you are selling a fixed price format item
(in a category for which Best Offer is also enabled), you can enable Best Offer for that item.This
Template field definitions82
File Exchange Advanced Template Instructions
feature enables a buyer to make a lower priced binding offer on your item.You can choose to accept
the offer, decline the offer or let the offer naturally expire after 48 hours. If you accept an offer, the
listing ends and the Best Offer price and terms are displayed upon viewing the ended listing. See the
eBay online help for more information. Additional fees apply.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
BuyItNowPrice
Price required to immediately buy an auction-style format item. Defines the price you are willing to
accept for the item, which will immediately end the auction. Not valid for fixed priced format items.
Max length 16, including decimal point or commaCharacter limit
CurrencyType
Numeric amount, like 10.00, 29.99, 100.00.
Valid Entry
Currency
What types of currency do you accept? Specifies Currency in the metadata section of the Action field.
Three-letter codeCharacter limit
Text stringType
A default currency value is already included in the template metadata and is related to
the site where you downloaded your template. (You only need to change it if you want
Valid Entry
to list your item on a different eBay site.) For example, USD, CAD, GBP, AUD, EUR,
CHF, TWD, CNY, INR, HKD, MYR, and PHP. Entry must be a valid Currency on page
53.
InternationalPackagingHandlingCosts
Do you want the buyer to pay for extra shipping costs? Specifies Optional fees you want for shipping
the item internationally.
N/ACharacter limit
CurrencyType
Numeric amount, like .99, 1.00, 10.00.
Valid Entry
InternationalPromotionalShippingDiscount
Specifies the requirements for buyers to receive the promotional shipping discount for international
shipping.
83Template field definitions
File Exchange Advanced Template Instructions
Important: When revising this field, you must also include certain field information for the listing
in the uploaded file, even if the information has not changed. Refer to Revision dependent fields
on page 13 for the names of the fields that need to be included in a revised listing.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0. Must be a valid rule created for your eBay account
under Site Preferences.
Valid Entry
Promotional shipping rules must be created before using this field. See Promotional
Shipping Rules.
Field Dependency
InternationalShippingDiscountProfileID
Numeric ID of the shipping discount rule used for international combined purchases.
Determines whether a shipping discount is applied for the item when its transaction is combined with
a buyer-created Combined Payment order. If you don't specify a value in this field, the default profile
in your My eBay page preferences will be used. (Refer to Using Combined Payments and About
Shipping Discounts for more information.)
To locate your shipping profile ID numbers, go to My eBay > Account > Site Preferences > Shipping
Preferences > Show > Offer combined payments and shipping > Edit.The ID numbers for each
shipping rule are listed on the My eBay: Combined Payments and Shipping Discounts page.
Important: When revising this field, you must also include certain field information for the listing
in the uploaded file, even if the information has not changed. Refer to Revision dependent fields
on page 13 for the names of the fields that need to be included in a revised listing.
N/ACharacter limit
IntegerType
Eight-digit number. For example, enter 78038543. Must be a valid rule created for
your eBay account under Site Preferences.
Valid Entry
You must define shipping rule profiles using the My eBay pages before using this field.Field Dependency
MinimumBestOfferMessage
Provides buyers with information in the event their best offers are declined.
Max length 80Character limit
Text stringType
User inputValid Entry
Template field definitions84
File Exchange Advanced Template Instructions
MinimumBestOfferPrice
Specifies the amount that will be auto-declined for a best offer from a buyer. For example, if you set
the value to 5.00, best offers of this amount and below will be automatically declined.
Max length 16, including decimal point or commaCharacter limit
CurrencyType
Numeric amount, like .99, 1.00, 10.00.
Valid Entry
The BestOfferEnabled field must be set to 1 (true) for this field to be applicable.Field Dependency
PackagingHandlingCosts
Do you want the buyer to pay for extra shipping costs? Specifies Optional fees you want to assess for
the shipping of the item. For calculated shipping only.
N/ACharacter limit
CurrencyType
Numeric amount, like .99, 1.00, 10.00.
Valid Entry
PromotionalShippingDiscount
Specifies the requirements for buyers to receive the promotional shipping discount for domestic
shipping.
Important: When revising this field, you must also include certain field information for the listing
in the uploaded file, even if the information has not changed. Refer to Revision dependent fields
on page 13 for the names of the fields that need to be included in a revised listing.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0. Must be a valid rule created for your eBay account
under Site Preferences.
Valid Entry
Promotional shipping rules must be created before using this field. For more information,
see Promotional Shipping Rules.
Field Dependency
ReservePrice
Bid amount that is required to be met before the item will sell. This value must be greater than the
StartPrice value. Not applicable to fixed price formats.
Max length 16, including decimal point or commaCharacter limit
85Template field definitions
File Exchange Advanced Template Instructions
CurrencyType
Numeric amount, like 10.00, 49.99, 100.00.
Valid Entry
SalesTaxPercent
Percent of an item's price to be charged as the sales tax for a transaction. Do not use the ‘%’ symbol.
If revising, use a value of 0.00 to remove SalesTaxPercent.
Important: When revising this field, you must also include certain field information for the listing
in the uploaded file, even if the information has not changed. Refer to Revision dependent fields
on page 13 for the names of the fields that need to be included in a revised listing.
Max length 5 (max 3 decimal values)Character limit
Numeric stringType
0.00 (default), 7.25, 8.975
Valid Entry
If you specify this field, you must also specify a SalesTaxState value.Field Dependency
SalesTaxState
State or tax jurisdiction for which sales tax is being collected.
Important: When revising this field, you must also include certain field information for the listing
in the uploaded file, even if the information has not changed. Refer to Revision dependent fields
on page 13 for the names of the fields that need to be included in a revised listing.
Max length 2Character limit
Text stringType
2-letter abbreviation for the jurisdiction.Valid Entry
If you specify this field, you must also specify a SalesTaxPercent value.Field Dependency
ShippingDiscountProfileID
Numeric ID of the shipping discount profile used for domestic shipping costs. Replaces the
ApplyShippingDiscount field so that multiple discount profiles can be used for domestic shipping
options.
Determines whether a shipping discount is applied for the item when its transaction is combined with
a buyer-created Combined Payment order. If you don't specify a value in this field, the default profile
in your My eBay page preferences will be used. (Refer to Using Combined Payments and About
Shipping Discounts for more information.)
To locate your shipping profile ID numbers, go to My eBay > Account > Site Preferences > Shipping
Preferences > Show > Offer combined payments and shipping > Edit.The ID numbers for each
shipping rule are listed on the My eBay: Combined Payments and Shipping Discounts page.
Template field definitions86
File Exchange Advanced Template Instructions
Important: When revising this field, you must also include certain field information for the listing
in the uploaded file, even if the information has not changed. Refer to Revision dependent fields
on page 13 for the names of the fields that need to be included in a revised listing.
N/ACharacter limit
IntegerType
Numeric ID. For example, enter 780385439. Must be a valid rule created for your
eBay account under Site Preferences.
Valid Entry
You must define shipping rule profiles using the My eBay pages before using this field.Field Dependency
ShippingInTax
Indicates whether shipping costs should be included in the base amount that is taxed.
Important: When revising this field, you must also include certain field information for the listing
in the uploaded file, even if the information has not changed. Refer to Revision dependent fields
on page 13 for the names of the fields that need to be included in a revised listing.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
*StartPrice
Price at which bidding starts. If the listing is in fixed price format, this is the price to buy the item.
Max length 16, including decimal point or commaCharacter limit
CurrencyType
Numeric amount, like 5.99, 10.00, 100.00
Valid Entry
UseTaxTable
Indicates whether your tax table is to be used for applying and calculating taxes. If used, do not specify
values for SalesTaxState, SalesTaxPercent, and ShippingInTax.
For more information, refer to the Tax table page.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
87Template field definitions
File Exchange Advanced Template Instructions
Product code and details fields
This section explains the fields used to identify a an item by its product codes, which are then used
to add its product information in your listing.
For more information about using these fields, see Using product identifiers on page 22.
Product:Brand
The name that identifies the product. eBay attempts to find a matching product on your behalf to use
in the listing. If multiple matches offur for the Brand and MPN, you must resubmit the item using
Product:ReturnSearchResultsOnDuplicates on page 90 field to determine which EPID to use.
N/ACharacter limit
Text stringType
The brand name of the product, like Sony or Levis.
Valid Entry
Must accompany Product:MPN on page 89.Field Dependency
Product:EAN
The European Article Number (EAN), which provides standard product information about the item.
eBay attempts to find a matching product on your behalf to use in the listing. If multiple matches occur
for the EAN, you must resubmit the item using Product:ReturnSearchResultsOnDuplicates on page
90 field to determine which ePID to use.
N/ACharacter limit
IntegerType
Number located by the bar code on the product.Valid Entry
Product:EPID
The eBay Product Identification number, or ePID, provides unique product information about the item.
To find the ePID, search for the item on eBay, and then copy and paste the ePID from the search
results page into Product:EPID field.
To alleviate the chances of our catalog finding multiple product matches, if you know the ePID for an
item use the ePID instead of the other Product:<type> fields (like Product:UPC).
N/ACharacter limit
IntegerType
Unique product identifier generated by eBay.Valid Entry
Template field definitions88
File Exchange Advanced Template Instructions
Product:ISBN
The International Standard Book Number (ISBN), which provides standard product information about
the item. eBay attempts to find a matching product on your behalf to use in the listing. If multiple
matches occur for the ISBN, you must resubmit the item using
Product:ReturnSearchResultsOnDuplicates on page 90 field to determine which ePID to use.
N/ACharacter limit
IntegerType
Number located by the bar code, and on the back of the title page in the book.Valid Entry
Product:MPN
The Manufacturer Part Number (MPN), which provides standard product information about the item.
eBay attempts to find a matching product on your behalf to use in the listing. If multiple matches occur
for MPN and Brand, you must resubmit the item using the Product:ReturnSearchResultsOnDuplicates
on page 90 field to determine which ePID to use.
N/ACharacter limit
IntegerType
Number located somewhere on the product housing. Look in the product Owners' Manual
for instructions about where the part number is located.
Valid Entry
Must accompany Product:Brand on page 88.Field Dependency
Product:IncludePrefilledItemInformation
Adds pre-filled item information from our catalog to the listing. Manufacturer name, version number,
author or artist, and publisher are examples of Pre-filled Item Information.
N/ACharacter limit
BooleanType
Use 1 (for True) or 0 for False.
Valid Entry
Product:IncludeStockPhotoURL
Adds a stock photo (when one is available) to the listing. If no stock photo is available (or to add your
own pictures in addition to a stock photo), use the PicURL on page 69 field.
If you supply no photos, the stock photo is displayed at the top of View Item (not in the item specifics).
If you supply photos, the stock photo does not appear in View Item. Instead, your photos appear at
the top of the page.
N/ACharacter limit
89Template field definitions
File Exchange Advanced Template Instructions
BooleanType
Use 1 (for True) or 0 for False.
Valid Entry
Product:ReturnSearchResultsOnDuplicates
Provides definitive information about a product when multiple matches are found in the catalog.
In order to discern between the product matches found, download the Upload results, and then use
the EPID that best matches your item in the listing.
N/ACharacter limit
BooleanType
Use 1 (for True) or 0 for False.
Valid Entry
Product:UPC
The Universal Product Code (UPC), which provides standard product information about the item. eBay
attempts to find a matching product on your behalf to use in the listing. If multiple matches occur for
the UPC, you must resubmit the item using Product:ReturnSearchResultsOnDuplicates on page 90
field to determine which ePID to use.
N/ACharacter limit
IntegerType
Number located by the bar code on the product.Valid Entry
Product:UseStockPhotoURLAsGallery
Designates the stock photo (when available) to be used as the Gallery picture in the listing. To use
your own photo as the Gallery picture, but still use the stock photo as the second picture, enter 0 in
this field, and then use the PicURL on page 69 field to specify your self-hosted photo as the Gallery
picture.
N/ACharacter limit
BooleanType
Use 1 (for True) or 0 for False.
Valid Entry
Shipping services fields
Explains the fields and corresponding values that define available shipping service options, rates, and
other shipping related information. Note the difference between the terms field and value. Field refers
to the presence of the column header.Value implies the field is present, and input (a value) is required
for that field.
Template field definitions90
File Exchange Advanced Template Instructions
Important: When revising these fields, you must also include certain field information for the
listing in the uploaded file, even if the information has not changed. For the names of fields that
must be included in a revised listing, see revision dependent fields on page 13.
For more information about using these fields, see Specifying payments, shipping, and returns on
page 37 .
DomesticRateTable
The eBay domestic shipping rate table can be used to specify shipping costs to areas in the continental
United States, Alaska/Hawaii, United States protectorates (Puerto Rico, Guam), and to Army Post
Office (APO) and Fleet Post Office (FPO) addresses in the United States.
Rate tables are defined in your eBay account Shipping Preferences.You must create the rate tables
prior to using them for File Exchange.
When you set up a rate table, you can specify a rate for each region and service level you want to
support.You can opt to specify rates per item, per weight, or by surcharge. Only one of these rate
types can be used at a time.The rate type selected in your Shipping Preferences becomes the default
rate table used in your listings.
N/ACharacter limit
PredefinedType
Default
Valid Entry
GlobalShipping
When you opt in to the Global Shipping Program on eBay, use GlobalShipping to specify that an item
is to be made available to buyers around the world.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) The default value is 0 (false).Valid Entry
To use this field, you must first opt in to the Global Shipping Program on the eBay site.
For terms and conditions, see Global Shipping Program Seller Terms and Conditions.
Field Dependency
IntlShippingService-1:AdditionalCost
Cost to ship additional items when a buyer purchases two or more of the same item.
For example, if a buyer purchases three identical items, the first ships with the price specified in
IntlShippingService-1:Cost, whereas the remaining two ship with the value specified in
IntlShippingService-1:AdditionalCost.
When no value is entered (and Action=Add), the value defaults to the amount specified in
IntlShippingService-1:Cost.
91Template field definitions
File Exchange Advanced Template Instructions
N/ACharacter limit
CurrencyType
Numeric amount, like 3.99.
Valid Entry
Do not enter a value when ShippingType=Freight for international services.
Field Dependency
Do not enter a value when ShippingType=Calculated for international services.
IntlShippingService-1:Cost
Cost to ship the item with the selected shipping service.
N/ACharacter limit
CurrencyType
Numeric amount, like 0.00, 1.99
Valid Entry
Must accompany IntlShippingService-1:Option on page 92.
Field Dependency
Do not enter a value when ShippingType=Freight for international services.
Do not enter a value when ShippingType=Calculated for international services.
IntlShippingService-1:Locations
An international location or region to which an item can be shipped, according to the respective shipping
service. Multiple locations are separated by the pipe (|) character. For example: Asia|Europe.
For location field values, refer to Values for international location fields on page 54.
N/ACharacter limit
Text stringType
Must be a valid shipping location value, like Europe or Americas.
Valid Entry
Field and value(s) are required when any international shipping service is specified.
Field Dependency
IntlShippingService-1:Option
An international shipping service the buyer can choose to ship the item.
N/ACharacter limit
Text stringType
Template field definitions92
File Exchange Advanced Template Instructions
Must be a valid service option value.
For valid service option values, refer to Shipping services field values on page 102.
Valid Entry
Must be accompanied by IntlShippingService-1:Cost.Field Dependency
IntlShippingService-1:Priority
Defines the display order of the international shipping service options shown in your listing.
For example, if two or more international shipping services are specified, the service with Priority=1
will be the first shipping option shown in your listing.
Note: Each international service priority must be unique; no two international shipping services
can have the same Priority.
N/ACharacter limit
IntegerType
Numeric value, like 1, 2, or 3.
Valid Entry
Field and a value are required if more than one international shipping service is specified.
Field Dependency
IntlShippingService-2:AdditionalCost
Cost to ship additional items when a buyer purchases two or more of the same item.
For example, if a buyer purchases three identical items, the first ships at the price specified in
IntlShippingService-2:Cost, whereas the remaining two ship with the value specified in
IntlShippingService-2:AdditionalCost.
If no value is entered (and Action=Add), the value defaults to the IntlShippingService-2:Cost amount.
N/ACharacter limit
CurrencyType
Numeric amount, like 3.99.
Valid Entry
Do not enter a value when ShippingType=Freight for international services.
Field Dependency
Do not enter a value when ShippingType=Calculated for international services.
IntlShippingService-2:Cost
Cost to ship the item with the selected shipping service.
N/ACharacter limit
CurrencyType
93Template field definitions
File Exchange Advanced Template Instructions
Numeric amount, like 0.00, 1.99
Valid Entry
Must accompany IntlShippingService-2:Option.
Field Dependency
Do not enter a value when ShippingType=Freight for international services.
Do not enter a value when ShippingType=Calculated for international services.
IntlShippingService-2:Locations
An international location or region to which an item can be shipped, according to the respective shipping
service. Multiple locations are separated by the pipe (|) character. For example: Asia|Europe.
For location field values, refer to Values for international location fields on page 54.
N/ACharacter limit
Text stringType
Must be a valid shipping location value, like Europe or Americas.
Valid Entry
Field and value(s) are required when any international shipping service is specified.
Field Dependency
IntlShippingService-2:Option
An international shipping service the buyer can choose to ship the item.
N/ACharacter limit
Text stringType
Must be a valid service option value.
For valid service option values, refer to Shipping services field values on page 102.
Valid Entry
Must be accompanied by IntlShippingService-2:Cost.Field Dependency
IntlShippingService-2:Priority
Defines the display order of the international shipping service options shown in your listing.
For example, if two or more international shipping services are specified, the service with Priority=1
will be the first shipping option shown in your listing.
Note: Each international service priority must be unique; no two international shipping services
can have the same Priority.
N/ACharacter limit
IntegerType
Template field definitions94
File Exchange Advanced Template Instructions
Numeric value, like 1, 2, or 3.
Valid Entry
Field and a value are required if more than one international shipping service is specified.
Field Dependency
IntlShippingService-3:AdditionalCost
Cost to ship additional items when a buyer purchases two or more of the same item.
For example, if a buyer purchases three identical items, the first ships at the price specified in
IntlShippingService-3:Cost, whereas the remaining two ship with the value specified in
IntlShippingService-3:AdditionalCost.
If no value is entered (and Action=Add), the value defaults to the IntlShippingService-3:Cost amount.
N/ACharacter limit
CurrencyType
Numeric amount, like 3.99.
Valid Entry
Do not enter a value when ShippingType=Freight for international services.
Field Dependency
Do not enter a value when ShippingType=Calculated for international services.
IntlShippingService-3:Cost
Cost to ship the item with the selected shipping service.
N/ACharacter limit
CurrencyType
Numeric amount, like 0.00, 1.99
Valid Entry
Must accompany IntlShippingService-3:Option.
Do not enter a value when ShippingType=Freight for international services.
Field Dependency
Do not enter a value when ShippingType=Calculated for international services.
IntlShippingService-3:Locations
An international location or region to which an item can be shipped, according to the respective shipping
service. Multiple locations are separated by the pipe (|) character. For example: Asia|Europe.
For location field values, refer to Values for international location fields on page 54.
N/ACharacter limit
Text stringType
95Template field definitions
File Exchange Advanced Template Instructions
Must be a valid shipping location value, like Europe or Americas.
Valid Entry
Field and value(s) are required when any international shipping service is specified.
Field Dependency
IntlShippingService-3:Option
An international shipping service the buyer can choose to ship the item.
N/ACharacter limit
Text stringType
Must be a valid service option value.
For valid service option values, refer to Shipping services field values on page 102.
Valid Entry
Must be accompanied by IntlShippingService-3:Cost.Field Dependency
IntlShippingService-3:Priority
Defines the display order of the international shipping service options shown in your listing.
For example, if two or more international shipping services are specified, the service with Priority=1
will be the first shipping option shown in your listing.
Note: Each international service priority must be unique; no two international shipping services
can have the same Priority.
N/ACharacter limit
IntegerType
Numeric value, like 1, 2, or 3.
Valid Entry
Field and a value are required if more than one international shipping service is specified.
Field Dependency
ShippingService-1:AdditionalCost
Cost to ship additional items when a buyer purchases two or more of the same item.
For example, if a buyer purchases three identical items, the first item ships with the price specified in
ShippingService-1:Cost, while the remaining two items ship with the value specified in
ShippingService-1:AdditionalCost.
If no value is provided and Action=Add, the value defaults to the amount specified by
ShippingService-1:Cost.
N/ACharacter limit
Template field definitions96
File Exchange Advanced Template Instructions
CurrencyType
Numeric amount, such as 3.99
Valid Entry
Do not provide a value when:Field Dependency
• ShippingService-1:FreeShipping=1
• ShippingType is set to Calculated for domestic services
• *ShippingType on page 76 is set to Freight for domestic services
ShippingService-1:Cost
Cost to ship the item with the selected shipping service.
N/ACharacter limit
CurrencyType
Numeric amount, like 0.00, 1.99.
Valid Entry
This field must accompany ShippingService-1:Option on page 97 regardless of whether
ShippingService-1:FreeShipping on page 97 contains a value or not.
Field Dependency
Do not enter a value when ShippingService-1:FreeShipping=1 for domestic services.
For domestic services, do not enter a value when ShippingType=Freight.
For domestic services, do not enter a value when ShippingType=Calculated.
ShippingService-1:FreeShipping
Determines whether shipping is free for the first domestic shipping option.
Note: The FreeShipping field does not apply to additional (or international) shipping services.
If you want to offer free shipping for other services, enter a value of 0.00 for that service's Cost
field.
N/ACharacter limit
BooleanType
1 or 0 Default is 1.
Valid Entry
ShippingService-1:Option
A domestic shipping service the buyer can choose to ship the item.
N/ACharacter limit
Text stringType
97Template field definitions
File Exchange Advanced Template Instructions
Must be a valid service option value.
For valid service option values, refer to Shipping services field values on page 102.
Valid Entry
Must be accompanied by ShippingService-1:Cost on page 97.Field Dependency
ShippingService-1:Priority
Defines the display order of the domestic shipping service options shown in your listing.
For example, if two or more domestic shipping services are specified, the service with Priority as 1
will be the first shipping option shown in your listing.
Note: Each domestic service priority must be unique; no two domestic shipping services can
have the same Priority.
N/ACharacter limit
IntegerType
Numeric value, like 1, 2, or 3.
Valid Entry
Field and a value are required if more than one domestic shipping service is specified.Field Dependency
ShippingService-1:ShippingSurcharge
Additional cost to buyers who request an item be shipped to Alaska, Hawaii, Puerto Rico, or Guam.
When you specify calculated shipping, the surcharge is automatically applied when UPS is used to
ship items to these remote areas.
For more information, see *ShippingType on page 76.
N/ACharacter limit
CurrencyType
Numeric amount, such as 3.99.
Valid Entry
To avoid a surcharge, leave this field blank – 0.00 is not a valid value.
Field Dependency
ShippingService-2:AdditionalCost
For example, if a buyer purchases three identical items, the first item ships with the price specified in
ShippingService-2:Cost, while the remaining two items ship with the value specified in
ShippingService-2:AdditionalCost.
If no value is entered (and Action=Add), the value defaults to the ShippingService-2:Cost amount.
N/ACharacter limit
CurrencyType
Template field definitions98
File Exchange Advanced Template Instructions
Numeric amount, such as 3.99
Valid Entry
Field Dependency
ShippingService-2:Cost
Cost to ship the item with the selected shipping service.
N/ACharacter limit
CurrencyType
Numeric amount, like 0.00, 1.99.
Valid Entry
This field must accompany ShippingService-2:Option on page 99.Field Dependency
Do not enter a value when ShippingType=Freight for domestic services.
Do not enter a value when ShippingType=Calculated for domestic services.
ShippingService-2:Option
A domestic shipping service the buyer can choose to ship the item.
N/ACharacter limit
Text stringType
Must be a valid service option value.
For valid service option values, refer to Shipping services field values on page 102.
Valid Entry
Must be accompanied byShippingService-2:Cost on page 99.Field Dependency
ShippingService-2:Priority
Defines the display order of the domestic shipping service options shown in your listing.
For example, if two or more domestic shipping services are specified, the service with Priority as 1
will be the first shipping option shown in your listing.
Note: Each domestic service priority must be unique; no two domestic shipping services can
have the same Priority.
N/ACharacter limit
IntegerType
Numeric value, like 1, 2, or 3.
Valid Entry
Field and a value are required if more than one domestic shipping service is specified.Field Dependency
99Template field definitions
File Exchange Advanced Template Instructions
ShippingService-2:ShippingSurcharge
Additional cost to buyers who request an item be shipped to Alaska, Hawaii, Puerto Rico, or Guam.
When you specify calculated shipping, the surcharge is automatically applied when UPS is used to
ship items to these remote areas.
For more information, see *ShippingType on page 76.
N/ACharacter limit
CurrencyType
Numeric amount, such as 3.99.
Valid Entry
To avoid a surcharge, leave this field blank – 0.00 is not a valid value.
Field Dependency
ShippingService-3:AdditionalCost
Cost to ship additional items when a buyer purchases two or more of the same item.
For example, if a buyer purchases three identical items, the first item ships with the price specified in
ShippingService-3:Cost, while the remaining two items ship with the value specified in
ShippingService-3:AdditionalCost.
If no value is entered (and Action=Add), the value defaults to the ShippingService-3:Cost amount.
N/ACharacter limit
CurrencyType
Numeric amount, such as 3.99
Valid Entry
Field Dependency
ShippingService-3:Cost
Cost to ship the item with the selected shipping service.
N/ACharacter limit
CurrencyType
Numeric amount, like 0.00, 1.99.
Valid Entry
This field must accompany ShippingService-3:Option.
Field Dependency
Do not enter a value when ShippingType=Freight for domestic services.
Do not enter a value when ShippingType=Calculated for domestic services.
Template field definitions100
File Exchange Advanced Template Instructions
ShippingService-3:Option
A domestic shipping service the buyer can choose to ship the item.
N/ACharacter limit
Text stringType
Must be a valid service option value.
For valid service option values, refer to Shipping services field values on page 102.
Valid Entry
Must be accompanied by ShippingService-3:Cost.Field Dependency
ShippingService-3:Priority
Defines the display order of the domestic shipping service options shown in your listing.
For example, if two or more domestic shipping services are specified, the service with Priority as 1
will be the first shipping option shown in your listing.
Note: Each domestic service priority must be unique; no two domestic shipping services can
have the same Priority.
N/ACharacter limit
IntegerType
Numeric value, like 1, 2, or 3.
Valid Entry
Field and a value are required if more than one domestic shipping service is specified.Field Dependency
ShippingService-3:ShippingSurcharge
Additional cost to buyers who request an item be shipped to Alaska, Hawaii, Puerto Rico, or Guam.
When you specify calculated shipping, the surcharge is automatically applied when UPS is used to
ship items to these remote areas.
For more information, see *ShippingType on page 76.
N/ACharacter limit
CurrencyType
Numeric amount, such as 3.99.
Valid Entry
To avoid a surcharge, leave this field blank – 0.00 is not a valid value.
Field Dependency
101Template field definitions
File Exchange Advanced Template Instructions
Shipping services field values
This section explains the shipping service codes supported in the default templates.These values are
used in the ShippingService-n:Option field of the default templates (where -n equals -1, -2,
or -3).
Australia services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Australia.
International servicesDomestic services
AU_AirMailInternationalAU_StandardDelivery
AU_AusPostRegisteredPostInternationalPaddedBag500gAU_Regular
AU_AusPostRegisteredPostInternationalPaddedBag1kgAU_RegularParcelWithTracking
AU_AusPostRegisteredPostInternationalParcelAU_RegularParcelWithTrackingAndSignature
AU_ExpeditedInternationalAU_eBayAusPost500gFlatRateSatchel
AU_ExpressCourierInternationalAU_eBayAusPost3kgFlatRateSatchel
AU_ExpressPostInternationalAU_PrePaidParcelPostSatchels500g
AU_PrePaidExpressPostInternationalBox5kgAU_PrePaidParcelPostSatchels3kg
AU_PrePaidExpressPostInternationalBox10kgAU_Registered
AU_PrePaidExpressPostInternationalBox20kgAU_RegisteredParcelPost
AU_PrePaidExpressPostInternationalEnvelopeB4AU_Registered ParcelPostPrepaidSatchel500g
AU_PrePaidExpressPostInternationalEnvelopeC5AU_Registered ParcelPostPrepaidSatchel3kg
AU_PrePaidExpressPostInternationalSatchels2kgAU_Express
AU_PrePaidExpressPostInternationalSatchels3kgAU_ExpressDelivery
AU_SeaMailInternationalAU_PrePaidExpressPostSatchel500g
AU_StandardInternationalAU_PrePaidExpressPostSatchel3kg
AU_PrePaidExpressPostSatchel5kg
AU_PrePaidExpressPostPlatinum500g
AU_PrePaidExpressPostPlatinum3kg
AU_AustralianAirExpressFlatRate1kg
AU_AustralianAirExpressFlatRate3kg
AU_AustralianAirExpressFlatRate5kg
AU_AustralianAirExpressMetro15kg
AU_EconomyDeliveryFromOutsideAU
Template field definitions102
File Exchange Advanced Template Instructions
International servicesDomestic services
AU_ExpeditedDeliveryFromOutsideAU
AU_StandardDeliveryFromOutsideAU
AU_Courier
AU_Pickup
Austria services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Austria.
International servicesDomestic services
AT_SonstigerVersandInternationalAT_COD
AT_UnversicherterExpressVersandInternationalAT_ExpressOrCourier
AT_UnversicherterVersandInternationalAT_InsuredDispatch
AT_VersicherterExpressVersandInternationalAT_InsuredExpressOrCourier
AT_VersicherterVersandInternationalAT_InsuredSpecialDispatch
AT_Pickup
AT_Sonstige
AT_SpecialDispatch
AT_StandardDispatch
AT_Writing
Belgium (French) services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Belgium.
International servicesDomestic services
BEFR_DHLInternationalBEFR_LaPosteCertifiedShipping
BEFR_FedExInternationalBEFR_LaPosteStandardShipping
BEFR_LaPosteInternationalBEFR_LaPosteTaxipost24h
BEFR_LivraisonSecuriseBEFR_LaPosteTaxipostLLS
BEFR_OtherInternationalBEFR_LaPosteTaxipostSecur
BEFR_PostInternationalRegisteredBEFR_LivraisonSecurise
BEFR_PostInternationalStandardBEFR_OtherShippingMethods
BEFR_TNTInternationalBEFR_Pickup
BEFR_UPSInternationalBEFR_PointRetraitKiala
103Template field definitions
File Exchange Advanced Template Instructions
Belgium (Dutch) services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Belgium.
International servicesDomestic services
BENL_DHLInternationalBENL_DePostCertifiedShipping
BENL_FedExInternationalBENL_DePostStandardShipping
BENL_LaPosteInternationalBENL_DePostTaxipost24h
BENL_OtherInternationalBENL_DePostTaxipostLLS
BENL_PostInternationalRegisteredBENL_DePostTaxipostSecur
BENL_PostInternationalStandardBENL_KialaAfhaalpunt
BENL_TNTInternationalBENL_OtherShippingMethods
BENL_UPSInternationalBENL_Pickup
BENL_VerzekerdeVerzendingInternationalBENL_VerzekerdeVerzending
Canada services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Canada.
International servicesDomestic services
CA_ExpeditedInternationalCA_Pickup
CA_PostExpeditedParcelUSACA_PostLettermail
CA_PostInternationalLetterPostCA_PostPriorityCourier
CA_PostInternationalParcelAirCA_PostRegularParcel
CA_PostInternationalParcelSurfaceCA_PostXpresspost
CA_PostLightPacketInternationalCA_UPSStandardCanada
CA_PostLightPacketUSACA_UPSExpeditedCanada
CA_PostSmallPacketsUSAAirCA_UPSExpressCanada
CA_PostSmallPacketsUSAGroundCA_UPSExpressSaverCanada
CA_PostUSALetterPostCA_EconomyShippingfromoutsideCanada
CA_PostXpresspostInternationalCA_ExpeditedShippingfromoutsideCanada
CA_PostXpresspostUSACA_StandardShippingfromoutsideCanada
CA_PriorityWorldwideCA_CanadaPostPriorityNextAM
CA_SmallPacketsInternationalAirCA_EconomyShipping
CA_SmallPacketsInternationalGroundCA_ExpressShipping
CA_StandardInternationalCA_StandardShipping
CA_UPS3DaySelectUnitedStatesCA_PostExpeditedParcel
CA_UPSExpeditedUnitedStates
Template field definitions104
File Exchange Advanced Template Instructions
International servicesDomestic services
CA_UPSExpressUnitedStates
CA_UPSStandardUnitedStates
CA_UPSWorldWideExpedited
CA_UPSWorldWideExpress
Canada (French) services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in French Canada.
International servicesDomestic services
QUEBEC_ExpeditedInternationalQUEBEC_ExpeditedDelivery
QUEBEC_OtherInternationalQUEBEC_PostExpeditedParcel
QUEBEC_PostInternationalLetterPostQUEBEC_PostExpeditedParcelUSA
QUEBEC_PostInternationalParcelAirQUEBEC_PostLettermail
QUEBEC_PostInternationalParcelSurfaceQUEBEC_PostPriorityCourier
QUEBEC_PostXpresspostInternationalQUEBEC_PostRegularParcel
QUEBEC_PurolatorInternationalQUEBEC_PostSmallPacketsUSA
QUEBEC_SmallPacketsInternationalQUEBEC_PostSmallPacketsUSAAir
QUEBEC_SmallPacketsInternationalAirQUEBEC_PostSmallPacketsUSAGround
QUEBEC_SmallPacketsInternationalGroundQUEBEC_PostUSALetterPost
QUEBEC_StandardInternationalQUEBEC_PostXpresspost
QUEBEC_UPSWorldWideExpeditedQUEBEC_PostXpresspostUSA
QUEBEC_UPSWorldWideExpressQUEBEC_StandardDelivery
QUEBEC_UPS3DaySelectUnitedStates
QUEBEC_UPSExpeditedCanada
QUEBEC_UPSExpeditedUnitedStates
QUEBEC_UPSExpressCanada
QUEBEC_UPSExpressSaverCanada
QUEBEC_UPSExpressUnitedStates
QUEBEC_UPSStandardCanada
QUEBEC_UPSStandardUnitedStates
China services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in China.
105Template field definitions
File Exchange Advanced Template Instructions
International servicesDomestic services
CN_ExpeditedInternationalCN_ExpressDeliveryOtherCities
CN_OtherInternationalCN_ExpressDeliverySameCity
CN_StandardInternationalCN_FastPostOffice
CN_PostOfficeExpress
CN_RegularPackage
France services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in France.
International servicesDomestic services
FR_ChronopostClassicInternationalFR_AuteModeDenvoiDeColis
FR_ChronopostExpressInternationalFR_Autre
FR_ChronopostPremiumInternationalFR_Chrono10
FR_DHLInternationalFR_Chrono13
FR_ExpeditedInternationalFR_Chrono18
FR_LaPosteColisEconomiqueInternationalFR_Chronopost
FR_LaPosteColissimoEmballageInternationalFR_ChronopostChronoRelais
FR_LaPosteColissimoInternationalFR_ColiposteColissimo
FR_LaPosteInternationalEconomyCourierFR_ColiposteColissimoRecommended
FR_LaPosteInternationalPriorityCourierFR_Ecopli
FR_OtherInternationalFR_LaPosteLetterMax
FR_StandardInternationalFR_PostOfficeLetter
FR_UPSExpressInternationalFR_PostOfficeLetterFollowed
FR_UPSStandardInternationalFR_PostOfficeLetterRecommended
FR_RemiseEnMainPropre
FR_UPSStandardAgainstRefund
FR_EconomyDeliveryFromAbroad
FR_ExpressDeliveryFromAbroad
FR_StandardDeliveryFromAbroad
Germany services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Germany.
International servicesDomestic services
DE_DeutschePostBriefInternationalDE_DHLPackchen
Template field definitions106
File Exchange Advanced Template Instructions
International servicesDomestic services
DE_DHLPackchenInternationalDE_DHLPaket
DE_DHLPaketInternationalDE_DPBuecherWarensendung
DE_ExpressInternationalDE_DPDClassic
DE_HermesPaketInternationalDE_DPDExpress
DE_IloxxTransportInternationalDE_DeutschePostBrief
DE_PaketInternationalDE_eBayHermesPaketShop2ShopKaeufer
DE_SonstigeInternationalDE_Einschreiben
DE_eBayHermesPaketSperrgutShop2Shop
DE_Express
DE_ExpressversandAusDemAusland
DE_GLSPaket
DE_HermesPaket
DE_HermesPackchen
DE_HermesPaketSperrgut
DE_IloxxTransport
DE_Nachname
DE_Paket
DE_Pickup
DE_SonstigeDomestic
DE_SparversandAusDemAusland
DE_SpecialDelivery
DE_StandardversandAusDemAusland
DE_UPSExpress
DE_UPSStandard
Hong Kong services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Hong Kong.
International servicesDomestic services
HK_InternationalRegularShippingHK_DomesticRegularShipping
HK_InternationalSpecialShippingHK_DomesticSpecialShipping
HK_LocalCourier
HK_LocalPickUpOnly
107Template field definitions
File Exchange Advanced Template Instructions
Ireland services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Ireland.
International servicesDomestic services
IE_CollectionInPersonInternationalIE_CollectionInPerson
IE_EconomySDSCourierInternationalIE_EconomySDSCourier
IE_EMSSDSCourierInternationalIE_EMSSDSCourier
IE_InternationalEconomyServiceIE_FirstClassLetterService
IE_InternationalPriorityServiceIE_OtherCourier
IE_OtherCourierInternationalIE_RegisteredPost
IE_SellersStandardRateInternationalIE_SellersStandardRate
IE_SellersStandardRateInternationalIE_SwiftPostNational
IE_SwiftPostExpressInternational
IE_SwiftPostInternational
India services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in India.
International servicesDomestic services
IN_ExpeditedInternationalIN_BuyerPicksUpAndPays
IN_OtherInternationalIN_Courier
IN_StandardInternationalIN_Express
IN_FlatRateCOD
IN_Regular
Italy services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Italy.
International servicesDomestic services
IT_ExpeditedInternationalIT_ExpressCourier
IT_OtherInternationalIT_ExpressPackageMaxi
IT_StandardInternationalIT_InsuredMail
IT_MailRegisteredLetter
IT_Pickup
IT_PriorityMail
Template field definitions108
File Exchange Advanced Template Instructions
International servicesDomestic services
IT_QuickMail
IT_QuickPackage1
IT_QuickPackage3
IT_RegularPackage
IT_EconomyDeliveryFromAbroad
IT_ExpressDeliveryFromAbroad
IT_StandardDeliveryFromAbroad
Malaysia services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Malaysia.
International servicesDomestic services
NoneMY_DomesticNonStandardMail
MY_DomesticStandardMail
MY_LocalCourier
MY_LocalPickupOnly
Netherlands services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in the Netherlands.
International servicesDomestic services
NL_DHLInternationalNL_Other
NL_DPDGBRInternationalNL_ParcelPost
NL_ExpeditedInternationalNL_Pickup
NL_FedExInternationalNL_RegisteredMail
NL_GLSBusinessInternationalNL_StandardDelivery
NL_OtherInternational
NL_StandardInternational
NL_TPGPostTNTInternational
NL_UPSInternational
Philippines services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in the Philippines.
109Template field definitions
File Exchange Advanced Template Instructions
International servicesDomestic services
NonePH_DomesticNonStandardMail
PH_DomesticStandardMail
PH_LocalCourier
PH_LocalPickupOnly
Poland services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Poland.
International servicesDomestic services
PL_DHLInternationalPL_DomesticRegular
PL_InternationalRegularPL_DomesticSpecial
PL_InternationalSpecial
PL_UPSInternational
Singapore services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Singapore.
International servicesDomestic services
NoneSG_DomesticNonStandardMail
SG_DomesticSpeedpostIslandwide
SG_DomesticStandardMail
SG_LocalCourier
SG_LocalPickUpOnly
Spain services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Spain.
International servicesDomestic services
ES_CartasPostalInternationalES_CartasInternacionalesDeMas20
ES_EconomyPacketInternationalES_CartasInternacionalesHasta20
ES_EmsPostalExpressInternationalES_CartasNacionalesDeMas20
ES_ExpeditedInternationalES_CartasNacionalesHasta20
ES_OtherInternationalES_Otros
ES_StandardInternationalES_PaqueteAzulDeMas2kg
Template field definitions110
File Exchange Advanced Template Instructions
International servicesDomestic services
ES_PaqueteAzulHasta2kg
ES_PaqueteInternacionalEconomico
ES_Pickup
ES_Urgente
Switzerland services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Switzerland.
International servicesDomestic services
CH_EconomySendungenInternationalCH_COD
CH_PrioritySendungenInternationalCH_ExpressOrCourier
CH_SonstigerVersandInternationalCH_InsuredDispatch
CH_UrgentSendungenInternationalCH_InsuredExpressOrCourier
CH_InsuredSpecialDispatch
CH_Pickup
CH_Sonstige
CH_SpecialDispatch
CH_StandardDispatchAPost
CH_StandardDispatchBPost
CH_Writing
Taiwan services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Taiwan.
International servicesDomestic services
TW_CPInternationalEMSTW_COD
TW_CPInternationalLetterPostTW_DwellingMatchCOD
TW_CPInternationalOceanShippingParcelTW_DwellingMatchPost
TW_CPInternationalParcelPostTW_ExpressMail
TW_CPInternationalRegisteredLetterPostTW_Other
TW_CPInternationalRegisteredParcelPostTW_ParcelPost
TW_FedExInternationalEconomyTW_RegisteredMail
TW_FedExInternationalPriorityTW_SelfPickup
TW_OtherInternationalTW_UnregisteredMail
TW_UPSWorldwideExpedited
111Template field definitions
File Exchange Advanced Template Instructions
International servicesDomestic services
TW_UPSWorldwideExpress
TW_UPSWorldwideExpressPlus
United Kingdom services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in the United Kingdom.
International servicesDomestic services
UK_CollectInPersonInternationalUK_CollectDropAtStoreDeliveryToDoor
UK_OtherCourierOrDeliveryInternationalUK_CollectInPerson
UK_ParcelForceEuro48InternationalUK_EconomyShippingFromOutside
UK_ParcelForceInternationalDatapostUK_ExpeditedShippingFromOutside
UK_ParcelForceInternationalScheduledUK_myHermesDoorToDoorService
UK_ParcelForceIreland24InternationalUK_OtherCourier
UK_RoyalMailAirmailInternationalUK_OtherCourier24
UK_RoyalMailAirsureInternationalUK_OtherCourier3Days
UK_RoyalMailHMForcesMailInternationalUK_OtherCourier48
UK_RoyalMailInternationalSignedForUK_OtherCourier5Days
UK_RoyalMailSurfaceMailInternationalUK_Parcelforce24
UK_SellersStandardInternationalRateUK_Parcelforce48
UK_RoyalMailFirstClassRecorded
UK_RoyalMailFirstClassStandard
UK_RoyalMailSecondClassRecorded
UK_RoyalMailSecondClassStandard
UK_RoyalMailSpecialDelivery9am
UK_RoyalMailSpecialDeliveryNextDay
UK_RoyalMailStandardParcel
UK_SellersStandardRate
UK_StandardShippingFromOutside
United States services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in the United States of America.
In the following table, the value for Other designates economy shipping.
International servicesDomestic services
ExpeditedInternationalEconomyShippingFromOutsideUS
Template field definitions112
File Exchange Advanced Template Instructions
International servicesDomestic services
FedExGroundInternationalToCanadaExpeditedShippingFromOutsideUS
FedExInternationalEconomyePacketChina
FedExInternationalPriorityePacketHongKong
OtherInternationalFedEx2Day
StandardInternationalFedExExpressSaver
UPSStandardToCanadaFedExHomeDelivery
UPSWorldWideExpeditedFedExPriorityOvernight
UPSWorldWideExpressFedExStandardOvernight
UPSWorldWideExpressPlusOther
UPSWorldwideSaverPickup
USPSExpressMailInternationalShippingMethodExpress
USPSExpressMailInternationalFlatRateEnvelopeShippingMethodOvernight
USPSExpressMailInternationalLegalFlatRateEnvelopeShippingMethodStandard
USPSFirstClassMailInternationalStandardShippingFromOutsideUS
USPSPriorityMailInternationalUPS2ndDay
USPSPriorityMailInternationalFlatRateBoxUPS3rdDay
USPSPriorityMailInternationalFlatRateEnvelopeUPSGround
USPSPriorityMailInternationalLargeFlatRateBoxUPSNextDay
USPSPriorityMailInternationalLegalFlatRateEnvelopeUPSNextDayAir
USPSPriorityMailInternationalPaddedFlatRateEnvelopeUSPSExpressFlatRateEnvelope
USPSPriorityMailInternationalSmallFlatRateBoxUSPSExpressMail
USPSExpressMailLegalFlatRateEnvelope
USPSFirstClass
USPSMedia
USPSParcel
USPSPriority
USPSPriorityFlatRateBox
USPSPriorityFlatRateEnvelope
USPSPriorityMailLargeFlatRateBox
USPSPriorityMailLegalFlatRateEnvelope
USPSPriorityMailPaddedFlatRateEnvelope
USPSPriorityMailSmallFlatRateBox
Result and report fields
Explains the field definitions used for upload results and various reports.
113Template field definitions
File Exchange Advanced Template Instructions
Load results report fields
The table below explains the load results field data downloaded from File Exchange.
Load Results Report Fields
DescriptionField Name
Action value for corresponding listing.Action
Custom, application-specific data to be associated with the new item.ApplicationData
eBay fee for 10-day auction for this listing.AuctionLengthFee
eBay fee to boldface the title for the item listing.BoldFee
eBay fee to display a border around an item in the listing.BorderFee
eBay fee to add the BuyItNow feature on this listing.BuyItNowFee
eBay fee for listing the item in the selected category.CategoryFeaturedFee
Specifies currency type, such as USD, CAD, GBP, AUD, EUR, CHF, TWD,
CNY, INR
CurrencyID
Holds your internal SKU or unique identifier and is a very useful way to index
your inventory with eBay listings and associated costs.
CustomLabel
Time listing will end on eBay site. Type:YYYY-MM-DD HH:MM:SS. Hours
are in 24-hour format (for example, 2:00:00pm is shown as 14:00:00) and
treated as GMT.
EndTime
Code number denoting reason for the listing failure during upload.ErrorCode
Text description that corresponds to ErrorCode.ErrorMessage
eBay fee to list the item at the top of the item listings.FeaturedFee
eBay fee to list a fixed-price item for a certain duration.FeaturedGalleryFee
eBay fee for using the FixedPriceDuration feature on this listing.FixedPriceDurationFee
eBay fee to have the item included in the gallery.GalleryFee
eBay fee to display the gift icon next to the listing.GiftIconFee
eBay fee to make the listing appear highlighted.HighlightFee
Basic eBay fee for listing the item. EU residents who sell items on EU sites
may be subject to VAT.
InsertionFee
For sites that don't normally charge insertion fees, a fee for offering shipping
to countries other than the country of the listing site.
InternationalInsertionFee
eBay-designated ID number that is given to successful listings only.ItemID
Line number of the listing from your upload file.LineNumber
eBay fee to list the item using a Listing Designer layout or theme template.
Using Motors vehicle listings might result in a higher fee.
ListingDesignerFee
Template field definitions114
File Exchange Advanced Template Instructions
Load Results Report Fields
DescriptionField Name
Total eBay fee for listing the item, which includes basic fee (InsertionFee)
plus any specialty listing features (GalleryFee, HighLightFee, FeaturedFee,
ListingFee
ListingDesignerFee, etc.). EU residents who sell items on EU sites may be
subject to VAT.
eBay fee use of Photo Hosting feature, a slideshow of multiple images.PhotoDisplayFee
eBay fee for associating photos with the listed item.PhotoFee
Fee for selecting ProPackBundle (at a discount over individually selecting
BoldTitle).Valid only for U.S. and Canadian eBay Motors.
ProPackBundleFee
eBay fee for specifying a reserve price for the auctioned item.ReserveFee
eBay fee to schedule a listing for a later date.SchedulingFee
Time listing went live on eBay site (same as ScheduleTime, if used). Type:
YYYY-MM-DD HH:MM:SS. Hours are in 24-hour format (for example,
2:00:00pm is shown as 14:00:00) and treated as GMT.
StartTime
Specifies success or failure of action for listing. If "Fail," ErrorCode and
ErrorMessage fields provide corresponding information.
Status
eBay fee to add a subtitle to item listing.SubtitleFee
Active Listings report fields
The table below explains the Active Listings report field data downloaded from File Exchange.
Active Listings Report Fields
DescriptionField Name
Current number of bids on a listing. Only applies to Chinese and Live
Auctions. (Note that the Live Auctions option gives you a snapshot of you're
my eBay active listings which includes any Live Auction listings.)
Bids
Name of leaf category.CategoryLeafName
Number of the leaf category in which the listing was created.CategoryNumber
Physical condition of the item.Condition
Value you can assign (such as internal SKU or unique identifier); way to
index your inventory with eBay listings and associated costs.
CustomLabel
Date/time the Active Listings file was downloaded; for example, Mar-29-10
13:32:01 PST.
DownloadDate
Date the listing was ended; for example, Apr-01-10.EndDate
eBay-generated ID number that is given to successful listings only.ItemID
Title displayed in the listing.ItemTitle
Chinese, Live Auctions = Highest current bid; Fixed Price, Store Inventory
= Buy It Now price; Second Chance Offer = Price offered; Ad/Real Estate
Price
115Template field definitions
File Exchange Advanced Template Instructions
Active Listings Report Fields
DescriptionField Name
= Listed price (Note that the Live Auctions option gives you a snapshot of
you're my eBay active listings which includes any Live Auction listings.)
Only applies to Store Inventory and Fixed Price. Current number of purchases
for a listing. Note that # of purchases does not necessarily = # of items
purchased.
Purchases
Number of items remaining for a particular listing.QuantityAvailable
eBay site on which the item is listed, denoted by an integer; for example, 0
(U.S.), 100 (eBay Motors), 77 (Germany).
SiteListed
Date the listing was created; for example, Mar-25-08.StartDate
Sold Listings report fields
The table below explains the Sold Listings report field data downloaded from File Exchange.
Sold Listings Report Fields
DescriptionField Name
Buyer's primary address.Buyer Address 1
Buyer's secondary address.Buyer Address 2
Buyer's city.Buyer City
Buyer's country.Buyer Country
Buyer's email address.Buyer Email
Buyer's first and last name.Buyer Fullname
Buyer's phone number.Buyer Phone Number
Buyer's state.Buyer State
Buyer's postal code.Buyer Zip
Date the sales transaction occurred.Checkout Date
Value you can assign (such as internal SKU or unique identifier); way to
index your inventory with eBay listings and associated costs.
CustomLabel
Shows if you sent feedback for the buyer (Yes/No).Feedback Left
Shows if the buyer gave you feedback (Yes/No).Feedback Received
eBay-generated ID number that is given to successful listings only.ItemID
Title displayed in the listing.ItemTitle
Site where the listing appeared.Listed On
Information about the item (not seen by the buyer).Notes to Yourself
Numeric ID for an order, which has multiple transactions.Order ID
Template field definitions116
File Exchange Advanced Template Instructions
Sold Listings Report Fields
DescriptionField Name
Date the item was paid for.Paid on Date
How the item was paid for.Payment Method
Numeric ID for a PayPal transaction that involves eBay.PayPal Transaction ID
Type of data contained in ProductIDValue such as ISBN, UPC, EAN or
eBay-generated Product Identifier.
ProductIDType
Value of first ProductIDType.Product ID Value 1
Value of second ProductIDType, like when two ISBN numbers are used.
For example, the ISBN-13 number is shown in Product ID Value 1, and the
ISBN-10 number is shown in Product ID Value 2.
Product ID Value 2
Unique payment ID for this transaction.Purpose
Number of item purchased.Quantity
Purchased date of the item(s).Sale Date
The amount the item sold for (not including shipping costs).Sale Price
Numeric ID of the listing after the item sells.Sales Record Number
The tax cost for the item.Sales Tax
Date item was sent to the buyer.Shipped on Date
Total of shipping and handling costs.Shipping and Handling
Carrier used to ship the item.Shipping Service
The marketplace where the item was sold, such as eBay.Sold On
Total cost of the item, including shipping cost.Total Price
Total cost of the item, including P&P cost.Total Price
Numeric ID for a single transaction.Transaction ID
Member ID of the buyer.User ID
Lists the variations used in the listing.Variation Details
Active Listings report
The following table describes the fields in the Active Listings report, which you can download from File
Exchange.
Active Listings Report Fields
DescriptionField Name
Current number of bids for an active listing.Bids
Name of leaf category.CategoryLeafName
117Template field definitions
File Exchange Advanced Template Instructions
Active Listings Report Fields
DescriptionField Name
Numeric ID of the category in which the item is to be listed.Category Number
The physical condition of the item.Condition
Numeric value used to denote the condition of an item. For example, 1000, 2750, or
3000.
Condition ID
Contains an internal SKU or unique identifier and is a very useful way to index your
inventory with eBay listings and associated costs.
Custom Label
Date and time at which the file was downloaded. For example, 29-Mar-12 13:32:01 PST.Download Date
Date on which the listing ended; for example, 1-Apr-12.End Date
Numeric ID assigned to the item when it is successfully listed. In the Load Results report
for the Add action, this is the ItemID that the system has assigned to each successful
listing (for other actions, it will be returned if you included it in your upload file).
Item ID
Title displayed in the listing.Item Title
One of the following. For:Price
• Active auctions, the highest current bid
• Fixed Price and Store Inventory items, the Buy It Now price
• Second Chance Offers, the price offered
• Ad/Real Estate, the listed price
Any content about the item or the transaction that you provided in your upload file.Private Notes
eBay Product ID (EPID) of the item.Product:EPID
Applies to Store Inventory and Fixed Price sales only.This is the current number of
purchases for a listing.The number of purchases does not necessarily equal the number
of items purchased.
Purchases
Number of items remaining for a specific listing.QuantityAvailable
The eBay site on which the item is listed, denoted by an integer. For example, 0 (U.S.),
100 (eBay Motors), or 77 (Germany).
Site Listed
Date on which the listing was created. For example, 25-Mar-12.Start Date
Numeric ID for the type of auction. For example, 1 is Auction, 7 is Store Fixed Price, 9
is Basic Fixed Price, and 13 is Lead Generation.
Type
Provides the variations used in the listing.Variation Details
Awaiting Payment report
The following table describes the fields in the Awaiting Payment report, which you can download from
File Exchange.
Template field definitions118
File Exchange Advanced Template Instructions
Awaiting Payment Report Fields
DescriptionField Name
Physical address of the buyer, typically a post office box, street address, or house name.Buyer Address 1
Supplement physical address of the buyer such as an apartment or suite number.Buyer Address 2
City in which the buyer resides.Buyer City
Country in which the buyer resides.Buyer Country
eMail address of the buyer.Buyer Email
Name of the buyer.Buyer Fullname
(US only) Phone number of the buyer.Buyer Phone Number
State in which the buyer resides.Buyer State
ZIP code or postal code for the area in which the buyer resides.Buyer Zip
Date on which the buyer set up a payment.Checkout Date
Contains an internal SKU or unique identifier and is a very useful way to index your
inventory with eBay listings and associated costs.
Custom Label
Indicates that feedback was created for the seller.Feedback Left
Indicates that the feedback was received from the buyer.Feedback Received
Amount of insurance (if applicable) to be paid for by the buyer.Insurance
Numeric ID assigned to the item when it is successfully listed. In the Load Results report
for the Add action, this is the ItemID that the system has assigned to each successful
listing (for other actions, it will be returned if you included it in your upload file).
Item ID
Title displayed in the listing.Item Title
Date on which the item was listed.Listed On
Details provided by the seller about the transaction.Notes to Yourself
Numeric ID of the listing assigned when the order is placed.Order ID
Date on which the buyer paid for the item.Paid on Date
Means by which the buyer is to remit payment.Payment Method
If payment is remitted with PayPal, this value is the transaction ID number assigned by
PayPal.
PayPal Transaction ID
Any content about the item or the transaction that you provided in your upload file.Private Notes
eBay Product ID (EPID) of the item.Product:EPID
Number of units of a specific item available for purchase.Quantity
Date on which the sale took place.Sale Date
The amount the item sold for, not including shipping and handling.
Sale Price
Numeric ID of the listing assigned after the item sells.Sales Record Number
119Template field definitions
File Exchange Advanced Template Instructions
Awaiting Payment Report Fields
DescriptionField Name
Amount of sales tax (if applicable) to be paid for by the buyer.Sales Tax
Date on which the seller shipped the item.Shipped on Date
Total costs charged to the customer to prepare and ship the item.Shipping and Handling
Means by which the item was shipped.Shipping Service
Site on which the item was sold (for example, eBay, Half.com, or WofG.com).Sold On
Total cost of the item, including shipping and handling (as well as sales tax, and insurance
if applicable).
Total Price
Numeric ID for a single transaction.Transaction ID
User Id of the buyer.User Id
Provides the variations used in the listing.Variation Details
Load Response Results report
The following table describes the fields in the Load Response Results report, which you can download
from File Exchange.
Load Response Results Report Fields
DescriptionField Name
Action value for a corresponding listing.Action
Custom, application-specific data to be associated with the new item.ApplicationData
eBay fee for 10-day auction for this listing.AuctionLengthFee
eBay fee to display the title of a listing in bold type.BoldFee
eBay fee to display a border around an item in the listing.BorderFee
eBay fee to add the BuyItNow feature on this listing.BuyItNowFee
eBay fee for listing the item in a selected category.CategoryFeaturedFee
Specifies currency type, such as USD, CAD, GBP, AUD, EUR, CHF, TWD, CNY, and
INR.
CurrencyID
Contains an internal SKU or unique identifier and is a very useful way to index your
inventory with eBay listings and associated costs.
Custom Label
Time at which the listing will end on eBay.Type:YYYY-MM-DD HH:MM:SS. Hours are
displayed in 24-hour format (for example, 2:00:00pm is shown as 14:00:00) and treated
as GMT.
EndTime
Code number denoting reason for the listing failure during upload.ErrorCode
Text description that corresponds to ErrorCode.ErrorMessage
Template field definitions120
File Exchange Advanced Template Instructions
Load Response Results Report Fields
DescriptionField Name
eBay fee to list the item at the top of the item listings.FeaturedFee
eBay fee to list a fixed-price item for a certain duration.FeaturedGalleryFee
eBay fee to list a fixed-price item for a certain duration.FixedPriceDurationFee
eBay fee to have the item included in the gallery.GalleryFee
eBay fee to display the gift icon next to the listing.GiftIconFee
eBay fee to make the listing appear highlighted.HighlightFee
Basic eBay fee for listing the item. EU residents who sell items on EU sites may be
subject to VAT.
InsertionFee
For sites that don't normally charge insertion fees, a fee for offering shipping to countries
other than the country of the listing site.
InternationalInsertionFee
Numeric ID assigned to the item when it is successfully listed. In the Load Results report
for the Add action, this is the ItemID that the system has assigned to each successful
listing (for other actions, it will be returned if you included it in your upload file).
Item ID
Line number of the listing from your upload file.LineNumber
For sites that don't normally charge insertion fees, a fee for offering shipping to countries
other than the country of the listing site.
ListingDesignerFee
Total eBay fee for listing the item, which includes basic fee (InsertionFee) plus any
specialty listing features (GalleryFee, HighLightFee, FeaturedFee, ListingFee, and so
forth). EU residents who sell items on EU sites may be subject to VAT.
ListingFee
eBay fee to use the Photo Hosting feature, a slide show of multiple images.PhotoDisplayFee
eBay fee for associating photos with the listed item.PhotoFee
Fee for selecting ProPackBundle (at a discount over individually selecting BoldTitle).
Valid only for U.S. and Canadian eBay Motors.
ProPackBundleFee
eBay fee for specifying a reserve price for the auctioned item.ReserveFee
eBay fee to schedule a listing for a later date.SchedulingFee
Time listing went live on eBay site (same as ScheduleTime, if used).Type:YYYY-MM-DD
HH:MM:SS. Hours are in 24-hour format (for example, 2:00:00pm is shown as 14:00:00)
and treated as GMT.
StartTime
(Awaiting Payment, Paid Not Shipped) Specifies the status of the purchase; should be
Refunded or Shipped, depending on the purpose of the uploaded file.
Status
(Unsold Items) Indicates the success or failure of an action in a listing. If "Fail," ErrorCode
and ErrorMessage fields provide corresponding information.
eBay fee to add a subtitle to item listing.SubtitleFee
121Template field definitions
File Exchange Advanced Template Instructions
Global Trade Item Number report
Use this section to learn about the fields contained in the Global Trade Item Number report.
Creating a Global Trade Item Number report
Global Trade Item Numbers are integral to worldwide e-commerce because Internet search engines
use Global Trade Item Numbers to find products. Examples of Global Trade Item Numbers include
bar codes, Universal Product Codes (UPC), International Standard Book Numbers (ISBN), and European
Article Numbers (EAN). For more information about these product identifiers, see Using product
identifiers on page 22.
When you associate Global Trade Item Numbers with your listings, you ensure that your listings are
identified in searches performed by potential buyers. Run this report to view - in one place - all the
Global Trade Item Numbers associated with your listings. For example:
Product:EPIDProduct:MPNProduct:EANProduct:ISBNProduct:UPCItemID
EPID30971438MC920LL/A885909459858327095898004iPhone 4s White
16GB
EPID14309738MC774LL/A0885909464845885909457625280724702242iPad 2 32GB 3G
010-00718-20753759077600400752507118Garvin Nuvi 255W
EPID097314384460B003452426640795250924892746Canon EOS 60D
18MP DSLR
To create a Global Trade Item Number report:
1. Using a web browser, go to the Create a Download Request page.
2. Under Listing and Records, select Active.
3. Verify your eBay account email address.
4. Under Download Format, select File Exchange and then select Add Unique Identifiers
(UPC/EAN/ISBN/Brand/MPN).
5. Under Date Range, select either All Active Listings or Active Listings Closing and then use the
date fields to define the desired date range you want to view.
6. Click Save. Make a note of the reference number displayed on the Create a Download Request:
Success page, which identifies the report you just requested.
7. In the File Exchange navigation bar, click Completed Downloads.Your request is displayed on
this page. Until it is complete, the request is designated as "in progress."
8. To view the report when it is complete, click the respective Download link.
9. When prompted, open the file. Be sure to save the file on your computer.
10. When using Microsoft Excel, you may need to widen the ItemID column to view entire value.To
do so, click the right-mouse button and select Format Cells. Move the cursor to the ItemID column
and in the Format Cells window under Category, select Number. Set Decimal Places to 0 (zero)
and, finally, click OK.
Describing the Global Trade Item Number report fields
The following table describes the fields in the Global Trade Item Number report:
Template field definitions122
File Exchange Advanced Template Instructions
DescriptionField Name
Action value for a corresponding listing.Action
Numeric ID assigned to the item when it is successfully listed. In the Load Results
report for the Add action, this is the ItemID that the system has assigned to each
Item ID
successful listing (for other actions, it will be returned if you included it in your upload
file).
Universal Product Code (UPC) of the item.Product:UPC
International Standard Book Number (ISBN) of the item.Product:ISBN
European Article Number (EAN) of the item.Product:EAN
eBay Product ID (EPID) of the item.Product:EPID
Manufacturer's Part Number (MPN) of the item.Product:MPN
Indicates that the listing contains pre-filled information.Product:IncludePreFilledInformation
Numeric value used to denote the condition of an item. For example, 1000, 2750,
or 3000.
Condition ID
Paid and Awaiting Shipment report
The following table describes the fields in the Paid and Awaiting Shipment report, which you can
download from
Paid and Awaiting Shipment Report Fields
DescriptionField Name
Physical address of the buyer, typically a post office box, street address, or house name.Buyer Address 1
Supplement physical address of the buyer such as an apartment or suite number.Buyer Address 2
City in which the buyer resides.Buyer City
Country in which the buyer resides.Buyer Country
eMail address of the buyer.Buyer Email
Name of the buyer.Buyer Fullname
(US only) Phone number of the buyer.Buyer Phone Number
State in which the buyer resides.Buyer State
ZIP code or postal code for the area in which the buyer resides.Buyer Zip
Date on which the buyer set up a payment.Checkout Date
Contains an internal SKU or unique identifier and is a very useful way to index your
inventory with eBay listings and associated costs.
Custom Label
Indicates that feedback was created for the seller.Feedback Left
Indicates that the feedback was received from the buyer.Feedback Received
Amount of insurance (if applicable) to be paid for by the buyer.Insurance
123Template field definitions
File Exchange Advanced Template Instructions
Paid and Awaiting Shipment Report Fields
DescriptionField Name
Numeric ID assigned to the item when it is successfully listed. In the Load Results report
for the Add action, this is the ItemID that the system has assigned to each successful
listing (for other actions, it will be returned if you included it in your upload file).
Item ID
Title displayed in the listing.Item Title
Date on which the item was listed.Listed On
Details provided by the seller about the transaction.Notes to Yourself
Numeric ID of the listing assigned when the order is placed.Order ID
Date on which the buyer paid for the item.Paid on Date
Means by which the buyer is to remit payment.Payment Method
If payment is remitted with PayPal, this value is the transaction ID number assigned by
PayPal.
PayPal Transaction ID
Any content about the item or the transaction that you provided in your upload file.Private Notes
eBay Product ID (EPID) of the item.Product:EPID
Number of units of a specific item available for purchase.Quantity
Date on which the sale took place.Sale Date
The amount the item sold for, not including shipping and handling.
Sale Price
Numeric ID of the listing assigned after the item sells.Sales Record Number
Amount of sales tax (if applicable) to be paid for by the buyer.Sales Tax
Date on which the seller shipped the item.Shipped on Date
Total costs charged to the customer to prepare and ship the item.Shipping and Handling
Means by which the item was shipped.Shipping Service
Site on which the item was sold (for example, eBay, Half.com, or WofG.com).Sold On
Total cost of the item, including shipping and handling (as well as sales tax, and insurance
if applicable).
Total Price
Numeric ID for a single transaction.Transaction ID
User Id of the buyer.User Id
Provides the variations used in the listing.Variation Details
Paid and Shipped Items report
The following table describes the fields in the Paid and Shipped Items report, which you can download
from File Exchange.
Template field definitions124
File Exchange Advanced Template Instructions
Paid and Shipped Items Report Fields
DescriptionField Name
Physical address of the buyer, typically a post office box, street address, or house name.Buyer Address 1
Supplement physical address of the buyer such as an apartment or suite number.Buyer Address 2
City in which the buyer resides.Buyer City
Country in which the buyer resides.Buyer Country
eMail address of the buyer.Buyer Email
Name of the buyer.Buyer Fullname
(US only) Phone number of the buyer.Buyer Phone Number
State in which the buyer resides.Buyer State
ZIP code or postal code for the area in which the buyer resides.Buyer Zip
Date on which the buyer set up a payment.Checkout Date
Contains an internal SKU or unique identifier and is a very useful way to index your inventory
with eBay listings and associated costs.
Custom Label
Indicates that feedback was created for the seller.Feedback Left
Indicates that the feedback was received from the buyer.Feedback Received
Amount of insurance (if applicable) to be paid for by the buyer.Insurance
Numeric ID assigned to the item when it is successfully listed. In the Load Results report for
the Add action, this is the ItemID that the system has assigned to each successful listing (for
other actions, it will be returned if you included it in your upload file).
Item ID
Title displayed in the listing.Item Title
Date on which the item was listed.Listed On
Details provided by the seller about the transaction.Notes to Yourself
Numeric ID of the listing assigned when the order is placed.Order ID
Date on which the buyer paid for the item.Paid on Date
Means by which the buyer is to remit payment.Payment Method
If payment is remitted with PayPal, this value is the transaction ID number assigned by PayPal.PayPal Transaction ID
Any content about the item or the transaction that you provided in your upload file.Private Notes
eBay Product ID (EPID) of the item.Product:EPID
Number of units of a specific item available for purchase.Quantity
Date on which the sale took place.Sale Date
The amount the item sold for, not including shipping and handling.
Sale Price
Numeric ID of the listing assigned after the item sells.Sales Record Number
Amount of sales tax (if applicable) to be paid for by the buyer.Sales Tax
125Template field definitions
File Exchange Advanced Template Instructions
Paid and Shipped Items Report Fields
DescriptionField Name
Date on which the seller shipped the item.Shipped on Date
Total costs charged to the customer to prepare and ship the item.Shipping and Handling
Means by which the item was shipped.Shipping Service
Site on which the item was sold (for example, eBay, Half.com, or WofG.com).Sold On
Total cost of the item, including shipping and handling (as well as sales tax, and insurance if
applicable).
Total Price
Use a tracking number to identify, trace, and check the status of a shipment as it moves to
its destination. Not all sellers track shipments.
Tracking Number
Numeric ID for a single transaction.Transaction ID
User Id of the buyer.User Id
Provides the variations used in the listing.Variation Details
Product Inventory report
The following table describes the fields in the Product Inventory report, which you can download from
File Exchange.
Product Inventory Report Fields
DescriptionField Name
Action value for a corresponding listing.Action
Specifies currency type, such as USD, CAD, GBP, AUD, EUR, CHF, TWD, CNY, and INR.CurrencyID
Fields that can be used to contain additional information about an item.Folder
ID assigned to a collection of similar products.GroupProductID
The name of the product.ProductName
Used to described the topmost category for the item.Root Folder
Amount paid by the seller to purchase the item.Unit Cost
Sold Listings report
The following table describes the fields in the Sold Listings report, which you can download from File
Exchange.
Sold Listings Report Fields
DescriptionField Name
Physical address of the buyer, typically a post office box, street address, or house name.Buyer Address 1
Template field definitions126
File Exchange Advanced Template Instructions
Sold Listings Report Fields
DescriptionField Name
Supplement physical address of the buyer such as an apartment or suite number.Buyer Address 2
City in which the buyer resides.Buyer City
Country in which the buyer resides.Buyer Country
eMail address of the buyer.Buyer Email
Name of the buyer.Buyer Fullname
(US only) Phone number of the buyer.Buyer Phone Number
State in which the buyer resides.Buyer State
ZIP code or postal code for the area in which the buyer resides.Buyer Zip
Date on which the buyer set up a payment.Checkout Date
Contains an internal SKU or unique identifier and is a very useful way to index your
inventory with eBay listings and associated costs.
Custom Label
Time at which the listing will end on eBay.Type:YYYY-MM-DD HH:MM:SS. Hours are
displayed in 24-hour format (for example, 2:00:00pm is shown as 14:00:00) and treated
as GMT.
EndTime
Indicates that feedback was created for the seller.Feedback Left
Indicates that the feedback was received from the buyer.Feedback Received
Amount of insurance (if applicable) to be paid for by the buyer.Insurance
Numeric ID assigned to the item when it is successfully listed. In the Load Results report
for the Add action, this is the ItemID that the system has assigned to each successful
listing (for other actions, it will be returned if you included it in your upload file).
Item ID
Title displayed in the listing.Item Title
Date on which the item was listed.Listed On
Details provided by the seller about the transaction.Notes to Yourself
Numeric ID of the listing assigned when the order is placed.Order ID
Date on which the buyer paid for the item.Paid on Date
Means by which the buyer is to remit payment.Payment Method
If payment is remitted with PayPal, this value is the transaction ID number assigned by
PayPal.
PayPal Transaction ID
Any content about the item or the transaction that you provided in your upload file.Private Notes
eBay Product ID (EPID) of the item.Product:EPID
Number of units of a specific item available for purchase.Quantity
Date on which the sale took place.Sale Date
The amount the item sold for, not including shipping and handling.
Sale Price
127Template field definitions
File Exchange Advanced Template Instructions
Sold Listings Report Fields
DescriptionField Name
Numeric ID of the listing assigned after the item sells.Sales Record Number
Amount of sales tax (if applicable) to be paid for by the buyer.Sales Tax
Date on which the seller shipped the item.Shipped on Date
Total costs charged to the customer to prepare and ship the item.Shipping and Handling
Means by which the item was shipped.Shipping Service
Site on which the item was sold (for example, eBay, Half.com, or WofG.com).Sold On
Time listing went live on eBay site (same as ScheduleTime, if used).Type:YYYY-MM-DD
HH:MM:SS. Hours are in 24-hour format (for example, 2:00:00pm is shown as 14:00:00)
and treated as GMT.
StartTime
Total cost of the item, including shipping and handling (as well as sales tax, and insurance
if applicable).
Total Price
Use a tracking number to identify, trace, and check the status of a shipment as it moves
to its destination. Not all sellers track shipments.
Tracking Number
Numeric ID for a single transaction.Transaction ID
User Id of the buyer.User Id
Provides the variations used in the listing.Variation Details
Unsold Items report
The following table describes the fields in the Unsold Items report, which you can download from File
Exchange.
Unsold Items Report Fields
DescriptionField Name
Current number of bids for an active listing.Bids
Name of leaf category.CategoryLeafName
Numeric ID of the category in which the item is to be listed.Category Number
The physical condition of the item.Condition
Contains an internal SKU or unique identifier and is a very useful way to index your
inventory with eBay listings and associated costs.
Custom Label
Date and time at which the file was downloaded. For example, 29-Mar-12 13:32:01
PST.
Download Date
Date on which the listing ended; for example, 1-Apr-12.End Date
Highest bid entered for the item.High Bid
Template field definitions128
File Exchange Advanced Template Instructions
Unsold Items Report Fields
DescriptionField Name
Numeric ID assigned to the item when it is successfully listed. In the Load Results
report for the Add action, this is the ItemID that the system has assigned to each
Item ID
successful listing (for other actions, it will be returned if you included it in your upload
file).
Title displayed in the listing.Item Title
One of the following. For:Price
• Active auctions, the highest current bid
• Fixed Price and Store Inventory items, the Buy It Now price
• Second Chance Offers, the price offered
• Ad/Real Estate, the listed price
Any content about the item or the transaction that you provided in your upload file.Private Notes
eBay Product ID (EPID) of the item.Product:EPID
Number of items remaining for a specific listing.QuantityAvailable
The eBay site on which the item is listed, denoted by an integer. For example, 0 (U.S.),
100 (eBay Motors), or 77 (Germany).
Site Listed
(Awaiting Payment, Paid Not Shipped) Specifies the status of the purchase; should be
Refunded or Shipped, depending on the purpose of the uploaded file.
Status
(Unsold Items) Indicates the success or failure of an action in a listing. If "Fail," ErrorCode
and ErrorMessage fields provide corresponding information.
Date on which the listing was created. For example, 25-Mar-12.Start Date
Numeric ID for the type of auction. For example, 1 is Auction, 7 is Store Fixed Price, 9
is Basic Fixed Price, and 13 is Lead Generation.
Type
Number of users watching the item.Watchers
Report fields matrix
Each field contained in the reports generated by File Exchange is listed below according to the report
(or reports) in which it is used .
Report Fields
Unsold
Items
Sold
Listings
Product
Inventory
Paid,
Shipped
Paid,
Awaiting
Shipment
Load
Response
Awaiting
Payment
Active
Listings
Field Name
xxAction
xApplicationData
xAuctionLengthFee
129Template field definitions
File Exchange Advanced Template Instructions
Report Fields
Unsold
Items
Sold
Listings
Product
Inventory
Paid,
Shipped
Paid,
Awaiting
Shipment
Load
Response
Awaiting
Payment
Active
Listings
Field Name
xxBids
xBoldFee
xBorderFee
xBuyItNowFee
xxxxBuyer Address 1
xxxxBuyer Address 2
xxxxBuyer City
xxxxBuyer Country
xxxxBuyer Email
xxxxBuyer Fullname
xxxxBuyer Phone Number
xxxxBuyer State
xxxxBuyer Zip
xCategoryFeaturedFee
xxCategoryLeafName
xxCategory Number
xxxxCheckout Date
xxCondition
xCondition ID
xxCurrencyID
xxxxxxxCustom Label
xxDownload Date
xxEnd Date
xxEndTime
xErrorCode
xErrorMessage
xFeaturedFee
xFeaturedGalleryFee
xxxxFeedback Left
xxxxFeedback Received
Template field definitions130
File Exchange Advanced Template Instructions
Report Fields
Unsold
Items
Sold
Listings
Product
Inventory
Paid,
Shipped
Paid,
Awaiting
Shipment
Load
Response
Awaiting
Payment
Active
Listings
Field Name
xFixedPriceDurationFee
xGalleryFee
xGroupProductID
xHigh Bid
xHighlightFee
xInsertionFee
xxxxInsurance
xInternationalInsertionFee
xxxxxxxItem ID
xxxxxxItem Title
xLineNumber
xxxxListed On
xListingDesignerFee
xListingFee
xLocation
xxxxNotes to Yourself
xxxxOrder ID
xxxxPaid on Date
xxxxPayment Method
xxxxPayPal Transaction ID
xPhotoDisplayFee
xPhotoFee
xxPrice
xxxxxxPrivate Notes
xProductName
xxxxxxProduct:EPID
xProPackBundleFee
xPurchases
xxQuantityAvailable
xxxxQuantity
131Template field definitions
File Exchange Advanced Template Instructions
Report Fields
Unsold
Items
Sold
Listings
Product
Inventory
Paid,
Shipped
Paid,
Awaiting
Shipment
Load
Response
Awaiting
Payment
Active
Listings
Field Name
xReserveFee
xRootFolder
xxxxSale Date
xxxxSale Price
xxxxSales Record Number
xxxxSales Tax
xSchedulingFee
xxxxShipped on Date
xxxxShipping and Handling
xxxxShipping Service
xxSite Listed
xxxxSold On
xxStart Date
xxStartTime
xxStatus
xSubtitleFee
xxxxTotal Price
xxxxTransaction ID
xxType
xUnit Cost
xxxxUser Id
xxxxxVariation Details
xWatchers
Template field definitions132
File Exchange Advanced Template Instructions
Index
A
Action field 21
Action field definition 59
Action values
excess fields 18
Info 15
using multiple 18
action-specific required fields 16
Active Listings report fields 117
Add action 12
adding fields
auto-accept and -decline 33
conditionID 32
custom item specifics 31
dimension 41
international site visibility 34
payment information 37
return policy information 39
shipment tracking numbers 39
shipping discounts 37
weight 40
adding new fields
custom item specifics 31
general 19
international site visibility 34
shipping discount 38
weight and dimensions 40
AddToItemDescription action 12
API compatibility level 54
Australia shipping services option field values 102
austria shipping services option field values 103
auto-accept and auto-decline 33
Awaiting Payment report fields 118
B
belgium (dutch) shipping services option field values 104
belgium (french) shipping services option field values
103
best offer fields 82
buyer requirements 35
C
Canada (French) shipping services option field values
105
canada shipping services option field values 104
case-sensitivity 11
catalog-supported sites 50
category, store numbers 33
cell information 48
character
limits 11
types 11
china shipping services option field values 105
combined payments 37
compatibility
motorcycles 24
vehicles 24
compatibility fields 24
conditionID 32
cost fields 82
country 53
country codes 56
credit card fields 78
currency 53
CustomLabel, variation 27
D
data
entering 21
deleting a field
general info 20
deleting multiple field values
general info 20
Description field 21
design fields 59
dimension fields 41, 72
discount fields 82
display fields 59
domestic shipping rate table 41
domestic shipping services field values 102
domestic shipping services fields 91
download files
programmatically 46
E
eBay store
category numbers 33
eBay token 46
End action 12
entering data 21
excess fields 18
F
feedback fields 59
field definition
Action 59
field relationships 11
fields
Action 21
133Index
File Exchange Advanced Template Instructions
fields (continued)
Description 21
entering data 21
Title 21
fields, reports
Active Listings 117
Awaiting Payment 118
Global Trade Item Number 122
Load Response Results 120
matrix 129
Paid and Awaiting Shipment 123
Paid and Shipped 124
Product Inventory 126
Sold Listings 126
Unsold Items 128
File Exchange
finding templates 10
file format 12
file revision 44
file size and content rules 12
flat-file formats 51
france shipping services option field values 106
G
germany shipping services option field values 106
gift fields 72
Global Trade Item Number report fields 122
H
handling fields 72
hong kong shipping services option field values 107
HTTP post request 47
I
india shipping services option field values 108
Info action 15
international shipping services field values 102
international shipping services fields 91
international site visibility 34
ireland shipping services option field values 108
italy shipping services option field values 108
item specifics, custom 31
L
limits
characters 11
Load Response Results report fields 120
load result report fields 113
M
malaysia shipping services option field values 109
metadata
API compatibility level 54
metadata (continued)
cell information 48
Country 53
Currency 53
overriding 48
SiteID 52
modify variations 30
motorcycles
compatibility 24
multiple actions in one file 18
N
netherlands shipping services option field values 109
numbers, store category 33
O
overriding metadata 48
P
package dimension 41
package fields 72
package weight 40
Paid and Awaiting Shipment report fields 123
Paid and Shipped report fields 124
parts and compatibility fields 24
payment fields 78
payment policy 37
philippines shipping services option field values 109
picture fields 59
PicURL, variation 27
poland shipping services option field values 110
pricing fields 82
product fields 22, 88
product identifiers 22
Product Inventory report fields 126
programmatic instructions to download files 46
programmatic instructions to upload files 46
Q
Quantity, variation 27
quotation marks 18
R
rate table
domestic shipping 41
region names 54
Relationship, variation 27
RelationshipDetails, variation 27
Relist action 12
report fields 113
Active Listings 117
Awaiting Payment 118
Global Trade Item Number 122
Index134
File Exchange Advanced Template Instructions
report fields (continued)
Load Results Response 120
matrix 129
Paid and Awaiting Shipment 123
Paid and Shipped 124
Product Inventory 126
Sold Listings 126
Unsold Items 128
Report fields matrix 129
request eBay token 46
required fields per action 16
requirements
buyers 35
results fields 113
return policy 39
return policy fields 78
Revise action 12
revision files 44
S
shipment tracking numbers 39
shipping discounts 37
shipping rates
domestic 41
shipping services field values 102
shipping services fields 91
shipping services option field values
Australia 102
austria 103
belgium(dutch) 104
belgium(french) 103
canada 104
Canada (French) 105
china 105
france 106
germany 106
hong kong 107
india 108
ireland 108
italy 108
malaysia 109
netherlands 109
philippines 109
poland 110
singapore 110
spain 110
switzerland 111
taiwan 111
united kingdom 112
united states 112
singapore shipping services option field values 110
site ID 52
site-specific file formats 51
sites that support catalog templates 50
smart headers 11, 17
Sold Listings report fields 126
spain shipping services option field values 110
StartPrice, variation 27
Status action 12
store category fields 59
store category numbers 33
structure
template 11
style fields 59
supported formats 12
switzerland shipping services option field values 111
T
tables
shipping rates 41
taiwan shipping services option field values 111
tax fields 82
template
entering data 21
templates
adding auto-accept and auto-decline fields 33
adding conditionID 32
adding custom item specific fields 31
adding international site visibility fields 34
adding new fields 19
adding shipment tracking number fields 39
adding shipping discount fields 38
adding weight and dimension fields 40
country codes 56
Country metadata 53
Currency metadata 53
deleting a field 20
deleting multiple field values 20
file formats per site 51
file size and content rules 12
finding 10
metadata cell information 48
modifying 30
overriding metadata 48
parts and compatibility fields 24
product fields 22
region names 54
required fields per action 16
SiteID metadata 52
sites that support catalog template 50
structure 11
using quotation marks 18
using smart headers 17
variation 27
tips 11
Title field 21
token 46
types
characters 11
typographic conventions 10
U
understanding template structure 11
united kingdom shipping services option field values 112
united states shipping services option field values 112
135Index
File Exchange Advanced Template Instructions
Unsold Items report fields 128
upgrade fields 59
upload files
programmatically 46
using Action values 12
using quotation marks 18
using smart headers 17
V
variations
CustomLabel 27
modify 30
PicURL 27
variations (continued)
Quantity 27
Relationship 27
RelationshipDetails 27
StartPrice 27
Variations 27
vehicles
compatibility 24
VerifyAdd action 12
W
weight fields 40, 72
Index136
File Exchange Advanced Template Instructions
