All Questions
Tagged with importexport import
115 questions
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, ...
- 280
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?
- 1
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 ...
- 79
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
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 ...
- 31
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
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
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 ...
- 726
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 ...
- 98
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
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/...
- 43
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) ...
- 21
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-...
- 941
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, ...
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 ...
- 990
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 ...
- 280
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 ...
- 280
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 ...
- 169
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.
- 1,215
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 ...
- 3,431
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 ...
- 552
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 ...
- 931
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 ...
- 333
2
votes
0
answers
204
views
Magento 2: Missing entity types in CSV import
I have a fresh instance of Magento 2.2. In the Import tab, there are only "Products" entity types. Should I enable anywhere rest? Like e.g "advanced pricing"?
Edit. SOLVED -> Module "...
- 737
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 ...
- 1,102
0
votes
1
answer
347
views
import parent and sub category with csv magento 1.9
I am uploading a CSV in Magento 1.9, and what i need is to import both categories and sub-categories, but now it is currently importing only sub-categories. Here is an example of how I the categories ...
- 1
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>
&...
- 2,494
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 ...
- 193
1
vote
1
answer
232
views
"Use default value" with category in AvS/FastSimpleImport : how?
I'm trying to import a category array with AvS/FastSimpleImport where:
Index 0: the default scope
Index 1: values for the it store
Index 2: values for the en store
The goal is to set Use default ...
0
votes
1
answer
120
views
Bulk Import Error
I have tried to csv import just 40 products.
But there was an error like keep buffering like the image.
Then I have uploaded the same content with 10 products per csv file and it was successfully ...
- 326
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 ...
- 1,083
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 ...
- 338
0
votes
1
answer
91
views
Magento2 - Multistore/domain export one website import in fresh install
I was wondering if it is possible to export a whole website (Including blocks, widgets, products, etc. which are enabled for that specific website)
Lets say you have a multistore/domain setup which ...
- 784
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 ...
0
votes
1
answer
56
views
Product Import > URLs missing ".htm" extension even after re-indexing.
I am uploading a large number products. The upload runs perfectly but Magento is not adding the file extension to the url_key. So none of the products uploaded have the “.htm” file extension. Even ...
- 51
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 ...
- 10.1k
1
vote
1
answer
686
views
Solved: Mass uncheck the "exclude" option by images
We have imported a lot of products with Magmi in Magento 1 and accidentally checked all the "exlcude" options for our images, so the main image is not shown on the product page.
Is there an easy way ...
- 531
0
votes
3
answers
4k
views
Magento2 import products attribute and attribute sets
I'm using Magento 2.1.3.
Is it possible to import product attributes and attribute sets or do I have to create them manually before importing products with specific attributes?
- 1,467
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
3k
views
Magento2 - Import Product with Images Using Absolute Path
As the product images are well organized in shared folders on the server, I prefer having the absolute image path in the CSV file directly. For example this allows for simple one click (almost) ...
- 890
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 ...
- 4,717
0
votes
1
answer
18
views
Making a new import module, I need info where to find some documentation and tutorial about Magento ImportExport module
I was researching about import/export in Magento and I decided to go and implement a module that will rely on Magento's native ImportExport module (app/code/code/Mage/ImportExport). Where can I find ...
0
votes
1
answer
2k
views
"Product with specified super products SKU not found in rows:..." when reimporting just exported products to empty database
I exported all my single and configurable products to .csv and emptied my database of all products afterwards. I am now trying to reimport those same products using the just created .csv file. ...
1
vote
0
answers
19
views
During importing a previous export of products Configurable products don't have simple products any more
I exported all products and then cleared all products. When I try to import the same products, I can do this, but configurable products don't have th associated simple products any more. What happens ...