---
title: "Clean up product titles"
id: "1117"
type: "page"
slug: "shopify-clean-product-titles"
published_at: "2026-11-15T03:05:30+00:00"
modified_at: "2026-11-15T03:05:30+00:00"
url: "https://flexsync.app/formulas/shopify-clean-product-titles/"
markdown_url: "https://flexsync.app/formulas/shopify-clean-product-titles.md"
---

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.

[Start for Free](https://apps.shopify.com/flex-stock-sync/install?utm_source=flexsync.app&utm_medium=formula-page&utm_campaign=shopify-clean-product-titles)
[See how it works](#how)

[#](#)

Formula**PROPER**

Shopify field**Title**

Tested result**Title 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

Titles · FlexSync**Synced**

fx`=PROPER(AA2)`

| 1 | Raw title | Title |
| --- | --- | --- |
| 2 | raystreak 5'7 soft surfboard | Raystreak 5'7 Soft Surfboard |
| 3 | DAWN PATROL CHEST ZIP | Dawn Patrol Chest Zip |
| 4 | flashbomb hooded wetsuit | Flashbomb Hooded Wetsuit |

Shopify admin

### Raystreak 5'7 Soft Surfboard

Title**Title Case *Updated***

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.

[Read the formula guide](/docs/how-to-enable-and-use-flexsync-shopify-formula-feature/)

More recipes## More formulas that change your store

[Auto-draft sold-out products =IF(On_hand=0,"DRAFT","ACTIVE") Explore →](/formulas/shopify-auto-draft-out-of-stock/)
[Sitewide sale pricing =Compare_at*0.85 Explore →](/formulas/shopify-sale-pricing-formula/)
[Supplier price sync =IMPORTRANGE(supplier_url,"Sheet1!B2") Explore →](/formulas/shopify-supplier-price-sync/)
[Cost-plus pricing =VLOOKUP(SKU,Costs,3,0)*1.6 Explore →](/formulas/shopify-cost-plus-pricing/)
[Auto-tag low stock =IF(Available<10,"low-stock","") Explore →](/formulas/shopify-low-stock-tags/)
[Generate SKUs ="FB-"&RIGHT(Variant_id,6) Explore →](/formulas/shopify-auto-generate-skus/)

Questions## Frequently asked questions

Still have questions? Our support team is available 24/7 at [support@flexsync.app](mailto:support@flexsync.app)
.

### Will this change my product URL?

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

### Can I add a brand or size to every title?

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

### Where do I keep the raw titles?

    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.

[Install FlexSync Free](https://apps.shopify.com/flex-stock-sync/install?utm_source=flexsync.app&utm_medium=formula-page&utm_campaign=shopify-clean-product-titles)
[See pricing](/pricing)

×
