EZ Exporter Extra Options

We provide additional options for further customization of your reports.

Create a duplicate row per line item quantity

Applies only to Order data. This option will repeat a row based on the quantity of each line item in the order. For example, if a customer orders 5 of a particular product/variant, instead of having one row for that product/variant with quantity of 5 in the report, this option will instead create 5 rows with quantity set to 1. Some systems may require the CSV file formatted this way when shipping items separately.

When this option is enabled, the following special fields also become available:

  • {{ line_items._original_quantity }} - The total quantity ordered for this line item.
  • {{ line_items._duplicate_index }} - The index of the duplicated quantity row. Index starts at 0.

An actual use case from one of our customers is they wanted to include a column in the report that says something like: 1 of 3, 2 of 3, 3 of 3. Using the special fields above, we were able to come up with a formula that can be used in a Calculated Field to do this:

str({{ line_items._duplicate_index }} + 1) + " of " + str({{ line_items._original_quantity }})

App: EZ Exporter

Tags: advanced features