Questions tagged [importexport]

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

4
votes
6answers
11k views

import/export error - magento 2.0.1

Firstly I export csv file from admin and keep only one row and delete the remaining row, after that I will change product name,category name and then import the file.I am getting the result in ...
2
votes
1answer
704 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 ...
0
votes
0answers
47 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.
0
votes
0answers
53 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
3answers
911 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
2answers
855 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
21 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
1answer
168 views

Magento2 Delta migration, missing products

After I've setup a Magento 2 development site. Our initial goal was to use Delta migration using the Magento 1.9.x to Magento 2 CE migration tool to transfer all the missing orders and customer data ...
1
vote
2answers
2k views

Export a csv with product name and thumbnail image?

I know it's possible to export csv's from Magento. Is there a way to get a small image to export in a column and not just the image path or url. Also, I know _media_image is a field, is that an ...
1
vote
3answers
977 views

How Exporting PhpMyAdmin data in Zipped or gzipped

I am a learner with Magento i have created dummy website on my localhost Xmapp server. Now i want to move it to live server but when i am exporting Mysql data base it is directly downloaded in sql and ...
1
vote
1answer
153 views

Deleted products are showing in while exporting products

I am exporting products using Dataflow profile. The exported inventory csv file contains the deleted products also.But in Manage product option,no deleted products appear. I have tried exporting after ...
1
vote
0answers
25 views

Updating Magento 2 product attribute, Import Add/Update feature always create a duplicate new item, instead of updating

i'm trying to update a custom product attribute called is_eol, but when i use the system->data transfer->import -> import behavior (add/update), it always created a duplicate item with same sku number....
0
votes
2answers
523 views

How to manually import/migrate orders & customers from Magento1 to Magento 2 database tables?

What is the best way to manually move the orders and customers to Magento 2.2.6 from Magento 1.8.1 without any third part extensions? there are around 100 records only. I was able to migrated all ...
1
vote
2answers
1k views

Transfer all products from one magento installation to other

How can I transfer all product from one magento installation to another (both are 1.9). I tried to export all products and then import them in other store, but it failed. No product is imported. ...
0
votes
0answers
16 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/...
0
votes
0answers
28 views

No valid data sent magento product export

Trying to export products from Magento using system import-export function and getting the error no valid data sent Initially, I was trying to export a few thousand products I then tried to export ...
0
votes
0answers
14 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
votes
0answers
17 views

Magento 2.3 - Products URL key regenerate on import functionality

I update the products with no url_key header present (only sku,description) using the import functionality The import should only update the fields which are mentioned in the CSV file. The import ...
0
votes
1answer
579 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
10 views

How to import dimensions? M2.1.5 -> M2.3.1

Hi I am currently doing a fresh install of magento 2.3.1 as our last dev really fucked up the 2.1.5 environment. I'm working on importing products at the moment but can't for the life of me seem to ...
1
vote
1answer
16 views

How to collect admin phrases?

I am using i18n:collect-phrases command but seems that it collects only frontend phrases. I need to collect only admin panel phrases! For example, I have downloaded some language pack, but it does ...
5
votes
4answers
7k views

custom attributes in separate coloumn while export? - Magento 2.0.8

short description what I done: create product attribute set (Chennai) create 21 new product attributes assign to Chennai attribute set set value to attribute while create product export (System->...
1
vote
0answers
46 views

Tier Pricing import/export

Very new to Magento and need some guidance. We are running a promotion and need to remove tiered pricing however we want to re activate it after the promotion. Is there a way I can export all ...
2
votes
1answer
908 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 ...
2
votes
0answers
135 views

Magento2 - fastest way to save product after several calls to addImageToMediaGallery() method

We had several issues when trying to build a catalog for a customer using native Import/Export functionality. Unfortunately it seems Magento2 has some difficult to download & process cloudfront....
12
votes
2answers
36k views

How to export all attributes and attribute sets from one magento installation and import to other installation?

I need to export all the product attributes and attribute sets from my current website (Enterprise Edition 1.12.0.0) and import all of them to a new website (CE 1.8). I've gone through these: ...
0
votes
1answer
643 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 ...
0
votes
0answers
22 views

Magento 2 after exporting products csv products id does not match back end product ids

After exporting products in csv file products ids does not match magento 2 backend ids please help this matter. Any help would be appreciated. Thanks in advance..!
2
votes
0answers
23 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) ...
4
votes
1answer
2k 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
1answer
2k 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 ...
3
votes
1answer
748 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 ...
1
vote
1answer
29 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-...
1
vote
1answer
24 views

Improved import export extension magento 2

I want to try this extension https://firebearstudio.com/blog/improved-import-export-2-0.html so i found this link on github : https://github.com/firebearstudio/importexportfree but when i installed it ...
1
vote
0answers
28 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
2answers
1k 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
2k views

Skip import row, is not valid value “” for field “type”

I know there are a few issues with this already, but I have tried some of the solutions.But they dont seem to work. Is there a default set of fields that the CSV must have. I have checked my CSV and ...
2
votes
3answers
545 views

after configurable product being imported, on editing it shows attributes to make configurable(like you are creating first time)

I have successfully imported a configurable product with all it's simple products. But on editing the configurable product from backend, it shows global attributes to make configurable product like ...
0
votes
1answer
51 views

Magento product export import not working?

So I exported all my products by using the magento exporter under System -> Import-Export -> Dataflow Profile -> Export all products and then on the other magento installation: System -&...
1
vote
0answers
32 views

Import only the customer from magento 1.9 to Magento 2.2

I am creating a new site with Magento 2.2 I need to import only the customer from an old site that is running on Magento 1.9. Any option can be import customer details using .csv file.Please help.
1
vote
0answers
76 views

Value for 'msrp_display_actual_price_type' attribute contains incorrect value

When i try to import my early exported export i get a error regarding msrp_display_actual_price_type but the DB tells me the input must be 4. "1. Value for msrp_display_actual_price_type attribute ...
0
votes
2answers
14 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 ...
7
votes
2answers
2k 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. ...
1
vote
1answer
82 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
2answers
111 views

Magento 2 - Configurable products not pairing with simple products?

When I import my .csv - with my simple and configurable products inside, the document is imported correctly with no validation errors. The issue I'm having is the configurable products aren't paired ...
1
vote
0answers
66 views

Product CSV file not exporting from admin in Magento 2

When we export Procuct Csv from admin side. Then csv not export. We get error There is no data for the export. Any one help me to solve this issue.
2
votes
1answer
142 views

password_hash convert into simple md5 format

How to export all customers in simple username , email, and simple md5 format csv.
0
votes
1answer
108 views

Error when export a csv list order

I cannot export order list from Magento backend. When I am trying to do it, I am getting below error. It would be appreciable if someone can help to resolve this problem.
1
vote
1answer
148 views

How to re-import products with existing images

I have accidentally deleted all product from Magento store (1100 items) but few minutes before that I did export all of them to the .csv file what let me to import them back but unfortunately there no ...
0
votes
2answers
36 views

Exporting a Backup of All Orders

We are currently making a major overhaul to an old website of ours, and it is still using Magento Version 1.4.1.1. I know it is very outdated. We have a lot of orders here that we want to make a ...