Questions tagged [importexport]

Questions about the Import/Export core feature of Magento (`Mage_ImportExport`)

Filter by
Sorted by
Tagged with
0 votes
0 answers
14 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
12 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
8 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
19 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
82 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, ...
  • 276
1 vote
0 answers
23 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 ...
  • 31
0 votes
2 answers
14 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 ...
0 votes
0 answers
49 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,712
0 votes
1 answer
158 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?
0 votes
0 answers
67 views

How to import "Customer group price" in product csv Magento 2

I want to add products by CSV file but in product CSV file there is no part to add product price group. How can I add product price group while adding products at the same time? https://i.imgur.com/...
0 votes
1 answer
199 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 \...
0 votes
0 answers
13 views

Configurable variations not showing on both frontend and backend but those data are available in database

I have imported the configurable product along with its variations and they have imported successfully. When I edit that configurable product on the admin, the respective configurable variations are ...
0 votes
1 answer
37 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 ...
0 votes
2 answers
418 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)) { ...
  • 11
0 votes
0 answers
44 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 ...
0 votes
0 answers
87 views

Product Export Not exported all product Magento 2.4.2

I am trying to export the product from Admin, After successfully exported all products not showing. I have 3000 data in the database but 2700 product export in excel sheet. Expected Result: All listed ...
0 votes
0 answers
30 views

magento 2 bulk update "backorders" inventory attributes from 1 to 0

Are there any solutions using CSV (i found default import export not include updating backorders), or API can do that? I know update attributes in product grid can do that but i want the solutions can ...
  • 2,100
0 votes
0 answers
25 views

Is it possible to export products from 2.4.2-p1 and import them back into 1.9.4?

Magento 2.4.2-p1 Amasty extensions Smartwave Porto theme We setup a Magento 2.4.2-p1 store but are having endless problems with Amasty's extensions. The issue is that we have added a lot of new ...
  • 276
1 vote
0 answers
151 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 ...
  • 139
0 votes
1 answer
160 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. ...
  • 107
0 votes
1 answer
151 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/...
2 votes
1 answer
115 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 , ...
0 votes
0 answers
27 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/...
0 votes
1 answer
67 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
182 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 ...
  • 397
0 votes
1 answer
37 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 '...
0 votes
0 answers
142 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 ...
  • 397
1 vote
0 answers
266 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
25 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
128 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 ...
0 votes
1 answer
147 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.
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
39 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 ...
  • 490
0 votes
0 answers
404 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
455 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 ...
1 vote
0 answers
72 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
191 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
129 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 ...
4 votes
0 answers
299 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
184 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 ...
  • 370
2 votes
4 answers
1k 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!
0 votes
1 answer
484 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 ...
0 votes
1 answer
404 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
46 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 ...
0 votes
1 answer
430 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.
1 vote
0 answers
103 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 ...
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 ...
0 votes
1 answer
36 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
68 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 ...
1 vote
1 answer
83 views

Magento 2, Can we import 10K product of csv at once

I have a client who wants to import the 10k product at once, He is saying that he has done it earlier, but I don't think it is possible, I have never seen that much of products to get imported at once....

1
2 3 4 5
9