Also I cant just sort the Queue positions by time unfortunatley mate. I have to take multiple values into account.
Same with the estimated delivery (which is proving to be the hardest element to get right)
Essentially what needs to be achieved is:
Have submissions ordered by queue position in ascending order. The queue position needs to be determined by estimated delivery date, order number, and order status (as orders that change from Confirmed to Dispatched need to jump ahead in the queue (above 'confirmed' orders), while still respecting the Order Number, so that order numbers with a lower number that also have the status 'Dispatched' appear higher in the list than those with a higher order number with the status 'dispatched').
Meanwhile, the estimated delivery date needs to be influenced by Model, Colour, Order Date,and Order Time, while respecting the rules set I've set in a config sheet, as certain colours and models are in more demand than others. Therefore orders of a popular SKU have been given a 'cutoff' time and any orders made for this SKU after that time will face a delivery delay (as outlined in the config sheet). I've set these cutoff rules according to what i saw on EE's website throughout the day on Friday, and what ive seen today and yesterday - regarding the expected delivery times. (For e.g the Silver Pro Max currently sits at a 28 day delay)
I'm literally just sat here Vibe coding until I get this right lol
