EZ Exporter: Removing Non-Numeric Characters From Your Shopify Data

We've recently added a new Calculated Fields function in EZ Exporter for automatically stripping out non-numeric characters: strip_non_numeric_chars()

We've added this as one of our customers needed a way to export phone numbers to CSV containing only the numbers as they needed to import the data into another system that only accepts numbers. Shopify allows certain characters such as parentheses and dashes for phone numbers and this function will clean all these up automatically.

The usage is fairly simple. For …

Read more

Export UTM Parameters From Your Shopify Order Data to CSV With EZ Exporter

One way to keep track of how well your marketing campaigns are doing is by using UTM parameters. Our app EZ Exporter now supports a function for extracting individual UTM parameters and place them in separate columns in the CSV file to make it easier for you to analyze the data.

UTM parameters are basically just these additional strings that you add at the end of a URL in the format of key=value so you can parse them later …

Read more

Instagram Shoppable Posts and You

The internet sure does like to make things easy. Particularly, Instagram makes things easy. Instagram is an ecommerce store owner’s best friend and it is a huge platform to spread your ecommerce business. Almost everyone is on Instagram and it’s not surprising why─it’s great for enjoying some visually stunning pieces of photography. Because the social media giant is an expert at using the visual senses to grasp one’s attention, it takes advertising and marketing to an entirely different level. It’s …

Read more

Generating a Google Shopping Feed From Your Shopify Data

These last couple of weeks, we've gotten requests from some of our customers to help them set up a Google Shopping product data feed using our EZ Exporter app. I guess it makes sense as it's now the holiday shopping season and Shopify merchants are looking for ways to increase their revenue.

It's actually not as simple as it may seem as some fields have very specific requirements in the format and it's not always obvious which field in the …

Read more

How to Display Images from URLs in Your CSV File Using Google Sheets

Did you know that you can load images directly in Google Sheets from URLs?

Google Sheets provides an IMAGE() function that lets you do just that. The usage is very simple, basically just enter the URL inside the IMAGE() function surrounded by double quotes like this:

=IMAGE("https://highviewapps-main-site.s3.amazonaws.com/media/blog/thumbnails/postcards.jpg.800x400_q85_crop-smart.jpg")

This could come in handy for running your Shopify store. For example, you may need to generate a daily order picking list for your warehouse staff where printing a report …

Read more