All Questions
Tagged with importexport import
115 questions
4
votes
1
answer
4k
views
Importing Configurable products With color and size
Importing Configurable product with color and size but only size are visible on site.
What i followed here:
I exported all sample data of site.
Copy one configurable product with its associated ...
CommunityBot
- 1
1
vote
1
answer
1k
views
Why are there duplicate products exported with a different store view?
Why are duplicate product entries are exported from a magento 2 install that's data was migrated from magento 1?
The duplicate entries of products don't have names and some other attributes but they ...
- 2,905
3
votes
3
answers
3k
views
Magento 2 : Customer import not working and gives "Import successfully done"
I have around 1000 customer to import when I try customer import using magento2 default customer import. Validation works perfectly and when I start import it gives me the message "Import successfully ...
- 5,740
2
votes
2
answers
3k
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-...
CommunityBot
- 1
0
votes
1
answer
65
views
Magento2: Product import is not working (Static attribute)
I'm trying to update some products using the import file. I Realized that one attribute is not updating. I noticed this attributes is backend_type = static. This is related to the problem or can be ...
0
votes
0
answers
165
views
Import not working in magento 2.4.6 and category product disappeared
When i am importing a csv file in magento 2.4.6. It is giving me this error again and again
Additional data: <div class="messages"><div class="message message-error error"&...
0
votes
1
answer
352
views
Import products 2.4.6-p1 error SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key
We did an upgrade from version 2.4.3 to the version 2.4.6-p1 and we started to have a problem on cloud environments (production and staging, but mostly on production) but not locally.
So, the steps to ...
1
vote
3
answers
359
views
How to transfer products from Magento 2.4.2-p1 to Magento 2.4.4 which give Errors during export and then import?
We have a live production Magento ver. 2.4.2-p1 with 2224 products but have a lot of problems which stem from me using the official Magento Migration Tool to migrate from Magento 1.x.
Because of this, ...
- 146
7
votes
1
answer
10k
views
What is the difference between Import/Export vs Dataflow
So, I'm using Magento 1.6.2.0 on a project and I'm seeing I have options for import, export, and dataflow profiles. In previous versions I've used the interface has been like the dataflow profiles. ...
- 1,115
2
votes
1
answer
1k
views
Magento 2: Importing Virtual products URL key
I'm trying to upload a configurable product with product variations. This did work fine for a while, but now I get this error:
1. Specified URL key already exists in rows: 3
If I analyze the ...
CommunityBot
- 1
0
votes
1
answer
365
views
Can I update order statuses via CSV?
Is it possible to update order status using CSV? If so, what would be the obligatory data and columns?
- 121
3
votes
2
answers
3k
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 ...
6
votes
4
answers
21k
views
import custom csv to custom table- magento 2
My requirement is import custom csv file to custom table.
please share hints and key points to achieve this?
Thanks.
- 9,328
0
votes
1
answer
72
views
No Import/Export Section under System->Data Transfer
In the Admin-Panel there should a "Import/Export" option under System->Data Transfer. This option is missing for me.
I have already checked Admin-Resources and the admin-user has access ...
8
votes
4
answers
29k
views
Read input csv file and convert it to array
I have an input file form in phtml to import data from csv file type like this:
<div class="import-shipping">
<div class="header">
<h4>CSV File:</h4>
</div>
&...
- 511
0
votes
0
answers
163
views
Stuck with image import using magento 1.9.2.1
I m importing Magento products with a native Magento import profile. All the products were imported successfully but the image is not imported. I have also put the images on media/import folder and in ...
- 1,364
1
vote
1
answer
6k
views
Magento 2 : Need to import product image from external url
I just need to import all product images from external url , can i able to do this using default functionality in magento 2.
If yes, how can i use this product images external url during import csv ...
CommunityBot
- 1
0
votes
1
answer
98
views
Please enter a valid region error for regions with special characters
I'm trying to import customer addresses. If the region has a name with accents, Magento v2.3.6 won't recognize it.
Example:
Country code 'RO', region 'Timiș' - doesn't work
Country code 'RO', region '...
- 51
2
votes
1
answer
919
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 ...
CommunityBot
- 1
1
vote
1
answer
346
views
Can't change Custom Attribute when Importing Products
I have a custom attribute for my products called Designer_name. I'm trying to import products and change a Designer_name's value in the additional_attributes column, but it doesn't work. The attribute ...
- 5,980
5
votes
3
answers
22k
views
I'm Looking for a sample CSV product file to import into test store
I have my first Magento test site running and I'm looking for a sample CSV product file to import for testing. Does anybody know where I can download one? Ideally I'd like the file to contain lots of ...
- 11.7k
1
vote
0
answers
118
views
Import related_skus in magento 2.3.5 problem
After upgrading Magento from 2.1.7 to 2.3.5, when making a manual products import through the admin, the related products are not attaching to the products, no errors are being shown.
I've tried ...
- 11
5
votes
0
answers
447
views
Magento2 import stock sources successful but no changes made and not showing in import history
Preconditions (*)
Magento ver. 2.3.4
About 10000 skus, this process has worked many times previously, suddenly stops working.
No new modules or configurations have been done since last time the ...
0
votes
2
answers
421
views
Magento2 : Import/Export is not visible in Admin section
I am having an issue in Magento Admin. The import/export menu is not visible. When I open the URL directly, It shows a blank page.
Please help, it's urgent.
- 7,753
0
votes
1
answer
118
views
Magento2 importer importing only 400 rows everytime
I need to import 19000 price list in Magento system. My client break it into bunch of 5000 each.
While importing we noticed a weird behaviour that everytime when importing every batch only 400 ...
- 1,327
1
vote
3
answers
2k
views
Magento 2.1.3 - Import products. Issue with categories
When I'm trying import eg 2 products:
I have no error with Check Data but on import:
Category "MAN/zakiet/zakiet" has not been created. URL key for specified store already exists. in row(s)...
- 1,467
0
votes
1
answer
648
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/...
- 111
4
votes
4
answers
11k
views
Magento 2 product import error
I get:
General system exception happened
Additional data: URL key for specified store already exists.
error when trying to import products with csv.
my csv file is passing check data process ...
- 56
1
vote
0
answers
1k
views
Import products via command line using Magento\ImportExport\Model\ImportFactory in Magento 2.3
I want to import products from .csv file using command line. Referring to this link: https://www.thirdandgrove.com/insights/importing-products-magento2-part2/ everything is working fine, except ...
CommunityBot
- 1
1
vote
0
answers
72
views
Magento 1 Import - If "Use Default Value" checked, skip to default view?
I'm starting to learn a bit about Magento import / export tool.
The problem I'm having is that our store consists from 2 stores:
- Default View
- Canada
- USA
The way that we set it up is ...
- 816
0
votes
1
answer
243
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 ...
- 7,628
0
votes
0
answers
97
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 ...
- 2,637
4
votes
6
answers
17k
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 ...
- 3,091
2
votes
0
answers
36
views
Create import entity for attributes
I'm trying to implement a new import entity to be made available through the ImportExport module (which is actually extended by Firegento_FastSimpleImport2, but that's not relevant for this question) ...
- 157
0
votes
1
answer
4k
views
programatically import csv - magento 2
I have a bpmn tool, it will generate CSV, that CSV contains single product. I need to import that csv file programatically. Already magento admin have that feature.
please can anyone point key code ...
CommunityBot
- 1
1
vote
0
answers
41
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, ...
0
votes
2
answers
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 ...
- 199k
2
votes
3
answers
725
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 ...
CommunityBot
- 1
2
votes
1
answer
4k
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,327
0
votes
1
answer
299
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 ...
- 9,572
0
votes
0
answers
127
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
1
vote
2
answers
707
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 ...
- 4,541
2
votes
1
answer
345
views
Please help. After I upload the products file,I got the error: Image file was not found
The image is in the folder /media/import/ ., please see the below 3 pictures.
- 3,827
1
vote
1
answer
144
views
Magento in maintenance mode after importing database from live to test
I created a dump of my live database and imported it into staging by using n98-magerun.
./n98-magerun.phar db:import live.sql
But now my website is in maintenance mode, even though there is no ...
- 1,220
4
votes
0
answers
466
views
Advanced Pricing Import Export issue
I am having an issue with the Advanced Pricing import.
I am importing a new pricing file and I selected Replace as the action, but it is not replacing the file. There are 9,219 line items in the file ...
1
vote
0
answers
152
views
Magento Bulk Import Functionality Best Approach
We are developing a multi vendor module . In this module vendor will upload an excel sheet to import simple and configurable products.
I have a few questions here to proceed. I need a better approach ...
- 441
1
vote
1
answer
3k
views
How to import customers in magento-2 using csv?
Currently i am working on magento-2 .I have imported products successfully. Now i want to be import customers . I dont have any demo csv for import customers .
- 31
2
votes
1
answer
447
views
Schedule Import Product not found in admin
Magento User guide https://docs.magento.com/m2/ee/user_guide/system/data-scheduled-import-export.html said that
Scheduled Import/Export is implemented by default, and does not require additional ...
- 66
3
votes
3
answers
4k
views
Magento 2: import large CSV file was not successful
Magento2 large CSV file was not successfully imported.
I am trying to import 20 Mb products CSV file but was not imported successfully. Still it says "please wait" only.
I have also changed ...
- 3,827
1
vote
1
answer
617
views
Importing products takes too long on a fresh install of Magento 2 v2.2.4
Backstory:
Suddenly, my MySQL database for Magento 2 has failed and been corrupted (This is a development installation and used to enter products data) and I don't have backup of the database except ...
- 566