Skip to main content

eBay CSV - Import Items | Bulk Upload CSV/Excel files

How to format (and upload) a CSV file or Excel Workbook to import eBay listings into 3Dsellers Drafts. [+ Template]

Written by Karolina Santiago

The video is depreciated. (A new video is coming soon)

Please review the full article for updates.



eBay CSV Requirements:

Overview of CSV Import and Export Functions in 3Dsellers

3Dsellers offers comprehensive tools for both importing new listings and exporting your existing eBay listings:

  • Import CSV: Create bulk listings using templates (covered in detail below)

  • Export CSV: Download your existing eBay listings for review or modification Supported eBay Sites for Exports: You can export your active eBay listings from any supported eBay site, enabling multi-store management. Sites include Australia, Germany, USA, and more.

Workbooks:

  • .xlsx (Excel Workbook File)

    • You'll select a sheet to import after the file is uploaded.

CSV File:

Both filetypes:

  1. Must use Comma-separated delimiters

  2. ❌ Cannot include auto-formatted numbers.


Required eBay CSV Fields

Below are fields (and listing types) that require a specific format.

SKU (eBay Custom Label)

Every row in the CSV must have a unique SKU.

(Except Car Compatibility "child rows")


Auction or Fixed Price

To create an Auction listing, set ListingDuration to 1, 3, 5, 7, or 10.

ListingDuration

AuctionStartPrice

AuctionReservePrice

AuctionBINPrice

7

1

10

12

eBay Fixed Price (GTC) Listings will import as "Fixed-Price" automatically.

(leave ListingDuration blank)


Item Specifics

If the 3Dsellers CSV Template includes the Item Specific name (MPN, UPC, Color, etc.), no text formatting is needed.

Color

Material

Grey

ABS Plastic

If the template doesn't include an Item Specific, before the Item Specific label:

  • C:

  • Depreciated: CustomSpecifc

C:Brand

C:Type

BigBrand

Does not apply

CustomSpecificDiameter

3.45 Inches

Pro Tips:

  • C: can import any Item Specific (including Item Specifics in 3Dsellers CSV Mapping)

    • CustomSpecific will not import Item Specifics in 3Dsellers CSV Mapping.

  • When uploading the CSV/Excel file, custom Item Specifics will not display in the Mapping settings.

🙌 New - Separate columns for Item Specifics Name and Value

To help you import from other software (like ChannelAdvisor), you can separate Item Specific Names and Values into 2 columns:

