Questions tagged [import]

Denotes questions related to imports

2
votes
2answers
6k views

magento 2 how to update stock using import csv

I need to update my stock everyday in magento 2 but i dont know how it works. Do i have to import the same full stock with all columns of my stock.csv and set the qty,is in stock columns with new ...
0
votes
1answer
32 views

Magento 2.1.17 product imported but product images not show

I want to import product in Magento 2.1.17 product imported but images show error - Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in ...
0
votes
0answers
20 views

Create custom module to import CSV of custom table M2

I created a custom module to import a CSV of custom table but when importing the CSV I get the loader always and the 500 error that say invalid data or file did not upload. Here is my table structure:...
1
vote
1answer
29 views

Import csv in magento 2 is not working and show error “invalidAttributeName”

Import csv in magento 2 : Duplicates found in column names I want custom import data to custom table " profilers " but it not working and show this error. I followed http://www.blogtreat.com/how-to-...
0
votes
0answers
26 views

Importing csv issue in order to populate table on Magento 2.3

i got a problem while i was trying to populate a table on Magento 2.3 I dont know why is this appearing, i was trying to populate the table salesrule_coupon with the following data on the csv ...
3
votes
1answer
2k views

Magento2 Product import (image filenames)

I'm not sure that this is a bug, as it's intentional from the looks of it, but ... I'm working on a migration from Zencart and the original site's media folder has been downloaded and we've written a ...
0
votes
0answers
37 views

What is best way to move database from Magento 2 to Magento 1

I wanna move product category order from Magento 2 to Magento 1. what is the best way for this? I create export from product and import to Magento 1 by default tools on manage but I get some error ...
2
votes
3answers
4k views

Import only the products from magento 1.9 to Magento 2.1.8

I am creating a new site with Magento 2.1.8. I need to import only the products from an old site that is running on Magento 1.9. I want my old site to still be fuctional even after copying the product ...
0
votes
1answer
78 views

Import a csv file in Bo magento 2

We have prepared a script that convert the csv of product that belong to our customer then we converted to the format that magento accepted (mapping of attributs with some condition on attributs to ...
1
vote
0answers
28 views

Import users/customers in Magento 1.9 without overwriting users/customers users passwords

As per title, I'm exporting users/customers from a previous Magento installation via the Dataflow functionality. I've a problem with the import: the new installation already has some users/customers, ...
1
vote
0answers
39 views

how to Import CSV in magento 2 and insert in database Table

Here am added import custom upload drop down to magento backend succesfully. while am importing data its not getting insert into database, its showing Please enter a correct entity model. error class ...
1
vote
1answer
46 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 ...
3
votes
0answers
109 views

504 gateway timeout while import customer address CSV In Magento2

http://website.com/admin/admin/import/validate/key/40cc16dabfa0d1fb09a6cb9e62433b9880e4f3f0e024eb1c517d832fa47c225d/?form_key=s235x0mqERyjXLqX 504 (Gateway Timeout) `validation.js:185 while ...
2
votes
3answers
4k views

Magento 2 Update Prices with CSV

I want to update just the prices of all products in my Magento 2 store and to do this quickly and easily i have a CSV with sku and price and was hoping price could be updated using sku as an ...
0
votes
2answers
2k views

Skip import row, is not valid value “” for field “type”

I know there are a few issues with this already, but I have tried some of the solutions.But they dont seem to work. Is there a default set of fields that the CSV must have. I have checked my CSV and ...
2
votes
1answer
45 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
1answer
2k views

Magento tax_class_id not importing

I want to import bulk products using csv template in Magento. I am unable to import a column tax_class_id. I have given the value as eg: MA001234. The datatype used in backend is 'int'.
0
votes
1answer
636 views

How Importing Images with Labels using addImageToMediaGallery in magento2?

Magento2.1.x I had a problem adding a product Image Label programatically. Here's the code I used: $imageLabel1 = 'Test1'; $imageLabel2 = 'Test2'; $imageLabel3 = 'Test3'; $product-&...
0
votes
1answer
2k views
2
votes
3answers
545 views

after configurable product being imported, on editing it shows attributes to make configurable(like you are creating first time)

I have successfully imported a configurable product with all it's simple products. But on editing the configurable product from backend, it shows global attributes to make configurable product like ...
3
votes
2answers
307 views

How to display errors for product imports

When I import product using the Import functionality in Magento (2.2.1), I sometimes get an error saying "Maximum error count has been reached or system error is occurred!". According to the Magento ...
0
votes
0answers
27 views

How import image from csv only the first import job?

I have a problem when I import image in magento 2 from csv. After first import job, in the next add/update import (with same image name in csv)I find an added image for each import For example if I ...
0
votes
1answer
44 views

Magento 2: CSV Importing issue ,import successfully and did't show any products

While importing product CSV Magento didn’t give any error and import successfully. but didn’t show any products on customer view. If products already added it didn’t update the product content. I ...
0
votes
1answer
569 views

Custom csv import to a custom table

I want to make a custom csv import functionality to a custom table. I have added the custom table using another module. But my custom import module doesn't seem to work . I followed this link : ...
1
vote
2answers
65 views

M2 Importer: Value for 'visibility' attribute contains incorrect value

If the importer runs with cronjob I get always the same errors on all lines: Value for 'visibility' attribute contains incorrect value, see acceptable values on settings specified for Admin in ...
1
vote
0answers
32 views

Imported products and categories system urls return 404

We are setting up import of products and categories from suppliers XMLs. The idea is to have it automatic and we have successfully imported products and automatically generated categories using this ...
0
votes
2answers
73 views

2.3 to 2.3.1 upgrade (commerce/enterprise)

So far the upgrade went pretty smooth but now i have a few outdated modules and it's asking me to run the setup:upgrade on cli but i keep getting a SQLSTATE general error: 1813 Tablespace for table '...
1
vote
0answers
90 views

Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s)

