EZ Exporter: January 2024 Updates

Below is a list of changes to EZ Exporter that we've pushed in the last couple of months.

New Order Fields

  • confirmation_number (A randomly generated alpha-numeric identifier for the order that may be shown to the customer instead of the sequential order name. This value isn't guaranteed to be unique.)
  • po_number (The purchase order number associated to this order.)
  • tax_exempt (Whether or not an order was exempt from taxes. Value is either True or False.)

New Templates

  • Items Fulfilled …
Read more

EZ Inventory: Map Products in Your Supplier Feed to Shopify Variant Metafields

There may be cases where your supplier uses a different SKU or barcode from what you use in your Shopify store.  Using Shopify Variant Metafields is a good way to track these. With this EZ Inventory update, you now have the option to map product variants in your Shopify store to products in your suppliers' feeds based on a custom variant metafield's value.

In the Data Feed settings, you can find this option under Field Mapping > Shopify Variant Field.  Select the …

Read more

EZ Importer's Predefined CSV Templates Now Support Fulfilled and Unfulfilled Orders

In order to help get you started, EZ Importer has a set of predefined templates for merchants not migrating from another platform or Shopify store.  Previously, when importing orders using these templates, the orders would always be marked fulfilled.  We've recently updated the templates to work with Fulfilled and unfulfilled orders, or you can map your fulfillment status.

Selecting Your Fulfillment Status

Our predefined templates do the data mapping for you and allow you to download the CSV file with the mapped …

Read more

How to Split a Comma-Separated List of URLs From a Column Into Separate Rows in Google Sheets

If you have a spreadsheet that has a column with a comma-separated list of values (like URLs), you can easily combine them and create a separate row for each one in Google Sheets using a formula like this:

=TRANSPOSE(SPLIT(JOIN(",", Sheet1!B2:B), ","))

The formula above references column B of Sheet1, where each row's Column B is a comma-separated list of URLs for each product on a Shopify store.

Here's what the formula does:

  1. JOIN(",", Sheet1!B2:B): This part of the formula combines all …

Read more

Built-in Data Feed Templates Now Available in EZ Fulfill

Today, we're excited to announce that EZ Fulfill now has built-in templates to make it easier to get started.  If you're familiar with EZ Exporter and EZ Importer, then you've had experience with our built-in template system and are probably familiar with how much time this feature could save you.

You can download the template file, which will be in CSV or Excel format (depending on the template you are using), or use the template to create a data feed.  …

Read more