Metafield problem using csv imports

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.