Shopify Mastery
November 17, 2023
6 min

How to Bulk Edit or Upload Products on Shopify? Shopify Tips

Complete guide on Shopify's two official methods for bulk editing and uploading products: using the Bulk Editor and CSV Import/Export. Perfect for managing large product catalogs.

How to Bulk Edit or Upload Products on Shopify? Shopify Tips

Sometimes you might face work that requires batch processing product data.

Like batch modifying SKUs, batch adding Barcodes (GTINs)? Quickly changing product prices? Or if you're running a general store model with massive product uploads, and other needs.

Shopify actually has various batch editing or upload functions built in!

No more talk—2 methods! Let's dive right in.

Shopify Admin

Method 1: Using the Official Bulk Editor

The Bulk Editor can only modify existing products, not upload new ones.

Bulk Editor

Steps

On the products list page, select the products you want to edit.

Click the "bulk edit" button.

After entering the bulk editor, you can select which fields you want to edit.

Select Fields

Directly edit the content you need in the table.

Edit Content

After editing, save your changes.

Bulk Editor Use Cases:

  • Batch price modifications
  • Batch inventory updates
  • Batch SKU additions
  • Batch Barcode/GTIN additions
  • Batch status changes (Draft/Active)

Method 2: CSV Import Method

This is a more powerful method that can upload new products and batch modify.

CSV Import

Steps

First, export an existing product as a CSV template.

Export Template

Open the file in Excel or a CSV editor and start editing.

Edit CSV

Tips: Remember to select "Draft" status in CSV, which allows you to more calmly check and modify products in the Shopify admin after uploading.

After editing, upload your CSV file.

Upload File

Check and modify products in the admin after uploading, then publish.

Review

CSV Import Advantages:

  • Supports batch uploading new products
  • Can batch modify all product fields
  • Suitable for general store mass listings
  • Can edit offline for improved efficiency

Pro Tips

Remember my previous post about using ChatGPT to mass-generate reviews?

If you want to try a large-scale general store model, you can reference that method.

Use ChatGPT to help you batch-generate relatively personalized content, like product descriptions. Then copy them in with one click.


Recommended for You

1 / 5