Connecting erplain to QuickBooks Online and Shopify

Please note that the connection to QuickBooks and Shopify is only available in your Premium subscription.


Once erplain is connected to QuickBooks Online and Shopify, all your Sales orders and Invoices created in Shopify will be created in erplain, then in QuickBooks. Your Inventory, products, customers and suppliers will be synced in real time between the 3 systems.



Connecting erplain to QuickBooks and Shopify

Important: Prior to connecting erplain to QuickBooks Online and Shopify, please make sure to disable all other Apps that would connect QuickBooks and Shopify directly.


Open the Apps menu and click on "Connect to QuickBooks" or "Connect to Shopify":



You can find more information on the connection Settings for QuickBooks Online on this page and more information on the connection Settings for Shopify on this page. Make sure to select the appropriate Price level sync in the settings. You can find more information in this article in the Price Sync section.


Products sync and Products mapping

Once you are connected to QuickBooks and Shopify:

- If you don't yet have any product in QuickBooks or Shopify, simply Export your products from erplain to QuickBooks or from erplain to Shopify.


Apps settings - Configure QuickBooksApps settings - Configure Shopify



- If you already have products in QuickBooks and Shopify you can map your products between the 3 applications:


Please consider the 3 following scenarios:

1. erplain was connected to QuickBooks Online

Assuming that your products between QuickBooks and erplain are already mapped, you can now map your products between erplain and Shopify.

- Open the Apps menu, click on "Configure Shopify", then scroll down to Products Mapping:

- Choose which system (erplain or Shopify) will be the Primary or Master, then click on Save and "Map products".

- For each product, you can search for the matching product on Shopify or click on Auto suggest to find a possible match between erplain and Shopify.  Click on Save once you found the corresponding product.



2. erplain was connected to Shopify

Assuming that your products between Shopify and erplain are already mapped, you can now map your products between erplain and QuickBooks.

- Open the Apps menu, click on "Configure QuickBooks", then scroll down to Products Mapping:

- Choose which system (erplain or Shopify) will be the Primary or Master, then click on Save and "Map products".


- For each product, you can search for the matching product on QuickBooks or click on Auto suggest to find a possible match between erplain and QuickBooks.  Click on Save once you found the corresponding product.


3. erplain was never connected to QuickBooks Online or Shopify

Start by connecting erplain to either QuickBooks or Shopify. Then setup the connection between the 2 systems, and then proceed to the next step #1 or #2 above.


Price Sync

In the App settings (Menu Apps), for each App, please select the product price: Wholesale or Recommended Retail price level you would like to sync with erplain.

For QuickBooks, click on 'Configure QuickBooks' and scroll down to Price sync:

For Shopify, click on 'Configure Shopify' and scroll down to Price sync:


Important: You can sync the Wholesale price between erplain and QuickBooks, and the Retail price between erplain and Shopify but if you later update the sync between erplain and QuickBooks to Retail price (for example), it will overwrite the Wholesale prices in QuickBooks. 


Stock level sync

As Shopify and erplain support Sales orders but not QuickBooks, there is a small difference on the stock level sync:

- Between erplain and QuickBooks this is the On-hand stock that syncs between the 2 systems.

- Between erplain and Shopify this is the Available stock that syncs between the 2 systems. Please remember that manual stock adjustments done in Shopify will not be synced to erplain. It is recommended to use erplain to do your stock adjustments (stock entry, removals, bulk update).

For more information on On-Hand and Available stocks, please visit this page.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.