Linnworks custom report needed

We need a custom report/export from Linnworks. Ideally it’d be emailed to us automatically each day at 4:30pm, but I don’t mind having to trigger it manually if automation is expensive or overly difficult.

Basically, I need a report where any order that contains a certain set of characters t the start of the order number AND is on a Royal Mail service is added into a simple 2 column CSV. Column 1 is Order ID, column 2 is tracking number (pulled from Linnworks). If there is no tracking, the value is entered as 0.

My only req would be that no two order IDs are ever included in a report twice. If this can’t be done/guaranteed then I guess the automated emailing of the report at the same time each day would prevent this anyway.

Ideally this would be implemented in Linnworks desktop. I require the work to be completed ASAP.