Shopify regularly pushes updates to their APIs which often involve new fields being added as well.

Below is a list of new fields we've added to EZ Exporter when exporting order data.  Many of these fields can be used in the filters as well.

• current_subtotal_price: Current Subtotal Price (type: number). The current subtotal price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
• current_total_discounts: Current Total Discounts (type: number). The current …

Shopify has supported Metafields for a long time now but there was no option to manage them directly via the Shopify Admin so merchants often had to use third-party apps to add/update metafields.

A recent update takes care of this where Shopify merchants can now manage metafields directly from the Shopify Admin wihout the need of an app or writing custom code to interact with the API.

Metafields allow merchants to attach additional attributes to resources such as products, variants, and …

Google Sheets has a "Pivot table" option which allows you to create summary reports from your existing data.

In this tutorial, we'll show you how to create a basic pivot table from a list of individual order data.

The pivot table will group the data by the "Created At" column and will display the following:

1. Number of orders per day.
2. Total quantity of all line items ordered per day.
3. Average order value per day.

Step 1: Select the range of data to summarize. …

It's no longer uncommon for Shopify merchants to have multiple fulfillment centers or locations to ship their products from.  When we first launched EZ Importer Shopify didn't even have support for multiple warehouse locations.  Now a days, it's much more common and something we hear more and more merchants asking about.  In order to help as many merchants as we can, we now allow you to add your location to your order when importing orders into Shopify.

Data Mapping

At this …

A QR code (short for Quick Response code) is a two-dimensional barcode that allows you store a lot more data compared to standard UPC barcodes.

You can easily scan it with your smartphone's camera and because almost everyone now has a smartphone, it's becoming more and more popular.

Because QR codes can store more data, this also allows for many more use cases.  They're especially very helpful as a shortcut for entering long texts where it's easy to make …