Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [import]

Denotes questions related to imports

0
votes
0answers
29 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 ...
1
vote
0answers
26 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
27 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
0answers
27 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 ...
0
votes
0answers
21 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 ...
1
vote
2answers
28 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 ...
1
vote
0answers
48 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 ...
1
vote
1answer
29 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 ...
0
votes
2answers
58 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 '...
0
votes
0answers
7 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. ...
2
votes
1answer
43 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
1answer
21 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
41 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
34 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 ...
1
vote
1answer
30 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?
2
votes
1answer
15 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 ...
0
votes
0answers
23 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 ...
1
vote
1answer
26 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?
2
votes
0answers
20 views

Magneto 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. ...
0
votes
1answer
38 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
1answer
54 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 ...
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 ...
1
vote
0answers
19 views

How can I import products from external programs CSV every day?

I have external "offline" program that runs database of products. I would like to create a script or something to automaticaly update product inventary. Another problem is that headers don't mach, so ...
0
votes
1answer
26 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
0answers
47 views

Getting Errors after MySQL database import

I took a MySQL dump of my live website and imported the data to a fresh database for my development site. However, only the homepage is working, other links bring an error There has been an error ...
0
votes
1answer
104 views

Number of columns does not correspond to the number of rows in the header in row(s) Magento 2

I am trying to upload products in Magento 2.2.6 from default import using CSV. I am getting this error while checking data on CSV. I have double check my CSV file has accurate columns and values in ...
0
votes
1answer
40 views

Apply product to parent and child categories on import

I am trying to import products into v2.2.7. Many products have many categories like: Default Category/A1/A2/A3, Default Category/B1/B2/B3 When i check the product configuration, the product only has ...
2
votes
0answers
39 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 /...
4
votes
0answers
40 views

Importing from Custom E-Commerce Platform to Magento 2 (MySQL to M2)

I need to import Products, Customers and Order History from a custom e-commerce platform into a new Magento 2 implementation. Ideally the extension or cloud service would allow us to connect directly ...
0
votes
0answers
45 views

While importing custom options for products throws exception in magneto 2

While importing custom options throws following error in Magento2.2.5 Undefined offset: 6405 in /var/www/html/xx/vendor/magento/module-catalog-import-export/Model/Import/Product/Option.php on ...
1
vote
1answer
26 views

While import product custom options throws error in magento 2

While trying to import custom options for product throws the below error. Please provide me a solution SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4953' for key '...
0
votes
3answers
73 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
30 views

Image not optimizing for product page

I import products from CSV file. I added base_image, small_image, thumnail_image, swatch_image and additional_image column. In backend it had been updated. But in front-end shows default magento icon. ...
2
votes
1answer
46 views

Product Page 404 - product re-save needed

After updating some products by importing csv file, there are some of them that display 404 error in frontend product view page. Saving these products manually solves the issue. Saving these ...
0
votes
1answer
35 views

Mass Activating Magento Categories

Thanks guys for the help in getting the cat ids in magento. Found this script to mass enable categories based on IDs <?php setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID); $file = fopen(...
0
votes
0answers
19 views

Did a Dataflow - Profiles export/import. All is fine except NO custom options transferred. Is it possible to use regular import for custom options?

Magento 1.9.1 --) 1.9.4 I am setting up a new store on a new server Magento 1.9.4. I did the Dataflow - Profiles export/import and all is fine except we just noticed (when we were going to go live ...
1
vote
0answers
14 views

Data Collection and Preparation: 15,000+ products for Magento 2

We're at the early stages of a reasonably large Magento project that will have a catalog of over 15,000 products. The big problem is that the customer doesn't have any information on the products ...
0
votes
0answers
7 views

If I did a Product export/import via Dataflow - Profiles; can I now import customers via normal import?

Magento 1.9.1 --) Magento 1.9.4 So I ran the All Products export out of Magento 1.9.1 and imported them into Magento 1.9.4 and it seemed to work fine. Now I need to import All Customers and I was ...
1
vote
0answers
19 views

Magento 2: Importing Customer information shows validation error 1. Please enter a password with a valid length. in row(s)1

I am importing customer information in magento 2 with password 4 characters, I have also changed the password length to 4 in Stores->Configuration->Customer Configuration. But still shows the same ...
0
votes
0answers
39 views

Error in import products exported from Magento 2.3

I'm exporting product lists from magento 2.3.0 and importing it to magento 2.2.6 , I'm getting many errors! 1. Attribute with code "32gb storage)-space grey" is not super in row(s): 1, 6, 9 ...
0
votes
0answers
16 views

csv sheet imported as question marks

I'm trying to import products as csv but it read it as question marks and gives error even I can read it in excel and its encoding is utf-8. I also tried utf-8BOM but in vain. csv file is in arabic ...
0
votes
1answer
71 views

Magento 2 Customer Grid index is locked by another reindex process. Skipping

I am importing Customer Main file details, I imported 30,000 records and about to reindexing ended up with reindexing issue. On the first reindexing I got the following error: PHP Fatal error: ...
0
votes
1answer
29 views

import categories from magento 1 to 2

I need to import categories on magento 2 that I exported from magento 1, Is it without issue, I mean is it risky for magento 2 store. Help me please if you have any proposition?
0
votes
0answers
17 views

How to organise images when importing cvs into my own structure

in the docs of magento2 Method 1: Import Images from the Local Server On the Magento server, upload the image files to the pub/media/import folder. This is the default folder for importing product ...
0
votes
1answer
41 views

cannot import images

I'm trying to import csv products but I get that error 1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 1, 2, 3, 4, 5, 6 ...
0
votes
0answers
43 views

Import custom customer attribute

I created a custom attribute $eavSetup->addAttribute( Customer::ENTITY, 'table_association', [ 'type' => 'int', 'label' =>...
1
vote
2answers
114 views

“Image does not exist” Error when doing a Dataflow - Profiles import

Magento 1.9.1. --) Magento 1.9.4 I am setting up a newer version of our store on a different hosting account. I need to export PRODUCTS. I have tried to do a regular EXPORT and IMPORT but that just ...
0
votes
1answer
24 views

Mag 2.2.3 After Add/Update importing do not change nothing

i have the products in my site Magento 2.2.3, after a importation add/Update, that products don't change value (Product name ecc....). i edit and modify any value of this product but what i change i ...
0
votes
0answers
34 views

“Category does not exists in rows” Error when doing a Product import from 1.9.1 to 1.9.4

Magento 1.9.1 --) Magento 1.9.4 I did a Product Export on Magento 1.9.1 and tried to import it into Magento 1.9.4. It first gave me this Error: Column names: "cube_category_Bestsellers" are ...