Questions tagged [import-products]

Denotes question regarding Magento Import Functionality specifically Import products

66 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
161 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 /...
3
votes
2answers
943 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 ...
2
votes
0answers
45 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.
2
votes
1answer
146 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?
2
votes
1answer
148 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
0answers
192 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 ...
1
vote
0answers
18 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
1answer
35 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 ...
1
vote
0answers
14 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 ...
1
vote
0answers
28 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:
1
vote
1answer
101 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 ...
1
vote
0answers
106 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....
1
vote
1answer
555 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 import page - it always loading. How can i ...
1
vote
0answers
184 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 ...
1
vote
0answers
86 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
0answers
41 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 ...
1
vote
0answers
47 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 ...
1
vote
0answers
138 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?
1
vote
0answers
339 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
1answer
128 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
vote
1answer
306 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 ...
1
vote
0answers
623 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 ...
1
vote
1answer
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
vote
1answer
1k 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 ...
1
vote
1answer
268 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 ...
1
vote
1answer
547 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....
1
vote
3answers
2k 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
0answers
83 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 ...
1
vote
0answers
35 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 ...
0
votes
0answers
9 views

Magento 1: import products *directly* to multiple websites using csv import

We would like to import products via magento csv and add it to multiple websites in 1 go. Currently the data looks like this. sku name _product_websites PR.123 Blue socks domain.com ...
0
votes
0answers
14 views

Magento 2.x Image roles not imported through import however displaying on all products and in admin how do you update through MYSQL?

On importing 8K products onto Magento 2.3.4 all images and products have been added, however no roles are assigned, the environment is multistore (2 stores) The store ID is 2 How do I assign the roles ...
0
votes
0answers
13 views

How to Bulk Import product video using csv import sheet Magento 2

I'm trying to import product video using csv import. Is there a way to import product videos..?? How can i achieve this using import..?? Thanks in Advance.
0
votes
0answers
32 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 ...
0
votes
0answers
27 views

Magento 2.3 - how to convert simple products into configurable products?

I have all simple products in magento. How can I convert them, with a php script, into configurable products? I will associate simple products with them by importing them from csv files. Thanks.
0
votes
0answers
18 views

Magento 2 csv product import change separator

I am trying to import a product csv to magento 2 instance using command line . I have followed this link https://www.thirdandgrove.com/insights/importing-products-magento2-part2/ This code is ...
0
votes
0answers
10 views

Wyomind Mass Product Import

i'm using this plugin that worked fine until now. If i have a single store or multistore with product with the same price everything gone well. But now i need to set a different price for the same ...
0
votes
1answer
110 views

Magento 2: Unable to import products due to Invalid URL Key Error

I have made an upload file with both simple and configurable products. I have also specified all the necessary configurable_variations. I am using the Add/Update import behaviour When I click Check ...
0
votes
0answers
65 views

Magento 2 Read data from json file

I want to import products from a json file. How can I read the data from the json file as array? Here is my sample json [ { "id": 632910392, "title": "IPod Nano - 8GB", "...
0
votes
1answer
49 views

Import data in magento 2

Hi i want to import product on magento 2.2.9 if can any one help me with a good tutorial Also all my pictures are on externe server. I use Builderall platforme wich has magento 2 already installed ...
0
votes
0answers
23 views

Magento 2: Product Import through csv without SKU

can we import products through csv without sku column? how to add with same unique attribute same as sku ? note: don't suggest add random value for sku.
0
votes
0answers
21 views

Magento1.9 - Unable to upload images in bulk via CSV import

I have a Magento1.9 website and have too many products. I'm unable to upload images of too many products in a single import. ( even after everything is right ) Suppose I have a CSV sheet of 100 SKU ...
0
votes
1answer
13 views

Magento 1 - Hide products from customers

We have a problem with the visibility. We need to add some new configurable products, but the customers should not be able to see them, until we finished testing them. How are we supposed to do this ...
0
votes
1answer
17 views

Decoding Failed: Syntax error

Hi i use csv file to "import" bulk products. Checking Data with no error. but when i import the csv file, " Decoding failed: Syntax error"come out if anyone know why ?
0
votes
0answers
37 views

Custom import script addImageToMediaGallery error

i have custom import script which i use to import products(from excel sheets), it works just fine, although on some products it gives error regarding image. Script runs as cronjob since manufacturers ...
0
votes
1answer
124 views

In Magento 2 Product Update via Import CSV file

Need to update the product data via CSV file through import action. I am facing an issue to display the bundle product in front-end of the website after updating the product via import action. ...
0
votes
0answers
23 views

Import custom related products through CSV

I have created a custom tab for Alternative Products and have to import SKU's through CSV like _links_related_sku in CSV. I am unable to import my products in custom alternative products tab in ...
0
votes
1answer
37 views

Magento 2 : Import product with external image URL

I have a CSV file with image field is external image URL, how can I import it, hope anyone help me.
0
votes
0answers
36 views

Magento 2 : Change column title when import product csv file via programmatically

I have a product CSV file when I import it in Magento admin, I want to change column title eg : in the original file: NAME, CATEGORY...etc and I want to change to: name, categories...etc, hope anyone ...
0
votes
0answers
64 views

Magento 1.9 : Product importing not working

I have tried both Import/Export and the Dataflow method for importing the products in Magento 1.9. In both cases, it's giving a success message. But the product not importing to the backend. Can you ...
0
votes
0answers
44 views

Import product from csv error Missing Column: sku

I'm using Magento 2.3.2, I tried to update product stock with my CSV that looks like this: It's separated by comma, first column is for sku and second column for qty, but when i tried to import it ...