File Exchange
Advanced Template
Instructions
Copyright Statement
Copyright 2015 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.5.2
Date: July 2015
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
June, 2015.............................................................................................................................................9
September, 2014...................................................................................................................................9
March, 2014...........................................................................................................................................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.....................................................................................15
Required template fields for each Action value............................................................................16
Using smart headers and quotation marks..........................................................................................16
Using smart headers....................................................................................................................16
Using quotation marks as text qualifiers.......................................................................................17
Using multiple actions and excess fields.............................................................................................17
One action per row.......................................................................................................................17
File Exchange ignores excess fields............................................................................................17
Performing simple template tasks .............................................................................18
Adding a new field to a default template..............................................................................................18
Deleting a field from a default template...............................................................................................18
Deleting multiple field values...............................................................................................................19
Creating new listings ...................................................................................................20
About listing fees.................................................................................................................................20
Enter data in the template fields..........................................................................................................20
Using business policies.......................................................................................................................22
Using relationship fields for variations ................................................................................................23
Modifying the RelationshipDetails and PicURL of a variation.......................................................26
Modifying the Quantity and StartPrice of a variation....................................................................26
Modifying the Relationship and CustomLabel of a variation.........................................................27
Using a custom item specific field.......................................................................................................27
Using the Condition fields....................................................................................................................28
Get values for ConditionID...........................................................................................................28
Enter ConditionDescription...........................................................................................................29
Using the StoreCategory fields............................................................................................................29
Using store category numbers in a template................................................................................29
Looking up store category numbers.............................................................................................29
Using buyer requirements....................................................................................................................30
Setting up buyer requirements.....................................................................................................30
Applying buyer requirements to listings........................................................................................30
Specifying payments, shipping, and returns ............................................................32
Using the payment fields.....................................................................................................................32
iiiContents
File Exchange Advanced Template Instructions
Using shipping discount fields.............................................................................................................32
Combining payments to offer shipping discounts.........................................................................33
Adding shipping discount values to a template............................................................................33
Using return policy fields.....................................................................................................................34
Tracking your shipments......................................................................................................................34
Uploading and downloading files...............................................................................36
Upload a template file..........................................................................................................................36
View upload results..............................................................................................................................36
Load results report details...................................................................................................................37
Updating your listings .................................................................................................38
Using revision files...............................................................................................................................38
Revising price and quantity for variations in Active Listings................................................................39
Adding product identifiers to Active listings.........................................................................................39
Generating reports.......................................................................................................41
Create a download request..................................................................................................................41
Download an Active listings report......................................................................................................41
Download a Sold items report.............................................................................................................42
Create a download schedule...............................................................................................................42
View download schedule.....................................................................................................................43
Site and template information.....................................................................................44
eBay site-specific information..............................................................................................................44
Site-specific template information.................................................................................................44
Default template metadata information................................................................................................46
Metadata values...........................................................................................................................46
Region names and country codes.......................................................................................................47
Using advanced functions...........................................................................................52
Using programmatic instructions.........................................................................................................52
Requesting an eBay token...........................................................................................................52
Uploading files programmatically..................................................................................................52
Downloading files programmatically.............................................................................................52
Sample HTTP Post Request........................................................................................................53
HTTP Post Request Components................................................................................................53
Using metadata information.................................................................................................................54
Metadata cell information.............................................................................................................54
Overriding metadata values..........................................................................................................54
Template field definitions.............................................................................................56
Design and display fields.....................................................................................................................56
*Action..........................................................................................................................................56
BoldTitle.......................................................................................................................................56
Border...........................................................................................................................................56
BuyerRequirements:MaximumItemCount.....................................................................................57
BuyerRequirements:MaxItemMinFeedback..................................................................................57
BuyerRequirements:MaxUnpaidItemsCount................................................................................57
BuyerRequirements:MaxUnpaidItemsPeriod...............................................................................58
BuyerRequirements:MaxViolationCount.......................................................................................58
BuyerRequirements:MaxViolationPeriod......................................................................................58
BuyerRequirements:MinimumFeedbackScore.............................................................................59
BuyerRequirements:ShiptoRegCountry.......................................................................................59
Contentsiv
File Exchange Advanced Template Instructions
BuyerUserID.................................................................................................................................59
*Category.....................................................................................................................................59
Category2.....................................................................................................................................60
ConditionDescription....................................................................................................................60
*ConditionID.................................................................................................................................60
Country.........................................................................................................................................61
C:<item specific name>................................................................................................................61
CustomLabel................................................................................................................................62
DeleteFields.................................................................................................................................62
*Description..................................................................................................................................63
*Duration.......................................................................................................................................63
EndCode......................................................................................................................................63
Feedback......................................................................................................................................64
FeedbackType..............................................................................................................................64
FE:ListByDate..............................................................................................................................64
*Format.........................................................................................................................................64
GalleryDuration............................................................................................................................65
GalleryType..................................................................................................................................65
HitCounter....................................................................................................................................65
ItemID...........................................................................................................................................66
*Location......................................................................................................................................66
LotSize..........................................................................................................................................66
OutOfStockControl.......................................................................................................................66
PhotoDisplay................................................................................................................................67
PicURL.........................................................................................................................................68
PostalCode...................................................................................................................................68
PrivateAuction..............................................................................................................................68
*Quantity.......................................................................................................................................68
Relationship..................................................................................................................................69
RelationshipDetails.......................................................................................................................69
ScheduleTime..............................................................................................................................69
StoreCategory..............................................................................................................................69
StoreCategory2............................................................................................................................70
Subtitle.........................................................................................................................................70
Title...............................................................................................................................................71
Packaging and handling fields.............................................................................................................71
*DispatchTimeMax.......................................................................................................................71
ExcludeShipToLocation................................................................................................................72
OrderID.........................................................................................................................................72
ShipmentTrackingNumber............................................................................................................73
ShippedTime................................................................................................................................73
ShippingCarrierUsed....................................................................................................................73
ShippingStatus.............................................................................................................................74
*ShippingType..............................................................................................................................74
ShipToLocations...........................................................................................................................74
ShipToRegistrationCountry...........................................................................................................75
TransactionID................................................................................................................................75
Payment and return fields....................................................................................................................75
AdditionalDetails...........................................................................................................................76
vContents
File Exchange Advanced Template Instructions
CashOnPickup..............................................................................................................................76
HolidayReturns.............................................................................................................................76
ImmediatePayRequired................................................................................................................77
MOCashiers.................................................................................................................................77
PaisaPayAccepted........................................................................................................................77
PaisaPayEscrow...........................................................................................................................77
PaisaPayEscrowEMI.....................................................................................................................78
PaymentInstructions.....................................................................................................................78
PaymentProfileName....................................................................................................................78
PaymentSeeDescription...............................................................................................................78
PaymentStatus.............................................................................................................................79
PayUponPickup............................................................................................................................79
PersonalCheck.............................................................................................................................79
RefundOption...............................................................................................................................79
ReturnProfileName.......................................................................................................................80
*ReturnsAcceptedOption..............................................................................................................80
ReturnsWithinOption....................................................................................................................80
ShippingCostPaidByOption..........................................................................................................80
WarrantyDuration.........................................................................................................................81
WarrantyOffered...........................................................................................................................81
WarrantyType...............................................................................................................................81
Pricing and cost fields..........................................................................................................................81
BuyItNowPrice..............................................................................................................................82
Currency.......................................................................................................................................82
InternationalPromotionalShippingDiscount..................................................................................82
InternationalShippingDiscountProfileID........................................................................................82
PromotionalShippingDiscount......................................................................................................83
ReservePrice................................................................................................................................83
ShippingDiscountProfileID............................................................................................................84
*StartPrice....................................................................................................................................84
UseTaxTable.................................................................................................................................84
Shipping services fields.......................................................................................................................84
IntlShippingService-1:AdditionalCost...........................................................................................85
IntlShippingService-1:Cost...........................................................................................................85
IntlShippingService-1:Locations...................................................................................................85
IntlShippingService-1:Option........................................................................................................86
IntlShippingService-1:Priority.......................................................................................................86
IntlShippingService-2:AdditionalCost...........................................................................................86
IntlShippingService-2:Cost...........................................................................................................87
IntlShippingService-2:Locations...................................................................................................87
IntlShippingService-2:Option........................................................................................................87
IntlShippingService-2:Priority.......................................................................................................88
IntlShippingService-3:AdditionalCost...........................................................................................88
IntlShippingService-3:Cost...........................................................................................................88
IntlShippingService-3:Locations...................................................................................................89
IntlShippingService-3:Option........................................................................................................89
IntlShippingService-3:Priority.......................................................................................................89
ShippingProfileName....................................................................................................................90
ShippingService-1:AdditionalCost................................................................................................90
Contentsvi
File Exchange Advanced Template Instructions
ShippingService-1:Cost................................................................................................................90
ShippingService-1:FreeShipping..................................................................................................91
ShippingService-1:Option.............................................................................................................91
ShippingService-1:Priority............................................................................................................91
ShippingService-1:ShippingSurcharge.........................................................................................92
ShippingService-2:AdditionalCost................................................................................................92
ShippingService-2:Cost................................................................................................................92
ShippingService-2:Option.............................................................................................................92
ShippingService-2:Priority............................................................................................................93
ShippingService-2:ShippingSurcharge.........................................................................................93
ShippingService-3:AdditionalCost................................................................................................93
ShippingService-3:Cost................................................................................................................94
ShippingService-3:Option.............................................................................................................94
ShippingService-3:Priority............................................................................................................94
ShippingService-3:ShippingSurcharge.........................................................................................95
*ShippingType..............................................................................................................................95
Shipping services field values.............................................................................................................95
Australia services options.............................................................................................................95
Austria services options...............................................................................................................96
Belgium (French) services options...............................................................................................97
Belgium (Dutch) services options.................................................................................................97
Canada services options..............................................................................................................98
Canada (French) services options................................................................................................99
China services options.................................................................................................................99
France services options..............................................................................................................100
Germany services options..........................................................................................................100
Hong Kong services options.......................................................................................................101
Ireland services options..............................................................................................................101
India services options.................................................................................................................102
Italy services options..................................................................................................................102
Malaysia services options..........................................................................................................103
Netherlands services options.....................................................................................................103
Philippines services options.......................................................................................................104
Poland services options..............................................................................................................104
Singapore services options........................................................................................................104
Spain services options...............................................................................................................105
Switzerland services options......................................................................................................105
Taiwan services options.............................................................................................................106
United Kingdom services options...............................................................................................106
United States services options...................................................................................................107
Result and reports fields............................................................................................109
About report scripts...........................................................................................................................109
Active Listings report.........................................................................................................................109
Awaiting Payment report....................................................................................................................110
Load Response Results report..........................................................................................................112
Global Trade Item Number report......................................................................................................113
Creating a Global Trade Item Number report.............................................................................113
Revising Active listings to include product identifiers using the GTIN report..............................114
Understanding the Global Trade Item Number report fields.......................................................115
viiContents
File Exchange Advanced Template Instructions
Paid and Awaiting Shipment report...................................................................................................115
Paid and Shipped Items report..........................................................................................................117
Product Inventory report....................................................................................................................119
Sold Listings report............................................................................................................................119
Unsold Items report...........................................................................................................................121
Contentsviii
File Exchange Advanced Template Instructions
What's New in File Exchange?
June, 2015
• Product identifiers requirement: Manufactured products, like electronics, clothing, books, and so
on, need to include a product identifier in the listing. Product identifiers include UPC, EAN, ISBN
codes. For more information, refer to Product code fields. Use the GTIN report to add product identifier
information to your active listings. For instructions, refer to Revising Active listings to include product
identifiers using the GTIN report on page 114.
September, 2014
• Holiday returns:The time allowed for buyers to return items during the holiday season can be
extended. For more information, refer to HolidayReturns on page 76.
March, 2014
• Updated shipping services for United Kingdom and United States: Shipping service option values
for these countries have been updated. For more information, refer to Shipping services field values
on page 95.
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 how templates are structured, how to enter your data into the templates, and
how to specify the actions to perform on the the data you enter.
You can enter product information into a template or, if your product information is already documented
in a database or spreadsheet file, map your data into the template file. Regardless of the method you
choose, pay close attention to the following details as you enter data into the structure contained in
the File Exchange template:
• Required field: Data must be entered into every required field. Asterisks (*) denote required fields.
For example, *Description and StartPrice.
Note: If you are a new seller who has sold fewer than 20 listings, the only payment method
you can offer is PaisaPay. Upon selling 20 listings or more, you can add payment methods
such as cheques and demand drafts. For all listings, PaisaPay is mandatory.
• Character type, character limit, and values: Data must meet the requirements for the character types
and limits provided in the template data field tables.
• Header field names are not case-sensitive: For example, File Exchange recognizes paypalaccepted
and PayPalAccepted as the same field. We recommend you use the field names as they are
provided in this guide.
• Field Relationships: Some fields depend on other fields. For example, if you enter a value for
ShippingService-1:Option, you must also enter a value for ShippingService-1:Cost. In some cases,
a field may be optional but require use of a related field. For example, ShipmentTrackingNumber is
optional but when used must be accompanied by a value for ShippingCarrierUsed. Error messages
may appear in the Load Results report when fields contain incorrectly populated fields.
• Using multiple values in one field: Some fields enable you to enter several values.When doing so,
use the pipe ( | ) character to separate values.
• Template variations across eBay sites: Different eBay sites support different default templates. For
example, not all sites support the Catalog template.
Tip: For more information about site-specific templates, see Site-specific template information
on page 44.
• Smart Headers automatically apply values: If you create an item listing file for a specific type of item
(such as a book), you can enter identical values once in the header instead of entering each value
several times. For more information, see Using smart headers and quotation marks on page 16.
The Action data field header includes metadata information such as SiteID, Country, and Currency,
which are specific to the site from which the template is downloaded. Do not change these values
unless you are an advanced user who wants to list items on a different eBay site and you have the
necessary permissions from Customer Support to do so.
11Using and managing template files
File Exchange Advanced Template Instructions
Understanding file size and content rules
The requirements you must follow when entering and formatting data in File Exchange templates are
explained in this section.
To minimize processing errors when using the File Exchange templates, follow these guidelines:
• Files must be saved in one of these formats:
• Comma-separated (.csv)
• Semicolon-delimited (.csv)
• Tab-delimited (.txt)
• A single file cannot exceed 15 MB
• No more than 5000 actions can by uploaded during each 24-hour period
• Templates files must contain data for all required fields (the asterisk (*) marks a field as required)
• The Action field must always be contained in the first cell and first row in a file (the remaining fields
can appear in any order) (for more information, see Using Action values on page 12)
• Do not include headers in a row of data
• When a field value contains leading zeros (such as 00856748589), change the cell format to Text (if
not, the leading zeros are removed from cells that use the Number or General format when the file
is saved in CSV format)
Understanding the Action field values
This section explains how to use the Action field values.
Using Action values
The following sections describe the values you can enter into the Action field. Action values differ from
Action metadata; Action values determine how a listing is processed when it is uploaded whereas
metadata identifies site ID, country, and currency information.You can enter the following values in
the Action field:
• 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 14
See Understanding Action-specific required fields on page 15 for the list of attributes that must
accompany each action in a template file.
Refer to the eBay Help Center for more information about eBay policies and instructions.
Using and managing template files12
File Exchange Advanced Template Instructions
Using the Add action
The Add action posts new listings to eBay and returns a results file that contains any associated fee
data, error warnings, and so forth. This action also generates an Item ID for each new listing (you'll
use the ItemID is used when you revise, relist, and end items).
Using the VerifyAdd action
The VerifyAdd action tests your file format and listing information before you upload the data.This
action performs similarly to theAdd but does not post the listing to eBay. If a listing contains errors,
VerifyAdd writes the errors to the Upload Results file.
VerifyAdd verifies each record on the add file and returns a results file containing any associated fee
data, error warnings, and so forth. When the VerifyAdd is successful, File Exchange calculates fee
amounts for each listing but does not create ItemIDs (Item IDs are created only when a listing is posted
to eBay).You can apply the Add action to the same values as VerifyAdd.When doing so, you can feel
confident the values are correct and no errors will occur when you post your listings to eBay.
Using the Revise action
To revise a listing means to update its content. For example, you can change the BuyItNow price.
When you revise a listing, include values for these required fields only:
• Action – Revise
• ItemID – <eBay-generated ItemID for the listing, retrieved from the Load Response Results report
on page 112>
• <Modified fields> – New values
• <Revision-dependent fields> – Existing values
An Active Listings report on page 109 contains all active listings, including a flag to indicate which items
can be revised.
Revision-dependent fields
Important: Some fields have revision dependencies, which means if you change one field, then
other similar fields – even if unchanged – must be included in the revised listing. Custom item
specific fields (C:<value name>), shipping fields, and payment fields all have this dependency.
Shipping fields: If you revise a shipping field, you must include all other shipping fields if you want
to retain them. For example, if you change the ShippingType field, you must include all the 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 90 ) will be dropped from the listing
• IntlShippingService-n fields – any IntlShippingService-n fields not included (such as
ShippingService-1:Option on page 91) will be dropped from the listing
• ShippingDiscountProfileID on page 84
• PromotionalShippingDiscount on page 83
• InternationalShippingDiscountProfileID on page 82
• InternationalPromotionalShippingDiscount on page 82
• PaymentInstructions on page 78
• UseTaxTable on page 84
13Using and managing template files
File Exchange Advanced Template Instructions
Payment fields: When you revise a payment method field, you must also include the other payment
methods you want to retain. For example, if you change PersonalCheck on page 79 to 1, you must
also include the other payment methods you want to use (such as PaisaPayEscrow on page 77). If
not, they will be dropped from the listing:
• MOCashiers on page 77
• PaymentSeeDescription on page 78
• PersonalCheck on page 79
Using the Relist action
If an item didn't sell, you can relist it (you cannot relist an item until it ends automatically or you force
the end of the listing). After you sell a relisted item, eBay automatically refunds one of the two listing
fees (some restrictions apply).
To avoid errors when you relist an item, include these required fields only:
• Action – Relist
• ItemID – <eBay-generated ItemID for the listing, retrieved from the Load Response Results report
on page 112>
Using the AddToItemDescription action
This option enables you to update the listing description only (as compared to the Revise action you
use to update numerous other details about an item).When you sell a relisted item, eBay automatically
refunds one of the two listing fees (some restrictions apply).
To avoid errors when you use this action, include these required fields only:
• Action – AddToItemDescription
• ItemID – <eBay-generated ItemID for the listing, retrieved from the Load Response Results report
on page 112> For example, 3500001016281
• Description – Additional information added to the listing description. For example, This product
is available in sizes small (S), medium (M), and large (L) only.
Using the End action
Use this action to remove listings from eBay.To avoid errors when you end a listing, include these
required fields only:
• Action – End
• ItemID – <eBay-generated ItemID for the listing, retrieved from the Load Response Results report
on page 112>
• EndCode – Valid values include LostOrBroken, NotAvailable, Incorrect, or
OtherListingError
Using the Status action
The Status can be applied to sold items only! You cannot use Status to update unsold or active listings.
Payment status
To designate an item as paid, insert the following fields in the upload file:
• Action – Status
Using and managing template files14
File Exchange Advanced Template Instructions
• ItemID – <eBay-generated ItemID for the listing, retrieved from the Load Response Results report
on page 112>
• PaymentStatus – 1
Shipping status
To designate an item as shipped, insert the following fields in the upload file:
• Action – Status
• ItemID – <eBay-generated ItemID for the listing, retrieved from the Load Response Results report
on page 112>
• ShippingStatus=1
• TransactionID – <TransactionID from the Sold report>
Leave Feedback status
To leave feedback for buyers, insert the following fields in the 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
To use the Action field for informational purposes only, enter Info. For example:
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.
15Using and managing template files
File Exchange Advanced Template Instructions
Required template fields for each Action value
Uploaded files must contain values for all required fields. An asterisk (*) denotes required fields in the
default catalogue or in non-catalogue (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
also need to enter a value in another field. Field dependencies are explicitly called out when they exist.
Pre-filled item information feature (such as from catalogues) is available for the Digital Cameras and
MP3 Player categories.
Different File Exchange actions require different fields, as shown in the table below:
Action Values
Fields
StatusEndRelistReviseAddToItem
Description
Add or
VerifyAdd
(non-Catalogue)
Add or
VerifyAdd
(Catalogue)
X*Category on page 59
XX*Description on page 63
XX*Duration on page 63
XEndCode on page 63
XX*Format on page 64
XXXXXItemID on page 66
XX*Location on page 66
XX*Quantity on page 68
XX*StartPrice on page 84
XTitle on page 71
XX
*ReturnsAcceptedOption on
page 80
XX
*DispatchTimeMax on page 71
(handling time)
XX
Payment and return fields on
page 75
Using smart headers and quotation marks
This section explains how to maximize the efficiency of the File Exchange templates.
Using smart headers
Use smart headers to set a global default setting in a template file.To designate a default value for
an entire column, enter an equal sign (=) into the respective header. For example, to automatically
insert the value of [email protected] into every cell in the column for PayPalEmailAddress,
enter [email protected] in the header.
When you use smart headers, follow these guidelines:
Using and managing template files16
File Exchange Advanced Template Instructions
• Do not insert spaces between the header name and the header value – for example, enter the
category of 15032 as Category=15032
• When entering a value, follow the rules for the specific data field. For example, 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; instead, you must explicitly list this value for every
item or row
• When you insert an equal (=) sign after the field header but do not include a value, File Exchange
interprets this as a valid field header but with no default or global value and therefore searches for
a value in each row for the respective field or column
• You can override a smart header row-by-row (if you enter an invalid override value, the listing will
fail and a warning will be written to the results file for that row)
• You can instruct File Exchange to interpret a cell as containing no data by inserting a hyphen (-) in
the desired cell (or cells)
Using quotation marks as text qualifiers
Some punctuation entered into the text fields of CSV or TXT files must be enclosed in quotation marks.
Be sure to use plain quotation marks (") and not smart quotes (“”).When a Microsoft Excel file is saved
in CSV or TXT format, the required qualifiers are automatically inserted.
For ExampleWhere to put the QuotesPunctuation
"Brand new, with manufacturer
warranty"
Enclose the text with quotation marks.Comma or semicolon.
"Clarence ""Lumpy"" Rutherford"Include the text field in quotation marks and then
enclose the entire expression in quotation marks.
Quotation marks in a text field. For
example, to denote a nickname or
a descriptive modifier.
Using multiple actions and excess fields
Explains how to use Action field values in the templates.
One action per row
Do not include more than one action in one row! Your uploaded flat files can contain any combination
of actions. For example, you can upload a file that adds listings only.You can also upload a file that
adds new listings and revises existing listings. However, you cannot insert more than one action in
one row. Doing so may cause errors.
File Exchange ignores excess fields
If you submit a file that contains unsupported fields, File Exchange ignores the unsupported fields and
processes the valid actions submitted for the required and eligible fields. For example, if you enter the
End action to remove a listing yet include extraneous fields like Description, File Exchange will ignore
the invalid fields and end the listing as instructed.
17Using and managing template files
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 templates contain a subset of all available fields.To use an optional or new field, you'll
enter it yourself. This section explains how to add a new field to a default template or to one of your
working product listing files.
Templates contain required and optional fields. The asterisk (*) denotes required fields (*Action). Do
not change or delete any of the required fields!
An optional field can be deleted (or renamed and used as a new field not included in the default
template). For example, you might rename the Subtitle on page 70 field as
ShippingService-1:FreeShipping on page 91 and re-use the field.
You can also add blank columns to a template and enter new field names in the column header.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 56.
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 56, and then press Enter.
3. Enter values (in the second row, below the field header) for the new fields, and then save the file.
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 56
Performing simple template tasks18
File Exchange Advanced Template Instructions
field, but would like to offer free shipping for this item, you can replace it with
ShippingService-1:FreeShipping on page 91, and use it for that purpose.
To delete an unused optional field, select the column and 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 DeletedField 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
DeletedField field.
Not all fields can be deleted; refer to DeleteFields on page 62 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 DeletedField 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 DeletedField 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.
19Performing simple template tasks
File Exchange Advanced Template Instructions
Creating new listings
This section explains how to add items to a template.
About listing fees
eBay charges you fees to list and sell items.
Each time you upload a template file to eBay, we automatically list the items as specified. We also
charge you a listing fee for new items, one listing fee per item. When you sell an item, we charge you
a final value fee based on the final selling price of an item. For details about these (and other) fees,
see Fees.
According to the listing information sent in your data feeds, MIP performs actions on your behalf, such
as ending, adding, and relisting items. Unless there is an explicit contract signed with eBay, some
adding and relisting actions will incur listing fees.The listing actions will count towards the total number
of free listings you may have in a month. For details about listing (and other) fees, see Fees.
These actions incur a listing fee:
ResultActionRevision
AddAddA new item is listed
Relist (on next product feed submission)EndSchedule time and listing duration are
changed
Relist (once product info is fixed and sent
again)
EndMultil-SKU listings have incorrect
Variation Specifics and need to be
revised
• One variation has Size and another one
has SIZE
• One variation has size and color, and
another has size only
• One variation has null & others have
non-null variation specifics
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 56
Valid eBay category IDSpecifies the eBay product
category.
*Category on page 59
Creating new listings20
File Exchange Advanced Template Instructions
ExampleAccepted ValuesPurposeHeader Field Name
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 71
AppleOpen; user-definedSpecifies the product brand.Product:Brand
14UPMOTLDR001Open; user-definedSpecifies the manufacturer
part number.
Product:MPN
426351144531Open; user-definedSpecifies the product code
number or key used by the
Product:UPC
manufacturer to identify the
product.
6351144531942Open; user-definedSpecifies the product code
number or key used by the
Product:EAN
manufacturer to identify the
product.
05351144531Open; user-definedSpecifies the product code
number or key used by the
Product:ISBN
manufacturer to identify the
product.
2535114Open; user-definedSpecifies the eBay product
ID in our catalog.
Product:EPID
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 63
10Open; user-definedSpecifies the number of this
type of item for sale.
*Quantity on page 68
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 63
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
use (30) days, and GTC (for
the Good Til Cancelled) for
FixedPrice.
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 66
abbreviation), and country
(three-letter abbreviation).
21Creating new listings
File Exchange Advanced Template Instructions
ExampleAccepted ValuesPurposeHeader Field Name
UPSGroundOpen; user-definedIdentifies the shipping
service carrier.
ShippingService-1:Option on
page 91
For valid shipping service
entries, refer to Shipping
services fields on page 84.
Must accompany an entry for
ShippingService-1:Cost on
page 90.
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 business policies
This section explains business policies and how to apply your payment, return, and shipping policies
to your listings.
To use business policies, you must first opt in on My eBay. Business policies are the payment, return,
and shipping information you specify to your buyers. For details about opting in, see Business policies.
Note:
If you haven't opted in to business policies, skip this section and see these topics instead:
• Using the payment fields on page 32
• Using return policy fields on page 34
• #unique_101
When you opt in to business policies, eBay automatically creates policies based on values contained
in your active, scheduled, and ended listings posted during the previous 90 days.You can edit these
policies from your My eBay page at any time. However, if you have not listed items in the previous 90
days, eBay does not automatically create policies. Instead, you must manually create at least one of
each type of policy – payment, return, and shipping – before you can complete a listing.
The benefits of using centralized business policies are that you can:
• Streamline the creating of new listings and the updating of existing listings
• Edit and update all listings at one time
• Deploy updated policies to listings in bulk
Payment, return, and shipping policies differ according to eBay site.To list the same – or a similar –
item on another eBay site, be sure to set up and select the respective payment, return, and shipping
policies for that site.
Creating new listings22
File Exchange Advanced Template Instructions
While you can create an unlimited number of business policies for each seller account, be thoughtful
about how many you create. Maintaining too many policies can be time-consuming. In addition, keep
your policies up-to-date so that you don't inadvertently include an incorrect or out-of-date policy.
To use your business policies in your listings, use these fields:
• PaymentProfileName on page 78
• ReturnProfileName on page 80
• ShippingProfileName on page 90
For example:
ShippingProfileNameReturnProfileNamePaymentProfileNameDescriptionAction
TwoDayExpeditedExchangeOnlyCashApple TV MD199LL/A Third
Generation
Add
Express21DaysCreditCardRoku 2 XD Wireless Video
Streaming Device
Add
Parcel14DaysPaymentServiceNew! Roku LT Streaming PlayerAdd
Using relationship fields for variations
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 colours 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 69: 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 69: Defines the variation details, like colour 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 colour and size) and their possible values (like Blue and Red, Medium
and Large). Use the format: Trait1=Value1;Value2|Trait2=Value1;Value2. For example:
Colour=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: Colour=Blue|Size=M.
23Creating new listings
File Exchange Advanced Template Instructions
*Quantity on page 68: 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 84: 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 Fixed Price
listing.Values in these fields are required.
The initial item and variation rows for a listing should look like this: Other fields also have item and
variation row requirements:
CustomLabel on page 62: 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 68: 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 68.
• 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 coloured 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 (colour) 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 (colour 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, consider one variation with RelationshipDetails
as Colour=Black|Size=Small and PicURL as Black=http://host.com/my.jpg. If
the next variation has RelationshipDetails as Colour=Black|Size=Medium, you need not
enter Black=http://host.com/my.jpg in 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...
Creating new listings24
File Exchange Advanced Template Instructions
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...
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|Colour=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
relationship fields on page 39 example. 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:
25Creating new listings
File Exchange Advanced Template Instructions
• the value for Quantity falls to zero?
• a pending transaction locks you out of a listing?
Modifying the RelationshipDetails and PicURL of a variation
Neither the RelationshipDetails on page 69 nor the PicURL on page 68 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).
TitleRelationshipDetailsRelationshipItemIDAction
Item 1Colour=Black;Pink;Red;Blue; BlackStripes|Size=S;M;L;XL;XXL10110~Revise
Colour=Black|Size=XLVariationDelete
Colour=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 on page 68 and *StartPrice on page 84 even if one or more
transactions are pending against the variation.
To revise Quantity and StartPrice, 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 Colour=Black|Size=XL and Colour=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|Colour=Black;Pink;Red;Blue10110~Revise
6.993Colour=Black|Size=XLVariation
9.993Colour=Red|Size=SVariation
8.994Colour=Pink|Size=MVariation
Creating new listings26
File Exchange Advanced Template Instructions
Modifying the Relationship and CustomLabel of a variation
When you delete or modify a variation, the CustomLabel on page 62 associated with that variation is
automatically deleted or modified (you need not modify it explicitly).
Lastly, since the value for Relationship on page 69 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 18.
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
• MPN (manufacturer part number)
• 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 15 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.
27Creating 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 Condition fields
Use the Condition fields to connote the condition of an item.
Get values for ConditionID
*ConditionID on page 60 is a mandatory field used to describe the state and appearance of an item.
The same value can connote different meanings depending on the category. For example, 1000
means New in a Computer category listing but New with box in a Shoes category listing.
To look up ConditionID values, click the ConditionIDs by Category link on the File Exchange
Instructions and Resources page. Doing so downloads a CSV file for those categories that require
ConditionIDs. Because the value you enter for ConditionID depends upon category, see the item
condition look-up page to determine which categories require a ConditionID.
To obtain the ConditionID value for a specific category, generate an Item Specifics template.The
generated template will contain the new ConditionID field as well as the ConditionID numbers. 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:
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. To open the Generate Template page, click the Item Specifics Category Template link file.
Creating new listings28
File Exchange Advanced Template Instructions
5. To open the file, click the Item Specifics Definitions link.
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.
Enter ConditionDescription
Use the optional ConditionDescription on page 60 field to describe the condition of a used item.This
field can be used in conjunction with the mandatory *Description on page 63, which should be used
to provide non-condition specifics about an item.To connote the condition of an item, use descriptive
text such as:
"The right leg of the chair has a small scratch (see photo) and the back of the seat has a light blue
stain the shape and size of a silver dollar."
ConditionDescriptionConditionIDDescriptionCategory
Gently used, miniscule scratch on lower left
corner of display.
2000Nokia Lumia 900 Smartphone AT&T
16GB Cyan
9355
Like new, no box or cables. Pristine
condition. Never used.
3000Panasonic Lumix12.1MP DMC-ZS7 Blue31388
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 69 and StoreCategory2
on page 70 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:
29Creating new listings
File Exchange Advanced Template Instructions
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 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 30.
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:MaxUnpaidItemsCount on page 57Buyers with unpaid item strikes
BuyerRequirements:MaxUnpaidItemsPeriod on page 58
Creating new listings30
File Exchange Advanced Template Instructions
BuyerRequirements:ShiptoRegCountry on page 59Buyers in locations to which I don't ship
BuyerRequirements:MaxViolationCount on page 58Buyers with policy violation reports
BuyerRequirements:MaxViolationPeriod on page 58
BuyerRequirements:MinimumFeedbackScore on page 59Buyers with a negative feedback score
BuyerRequirements:MaximumItemCount on page 57Buyers who may bid on several of my items and
not pay for them
BuyerRequirements:MaxItemMinFeedback on page 57
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 5 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 30.
3. Save the file.
When you upload the file to File Exchange, your listings automatically inherit the buyer requirements
you specify.
31Creating new listings
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 payment fields
This section explains how to use the payment fields in the default templates.
Note: If you opted in to Business policies on My eBay, you can skip the following content and
go to #unique_138 to set up and select your payment policies.
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:
• CashOnPickup on page 76
• #unique_140
• MOCashiers on page 77
• PaisaPayEscrow on page 77
• PaisaPayEscrowEMI on page 78
• PersonalCheck on page 79
For details about the payment fields, see Payment and return fields on page 75.
To add payment information to a 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:
PaisaPayEscrowEMIPaisaPayEscrowMOCashiersCashOnPickupTitle
1100Samsung Galaxy Ace
1111Canon 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.
Specifying payments, shipping, and returns32
File Exchange Advanced Template Instructions
Combining payments to offer shipping discounts
Use 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.You use the
InternationalShippingDiscountProfileID on page 82 and ShippingDiscountProfileID on page 84 fields
to do so.To apply shipping discounts, you must use combined payments. For an overview about
shipping discount rules and profiles, see Using Combined Payments and About Shipping Discounts.
To set up shipping discounts:
1. Go to Account > Site Preferences.
2. Go to Account > 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. 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.
7. To create a rule profile, select Add Profiles. Enter a profile name in the adjacent box and then
click Next.
8. On screen 2, review your shipping rule profile specifics. If you approve, click Save.
9. Make a note of the Shipping Discount Profile ID numbers that appear under Combined Shipping
Discounts.You will use these Profile ID numbers in the ShippingDiscountProfileID on page 84 field
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. Shipping
profile ID numbers 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.
33Specifying payments, shipping, and returns
File Exchange Advanced Template Instructions
Using return policy fields
This section explains how to set up a return policy for a listing.
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.
Note: If you opted in to Business policies on My eBay, you can skip the following content and
go to Using business policies on page 22 to set up and select your return policies.
As a seller, you can elect not to accept returns for the items you list. However, keep in mind that even
if you specify ReturnsNotAccepted, a buyer can still return an item should the item not match the listing
description and therefore become eligible for coverage under eBay Buyer Protection. (To be clear,
items not covered by eBay Buyer Protection cannot be returned when ReturnsNotAccepted is specified.)
In addition to describing a return policy in the Description field of an item, you can also use predefined
return policy options.
To define a return policy for an item:
1. For the mandatory *ReturnsAcceptedOption on page 80 field, do one of the following:
• To indicate a buyer can return an item, enter ReturnsAccepted or
• To indicate a buyer cannot return an item, enter ReturnsNotAccepted
During the holiday season, you can offer buyers an extended period of time to return an item. To
learn how, see HolidayReturns on page 76.
2. When you specify that an item can be returned, enter values for these fields:
a. For the optional RefundOption on page 79 field, specify how you will provide the refund, enter
one of the following:
• MerchandiseCredit
• MoneyBack
b. For the optional AdditionalDetails on page 76 field, enter general information you want to convey
to a buyer
3. Save the template.
Tracking your shipments
You can track your shipped items according to shipping carrier and tracking number.
File Exchange cannot be used to enter multiple tracking numbers. Therefore, when a single sale
consists of several separately shipped items, track each item separately.
To add tracking information:
1. Open a blank template file or a working listing file. For details about working with revision files, see
Using revision files on page 38.
2. In the existing Action field for each item you want to track, enter Status.
Specifying payments, shipping, and returns34
File Exchange Advanced Template Instructions
3. Insert the following four new columns (for details, see Adding a new field to a default template on
page 18):
• ItemID on page 66 – The unique identifier of the item you want to track (find this value in the
Upload Response file)
• ShippingStatus on page 74 – 1 (shipped)
• ShipmentTrackingNumber on page 73 – The tracking number from the carrier's invoice
• ShippingCarrierUsed on page 73 – The name of the carrier (not the value provided for
ShippingService-X:Option)
4. Enter the following values in the new fields:
• You must provide values for ShipmentTrackingNumber and ShippingCarrierUsed (you cannot
provide a value for one and not the other).
• You are responsible for the accuracy of the value you enter for ShippingTrackingNumber.We
verify that the tracking number is unique across all your orders and is consistent with the numbering
scheme used by the carrier you provide. For example:
ShippingCarrierUsedShipmentTrackingNumberShippingStatusItemIDAction
Other23416785120954631170684767112Status
5. Delete all other fields in the template.
6. Save the file and upload it to eBay.
35Specifying payments, shipping, and returns
File Exchange Advanced Template Instructions
Uploading and downloading files
Upload a template file
Template files are validated when uploaded as follows:
• A basic format check is performed when files are uploaded. For example, if you use a format other
than .csv, or tab-delimited .txt in some regions, the upload will fail. Also, if the Action field is not
present in the first column, or the required fields are not present and properly formatted, the upload
will fail.
• If you create your File Exchange CSV files on a Unix system (such as Linux), you must convert the
files from Unix format to DOS format before you upload them to eBay. To do so, run the unix2dos
utility against the files to properly encode line breaks. For example, run unix2dos linuxfilename.csv.
Doing so converts the Unix instruction for a new line (\n) to an instruction recognized by Windows
(\r\n). Be sure to upload the converted Windows-compatible version of the files.
• Files can only have up to150,000 rows and cannot be over 5 MB in size
After uploading files, always check the upload results report to verify that no errors occurred. eBay
sends you an email confirmation noting its success or failure. (If the upload fails, the email you receive
will describe any errors.)
Follow these steps to upload your template file:
1. Under File Location, click Browse and locate the new template .csv file that you previously created.
When you have found and selected the file, click Open to place it in the File Location field.
2. Click Upload to send your template file to eBay.
View upload results
The View Upload Results page shows the status of uploaded files, along with this information:
• Date you uploaded the file
• Number of requested actions in the file
• Percentage of actions completed
• Links to the uploaded file(s)
• Upload status, which includes: File Received-In Queue, In Progress, Completed, Failed - Invalid File
Format
The View Upload Results page also allows you to download any file that has been previously uploaded.
For example, if you want to create a similar file from one that uploaded successfully, simply download
that file and rename it when you save it.You can also download your upload results report from this
page once processing has completed.
Use the View Last drop-down menu to see your upload results sorted by time frames (24 hrs, last 7
days, 30 days or 90 days).
Uploading and downloading files36
File Exchange Advanced Template Instructions
Figure 2:View Upload Results page
Click on a Download link under Load Results Report to open a results file.
Load results report details
The Load Results report contains processing data about each listing in your upload file. An example
file is shown below.
37Uploading and downloading files
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.
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. For listings with variations, the price and quantity fields can be
updated for each variation.
For more information, refer to Revising price and quantity for variations in Active Listings on page
39.
• 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.
• Revise product identifiers: Use to update the UPC/EAN/ISBN/Brand/MPN fields 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. Under Date 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 listings38
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.
Revising price and quantity for variations in Active Listings
This section describes how to use the File Exchange Price and Quantity revision file to update variations.
The Price and Quantity revision file still supports updating price and quantity in individual listings, but
can now also be used for variations.
This procedure explains how to revise the price and quantity in active listings that contain variations.
1. To download your active listings, see the download procedure in Using revision files on page 38.
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. Revise the values in the price and quantity fields in the row corresponding to the variation. The
Variation is identified by RelationshipDetails (and CustomLabel field if present). For example, revise
the price and quantity values in the bottom three rows.
CustomLabelStartPriceQuantityRelationshipDetailsRelationshipItemID
CL345WASize=S;M;L;XL|Color=Black;Pink;Red;Blue3500001016281
CL350BS7.995Color=Black|Size=XLVariation
CL350RS10.995Color=Red|Size=SVariation
CL350PS8.994Color=Pink|Size=MVariation
4. When you are finished, 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.
Adding product identifiers to Active listings
This section describes how to use File Exchange to add unique product identifiers 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.
All manufactured goods require a product identifier. 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 38.
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.
39Updating your listings
File Exchange Advanced Template Instructions
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 for more information about each field.
Updating your listings40
File Exchange Advanced Template Instructions
Generating reports
This section explains how to download inventory, sales, and recommendations reports generated by
completing a download request, and then explains how to create download schedules.
Create a download request
The Create a Download Request page enables you to generate inventory and sales reports by choosing
one of these filters on the Listing and Records menu:
• Sold items
• Unsold items
• Sold and archived items
• Items awaiting payment
• Items paid and awaiting shipment
• Items paid and shipped
• Archived items
• All Sold and Archived
Download an Active listings report
This section explains how to generate a report that shows all of your active listings.
There are several types of status-oriented reports, all of which can be downloaded using this procedure.
In this example, you will generate an inventory snapshot report following these steps:
1. Select Active Listings from the Listing and Records drop-down menu.
2. Type in the email address(es) you want the file sent to (it defaults to your registered email).
3. Click Save.
4. In the navigation bar, click Completed Downloads.The View Completed Downloads page provides
links to download the report(s) you just created.
The Active listings report, in .csv format, provides you a view of all your listings still selling on eBay.
(After a listing ends, it moves to the Sold or Unsold listings.) This file is in default list order by end date,
and with all Good Til Cancel Items listed at the end.
You can import this file into your inventory system and use the data in it to reconcile and manage your
inventory. An example file is shown below.
Figure 3: Active listings report
41Generating reports
File Exchange Advanced Template Instructions
For Active listings field descriptions, see Result and report fields on page 109.
Download a Sold items report
This section explains how to generate a report that shows your current sales.
There are several types of sales-oriented reports, all of which can be downloaded using this procedure.
In this example, you will generate a Sold items report.
1. Select Sold from the Listing and Records drop-down menu.
2. Type in the email address(es) you want the file sent to (it defaults to your registered email).
3. Click Save.
4. In the navigation bar, click Completed Downloads.The View Completed Downloads page provides
links to download the report(s) you just created.
The report you download provides a summary of the profits generated by each of your sold listings.
The data displayed is calculated based on stored product information, eBay fees, and the total revenue
generated by the sold listing.
The report contains the following:
• Buyer information
• Payment information
• Shipping information
• Sales information
• Cost information
• Listing information
• Feedback information
Note: For report field definitions, refer to Sold Listings report fields.
The figure below is a sample Sold Items report (in .csv format). The generated report and its data
fields or column headers will differ depending on the filter you select.
Figure 4: Sold items report
Create a download schedule
The Download Schedule page enables you to specify which reports will be automatically sent to you
by choosing one of these filters on the Listing and Records menu:
Generating reports42
File Exchange Advanced Template Instructions
• Sold items
• Items awaiting payment
• Items paid and awaiting shipment
• Items paid and awaiting shipment
• Archived items
• All Sold and Archived items
You can also use date ranges to control which data gets captured in a generated reports.
After selecting the options you want and entering your email address, click Save.
View download schedule
Figure 5:View Download schedule
This page shows the currently scheduled downloads, and allows you to edit or delete download
schedules.
43Generating reports
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 Catalogue template
listings, you will receive an error.
Supported TemplateseBay Site
CatalogueItem 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 information44
File Exchange Advanced Template Instructions
Supported TemplateseBay Site
CatalogueItem 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)
45Site 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 information46
File Exchange Advanced Template Instructions
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 India will have Currency=INR.Valid values are provided
in the table below.
Currency ValueCurrency Type
USDUS Dollar
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.
47Site and template information
File Exchange Advanced Template Instructions
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
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
Site and template information48
File Exchange Advanced Template Instructions
Region NameseBay Sites
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
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
49Site and template information
File Exchange Advanced Template Instructions
PMSaint Pierre and MiquelonILIsraelBMBermuda
VCSaint Vincent and the
Grenadines
ITItalyBTBhutan
SMSan MarinoJMJamaicaBOBolivia
SASaudi ArabiaSJJan MayenBABosnia and Herzegovina
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
Site and template information50
File Exchange Advanced Template Instructions
TMTurkmenistanMRMauritaniaDJDjibouti
TCTurks and Caicos IslandsMUMauritiusDMDominica
UGUgandaYTMayotteDODominican Republic
UAUkraineMXMexicoECEcuador
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
51Site and template information
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 53.
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 functions52
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
53Using 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|CC=UTF-8)
Overriding metadata values
Caution: ADVANCED USERS ONLY!
Using advanced functions54
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=India|Country=IN|Currency=INR|Version=745|CC=UTF-8|StartPrice=1.99)
55Using advanced functions
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 describes the fields you can use to tell us how to design your listing and the content they
contain.
For more information about adding these fields to your templates, see Enter data in the template fields
on page 20.
*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
Valid Entry
•
Add
•
Revise
•
Relist
•
End
•
Status
•
VerifyAdd
•
AddToItemDescription
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
Border
Specifies whether the item listing will have a border around it.
N/ACharacter limit
Template field definitions56
File Exchange Advanced Template Instructions
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
Using this field does not affect the item Subtitle, if any.Field Dependency
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 on page 57.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 on page 57.
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
57Template field definitions
File Exchange Advanced Template Instructions
Use this field with BuyerRequirements:MaxViolationPeriod on page 58.
Field Dependency
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.
N/ACharacter limit
IntegerType
Days_30, Days_180, or Days_360.The default value is Days_180.
Valid Entry
Use this field with BuyerRequirements:MaxUnpaidItemsCount on page 57.
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 (violations).
Valid Entry
Use this field with BuyerRequirements:MaxViolationPeriod on page 58.
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 on page 58.
Field Dependency
Template field definitions58
File Exchange Advanced Template Instructions
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
-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
Numeric ID of the Category where the item is to be listed.To get category IDs, download the Category
IDs file. After you open the file, if you sort the lines in a column, be certain to sort the whole table, not
just the one column.
Max length 10Character limit
IntegerType
Category number, like 1245 ( for Printers).
Valid Entry
Must use a valid eBay category number.Field Dependency
59Template field definitions
File Exchange Advanced Template Instructions
Category2
Numeric ID of an additional Category where the item is to be listed. To get category IDs, download
the Category IDs file. After you open the file, if you sort the lines in a column, be certain to sort the
whole table, not just the one column.
Max length 10Character limit
IntegerType
Category ID number, like 1245 (for Printers).
Valid Entry
Must use a valid eBay category number.Field Dependency
ConditionDescription
Use this field to describe the condition of a used item.
This field can be used in conjunction with *Description on page 63, which should be used to provide
non-condition details about an item. For instructions about using this field, see Using the Condition
fields on page 28.
1000 charactersCharacter limit
StringType
Descriptive text, such as:Valid Entry
"The right leg of the chair has a small scratch (see photo) and the back of the seat has
a light blue stain the shape and size of a silver dollar."
*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:Valid Entry
•
1000
•
1500
•
2000
•
2500
•
3000
•
4000
•
5000
•
6000
Template field definitions60
File Exchange Advanced Template Instructions
•
7000
To obtain the ConditionID value for a specific category, generate an Item Specifics
template.The generated template will contain the new ConditionID field as well as the
ConditionID numbers. Literal values are defined in the Item Specifics Definitions file that
accompanies the generated template.
To view the ConditionIDs for all categories, go to File Exchange Instructions and
Resources and click theConditionIDs by Category.
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
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.
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
• MPN (manufacturer part number)
• 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
61Template field definitions
File Exchange Advanced Template Instructions
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
Identifies the field (or fields) to remove from a listing. Multiple fields can be deleted at a time.To do
so, use the pipe character (|) to separate the field names. For example, Category2|Subtitle.
Only those fields noted in the table below can be deleted.
N/ACharacter limit
Text stringType
Valid Entry
•
Application Data
•
Attributes (deletes all A: attributes)
•
BoldTitle
•
BuyItNowPrice
•
Category2
•
Charity
•
ConditionID
•
CustomLabel
•
ItemSpecifics (deletes all C: item specifics)
•
Layout
•
MinimumBestOfferPrice
•
PayPalEmailAddress
•
PicURL
•
Product (deletes all product details)
•
ProPackBundle
•
ProPackPlusBundle
•
ValuePackBundle
•
Subtitle
•
Theme
Template field definitions62
File Exchange Advanced Template Instructions
*Description
Contains product information about the item. Include all relevant item and product specifications that
may be of interest to the buyer.
Note: You cannot use line breaks and carriage returns in this field. To insert multiple lines, use
the HTML <BR> and <P> tags to separate lines into paragraphs.
To provide information specific to the condition of an item, use ConditionDescription on page 60.
We provide a script to remove carriage returns, escape quotes, and to perform other necessary changes
to make the text in your Description field valid in File Exchange. To download the script as well as the
instructions for using it, see How to use the new File Exchange Item Description Utility.
Max length 500,000Character limit
Text stringType
Content to accurately and completely describe the item.Valid Entry
This field is optional for catalogue listings but is required for non-catalogue 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
Valid Entry
•
LostOrBroken
•
NotAvailable
•
Incorrect
63Template field definitions
File Exchange Advanced Template Instructions
•
OtherListingError
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 (up to 21 days in the future) by which an action must occur for a listing. For example,
if you want to Add a listing before a specific date, like for a sale item, File Exchange will process the
Add action up until the date and time specified in the FE:ListByDate field. After that date, File Exchange
will send a message stating "List by date has passed" and the item will not be listed.
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
Valid Entry
•
Auction (default)
•
FixedPrice
•
ClassifiedAd
•
RealEstateAd
Template field definitions64
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
Valid Entry
•
None (default)
•
Gallery
•
Plus
•
Featured
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
Valid Entry
•
NoHitCounter
•
HonestyStyle (US only)
•
GreenLED (US only)
•
Hidden
•
BasicStyle
•
RetroStyle
•
HiddenStyle
65Template field definitions
File Exchange Advanced Template Instructions
ItemID
When you upload a template, we automatically generate and assign a unique read-only ID to identify
each item (the value for ItemID cannot be changed or selected).
N/ACharacter limit
AlphanumericType
Contained in the Revision file or the Load Results report.Valid Entry
Required when revising, re-listing, and ending listings, and when checking status (by
entering Status in the Action field).
Field Dependency
*Location
Location of the item. Enter the State and Country information.
Max length 45Character limit
AlphanumericType
State and Country where the item is located (do not enter postal code).Valid Entry
If you use the PostalCode field, do not use the Location field.The location will be derived
from the postal code value.
Field Dependency
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
OutOfStockControl
When this field is set to true, the item is hidden from search when the quantity goes to 0 (zero), but
the listing is kept alive. This is useful for a seller who is waiting for additional stock of an item with the
same ItemID. Instead of ending the listing and then relisting it when the inventory drops to 0, you can
use this field to hide the listing.When you have the item available, you can upload a file Revise action
with a new quantity value to make the item available in search again. This only works for Fixed Price
listings that have a Good 'Til Cancelled (GTC) duration.
Template field definitions66
File Exchange Advanced Template Instructions
Important: Because an item is hidden the listing is still alive, the GTC automatic renewal will
continue every 30 days and the listing fees will be charged.This option is best suited for long
running items where inventory can be replaced in a short time.
Some factors to consider are:
• OutOfStockControl is set at the item level. So you can set this field for existing listings using a Revise
upload, and can include it in Add uploads.
• Once this field is set to true you cannot change it, nor do you need to. If you still have inventory,
the listing will be displayed in search results. When the quantity falls to zero, the listing will no longer
be displayed in search.To remove it, end the item, and relist it by setting the OutOfStockControl field
to false.
• When OutOfStockControl is set to true, you can set the quantity of the item to zero. When
OutOfStockControl is set to false you cannot set the quantity to zero.
• The OutOfStockControl field status only appears in the Active Download report, not the Revision file
download used to revise listings.
N/ACharacter limit
BooleanType
true or false Default is false.
Valid Entry
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
Text stringType
None (default), PicturePack, SuperSize.
Valid Entry
67Template field definitions
File Exchange Advanced Template Instructions
PicURL
URL of the picture 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.
Pictures can be self-hosted, hosted by a third party, or hosted by eBay Picture Services (EPS).To
add up to 12 pictures, separate the URL with a pipe " | " character.
Pictures for a listing can either self-hosted, or hosted by a third party, but not both.
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/images/item1.jpg|
http://hostedpics.com/images/item2.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
Valid postal code.Valid Entry
If the PostalCode field is used, the Location field should not be used because the location
of the item is derived from the postal code.
Field Dependency
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.
Max length 45Character limit
Template field definitions68
File Exchange Advanced Template Instructions
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
N/ACharacter limit
Text stringType
Valid Entry
•
Compatibility
•
Variation
Must accompany the RelationshipDetails on page 69 field.Field Dependency
RelationshipDetails
The equal sign (=) couples the name with a value.
N/ACharacter limit
Text stringType
Valid Entry
Must accompany the Relationship on page 69 field.Field Dependency
ScheduleTime
Use this field to schedule a listing to start at a specific time in the future (listings cannot be started in
the past).
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.
69Template field definitions
File Exchange Advanced Template Instructions
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 include:
Valid Entry
• 0=Not an eBay Store item
• 1=Other
• 2=Category A
• 3=Category B
• 4=Category Z
If you change the StoreCategory field value, include both StoreCategory and
StoreCategory2 fields in the template file you upload.
Field Dependency
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 include:
Valid Entry
• 0: Not an eBay Store item
• 1: Other
• 2: Category A
• 3: Category B
• 4: Category Z
If you change the StoreCategory field value, include both StoreCategory and
StoreCategory2 fields in the template file you upload.
Field Dependency
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
Template field definitions70
File Exchange Advanced Template Instructions
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 DeletedField=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-catalogue
listings and optional for catalogue listings.
Max length 80Character limit
Alphanumeric stringType
Keywords and item descriptors, such as product name and model, that buyers will use
when searching for an item.
Valid Entry
Packaging and handling fields
Explains the packaging, gift, and handling fields that determine how, when, and where the item is sent.
*DispatchTimeMax
Use this field to specify the maximum number of business days you take to prepare an item for shipment
to a domestic buyer once you receive a cleared payment.The value you enter for *DispatchTimeMax
does not include the duration of time needed to actually ship the item (the carrier's transit time) to the
buyer.
To specify:
• zero-day handling, enter 0 (zero)
• that an item is not shipped (for example, an item that is picked up locally), enter -1
N/ACharacter limit
IntegerType
Valid Entry
•
-1
•
0
•
1
•
2
•
3
•
4
•
5
•
10
•
15
•
20
71Template field definitions
File Exchange Advanced Template Instructions
•
30
*DispatchTimeMax is valid for Flat and Calculated shipping.You can enter a value for
*DispatchTimeMax even when you do not enter a value for shipping service costs.
Field Dependency
ExcludeShipToLocation
The best way to block bidders who reside (according to their eBay primary shipping address) in locations
to which you do not ship is to Exclude Shipping Locations on My eBay. We automatically apply the
settings to all your listings.
For individual listings, you can use ExcludeShipToLocation to override these default settings. For
example, though you normally exclude all bidders in North America, one of your items – an O'Neill
Reactor wetsuit for use in cold water – may appeal to buyers in Greenland and Saint Pierre and
Miquelon.
N/ACharacter limit
Text stringType
Enter the desired value as provided in Region names and country codes on page 47 –
for example, BM or CA
Valid Entry
Alternatively, to disable all default settings and allow buyers from all locations to bid on
or buy your item, enter None
To use this field, you must set ShipToRegistrationCountry on page 75 to 1
Field Dependency
You can use ExcludeShipToLocation to identify more than one location; be sure to insert a vertical
bar (|) to separate each excluded location. For example:
ShipToRegistrationCountryExcludeShipToLocationItemID
1CA|MX101100296
OrderID
An eBay-generated ID used to uniquely identify the transaction for a multiple item order.
N/ACharacter limit
IntegerType
Acquired from the Sold Listings report.Valid Entry
Using the OrderID number will place the tracking and paid status for the entire order. The table below
shows how the Sold Listings report shows the OrderID, which in this example, includes two items.
Transaction IDItem IDOrder IDUser IDSale Record Number
170377010019example7371
Template field definitions72
File Exchange Advanced Template Instructions
Transaction IDItem IDOrder IDUser IDSale Record Number
10268378580132311754968537371
9842895140143309646900077371
For a single item order, use TransactionID on page 75.
ShipmentTrackingNumber
The tracking number associated with an item.To obtain the tracking number, see the invoice or order
form provided by the shipping carrier.
N/ACharacter limit
Text stringType
A valid tracking number, typically provided on the invoice issued by the shipping carrier.Valid Entry
To use this field, you must also provide a value for ShippingCarrierUsed on page 73.Field Dependency
ShippedTime
Indicates the date and time at which an item was actually shipped.
If a template contains an empty instance of this field, we automatically enter the date and time at which
you uploaded the file. ShippedTime is displayed to both the buyer and the seller on their respective
My eBay pages.
You must enter the date and time in GMT ISO 8601 date and time format:
YYYY-MM-DDTHH:MM:SS.SSSZ
N/ACharacter limit
DateType
2013-05-28T22:09:23.000Z
Valid Entry
Do not enter a date or time in the future.
Use only with the Status action.
Field Dependency
ShippingCarrierUsed
The carrier used to ship an item.
N/ACharacter limit
Text stringType
73Template field definitions
File Exchange Advanced Template Instructions
Enter a valid shipping carrier name. For example, if ShippingService-X:Option is
UPSNextDay , enter UPS (do not enter the value you entered for
ShippingService-X:Option).
Valid Entry
For non-specific ShippingService-X:Option values such as ShippingMethodOvernight,
enter Other.
To use this field, you must also provide a value for ShipmentTrackingNumber on page
73.
Field 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 you revise this field – even when you know the information has not changed
– be sure to include specific field information for the listing in the uploaded file. For a list of fields
that must be included in a revised listing, see Revision-dependent fields on page 13.
N/ACharacter limit
Text stringType
Valid Entry
•
Flat (default)
•
FreightFlat
If you set this field to Flat or FreightFlat, you also must also provide field values
for ShippingService-X:Option and ShippingService-X:Cost.
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. Use this field to specify one or more ShipToLocations
destinations.
Template field definitions74
File Exchange Advanced Template Instructions
to separate options are used and one is set to None, all are ignored and a warning is returned.
This field differs from IntlShippingService-n:Locations, which you can use to define specific ship-to
locations for the respective international shipping service.
N/ACharacter limit
Text stringType
Valid Entry •
Worldwide
•
Americas
•
Europe
•
None
To enter more than one value, enter the respective ISO two-character country codes.
Use the pipe (|) character to separate the codes. For example:
AU|CA|MY
ShipToRegistrationCountry
Use this field to block bidders who reside (according to their primary eBay shipping address) in locations
to which you do not ship.
N/ACharacter limit
BooleanType
1 – the default value is 0 (false)
Valid Entry
This field is used with ExcludeShipToLocation on page 72 only. When used, it must be
set to 1 (true).
Field Dependency
TransactionID
An eBay-generated ID used to uniquely identify the transaction for a single item order.
N/ACharacter limit
IntegerType
Acquired from the Sold Listings report.Valid Entry
For a multiple item order, user OrderID on page 72.
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.
75Template field definitions
File Exchange Advanced Template Instructions
Note: If you opted in to Business policies on My eBay, you can skip the following content and
go to Using business policies on page 22 to set up and select payment and return policies.
For more information about using these fields, see Using the payment fields on page 32.
AdditionalDetails
Provides detailed explanation of your return policy.
Max 5000 charactersCharacter limit
Text stringType
User inputValid Entry
The *ReturnsAcceptedOption on page 80 field is required when you use this field.Field Dependency
CashOnPickup
Do you allow a customer to pay for an item when they pick it up? Specifies whether Cash on Pickup
is an acceptable payment option.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
HolidayReturns
If added to your return policy, buyers who purchase items on or after November 1, 2014 have until
January 31, 2015 to return the item.The extended holiday returns period is defined by three dates:
• The start date - November 1
• The purchase cutoff date - December 31
• The end date - January 31
N/ACharacter limit
BooleanType
1 = true, 0 = false
Valid Entry
To use this option, add it to your return business policy, or add a column to your listing template, and
use HolidayReturns as the column header name and 1 for the value.
Template field definitions76
File Exchange Advanced Template Instructions
ImmediatePayRequired
Indicates that immediate payment is required from the buyer. This field is used to require that an item
be paid for before it is considered closed and purchased.This field is supported for Premier and
Business PayPal accounts only.
For more information, see Requiring immediate payment.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
#unique_249 must be set to 1 (true).
Field Dependency
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
PaisaPayAccepted
Do you accept PaisaPay as a payment service? Specifies whether or not PaisaPay is accepted as
payment.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
PaisaPayEscrow
Do you accept PaisaPay as a payment service? Specifies whether or not PaisaPay is accepted as
payment.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
77Template field definitions
File Exchange Advanced Template Instructions
PaisaPayEscrowEMI
Do you accept PaisaPay Equated Monthly Installment (EMI) as an installment plan payment service?
Specifies whether or not PaisaPay EMI is accepted 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
PaymentProfileName
To use a payment business policy in a listing, you must first opt in to Business policies with your eBay
account and then specify the payment options for each policy in your Site Preferences on My eBay.
For more information, see Manage Business policies.
The PaymentProfileName field identifies the payment business policy to use in the listing. Since policy
names are case-sensitive, be sure to enter the policy name exactly as it appears in Site Preferences
on My eBay.
Maximum length of 50 charactersCharacter limit
TextType
Must be an existing and valid payment policy as defined in your Site Preferences on
My eBay. For example, CashOnly
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
Template field definitions78
File Exchange Advanced Template Instructions
PaymentStatus
Do you show buyers when a payment has been received? Specifies whether or not the item has been
paid for.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0.
Valid Entry
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.
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
Valid Entry
•
MerchandiseCredit
•
MoneyBack
*ReturnsAcceptedOption on page 80 must be set to ReturnsAccepted.
Field Dependency
79Template field definitions
File Exchange Advanced Template Instructions
ReturnProfileName
To use a return business policy in a listing, you must first opt in to Business policies for your eBay
account and then specify the return options for each policy in your Site Preferences. For more
information, see Manage Business policies.
The ReturnProfileName field specifies which return business policy to use in the listing. Since policy
name values are case-sensitive, be sure to enter the policy name exactly as it appears in Site
Preferences on My eBay.
Maximum length of 50 charactersCharacter limit
TextType
Must be a valid return policy already defined in your Site Preferences on My eBay. For
example, ExchangeOnly
Valid Entry
*ReturnsAcceptedOption
Indicates that a buyer can return the item.
N/ACharacter limit
Text stringType
Valid Entry
•
ReturnsAccepted
•
ReturnsNotAccepted
ReturnsWithinOption
Defines the length of time a buyer has in which to notify you of their intent to return an item.
N/ACharacter limit
Text stringType
Valid Entry
•
Days_14
•
•
Days_60
*ReturnsAcceptedOption on page 80 must be set to ReturnsAccepted.
Field Dependency
ShippingCostPaidByOption
Specifies who pays to return the item.
N/ACharacter limit
Text stringType
Template field definitions80
File Exchange Advanced Template Instructions
Valid Entry
•
Buyer – Buyer pays to return the item
*ReturnsAcceptedOption on page 80 must be set to ReturnsAccepted.
Field Dependency
WarrantyDuration
Specifies how long warranties are honored. Available in IN only.
N/ACharacter limit
Text stringType
Months_1, Months_3, Months_6, Years_1, Years_2,Years_3,
Years_MoreThan3. (Default is Months_6)
Valid Entry
The WarrantyOffered field is required when you use this field.Field Dependency
WarrantyOffered
Do you offer warranties in your product listings? Specifies whether or not the product manufacturer
offers warranties for the item purchased. Available in IN only.
N/ACharacter limit
Text stringType
WarrantyOffered, None (Default is None).
Valid Entry
The WarrantyType and WarrantyDuration fields are required when you use this field.Field Dependency
WarrantyType
Specifies the warranty options. Available in IN only.
N/ACharacter limit
Text stringType
ReplacementWarranty, DealerWarranty,
ManufacturerWarranty (Default is DealerWarranty)
Valid Entry
The WarrantyOffered field is required when you use this field.Field Dependency
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 #unique_250.
81Template field definitions
File Exchange Advanced Template Instructions
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
47.
InternationalPromotionalShippingDiscount
Applies a promotional shipping discount to the international shipping fee paid for by the buyer.
Important: When you revise this field – even when you know the information has not changed
– be sure to include specific field information for the listing in the uploaded file. For a list of fields
that must be included in a revised listing, see Revision-dependent fields on page 13.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0. Must be a valid rule created in your eBay account
under Shipping Preferences.
Valid Entry
Before you can use this field, you must have already created promotional shipping rules.
For more information, see Promotional Shipping Rules.
Field Dependency
InternationalShippingDiscountProfileID
The numeric ID of the shipping discount profile we use to calculate shipping for combined international
purchases.
Template field definitions82
File Exchange Advanced Template Instructions
Use this field to specify that a shipping discount be applied to an item when an item in a transaction
is combined with another item (or items) by the buyer into a Combined Payment order. If you don't
enter a value in this field, we use the default profile defined by your My eBay shipping preferences.
For details, see Using Combined Payments and About Shipping Discounts.
To locate your shipping profile ID numbers, go to My eBay > Account > Site Preferences > Shipping
Preferences > Show > Offer combined payments and shipping > Edit. Shipping profile ID numbers
are listed on the My eBay: Combined Payments and Shipping Discounts page.
Important: When you revise this field – even when you know the information has not changed
– be sure to include specific field information for the listing in the uploaded file. For a list of fields
that must be included in a revised listing, see Revision-dependent fields on page 13.
N/ACharacter limit
IntegerType
Numeric ID. For example, enter 71808543. Be sure this integer refers to a valid rule
created in your eBay account for Shipping Preferences.
Valid Entry
To use this field, you must create at least one valid shipping rule profile on your My eBay
Shipping Preferences page.
Field Dependency
PromotionalShippingDiscount
Applies a promotional shipping discount to the cost of domestic shipping paid for by the buyer.
Important: When you revise this field – even when you know the information has not changed
– be sure to include specific field information for the listing in the uploaded file. For a list of fields
that must be included in a revised listing, see Revision-dependent fields on page 13.
N/ACharacter limit
BooleanType
0 or 1 (0=false, 1=true) Default is 0. Must be a valid rule created in your eBay account
under Shipping Preferences.
Valid Entry
Before you can use this field, you must have already created promotional shipping rules.
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
CurrencyType
Numeric amount, like 10.00, 49.99, 100.00.
Valid Entry
83Template field definitions
File Exchange Advanced Template Instructions
ShippingDiscountProfileID
The numeric ID of the shipping discount profile we use to calculate domestic shipping costs for the
buyer.
Use this field to specify that a shipping discount be applied to an item when an item in a transaction
is combined with another item (or items) by the buyer into a Combined Payment order. If you don't
enter a value in this field, we use the default profile defined by your My eBay shipping preferences.
For details, see Using Combined Payments and About Shipping Discounts.
To locate your shipping profile ID numbers, go to My eBay > Account > Site Preferences > Shipping
Preferences > Show > Offer combined payments and shipping > Edit. Shipping profile ID numbers
are listed on the My eBay: Combined Payments and Shipping Discounts page.
Important: When you revise this field – even when you know the information has not changed
– be sure to include specific field information for the listing in the uploaded file. For a list of fields
that must be included in a revised listing, see Revision-dependent fields on page 13.
N/ACharacter limit
IntegerType
Numeric ID. For example, 780385439. Be sure this integer refers to a valid rule
created in your eBay account for Shipping Preferences.
Valid Entry
To use this field, you must create at least one valid shipping rule profile on your My eBay
Shipping Preferences page.
Field Dependency
*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
a value for ShippingInTax.
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
Template field definitions84
File Exchange Advanced Template Instructions
to the presence of the column header.Value implies the field is present, and input (a value) is required
for that field.
For more information about using these fields, see Specifying payments, shipping, and returns on
page 32.
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.
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 on page 85, 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 on page 85.
N/ACharacter limit
CurrencyType
Numeric amount, like 3.99.
Valid Entry
Field Dependency
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 86.Field Dependency
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 47.
N/ACharacter limit
85Template field definitions
File Exchange Advanced Template Instructions
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
Must be a valid service option value.Valid Entry
For valid service option values, refer to Shipping services field values on page 95.
Must be accompanied by IntlShippingService-1:Cost on page 85.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 on page 87, 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 on page
87 amount.
Template field definitions86
File Exchange Advanced Template Instructions
N/ACharacter limit
CurrencyType
Numeric amount, like 3.99.
Valid Entry
Field Dependency
IntlShippingService-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
Must accompany IntlShippingService-2:Option on page 87.Field Dependency
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 47.
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.Valid Entry
For valid service option values, refer to Shipping services field values on page 95.
Must be accompanied by IntlShippingService-2:Cost on page 87.
Field Dependency
87Template field definitions
File Exchange Advanced Template Instructions
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
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 by
IntlShippingService-3:Cost on page 88, 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 amount entered into
IntlShippingService-3:Cost on page 88.
N/ACharacter limit
CurrencyType
Numeric amount, like 3.99.
Valid Entry
Field Dependency
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 on page 89.Field Dependency
Template field definitions88
File Exchange Advanced Template Instructions
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 47.
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-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.Valid Entry
For valid service option values, refer to Shipping services field values on page 95.
Must be accompanied by IntlShippingService-3:Cost on page 88.
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
89Template field definitions
File Exchange Advanced Template Instructions
ShippingProfileName
To use a postage business policy in a listing, you must first opt in to Business policies with your eBay
account and then specify the postage options for each policy in your Site Preferences on My eBay.
For more information, see Business policies.
The ShippingProfileName field specifies which postage business policy to use in the listing. Since
policy name values are case-sensitive, be sure to enter the postage policy name exactly as it appears
in Site Preferences on My eBay.
Maximum length of 50 charactersCharacter limit
TextType
Must be one of the predefined shipping policies in your Site Preferences on My eBay.
For example, ShippingPolicy1
Valid Entry
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
CurrencyType
Numeric amount, such as 3.99
Valid Entry
Do not provide a value when:Field Dependency
• ShippingService-1:FreeShipping=1
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 91 regardless of whether
ShippingService-1:FreeShipping on page 91 contains a value or not.
Field Dependency
Do not enter a value when ShippingService-1:FreeShipping=1 for domestic services.
Template field definitions90
File Exchange Advanced Template Instructions
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 that can be selected by the buyer.
N/ACharacter limit
Text stringType
Must be a valid service option value.Valid Entry
For valid service option values, refer to Shipping services field values on page 95.
Must be accompanied by ShippingService-1:Cost on page 90.
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
91Template field definitions
File Exchange Advanced Template Instructions
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, we automatically apply the surcharge when UPS is used to
ship items.
N/ACharacter limit
CurrencyType
Numeric amount, such as 3.99.
Valid Entry
To avoid a surcharge, leave this field blank. 0.00 is an invalid value.
Field Dependency
ShippingService-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 item ships with the price specified in
ShippingService-2:Cost on page 92, 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 amount entered into
ShippingService-2:Cost on page 92.
N/ACharacter limit
CurrencyType
Numeric amount, such as 3.99
Valid Entry
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 92.Field Dependency
ShippingService-2:Option
A domestic shipping service that can be selected by the buyer.
N/ACharacter limit
Text stringType
Template field definitions92
File Exchange Advanced Template Instructions
Must be a valid service option value.Valid Entry
For valid service option values, refer to Shipping services field values on page 95.
Must be accompanied by ShippingService-2:Cost on page 92.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
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, we automatically apply the surcharge when UPS is used to
ship items.
N/ACharacter limit
CurrencyType
Numeric amount, such as 3.99.
Valid Entry
To avoid a surcharge, leave this field blank. 0.00 is an invalid 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 on page 94, 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 on page 94
amount.
93Template field definitions
File Exchange Advanced Template Instructions
N/ACharacter limit
CurrencyType
Numeric amount, such as 3.99
Valid Entry
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 on page 94.Field Dependency
This field must accompany ShippingService-3:Option.
ShippingService-3:Option
A domestic shipping service that can be selected by the buyer.
N/ACharacter limit
Text stringType
Must be a valid service option value.Valid Entry
For valid service option values, refer to Shipping services field values on page 95.
Must be accompanied by ShippingService-3:Cost on page 94.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
Template field definitions94
File Exchange Advanced Template Instructions
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, we automatically apply the surcharge when UPS is used to
ship items.
N/ACharacter limit
CurrencyType
Numeric amount, such as 3.99.
Valid Entry
To avoid a surcharge, leave this field blank. 0.00 is an invalid value.
Field Dependency
*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 you revise this field – even when you know the information has not changed
– be sure to include specific field information for the listing in the uploaded file. For a list of fields
that must be included in a revised listing, see Revision-dependent fields on page 13.
N/ACharacter limit
Text stringType
Valid Entry
•
Flat (default)
•
FreightFlat
If you set this field to Flat or FreightFlat, you also must also provide field values
for ShippingService-X:Option and ShippingService-X:Cost.
Field Dependency
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.
95Template field definitions
File Exchange Advanced Template Instructions
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
AU_ExpeditedDeliveryFromOutsideAU
AU_StandardDeliveryFromOutsideAU
AU_Courier
AU_Pickup
AU_StarTrackExpress
Austria services options
The field values below are for the ShippingService-n:Option field that specifies the shipping services
used in Austria.
Template field definitions96
File Exchange Advanced Template Instructions
International servicesDomestic services
AT_EconomyDeliveryFromAbroadAT_COD
AT_ExpressDeliveryFromAbroadAT_ExpressOrCourier
AT_SonstigerVersandInternationalAT_InsuredDispatch
AT_StandardDeliveryFromAbroadAT_InsuredExpressOrCourier
AT_TrackedDeliveryFromAbroadAT_InsuredSpecialDispatch
AT_UnversicherterExpressVersandInternationalAT_Pickup
AT_UnversicherterVersandInternationalAT_Sonstige
AT_VersicherterExpressVersandInternationalAT_SpecialDispatch
AT_VersicherterVersandInternationalAT_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_EconomyDeliveryFromAbroadBEFR_LaPosteStandardShipping
BEFR_ExpressDeliveryFromAbroadBEFR_LaPosteTaxipost24h
BEFR_FedExInternationalBEFR_LaPosteTaxipostLLS
BEFR_LaPosteInternationalBEFR_LaPosteTaxipostSecur
BEFR_LivraisonSecuriseBEFR_LivraisonSecurise
BEFR_OtherInternationalBEFR_OtherShippingMethods
BEFR_PostInternationalRegisteredBEFR_Pickup
BEFR_PostInternationalStandardBEFR_PointRetraitKiala
BEFR_StandardDeliveryFromAbroad
BEFR_TNTInternational
BEFR_TrackedDeliveryFromAbroad
BEFR_UPSInternational
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_EconomyDeliveryFromAbroadBENL_DePostStandardShipping
97Template field definitions
File Exchange Advanced Template Instructions
International servicesDomestic services
BENL_ExpressDeliveryFromAbroadBENL_DePostTaxipost24h
BENL_FedExInternationalBENL_DePostTaxipostLLS
BENL_LaPosteInternationalBENL_DePostTaxipostSecur
BENL_OtherInternationalBENL_KialaAfhaalpunt
BENL_PostInternationalRegisteredBENL_OtherShippingMethods
BENL_PostInternationalStandardBENL_Pickup
BENL_StandardDeliveryFromAbroadBENL_VerzekerdeVerzending
BENL_TNTInternational
BENL_TrackedDeliveryFromAbroad
BENL_UPSInternational
BENL_VerzekerdeVerzendingInternational
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_CanadaPostPriorityNextAM
CA_PostExpeditedParcelUSACA_EconomyShipping
CA_PostInternationalLetterPostCA_EconomyShippingfromoutsideCanada
CA_PostInternationalParcelAirCA_ExpressShipping
CA_PostInternationalParcelSurfaceCA_ExpeditedShippingfromoutsideCanada
CA_PostLightPacketInternationalCA_Pickup
CA_PostLightPacketUSACA_PostExpeditedParcel
CA_PostSmallPacketsUSAAirCA_PostLettermail
CA_PostSmallPacketsUSAGroundCA_PostPriorityCourier
CA_PostUSALetterPostCA_PostRegularParcel
CA_PostTrackedPacketsUSACA_PostXpresspost
CA_PostTrackedPacketsInternationalCA_StandardShipping
CA_PostXpresspostInternationalCA_StandardShippingfromoutsideCanada
CA_PostXpresspostUSACA_UPSExpeditedCanada
CA_PriorityWorldwideCA_UPSExpressCanada
CA_SmallPacketsInternationalAirCA_UPSExpressSaverCanada
CA_SmallPacketsInternationalGroundCA_UPSStandardCanada
CA_StandardInternational
CA_UPS3DaySelectUnitedStates
CA_UPSExpeditedUnitedStates
Template field definitions98
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.
99Template 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_Chrono13
FR_DHLInternationalFR_Chronopost
FR_EconomyDeliveryFromAbroadFR_ChronopostChronoRelais
FR_ExpeditedInternationalFR_ColiposteColissimo
FR_ExpressDeliveryFromAbroadFR_ColiposteColissimoRecommended
FR_LaPosteColisEconomiqueInternationalFR_Ecopli
FR_LaPosteColissimoEmballageInternationalFR_KIALA_DELIVERY
FR_LaPosteColissimoInternationalFR_LaPosteLetterMax
FR_LaPosteInternationalEconomyCourierFR_LivraisonDansLesDomTom
FR_LaPosteInternationalPriorityCourierFR_LivraisonEnRelaisMondialRelay
FR_OtherInternationalFR_PostOfficeLetter
FR_StandardDeliveryFromAbroadFR_PostOfficeLetterFollowed
FR_StandardInternationalFR_PostOfficeLetterRecommended
FR_TrackedDeliveryFromAbroadFR_RemiseEnMainPropre
FR_UPSExpressInternationalFR_UPSStandardAgainstRefund
FR_UPSStandardInternationalPromotionalShippingMethod
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
DE_DHLPackchenInternationalDE_DHLPaket
Template field definitions100
File Exchange Advanced Template Instructions
International servicesDomestic services
DE_DHLPaketInternationalDE_DPBuecherWarensendung
DE_ExpressInternationalDE_DPDClassic
DE_ExpressversandAusDemAuslandDE_DPDExpress
DE_HermesPaketInternationalDE_DeutschePostBrief
DE_IloxxTransportInternationalDE_eBayHermesPaketShop2ShopKaeufer
DE_PaketInternationalDE_Einschreiben
DE_SonstigeInternationalDE_eBayHermesPaketSperrgutShop2Shop
DE_SparversandAusDemAuslandDE_Express
DE_StandardversandAusDemAuslandDE_GLSPaket
DE_TrackedDeliveryFromAbroadDE_HermesPaket
DE_HermesPackchen
DE_HermesPaketSperrgut
DE_IloxxTransport
DE_Nachname
DE_Paket
DE_Pickup
DE_SonstigeDomestic
DE_SpecialDelivery
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
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
101Template field definitions
File Exchange Advanced Template Instructions
International servicesDomestic services
IE_EconomyDeliveryFromAbroadIE_EconomySDSCourier
IE_EconomySDSCourierInternationalIE_EMSSDSCourier
IE_ExpressDeliveryFromAbroadIE_FirstClassLetterService
IE_EMSSDSCourierInternationalIE_OtherCourier
IE_InternationalEconomyServiceIE_RegisteredPost
IE_InternationalPriorityServiceIE_SellersStandardRate
IE_OtherCourierInternationalIE_SwiftPostNational
IE_SellersStandardRateInternational
IE_SellersStandardRateInternational
IE_StandardDeliveryFromAbroad
IE_SwiftPostExpressInternational
IE_SwiftPostInternational
IE_SwiftPostInternational
IE_TrackedDeliveryFromAbroad
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_EconomyDeliveryFromAbroad
IT_ExpressMailServiceIT_ExpressDeliveryFromAbroad
IT_PaccocelereInternazionaleIT_ExpressMailExpressCourier 1
IT_PaccoOrdinarioEsteroIT_DHLExpress
IT_PostaAssicurataInternazionaleIT_InsuredMail
IT_PostaPrioritariaInternazionaleIT_IoInvio
Template field definitions102
File Exchange Advanced Template Instructions
International servicesDomestic services
IT_PostaRaccomandataInternazionaleIT_MailRegisteredLetter
IT_OtherInternationalIT_Other48hrCourier
IT_StandardInternationalIT_OtherCourier3To5Days
PromotionalShippingMethodIT_Pickup
IT_PriorityMail
IT_QuickPackage1
IT_QuickPackage3
IT_RegularPackage
IT_StandardDeliveryFromAbroad
IT_TrackedDeliveryFromAbroad
PromotionalShippingMethod
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_EconomyDeliveryFromAbroadNL_Pickup
NL_ExpeditedInternationalNL_RegisteredMail
NL_ExpressDeliveryFromAbroadNL_StandardDelivery
NL_FedExInternational
NL_GLSBusinessInternational
NL_OtherInternational
NL_StandardInternational
NL_StandardDeliveryFromAbroad
103Template field definitions
File Exchange Advanced Template Instructions
International servicesDomestic services
NL_TPGPostTNTInternational
NL_TrackedDeliveryFromAbroad
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.
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_EconomyDeliveryFromAbroadPL_DomesticSpecial
PL_ExpressDeliveryFromAbroad
PL_InternationalRegular
PL_InternationalSpecial
PL_StandardDeliveryFromAbroad
PL_TrackedDeliveryFromAbroad
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
Template field definitions104
File Exchange Advanced Template Instructions
International servicesDomestic services
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_CartasInternacionalesDeMas20ES_CartasNacionalesDeMas20
ES_CartasInternacionalesHasta20ES_CartasNacionalesHasta20
ES_CartasPostalInternationalES_CorreosCartasCertificadas
ES_EconomyPacketInternationalES_CorreosCartasCertificadasUrgentes
ES_EmsPostalExpressInternationalES_CorreosChronoexpres
ES_ExpeditedInternationalES_CorreosPostal4872
ES_OtherInternationalES_EconomyDeliveryFromAbroad
ES_StandardInternationalES_ENTREGA_KIALA_8KG
ES_EntregaEnNacexShop
ES_EnvioEstandarAIslasBalearesCeutaMelilla
ES_EnvioEstandarALasIslasCanarias
ES_ExpressDeliveryFromAbroad
ES_NacexPluspackPlusbag
ES_NacexSiguienteDiaLaborable
ES_OtroCourier48Horas
ES_Otros
ES_PaqueteAzulDeMas2kg
ES_PaqueteAzulHasta2kg
ES_PaqueteInternacionalEconomico
ES_Pickup
ES_StandardDeliveryFromAbroad
ES_TrackedDeliveryFromAbroad
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_EconomyDeliveryFromAbroadCH_COD
105Template field definitions
File Exchange Advanced Template Instructions
International servicesDomestic services
CH_ExpressDeliveryFromAbroadCH_ExpressOrCourier
CH_EconomySendungenInternationalCH_InsuredDispatch
CH_PrioritySendungenInternationalCH_InsuredExpressOrCourier
CH_SonstigerVersandInternationalCH_InsuredSpecialDispatch
CH_StandardDeliveryFromAbroadCH_Pickup
CH_TrackedDeliveryFromAbroadCH_Sonstige
CH_UrgentSendungenInternationalCH_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
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_CollectInPersonInternationalStandardDeliveryfromOutsideUKwithRoyalMail
UK_OtherCourierOrDeliveryInternationalUK_CollectPlusStandard
UK_ParcelForceEuro48InternationalUK_CollectPlusTrakedDeliveryToDoor
Template field definitions106
File Exchange Advanced Template Instructions
International servicesDomestic services
UK_ParcelForceInternationalDatapostUK_EconomyShippingFromOutside
UK_ParcelForceInternationalScheduledUK_ExpeditedShippingFromOutside
UK_ParcelForceIreland24InternationalUK_FedExIntlEconomy
UK_RoyalMailAirmailInternationalUK_myHermesDoorToDoorService
UK_RoyalMailAirsureInternationalUK_OtherCourier
UK_RoyalMailHMForcesMailInternationalUK_OtherCourier24
UK_RoyalMailInternationalSignedForUK_OtherCourier3Days
UK_RoyalMailSurfaceMailInternationalUK_OtherCourier48
UK_SellersStandardInternationalRateUK_OtherCourier5Days
UK_Parcelforce24
UK_Parcelforce48
UK_RoyalMail24
UK_RoyalMail48
UK_RoyalMailFirstClassStandard
UK_RoyalMailNextDay
UK_RoyalMailSecondClassRecorded
UK_RoyalMailSecondClassStandard
UK_RoyalMailSpecialDelivery9am
UK_RoyalMailSpecialDeliveryNextDay
UK_RoyalMailTracked
UK_SellersStandardRate
UK_StandardShippingFromOutside
UK_TntIntlExp
UK_TrackedDeliveryFromAbroad
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
FedExGroundInternationalToCanadaExpeditedShippingFromOutsideUS
FedExInternationalEconomyePacketChina
FedExInternationalPriorityePacketHongKong
OtherInternationalFedEx2Day
StandardInternationalFedExExpressSaver
107Template field definitions
File Exchange Advanced Template Instructions
International servicesDomestic services
UPSStandardToCanadaFedExHomeDelivery
UPSWorldWideExpeditedFedExPriorityOvernight
UPSWorldWideExpressFedExStandardOvernight
UPSWorldWideExpressPlusOther
UPSWorldwideSaverPickup
USPSExpressMailInternationalShippingMethodExpress
USPSExpressMailInternationalFlatRateEnvelopeShippingMethodOvernight
USPSExpressMailInternationalLegalFlatRateEnvelopeShippingMethodStandard
USPSFirstClassMailInternationalStandardShippingFromOutsideUS
USPSPriorityMailInternationalUPS2ndDay
USPSPriorityMailInternationalFlatRateBoxUPS3rdDay
USPSPriorityMailInternationalFlatRateEnvelopeUPSGround
USPSPriorityMailInternationalLargeFlatRateBoxUPSNextDay (for UPS Next Day Air Saver service)
USPSPriorityMailInternationalLegalFlatRateEnvelopeUPSNextDayAir
USPSPriorityMailInternationalPaddedFlatRateEnvelopeUSPSExpressFlatRateEnvelope
USPSPriorityMailInternationalSmallFlatRateBoxUSPSExpressMail
USPSExpressMailLegalFlatRateEnvelope
USPSFirstClass
USPSMedia
USPSParcel
USPSPriority
USPSPriorityFlatRateBox
USPSPriorityFlatRateEnvelope
USPSPriorityMailLargeFlatRateBox
USPSPriorityMailLegalFlatRateEnvelope
USPSPriorityMailPaddedFlatRateEnvelope
USPSPriorityMailSmallFlatRateBox
USPSStandardPost
Template field definitions108
File Exchange Advanced Template Instructions
Result and report fields
Explains the field definitions used for upload results and various reports.
About report scripts
To extract specific data from the reports described in this chapter, it is possible to write scripts to search
for and extract only the data you want to view.
If you write such scripts, please search for the column name (such as Title or Price) instead of the
column number (such as 1, 2, or 11).When your scripts search for and extract column titles instead
of column numbers, your scripts will continue to work when we add or remove columns from the reports.
On the other hand, if you write scripts to extract column numbers (instead of column titles), there is a
high probability we will inadvertently break your scripts when we add or remove columns from the
reports.
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
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-13 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
Specifies whether OutOfStockControl is set to true or false.OutOfStockControl
One of the following. For:Price
109Result and report fields
File Exchange Advanced Template Instructions
Active Listings Report Fields
DescriptionField Name
• 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 Shop 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 type of RelationshipDetails, either Variation or Compatibility.Relationship
Name and value pairs that define the Variation or Compatibility types.RelationshipDetails
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.
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
State in which the buyer resides.Buyer State
ZIP code or postal code for the area in which the buyer resides.Buyer Zip
Result and report fields110
File Exchange Advanced Template Instructions
Awaiting Payment Report Fields
DescriptionField Name
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 postage 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 post the item.Shipping and Handling
The means by which an item is shipped.Shipping Service
Site on which the item was sold (for example, eBay, Half.com, or eBay World of Good).Sold On
Total cost of the item, including P&P.Total Price
Numeric ID for a single transaction.Transaction ID
User ID of the buyer.User Id
111Result and report fields
File Exchange Advanced Template Instructions
Awaiting Payment Report Fields
DescriptionField Name
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
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
Result and report fields112
File Exchange Advanced Template Instructions
Load Response Results 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
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 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
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
Universal Product Codes (UPC), International Standard Book Numbers (ISBN), European Article
Numbers (EAN), and so on. For more information about these product identifiers, see Using product
identifiers.
Note: The Global Trade Item Number report now includes variations information.
113Result and report fields
File Exchange Advanced Template Instructions
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/A885909459858327095898004
EPID14309738MC774LL/A0885909464845885909457625280724702242
010-00718-20753759077600400752507118
EPID097314384460B003452426640795250924892746
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 the entire value.
To do so, move the cursor to the ItemID column, click the right-mouse button and select Format
Cells. In the Format Cells window under Category, select Number. Set Decimal Places to 0 (zero)
and, finally, click OK.
Revising Active listings to include product identifiers using the GTIN
report
Perform the previous procedure first to get a file that contains all of your active listings, then you can
add product identifiers for each product. After formatting the ItemID so the complete number displays,
follow these steps.
1. For each product, enter a product identifier in the appropriate field. Each product only needs one
identifier. For more information about product identifiers, refer to product codes.
2. After the product identifiers have been entered, remove the Country and Currency information from
the Action field metadata. For example, change
*Action(SiteID=US|Country=US|Currency=USD|Version=745) to
*Action(SiteID=US|Version=745).
Important: Make sure the SiteID value is for the eBay site where your listings appear.
3. When you are done, upload this file to update your active listings with the required product identifiers.
Result and report fields114
File Exchange Advanced Template Instructions
Understanding the Global Trade Item Number report fields
The following table describes the fields in the Global Trade Item Number report:
Note: The Global Trade Item Number report now includes variations information.
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).
Indicates whether the relationship details field is for variations or compatibilityRelationship
Specifies the variation or compatibility information for the productRelationshipDetails
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
Brand name of the item.Product:Brand
Manufacturer's Part Number (MPN) of the item.Product:MPN
eBay Product ID (EPID) of the item.Product:EPID
Indicates that the listing contains pre-filled information.Product:IncludePreFilledInformation
Indicates if a stock photo is included in the listing.Product:IncludeStockPhotoURL
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
115Result and report fields
File Exchange Advanced Template Instructions
Paid and Awaiting Shipment Report Fields
DescriptionField Name
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
The unique identifier of an order shipped in the Global Shipping Program. eBay generates
this value when the order is complete. The international shipping provider uses the
Global Shipping Reference ID
Product:EPID as the primary reference when processing the shipment. Sellers must
include this value on the package immediately above the street address of the
international shipping provider.
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 postage 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 post the item.Shipping and Handling
Result and report fields116
File Exchange Advanced Template Instructions
Paid and Awaiting Shipment Report Fields
DescriptionField Name
The means by which an item is shipped.Shipping Service
Site on which the item was sold (for example, eBay, Half.com, or eBay World of Good).Sold On
Total cost of the item, including P&P.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.
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
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
117Result and report fields
File Exchange Advanced Template Instructions
Paid and Shipped Items Report Fields
DescriptionField Name
The unique identifier of an order shipped in the Global Shipping Program. eBay generates
this value when the order is complete. The international shipping provider uses the
Global Shipping Reference ID
Product:EPID as the primary reference when processing the shipment. Sellers must include
this value on the package immediately above the street address of the international shipping
provider.
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 postage 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 post the item.Shipping and Handling
The means by which an item is shipped.Shipping Service
Site on which the item was sold (for example, eBay, Half.com, or eBay World of Good).Sold On
Total cost of the item, including P&P.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
Result and report fields118
File Exchange Advanced Template Instructions
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
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
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
119Result and report fields
File Exchange Advanced Template Instructions
Sold Listings Report Fields
DescriptionField Name
Indicates that the feedback was received from the buyer.Feedback Received
The unique identifier of an order shipped in the Global Shipping Program. eBay generates
this value when the order is complete. The international shipping provider uses the
Global Shipping Reference ID
Product:EPID as the primary reference when processing the shipment. Sellers must
include this value on the package immediately above the street address of the international
shipping provider.
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 postage 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 post the item.Shipping and Handling
The means by which an item is shipped.Shipping Service
Site on which the item was sold (for example, eBay, Half.com, or eBay World of Good).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 P&P.Total Price
Result and report fields120
File Exchange Advanced Template Instructions
Sold Listings Report Fields
DescriptionField Name
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-13 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
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
121Result and report fields
File Exchange Advanced Template Instructions
Unsold Items Report Fields
DescriptionField Name
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
Result and report fields122
File Exchange Advanced Template Instructions
Index
A
Action field 20
Action field definition 56
Action values
excess fields 17
Info 15
using multiple 17
action-specific required fields 16
active listings report 41
Active Listings report fields 109
Add action 12
adding fields
conditionID 28
custom item specifics 27
payment information 32
return policy information 34
shipment tracking numbers 34
shipping discounts 33
adding new fields
custom item specifics 27
general 18
shipping discount 33
AddToItemDescription action 12
API compatibility level 47
archived items report 41
auction fees 20
Australia shipping services option field values 95
austria shipping services option field values 96
awaiting payment items report 41
Awaiting Payment report fields 110
B
belgium (dutch) shipping services option field values 97
belgium (french) shipping services option field values 97
best offer fields 81
Business policies 22
payment 22
return 22
shipping 22
buyer requirements 30
C
Canada (French) shipping services option field values
99
canada shipping services option field values 98
case-sensitivity 11
catalog-supported sites 44
category, store numbers 29
cell information 54
character
limits 11
types 11
china shipping services option field values 99
combined payments 33
conditionID 28
cost fields 81
country codes 49
create download request 41
create download schedule 42
credit card fields 75
currency 47
Customer Support 36
CustomLabel, variation 23
D
data
entering 20
deleting a field
general info 18
deleting multiple field values
general info 19
Description field 20
design fields 56
dimension fields 71
discount fields 81
display fields 56
domestic shipping services field values 95
domestic shipping services fields 85
download
create schedule 42
view schedule 43
download files
programmatically 52
download request 41
downloading
reports 36
E
eBay store
category numbers 29
eBay token 52
End action 12
entering data 20
excess fields 17
F
feedback fields 56
fees, auction 20
fees, listing 20
123Index
File Exchange Advanced Template Instructions
field definition
Action 56
field relationships 11
fields
Action 20
Description 20
entering data 20
Title 20
fields, reports
Active Listings 109
Awaiting Payment 110
Global Trade Item Number 113
Load Response Results 112
Paid and Awaiting Shipment 115
Paid and Shipped 117
Product Inventory 119
Sold Listings 119
Unsold Items 121
File Exchange
finding templates 10
file format 12
file revision 38
file size and content rules 12
flat-file formats 45
format check 36
france shipping services option field values 100
G
germany shipping services option field values 100
gift fields 71
Global Trade Item Number report fields 113
H
handling fields 71
hong kong shipping services option field values 101
HTTP post request 53
I
india shipping services option field values 102
Info action 15
international shipping services field values 95
international shipping services fields 85
ireland shipping services option field values 101
italy shipping services option field values 102
item specifics, custom 27
L
limits
characters 11
listing fees 20
listings and records menu 41
Load Response Results report fields 112
M
malaysia shipping services option field values 103
metadata
API compatibility level 47
cell information 54
Currency 47
overriding 54
SiteID 46
modify variations 26
multiple actions in one file 17
N
netherlands shipping services option field values 103
numbers, store category 29
O
overriding metadata 54
P
package fields 71
page
View Upload Results 36
paid and awaiting shipment items report 41
Paid and Awaiting Shipment report fields 115
paid and shipped items report 41
Paid and Shipped report fields 117
paid items 41
payment
Business policy 22
payment fields 75
payment policy 32
philippines shipping services option field values 104
picture fields 56
PicURL, variation 23
poland shipping services option field values 104
pricing fields 81
Product Inventory report fields 119
programmatic instructions to download files 52
programmatic instructions to upload files 52
Q
Quantity, variation 23
quotation marks 17
R
region names 47
Relationship, variation 23
RelationshipDetails, variation 23
Relist action 12
report fields
Active Listings 109
Awaiting Payment 110
Index124
File Exchange Advanced Template Instructions
report fields (continued)
Global Trade Item Number 113
Load Results Response 112
Paid and Awaiting Shipment 115
Paid and Shipped 117
Product Inventory 119
Sold Listings 119
Unsold Items 121
report scripts 109
reports 41
reports, downloading 36
request eBay token 52
required fields per action 16
requirements
buyers 30
results
file 36
view upload 36
results report 37
return
Business policy 22
return policy 34
return policy fields 75
Revise action 12
revision files 38
S
scheduling downloads 41
scripts, reports 109
shipment tracking numbers 34
shipping
Business policy 22
shipping discounts 33
shipping services field values 95
shipping services fields 85
shipping services option field values
Australia 95
austria 96
belgium(dutch) 97
belgium(french) 97
canada 98
Canada (French) 99
china 99
france 100
germany 100
hong kong 101
india 102
ireland 101
italy 102
malaysia 103
netherlands 103
philippines 104
poland 104
singapore 104
spain 105
switzerland 105
taiwan 106
united kingdom 106
shipping services option field values (continued)
united states 107
singapore shipping services option field values 104
site ID 46
site-specific file formats 45
sites that support catalog templates 44
smart headers 11, 16
Sold Listings report fields 119
spain shipping services option field values 105
StartPrice, variation 23
Status action 12
store category fields 56
store category numbers 29
structure
template 11, 36
style fields 56
supported formats 12
switzerland shipping services option field values 105
T
taiwan shipping services option field values 106
tax fields 81
template
entering data 20
templates
adding conditionID 28
adding custom item specific fields 27
adding new fields 18
adding shipment tracking number fields 34
adding shipping discount fields 33
country codes 49
Currency metadata 47
deleting a field 18
deleting multiple field values 19
file formats per site 45
file size and content rules 12
finding 10
metadata cell information 54
modifying 26
overriding metadata 54
region names 47
required fields per action 16
SiteID metadata 46
sites that support catalog template 44
structure 11
uploading 36
using quotation marks 17
using smart headers 16
variation 23
tips 11
Title field 20
token 52
tracking numbers 34
types
characters 11
typographic conventions 10
125Index
File Exchange Advanced Template Instructions
U
understanding template structure 11
united kingdom shipping services option field values 106
united states shipping services option field values 107
unsold items report 41
Unsold Items report fields 121
upgrade fields 56
upload
result details 37
view results 36
upload files
programmatically 52
using Action values 12
using quotation marks 17
using smart headers 16
V
variations 23
CustomLabel 23
modify 26
PicURL 23
Quantity 23
Relationship 23
RelationshipDetails 23
StartPrice 23
VerifyAdd action 12
view download schedule 43
view upload results 36
W
warranty fields
standard 75
weight fields 71
Index126
File Exchange Advanced Template Instructions
