Variant Grid Editor

Variant Grid Editor

The Variant Grid Editor provides Excel-like spreadsheet editing for variants across multiple products. Edit prices, SKUs, inventory, and other variant fields in a familiar grid interface.

Overview

The Variant Grid Editor is designed for scenarios where you need to set different values for each variant. Unlike Targeted Bulk Edit (which applies the same value to all), the grid lets you edit each row individually.

Key Features:

  • Excel-like navigation and editing
  • Edit multiple fields per variant
  • Per-location inventory columns
  • Change tracking with visual highlights
  • Automatic backup before saving
  • Copy/paste support

Opening the Editor

  1. Select products in the main grid
  2. Click Spreadsheet Edit > Variants in the toolbar

The editor loads all variants from your selected products into a single editable grid.

Grid Layout

Frozen Columns (Read-Only)

The first two columns are frozen and cannot be edited:

Column Description
Product Product title for context
Variant Variant title (e.g., "Large / Blue")

Editable Columns

Column Description Notes
SKU Stock Keeping Unit Text field
Price Variant price Decimal, 2 places
Compare At Compare-at/original price Decimal, 2 places
Cost Cost per item Decimal, 2 places
Barcode UPC, EAN, ISBN, etc. Text field
Weight Product weight Decimal
Unit Weight unit Dropdown: lb, oz, kg, g
Tax Is taxable Checkbox
Inv Policy Inventory policy Dropdown: DENY, CONTINUE
Country Country of origin 2-letter ISO code
HS Code Harmonized System code Text field

Inventory Location Columns

If your store has multiple inventory locations, additional columns appear for each location showing current inventory levels.

Managing Location Columns:

  1. Click the Locations dropdown in the toolbar
  2. Check/uncheck locations to show/hide their columns
  3. Maximum 10 locations can be displayed at once
  4. First 3 locations are selected by default

Editing Cells

Key Action
Tab Move to next cell
Shift+Tab Move to previous cell
Enter Confirm edit, move down
Arrow keys Navigate between cells
F2 Enter edit mode
Escape Cancel current edit

Editing

  1. Double-click a cell to enter edit mode
  2. Type the new value
  3. Press Enter to confirm or Escape to cancel
  4. Modified rows are highlighted in yellow

Copy/Paste

  • Ctrl+C - Copy selected cells
  • Ctrl+V - Paste into selected cells
  • Works with Excel and other spreadsheet applications

Change Tracking

The editor tracks all changes and provides visual feedback:

  • Yellow row background - Row has pending changes
  • Header counter - Shows "X changes" in the header
  • Status bar - Displays total products, variants, and change count

Discarding Changes

Click Discard Changes to revert all modifications to their original values.

Saving Changes

  1. Make your edits in the grid
  2. Review the change count in the header
  3. Click Save to apply changes to Shopify
  4. Wait for the save operation to complete

What happens on save:

  1. Automatic backup is created (for variants with price/cost changes)
  2. Changes are sent to Shopify in batches
  3. Local cache is updated
  4. Progress is shown in the status bar

Auto-Close Option

Enable Auto-close on success to automatically close the dialog after a successful save.

Inventory Editing

Single Location

If you have only one inventory location, its column appears automatically.

Multiple Locations

For multi-location stores:

  1. Click Locations dropdown
  2. Select which locations to display (max 10)
  3. Edit inventory quantities per location
  4. All location changes are saved together

Inventory Policy

The Inv Policy column controls overselling behavior:

Policy Behavior
DENY Cannot sell when out of stock
CONTINUE Can oversell (allow backorders)

Common Use Cases

Update Prices Individually

When each variant needs a different price:

  1. Select products with variants to reprice
  2. Open Variant Grid Editor
  3. Edit the Price column for each row
  4. Save when complete

Bulk SKU Entry

Enter unique SKUs from a spreadsheet:

  1. Copy SKU column from Excel
  2. Select first SKU cell in grid
  3. Paste (Ctrl+V)
  4. Verify and save

Adjust Inventory Across Locations

Review and adjust inventory at multiple warehouses:

  1. Open Variant Grid Editor
  2. Show relevant location columns
  3. Adjust quantities as needed
  4. Save changes

Update Costs After Supplier Change

Update cost-per-item for margin tracking:

  1. Select affected products
  2. Open grid editor
  3. Update Cost column values
  4. Save

Set Weights for Shipping

Add or update weights for shipping calculations:

  1. Select products needing weights
  2. Open grid editor
  3. Enter Weight and select Unit
  4. Save

Best Practices

  1. Work in batches - Select 20-50 products at a time for manageable grids
  2. Review before saving - Check the change count matches expectations
  3. Use filters first - Filter in main grid to select related products
  4. Copy from Excel - Prepare data in Excel, then paste into grid
  5. Check inventory locations - Ensure correct locations are selected

Comparison: Grid Editor vs Bulk Variant Fields

Scenario Use This Tool
Set same value for all variants Bulk Variant Fields
Set different value per variant Variant Grid Editor
Apply formula (e.g., +10%) Bulk Variant Fields
Review and adjust individually Variant Grid Editor
Pattern-based SKU generation Bulk Variant Fields
Manual SKU entry from list Variant Grid Editor

Troubleshooting

"Loading takes a long time"

  • Large selections with many variants take longer
  • Try selecting fewer products (20-50 at a time)
  • Variants are loaded in batches from Shopify API

"Some inventory columns missing"

  • Click Locations dropdown to show hidden locations
  • Maximum 10 locations can be displayed
  • First 3 are shown by default

"Changes not saving"

  • Check for validation errors (negative prices, etc.)
  • Verify network connection
  • Check Shopify API rate limits
  • Review error messages in status bar

"Inventory not updating"

  • Ensure variant has inventory tracking enabled
  • Check inventory item exists (some historical variants may lack this)
  • Verify you have write_inventory permission

"Weight not saving"

  • Ensure weight value is positive
  • Select appropriate weight unit
  • Variant must have inventory item for weight storage

Keyboard Shortcuts

Shortcut Action
F2 Enter edit mode
Enter Confirm edit
Escape Cancel edit / Close dialog
Tab Next cell
Shift+Tab Previous cell
Ctrl+C Copy
Ctrl+V Paste
Ctrl+S Save changes

See Also