Questions tagged [import-products]

Denotes question regarding Magento Import Functionality specifically Import products

Filter by
Sorted by
Tagged with
4
votes
2answers
572 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 ...
4
votes
2answers
1k 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 ...
3
votes
0answers
179 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
998 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
1answer
620 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
votes
2answers
2k 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 ...
2
votes
1answer
1k 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 ...
2
votes
1answer
124 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 ...
2
votes
0answers
53 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
187 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
164 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
195 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
2answers
5k 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
vote
1answer
24 views

import products using fast_simple_import

Anyone know a stable way to import thousands of products to magento using fast_ simple_import and syncing updates from external POS without relying on SKUs? Thanks, Rob
1
vote
1answer
521 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, ...
1
vote
1answer
115 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 ...
1
vote
1answer
380 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 ...
1
vote
1answer
304 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', ...
1
vote
2answers
149 views

What is the best way to transfer data of Magento 2? + error “Unable to unserialize value.” [duplicate]

I would like to change the server and move Magento 2.1.0 from server A to server B without any difference in data, theme, extensions, and configuration. only the domain will be a change from www....
1
vote
1answer
115 views

SOLVED: How do I sort configurable product super attributes on import? (M1)

My theme and business requirements stipulate that the super attributes for configurable products be presented in a specific order. While this can be changed in the Admin while editing a product by ...
1
vote
0answers
19 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
28 views

What is the folder where the images need to be for mass importing products?

What is the folder where the images need to be for mass importing products ? I seen there in import admin panel that is var/import/images/products_images but no is not working
1
vote
1answer
36 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
17 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
29 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
122 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
140 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
607 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
1answer
299 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 ...
1
vote
0answers
226 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
87 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
42 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
48 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
151 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
364 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
135 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
321 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
682 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
621 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 ...
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
271 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
567 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
3k 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
1answer
257 views

Magento product import using magmi Base Image, Small image and Thumbnail fields not selected

I have imported products, categories and images successfully using Magmi but Base Image, Small Image and Thumbnail attributes of the image are not getting selected.
1
vote
0answers
84 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 ...
1
vote
2answers
242 views

Magento admin menu with file upload [duplicate]

I have developed a website in magento version 1.9.2, i have lot of products in excel, so I want to upload this file in magento admin, for that how to create menu and upload file in magento back end, I ...
0
votes
1answer
977 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 ?
0
votes
1answer
535 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 ...