Questions tagged [import]

Denotes questions related to imports

4
votes
6answers
11k views

import/export error - magento 2.0.1

Firstly I export csv file from admin and keep only one row and delete the remaining row, after that I will change product name,category name and then import the file.I am getting the result in ...
8
votes
7answers
11k views

Magento 2 product import won't import images

I am importing products using the built in CSV import (System - import - products) All my data is imported fine, but I get an error "Imported resource (image) could not be downloaded from external ...
4
votes
3answers
3k views

Magento 2: Import multiple select attribute values using CSV

How can we import multiple select attribute values using CSV ? For example SKU "test" has two values for attribute "xyz" - "val1" and "val2". When I use both value as val1<space><comma>&...
2
votes
0answers
24 views

How to create system configuration for fileds of the custom table which is imports that fields using csv via import in admin configuration? Magento2.3 [on hold]

I have created the module to import CSV to a custom table. the columns of table should dynamically be added to the import.xml and not by code to import the CSV and not by code.in Magento 2 for example,...
1
vote
1answer
691 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
25 views

Best practices/methods for adding 100k products in Magento 2?

I have to add 100k products by the end of this week. Most of them are simple products but 30% are configurable products which each have 8 simple products, total 100,000 SKUs. I used Magmi (in Mage 1) ...
3
votes
1answer
710 views

Magento 2 Import categories using csv

I have around 500+ categories in my csv. I'm trying to import only categories using csv. Can anyone knows how to import only categories in magento 2 using csv?
2
votes
0answers
292 views

Custom csv Import not working in magento 2.3

While doing importing from backend for custom table its trowing following error systemException Additional data: Error in data structure: entity values are mixed but its correct validated in ...
2
votes
1answer
704 views

Import Product Data w/ CSV from command line (not dataflow)

I've updated a development version of my store to 1.9.2.4 from 1.7.0.2. I noticed that a plugin I used to handle inventory updates from the command line no longer works. I have over 15K products and ...
0
votes
1answer
800 views

Magento 2.2.1 Product Import Not Updating Assigned Categories

When updating my products via the add/update import process, the assigned product categories are not being updated. If I update by selecting "replace", it works. Example Product-A currently has the ...
2
votes
1answer
877 views

1.9.0.1 dataflow import customers. Different results when ran from browser or shell

I'm magrating to Magento, and I have a large amount of customers to import. I am using the dataflow profiles because more fields are available. The problem of importing dozens of thousands of ...
2
votes
1answer
277 views

Magento 2 - Custom module file upload configuration and save in custom module table

File upload in Magento 2 store configuration <section id="custom_section" translate="label" type="text" sortOrder="301" showInDefault="1" showInWebsite="1" showInStore="0"> <label>...
0
votes
0answers
47 views

Magento2 : Import/Export is not visible in Admin section

I am having an issue in Magento Admin. The import/export menu is not visible. When I open the URL directly, It shows a blank page. Please help, it's urgent.
6
votes
3answers
109 views

How to keep products synchronized in two shops

How can I transfer all products from one shop to another after clicking a button? We have a shop which is a copy of our real shop. We need to keep the products, prices, etc. synchronized in both ...
2
votes
3answers
910 views

Magento 2 : Customer import not working and gives “Import successfully done”

I have around 1000 customer to import when I try customer import using magento2 default customer import. Validation works perfectly and when I start import it gives me the message "Import successfully ...
2
votes
1answer
442 views

Customer login does not work after customer import via CSV (Hash not same)

I successfully exported my customers from Magento 1 into a CSV and then used the import tool in Magento 2 to import them. On the backend everything looks fine and all customers and addresses are ...
0
votes
2answers
831 views

Import Database Error: #1062 Duplicate entry '3-13-70-0' for key

I am attempting to export the Magento database from my current installation to a test installation before I have the test installation go live. Both installations are version 1.9.2.1. I can ...
0
votes
0answers
668 views

How to upload and read csv file import into database in magento 2?

