Change regionHiPO
INSEA
en

Uploading your listings in bulk using Reports tab

Seller Hub Reports, formerly known as eBay File Exchange, lets you upload and manage your inventory easily in CSV or XLS files. This is one of the most effective list strategies for high-volume sellers.

1

Select a template

Download a template to fill out your listings and/or order details in bulk

2

Fill in the template

Follow our instructions and use helpful guides and tips in the smart file

3

Proceed to upload

Once you’ve completed the details in the file, save it and upload it

Activate

All you need to get started on Reports features is an eBay account with access to Seller Hub. Business sellers are automatically opted in to Seller Hub. Private sellers just need to have made at least one sale to get access. eBay Seller Hub listing features, as well as reporting and order management are free to use.

How to create templates to list or edit your inventory in bulk

Whether you're listing inventory for the first time or editing existing listings, you should start by creating templates in the Upload section.

  1. Go to Seller Hub Reports.
  2. Select Upload on the left-hand side.
  3. Select the Get template button.
  4. Select Listings from the Source options.
  5. Select Create new listings template as the template Type.
  6. Select the File type:
    • Excel Spreadsheet (.xlsx) is the default option, optimized to work well with the latest version of Excel
    • Comma Separated File (.csv) is recommended for advanced sellers and provides more flexibility for advanced apps as it structures the information in a table-type of layout. It’s compatible with most spreadsheet applications
  7. Select the required category (categories) from the Category options. Use the bar on the right to scroll down through the main category headings and click arrows to collapse the sub-categories. Tick up to 5 checkboxes and click Done).
  8. On the right side of the window, you will see a summary of columns. Check that the selected parameters are correct and select Download.

Creating new listings through the reports tab generally requires image hosting. However, you can use the Drafts template, leave the image URL column blank, and add images later when you're converting the draft to listings. To create a draft, simply select Create drafts template as the template Type on step 5. Then you can add images later when you're converting the draft to listings.

SH_Reports_list_07.jpg

Category changes

  • Relevant and up-to-date changes eBay periodically makes to the category structure helps to ensure that your listings appear in the relevant categories
  • If and when the category structure changes, your listings may be automatically moved to a different category, based on the item specifics that you provided
  • Aligning categories across international eBay sites will make cross-country trading on eBay sites easier
  • You can find all category ID numbers needed for Seller Hub Reports here or inside of a category template

You can also create templates to bulk edit and manage existing listings and orders:

  1. Go to Seller Hub Reports.
  2. Select Upload on the left-hand side.
  3. Select the Get template button.
  4. Choose Orders or Listings from the Source options.
  5. Select the template Type:
    • Edit price and quantity or Relist unsold listings — for Listings
    • Add order tracking and shipping info — for Orders
  6. If you choose Orders as the template source, select the Date Range for the report.
  7. Select Download.

How to fill in templates

The downloaded template is an interactive, smart file that allows you to view header definitions, choose fields from dropdowns, and see helpful tool tips. Inside the file template you will find different colors to help you decide which cells to pre-fill, helping buyers narrow down their search results to find your listing.

Valuable insights

If Reports is new to you, try to list 1-2 items first to familiarize yourself with the tool.

Inside the template file, you'll find general instructions and a link to the full guide on how to complete your listings and customize them with advanced features.

Start filling from left to right using the Add action to add new listings and fill in each column:

  1. Hover your mouse over headers to see column header definitions.
  2. Click on the cell with missing fields.
  3. Click on the arrow that appears beside the cell.
  4. Select an applicable value from the list or enter a custom value, or leave it blank if none is applicable.

SH_Reports_list_13.jpg

Note the color reference on each cell: it's important to fill in color-coded item specifics. These item specifics will help buyers optimize their search results: the more information you enter, the more buyers will be able to find your products.

  • Red color indicates missing required fields for a listing
  • Yellow color indicates missing item specifics that will be required soon
  • Blue color indicates missing recommended item specifics for a listing
  • Grey color indicates item specifics does not apply to this item/category

Operations to manage eBay listings

“Add” operation (listing creation)

