Shopify Connector
The Shopify Connector synchronizes Shopify orders with ERPNext by automatically creating Sales Orders. If a customer or item does not already exist in ERPNext, the connector creates them automatically using data from Shopify.
App Installation
The Shopify Connector is available as a separate Frappe application and is no longer bundled with ERPNext.
- Frappe Cloud: Install the connector directly from the Frappe Cloud Marketplace.
- Frappe Hosted: Contact Frappe Support to install the application.
- Self Hosted: Install the application using Bench:
bench get-app ecommerce_integrations --branch main
Important: If you are using the legacy Shopify integration, disable it before installing the new connector. Existing Shopify data will be migrated automatically to the new integration.
Creating a Shopify Custom App
- Open your Shopify Admin panel and navigate to Apps.
- Select Develop apps for your store.
- Create a new custom application.
- Configure the application and generate the required credentials:
- API Key
- Access Token
- API Secret
- Grant the following Admin API permissions:
- Draft Orders – Read & Write
- Orders – Read & Write
- Locations – Read
- Customers – Read
- Assigned Fulfillment Orders – Read & Write
- Products – Read & Write
- Product Listings – Read & Write
- Inventory – Read & Write
- Install the custom application in your Shopify store.
Configuring Shopify in ERPNext
- Open Shopify Settings in ERPNext.
- Enter the following credentials from your Shopify custom application:
- Shopify Store URL
- Access Token
- API Secret
- Configure:
- Customer settings
- Company settings
- Inventory settings
- Configure order synchronization options such as payment and fulfillment handling.
- Create tax and shipping mappings between Shopify and ERPNext.
- Enable Shopify Sync and save the document.
Once enabled, ERPNext begins synchronizing Shopify orders automatically.
Syncing Existing Shopify Orders
Previously created Shopify orders can also be imported into ERPNext.
- Enable Sync Old Shopify Orders.
- Select the required From and To dates.
- Save the settings.
The synchronization runs in the background and completion time depends on the number of orders.
Inventory Synchronization
ERPNext can automatically synchronize inventory levels with Shopify.
Configure Inventory Sync
- Enable Inventory Sync.
- Select the synchronization frequency.
- Click Fetch Shopify Locations.
- Map each Shopify location to the corresponding ERPNext warehouse.
- Save the configuration.
Inventory Behavior
- Inventory updates are processed automatically according to the configured schedule.
- Warehouse quantities in ERPNext are mapped directly to Shopify locations.
- ERPNext acts as the source of inventory data, and synchronized quantities overwrite Shopify inventory.
- Shopify supports only whole-number quantities. Fractional quantities from ERPNext are rounded down during synchronization.
Item Synchronization
ERPNext can automatically create new Shopify products from ERPNext items.
- Enable Upload New ERPNext Items to Shopify.
- Optionally enable automatic updates whenever an ERPNext item is modified.
Field Mapping
| ERPNext Field | Shopify Field |
|---|---|
| Item Name | Title |
| Item Code | SKU |
| Description | Description |
| Item Group | Product Type |
| Weight Per Unit | Weight |
| Weight UOM | Weight Unit |
Newly uploaded products are created as Draft in Shopify and are not automatically published.
Note: Item synchronization is not supported for Data Import, Variant Items, or Template Items.
Order Cancellation Handling
- If a Shopify order is cancelled before an Invoice or Delivery Note is created in ERPNext, the corresponding Sales Order is automatically cancelled.
- If related ERPNext documents already exist, the Shopify cancellation status is recorded on those documents, allowing users to complete the remaining cancellation process manually.
