Questions tagged [import-products]
Denotes question regarding Magento Import Functionality specifically Import products
119
questions
1
vote
0
answers
619
views
Updating Magento 2 product attribute, Import Add/Update feature always create a duplicate new item, instead of updating
i'm trying to update a custom product attribute called is_eol, but when i use the system->data transfer->import -> import behavior (add/update), it always created a duplicate item with same sku number....
- 962
0
votes
0
answers
96
views
Magento 2 configurable product import issue
I have uploaded configurable products using csv and it works fine when all the simple products have the same price.
However when the simple products are each having a different price within 1 ...
- 2,627
2
votes
2
answers
1k
views
export csv file from magento 1.9 to import product csv in magento 2.3.0
I have a task to import products from m1 to m2.
I having the CSV file with products(from Magento 1 export) at the moment. When I try to "Check Data" on the import page - is always loading.
...
- 648
1
vote
1
answer
219
views
On Import, why did Magento delete products?
I did a product import with behaviour REPLACE using the backend.
The original reason to do this is, that we get duplicated images when importing a CSV file with same products again.
If I understand ...
- 13.7k
2
votes
2
answers
644
views
Magento2.2 product import using Magmi
Is Magmi import is compatible with Magento2.2? Is it compatible with grouped and simple products import? Where I can find the Latest version of Magmi?
1
vote
1
answer
791
views
Update Product Attribute through Import Tool using csv - ERROR: keep creating new same sku number - magento 2
I'm try to update a product attribute called "custom_stock_status". I have put together a csv file, with 2 columns like this, and import the file using import behavior "add/update", but it keeps ...
- 962
2
votes
1
answer
310
views
Error when importing configurable product programmatically
I am programming a custom import system with Magento libraries, but when I import configurable products I get an SQL error.
This is my configurable product function (only a part of my code):
...
2
votes
1
answer
3k
views
Magento 2 - Import custom product attributes through csv, can I import them using individual columns?
I was able to export the custom filterable product attributes into individual columns in CSV file using BSSCommerce export extension. Now I have a large amount of data need to update.I have searched ...
- 962
2
votes
1
answer
181
views
Magento2 : Unable to serialize value while importing product description from CSV for configurable products
Hi, I was trying to add description to products using CSV file for configurable products but when I tried to import the CSV i got the error regarding Unable to serialize value but if I tried to import ...
- 456
4
votes
2
answers
1k
views
Exporting / importing products
I'm having difficulties in exporting all products with their categories from Magento v2.1.9 installation for importing them to Magento v2.3.0.
Because I don't need all other tables I don't want to ...
- 360
0
votes
1
answer
563
views
Apply product to parent and child categories on import
I am trying to import products into v2.2.7. Many products have many categories like:
Default Category/A1/A2/A3, Default Category/B1/B2/B3
When i check the product configuration, the product only has ...
- 241
3
votes
0
answers
358
views
Import products not escaping forward slash in category
I'm trying to import products into v2.2.7 but apparently this has been a problem since 2016 and has not been resolved until v2.3.x.
When importing to magento, some categories are like Socks/types a /...
- 241
1
vote
1
answer
720
views
How to Import Product Meta Title for Multi Store Website in magento 2
I have multi store website in Magento 2. I want to import different different Meta Title as per store by CSV file.
i am using bellow format but its not working for me.
SkU store_view_code ...
- 742
0
votes
1
answer
713
views
Is it necessary to upload product images into the "media/import" folder before importing products from 1.9.1 to 1.9.4?
Magento 1.9.1 to Magento 1.9.4
I am exporting products from Magento 1.9.1 into Magento 1.9.4 and I read the following here:
Before the import put image files in media/import and in the .csv file ...
- 178
0
votes
2
answers
569
views
How to import downlodable product on different store using csv in magento2
I want to import downloadable product in different store using csv in magento2
Can anyone help?
- 3,871
1
vote
0
answers
704
views
Magento 2.2 any issue will arise if we truncate import export history?
If I truncate import_history table from database in Magento 2.2 version.
But thing is that some of the values in execution_time column it's showing as In Progress which seems to that product import ...
- 3,944
1
vote
0
answers
184
views
Update description for product with csv for one store only magento 2
I want to update some fields of product only in one store (magento2), but all stores are updated
Any ideas ?
0
votes
1
answer
243
views
How to import Configurable product from csv with custom attributes using php script
I am trying to import a configurable products in magento 2 with custom attributes using a php script. How far I got the php script to create simple product without custom attributes as a newbie i don'...
- 1
0
votes
1
answer
179
views
Is it possible to import decimal quantity while products imports for some of the products magento 2?
I am thinking to allow decimals quantity to some of the products while products import Magento 2.
If anyone have idea please guide me.
- 1,886
4
votes
3
answers
2k
views
Magento2.3 and Magmi
I'm working on one module. module does read CSV file from var/import and making a call to Magmi to import.
RunQuickImport.php
namespace Test\Import\Controller\Adminhtml\Customimport;
class ...
- 316
0
votes
1
answer
566
views
Import product CSV to magento using cronjob
I want to update my products csv to Magento 1.9.0 using cronjob.
so someone can please tell me appropriate code script, please.
because I want to set it using the cronjob
Thanks in advanced.
- 139
1
vote
0
answers
59
views
Facing error when importing virtual product in magento2
I want to import virtual product when i was importing catalog_product.csv it's giving me below error:
1.Data validation failed. Please fix the following errors and upload the file again.
2.Options ...
- 581
0
votes
1
answer
1k
views
Attributes error on importing Magento 2 products
Im tryin to import products.csv on my Magento 2.2.6 website, but i receive the below error.
1. Value for 'news_to_date' attribute contains incorrect value in row(s): 1, 2, 3, 8, 18, 19, 20, 21, 22, ...
- 82
0
votes
2
answers
4k
views
Magento 2 Product Import Problem
I got an Error on Magento 2 Product Import - which says:
Value for 'visibility' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 1
Invalid value in ...
1
vote
0
answers
58
views
Add products via REST API to Magento 2 webshop
I want to add products to my webshop via a REST API.
I have the following API documentation available.
Ofcourse, I also have a API token and Test API token.
My question is, how can I import the ...
- 11
1
vote
2
answers
7k
views
Need csv format for size and color Configurable product Magento2?
Please Anyone suggest the sample csv file for both color and size Product for bulk import in magento2.
- 1,929
0
votes
1
answer
43
views
Products not updating with load product model by id in magento2
When I load product by below code then product name not updating. what problem in my code?
foreach ($catval as $p) {
$model = $p->MODEL;
$NAME = $p->NAME;
$product = $objectManager-...
- 1,225
1
vote
0
answers
241
views
How to import product include entity_id?
I want to import products with the existing id. ex: I have products which id start from 200. How can I import those products to magento product table which will start from 200 also?
- 11
1
vote
0
answers
573
views
Magento 2: FastSimpleImport Integrity constraint violation
I'm trying to import some products with Firegento FastSimpleImport
https://github.com/firegento/FireGento_FastSimpleImport2
https://github.com/firegento/FireGento_FastSimpleImport2_Demo
When I run the ...
1
vote
1
answer
398
views
Magento 2 : Configurable product import issue with option group attribute value
I have added a product multiselect attribute with option group values programatically as follows
$eavSetup->addAttribute(
\Magento\Catalog\Model\Product::ENTITY,
'print_and_locations',
...
- 2,861
1
vote
1
answer
159
views
import images are default to exclude on dataflow
I am importing images with dataflow, and all looks fine, however after I import they are all pre-selected as excluded:
I am uploading a csv file with sku and image and it should have one more column ...
- 1,069
1
vote
1
answer
580
views
Importing products takes too long on a fresh install of Magento 2 v2.2.4
Backstory:
Suddenly, my MySQL database for Magento 2 has failed and been corrupted (This is a development installation and used to enter products data) and I don't have backup of the database except ...
- 333
0
votes
1
answer
663
views
Products not importing via CSV - Magento 2.2.3
I'm trying to import products on Magento 2.2.3 via the System > Data Transfer > Import method.
I've selected 'Add / Update' from 'Import Behaviour' and the file imports successfully.
But, none of ...
- 69
0
votes
1
answer
646
views
special price is not working fine while adding product into cart
While uploading products, special price given from Magento admin is working fine in product page.
But, in cart page it's taking actual price.
I had tried many answers from internet. But, still ...
- 1
2
votes
1
answer
333
views
How to skip missing additional images and continue to import products?
I am importing more than 10000 products to my Magento 2 store and got the following error codes:
Imported resource (image) could not be downloaded from external
resource due to timeout or access ...
- 21
0
votes
1
answer
2k
views
Magento 2- How to Import cross sell products with CSV?
I have many products in my Magento2 store. I want to assign one product as cross sell product of all products.
Is there any way to assign cross sell product with CSV product import ?
- 2,387
0
votes
1
answer
832
views
Ｍagento 1 Update product categories to multiple root categories programmatically
In my Magento installation, I have created two root categories, one for each website.
Let's say in my UK website, it use root category that has categoryID 2. In my US website, it uses root category ...
- 2,014
0
votes
1
answer
186
views
Bulk Products import are not showing on front end
I have uploaded bulk products through using a CSV file. The products get uploaded successfully and can be found on the back end, but they are not showing on front end. When I edit a product and save ...
- 15
2
votes
1
answer
2k
views
How to import multiple images for a single SKU
According to M2 Docs:
If importing multiple images for a single sku, insert a blank row below the sku, and enter the additional image file names in the appropriate columns. The additional rows are ...
- 2,640
0
votes
1
answer
48
views
Not showing newly added products in magento
I have import products through magmi, products is imported successfully, but the products are not showing in frontend, please help me.
2
votes
1
answer
936
views
tax_class_name in product import won't change to none
I tried to import product by CSV file from backend. I fill the tax_class_name column to 0 but it won't make the product tax to None but Taxable Goods. And when i check at the database in tax_class, ...
- 846
1
vote
0
answers
1k
views
general system exception happened additional data: class name and class type already exists
while importing in magento 2 getting this error
general system exception happened additional data: class name and class type already exists.
when i check in var/import_history/filename_error.csv
...
- 492
1
vote
1
answer
816
views
Import bulk products with custom atributes fail
I am trying to upload 100 products at once with custom attributes from backend.
First I have downloaded some products I created with custom attributes to know how can I create csv.
Now I have the ...
- 13
3
votes
2
answers
1k
views
Key constraint error while importing simple products
I am getting an error when I am importing simple products in Magento 2.2.
The error is :
Category " has not been created. URL key for specified store already exists. in row(s): 1 General ...
- 31
1
vote
1
answer
2k
views
Magento 2: Products images are not showing on category page
I have a huge catalog and imported images for them by csv file. Unfortunately images are not showing on category page but they are showing on view page.
I executed all the commands such as:
php bin/...
- 1,063
3
votes
2
answers
3k
views
Magento 2 csv product import : How to escape commas in category name
I would like to import a product csv into Magento 2 through the standard admin UI. The category name contains commas Default Category/Grocery/Snacks/Fruit, Nuts, Seeds.
The (abbreviated) csv looks ...
- 193
0
votes
1
answer
957
views
images not imported through csv in magento 1.9
I tried to import products through import/export, everything gets imported but not image.
What I did was:
Flushed cache and re-index
Media folder provided permissions to 777
Place all images in var/...
- 609
0
votes
1
answer
527
views
Magento 2 import product VAT rate from csv
I have a product csv file which I would like import into Magento 2. It contains all the required product data including the VAT rate for each product. This is represented as a percentage which can ...
- 193
2
votes
1
answer
2k
views
on Magento2.1 how to import product with multiple category
Now i try
Default Category/Main/sub ,
Default Category/Main2/sub2
Default Category/Main/sub is working fine
but in Default Category/Main2/sub2 can't import product
Error Category Default ...
- 41
0
votes
1
answer
653
views
Can't upload Configurable product via CSV - can't find common element with products erroring?
I have been staring down this spreadsheet for the last six hours, so any help is greatly appreciated.
I am trying to upload about 2K SKUs of apparel product, I'm uploading via CSV. Of my about 80 ...
- 3