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 ...
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 ...
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 ...
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 ...
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 ...
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);
...
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 (’...
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
*/
...
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\...
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.
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
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',
'...
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 ...
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
...
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 ...
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 `...
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'...
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 ...
1
vote
Magento2: Product Import Issue
You can try this file.
Download here sample file
May help you!!
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 ...
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 ...
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->...
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 ...
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 ...
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 ...
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/...
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,...
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
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 ...
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
product-import × 63magento2 × 36
import × 12
csv × 9
importexport × 7
import-products × 7
magento2.3 × 5
magento-1.9 × 4
product-attribute × 4
product-images × 4
magento-2.2.5 × 4
product × 3
magento2.2 × 3
configurable-product × 3
magento2.3.1 × 3
attributes × 2
magento2.4.4 × 2
magento-2.1 × 1
php × 1
module × 1
category × 1
error × 1
magento-1 × 1
adminhtml × 1
xml × 1