Formula recipe

Fix messy product titles in seconds

=PROPER(raw_title)

Supplier titles in all caps or all lowercase? PROPER fixes the casing and FlexSync sends clean titles to Shopify.

FormulaPROPER
Shopify fieldTitle
Tested resultTitle fixed in Shopify
4.9/5 on Shopify App Store
Built for Shopify
20 formula cells free
How it works

Consistent titles across the whole catalog

Keep the raw title in its own column or the supplier's sheet. PROPER, TRIM and SUBSTITUTE turn it into a clean title.

  • Title Case in one formula
  • Strip extra spaces with TRIM
  • Fix small words with SUBSTITUTE
Copy and paste

Ready-to-use variations

Native Google Sheets formulas. Paste one in the yellow column and fill down.

=PROPER(AA2)

Title Case

Capitalize every word.

=TRIM(PROPER(AA2))

Title Case, no extra spaces

Removes double spaces from supplier data.

=SUBSTITUTE(PROPER(AA2)," With "," with ")

Keep small words lowercase

Title Case without the awkward With.

Good to know

Tips before you start

Needs a source column

A title can't reference itself. Point PROPER at a raw title column or a supplier sheet.

Tested with a supplier sheet

We tested =PROPER(VLOOKUP(id,IMPORTRANGE(url,range),4,0)) and the title updated in Shopify.

Check brand names

PROPER changes iPhone to Iphone. Use SUBSTITUTE for brand names.

Setup

Up and running in three steps

1

Turn on formulas

In FlexSync, open Settings, then Advance Settings, and switch on Allow Sheet Formula.

2

Paste the formula

Add it to the first row of the yellow column you want to change.

3

Fill down

Drag it down the column. FlexSync sends each result to Shopify.

Questions

Frequently asked questions

Still have questions? Our support team is available 24/7 at support@flexsync.app.

No. Shopify keeps the existing handle when the title changes.

Yes. Join text with &, for example =PROPER(AA2)&" | Brand".

In a column you add to your Sheet, or in your supplier's sheet via IMPORTRANGE.

Let your formulas run your store

Free plan includes 500 SKUs and 20 formula cells.