Metafield problem using csv imports

Topic summary

A user needs to bulk edit approximately 4,000 out of 13,000 products in their Shopify store and asks about the proper file format and whether their Metafield Guru app can help.

Another participant confirms that CSV files are the solution, formatted with Shopify’s standard column structure (Handle, Title, Variant SKU, Price, Inventory, etc.). Only columns being modified need to be included.

Recommended workflow:

  • Export products via Shopify Admin > Products > Export to get the correct format
  • Edit the CSV in Excel or Google Sheets
  • Re-upload to Shopify, or use Metafield Guru’s import/export feature for custom metafield updates

Metafield Guru is particularly useful for editing product details beyond Shopify’s basic fields (descriptions, dimensions, special tags). The question appears resolved with a clear action plan provided.

Summarized with AI on October 31. AI used: claude-sonnet-4-5-20250929.

We have over 13,000 parent items in our store and currently need to bulk edit about 4,000.

can we upload a list and what format does it have to be in to accomplish this?

We also have the app Meatfield guru if there are any solutions using that.

you can bulk edit your 4,000 products by uploading a CSV file in Shopify. The file needs to be formatted with the same column structure Shopify uses, which includes things like Handle, Title, Variant SKU, Price, Inventory, etc. If you’re making specific edits, you only need to include the columns you’re changing.

Since you have Metafield Guru, you can also bulk update your custom metafields using their import/export feature. That means if you’re editing product details beyond the basic Shopify fields (like extra descriptions, dimensions, or special tags), you can use Metafield Guru to do it faster.

  • Export a CSV of your products from Shopify Admin > Products > Export (so you have the right format).
  • Make your changes in Excel or Google Sheets.
  • Upload the file back to Shopify or use Metafield Guru if updating metafields.