We've recently pushed an update to EZ Exporter to include additional product fields in the Order data exports.

To be able to do this, we had to "join" the product data with the order data. This involves making additional Shopify API calls to pull those product data so this could slow down the report generation quite a bit if you have a lot of orders and products.

The following fields can now be selected in the Order Data Settings' "Fields" section:

• Lineitem Product Handle (line_items.product.handle)
• Lineitem Product Type (line_items.product.product_type)
• Linetem Product Tags (line_items.product.tags)
• Lineitem Variant Barcode (line_items.variant.barcode)
• Lineitem Variant Option 1 (line_items.variant.option1)
• Lineitem Variant Option 2 (line_items.variant.option2)
• Lineitem Variant Option 3 (line_items.variant.option3)
• Lineitem Variant Position (line_items.variant.position)
• Lineitem Variant Inventory Management (line_items.variant.inventory_management)
• Lineitem Variant Inventory Policy (line_items.variant.inventory_policy)
• Lineitem Variant Inventory Quantity (line_items.variant.inventory_quantity)
• Lineitem Variant Compare At Price (line_items.variant.compare_at_price)
• Lineitem Variant Grams (line_items.variant.grams)
• Lineitem Variant Weight (line_items.variant.weight)
• Lineitem Variant Weight Unit (line_items.variant.weight_unit)
• Number of Products (products_count, the number of unique products in the order)
• Number of Line Items (line_items_count, the number of line items in the order)

That's a lot of new fields! :)

To make it even sweeter, many of these fields are also now available in the "Custom Filters" section, giving you even more flexibility to create automated, custom reports.

Potential Use Cases

Below are some use cases for these new fields and filters.

Create a picking list report where you can include the image of the product

This could help you or your team find things faster.

In Google Sheets, you can use the IMAGE() function to automatically load the images from the URL. You can enter this value in the Custom Fields to do this automatically:

=IMAGE("{{ line_items.product.image_src }}")

Then this is what you'll see in Google Sheets:

Add a Custom Field with a link to the product's public page

You may need to check the product page from time to time while going through your orders. Having the product link in your report directly could really save you time especially when you have a lot of orders.

For example:

https://mystore.myshopify.com/products/{{ line_items.product.handle }}

Will create a field in your report that looks something like this:

Create custom reports based on the number of unique products in the order

You may want a separate report that includes only orders with 1 type of product and another with multiple types of products (by filtering via "Number of Products") to help speed up your fulfillment process. This is actually a use case that one of our users needed and that's why we've added this field.

To filter by the number of line items/variants instead, you can use the field "Number of Line Items."

Create a custom report for backordered products

Now that you can include both the Inventory Policy and the current Inventory Quantity and filter by these fields, you could now generate a report that could show you a list of orders that can't be fully fulfilled currently because one or more products in the order is temporarily out of stock.

To do so, you can add the following Custom Filters to your unshipped/partially shipped orders report:

Data matching all of the following conditions:

• Lineitem Variant Inventory Policy is continue
• Lineitem Variant Inventory Quantity is less than 1

This could save you time from having to go through all your orders manually and notify your customers right away.

We hope that these additional fields and filters will help you with running your e-commerce business. If you have any questions or suggestions please feel free to leave a comment or contact us!