Ensure the column headers use the following format:

  • Attribute{#}Name

  • Attribute{#}Value

Attribute1Name

Attribute1Value

Attribute2Name

Attribute2Value

Brand

Unbranded

Color

Blue


eBay Categories

  • Enter a Category ID to include eBay Categories and Store/Shop Categories.

  • Category and Category2 can also search text (results may vary).

Category

Category2

StoreCategory

StoreCategory2

88433

14883

33103728012

33103729012

Always include an eBay Category in your CSV.

The Category ensures the correct Required Item Specifics are assigned to the listing


Product Condition

Assign a Condition to the listing with eBay Condition IDs

Condition

ConditionNote

1000

The item is brand new, unused, unopened, and undamaged

1500

Open box, sealed inner packaging. Never Used.

Pro Tips:

  • Conditions may be rejected if the eBay Category does not accept it.

  • eBay may need to approve your account for refurbished conditions in particular categories.


Shipping & Package Settings

Note: PackageType

eBay may reject a PackageType based on the Category.

In this case, please try the following:

  • PackageThickEnvelope works for almost every category and eBay site.

  • MailingBoxes works for most eBay Australia categories.

Package Dimensions & Weight

If your Shipping Policy uses Calculated Shipping, then package dimensions and weight are required.

MeasurementSystem

PackageLength

PackageWidth

PackageDepth

WeightMajor

WeightMinor

ENGLISH

20

20

20

4

2

Weight units are separated:

  • WeightMajor (Pounds / Kilos)

  • WeightMinor (Ounces / Grams) [Decimals are not allowed. Round up.]

MeasurementSystem is set automatically by the country of your eBay Account on 3Dsellers. Accepted values are ENGLISH and METRIC.

Item Location

CountryCode and Location are required for every eBay listing.

eBay uses this info for Estimated Delivery dates.

CountryCode

Location

US

Topeka,Kansas

Reminder: If the item is in the UK, enter GB for the CountryCode.

eBay Global Shipping Program (GSP) options:

  1. Make a GlobalShipping column and set the values to TRUE..

  2. Or, enable GSP in your Shipping Policies to apply it automatically to the listings.


Images

  • You can import up to 24 images per listing, and 24 images per variation.

Use Separate Columns

  • Create a column for each image.

  • Number the columns in the sort order that the images should appear on eBay.

  • The field Image 1 is the primary image.

All Images in One Cell

  • Alternatively, you can include all images in one cell called ImageURLs.

  • Separate each URL with a comma.


Image Hosting for Product Photos

Select an image host when you upload the CSV:

  • Above the Mapping table, click the Images button

  • The resulting 3Dsellers Drafts will use the selected image host:

  • 3Dsellers image host backs up your photos, so eBay can't delete them. (eBay Hosting will delete 3Dsellers Draft images if not published within 30 days. Learn more)

  • eBay will try and host all your images automatically when you publish the 3Dsellers Drafts.


Business Policies (Returns & Shipping Settings)

Shipping and Return settings can only be set with eBay Business Policies.

You can skip these fields if all the listings use the same business policies.

Instead, you can choose policies when you bulk-publish the listings.

Find Business Policy IDs:

Navigate to: Products > Listings Manager > Business Policies

PolicyPayment

PolicyShipping

PolicyReturn

217446963020

217862221020

30097749020

Why does 3Dsellers only use Business Policies? - If you create Shipping and Return settings for individual listings, eBay automatically creates Business Policies on your account. This can lead to countless policies, making bulk listing nearly impossible in many cases. As a bulk-selling platform, we aim to prevent additional work and make your business easier to manage.


Variation Listings

Variation Listings require multiple rows:

  • One top "Parent Row" (main listing details)

  • Multiple "Child Rows" (variation details)

E.g.

SKU

Parent SKU

Title

C:Size

C:Color

Quantity

Price

(parent row)

ITM001

A Title

(child row)

variation_1

ITM001

M

Red

2

16.99

(child row)

variation_2

ITM001

L

Blue

2

18.99

Variation SKUs:

  1. Each variation must have a unique SKU.

  2. Enter the Parent Row's SKU in the Parent SKU column for each variation (Child Row). (This links the row to the parent.)

Creating Variation Options:

  • Item Specifics on Child Rows create the variation options.

  • Include all other Item Specifics on the Parent Row.

Variation Rows should only have these values:

  • SKU

  • Parent SKU

  • Price/Wholesale

  • Quantity/Warehouse

  • Item Specifics for Variation Options

Do not include these values on the Parent Row (except SKU).

Put all other listing data on the Parent Row.



CSV Import Walk-through

Import and publish bulk listings

Step 1 - Upload eBay CSV

  • Navigate to Products → Listings Manager → Import CSV

  • Click the Import Products button:

  • Choose the upload method, and upload your CSV

Step 2 - eBay CSV Mapping

  • Verify that 3Dsellers import fields match your CSV column headers:

Fallback Explained: Set a default value for empty CSV fields.

  • Do all your CSV rows use the same value for a field? Use the "Don't Import" option for mapping, then set the Fallback to apply the value to every CSV row.

Step 3: Import & Publish Listings

  • Click Start Import.

Depending on the number of items, description length, photos, image host, etc., it may take time to process the CSV.

  • Navigate to 3Dsellers Drafts.

  • Make any edits (if needed)

  • Select the imported items and click the Publish to Channel button:

  • Use the draft policies or select the eBay Business Policies you want to use,

  • then set your preferences for your items:

Click Publish Drafts to Channel to publish the products to your eBay account.


Troubleshooting Errors

A notification will display above your listings if eBay rejects any data in your Drafts.

  • Click View Errors to view eBay's error messages.

  • The eBay Error message will be linked to our eBay Error Resolve List


FAQ

Does importing overwrite an existing draft?

Yes. If a draft already exists in 3Dsellers with the same SKU, re-importing a CSV will overwrite it. This makes CSV import a reliable way to update draft data in bulk — just make sure your SKUs are consistent between exports and re-imports.

WarehouseQuantity vs UpToQuantity vs Quantity — which do I use?

These two fields serve different purposes:

  • WarehouseQuantity — Your actual stock level stored in 3Dsellers. This is the source of truth for inventory and is required to be mapped for the import to run.

  • UpToQuantity — Caps how many units eBay shows at once, regardless of your warehouse stock. Useful if you want to display limited availability on eBay (e.g. show "5" even if you have 100 in stock).

In short: use WarehouseQuantity for stock, UpToQuantity only if you want to cap eBay's displayed quantity.

Why is the "Start Import" button greyed out?

WarehouseQuantity must be mapped to a column in your CSV (or set via Fallback) before the import can proceed. If it has no mapping and no fallback value, the Start Import button will remain disabled. Either map it to your quantity column in the Mapping step, or set a Fallback value if all your items share the same stock level.

What's the difference between Cost and Wholesale?

They are the same field — just named differently depending on context. Wholesale (used in CSV column headers) and Cost (shown in the 3Dsellers UI) both refer to your internal cost price for the item. This value is stored privately in 3Dsellers and is never sent to eBay. Use it to track your margins alongside your selling price.

Why didn't the AI auto-mapper pick up my SKU column?

SKU mapping is intentionally kept separate from the AI auto-mapper. Because SKU is the unique identifier used to match and overwrite existing drafts, it requires a deliberate manual mapping to avoid accidental overwrites. In the Mapping step, locate the SKU field and manually select your SKU column from the dropdown.

Minimum fields to create a draft vs. to publish live on eBay

The minimum required fields depend on your goal:

To create a Draft in 3Dsellers:

  • SKU (unique per row)

  • Title

  • WarehouseQuantity

  • Price

To publish a listing live on eBay, you also need:

  • Category (eBay Category ID)

  • Condition (eBay Condition ID, e.g. 1000 for New)

  • CountryCode and Location

  • Business PoliciesPolicyShipping and PolicyReturn (can be applied at publish time if not in the CSV)

  • Image 1 or ImageURLs — at least one image URL

  • Required Item Specifics for the chosen eBay category

💡 Tip: You can always import with just the draft-minimum fields, review in Drafts, fill in any missing details, and then publish — you don't need a perfect CSV to get started.

Did this answer your question?