Export Shopify Order Fulfillment Locations at the Line Item Level With EZ Exporter

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 …

Read more

Export Your Shopify Data to Excel With EZ Exporter

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 …

Read more

EZ Exporter: Removing Non-Numeric Characters From Your Shopify Data

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 …

Read more

Automatically Export Your Shopify Multi-Location Inventory Data to CSV With EZ Exporter

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 …

Read more

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