Once you've chosen the option Create new listings and selected other preferences, you will obtain a file which contains the mandatory and recommended characteristics of each category you want to publish your items:

  • If you have selected the CSV file, on the same sheet where the columns are located, you will see an information section, where eBay provides recommended values to include in the item specifics
  • If you have selected the XLSX file, you will have different sheets where you can find the instructions and recommended value to upload the products

In addition to the characteristics of each category, you will have to fill in a series of data to correctly upload your listings. Here is a list of the mandatory fields which must be filled in:

  • Action: this column requires to introduce the value Add for every item you want to publish on eBay
  • Site ID: this field represents the site ID where the listing is going to be published. For example: UK. See the site IDs list
  • Country: the country codes. For example: GB (United Kingdom). Сheck the country codes list
  • Currency: the designated monetary system. For example: GBP. See the currency codes list

(SiteID=UK|Country=GB|Currency=GBP|Version=1193|CC=UTF-8) Introducing SiteID, Country and Currency on the header/column name, all listings included in the file will be published on the same eBay site (UK in this case). If you want to publish listings on different sites, then you will have to create new columns called SiteID, Country and Currency, and the correspondant values for each listing.

  • Custom label (SKU): this would be the product SKU (Stock Keeping Unit), a user-assigned product identification label (an identification code)
  • Category: the numerical identifier of the eBay category. For products with variations, you will only fill in this field for the parent product. This must always be a final category, and not an intermediate one. See the complete tree with eBay categories
  • Store category: your Store categories identified. As using shop categories is optional, this is not a mandatory field
  • Title: the primary name that appears at the top of your listing, 80 characters maximum. In case of multi-variation listing, you will include titles only on parent products
  • Condition: the numerical identifier which specifies the product condition. For example: 1000=New. You can find all possible Condition IDs for the different eBay categories using this free tool
  • UPC/ISBN/EAN: the Universal Product Code or other product code will be included in this field. In its absence, you will insert the value Not applicable
  • Item photo URL: you can enter the images URL in this field. You can add up to 12 images for each listing, and URLs must be separated by a vertical bar ( | ), without spaces. Learn more on using images with your listings below
  • Format: you can choose between auction style and fixed price listing. Default entry is Auction. In case of fixed price items, you will have to insert the value FixedPrice
  • Description: in this field, you will describe basic, special and unique features of your listings. In case of multi-variation listings, descriptions will only be indicated on parent products
  • Duration: for fixed price listings, always use the value GTC (Good ’Til Canceled). This means that your listing will be automatically renewed every 30 days. Valid auction durations include: 1, 3, 5, 7, and 10 (days)
  • Price: this field indicates the price at which bidding starts for an auction (accepts decimal point but no currency symbols). If the listing is in fixed price format, this is the price to buy the item. Enter the price value on each variation in case of multi-variations listings, and never on the field for the parent product
  • Quantity: this field indicates the number of items available for sale. A quantity of more than 1 implies all the items are exactly the same. In case of multi-variations listings, you will also include stock on each variation, and never on the field for the parent product
  • Location: this field indicates the geographical location of the item. Enter postal code of your store or warehouse
  • Shipping profile name: the exact name of the shipping policy already defined on your Business policy page
  • Return profile name: the exact name of the return policy already defined on your Business policy page
  • Payment profile name: the exact name of the payment policy already defined on your Business policy page
  • Item specifics (C:Brand, C:MPN etc.): to introduce item specifics, such as Brand or MPN, you will need to create new columns with headers like these
  • Relationship / Relationship details: item variations will be defined on these columns.
    • For the parent item, you will leave the field Relationship empty. The parent row should only contain the normal listing information, like Action, Category, Format, and other shared information (like shipping and returns options) that apply to all the variations in the listing — but do not add any of this information to your child rows
    • For the child items, you will insert the word Variation for all variations on the field Relationship. Then you will have to specify these variations on the field RelationshipDetails: insert the name of the variation specific followed by an equals sign (=), and separate each value with semicolon ( ; ). To add another variation specific, you will repeat this on RelationshipDetails column, separating variations with a vertical bar ( | )

