Sync Shopify edited orders with Quicbooks Online

Follow

Robert Herbelin

• April 15, 2021 17:49

Shopify allows editing orders, but the OneSaas integration does not sync order updates with Quickbooks invoices. Editing an order in Shopify requires manual editing of the invoice in Quicbooks, as well as manually entering additional payments in Quickbooks. For example:

• Order 1234 is created in Shopify. This order is synced to Quickbooks correctly by creating a new invoice and payment.
• Order 1234 is edited in Shopify and an additional payment is made. This edit does not update the Quickbooks invoice, and trying to sync the additional payment causes an error to occur stating that the payment cannot be synced, as the invoice already exists in Quickbooks. The invoice in Quickbooks still shows the original order.
• Order 1234 must be manually updated in Quickbooks and an additional payment entered manually to match the new Shopify order.

Please integrate synchronizing edited orders by modifying the Quickbooks invoice and creating the additional payments to the updated invoice.

1

• Official comment

  

  Johnny Chiang

  • April 15, 2021 23:07

  Hi Robert, thank you for your suggestion. Our team is definitely looking at the possibility of introducing invoice updates to our sync capability. Unfortunately there's no ETA yet as there are quite a few scenarios(as well as limitations) around the definition of what constitutes an update that OneSaas should sync, and what should be ignored.
  E.g. We want to be careful not to override manual changes done against the QuickBooks invoice for other accounting processes (eCommerce platforms typically do not tell us what part of a specific order was updated, rather we are just told that it has been "updated" in some way).
  If we created the sale as a Paid Receipt in QuickBooks, we are also limited in our ability to make any edits. etc.
  
  For the time being, our recommendation is that you should set up your OneSaas app to only transfer Shopify orders which are final to minimise the amount of edits you need to do within QuickBooks. Again, we do understand that this suggestion does not encompass every user scenario, and we are doing our best to improve!

  Comment actions Permalink

Please sign in to leave a comment.