Order lifecycle across Shopify, DEAR, QBO
We use the Shopify/Dear and Dear/QBO integrations. I want to track a given order across all three systems. Essentially, I would like to be able to say for a given Shopify order:
* return all order details from Shopify
* return matching sales order numbers and invoice numbers from Dear (and perhaps journal entries)
* return all relevant records (sales order, payment), journal entries (revenue, inventory/COGS)
I am uncertain if there is an id that could be used to link the records.