Import magento 2 products programmatically

[vinaymaurya134]

As the first create the importproducts.php file inside the script folder in the magento root directory.Then establish the database connection as shown below.

1. <?php
2. define('DS', DIRECTORY_SEPARATOR);
3. use \Magento\Framework\App\Bootstrap;
5. include('../app/bootstrap.php');
6. $bootstrap = Bootstrap::create(BP, $_SERVER);
7. $objectManager = $bootstrap->getObjectManager();
8. $app_state = $objectManager->get('\Magento\Framework\App\State');
9. $app_state->setAreaCode('frontend');
11. $productsData = getProducts();
12. importSimpleProducts( $productsData , $objectManager );
    

Read CSV​

This step reads the products data from the CSV.

1. function getProducts()
2. {
3. $file = 'csv/products.csv';
4. $arrResult = array();
5. $headers = false;
6. $handle = fopen($file, "r");
7. if (empty($handle) === false) {
8. while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
9. if (!$headers) {
10. $headers[] = $data;
11. } else {
12. $arrResult[] = $data;
13. }
14. }
15. fclose($handle);
16. }
17. return $arrResult;
18. }
    

Import magento 2 products​

The above function reads the data from the CSV and return the data in an array. The following code iterate through the array and create the products as show above.

1. /*
2. * Import Simple Products
3. */
4. function importSimpleProducts( $importProducts, $objectManager ) {
6. // Path to media folder
7. $filesystem = $objectManager->create('Magento\Framework\Filesystem');
8. $mediaDirectory = $filesystem->getDirectoryWrite(\Magento\Framework\App\Filesystem\DirectoryList::MEDIA);
9. $mediaPath = $mediaDirectory->getAbsolutePath();
11. foreach( $importProducts as $importProduct ) {
13. try {
15. $product = $objectManager->create('\Magento\Catalog\Model\Product');
16. $product->setWebsiteIds(array(1));
17. $product->setAttributeSetId(4);
18. $product->setTypeId('simple');
19. $product->setCreatedAt(strtotime('now'));
20. $product->setName($importProduct[1]);
21. $product->setSku($importProduct[3]);
22. $product->setWeight($importProduct[16]);
23. $product->setStatus(1);
24. $category_id= array(30,24);
25. $product->setCategoryIds($category_id);
26. $product->setTaxClassId(0); // (0 - none, 1 - default, 2 - taxable, 4 - shipping)
27. $product->setVisibility(4); // catalog and search visibility
28. $product->setColor(24);
29. $product->setPrice($importProduct[11]) ;
30. $product->setCost(1);
31. $product->setMetaTitle($importProduct[1]);
32. $product->setMetaKeyword($importProduct[26]);
33. $product->setMetaDescription($importProduct[28]);
34. $product->setDescription($importProduct[27]);
35. $product->setShortDescription($importProduct[27]);
37. $product->setStockData(
38. array(
39. 'use_config_manage_stock' => 0,
40. 'manage_stock' => 1, // manage stock
41. 'min_sale_qty' => 1, // Shopping Cart Minimum Qty Allowed
42. 'max_sale_qty' => 2, // Shopping Cart Maximum Qty Allowed
43. 'is_in_stock' => 1, // Stock Availability of product
44. 'qty' => (int)$importProduct[6]
45. )
46. );
49. $product->save();
50. echo "Upload simple product id :: ".$product->getId()."\n";
51. }
52. catch(Exception $e)
53. {
54. echo 'Something failed for product import ' . $importProduct[1] . PHP_EOL;
55. print_r($e);
56. }
57. }
58. }

 

[zyhivan]

great module for import! Thank you so much! Thank you so much!

 

[blackhawkdown]

is there any observer code for these ?

 

[greg2]

Thank you for sharing your code !

 

[ececec]

Thank you for sharing!
really helped me so good