Skip to main content

eBay Bulk Upload CSV Helper

eBay's bulk upload is notoriously picky. Seller Hub Reports (formerly File Exchange) rejects files for wrong CSV format, mismatched business policy names, and missing condition IDs. Even Mac users get tripped up - eBay expects Windows-style CSV. PipeSheets formats your listing data exactly how eBay wants it.

Stop getting red failure notices in Seller Hub Reports

What is eBay Bulk Upload CSV Helper?

eBay's bulk upload is notoriously picky. Seller Hub Reports (formerly File Exchange) rejects files for wrong CSV format, mismatched business policy names, and missing condition IDs. Even Mac users get tripped up - eBay expects Windows-style CSV. PipeSheets formats your listing data exactly how eBay wants it.

  • 3000, 1000, 1000, 7000 (condition IDs): eBay requires numeric condition codes - PipeSheets converts text values automatically
  • eBay-compliant titles: Removes characters that trigger upload failures and policy violations
  • Zero values (0): Fills missing quantity fields - eBay rejects rows with empty required fields

Transform listing data for Seller Hub Reports

1Before

TitlePriceQuantityConditionID
Vintage Camera (Tested & Working!)$149.991Used
Electronics Lot — AS IS99.99emptyFor Parts
Rare Collectible empty5Like New

2After

TitlePriceQuantityConditionID
Vintage Camera Tested Working149.9913000
Electronics Lot - AS IS99.9907000
Rare Collectibleempty51000

What Gets Fixed

Used, New, Like New, For Parts
3000, 1000, 1000, 7000 (condition IDs)

eBay requires numeric condition codes - PipeSheets converts text values automatically

Special characters (!, &, —, parentheses)
eBay-compliant titles

Removes characters that trigger upload failures and policy violations

Empty or NULL quantities
Zero values (0)

Fills missing quantity fields - eBay rejects rows with empty required fields

$149.99 with currency symbols
149.99 plain decimal

Strips $ and formats numbers for clean import

How It Works

Clean your data in three simple steps. No coding required.

1

Export or Create Your Listing File

Drop your file here

CSV or XLSX, up to 25MB free

data_export.csv

Use eBay's template from Seller Hub Reports or export from your inventory system

2

Apply eBay Cleanup

Quick Clean Pipeline
Trim whitespace
Standardize nulls
Remove empty rows
Normalize headers

Convert conditions to IDs, fix titles, clean prices, fill empty fields

3

Upload to Seller Hub Reports

clean_data.csv
Ready
1,234
rows
8
columns
2.3s
time

Download the eBay-ready file and upload without red failure notices

Seller Hub Reports: Action Codes, Item Specifics, and Why Uploads Fail

Seller Hub Reports failures usually come down to three things: the wrong action code for what you are trying to do, missing or misnamed item specifics, and file-format details eBay never surfaces clearly. Understanding the first column of your CSV - the Action column - solves more upload problems than anything else.

eBay action codes and when to use each

eBay bulk upload action codes and their requirements

ActionWhat it doesWatch out for
AddCreates a brand-new listing from the rowFails if required fields (category, condition, price, quantity) are missing; do not include an ItemID
ReviseUpdates an existing active listingRequires the ItemID column; only include the fields you are changing plus the required identifiers
RelistBrings back an ended listingRequires the ItemID of the ended listing - relisting keeps sales history that a fresh Add loses
EndEnds an active listingRequires ItemID; rows with a wrong or stale ItemID fail individually while the rest of the file processes

Item specifics: the silent listing killer

Item specifics live in columns prefixed with C:, like C:Brand, C:Size, or C:Color. Many categories now require specific ones - a clothing listing without C:Size or C:Brand can fail outright or get buried in search. Two problems dominate: inconsistent values (Blue, blue, BLUE across rows) and values eBay does not recognize for that category. In PipeSheets, a case transform makes capitalization uniform, and the map values step converts your internal vocabulary to eBay's expected values - for example mapping 'navy', 'dk blue', and 'NAVY BLUE' all to 'Blue'. Consistent item specifics is also what makes your listings filterable in eBay search, which directly affects visibility.

Workflow: from spreadsheet to live listings

eBay bulk upload cleanup steps

  • Download the current category template from Seller Hub → Reports → Download - column requirements change, so do not reuse a year-old template.
  • Upload your listing data to PipeSheets and run Quick Clean for whitespace, nulls, and empty rows.
  • Use map values to convert condition text to numeric IDs (Used to 3000, For Parts to 7000) and to standardize item specific values.
  • Use find & replace to strip characters eBay rejects in titles, and rename columns so headers exactly match the template - eBay fails files with unrecognized columns.
  • Reorder columns to the template's order, preview, and download as CSV.
  • Upload in Seller Hub Reports, then download the upload results report. It lists each failed row with a reason - fix those rows and re-upload just them.

The results report is the step most sellers skip. A red failure notice only tells you the file failed; the results report tells you which rows and why. Fix, re-upload, repeat - with a saved pipeline, the second pass takes minutes.

Frequently Asked Questions

Fix Your eBay Bulk Upload

No more red failure notices. Format your listings for Seller Hub Reports in seconds.

Get Started