We've gotten a few customer questions recently regarding exporting gift card information applied to the Shopify order.

One customer needed to export the last 4 characters of the gift card code that was used to pay for the order and another needed the amount paid by gift card. These data are stored in the order transaction data provided by the Shopify API and our app has functions that can be used in the Calculated Fields to retrieve them, but we …

You can now export the fulfillment location names and IDs at the line item level from your Shopify order data with EZ Exporter.

The fulfillment location IDs had been available at the order level for some time now and but we've recently received a request to be able run sales reports by product and fulfillment location. To do this, we needed to parse the fulfillment data returned by the Shopify API and match them up with the line items …

In addition to being able to export your Shopify data to a custom CSV file, EZ Exporter also now supports exporting directly to Excel format. Both the old XLS (Excel 97-2003) and the newer XLSX (Excel 2007 or later) formats are supported.

While pretty much any spreadsheet application can read CSV files, there are instances where the file needs to be specifically in Excel format as certain systems that need to process the file only support Excel formats. A common …

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 …

We've recently pushed an update to EZ Exporter to provide an option to include inventory levels from multiple Shopify locations as part of the product data export.

When you go to the Data Settings in EZ Exporter, you'll now see the following new fields:

• variants.inventory_levels
• variants.inventory_levels.available
• variants.inventory_levels.location_id
• variants.inventory_levels.location_name
• variants.inventory_levels.updated_at

By default, the fields that start with variants.inventory_levels. such as variants.inventory_levels.available will include the values from all locations separated by a comma. To split them up in separate columns in the …