Questions tagged [import]

Denotes questions related to imports

Filter by
Sorted by
Tagged with
0
votes
1answer
27 views

Magento 2 : Import product image with sku

I have a CSV file product image with SKU, I did import all product SKU in admin but not have an image. here is the CSV file I need import.
0
votes
0answers
14 views

Magento 1.9 product import xlsx to csv

I am trying to write a module that converts the given Xls file to default Magento CSV format? Is there any better way to do this?
1
vote
0answers
21 views

Magento2 error while updating product URL keys

Getting this error while importing produdct for updating product URLs SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (...
0
votes
1answer
24 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
1answer
15 views

SQL Error when importing bulk data. Product_id goes out of sync with Entity_id

When importing about 12000 rows of products from a .csv file, it suddenly gives me the following error: General system exception happened Additional data: SQLSTATE[23000]: Integrity constraint ...
0
votes
0answers
16 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 ...
1
vote
1answer
44 views

Magento 2 : Import product with custom csv

I have a custom product csv file https://drive.google.com/file/d/1f9t4REhn8-Ant58zRB6S0yRx1Rh1PctX/view?usp=sharing how can I import it in Magento 2. Do you have any idea?
0
votes
1answer
34 views

Magento 2: import product with many other data fields

I want to import many products with many custom fields. How can I do that, I hope anyone helps me, Thank in advance. Here is notice when I import product with many custom field
0
votes
1answer
19 views

Magento 2: Problem with Product Links

During an Import to Update Product prices, I made a mistake. I leave the value for the Product Link empty. After the Import all Product URL change and got the value from the Product name. To face this ...
0
votes
0answers
14 views

Getting import errors from csv even though data is valid

When I try to import products via csv, I get import errors on valid fields. For example, I have a color column, and sometimes it'll randomly throw an error for Black or White. Is there a place that I ...
0
votes
0answers
25 views

Magento 2.3.2 - Import / Export not display attributes

I try to export today all of my products and I observe that I can't do this because the attributes not display in that section. Also if I press that Continue button I have this error: Please correct ...
0
votes
0answers
29 views

Bulk Image Import

As the title says, I've ~5k images to import. What's the best approach? I'm not thinking in using CSV file, so what should I do? I'm thinking in coding a module that iterates through all my products ...
0
votes
0answers
23 views

Magento 2.3.2 - Product import duplicates images

Running Magento 2.3.2 on PHP 7.2 CSV being uploaded has one image for base_image, small_image, thumbnail_image, swatch_image, additional_images. When products are imported, product images are ...
0
votes
1answer
10 views

Magento2.1 image importer

I want to import images into magento2.1 with default importer. My problem is that I added image folder into pub like this: pub/media/catelectronicpic/mobile/1.jpg pub/media/catelectronicpic/...
0
votes
0answers
16 views

Magento 2 Column names: “_super_attribute_price_corr” are invalid

I'm trying to do a Magneto 1 to magneto 2 import, using the built in Magento 2 importer. I keep receiving the error "Column names: "_super_attribute_price_corr" are invalid". Did the attribute name ...
0
votes
2answers
32 views

Magento 2: Other required columns in CSV to update Name, Quantity & Price

I want to update products on my Magento 2 Website with csv bulk import. I have downloaded the export file but it has too many columns. I will only update the Product name, Quantity & Price. ...
0
votes
1answer
30 views

URL key for specified store already exists. When importing

M 2.3.1 We are importing via Firebear. When I import I am getting success.. the product imports but I get this error: URL key for the specified store already exists. Whenever I try and SAVE ...
0
votes
1answer
52 views

How to Import Orders Programmatically with all the product type in Magento2?

I am Looking for the Order Import Programmatically with capable of importing all the product types and multiple products able to import that also I need specific billing details to be included.
0
votes
0answers
33 views

How to import configurable product in Magento 2 using custom CSV file

I want to import configurable product in Magento 2 using a custom CSV file. My CSV file like this How to import it with this file? Please help me! UPDATE I can import by this CSV but it not show in ...
0
votes
0answers
40 views

Magento 2: Categories import via CSV not updated same name child category as assign in different parent categories

I am importing categories via CSV and it is working. After updating categories data like description, is_active, etc. But same name categories are not updating in different parent. I want to update ...
0
votes
0answers
22 views

Magento stop when will import products

I'm start using magento few days, I have imported product from a csv file and was ok. But now, when I setup to import products from a csv file they stop and not work more. I already reindex and ...
0
votes
0answers
22 views

Line break into Magento CSV import description field

I need some help because I don't know how to fix this problem. On my import CSV, I have a description field but when I go to the front office after the import, the line break is not taken into ...
0
votes
0answers
26 views

Magento 2 programmatically order import is not working with multiple product only one item price display in order details

Magento 2 programmatically order import is not working with multiple product only one item price display in order details and other product price and qty 0
0
votes
0answers
20 views

Cron job image import issue - Magento 2.3

In Magento 2.3, I am importing data from the .xml file. The product name, SKU and product description i can import via cron job but I cannot import the product image. Can you help me? Thanks in ...
0
votes
0answers
10 views

How do stores with large catalog map item image to swatch colors?

So I have thousands of items (all config products) that have a few different colors (simple products) and have about 8 different swatch colors and the only data that have the only relation to color is ...
1
vote
0answers
17 views

help with importing customers into magento 2.2.7

I have tried to import the attached listed using the example CSV sheet from Magento. But I keep getting an error that the headers are wrong. I attached the two files can you tell me what I am doing ...
0
votes
0answers
31 views

Configurable Products Import Issue

I am trying to upload this CSV file for the configurable products. https://docs.google.com/spreadsheets/d/1yJBI_rS7miln6yATN6TYgoh3H4RSyty4WKJI9zNz1aw/edit?usp=sharing Unfortunately, the error I'...
0
votes
0answers
58 views

Magento2.3.0 Getting error, when Import Group product via CSV

I am using magento2.3.0 when I import CSV through group product with associate product getting an error in back end side. If anyone has an idea please share your inputs. {"error": "Invalid file ...
0
votes
0answers
36 views

Can't import cross-sell when cross-sell sku contains space

In "System, Import/Export, Dataflow Advanced Profiles" I have a profile for importing Cross-sell. It works fine; however when the cross-sell SKU contains space it is not imported. The product itself ...
1
vote
0answers
31 views

Import new database after category description not showing in magento 2

Hello I have import new database and category description no showing. Description.phtml no working. But in old Database everything is good. is that import Database issue? Where i find error in ...
0
votes
1answer
44 views

Undefined index: category_id in Magento 2 Import

I'm trying to import some data into magento for some custom atributes, it seems to get some far through the sheet and then errors with the following message: Notice: Undefined index: category_id in /...
0
votes
0answers
24 views

Special price set with schedule date : M2

In magento2 enterprise edition, we need to set a schedule for the special price for a particular product from the product edit page. I have tried to import special price with schedule date but the ...
0
votes
0answers
26 views

Import customers without e-mail notification?

How can I import all our customers from Magento 1 to Magento 2 without any e-mail notification? Is this possible with the default importer from Magento 2?
2
votes
0answers
28 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 [closed]

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
71 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) ...
6
votes
3answers
135 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 ...
0
votes
1answer
110 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
29 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
298 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
0answers
77 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 ...
0
votes
0answers
35 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 ...
3
votes
0answers
62 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-...
1
vote
1answer
64 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
45 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
19 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
38 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 ...
1
vote
1answer
53 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 ?
0
votes
0answers
11 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
38 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
25 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/...