The Spreadsheet Editor

A familiar Excel-like grid interface for editing metafields across multiple resources simultaneously.

Accessing the Editor

Navigate to Shopify admin → Apps → Metafield Studio → Spreadsheet → Open editor

Interface Overview

The editor consists of 8 control groups:

Control	Purpose
Resource type selector	Switch between products, orders, pages, etc.
Saved searches	Quick access to saved search configurations
Column selector	Add metafield and standard property columns
Resource list	Displays selected items (width adjustable)
Advanced filters	Tools for precise targeted updates
Settings	Configure editor behavior and preferences
Pagination controls	Navigate pages (max 50 items per page)
Action buttons	Save, discard, or close the editor

Configuring the Grid

Adding Metafield Columns

Press "Select columns" to access:

• From templates and definitions Select from your configured metafield templates and definitions
• From other resources Copy column configurations from existing resources
• Manual specification Enter type, namespace, and key directly

Adding Standard Property Columns

Access the standard properties tab to add columns for built-in Shopify attributes. These columns support viewing, copying, and pasting but are read-only.

Removing Columns

Use the trash icon in the selection menu, or the [...] and X buttons in the grid header.

Editing Metafields

Single Cell Editing

Click any cell to activate editing mode. Active cells display 4 utility buttons:

1. Assign to column Apply the value to the entire column (current page only)
2. Copy Copy the value to clipboard
3. Discard Revert changes to this cell
4. Clear Remove the cell value

Bulk Editing

Edit entire columns or select multiple cells simultaneously for batch changes.

Saving Changes

Click the Save button to persist all changes to Shopify.

Keyboard Shortcuts

Key	Action
Arrow keys	Navigate between cells
Enter	Move to the next cell in the same column
Tab	Move to the right
Del / Backspace	Clear cell values
Ctrl+Z / Cmd+Z	Undo last action
Ctrl+Shift+Z / Cmd+Shift+Z or Ctrl+Y / Cmd+Y	Redo last action
F2	Undo (works inside cells)
F3	Redo (works inside cells)

Undo and Redo

The spreadsheet editor tracks your changes and lets you step backward or forward through them.

• Ctrl+Z (Windows) or Cmd+Z (Mac) undoes your last action. This shortcut works when you are navigating the grid but not while typing inside a cell — in that case the browser handles its own text-level undo.
• Ctrl+Shift+Z / Cmd+Shift+Z or Ctrl+Y / Cmd+Y redoes a previously undone action, with the same restriction.
• F2 (undo) and F3 (redo) work everywhere, including while you are editing text inside a cell. Use these shortcuts when you need to undo or redo a grid-level change without leaving the cell you are typing in.

Spreadsheet Compatibility

The editor supports copy and paste between:

• Google Sheets
• Microsoft Excel
• The Metafield Studio spreadsheet editor

You can copy data from an external spreadsheet and paste it directly into the grid, or copy grid data to an external spreadsheet.

API Limitation

The spreadsheet editor displays a maximum of 50 items per page due to Shopify API constraints.