8 votes
Accepted

Product custom attribute import with CSV Magento 2

Upload from the default CSV generated by Magento Yes, you need to fill all your custom attributes into the single-column named additional_attributes_code. Just simply put all your custom attributes ...
Abhishek Tripathi's user avatar
6 votes

Product custom attribute import with CSV Magento 2

I have made one more test case and tried to upload with the name of attribute in csv. Instead of "additional_attributes" I have directly added name of a column and tried to upload value of a custom ...
Dhaval Solanki's user avatar
6 votes
Accepted

Magento 2 import new and update current products with a CSV file and cron job

I made 2 scripts for updating products and importing new products, based on a few similar questions/answers I found on SME and my own research. The solution is tested and works on Magento 2.2 (but ...
Lez's user avatar
  • 2,907
4 votes
Accepted

What cronjob takes care of running a Scheduled Import in Magento2?

I found it. The job_code is scheduled_operation_ID with ID being the ID of the profile you created in the backend. I did not have time to find how the job is added to the cron_schedule table but I ...
Peeter Rannou - thedotwriter's user avatar
3 votes
Accepted

Need csv format for size and color Configurable product Magento2?

Follow the below magento 2 official document to import configurable product. https://docs.magento.com/m2/ce/user_guide/system/data-transfer-configurable-products.html Sample CSV file download from ...
Hariharan's user avatar
  • 253
3 votes

Magento 2: How to create CSV with UTF-8 encoding?

You can convert your string to UTF-8 by using default PHP function. mb_convert_encoding(string, encode_type) Please check below example for more details. $products[] = array(1,'Test 1','test 1',100); ...
Mohammad Bharmal's user avatar
2 votes

Product import successfully done no errors but no products imported in Magento 2

I had the same problem. Found out some product names contained curved apostrophes instead of straight ones. It was saying successful but no products were added even after trying 4 times. I had these (’...
Jean-Sebastien's user avatar
2 votes

Magento 2 : How can i read Xml file data

You can try this way : namespace Vendor\ModuleName\Model; class ParseXmlClass { /** * @var \Magento\Framework\Module\Dir\Reader */ ...
Shashank Gupta's user avatar
2 votes
Accepted

Magento2: Import custom attribute for specific product id using csv

Please analyse below demo its working to update price and qty using sku ( specific SKU ) via CSV, I hope its helpful to you.. ( its just idea how to work in magento2 ) <?php use Magento\...
Anas Mansuri's user avatar
  • 2,627
2 votes
Accepted

Products not importing via CSV - Magento 2.2.3

Managed to fix this. The issue was my excel not saving the document properly to UTF8 (Comma Delimited). I had to open the .csv using notepad and resaving it into UTF 8 that way.
cz84's user avatar
  • 69
2 votes

Product custom attribute import with CSV Magento 2

Yes, you have to add all custom attributes under additional_attributes column. See below image
Dinesh Yadav's user avatar
  • 6,447
2 votes

Magento 2: How to create CSV with UTF-8 encoding?

Please follow the below code snippets, //Declare column and data $result[] = [ 'Column1', 'Column2' ]; $result[] = [ 'data01', '...
Mohamed Abbas's user avatar
2 votes
Accepted

How to delete all records in the importexport_importdata table?

Execute Mysql delete query (assuming mysql as you have asked for phpMyAdmin) Select the database in phpMyAdmin. OR execute mysql query for selecting database: use <db-name>; Delete all ...
Harsh Tank's user avatar
1 vote

Need csv format for size and color Configurable product Magento2?

First Solution : Please go through this csv format for size and color Configurable product Magento2.Set size,color variation as attached image Second Solution Go through that link and read this blog ...
Rv Singh's user avatar
  • 1,617
1 vote

Getting CSP related error on custom plugin page in admin in Magento 2.4.3

The purpose of $this->_formScripts[] to load additional scripts, using requireJS, for your form. Take a look at Magento\Widget\Block\Adminhtml\Widget for an example. Apparently your module tries to ...
Tom van den Heuvel's user avatar
1 vote

How to tell which record in the CSV file is causing the 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '6206' for key' Error?

You should reset increment_id field. It would be better that you would truncate all product table and re-insert all product data. Execute below query. SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `...
S.P's user avatar
  • 1,524
1 vote

Change the default product image import directory

You can override that value by adding that field in core_config_data you can run below sql code for the same INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0'...
Murtuza Zabuawala's user avatar
1 vote

Magento Import products Internal Server Error

This might also be related to some kind of an infinite loop into your code or internal error in your code. You might want also to check on your var/log/system.log to see if there isn't any error that ...
Claims's user avatar
  • 1,154
1 vote

Magento2: Product Import Issue

You can try this file. Download here sample file May help you!!
Jafar Pinjar's user avatar
  • 1,929
1 vote
Accepted

Magento2: Product import errors

Check once the attribute set which you added in CSV and compare with the attribute set which you want to assign the products in admin By going to admin > stores > attribute set, you can find the ...
Teja Bhagavan Kollepara's user avatar
1 vote

Magento2: Product import errors

Please make sure! It seems some missing attribute set name. You need to change the column value of the attribute set. whichever is your CSV file. and the rows are 1,2,3,4,5,6. It means you mentioned ...
Sarvesh Patel's user avatar
1 vote
Accepted

How to create csv comma separated list from an array in PHP

you can use the code below to add the category names in separate columns in csv file, just modified your code a bit. $products = Mage::getModel('catalog/product')->getCollection(); $products->...
Haijerome's user avatar
  • 2,181
1 vote

Magento 2.3.2 Import only images for multiple products

The error occurs while adding product images "Product Type is invalid or not supported in row(s): 1" is because the sku on first row you are trying to add image does not exist in the magento system or ...
Qasim Ali Saeed's user avatar
1 vote
Accepted

Magento 2 - Import Product .csv via CLI

Is it possible to start the product import with "Add Update" (all other default) via the CLI? The short answer is no. You would write something custom to do this. Writing console scripts is ...
Dominic Pixie's user avatar
1 vote
Accepted

Magento2: Add product to parent and child categories on import

In your csv check column categories you have just added Default Category/A1/A2/A3 instead of Default Category/A1, Default Category/A1/A2 ,Default Category/A1/A2/A3 If you want to get better idea ...
Rutvee Sojitra's user avatar
1 vote

Magento2.2 product import using Magmi

Is Magmi import is compatible with Magento2.2? -> Yes Is it compatible with grouped and simple products import? -> Yes Where I can find the Latest version of Magmi? -> https://github.com/...
Msquare's user avatar
  • 9,063
1 vote

Magento 2 - Import custom product attributes through csv, can I import them using individual columns?

You can use Magento default Import Export available at (System > Data Transfer > Import/Export). Yes you need to specify all inside "additional_attributes" like "gift_wrapping_available=Use config,...
Narendra Vyas's user avatar
1 vote

Magento 2 Product import error :. Value for 'product_type' attribute contains incorrect value

You need make sure need at least attributes below for your csv import file sku,product_type,attribute_set_code,categories,name,description,price,qty
Magetop E-commerce's user avatar
1 vote
Accepted

Import error in Magento2 admin

This issue is now typical of Magento 2 import. there are 2 scenarios: the url key that exists is from the same product but somehow conflicts with the product to add/update the url key conflicts with ...
Herve Tribouilloy's user avatar
1 vote

Product custom attribute import with CSV Magento 2

Maybe a little late to the show, but if you are, like me, struggling with custom attributes not being imported (and apparently ignored by magento) make sure, the additional attributes column is not ...
BromStyle's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible