Answered 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.
The main link of the orders are the PO#'s and INV#. For inventory items, these are the SKU's. You could always check at the Log Tab or Operations Log in Shopify and Synschronisation page in QBO the orders and invoices that were processed.
Below is a list of resources that we think will be useful for you.
The DEAR Support Team