Questions tagged [importexport]
Questions about the Import/Export core feature of Magento (`Mage_ImportExport`)
437
questions
0
votes
0
answers
41
views
Exporting products in Magento 1.7.0.2
I am trying to export all products to CSV or XML file in Magento 1.7.0.2.
I tried from "System" > "Import / Export" > "Data Flow - Profiles" > "Export All ...
- 101
0
votes
1
answer
31
views
How to transfer orders from Magento 2.4.2-p1 to Magento ver. 2.4.5-p1?
Magento 2.4.2-p1
Smartwave Porto theme
13 Amasty extensions
I have a production Magento 2.4.2-p1 website with 2 stores. We are having lots of problems with this site which I truly believe might be a ...
- 256
1
vote
0
answers
27
views
Magento 2: Product images are not generated in media cache on importing products
Facing weird issue for 2-3 days. Images are not showing on frontend Whenever I import new products using firebear module or default importer.
I tried php bin/magento catalog:image:resize, ...
- 1,849
0
votes
0
answers
29
views
Magento create customer and force customer id
I have magento 2.4.3.
I need to do a customer migration and I should force the entity_id but I get this error
No such entity with customerId = 40
I tried this code:
$customer = $this->...
- 101
0
votes
0
answers
12
views
Magento System/Data Transfer/Export, where Magento defines the data of exported files?
I searched and found that the export was executed by a corn job, and I think the file that was executed in the process is "Magento\ImportExport\Model\Export\Consumer::process" but I add a ...
2
votes
2
answers
213
views
Magento 2 Slow import when 900 attribute options
We have a store with 35000 sku and there are 950 attribute options -
We find that when making any updates to products like price or qty or any other changes it is very very slow - like 5 mins if ...
- 43
0
votes
0
answers
51
views
Import custom csv to update just price and special_price error entity model
I’m trying to import a custom csv just with sku, store_id, price and special_price.
I saw some modules with exemples but not working because my import can´t be make and returned "Please enter a ...
1
vote
0
answers
24
views
Import: Value for 'country_of_manufacture' attribute contains incorrect value but I just exported it... sanity check for 2.4.4
I am confident I am not going crazy - but has anyone else experienced odd behaviour with the Magento 2 imports?
I am importing data sheets and it is flagging up country_of_manufacture as having ...
0
votes
0
answers
9
views
How can i unassign product images in bulk for store view
I accidentally assigned product images as store view during csv import
Like as base_image,small_image,thumbnail_image,swatch_image with store_view_code value.
How can i unassing all image data from ...
- 73
1
vote
1
answer
74
views
Is that possible to customize "files export path"?
System - Data Transfer - Export
The files export is in /magento/var/export/. Can we custom this path?
And if we can custom. How to?
- 36
1
vote
3
answers
143
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, ...
- 256
1
vote
0
answers
33
views
Duplicate records found in Advanced Pricing Export Report in Magento 2.3
I am using magento 2.3.0, while exporting Advance Pricing report, I am getting duplicates for some of the rows.. There are no duplicates in the table.All looks fine.
I am not able to figure out the ...
- 41
0
votes
2
answers
30
views
Importing products. 3rd party or native?
I'm wondering if the magento 2 import is worth using. Back in M1 this process was just horrible and I remember only a couple thousand products taking over a half hour and then timing out partway ...
- 55
0
votes
0
answers
157
views
Magento 2 product export with full product url
I export products from specific merchants from magento2 admin. System -> Data Transfer -> Export.
Every thing works fine, but here I need the the url key (chest-of-drawers-grey) as a full url ...
- 1,722
0
votes
1
answer
249
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
400
views
How to add custom attributes to Customer Export? (from the import/export admin page -> Customers Main File)
I need to add custom attributes to the Customers Main File export (from the Import / Export admin page), but I can't seem to find a way to do it.
I believe I can create a preference to override \...
- 63
0
votes
1
answer
46
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 ...
- 39
0
votes
2
answers
815
views
How to read and validate csv input and the rows
public function execute()
{
$data = [];
$file = $this->getRequest()->getFiles('refundcsv');
print_r($file);//display the input file name
if (!isset($file))
{
...
- 21
0
votes
0
answers
94
views
Export single or limit the no of products for export Magento2.4
In Magento, export functionality is there a way to export only a single product or limit the product export to 5 or 10. As I have more than 30,000 products as of now in my Magento.
But I only need ...
- 744
1
vote
0
answers
233
views
How to get columns header of csv in custom import module
Hi I created custom module for import data by helping module ( https://github.com/Smile-SA/magento2-module-custom-entity-import-export)
In this case I need to get csv header names.
I tried several ...
- 149
0
votes
1
answer
358
views
Import with custom behavior
I want to create an import entity that will have a custom behavior. All the examples I have seen about custom imports merely mention importing data into a table using the related Model, and that's it. ...
- 117
0
votes
1
answer
259
views
Unable to download the exported files
When I try to download the export file following errors throw up:
The webpage at https://example.com/example_admin/admin/export_file/download/key/...
- 101
2
votes
1
answer
196
views
Magento 2.4: Create Order Programatically with custom Order ID
Please Note - I am able to create order programatically , just i want new created order to have specific order ID instead of auto generated order id
Below is code to create order Programatically , ...
- 920
0
votes
0
answers
28
views
Getting issue while importing product data in Magento 2.4.1
We are looking for solution in Magento 2.4.1 which can resolve our issue in data import
In our case the category name are like
Available Brands Migrated/Kitchen, Storage & Furniture/Cookware/...
- 1
0
votes
1
answer
106
views
Display Products Attributes label is exported CSV file
I want to display product attributes label in exported csv file from backend file.Currently it display product attributes code in exported csv file.
Thanks
0
votes
1
answer
266
views
Magento 2 : Prevent stopping import execution in Magento 2
I am not able to find the code which is responsible for breaking import csv execution
from magento import tool in backend.
I do not want to terminate csv execution, even if error occur.
Any thoughts ...
- 467
0
votes
1
answer
63
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
0
votes
0
answers
184
views
Magento 2 : Add custom error message after csv import
i am trying to display custom text message after import csv is done in On the Admin sidebar, go to System > Data Transfer > Import.
The messages appears but on reload page.
Any thoughts how can ...
- 467
1
vote
0
answers
512
views
I want to add custom entity type export in system -> export
I want to create custom entity export which export data from inventory_source with custom product attribute like color, size
I have referred this and this link and created my export model file and its ...
1
vote
1
answer
31
views
Export attribute set and the attributes that are assigned to it
our attribute sets have become messy, things are assigned to them that shouldnt be and some things that should be havent. Is it possible for me to export to CSV the attribute set name and a list of ...
- 11
1
vote
1
answer
203
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
0
votes
1
answer
269
views
how to migrate order , customer data mysql from one environment to another
need table detail which we need export order , customer attribute from same version of magneto but different server
need table name .
any admin import /export method.
- 40
0
votes
0
answers
18
views
how to custom value which will be exported?
I have a grid and buttons for exporting like this.
There is field status in my grid. The value is 1 or 0. After exporting the grid, the value of this status is 1 or 0 in the CSV file. How can I make ...
1
vote
0
answers
42
views
Magento2.4: Getting error while importing the product custom option
We have created the product custom options by uploading the csv file but its showing the error and the uploaded custom option is not showing in the frontend.
Getting the below error:
Integrity ...
- 512
0
votes
0
answers
459
views
Import Product Programmatically
For product import,
I used to create a CSV file from the text file (from customer) via programming. Then I place it in var/import folder
Now, For Magento 1.9
My code was :
$profile = Mage::getModel('...
0
votes
2
answers
539
views
magento 2 enterprice stock source export not working
Hi i am using magento enterprice when i tried to export stock source it below message
showing Message is added to queue, wait to get your file soon
but after consumer run getting error
bin/magento ...
- 663
1
vote
0
answers
100
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
0
votes
0
answers
276
views
I want to import csv file into multiple tables in magento 2.4.please advice
I am new to magento. I want to import csv file into multiple tables. I created a import.xml, CustomImport.php, RowValidatorInterface.php. After that i created a module, and registraion.php. Even ...
0
votes
1
answer
201
views
Magento 2 Products Base Image Missing on Frontend after Import
We've been having an issue with importing images via CSV spreadsheet into Magento 2.
I'm able to import product images into the Magento admin via the columns Base Image, Small Image, Thumbnail and ...
- 11
4
votes
0
answers
342
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 ...
2
votes
0
answers
248
views
Add Product Name to Advanced Pricing Export
I'm attempting to add the "Product Name" attribute export the Advanced Price List in Magento 2.3.4 but I cannot seem to get it to work.
I am attempting to modify the AdvancedPricing.php ...
- 382
2
votes
4
answers
2k
views
MAGENTO 2.4 EXPORT CSV FILE STUCK IN QUEU AND NEVER APPEARS TO DOWNLOAD IT
HELP..!! I am on Magento 2.4
trying to export products but EXPORT FILE STUCK IN QUEUE....
it never appears.. what can i do?
Thanks in advance!
- 21
0
votes
1
answer
585
views
Import/Export cannot be used with directory
We recently upgraded our website to Magento 2.4, but we have run into an issue with trying to import products using the import tool. When we upload a csv that has errors in it, we want to download the ...
- 133
0
votes
1
answer
576
views
Magento2.3 - Can't Import product CSV file
I can't import CSV file. Got error https://prnt.sc/u0e9tr
Data validation failed. Please fix the following errors and upload the file again.
Number of columns does not correspond to the number of rows ...
0
votes
1
answer
73
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,267
0
votes
1
answer
574
views
how to add import & Export functionality to custom grid in magento 2
I don't have any idea to do import and export functionality in Magento 2 for my custom module grid. Kindly help and suggest me some solutions.
- 311
1
vote
0
answers
117
views
Import add and update products with their attributes in a CSV file and cron job Magento2
I am using Magento 2.3.3 and wants to import products using cron and csv. I have google Sheet which contains all products data and sheet's data changes continuously. So I have to run a cron every day ...
- 11
2
votes
3
answers
1k
views
Import new and update products and their attributes with a CSV file and cron job Magento2
I am using Magento 2.3.3 and wants to import products using cron and csv. I have google Sheet which contains all products data and sheet's data changes continuously. So I have to run a cron every day ...
- 129
0
votes
1
answer
44
views
how to share the admin configurations in magento 2.2.x
I am working with git, so i have added a module inside the project with code controllers,blocks,templates... and i have done also some change on this module's configuration on admin backend, so when i ...
0
votes
0
answers
91
views
how to export the configuration for a specific module
good morning everyone , i have a configuration was set in the Magento 2 backend for a specific module , i have search on the web on it , and i have find that there is a command to do it :
bin/magento ...