Skip to content

Instantly share code, notes, and snippets.

@tpage99

tpage99/google_sheets_tips.md

Last active September 1, 2022 12:59
Show Gist options
  • Save tpage99/663c1b3bba701e6be461fbe759292943 to your computer and use it in GitHub Desktop.
Save tpage99/663c1b3bba701e6be461fbe759292943 to your computer and use it in GitHub Desktop.
Download ZIP
Helpful rules for Shopify Exports
Raw
google_sheets_tips.md

Helpful Tips for Shopify Exports

Shopify provides CSV exports/imports for various resources (products, URL redirects, etc). Here are some handy rules when manipulating data from old sources such as when updating during the course of a platform migration to Shopify

Add two columns together

=CONCAT(firstItem, secondItem)

Remove all special characters

=REGEXREPLACE(selection, "[^a-zA-Z0-9 ]", "")

Handleize

=REGEXREPLACE(selection, "\b \b", "-")

Lowercase

=LOWER(selection)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment