US Portal

May be able to do something in SQL like :

SELECT `customerJson`, `orderJson`,`orderStatusJson`, CONCAT(CONCAT('[', GROUP_CONCAT(`orderedItemsJson`)), ']'), `id`, STR_TO_DATE(CAST(JSON_UNQUOTE(JSON_EXTRACT( `orderJson`, '$.orderDate' )) AS CHAR), '%b %d %Y %H:%i:%s' ) AS orderDate FROM IgennusOrders WHERE (STR_TO_DATE(CAST(JSON_UNQUOTE(JSON_EXTRACT( `orderJson`, '$.orderDate' )) AS CHAR), '%b %d %Y' ) BETWEEN '2024-08-01' AND '2024-10-10') AND CAST(JSON_UNQUOTE(JSON_EXTRACT( `customerJson`, '$.name' )) AS CHAR) LIKE '%ennox%' GROUP BY CAST(JSON_UNQUOTE(JSON_EXTRACT( `customerJson`, '$.name' )) AS CHAR), CAST(JSON_UNQUOTE(JSON_EXTRACT( `orderJson`, '$.orderDate' )) AS CHAR), CAST(JSON_UNQUOTE(JSON_EXTRACT( `customerJson`, '$.deliverAddress' )) AS CHAR) ORDER BY `orderDate` DESC

but this will result in an array of ordered items, which will need to be handled. Probably best to handle before delivery to avoid major and error prone alterations to the web front end.

Having all but done this I'm now wondering if this should be done at the point of transfer from the UK portal!

Opened a new ticket,  FS#193 , on the UK portal list

Will still pursue this as it may yet prove useful.

Feature now enabled and in use on US portal!

Need to stop Shopify fulfils being sent multiple times for the same account and order. If they are genuinely different orders further processing to send Shopify fulfils for each will be required. This is unlikely as grouping criteria is quite tight.

First version now implemented on US and SMS portals. Separate CL opened as the Sent To U.S. / S.M.S. message not displayed on all orders in the group, and the tracking info was not being sent back to the UK portal for all orders in the group.