Problem
We are using Exportier in Shopify to export order lines for our internal monitoring.
Unfortunately, we keep running into an issue where certain order lines appear twice in the generated report. We cannot identify any obvious reason for this, nor can we see what is causing the duplicate entries.
Certain order lines are included multiple times in the export, although they only exist once in the respective Shopify order as far as we can see.
Could you please have a look at it and let us know what might be causing this? Is there a specific setting, filter, or export logic in Exportier that could result in the same order line being returned more than once?
For our monitoring process, it is important that each order line is exported exactly once.
Solution
If you have multiple line items or fulfillments on the same order, the rows in your report may look duplicated, but they actually contain distinct information layered on top of the same order ID (different line item variants or fulfillment records). So these aren't true duplicates; they're separate line item variants or fulfillment orders within a single order:
This is expected export behavior. To avoid it, deselect the fields that pull from related non-order tables, since those are what generate the extra rows.