Need Help creating automation for Metafileds for size description

Shopify Discussion

Topic summary

A multi-channel shoe retailer is restructuring their Shopify inventory to handle complex sizing across different brands (Dr. Martens, Birkenstock, Converse, Vans) that use varying systems (US, UK, Euro) and unisex formats.

Proposed Solution:

  • Simplify the main size field to show only the brand’s native size (e.g., “41” for Birkenstock)
  • Create variant metafields to store detailed conversion information:
    • “Size Description” (e.g., “Euro 41 = Men’s 8 US / Women’s 10 US”)
    • “Men US Size” and “Women US Size” (numeric values)
    • “Width Description” for width variants
  • Map these metafields to storefront display and marketplace feeds (eBay, Walmart)

Automation Need:
Seeks to create rules that automatically populate metafields based on brand, gender, size, and width combinations when products are imported.

Key Questions:

  • Can Shopify Flow reliably handle this metafield automation?
  • Should a dedicated app be used instead?
  • Requesting help with Flow logic/formulas if it’s the appropriate tool

The discussion remains open with no responses yet. An attached screenshot shows the current size description format.

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

We sell brand-name shoes for men, women, and children through multiple channels including our website (nyck.com), Amazon, eBay, Walmart, Shopify, and a physical retail store. One of our biggest challenges is managing shoe sizes across various brands, as they often use different sizing systems (US Size, Euro Size, UK Size) and many styles are unisex.

Examples of sizing systems used by brands:

  • Dr. Martens: UK sizing (e.g., UK 5 = Men’s US 6 / Women’s US 7)

  • Birkenstock: European sizing (e.g., EU 41 = Men’s US 8 / Women’s US 10)

  • Converse: Unisex sizing (e.g., US 9 = Men’s 9 / Women’s 11)

  • Vans: Unisex sizing (e.g., US 9 = Men’s 9 / Women’s 10.5)

Currently, size information is being pushed to Shopify from our inventory system, but the format is inconsistent and confusing. I’ve decided to switch and use Shopify as our primary inventory source going forward.

Inventory Restructuring Plan:1. Standardize Size Format:

For example, with Birkenstock, instead of showing “Euro 41 = Men’s 8 US / Women’s 10 US” in the size field, I’ll simplify it to just “41”.

  1. Use Variant Metafields:

    • Create a metafield called “Size Description” and move the detailed sizing info there (e.g., “Euro 41 = Men’s 8 US / Women’s 10 US”).

    • Add metafields: “Men US Size” and “Women US Size”, populated with values like 8 and 10 respectively.

  2. Width Description:

    • Add a metafield for “Width Description”.

    • For Birkenstock widths:

      • R = “Regular/Wide”

      • N = “Medium/Narrow”

Tools Needed:- I need a reliable bulk editing app (like Matrixify) or a Shopify Flow automation to help restructure and update existing product variants efficiently. Recommendations are welcome.

Website + Channel Integration:- Once variant metafields are set, I want to map these fields to display on my storefront, and push them to eBay and Walmart listings instead of relying on the standard “Size” field.

see bellow

Size Description.jpg
Size Description.jpg1694×693 88.5 KB

Automation Requirements:

After cleaning up the current inventory, I want to create an automation rule. For example:

If a product from Birkenstock is imported and the gender is Unisex, the size is 41, and the width is R, then:> > - Set Size Description metafield to: “Euro 41 = Men’s 8 US / Women’s 10 US”> > - Set Width Description to: “Regular/Wide”> > - Set Men US Size metafield to: 8> > - Set Women US Size metafield to: 10

I’m trying to figure out:

  • Can Shopify Flow handle this kind of automation reliably?

  • Or should I use a dedicated app for automating product imports and metafield population?

  • If Flow is sufficient, I’d appreciate help with the logic or formula needed to set it up.

2 Likes