Import CSV - Bulk Upload eBay Product Listings

In this article:

• CSV Requirements

• How to use the CSV Import Template

• CSV Fields You Need to Know

  • Auction vs Fixed Price

  • Item Specifics

  • Categories

  • Condition

  • Shipping Packages

  • Business Policies

  • eBay Variation Listings

  • Product Photos & Image Host

• Upload Walk-through

• Related tasks

  • Update Any (& multiple) eBay Listing Details with CSV

  • Edit eBay Inventory and Pricing (+ auto-Inventory Control rules)

  • End eBay Listings with a CSV file

  • Delete eBay Variations with a CSV

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

3 — Fixed-Price listing

4-8 — Variation 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.

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.

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).

Resources:

View eBay Category CSV Specifications

eBay CSV - Product Condition

• Assign a Condition to the listing with eBay Condition IDs

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.

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.

CountryCode and Location are required for eBay Estimated Delivery dates.

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

Resources:

See eBay Package Details CSV specifications

Related:

• Edit eBay Business Policies with a CSV file

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

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

Resources:

Related:

• How to delete variations with a CSV

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: