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. Ask it to call the write with dryRun: true first; that preview is not executed.

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 can change title, description, status, vendor, product type, tags, SEO title and description, URL handle, and template suffix. It does not set price, compare-at price, or metafields. Price changes use update_product_variant_price or bulk_update_prices. Metafields use set_product_metafields. A dry-run previews the call and does not write.