Questions tagged [importexport]

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

Filter by
Sorted by
Tagged with
4 votes
4 answers
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
1 answer
13 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, ...
0 votes
1 answer
1k 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 ...
2 votes
1 answer
393 views

How to use magento ImportExport module in your custom module

For my module I need to insert data that has nothing to do with magento products or categories. It is just a list of stores, addresses and coordinates, so I guess it could be a separate table inside ...
1 vote
0 answers
17 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 ...
2 votes
1 answer
99 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 , ...
2 votes
2 answers
1k views

Magento 2 how to import custom link type products

We have created custom link types like consumable, recommended, etc..like cross-sells, upsells, related. Now we would like to implement the import functionality for these custom types. We have written ...
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. ...
0 votes
2 answers
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
1 answer
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
2 answers
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 ...
2 votes
3 answers
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: ...
3 votes
2 answers
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 ...
4 votes
1 answer
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 ...
1 vote
1 answer
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?
1 vote
2 answers
2k 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
2 answers
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. ...
0 votes
2 answers
11 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 ...
1 vote
1 answer
1k views

Export Product IDs with Magento export functionality

I have an extension that works with product Ids instead of product SKUs for import for which i need to export product ids along with the SKUs to match the products. As far i have checked there is no ...
1 vote
1 answer
1k 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 ...
2 votes
1 answer
996 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
0 answers
37 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 ...
2 votes
1 answer
10k views

Product has image but it show placeholder image as default image

I got a strange problem I imported products by csv. There're some products showing placeholder magento image, even it has image. I try to re save, reindex, clear cache. not working it still showing. ...
0 votes
1 answer
359 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
117 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
2 answers
428 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 ...
0 votes
0 answers
51 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
121 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 \...
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
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 ...
2 votes
2 answers
2k 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 ...
1 vote
1 answer
110 views

How to get Customer Id while exporting customer details in magento backend

I wish to download Customer Id while exporting customer details in Magento back-end? Systems -> Export->Customer Main file Can anybody guide me , how to include customer id while export ...
5 votes
4 answers
19k 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.
1 vote
1 answer
938 views

MySQL Query for an export of all products?

Is there any way to find out a MySQL query that would give the same results as exporting all shop products? The reason I need this. When trying to export, I get the error Message is added to ...
0 votes
1 answer
35 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 ...
2 votes
4 answers
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
2 answers
318 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)) { ...
0 votes
1 answer
126 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. ...
8 votes
2 answers
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 ...
7 votes
4 answers
23k 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
0 answers
41 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
2 answers
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 ...
1 vote
2 answers
842 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
0 answers
74 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
1 answer
2k 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
2 answers
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
0 answers
28 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
0 answers
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
0 answers
24 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 ...
0 votes
0 answers
56 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
2 3 4 5
9