Questions tagged [import]

Denotes questions related to imports

0
votes
2answers
634 views

Export products from Magento 1.6 and import products in Magento 2.0.9

I need to import lots of configurable products to my new Magento 2. But if I export a CSV File and import in Magento 2 I get 1000s of errors. The File is different than a CSV I export from Magento 2....
1
vote
2answers
625 views

Update custom attribute when product data updated through import

We import product data using a feed we get from a wholesaler - one full import a week that merges product data and a daily import that only updates price and stock data. I have created a custom ...
0
votes
1answer
74 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 ...
0
votes
1answer
229 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 ...
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 ...
4
votes
2answers
799 views

TAblerates upload: something went wrong with importing tablerates

When importing the tablerates i get the message: something went wrong when importing the tablerates. I can't find the reason why, could you give me a hint? On the internet i could not find ...
2
votes
0answers
59 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 /...
1
vote
2answers
24 views

Magento csv import category error

When import gives error Category doesn't exist _category -> category name Error not showing in log file.
0
votes
2answers
838 views

Import Product Information from MSSQL to MySQL (or Magento)

I have Products Information stored in MSSQL database and i want this Product Information into Magento or MySQL database.
0
votes
1answer
32 views

Problems Importing Product CSV file

I have a big issue with reading my csv file. When I do an export and open it in Google doc or Excel the price and qty not show correct. Magento 2.2.6 https://docs.google.com/spreadsheets/d/...
0
votes
0answers
68 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
35 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
1answer
113 views

bulk product images uploading fails

I am trying to bulk upload images for products I am getting the following error: imported resource (image) could not be downloaded from external resource due to timeout or access permissions in ...
0
votes
1answer
791 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 ...
0
votes
1answer
318 views

Mass Import problem for images [closed]

I'm using magmi to import more than 30.000 products with images. The problem is with images that they are imported but all of them are excluded. Is there any sql query that I can use and get all ...
2
votes
1answer
875 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 ...
1
vote
1answer
31 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. ...
1
vote
2answers
865 views

Can't import into Magento 2.1

I've got two test products to import. One is exported from Magento and can be imported without issues. The other one appears to be almost identical but has been manually created. I can't figure out ...
2
votes
1answer
60 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
0answers
42 views

Magento 1.7. - Update status attribute via Dataflow Profile

We are trying to UPDATE the status attribute via Dataflow Profiles and CSV file. The CSV is processed correctly (no error messages in the popup showing the process), so the settings in the Dataflow ...
2
votes
1answer
703 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
0answers
21 views

Import “Stop on Error” does not work as expected

The "Stop on Error" feature in System > Data Transfer > Import does not work as expected. It only seems to work when checking for required columns. But when there are validation errors (like "please ...
1
vote
0answers
47 views

Php script for import configurable products from csv

I need to import a lot of products. So i want to use a script. So if you have any script to do that can you share the whole php file?
0
votes
1answer
38 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(...
1
vote
1answer
855 views

How do I import ONIX XML into Magento?

I need to get ONIX data to my Magento ebook store. I could convert it into a format that Magento understands (i.e. CSV) and then use the default import. But at times the a single feed can have a few ...
0
votes
0answers
26 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
385 views

Magento 2.2.5: Import Font-Awesome with _module.less

I'm trying to import the font-awesome.min.less in css/lib folder to _module.less, but doesn't seem to work, please help, import by _module.less only, do not use <css></css> in layouts ...
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
25 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
75 views

How to migrate categories from Magento 1.9.1 to 1.9.4? Also - Will EXPORT of products and customers work?

Magento 1.9.1 to Magento 1.9.4 We are setting up again and I can't figure out how to migrate categories from our old (live) Magento 1.9.1 site to the new 1.9.4? Is there a way to do that? I will ...
1
vote
2answers
140 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
31 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
61 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
19 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
121 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
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 ...
2
votes
2answers
928 views

Magento 2 csv product import : How to escape commas in category name

I would like to import a product csv into Magento 2 through the standard admin UI. The category name contains commas Default Category/Grocery/Snacks/Fruit, Nuts, Seeds. The (abbreviated) csv looks ...
0
votes
1answer
44 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
51 views

Import custom customer attribute

I created a custom attribute $eavSetup->addAttribute( Customer::ENTITY, 'table_association', [ 'type' => 'int', 'label' =>...
0
votes
1answer
57 views

Import Magento1 admin users to Magento2

I have done data migration using data migration tool from magento 1.9.x to 2.2.4, but it doesn't import admin users as mentioned in the docs, and we need to manually copy the admin users. What I have ...
4
votes
5answers
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 ...
0
votes
1answer
25 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
45 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 ...
2
votes
0answers
268 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 ...
0
votes
1answer
225 views

Importing from CSV to salesrule_coupon. Notice: Undefined index: sku

I've added on System > Data Transfer > Import another option in order to populate the table salesrule_coupon and i got on my csv the following: rule_id,code,usage_limit,usage_per_customer,times_used,...
2
votes
2answers
48 views

Get product, with 0 quantity, by attribute (sku)

I'm importing products and I want to get product by its sku. This is the code: $product = $this->productFactory->create(); $record = $product->loadByAttribute('sku', '1234'); It works but ...
0
votes
0answers
12 views

How to import CSV file programatically from another directory?

I am trying to import CSV file programmatically for orders. My files are located on another location of the same server... How to achieve this?
1
vote
0answers
50 views

Update description for product with csv for one store only magento 2

I want to update some fields of product only in one store (magento2), but all stores are updated Any ideas ?
1
vote
1answer
185 views

CRITICAL: Broken reference: No element found with ID 'content_schedule_block0'

I got this error on product details page. Added product using CSV import. 1 exception(s): Exception 0 (OutOfBoundsException): No element found with ID 'content_schedule_block0'. Exception ...