Skip to main content

How to Upload Multiple Size Charts at Once (Bulk Upload)

Upload all your size charts in one go. Follow the step-by-step guide to map columns, match products, and go live in minutes.

Overview

The Bulk Upload feature lets you upload all your size charts in a single file, no need to create each chart manually inside the app. Once uploaded, Measmerize walks you through a guided process to map your columns, name your charts, match them to your products, and configure the recommendation experience.

You can use any file format you're already working with. Our tool is designed to recognise most column structures and naming conventions, so you rarely need to reformat your data from scratch. The step-by-step process takes care of the rest.

Before You Start

Download the template (optional)

We provide a master template that covers every supported column type, measurements, size conversions, custom fields, and product metadata. It's a useful reference if you're building a file from scratch or want to understand exactly what our system expects.

That said, you don't need to use it. If you already have a size chart file in your own format, upload it as-is and the mapping step will help us understand your structure.

Step-by-Step: The Bulk Upload Process

Step 1: Upload your file

Go to Size Charts in your Measmerize dashboard and click Bulk Upload. Drag and drop your Master size chart file or click to browse.

The app accepts .xlsx, .csv, .tsv, and .txt files.

⚠️ Note that if your Excel file contains multiple sheets, we will only consider the first one.

Step 2 — Map your columns

Once your file is uploaded, you'll first be asked two quick questions that apply to the entire file:

  • Unit of measurement: are your values in centimetres (cm) or inches (in)?

  • Dimension type: are the measurements taken on the garment (product dimensions) or on the customer's body (body dimensions)?

⚠️ These settings apply globally to all charts in the file. If you need to upload charts with different units or dimension types, run separate uploads.

Once confirmed, Measmerize reads your file's structure and presents the column mapping interface. Each column from your file is shown on the left, you assign it to the corresponding Measmerize field in the center.

How this works:

  • Fields like Chest, Waist, Hips, and standard size conversions (EU, UK, US…) are recognised automatically in most cases.

  • Columns we can't identify are flagged for manual mapping, you simply select the correct field from a dropdown.

  • Unrecognised fields can be mapped to our custom columns, you then just need to confirm the client facing column title.

  • Any column you don't need can be crossed out and ignored.

💡 You don't need a perfect file and title headers. If a measurement column is labelled "Chest Width", "Bust" or "Poitrine" instead of "Chest", the tool will still suggest the right match.

Step 3 — Identify your size charts

This step groups your rows into individual size charts. Measmerize needs to know which rows belong to the same chart.

You'll be asked to select the column that acts as the unique chart identifier, this is typically a column called Chart Name, Style ID, SKU, or Product Name. Every row sharing the same value in that column will be grouped into one size chart.

Step 4 — Categorise your charts

For each identified chart, you can assign:

  • Macro category: Apparel, Footwear, or Belts

  • Target gender: Men, Women, Unisex, Kids, Babies & Toddlers

  • Intended fit: Regular, Slim, Relaxed, Oversized (optional — relevant for product dimensions charts only)

If you included these columns in your file, Measmerize pre-fills them and you simply review. If not, our tool tries to make a guess from information it can find in other columns; in any case you will be asked to verify and confirm these assumptions here.

Step 5 — Validate

Before anything is saved, Measmerize runs a validation check on your file. Any issues are surfaced here with clear explanations.

What gets checked:

  • Measurement columns contain numeric values only

  • No duplicate size labels within the same chart

  • Required fields (chart identifier, at least one measurement) are present

  • Range values use the correct format (e.g. 80-84)

  • Value increase from smaller sizes to bigger sizes

  • Dimensions expected to match real body/product dimensions

Errors must be resolved before proceeding. Warnings can be acknowledged and skipped if they don't affect your use case.

Step 6 — Match products

This step links each size chart to the relevant products in your Shopify store. There are two matching strategies:

Strategy A: Direct title match (1:1)
If your chart name matches the product title, Variant SKU name, Product Handle, or the Barcode exactly in Shopif, Measmerize matches them automatically. No extra setup needed.

Strategy B: Metafield match (1:many)
If one chart covers multiple products (e.g. all women's tops share the same chart), matching is done via a Shopify metafield. Your products need to have a metafield value (e.g. custom.custom_size_chart_name) already set in Shopify, and that value must match the Metafield Matching Key in your upload file. The metafield key shown here is an example, your store may use a different one.

Unmatched charts are flagged. You can resolve them by editing the match manually or returning to fix the file later.

Step 7 — Choose your experience

This is a global selection that applies to all charts being uploaded. You choose how the Measmerize widget appears and behaves across your storefront:

  • Full Size Hub — shoppers see the full Measmerize experience: a size recommendation, a smart size chart.

  • Size Advisor only — shoppers get a personalised size recommendation based on their measurements, without the full chart view.

  • Smart Size Chart only — shoppers see a size chart without a full recommendation flow.

Step 8 — Optimise

This step lets you calibrate the recommendation engine based on your brand's knowledge of how their products fit.

You tell us which size you would expect a customer with a specific body profile to wear in your product. This helps Measmerize align its recommendations with your brand's sizing intent, rather than relying on measurements alone.

Important:

  • Footwear charts: optimisation is required before your charts can go live. Footwear sizing relies heavily on brand-specific calibration to give accurate recommendations.

  • Apparel charts: optimisation is not required to publish, but strongly recommended. Skipping it means recommendations are based on measurements only, without your brand's fit knowledge factored in.

You can always return to this step later from your Size Charts dashboard to adjust or complete optimisation after going live.

Step 9 — Done

Your size charts are live. The Measmerize widget on your storefront will now display size recommendations for all matched products.

You can return to Size Charts at any time to edit, re-upload, or add new charts.

File Building Best Practices

Getting your file right the first time saves time at the validation and matching steps. Here's what to keep in mind.

Mandatory — your file won't work without these

1. One size per row
Each size must be on its own row. If a chart has XS through XXL, that's six rows. Repeat the chart identifier on every row.

Chart Name       | Size | Chest | Waist
Women's Tops     | XS   | 82    | 64
Women's Tops     | S    | 86    | 68
Women's Tops     | M    | 90    | 72

2. One measurement per column, numeric values only
Each body part or dimension needs its own column. Values must be numbers — no units, no text, no mixed content.

95 — correct
95 cm — will fail validation
Fits 90-95 — will fail validation

3. A size chart identifier column
You need at least one column that groups rows into the same chart — a chart name, style code, SKU, or any consistent reference. Without it, the system can't tell where one chart ends and another begins.

4. Use a hyphen for ranges
If a size covers a range of measurements, write it as 80-84. Measmerize automatically calculates the midpoint for recommendation logic.

80-84
80 to 84
~82

Tips for faster processing

Add category, gender, and fit attributes
Including a Macro Category, Target Gender, and Intended Fit column in your file means Measmerize pre-fills the categorisation step automatically. Without them, you assign these manually for every chart.

Cover your full size range
Include every size available in your Shopify store — from your smallest to your largest (e.g. XS through 3XL, EU 36 through 46). Gaps in the size chart mean shoppers with measurements outside the covered range won't get a recommendation.

One dimension type per upload
If your catalogue uses both body dimension charts and product dimension charts, that's fine — you'll just need to upload them separately. Each file should contain one type only.

Not sure which to use? We generally recommend body dimensions as your default. Here's why →

⚠️ Never mix product and body dimensions within the same file.

Use cm or inches — not both
Pick one unit for the entire file. Do not mix.

Did this answer your question?