Shopigent Shopigent
← All posts

Use case: bulk editing products from a spreadsheet

Shopify's bulk editor is powerful but limited to what it shows in the grid. With Shopigent + an MCP agent, you can update any field on any product — based on a spreadsheet you already have.

The workflow

Step 1: Export a CSV from Shopify (or prepare one in Google Sheets).

Step 2: Feed it to your agent with clear instructions.

Step 3: The agent reads each row, matches the product in Shopify, and applies the change — always with dry-run first.

Example: price update from a CSV

I have a file called prices.csv with columns: SKU, new_price.

For each row, find the matching product in Shopify by SKU. 
Dry-run updating the price to new_price. Report back any SKUs 
that don't match before you execute.

Example: bulk tag addition

Add the tag "winter-2026" to every product in the "Winter Collection" 
collection. Show me how many products will be affected, then dry-run
before executing.

Example: SEO meta update

Read meta-descriptions.csv (columns: title, new_meta). For each row, 
find the product by title and update its seo.description to new_meta. 
Skip any products that already have the same meta.

Example: multi-lingual translation

Export all products. For products where the Spanish description 
is missing, translate the English description using the product's 
tags as context. Dry-run the first 5 translations for review.

Tips for spreadsheet operations

Always use SKU or GID

Product titles change. Use the SKU or the Shopify GID (gid://shopify/Product/123) to match rows reliably.

Dry-run first

Add dryRun: true to every bulk update. The agent will preview every mutation without touching your store.

Batch by category

Split large spreadsheets into batches (e.g. 20 products at a time) to review before committing.

Process the first 20 rows and stop for review. If the output 
looks right, I'll tell you to continue with the next 20.

Use filters to narrow scope

List products in "Electronics" with inventory > 10. Export their 
SKUs and current prices, then reduce each price by 15%.

This avoids updating products that shouldn't change.

Why this works

Shopigent's update_product tool supports every field: title, description, price, compareAtPrice, tags, status, SEO, metafields, and more. Combined with dryRun, you get the power of a full API client without writing a single GraphQL query.