Import products from CSV to Magento 2 Commerce using Magento 2 Commerce API

Import products from CSV to Magento 2 Commerce using Magento 2 Commerce API

A client of ours wants to develop an e-commerce website based on Magento 2 enterprise edition. Currently he is using ERP software to manage the inventory and all other operations. At the first phase He wants to import the products from ERP to new Magento 2 Commerce website.

Technologies

  • Laravel
  • Magento 2 Commerce
flat

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 Magento 2 enterprise edition. Thus, he needs to import a configurable products csv into Magento 2 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

flat

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 of Magento 2 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 Magento 2 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 Magento 2 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 Magento store without human interaction.

Please read our blog post if you want to know how to import prodct CSV in Magento 2 Commerce (Enterprise Edition).

Want to start a project?

It’s simple.

Contact us