Questions tagged [import-products]
Denotes question regarding Magento Import Functionality specifically Import products
75
questions with no upvoted or accepted answers
3
votes
0
answers
1k
views
Value for '*' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s):
Not sure what is causing this problem.
The previous line which has the same value is valid. But this line is invalid.
- 31
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
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
2
votes
0
answers
249
views
Magento 2.2.4. Product Import additional_attributes Error Issues
I have a problem with Magento 2.2.4. when I try to Import new products into a website, even when I try to Import the Exported products I already have on the website, I get this kind of error.
Those ...
- 21
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
2
votes
1
answer
309
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
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
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
1
vote
0
answers
69
views
Magento 2: Product images are not generated in media cache on importing products
Facing weird issue for 2-3 days. Images are not showing on frontend Whenever I import new products using firebear module or default importer.
I tried php bin/magento catalog:image:resize, ...
- 1,864
1
vote
0
answers
18
views
Upload of csv to add related products to a parent product scrambles order of skus in related_skus column
I use products that have related products (so they pull them automatically when the parent product is selected) - i need them as separate items for accounting/inventory purposes, but i sell them in ...
1
vote
3
answers
289
views
How to transfer products from Magento 2.4.2-p1 to Magento 2.4.4 which give Errors during export and then import?
We have a live production Magento ver. 2.4.2-p1 with 2224 products but have a lot of problems which stem from me using the official Magento Migration Tool to migrate from Magento 1.x.
Because of this, ...
- 178
1
vote
0
answers
21
views
Store wih diferent languages have broken images after programmatically product import
I have a script running in cron to import products.
This import creates simple products and then creates a configurable one with all these simple ones as children of that.
During this process, I ...
1
vote
1
answer
83
views
Import options for simple products CSV - pros vs cons (Magento 2.2.8)
Currently I'm using magento 2.2.8 and so far I know about 3 main options to import simple products (using csv file).
a) csv import (Magento seems quite slow on this end) and only allows batches of ...
- 189
1
vote
0
answers
67
views
Magento 1 Import - If "Use Default Value" checked, skip to default view?
I'm starting to learn a bit about Magento import / export tool.
The problem I'm having is that our store consists from 2 stores:
- Default View
- Canada
- USA
The way that we set it up is ...
- 756
1
vote
0
answers
47
views
Magento 2 : Import product error
I have a product csv file and when I import it in admin then is the result https://prnt.sc/pf3rhl Thank in advance.
update:
I did change all ” to " and this is the result:
- 671
1
vote
0
answers
614
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
1
vote
0
answers
702
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,924
1
vote
0
answers
182
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 ?
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
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
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
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
574
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
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
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
1
vote
1
answer
290
views
Products import successully with dataflow profiles but won't show on frontend
Magento Version 1.9.3.6
I am able to import products using Dataflow profiles successfully.
All Cache is disabled.
Tried re-index all after import.
but still products don't show up in frontend.
If I ...
- 347
1
vote
1
answer
908
views
Import Module to allow for multiple CSV imports in a batch setting
<?php
/**
* Copyright © 2013-2017 Magento, Inc. All rights reserved.
* See COPYING.txt for license details.
*/
/**
* Import model
*
* @author Magento Core Team <core@magentocommerce....
- 125
1
vote
3
answers
4k
views
Importing produtcs with images from .csv file error
When I try to import a .csv file with products and images I got this error:
Imported resource (image) could not be downloaded from external
resource due to timeout or access permissions
In the .csv ...
1
vote
0
answers
98
views
Unable to reindex product eav indexer
Unable to reindex Product Eav Indexer.. I am getting that error message
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-82-1-7.0000' for key 'PRIMARY', query was: INSERT INTO ...
- 492
1
vote
0
answers
41
views
How to redirect after successful import via DataFlow import in magento 1.9.2.4
I am using System->Import/Export->Dataflow-Advanced Profiles for importing products to store.
I have inherited Mage_Adminhtml_System_Convert_ProfileController class. Using this it allows me to import ...
- 622
1
vote
1
answer
507
views
Magento 2: Is there a way to import more than 200 products at a time?
My import is only addressing the first 200 parts, is there somewhere to change this setting?
I am using the built in import function
My inventory is 8870 lines but it only is importing the first ...
- 51
0
votes
1
answer
33
views
Magento 2: REST API Endpoint uses wrong locale
I'm implementing an endpoint where the users can create products from a CSV, using the same logic that Magento implements in the backend to import CSV seems to work great but I have a problem, the ...
- 1
0
votes
0
answers
33
views
Errors when Importing products in Magento 2.4.5-p1
Magento 2.4.5-p1
I exported products from Magento version 2.4.2-p1. I then go to import the CSV file into my Magento 2.4.5-p1. The check goes mostly OK and it says it can import the data. Then, I ...
- 178
0
votes
0
answers
37
views
M2 Product Import "Multi Select" upload bug - Returns error when only 1 option given
I'm trying to bulk upload a whole bunch of product attributes. When I attempt to upload values for attributes with "Multi Select" values I get this error message.
Value for 'x' attribute ...
- 1
0
votes
0
answers
298
views
IMPORT PRODUCT : url key for specified store already exists
I have this method which is meant to save the product during an import script.
protected function saveProduct($product, $urlKeySuffix = 0, $baseUrlKey = false)
{
$savedProd = null;
try {
...
- 1,049
0
votes
2
answers
53
views
Importing products. 3rd party or native?
I'm wondering if the magento 2 import is worth using. Back in M1 this process was just horrible and I remember only a couple thousand products taking over a half hour and then timing out partway ...
- 55
0
votes
1
answer
200
views
Update Product Stock and Price by uploading CSV using Command Line
I am updating products stock and price by uploading CSV in adminform magento2.
I want to perform the same thing using command line.
Is it Possible ?
How ?
0
votes
1
answer
199
views
Uploading Product Brand CSV in magento2
We have 67 products where we have just uploaded but the "Product Brand" has not been selected.
I have tried the following:
A singular coloumn with title "product_brand": Rudy ...
0
votes
1
answer
28
views
Magento 2: Import will not import more than 1 product at a time
Magento 2 version 2.2.6 will not import more than 1 product at a time.
The import will not create, update, or delete.
I've checked the import history, but there are no errors. I've validated the ...
- 1
0
votes
1
answer
160
views
Is it possible to use (system -> Data transfer -> import) products csv programmatically
I want to create a cron module (in Magento) to download some CSV to the import folder, and then use the (system -> Data transfer -> import) feature to add/replace products programmatically, but ...
- 2,201
0
votes
1
answer
152
views
Magmi: No records found in datasource
Using magmi 0.7.24 for Magento 2.4
Importing one simple and configurable product
Placed the file in var/import
File is detected. I ran import and get the following output
Import Profile:default
Import ...
- 590
0
votes
1
answer
217
views
CSV-import error: "Content of uploaded file was changed, please re-upload the file"
Has anyone had this problem?
If I try to import a .csv file, it instantly says "Content of uploaded file was changed, please re-upload the file"
- 7
0
votes
0
answers
256
views
Unable to import drop-down attribute options with product import Magento2.4.2
I have created an attribute Model with type dropdown and added options values.
Assign the value to some products and export the CSV and it is working fine.
Add some more products and try to import ...
user99630
0
votes
1
answer
98
views
Can't see (imported) configurable products in catalog or search
I may need help...
If I manually create a configurable product I see it fine in the frontend.
However when I import products from stock with my homemade script, they don't show up.
On my backend all ...
0
votes
1
answer
45
views
Additional Data is not being imported into produces (full imports and focus additional data imports)
FIRSTLY I should note that all product data is importing correctly except the additional_attributes column.
I've been struggling for the past few hours with getting additional data imported into my ...
0
votes
1
answer
764
views
Importing existing products: Integrity constraint violation: 1062 Duplicate Entry
I have been importing existing products to a local environment through the admin dashboard. I realized that many of the products I imported didn't include their attributes, so I went back to make sure ...
0
votes
2
answers
695
views
Update products using csv import but dont update url_key
I have products on magento 2.4.0 now when I use product import (Add/Update & also replace) to update product data, it throws below error
Url key: 'this-is-product-url-key' was already generated ...
- 150
0
votes
0
answers
105
views
Magento 2: custom product import taking long time
We had a magento 2.3.0 multi-website shop and we use custom product import for shops.
We use CLI script as a config for each shops and execute import with a common custom module handing few checkings.
...
- 1
0
votes
1
answer
218
views
Simplify Product Import Export in Bulk with Custom Attributes Magento 2.3.5
I have requirement to import products in bulk from CSV file which have multiple custom attributes of different type (Multiple Select, Dropdown, Text, etc.). Standard Import/Export option for Magento ...
