Skip to main content

Managing Bulk Edits and SKU/Inventory Adjustments in 3Dsellers

AI Support Bot avatar
Written by AI Support Bot
Updated over a month ago

Overview

Managing bulk edits and SKU or inventory adjustments efficiently is essential for sellers handling large catalogs and multiple variations.
3Dsellers provides powerful bulk editing tools and CSV-based inventory updates that allow you to update prices, quantities, SKUs, and variations at scale—while keeping inventory accurate across all listings.

This guide explains:

  • Bulk edit limits and best practices

  • How to manage variations using SKUs

  • When and how to use CSV updates for large inventory changes

  • Common validations, constraints, and troubleshooting tips

For very large updates (hundreds or thousands of listings), CSV updates are strongly recommended.


🔧 Understanding Bulk Editing Limits

Bulk editing allows you to update multiple listings at once, but it has operational limits designed to ensure system stability and performance.

📌 Maximum Listings per Bulk Edit

  • 200 listings per operation

  • You can perform multiple bulk edit operations, but each action is capped at 200 listings

Note: the 200-listing limit applies per action, not per day.

ℹ️ Best practice:

Break large updates into organized batches (by category, status, account, or channel).

👉 To efficiently group listings before bulk editing, use Segments:
How to Use Segments and Custom Segments in 3Dsellers Listing Tool


The Listing Tool allows you to select up to 200 listings at a time and apply bulk actions using the Bulk Actions menu.


✏️ What Can Be Bulk Edited

Common bulk edit actions include:

  • Listing status (Active, Draft, Ended)

  • Prices and quantities

  • Categories and attributes

  • Shipping and fulfillment settings

  • Tags and custom fields

  • Inventory sync from Product Catalog

⚠️ If you need to update more than 200 listings or perform SKU-level inventory changes, use CSV updates instead.


🧩 Managing Variations Using SKUs

SKU-based management is essential when working with variations across multiple listings.

SKU Management Essentials

✅ Consistent SKU Assignment Across Listings

  • The same variation should use the same SKU across all listings

  • Example: All Pink variations → PINK-001

Why this matters:
It allows a single CSV update to change inventory across every listing using that SKU.


🔑 Unique SKUs Within a Single Listing

  • Each variation within a listing must have a unique SKU

  • Variations in different listings can share SKUs


Each variation must have a unique SKU within the same listing, while identical variations across different listings can share the same SKU.


📄 CSV Bulk Updates for Inventory Adjustments

CSV updates are the most efficient way to manage inventory across large numbers of listings and variations.

👉 For advanced CSV examples (price & inventory), see:
Update Values via eBay CSV – Edit Price & Inventory


📋 Required CSV Columns

Column

Description

variation_sku

Exact SKU used in listings

quantity

Inventory level (0 or higher)


Your CSV file must include variation_sku and quantity columns, with values matching listing SKUs exactly.


🔄 Step-by-Step: CSV Inventory Update

Step 1: Identify Variations

  • Identify which variations need updates

  • Confirm their exact SKUs

  • Decide target inventory quantities


Step 2: Create the CSV File

  1. Open Excel or Google Sheets

  2. Create columns: variation_sku, quantity

  3. Add one row per SKU

  4. Save as CSV


Step 3: Upload the CSV

  1. Go to Listing Tool

  2. Select CSV Import / Update Active Values / Update Inventory

  3. Upload your file

  4. Review the CSV mapping

  5. Click Start Import

  6. Wait until the update is complete and check the status to see if everything has been updated successfully.

CSV Import - Update Inventory

CSV Upload & Mapping


Step 4: Verify Results

  • Review the confirmation message

  • Open a few affected listings

  • Confirm quantities were updated correctly


ℹ️ Important Note About CSV Upload Results

If a CSV file contains formatting issues, the upload may still appear as completed successfully.

  • The system will only display errors if:

    • eBay returns an error for a specific item, or

    • A SKU listed in the CSV does not exist in your listings

For this reason, it’s important to review your CSV carefully and verify inventory changes after the upload completes.


⚙️ How CSV Updates Work

When a CSV is uploaded:

  • The system scans all listings

  • Finds variations with matching SKUs

  • Updates every instance of those SKUs


✅ Best Practices

  • Use Segments to organize bulk edits

  • Keep bulk selections under 200 listings

  • Back up inventory before CSV updates

  • Use consistent SKU naming

  • Test on small batches first


🛠️ Troubleshooting

Common Issues

  • CSV not saved correctly

  • SKU mismatches

  • Ended or archived listings

  • Catalog sync overriding changes


⚠️ Validations & Constraints

  • 200 listings max per bulk edit

  • SKUs required for CSV updates

  • Quantity must be ≥ 0

  • CSV must be UTF-8 encoded

  • Permissions apply by user role


🔗 Related Articles

Did this answer your question?