Questions tagged [import]

Denotes questions related to imports

Filter by
Sorted by
Tagged with
1
vote
0answers
13 views

Magento 2 I am trying to upload CSV file for the configurable products. getting error like attribute code does not exists

I am trying to upload this CSV file for the configurable products. Unfortunately, the error I'm facing is Column configurable_variations: Attribute with code "rom" does not exist or is missing ...
2
votes
4answers
80 views

Can't import database Magento 2.3.3

I have created a backup database by command line: php bin/magento setup:backup --db Then I import it to my new PHPMyAdmin, But it shows a bug: Static analysis: 4 errors were found during ...
0
votes
1answer
15 views

M2 - How to fix wrong customer import

I have a live webshop and imported user from the old webshop. The amount of accounts is around 6500. The was something wrong with the import so everyone has a wrong address in their account. So I made ...
0
votes
0answers
12 views

Magento 2 - Keep csv data description spaces while creating programatically

I am trying to create a new product using CSV custom script for which I refer Programmatically create a simple product in magento 2 Which is creating a product but it removes all spaces when we set an ...
0
votes
0answers
47 views

Magento 2 Custom Import Not updating the exists data

In Magento 2.3, I am using this link to import the custom csv data. Adding, deleting, replacing are working fine. But the data is not updating with existing data. Anyonce came across this issue, ...
0
votes
1answer
20 views

Export Magento 2 Orders

How can I export Magento 2 orders and then import them on a new system? The new system has the same products in front-end and as far as customers are concerned. However, the way it works in the back ...
0
votes
0answers
19 views

Image import errors (csv)

I'm trying to import 500 images (at a time, 13000 total) using a csv. I keep getting the following error: Imported resource (image) could not be downloaded from external resource due to timeout ...
0
votes
1answer
25 views

Magento 2.3.3 - Import Newsletter subscribers along with email, Name, Type, Website, Store, Store view from CSV

I run a multi website and store setup, on PHP 7.1 I'm trying to import newsletter subscribers from a CSV as follows, which is in a CSV file called subscribers-import.csv in the root dir. I'm using ...
0
votes
1answer
51 views

Magento 2.3.3 - import newsletter subscribers from CSV

Running a multi website and store setup. Example Website - Japan Store - JP Store View - JP I'm trying to import newsletter subscribers from a CSV. I'm using the following code in a file called ...
0
votes
0answers
13 views

Magmi image processor import issue

I am using Magmi to import my date, have remote image addresses. The problem is when I import them, all images are same! I am Using version magento 2.1
0
votes
0answers
18 views

products csv import categories not updated in magento2

I'm importing product sku and category ids using product import in magento2. but not working please anyone help me. eg: sku,category_ids test_123,2,5,12 thanks
0
votes
0answers
19 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
32 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
24 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
29 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
30 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
17 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
19 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
48 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
2answers
53 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
23 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
15 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
31 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
40 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/...
1
vote
0answers
23 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
51 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
32 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
72 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
34 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
43 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
23 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
27 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
21 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
45 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
70 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
39 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
70 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
26 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
32 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
125 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
140 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
208 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 ...
1
vote
1answer
528 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