I'm importing products via csv and get the following error: Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s) what I've noticed ...
3
votes
5answers
1k views

Bulk product import error SKU not defined

I have a product sheet with some 200 odd products. When I am trying to import these product I get an error saying "Skipping import row, required field SKU not defined", even though all the SKUs are ...
2
votes
1answer
58 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): ...
0
votes
0answers
10 views

Missing rows after a succesful import of a CSV file. Any ideas of why's this happening?

I've been having this issue ALL day long. Each time I try to import a CSV file in Magento, everything goes quite well, no errors, no changes needed, then I get the "Import Succesful" notification. ...
0
votes
1answer
33 views

Importing product images in specific sequence / order

I import images into Magento as described here https://docs.magento.com/m2/ee/user_guide/system/data-import-product-images.html and here Product import csv images not getting imported : I upload the ...
2
votes
1answer
125 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 ...
1
vote
1answer
575 views

How to update data if product sku already available in magento using custom script for product import?

I have created custom import script for simple product csv import in magento. It is working fine for the newly products. But I want to update the products if sku already exists. How can I achieve ...
1
vote
0answers
553 views

Magento2: Import Export to update multiple product attribute settings?

Can I use Magento2 's Import or Export features under Settings in the Admin to make this change: "Storefront Properties - Allow HTML tags on Storefront, change to Yes" for multiple product ...
1
vote
1answer
41 views

Magento 2 Import/Export Options Missing

I've installed Magento 2 and under System -> Data Transfer there are no options. Do I have to enable them somehow?
0
votes
3answers
75 views

Set programmatically added attributes to product

I'm writing cron module to import products (Magento 2). In this module I'm adding attribute, attribute value and assign this new attribute value to product. It sounds easy but new added attributes and ...
1
vote
1answer
574 views

Upload csv file with products. not working

i have a job of making a new shop for a client. He has an existing shop in another platform - Dandomain The client has over 1000 products, so clearly i want to make an product import. Dandomain have ...
2
votes
2answers
1k views

Error 500 internal server error validate key magento

I'm new to Magento which makes me a big newbie. I have recently set up a localhost store using XAMPP. Now I want to import 500 products with my CSV file. I've looked up the CSV file structure and I ...
0
votes
1answer
240 views

Magento 2.2.1 cannot import custom options in different store view / language from another product does not work

In product ID 192, the product has a color option, and I have translated it for 3 different store view / languages In FR In product ID 191 i will the same custom options like in product 192. I click ...
1
vote
1answer
33 views

Magento 1.9: Massive set customer confirmation attribute

I imported over 3000 customers in magento, I need to set them all as confirmed. How can I do?
0
votes
0answers
26 views

How to import a CSV in Magento 2 of configurable product?

I have multiple products that are configurable and there is a problem that some child has same variations but with different SKU or Magento does not accept more than the allowed configuration so I ...
2
votes
1answer
34 views

General System Exception Magento 2 UTF-8 BOM

I have been uploading products to Magento 2 for some time using import via CSV. The first chunk worked fine and the second is throwing a general system error. UTF-8 BOM is being used... very ...
2
votes
1answer
564 views

Insert product id into custom table while importing products in Magento from csv

I have created a custom admin module using module creator with entity type "Flat" and it created 2 table in my database. Now I need to insert product id in one of table when importing products from ...
1
vote
1answer
169 views

Import Product Dimensions (Length, Width, Height) in Magento 2

I am trying to import dimension data to a Magento 2.2.6 store. The Magento attributes are present on the product, but I cannot figure out how to import to these fields. I have tried length and ...
2
votes
0answers
139 views

Why can't I import attribute values?

I've created a new attribute - GTIN. All I want to do is import my barcodes into the GTIN field per SKU. sku,additional_attributes AM0005930-34,gtin=08033546253915 I've created the above .csv, but ...
5
votes
1answer
2k views

Magento 2 replace product images via CSV import

I'm following this tutorial http://docs.magento.com/m2/ce/user_guide/system/data-import-product-images.html to upload and assign images to product. I have successfully completed this process but i ...
19
votes
12answers
13k views

What is the most common process for importing the products?

What is the most common process for importing products? Does everyone use the product import/export tool? The CSV file format is not something that the client is likely to fill in and if they try it ...
8
votes
6answers
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 ...
3
votes
0answers
25 views

Import CSV for products with new sub categories

I'm importing a CSV file with new subcategories not already created. Some times products imported correctly and others it gives me: general system exception Asymmetric transaction rollback Anyone ...