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.
This article will cover the following topics:
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.
![]() | ![]() |
- 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.