When generating a CSV/Excel export of your Shopify data to be sent to third parties such as a supplier or another platform, the recipient may require the content of certain fields to be formatted in a certain way.

For example, some systems may require fields such as the shipping address to include only official abbreviations. There may also be cases where the system receiving the data only supports ASCII characters and if your customer base is global, you'll most likely …

By this point in time we should all have conceded to the fact that Google in almost any form is exceedingly helpful when trying to run an online business. Whether it’s helping us determine the trends we may want to use or helping us with our site’s search engine optimization, Google can do no wrong. In fact, it’s always right and to not take advantage of Google and its tools would be folly. There are countless tools that you …

When viewing records in the Shopify admin, you might notice that most of the pages don't show you how many total records are there.

One way to figure out the number of records is to do a CSV export, but this could be annoying as you usually have to wait for the CSV file in the email, unzip the attachment, open the file, and then look at the rows.

Luckily, there's a quicker and easier way to get this by …

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 …

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 …