How to upload the csv file and read import into the database magento 2? <?php /** * XXXX_ProductImport extension * @category * @package XXXX_ProductImport * @copyright Copyright (c) 2018 * @...
0
votes
2answers
753 views

Images not display both frontend and backend after import

I have try to import bulk images, after i import i got successful message, right after check front and back end there is no image, excel format : https://www.dropbox.com/s/ruh3bg6htuirybp/ready.csv?...
0
votes
1answer
32 views

Magento 2 - Import Product .csv via CLI

Actually, the desired requirement is quite simple. I would like to control and execute the import from the backend of the Magento 2 system via the CLI. This question was asked some time ago (2016) ...
0
votes
0answers
23 views

Take by Magmi a Magento attribute value

I would like to add to a price I have in CSV a percentage that I have on an attribute (when I update the product). For example, in my CSV I have: sku price xx 18,08 On Magento I have a ...
0
votes
1answer
33 views

Magento 2.3 what is "Empty attribute value constant' in import

Is anyone know in Mageno 2.3 product import a new field is introduced i.e "Empty attribute value constant" field. What is the use for
0
votes
1answer
1k views

Magento 2 : Import product from csv configurable product error

I am working on Magento 2.1.3 product import with CSV. I am getting a error while using following CSV file. download csv Error is "General system exception happened"
0
votes
0answers
39 views

Magento 2.3.1 error when importing stock - Cannot get auto increment value

I have installed fresh magento 2.3.1 and tried to import stock, but every time I got error "Cannot get autoincrement value". The product is added to store, but Quantity is empty, and Salable Quantity ...
1
vote
1answer
37 views

Problem with importing from Cludes ERP System to Magento backend

I am importing products from Cludes ERP System, but Product base image is not set in Magento backend:
0
votes
0answers
21 views

Can't edit custom options via CSV import - Magento 2

I'm trying to update custom option values using the Import/export function. I have exported products as CSV and edited the values in custom_options column. When I try to import the spreadsheet back ...
1
vote
1answer
32 views

Magento 2 : Is there any way to stop to sending email to customer while importing customer?

Is there any way to stop to sending email to customer while importing customer ? Is Disable Email Communication : OFF this helpful for that ?
3
votes
0answers
34 views

M2: The URL key for the selected store already exists

Sometimes during import products we receive issue: The URL key for the selected store already exists. We have found one website with solution: https://www.human-element.com/url-key-specified-store-...
0
votes
0answers
16 views

“General system exception happened” Error when doing the import process

I have had problems when importing, I get that error, I attach the file I used at the time of import Does anyone know how to solve the problem? My version of magento is 2.1.6 https://drive.google.com/...
0
votes
0answers
18 views

Configurable variation is unidentifiable - Magento 2.3.1

I'm getting the Configurable variation is unidentifiable error when trying to import the configurable items to Magento 2.3.1. I think I have the correct format for the csv, using the defined format, ...
0
votes
0answers
14 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 ...
0
votes
1answer
18 views

Import Orders to magento no stock products

Trying to import orders to magento from other platform. I have almost done except import products with attribute stock_data is_in_stock set to 0. If I set manually the value to 1 imports correctly. I'...
1
vote
0answers
21 views

Magento 2.3.0 URL keys regenerate on import

This is a serious issue that is occurring on numerous Magento 2.3 builds (I have tried) If we use the import function from a CSV with the "name" header, Magento automatically updates the URL key to ...
0
votes
0answers
10 views

How to import dimensions? M2.1.5 -> M2.3.1

Hi I am currently doing a fresh install of magento 2.3.1 as our last dev really fucked up the 2.1.5 environment. I'm working on importing products at the moment but can't for the life of me seem to ...
0
votes
1answer
18 views

Import reviews from Amazon

[M1] We are selling some products on Amazon that we are selling on our website. We have plenty of reviews on multiple items, and we'd like to import those reviews on our Magento site. I have ...
0
votes
0answers
38 views

Update products from CSV using import behavior Update only not add new

Can we update products from CSV but skip new products just update products that already exist. Like I have a CSV which has data with SKUs some already exist some are new but I want to update products ...
0
votes
0answers
75 views

Magento 2.3.1 import images with external link still not working

trying to pull image from external url during import but get: "1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 2" here is ...
0
votes
2answers
32 views

Magento2 : Get Category Ids from product import csv

product import csv containing category data which is given as below Default Category/Diagrams/Business,Default Category/Diagrams/Strategy,Default Category/Diagrams/Planning,Default Category/...
1
vote
1answer
903 views

Import csv issue (product.php on line 1407)

I just install the magento 1.9.2 and try to import my csv file through System -> Import - > Import. I received the following error message: Notice: Undefined index: _attribute_set in /app/code/core/...
2
votes
1answer
908 views

Magento 2: Importing Virtual products URL key

I'm trying to upload a configurable product with product variations. This did work fine for a while, but now I get this error: 1. Specified URL key already exists in rows: 3 If I analyze the ...
0
votes
1answer
643 views

Magento 2 : Need to import product image from external url

I just need to import all product images from external url , can i able to do this using default functionality in magento 2. If yes, how can i use this product images external url during import csv ...
1
vote
1answer
34 views

Magento2 - Failed to import products

We are trying to import products into Magento 2.2.5, but whenever we run the import, we get the following error: Imported resource (image) could not be downloaded from external resource due to ...
2
votes
0answers
23 views

Create import entity for attributes

I'm trying to implement a new import entity to be made available through the ImportExport module (which is actually extended by Firegento_FastSimpleImport2, but that's not relevant for this question) ...
0
votes
1answer
295 views

Programitically Import products using CSV in video url not set magento2?

I have created a script for import CSV products everything's working perfect but one issue is product video url not set. <?php use \Magento\Framework\App\Bootstrap; include('app/bootstrap.php'); /...
1
vote
0answers
21 views

Magento 2 dimensions attribute code changed

Currently I am trying to import products from a 2.1.15 store to 2.3.1. I have noticed i cannot import my dimensions like height, length, width. apparently magento changed the attribute code from ...
8
votes
1answer
2k views

How to change programmatically product stock status when product sku doesn't appears in provider data feed?

I'm using Magento CE 1.9.1 I made an import script to import products from a provider xml feed. This feed is update everyday at 3 a.m . My profider send me in his xml only products where are in stock ...
2
votes
1answer
50 views

Magento 2: Assign existing image to product with position

I'm looking to attach size charts to products in my store using the Magneto data import. I want to use the same image for each of them, and it's already on the server. So I've got a twofold issue. ...
2
votes
1answer
1k views

Imported image roles are lost on update in Magento 2

I use an import script to create products with associated images that are assigned to roles thumbnail and small image. It works well, products and images are imported and they display as thumbnail ...
0
votes
2answers
2k views

Magento 2 : Cannot set product stock status to “Out of stock” using csv

I tried to import a product using CSV with is_in_stock value to '0' and after the import, the stock status still shows "In stock" CSV looks like this : sku,is_in_stock DC3508BR,0 What am I ...
1
vote
1answer
68 views

Trying to upload images via CSV and getting an error

I'm trying to upload 1800 products using Magento import. I'm not running into any issues aside from the images. When I try to upload them I get an error: Imported resource (image) could not be ...