What is the logic or the query for the order line items export?
We are trying to tie the sales data we are retrieving from Clover to data that we are displaying in our app and are running into some discrepancies.
Yeah, unfortunately there is a fairly major difference in how the line item exports in the Orders section finds their data versus the line items that appear on the page in the HTML table.
Under the covers the exports are actually running the Items report from the Reporting section.
In the Reporting section, the date that items are considered sold is when the item was first paid.
If you run Items report over the payment time
then you will see that the export matches
4 People are following this question.