In this article:


Resources:


eBay CSV Requirements:

  1. Save as a plain CSV

  2. Comma-separated delimiters

  3. ❌ Cannot include auto-formatted numbers (if using Excel)

SKU (eBay custom label):

  • SKU - Each row in the CSV must have a unique SKU.

  • Drafts - CSV Import will replace Drafts with the same SKU.


How to use the CSV Import Template

The Import Template includes 8 rows with examples of different listing types. Delete the listing types you don't need. Then, practice creating a couple of listings with the CSV.

1 Listing Data Fields (column headers)

2 Auction listing

3Fixed-Price listing

4-8Variation listing - (see variation CSV Format)


eBay CSV Fields to Know

Below are fields and listings that require either:

  • a specific format

  • or allow customisation.



eBay CSV - Auction VS Fixed Price

eBay Listings will import as "Fixed-Price" automatically.

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

  • Otherwise, leave ListingDuration blank to create a Fixed Price listing.

ListingDuration

AuctionStartPrice

AuctionReservePrice

AuctionBINPrice

7

1

10

12

Resources:

View Auction CSV Specifications



eBay CSV - Item Specifics

  • Use 3Dsellers CSV Template Item Specifics (MPN, UPC, Color, etc.) in your CSV.

  • If the template doesn't include your Item Specific, you can use the CustomSpecifc field.

Color

Material

CustomSpecificDiameter

Grey

ABS Plastic

3.45 Inches

Resources:

View Item Specifics CSV Specifications

Pro Tip: Always include an eBay Category in your CSV. The Category ensures the correct Required Item Specifics are assigned to the listing.



eBay CSV - Categories

  • Use Category IDs to include eBay and Store/Shop Categories in your CSV.

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

Category

Category2

StoreCategory

StoreCategory2

88433

14883

33103728012

33103729012

Resources:

View eBay Category CSV Specifications



eBay CSV - Product Condition

  • Assign a Condition to the listing with eBay Condition IDs

Condition

ConditionNote

1500

Open box, sealed inner packaging. Never Used.

Resources:

View eBay Condition CSV Specifications



eBay CSV - Shipping Packages

  • 3Dsellers supports eBay Global Shipping Program (GSP).

    • Set GlobalShipping to TRUE to enable GSP.

Pro Tip: eBay's accepted PackageType is:

  • PackageThickEnvelope for almost every category and eBay site.

  • Or MailingBoxes for eBay Australia.

GlobalShipping

PackageType

TRUE

PackageThickEnvelope


Calculated Shipping requires dimensions and weight for postage.

  • Add weight units separately for

    • WeightMajor (Pounds / Kilos)

    • WeightMinor (Ounces / Grams)

  • Decimals are not allowed.

    • If you need, round up WeightMinor.

  • Pro Tip: MeasurementSystem is set automatically by the country of your eBay Account on 3Dsellers.

MeasurementSystem

PackageLength

PackageWidth

PackageDepth

WeightMajor

WeightMinor

ENGLISH

20

20

20

4

2


CountryCode and Location are required for eBay Estimated Delivery dates.

  • Pro Tip: If the item is in the UK, enter GB for the CountryCode.

CountryCode

Location

US

Topeka,Kansas

Resources:

See eBay Package Details CSV specifications

Related:



eBay CSV - Business Policies (Returns & Shipping Settings)

  • Use Business Policy IDs to assign Shipping, Return, and Payment settings.

  • Skip these fields if all the listings use the same business policies.

    • Instead, 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

Resources:

View eBay Business Policy CSV Specifications

Pro Tip: Shipping and Return settings can only be set with eBay Business Policies. Why does 3Dsellers only use Business Policies? - If you create Shipping and Return settings for individual listings on eBay, eBay automatically creates Business Policies on your account. This can lead to hundreds of randomly-named policies, making bulk listing nearly impossible.



eBay CSV - Upload eBay Variation Listings

  • Import Variation Listings using multiple rows

    • Each variation row is linked to the "parent" listing by SKU.

  • For Variation Rows, only include:

    • SKUs,

    • Price,

    • Quantity,

    • and Item Specifics for Variation Options

SKU

Parent SKU

Title

Quantity

Color

PARENT-SKU

A Variation Listing's Title

variation-sku-1

PARENT-SKU

2

Red

variation-sku-2

PARENT-SKU

2

Blue

Resources:

Related:



eBay CSV - Product Photos and Image Hosting

  • 3Dsellers will host your product images automatically.

    • The SKU is saved with each image, so you can automatically apply the photos to Drafts in the future.

    • 3Dsellers image host backs up your photos, so eBay can't delete them.

    • Saves time processing the CSV

  • eBay and self-hosting are optional.

Resources:


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


Related Tasks:

Did this answer your question?