SH_Reports_list_15.jpg

Using images with your listings

The structured template file enables you to list vivid images of your items to showcase to your buyers, thus allowing them to make purchasing decisions faster. Photos need to be provided in the file template via URL links to the web-hosted images. Insert URL information in the field called Item photo URL.

The photo URL needs to start with the hypertext https:// and end with a file extension like .jpg or .png. Pictures can be self-hosted, hosted by a third party, or hosted by eBay Picture Services (EPS) through eBay’s API integration. There are many photo hosting services available and most are compatible.

eBay recommends a minimum of 500 pixels on the longest side, 800 pixels on the longest side to enable the buyer to zoom the picture in the listing page. For best results, 1200 pixels is Optimal.

Find out more tips for taking great photos

You can add up to 12 photos on the parent row and each variation row. When doing so, use the pipe ( | ) character to separate the values. Here is an example of how you can list with multiple images:

https://www.picturshostingsite.com/picturefolder/picturename1.jpg|https://www.picturshostingsite.com/picturefolder/picturename2.jpg|

If an image URL has blank spaces, you must replace the blank spaces with %20; otherwise, the image will not appear in the listing.

“Revise” operation (update listings)

You can use the revise file to update information about your active listings. It allows you to modify your listing's information: stock, prices, titles, and many other aspects.

The template file provided on the Uploads section includes a complete list of all active listings, so you can easily modify the information and then upload the same file to eBay. You will even be able to add new columns in case you need to modify other aspects which aren't included on the obtained file. Anyway, this will be faster and more comfortable than creating a revise file from scratch.

If you’ve chosen the listing template type “Edit price and quantity”, this file will include the following fields:

  • Action: with the value Revise
  • Item number: Item ID of the items. In case of multi-variation listings, his information will only appear on the parent product row
  • Title: listing title
  • Listing site: publication site
  • Currency: the designated monetary system
  • Start price: the price at which bidding starts for an auction, or the price to buy the item if the listing is in fixed price format
  • Buy It Now price: you will only use this field in case you want to set a Buy It Now price for an auction
  • Available quantity: the number of items available for sale
  • Relationship: you will see the value Variation on every variation row
  • Relationship details: which includes the variation specifics
  • Custom label (SKU): a user-assigned product identification label (Stock Keeping Unit)

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.

“End” operation (Remove listings)

You can use the revise file to end the items you don't want to sell on eBay anymore. This is a really simple file which only requires 3 columns:

  • Action: enter the value End
  • Item number
  • Ending reason: the reason why you are ending the listing. You can choose among different options: LostorBroken, NotAvailable, Incorrect, OtherListingError

Adding tracking information to orders

You can easily add shipping and tracking information to orders through CSV files by choosing the appropriate option and date range when you download the template.

These are the fields you will use to update the tracking number:

  • Shipping status: you can choose among Shipped or NotShipped options. The Shipping status field is not mandatory. If you provide tracking information, the system will interpret it and mark it as Shipped
  • Order number
  • Item number
  • Item title
  • Custom label
  • Transaction ID
  • Shipping carrier used: identifies a shipping carrier used to ship an order, and the countries served by that carrier. Check all different carrier names here
  • Tracking number: in order to use the Tracking number field, you will also have to provide a value for Shipping carrier used

How to upload completed templates

$

Each time you upload a template file to eBay, the items are automatically listed as specified. Insertion fees may be free, but please note that certain listing features (such as Subtitle) may incur additional fees. When you sell an item, eBay charges a final value fee, based on the final selling price of an item. See Selling fees and Store Selling fees for details.

1. Go back to Seller Hub Reports.

2. Select Upload on the left-hand side.

3. Select the Upload template button.

SH_Reports_list_16.jpg

4. Choose .xlsx file type if you plan to use Excel, otherwise choose .csv file type.

5. Select the template type you're uploading.

6. Select Upload.

guide

Seller Hub Reports functionality is based on the outdated File Exchange tool. Templates created in the File Exchange tool are not transferred to the reports. To create new templates in Seller Hub, follow the instructions above.