Import Products From CSV to Magento2 - Magneto2 Commerce API

Challenge

The client wants to use the ERP software because it is good in its own domain. However, the ERP software does not provide any interface or functionality to bridge the gap between itself and Magento2 enterprise edition. Thus, he needs to import a configurable products csv into Magento2 programmatically minimizing the manual process to a great extent.

Since the client is also a techie, he wanted an extensible and scalable solution that he can use for various import/update functionality with no to little modification.

Approach

To make above requirement real and working software, we chose laravel for it provides model–view–controller architectural pattern and is quite extensible. Since time is of essence, we decided to do what we do best: custom application development, as it allows us to control every aspect of the project.

• We started with requirement gathering and freezing the scope of work.
• Setup dev, staging and production at Magento2 Enterprise Edition.
• Installed and configured dev environment for Magento Commerce Cloud on our local system.
• Prepared the high-level documentation for every possible scenario.
• Prepared the low-level sequence diagram.
• Development, testing and pushing of code on live environment.
• Continued clear client communication at every phase.
• Extended the current project to suit similar import/update objectives.

“We have decided to import products from CSV file from FTP location to Magento Store using Magento2 Commerce API which is scalable and secure solution.”

Result

In the due course of project we have excelled the client expectations and developed a solution that serves every need of import in Magento2 Enterprise Edition.

Now client have to just export csv from his ERP system and place on FTP. Our application perform all the operation and Add/Edit/Delete the products to Magneto store without human interaction.