EZ Exporter: Option to Never Use Quotes in Shopify CSV Exports

By default, EZ Exporter uses "minimal quoting" when exporting Shopify data to CSV. This means that quotes will only be added to the fields if the data contains characters that could break the CSV parsing, such as line breaks/newline characters or a character that conflicts with the data separator/delimiter.

For example, if you're using semicolons as the delimiter and a field data also contains a semicolon, then this field will be automatically enclosed with quotes when the CSV file is …

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

EZ Exporter: Built-In Export Templates Now Available

EZ Exporter just got easier to use!

We're really excited to announce that our app now has support for built-in templates, making it super-easy to get started with our app! Just select a template and a pair of Export Profile and Data Settings will be created from that template, with most (if not all) of the things you'll most likely need already configured for you. You can then modify them at any time to customize them further.

It's also a …

Read more

Retrieving Shopify Discount Data on the Line Item Level with EZ Exporter

Shopify recently updated their Order API and it now provides more information about the discounts applied to the order on the line item level.

There's actually a field called total_discount under the line items data for a long time, but it's a bit misleading as it only applied to line item discounts when using the Shopify POS and not for web orders. With this API update, we can now pull the discount amount and discount codes that were applied to …

Read more

Grouping and Aggregating Your Shopify Data with EZ Exporter

Grouping and aggregating data is now available in EZ Exporter!

This feature allows you to generate all kinds of summary reports to get more insights from your Shopify data. Below is just small list of the different types of reports you can now create thanks to this new feature:

  • Sales by Hour, Week, Day, Month, Year, Day of Week (which days have the highest sales, for example)
  • Sales by Customer, Customer Lifetime Value (CLTV), Average Order Value
  • Sales by …
Read more