Questions tagged [importexport]

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

Filter by
Sorted by
Tagged with
3
votes
1answer
1k views

Is there any tool to Convert magento 1 Product import csv file to magento 2

I have Magento 1 Product Import CSV file, I need to convert Magento 2 Product Import CSV Format. Is there any tool out there?. If not there means, Suggest me How to Convert it. Because ...
0
votes
0answers
13 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 ...
7
votes
2answers
4k views

Magento 2: Import/Export Product Attribute Set & it's Attributes

I refer Magento 2 - Export/Import Product Attributes but no one answered :( I have already created new Attribute Set & it's Attributes. I have checked Magento Default Import/Export for Products. ...
2
votes
4answers
4k views

Bulk item delete via csv

i am a newbie in magento so dont know much about coding and scrippts, my problem is i have list of SKU's which are end of line now and has been replaced with new products. i want to delete them so i ...
0
votes
2answers
54 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)) { ...
1
vote
1answer
943 views

CSV Validation In magento 2

I am working on Magento 2.2.5, need to validate CSV file for import. How to skip row? like I don't want to save any data of row 2, then how to skip that row. I am using only one attribute set, so I ...
0
votes
1answer
35 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. ...
1
vote
2answers
1k 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-...
7
votes
2answers
4k views

I want to add my custom entity for export Magento 2

I want to export my custom entity from the admin like products, customers, etc... I have already created the code for the import for my custom entity and it is working fine. But now I want to add the ...
5
votes
4answers
18k 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.
7
votes
4answers
20k 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> &...
0
votes
0answers
30 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 ...
1
vote
2answers
2k views

Problem export product - no valid data sent

I need to export all the products in Magento 1.9 with the module Mage_ImportExport, but in export setting when I select product as Entity Type, Magento doesn't load any Entity Attributes. So when I ...
2
votes
1answer
971 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 ...
0
votes
1answer
998 views

Magento 1.9: Product Export all categories in single line

Single product has multiple categories. Within CSV Export file only one category is listed. Does anyone know why only one category is exported? I need an export that has all categories listed by ...
1
vote
2answers
778 views

Can't Export Customers Error Please correct the data sent value

Magento 2.2.7 Trying to export customers and get the error, Please correct the data sent value. Exception log says, main.CRITICAL: Notice: Undefined offset: 14 in /home/public_html/vendor/...
0
votes
0answers
25 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 ...
2
votes
1answer
1k views

Magento 2: How to import export Categories in csv via backend using Entity Type catalog_category

I have to need import export categories in csv same as product, in Magento 2 provided same thing for product. I have tried below code but facing issue in Model file path Vendor/CategoryImportExport/...
2
votes
2answers
1k views

Migrate customer and order data from M2 to M1

We are migrating a Magento2 site to Magento1 What would be the best way to get customer and order data over from Magento2 to Magento1? Should we build an API bridge or are the database tables similar ...
0
votes
0answers
6 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 ...
0
votes
0answers
161 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 ...
0
votes
2answers
2k views

Product SKU requirements. What characters are restricted from a product SKU and can there be spaces in the middle of the SKU?

For product SKU's can there be spaces in the middle of the SKU? Are there any character restrictions that can not be used for a SKU ?
0
votes
1answer
2k views

Invalid value for Attribute Set column (set does not exists?) in rows: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,

I have a products exported file from Magento 1.14 EE and I want it to import in magento 1.9 CE. When I am trying to upload that I'm getting following error: Invalid value for Attribute Set column ...
0
votes
0answers
20 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 ...
2
votes
3answers
3k views

Foreignkey integrity error while configurable product import magento 2

When I was trying to import some configurable products, magento admin shows the following error General system exception happened Additional data: SQLSTATE[23000]: Integrity constraint violation: ...
0
votes
2answers
1k views

export all product fields with custom options

I need to import products in Magento 1.9 through .csv Simple products which I need to import all have custom options. Can you tell me where should I find the structure of the csv with the correct ...
1
vote
1answer
2k views

how to give download link to var/export/export_customers.csv?

Normally after successful running export customers data flow profiles its saving data to var/export folder, but I want to download that file to desktop. Can you give any suggestions?
0
votes
0answers
21 views

Magento 2 import special with scheduled update dates via CSV

Good afternoon everyone, Apologies if this has been asked before but I have a site that I would like to import special price via CSV import but with scheduled update dates. I am aware that the only ...
1
vote
1answer
4k 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 ...
4
votes
1answer
3k 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 ...
0
votes
0answers
7 views

Magento 2 system product export duplicate some records

I have duplicates in some records in products export in System > Export. Magento version is 2.3.5 and I saw this as a bug in Magento 2.1.x but it's not fixed yet. I have some records that are not ...
0
votes
0answers
10 views

Entity attributes filter not showing when exporting magento2

Entity attributes filter not showing when i am exporting System => Export => select Entity Type as product or anything
7
votes
4answers
17k views

Export file problem in Magento 2.3

Error: "Message is added to queue, wait to get your file soon" enter code here Open admin panel/system/Data Transfer/Export After that select all export setting and click the continue button. When ...
0
votes
0answers
31 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 ...
4
votes
4answers
2k views

How to add Select All option in Export Settings of Magento 2

I want to export one attribute of product. For this I have to select all other attributes one by one for excluding. Can anyone please tell me How can I add the Select All option to select all the ...
0
votes
0answers
22 views

Magento 2 custom Product Catalog Export

I want to create a new custom Export entity, that will be almost the same with the default Products export entity, except only a certain set of product attributes will be exported as columns, some of ...
0
votes
1answer
16 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
1answer
64 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
0answers
23 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
1answer
25 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
1answer
78 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 ...
2
votes
2answers
294 views

How to pass data from UI Form to PHP Class

I have created a form using UI component, This form has a select dropdown which displays option related to current entity id if form is in edit mode and all options if a new entity is being added by ...
0
votes
1answer
17 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 '...
1
vote
0answers
109 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
0answers
237 views

Magento 2 - Entity Type empty in import /export pages

I am new to Magento. I want to develop a site in Magento 2 and the old site is in opencart. I want to import its products to Magento 2 via CSV file so I add some products to Magento 2 store with ...
0
votes
0answers
56 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 ...
1
vote
1answer
19 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 ...
0
votes
2answers
168 views

Magento 2 Customer import fails

I had exported customer from local machine and i am importing on server. When i tried to import on server it gives me an error saying "Sorry, but the data is invalid or the file is not uploaded." I ...
8
votes
8answers
24k views

Is there a way to export all categories into a csv?

Is there a way to export all categories into a csv? Im moving data from a non-magento store into a fresh build.
2
votes
1answer
871 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 ...

1
2 3 4 5
9