Bulk edit Shopify products with a spreadsheet

Load your catalog into a spreadsheet that stays connected to your Shopify store. Update titles, descriptions, status, tags, and more across thousands of products, then review your changes and sync to Shopify when ready.

Everything you need to bulk edit Shopify products

Mixtable loads your Shopify products into a spreadsheet that stays connected to your store. Edit like in Excel or Google Sheets, then sync reviewed changes back to Shopify.

The core product fields

Edit titles, descriptions, status, and other core fields, then add Net Sales, quantity sold, order count, refunds, or return analytics beside each product.

Create and update products

Add new rows to create products, with or without variants, and update thousands of existing Shopify products from the same worksheet.

Spreadsheet tools you already know

Use copy and paste, formulas, fill down, sorting, filtering, and find and replace to make big changes in minutes, no exports required.

Templates and custom field sets

Start from templates like Full Product Info and Basic Product Info, or pick standard fields, all fields, or your own ordered field selection.

Conditional worksheets

Build worksheets that only contain products matching your rules, like a vendor, tag, or status, and that stay updated as products change.

Cell and row history

See what changed, when, and by whom for any product row or cell, so catalog cleanups never turn into guesswork.

Edit every product field with a spreadsheet

Your products load into rows, and every field you choose becomes a column. Add supported analytics beside the fields you edit, so sales and return performance stay visible while you work. Change one cell or ten thousand, and Mixtable keeps track of every draft edit until you are ready to sync to Shopify.

  • Edit titles, descriptions, vendors, product types, and categories in place
  • Set product status to active, draft, or archived across whole ranges
  • Update handles, template suffixes, and publication fields where supported
  • Pick standard fields, all fields, or a custom ordered field set per worksheet
Edit your products

Update thousands of Shopify products at once

Copy and paste from anywhere, fill a fix down an entire column, or find and replace across your whole catalog. If you prefer point and click, the built-in bulk tools preview affected rows before anything is applied.

  • Fix titles and descriptions with find and replace, with preview and whole-word matching
  • Fill a corrected vendor or product type down thousands of rows in one move
  • Use formulas like =PROPER() and =TRIM() to clean messy imported data
  • Sort and filter first, so changes land only on the rows you mean
Clean up your catalog

Create new Shopify products straight from rows

New season, new supplier list? Paste new products into empty rows, with or without variants, and Mixtable creates them in Shopify when you sync. Existing rows update, new rows create, all from one sheet.

  • Add products with or without variants from the same spreadsheet
  • Use the CSV importer to import a file from your team or vendor, with column matching to ensure the correct worksheet columns are updated
  • Paste product lists from a supplier sheet directly into empty rows
  • Start new products as drafts, then flip them to active when they are ready
  • New products are labeled in the sync preview before you run Sync to Shopify
Add your next drop

Work on just the products that match your rules

Point a worksheet at a slice of your catalog, like one vendor's products, everything tagged clearance, or every draft. As products start or stop matching in Shopify, rows enter and leave the sheet on their own.

  • Filter by vendor, tag, status, product type, category, and more
  • Combine rules to target exactly the products you want to edit
  • Rows stay in sync with your store as products change
  • Check cell and row history to see who changed what along the way
Build a filtered view

Review every product change before Shopify sees it

Edits stay in your worksheet as drafts, highlighted so you can spot them. When you are ready, open the preview for your worksheet, check each pending value, and run Sync to Shopify. Nothing publishes on its own.

Preview changes
#
Product
Field
Pending value
Formula
1
Merino Crew Sweater
Title
Merino Crew Sweater
=PROPER(B14)
2
Flannel Overshirt
Status
Active
3
Linen Trouser
Vendor
Acme Basics
4
Corduroy Cap
Product type
Hats
5
Canvas Tote
Category
Bags & Totes

The product fields you need, in one worksheet

Load any of these into a products worksheet, split them across tabs, and keep helper columns right beside the fields you sync. Dedicated pages cover prices, variants, tags, collections, metafields, and inventory in more depth.

Title Handle Description Vendor Product type Status Tags Category Template suffix Publications SEO title and description Product metafields Variant fields Product images

Mixtable vs other ways to bulk edit Shopify products

Most stores manage products with some mix of these. Here is how they compare when you need to change a lot of products at once.

Product taskMixtableShopify adminCSV import and exportOther bulk-edit apps
Edit many products in one view Yes, with a sheet Limited bulk editor In Excel, then re-upload Form-based
Formulas, fill down, find and replace Excel-style tools No In Excel, then re-upload Rarely
Create and update products together Yes, same sheet One at a time Risky column mapping Varies
Live filtered views of your catalog Conditional worksheets Saved views only No Some
Metafields, categories, and publication fields Yes Some, per product Limited columns Varies by app
Review pending changes before they go live Yes Saves instantly No preview Some
Change history per cell and row Yes Admin events only No Rarely

Comparison reflects typical bulk product editing workflows. Shopify features can change over time.

From install to a cleaner catalog in minutes

No CSV exports, no re-imports, no waiting. Connect your store and start editing your Shopify products.

1

Connect your store

Install the Mixtable Spreadsheet Editor from the Shopify App Store and open a products spreadsheet.

2

Load your products

Pull in products with or without variants, using templates or your own field selection.

3

Edit in the sheet

Use copy and paste, formulas, fill down, sorting, filtering, and find and replace.

4

Review pending changes

Every edit stays a highlighted draft, so you can confirm exactly what will update.

5

Sync to Shopify

Push your reviewed changes back to your store in one move when you are ready.

Shopify bulk product editing questions

How do I bulk edit products in Shopify?

Install the Mixtable Spreadsheet Editor from the Shopify App Store, open a products spreadsheet, and your catalog loads into a spreadsheet. Edit titles, descriptions, status, tags, and other fields the way you would in Excel, then review your pending changes and run Sync to Shopify.

Can I bulk edit product titles and descriptions in Shopify?

Yes. Titles and descriptions are regular columns in your worksheet, so you can rewrite them cell by cell, fill a pattern down the column, or clean them up with find and replace and formulas across thousands of products at once.

Can I create new Shopify products from a spreadsheet?

Yes. Add new rows to a products worksheet, with or without variants, fill in the fields you need, and Mixtable creates those products in Shopify when you sync. You can paste a whole supplier list directly, or use the CSV importer to import a file from your team or vendor and match each CSV column to the correct worksheet column before syncing.

How do I change product status to active, draft, or archived in bulk?

Load the status column, then set it for as many rows as you like with copy and paste or fill down. The changes stay as drafts in the sheet until you review them and run Sync to Shopify.

Do I need to know formulas to bulk edit Shopify products?

No. Most edits are plain typing, copy and paste, and point-and-click tools like find and replace with preview. Formulas are there when you want them, not a requirement.

Can I edit only the products that match a filter, like one vendor or tag?

Yes. Conditional worksheets load only products matching rules you choose, such as vendor, tag, status, type, or category. As products start or stop matching in Shopify, rows are added or removed automatically.

Which product fields can I edit with Mixtable?

Core fields like title, handle, description, vendor, product type, status, tags, categories, and template suffix, plus publication fields, SEO fields, metafields, images, variant fields, prices, and inventory where supported. Dedicated use-case pages cover each area in depth.

Will my product edits publish to Shopify automatically?

No. Every edit is held as a pending change and highlighted in your worksheet. You review the full list in the sync preview and then run Sync to Shopify when you are ready, so nothing goes live by accident.

Manage your whole Shopify catalog with a spreadsheet

Open Mixtable for your store and bulk edit your products the way you already think.