Bulk editing products in Shopify after WooCommerce migration (2026)

After migrating from WooCommerce to Shopify, you'll need to bulk edit products: updating prices after migration, adding tags, setting metafield values across hundreds of products, or correcting data that didn't migrate cleanly. WooCommerce merchants are used to WordPress and WooCommerce's CSV import tools — Shopify has its own approach. Here's how bulk editing works in Shopify.

WooCommerce bulk editing: what you're used to

In WooCommerce, bulk product editing happened via:

• WooCommerce Products → Bulk Edit: Select multiple products, update price, sale price, status, stock, categories, tags in a floating edit bar
• WooCommerce CSV Export/Import: Full product CSV export, edit in Excel/Google Sheets, re-import to update
• WordPress Quick Edit: Inline editing for single product fields from the product list
• WP All Import / WP All Export: Powerful CSV/XML import and export with field mapping

Shopify bulk editing methods

1. Shopify Admin Bulk Editor

The native Shopify bulk editing tool:

• Go to: Shopify Admin → Products → select multiple products → "Edit products"
• Opens a spreadsheet-style editor with editable columns
• Available fields: title, price, compare-at price, cost, SKU, barcode, weight, inventory, status, vendor, product type, tags
• Metafields can be added as additional columns if metafield definitions exist
• Limitations: slower for large catalogs (100+ products), no formula support, no batch operations by collection
• Best for: small updates to 20–100 products

2. Shopify CSV export/import

Export the entire product catalog to CSV, edit in spreadsheet software, re-import:

• Export: Shopify Admin → Products → Export → All products → Shopify CSV format
• Edit in Excel or Google Sheets
• Import: Shopify Admin → Products → Import → select CSV → replace existing products

Shopify CSV format differs from WooCommerce CSV:

• One row per variant (multiple rows per product)
• Product-level fields (title, description, vendor) repeated on each variant row
• Variant fields (price, SKU, inventory) on each row
• Images listed by URL — Shopify fetches them again on import
• Tags: comma-separated in a single "Tags" column

Shopify CSV limitations:

• Does not include metafield values in standard export
• Re-import replaces existing products (matches by Handle column)
• Large imports (10,000+ products) can timeout or have errors

3. Matrixify (Excelify)

The most powerful third-party bulk editing tool for Shopify:

• Export/import products, collections, customers, orders, metafields, blog posts, pages, redirects
• Excel format with multiple sheets — Products, Variants, Images, Metafields
• Supports partial updates: only columns present in the import file are updated (no accidental overwrites)
• Bulk metafield updates: add a "Metafields" sheet with metafield namespace, key, and value
• Scheduling: queue imports for off-peak hours
• Smart update mode: only update rows where values changed (reduces API calls)
• Pricing: $20–$200/month. Essential for merchants managing large catalogs.

4. Shopify Admin API / GraphQL

For developers — programmatic bulk updates:

• Shopify's Bulk Operations API: Run GraphQL mutations in bulk via async JSONL job
• Use for: mass price updates, tag assignments, metafield values, status changes
• Rate limits: GraphQL cost-based throttling (1000 points, restores 50/sec)
• k-sync can generate Shopify-ready update files for bulk metafield assignment post-migration

5. Shopify Flow (automated bulk operations)

For rule-based bulk updates that need to run automatically:

• Trigger: scheduled (daily, weekly) or event-based
• Action: update product tags, status, metafields based on conditions
• Example: automatically tag products as "sale" when compare-at price is set
• Example: archive products with zero inventory and no sales in 180 days

Common bulk edit scenarios after WooCommerce migration

Price updates across a category

Apply a 10% price increase to all products in a collection:

1. Export products: Shopify Admin → Products → Export, filter by collection tag
2. In Excel: add formula column = current price × 1.10
3. Replace price column with formula results
4. Import back with Matrixify (partial update — only Price column)

Adding tags to hundreds of products

Tag all products by vendor, product type, or migrated WooCommerce category:

1. Export with Matrixify, get "Tags" column
2. In Excel: add new tag to existing tags string using CONCAT formula
3. Re-import with Matrixify partial update

Bulk metafield values after migration

Set metafield values across many products (e.g., adding safety certifications to all products in a category):

1. Export metafields via Matrixify → Metafields sheet
2. Add new rows for each product/metafield combination
3. Import → Metafields sheet creates/updates metafield values

Updating product status (draft → active)

If products were imported as drafts during migration review:

• Shopify Admin → Products → filter by Draft status → select all → bulk Actions → "Make active"
• Or: CSV import with Status column set to "active" for all rows

Updating compare-at prices for sale display

Add "was" prices to create sale pricing after migration:

1. Export product CSV
2. Add "Variant Compare At Price" column with original (higher) prices
3. Ensure current "Variant Price" is the discounted price
4. Import → Shopify displays strikethrough pricing

Bulk editing metafields specifically

Standard Shopify CSV does not export/import metafields. Options for bulk metafield management:

• Matrixify: Dedicated Metafields sheet in export. Add, update, delete metafield values in bulk. Most reliable method.
• Admin API: POST /admin/api/2024-01/products/{id}/metafields.json — script to set metafields by product handle or tag
• Shopify Bulk Operations GraphQL: metafieldsSet mutation via bulk operation for 1000+ product metafield updates
• Shopify Admin bulk editor: If metafield definitions exist, these appear as columns in the bulk editor. Edit up to 50 at a time directly in the UI.

Bulk image operations

Post-migration image tasks:

• Add alt text in bulk: Not supported natively. Use Matrixify Images sheet to set alt text by image URL pattern.
• Reorder images: Shopify Admin bulk editor can't reorder images — do this per-product or via API.
• Image compression: Shopify handles optimization automatically — no action needed.
• Replace images: Matrixify Images sheet — provide new image URL, matches existing by alt text or position.

Bulk product editing checklist after migration

• Review imported products: check for missing data (descriptions, prices, images) before going live
• Bulk activate draft products once review is complete
• Set compare-at prices for any sale products
• Add tags for collections, sale status, and search filters
• Set metafield values in bulk for product categories (safety certs, materials, specs)
• Install Matrixify for ongoing bulk edits after migration
• Set up Shopify Flow rules for automated tag and status management
• For price updates: use Matrixify partial import (only Price column) to avoid overwriting other data

Matrixify is the single most important tool investment for catalog management in Shopify. The native Shopify CSV is limited for complex catalogs — Matrixify's Excel format, partial updates, and metafield support make it the WP All Import equivalent for Shopify. Budget for it from the start of migration planning.