Google Sheets has an INDIRECT function that lets users use relative row references in formulas.

For example, instead of using a formula like =A2+B2, you can replace the row numbers with a variable referencing the current row. This way, you don't have to worry about whether the references for the current row are correct if your formula only deals with data in the current row.

This is particularly useful if you're pushing the …

As of April 2022, Shopify has changed how the customer accepts marketing flag works and has updated to a modern fulfillment workflow. This has two effects on EZ Importer; we now need to make a second call to Shopify when using the buyer_accepts_marketing flag and we no longer support adding multiple tracking numbers to orders.

Buyer Accepts Marketing

Shopify has migrated the customer.accepts_marketing flag to two new fields called email_marketing_consent.state and email_marketing_consent.opt_in_level. At this time EZ …

We've just pushed an update to EZ Exporter's scheduling options to allow our users to select the specific days of the week to run an export for the following schedule types:

• Every 15 Minutes
• Every 30 Minutes
• Hourly
• Daily

Some of our users have requested this option as they wanted to pause the automated exports on weekends or on specific days. 

You could technically accomplish this in the past by using …

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

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. …