All Collections
CSV IMPORT & UPDATE
eBay CSV Tools
eBay CSV - Import Products | Bulk Upload CSV/Excel files
eBay CSV - Import Products | Bulk Upload CSV/Excel files

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

Aaron avatar
Written by Aaron
Updated over a week ago

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

Please review the full article for updates.




eBay CSV Requirements:

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.




Upload 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:

  • select the eBay Business Policies you want to use,

  • then set your preferences for your items:

Click Apply to eBay 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


Did this answer your question?