Syncing Purchase Orders from Shopify Stocky to QuickBooks Online

Learn how to efficiently sync purchase orders from Shopify's Stocky app to QuickBooks Online for seamless inventory management and accurate financial reporting.

Written by the MyWorks Team

Updated at December 2nd, 2024

Table of Contents

MyWorks supports syncing Purchase Orders created in Shopify's Stocky app into QuickBooks Online, which helps automate the flow of Purchase Orders and reduce manual entry in QuickBooks Online. This feature is included in MyWorks' Scale and Soar plans.

Note: Shopify's API does not yet support apps interacting with Purchase Orders created directly in Shopify, which is why the use of the Stocky app is required. We hope Shopify will add this support soon, at which point MyWorks will also support syncing Purchase Orders created directly in Shopify. 

Overview

MyWorks can sync new Purchase Orders from Stocky into QuickBooks Online as either:

  • A Purchase Order,
  • A Purchase Order & a Bill,
  • A Bill

When a new Purchase Order is created in Stocky, MyWorks will automatically sync it to QuickBooks, in one of the above formats, as selected in our settings. 

MyWorks uses the name of the vendor/supplier in the Stocky Purchase Order to determine the matching QuickBooks vendor the Purchase Order/Bill should sync in to.  This Vendor does need to be already present in QuickBooks, exactly matching the vendor/supplier name of the Purchase Order in Stocky.

Getting Started

First, visit MyWorks Sync > Settings > Automatic Sync, and enable the setting to automatically sync Purchase Orders into QuickBooks. Once this is enabled, enter your Stocky API key into the field shown. This can be found in your Stocky App Preferences, here

Settings

Once purchase order syncing is enabled, visit the Settings > Order tab in your MyWorks App. There, you'll see a section that allows you to control how Purchase Orders are synced into QuickBooks.

These settings include:

  • Syncing the purchase order as either a Purchase Order, a Purchase Order + Bill, or a Bill.
  • Setting the A/P account that a Bill should sync to
  • Setting whether the Purchase Order status should be Open or Closed.