Add PO Numbers and Mark Orders Tax Exempt with EZ Importer

With our latest release of EZ Importer, you can add PO Numbers to your order and mark orders tax-exempt.

Add PO Numbers To Your Orders

There is a new field, po_number, on the Order Details tab of your data mapping.  You can map this field to the column in your file with your PO Number.  This field was recently added to Shopify's Order API and is currently displayed on the orders timeline (although this could change in the future).   …

Read more

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