ERPNext Magento
ERPNext Magento-V14

Products Item Code: ERPNext Magento-V14

$ 499.00 ($ 499.00 / Nos)

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.

* 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

  1. Setup a Magento URL
  2. 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
  3. Screenshot from 2023-08-22 13-32-48
  4. Regarding ERPNext, kindly navigate to the Magento Settings and configure the Magento URL
  5. image
  6. Setup an API Access Token
  7. Please go to the System > Integrations > Add New Integration. Then go to the API Tab and select All in Resource Access.
  8. image
  9. 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.
  10. 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.
  11. image
  12. Please set the Access Token in Magento Settings.
  13. image
  14. 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.
  15. image
  16. 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.
  17. image
  18. Please go to the System > Cache Management. Then clear the Flush Cache Storage and Flush Magento Cache.
  19. image
  20. Basic Configuration from the ERPNext perspective
  21. Please ensure that you configure your company, warehouse, and Cost Center correctly to enable the system to timestamp the transaction data accordingly.
  22. ERPNext Customer Group: The Customer Group will be automatically configured to the chosen group during the synchronization process of customers from Magento in ERPNext.
  23. ERPNext Item Group: The Item Group will be automatically configured to the chosen group when synchronizing items from Magento in ERPNext.
  24. Cash/Bank Account: The Cash Account is utilized in the creation of Sales Invoices and Payment Entries within ERPNext.
  25. image
  26. Item Variant Attributes
  27. 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.
  28. image
  29. Copy all Product Attribute names (Default Label), then proceed to download the Excel/CSV file of Item Attributes from ERPNext.
  30. image
  31. image
  32. Afterward, paste the Magento Product Attributes that you previously copied.
  33. image
  34. Then import the Item Attribute.
  35. image
  36. 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.
  37. image
  38. Currency Setup
  39. 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.
  40. image
  41. Also, set up Currency options. Please go to the Stores > Configuration > General > Currency Setup.
  42. image
  43. Please go to the System > Cache Management. Then clear the Flush Cache Storage and Flush Magento Cache.
  44. Map Price Lists
  45. Default Price List: Prices from this price list are established as the default pricing in ERPNext.
  46. Please verify the Magento Website Name and set it in Magento Settings.
  47. image
  48. 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.
  49. image
  50. Map Magento Tax
  51. Please go to the Stores > Tax Zones and Rates. Then set your tax according.
  52. image
  53. Then please go to the Stores > Tax Rules and configure it.
  54. image
  55. 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.
  56. image
  57. 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.
  58. image
  59. 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.
  60. image
  61. Sync Magento
  62. 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.
  63. image
  64. Output
  65. Product Attributes - Magento
  66. image
  67. Item Attribute - ERPNext
  68. image
  69. Products - Magento
  70. image
  71. Item - ERPNext
  72. image
  73. Customers - Magento
  74. image
  75. Customers - ERPNext
  76. image
  77. Orders - Magento
  78. image
  79. Sales Order - ERPNext
  80. image
  81. Shipments - Magento
  82. image
  83. Delivery Note - ERPNext
  84. image
  85. Invoices - Magento
  86. image
  87. Sales Invoice - ERPNext
  88. image
  89. Payment Entry - ERPNext
  90. image
  91. Stock Management
  92. Managing your Magento product stock is a seamless task when utilizing ERPNext Stock Management.
  93. image
  94. Stock Balance - ERPNext
  95. image


Customer Reviews

0

0 ratings
0 out of 5
1 star
0%
2 star
0%
3 star
0%
4 star
0%
5 star
0%
No Reviews