* | The ERPNext Magento Connector operates by extracting Order, Shipment, and Invoice data from Magento and subsequently generates corresponding Sales Orders, Delivery Notes, Invoices, and Payment Entries within ERPNext. |
📢 For Version 14,
First needs to install ERPNext. After then install the ERPNext Magento
Magento Integration
The ERPNext Magento Connector operates by extracting Order, Shipment, and Invoice data from Magento and subsequently generates corresponding Sales Orders, Delivery Notes, Invoices, and Payment Entries within ERPNext.
In the event that a Customer or Item is absent within ERPNext during the creation of a Sales Order, the system will initiate the establishment of a new Customer or Item. This is achieved by retrieving the relevant information directly from Magento. Additionally, an Address associated with the Customer is produced using the shipping details sourced from the order data.
How to Setup Connector?
Setting Up Magento on ERPNext
- Setup a Magento URL
- Ensure you are using a live server for your Magento website at https://www.magento_product.com . However, if you have configured Magento on a local instance, please access it via http://www.magento_product.com
- Regarding ERPNext, kindly navigate to the Magento Settings and configure the Magento URL
- Setup an API Access Token
- Please go to the System > Integrations > Add New Integration. Then go to the API Tab and select All in Resource Access.
- Please go to the System > Integrations > Add New Integration. Then go to the Integration Info tab and select your name and your password for current user identity verification and save it.
- Please go to the Setting > Integrations list. Activate and authorize the API from this section. Once that's done, access the record where you previously configured a username and password. This action will generate the Consumer Key, Consumer Secret, Access Token, and Access Token Secret in the Integration Details.
- Please set the Access Token in Magento Settings.
- Please go to the Stores > Configuration > Services > Magento Web API. Next, navigate to the Web API Security section and make sure to activate the "Allow Anonymous Guest Access" option. This step is crucial because without enabling it, you won't be able to gain access to any form of API.
- Please go to the Stores > Configuration > Services > OAuth. Next, navigate to the Consumer Settings section and make sure to activate the "Allow OAuth Access Tokens to be used as standalone Bearer tokens" option.
- Please go to the System > Cache Management. Then clear the Flush Cache Storage and Flush Magento Cache.
- Basic Configuration from the ERPNext perspective
- Please ensure that you configure your company, warehouse, and Cost Center correctly to enable the system to timestamp the transaction data accordingly.
- ERPNext Customer Group: The Customer Group will be automatically configured to the chosen group during the synchronization process of customers from Magento in ERPNext.
- ERPNext Item Group: The Item Group will be automatically configured to the chosen group when synchronizing items from Magento in ERPNext.
- Cash/Bank Account: The Cash Account is utilized in the creation of Sales Invoices and Payment Entries within ERPNext.
- Item Variant Attributes
- If Magento features a Configurable Product, it is necessary to import the Product Attributes into the Item Attribute section within ERPNext. Please go to the Stores > Product.
- Copy all Product Attribute names (Default Label), then proceed to download the Excel/CSV file of Item Attributes from ERPNext.
- Afterward, paste the Magento Product Attributes that you previously copied.
- Then import the Item Attribute.
- Add all Item Variant Attributes in Magento Settings. Specify which item attributes require synchronization. All attributes utilized to define item variants must undergo synchronization. It is essential that these attributes maintain identical names within both ERPNext and Magento. Any renaming adjustments should be executed manually within both systems.
- Currency Setup
- Please ensure that the currency configuration aligns with the country, as item prices, orders, shipments, and invoices in ERPNext will be determined based on the selected currency. Please go to the Stores > Configuration > General > General.
- Also, set up Currency options. Please go to the Stores > Configuration > General > Currency Setup.
- Please go to the System > Cache Management. Then clear the Flush Cache Storage and Flush Magento Cache.
- Map Price Lists
- Default Price List: Prices from this price list are established as the default pricing in ERPNext.
- Please verify the Magento Website Name and set it in Magento Settings.
- Please choose to either select or insert only one row at a time for mapping, as the functionality for multiple rows is currently unavailable in ERPNext.
- Map Magento Tax
- Please go to the Stores > Tax Zones and Rates. Then set your tax according.
- Then please go to the Stores > Tax Rules and configure it.
- Set the Magento Tax name in Magento Tax Account in Magento Settings. Also, set the ERPNext Tax Account. Please choose to either select or insert only one row at a time for mapping, as the functionality for multiple rows is currently unavailable in ERPNext.
- If you want to Import Delivery Notes from Magento on Shipment or Import Sales Invoice from Magento if Payment is marked then enable it and select the series.
- If enabled Tax is included in the Basic Rate then the tax amount will be considered as already included in the Print Rate / Print Amount.
- Sync Magento
- We have configured the scheduler to automatically synchronize Magento with ERPNext every hour. Any updates or changes made in Magento will be seamlessly reflected in ERPNext. For instance, if you modify the Item Name in Magento, it will automatically propagate to ERPNext within an hour. Additionally, you can manually trigger the synchronization process by clicking on the "Sync Magento" option, and it will function accordingly.
- Output
- Product Attributes - Magento
- Item Attribute - ERPNext
- Products - Magento
- Item - ERPNext
- Customers - Magento
- Customers - ERPNext
- Orders - Magento
- Sales Order - ERPNext
- Shipments - Magento
- Delivery Note - ERPNext
- Invoices - Magento
- Sales Invoice - ERPNext
- Payment Entry - ERPNext
- Stock Management
- Managing your Magento product stock is a seamless task when utilizing ERPNext Stock Management.
- Stock Balance - ERPNext