We've added new fields to EZ Exporter's product exports.

New Product Category Fields

category.full_name	Category Full Name (type: text). The full name of the taxonomy category. For example, Animals & Pet Supplies > Pet Supplies > Dog Supplies > Dog Beds.
category.name	Category Name (type: text). The name of the taxonomy category. For example, Dog Beds.

Sample Output:

New Inventory Quantity Fields

In the past, only the "available" quantity was available for export.  This update now allows you to export the quantities for the following inventory states:

• incoming
• available
• committed
• on_hand
• reserved
• damaged
• safety_stock
• quality_control

The last 4 states mentioned above make up the "unavailable" state.  We've added the following pre-computed fields that provide the totals accross all locations:

variants.inventory_levels.total_available	Variant Inventory Levels - Total Available (type: number). The inventory that a merchant can sell. Available inventory isn’t committed to any orders and isn’t part of incoming transfers.
variants.inventory_levels.total_committed	Variant Inventory Levels - Total Committed (type: number). The number of units that are part of a placed order but aren't fulfilled. When a draft order is created, the inventory isn't committed until the draft order is completed and an order is created.
variants.inventory_levels.total_incoming	Variant Inventory Levels - Total Incoming (type: number). The inventory that’s on its way to a merchant's location. For example, the inventory might be in an incoming shipment. Incoming inventory isn’t available to sell until it has been received and its state has been changed to available.
variants.inventory_levels.total_on_hand	Variant Inventory Levels - Total On Hand (type: number). The total number of units that are physically at a location. The on_hand state equals the sum of inventory quantities that are in the available, committed, reserved, damaged, safety_stock, and quality_control states.
variants.inventory_levels.total_unavailable	Variant Inventory Levels - Total Unavailable (type: number). The sum of inventory quantities that are in the reserved, damaged, safety_stock, and quality_control states.

Sample output:

There's also a field called variants.inventory_levels which provides the raw JSON data with the quantity breakdown by location.

You can follow this guide on how to export the quantities from a specific location.

For example, if you have a location called "Warehouse A" and you'd like to export the "available" quantity from this specific location, you would use a formula like this in the Calculated Fields:

search_attributes(search_attributes({{ variants.inventory_levels }}, "Warehouse A", search_key="location_name", result_key="quantities"), "available", search_key="name", result_key="quantity")

The formula is a bit complex, but the main things to note here are the parts where it says "Warehouse A" (the location name) and "available" (the inventory state).  You can basically copy/paste this formula and change the location name and inventory state value to extract the quantity from a specific location for a specific inventory state.

Sample output:

On the "Templates" page of the app, there's also a template you can use called "Inventory Report" which already includes these new inventory fields.

Feel free to contact us if you have any questions about this or need any help coming up with a formula.