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 with images would …

Read more

Shopify Tip: How to View the Raw JSON Data of an Order, Product, or Customer Through the Shopify Admin

Did you know that you can view the raw data of an order, product, or customer by simply appending ".json" to the URL while logged in to the Shopify admin?

This is a pretty neat trick as it allows you to view data that's not even visible in the Shopify Admin pages. The data shown here is in JSON format, which is basically the same data that you'll see when using the Shopify API.

All you have to do is: …

Read more