Replace data in Shopify in bulk with the Find and Replace feature

Mixtable’s Find and Replace feature allows you to find and replace specific text in bulk within a specific column. While you can find and replace text in any column in any worksheet, this feature is particularly useful when you are looking to bulk find and replace a word/phrase in your product descriptions, SEO title, SEO description, and option values. Find and Replace is also a super-fast way to rename a tag.

The Find and Replace feature will only modify cells/rows that are currently visible in the spreadsheet. So, if you have applied a filter to your data, only the data that is visible will be considered.

Open Find and Replace

There are two ways to open it:

• In the menu bar, choose Bulk Edit > Find and Replace
• Right-click a column’s letter and choose Find and replace…. The window opens with that column already chosen

Replace text in a column

In the Find and Replace window you’ll see a few inputs:

• Select column - this is how you choose which column in the currently active worksheet the Find and Replace will work on
• Find this - this is where you enter the word(s) that you are looking to replace
• Replace with this - this is where you enter the word(s) you want to replace with
• Case-sensitive match - whether you want to match words in a case sensitive manner. For example, whether a search value of “Organic Apple” should be strict about the capitalization of O and A, or whether it should also match “organic apple” (lowercase)
• Match whole words only - whether you want to only replace whole words that match your “Find this” value, or whether you also want to match parts of words. For example, whether replacing “butter” should only replace the specific word “butter”, or whether it should also replace the “butter” in “butterscotch”
• Preview first 10 rows - on by default, this shows the first 10 visible rows of the worksheet before and after the change. This way you can preview what the output will be before you make it real

When everything looks right, click Update Spreadsheet. Mixtable replaces the text in your spreadsheet, but nothing changes in Shopify yet. Click Sync at the top right of the spreadsheet, review your changes in the preview that opens, then click Sync again.