Import Shopify Product Metafields From a CSV on FTP

3 min setup

No coding required

Runs automatically

Updating SEO keywords, care instructions, or specs across hundreds of products by hand is slow and error-prone. This workflow watches a CSV on your FTP server and, for each new row, sets a product metafield in Shopify from the row's product ID and value, skipping rows with an empty value.

Use this template → Related article

FTP Fetch CSV File Row Created (Trigger)

Filter

Shopify Set Product Metafield

How it works

3 steps to bulk update Shopify product metafields from a CSV file on your FTP server

App connector: FTP • Time to complete: 1 minute

Check the CSV on the FTP server on a recurring interval and run once for each new row. Expect columns such as Product ID and SEO Keywords.

App connector: Filter • Time to complete: 1 minute

Continue only if the row has a product ID and the SEO Keywords value is not empty.

App connector: Shopify • Time to complete: 1 minute

Set a fixed metafield, for example namespace custom, key seo_keywords, type single line text, on the row's product ID, using the row's SEO Keywords value.

Trusted by 1,000+ merchants

Ready to bulk update Shopify product metafields from a CSV file on your FTP server

Get setup in 3 minutes.

Use this template →

FAQs

Can I import several metafields at once?

Yes. Add a column for each metafield and a Set Product Metafield step for each one, or add namespace and key columns and map them per row.

Can I update variant metafields too?

Yes. Use Set Product Variant Metafield with a Variant ID column instead of the product ID.

What if a row has no value?

The filter skips it, so blank cells never wipe out a metafield that already has a value.

Personalize this template

Customize this workflow even further:

Look up products by SKU

If your CSV has SKUs instead of product IDs, add Retrieve Product Variant Details from SKU before setting the metafield.

Log what changed

Add a final step that writes each updated product ID and value to a results CSV on the same FTP server.

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

Rothy's

bulk update Shopify product metafields from a CSV file on your FTP server

3 min setup • Fully supported if you need help