EZ Exporter Update: New Customer and Order Fields

We've just pushed an update to EZ Exporter for exporting addiitional Customer and Order fields.

Most of the fields are related to email and SMS marketing.

Below is a list of the new fields that were added.

New Customer Fields

email_marketing_consent.consent_updated_at Email Marketing Consent Updated At (type: datetime). The date and time when the customer consented to receive marketing material by email. If no date is provided, then the date and time when the consent information was sent is …
Read more

Import Orders Using Our Prebuilt CSV Templates

One of the hardest parts about importing orders into Shopify using CSV files is the formatting of the file.  Our app, EZ Importer, has a flexible mapping system that works for the majority of use-cases (as long as the file's first row is a header row with column names and line items are on a separate row). Another big hurdle is getting started with a CSV file, especially if you're NOT importing orders from another Shopify store or platform.  …

Read more

EZ Inventory Update: New Scheduling Option

In the vast majority of cases, users of our EZ Inventory app just use the Hourly or Daily scheduler to constantly keep their Shopify inventory up to date with their suppliers' feed or other external feeds.

However, we've had some users ask us if they can turn off the inventory updates on weekends or only run them on specific days of the week.

We've added an option in EZ Inventory so our users can now pick which days of the …

Read more

EZ Exporter Update: Grouping and Aggregation Now Supports a LIST() Function

In addition to the MIN, MAX, SUM, MEAN, COUNT, and UNIQUE COUNT functions, EZ Exporter also now supports a LIST function.

This new function allows you to combine a group of field values in a JSON list/array.  If you're familiar with SQL, this is similar to MySQL's GROUP_CONCAT() function or PostgreSQL's STRING_AGG() function.

This enables creating summary reports where you can include a column including a comma-separated list of values from a grouped data.

Some examples:

  • Group orders by product …
Read more

EZ Exporter Update: Shopify Fulfillment Orders Export Now Available

EZ Exporter has supported exporting fulfillment locations from the Shopify order for some time now, but they were only available for orders or line items that were already fulfilled.

In the last couple of months, we've gotten more inquiries from merchants on how to export and filter based on the assigned/allocation location to fulfill the orders and line items from.

One use case for this is to allow merchants to create separate CSV exports to be sent to different warehouses for …

Read more