Questions tagged [importexport]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
16 views

Export Magento 2 Orders

How can I export Magento 2 orders and then import them on a new system? The new system has the same products in front-end and as far as customers are concerned. However, the way it works in the back ...
0
votes
1answer
974 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 ...
0
votes
1answer
618 views

Importing Products, Super attribute not allowing any other from that attribute be selected in admin panel?

I am having an issue with importing a defined configurable product not allowing anything from that attribute set to be selected from the admin panel. I am getting results like this Here is an example ...
0
votes
1answer
688 views

Import Bulk Attribute Options in Magento 1.9.2.3

i am using Magento 1.9.2.3 version. I have a brand attribute and i want to import all its option through csv file. Is there any way to import bulk attribute option? thanks
4
votes
3answers
747 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 ...
1
vote
2answers
293 views

Facing error when importing downlodable product in magento2

I want to import downloadble product when i was importing catalog_product.csv it's giving me below error: Imported resource (image) could not be downloaded from external resource due to timeout ...
0
votes
0answers
25 views

Magento 2: How to add the ID column under the CSV file while exporting Products

I have to add the entity id in the CSV while I export the products. How can I perform such a task in Magento 2
0
votes
0answers
19 views

Import custom related products through CSV

I have created a custom tab for Alternative Products and have to import SKU's through CSV like _links_related_sku in CSV. I am unable to import my products in custom alternative products tab in ...
2
votes
1answer
741 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
2answers
1k 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 ?
3
votes
2answers
1k views

Export file problem in magento 2.3.2

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
15 views

Can I create a custom import for products that doesn't replace the current products import in Magento 2?

If I create a custom import for the catalog_product entity, I want to have the option to use the current Magento 'Products' import as well as my new import option in the System > Import Entity ...
2
votes
2answers
3k views

Magento 2 - What are the native required attributes to customer and products?

When we export the sample of the basic CSV (Customers and Products) at the admin panel on Magento 2 all attributes are exported, whose are the basic attributes to put?
3
votes
3answers
11k 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.
0
votes
1answer
672 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 ...
1
vote
2answers
2k 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
1answer
638 views

images not imported through csv in magento 1.9

I tried to import products through import/export, everything gets imported but not image. What I did was: Flushed cache and re-index Media folder provided permissions to 777 Place all images in var/...
1
vote
1answer
27 views

Exporting products description (HTML) and short description (HTML)

I need to export these 2 products columns: description (HTML) and short description (HTML) to a CSV. So far I've been using the dataflow profile system with a personal columns mapping but I cannot ...
1
vote
1answer
38 views

Importing Customer Record via Customer ID

I'm working on a project at the moment and the client requires the import/export of customer records to/from their CRM. I've imported a fair few successfully however I've found something else that I ...
2
votes
1answer
916 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 ...
1
vote
1answer
275 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
1answer
113 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
1answer
1k 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
1answer
50 views

Magento 1.9 - Looking for Sample CSV customer import File

Anyone can help me with the sample CSV format to import the "customers" from backend?? When I tried to import the exported file from Admin > Customers > Export To > CSV. It is showing the ...
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 ...
3
votes
1answer
841 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
1answer
24 views

Magento 2.3: Is it possible import/create a category tree with category_id assigned

I have to import a 3rd party catalog into Magento 2.3. I need to recreate in Magento the category tree with the same category_id in the original tree because I need it when I update inventory. How can ...
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. ...
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
0answers
48 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 ...
0
votes
1answer
25 views

Error In Import: Attribute doesn't belong to attribute_set in row(s)

I'm trying to import configurable product in magento 2 by CSV. using firegento extension. For simple product, It is working fine. But for the configurable product it fails. eg: in CSV file Simple ...
1
vote
4answers
4k views

Magento Import product reviews from a csv

I am trying to import magento product reviews form a csv using the following script but it seem not to be working. When I run the script I get a blank page and nothing is imported into the database ...
0
votes
1answer
27 views

Set Order Of Imported Product Images Using CSV Magento 2.2

Does anyone know if there is a way to set the order of the images being imported in the additional_images column when running a CSV import? It's worth noting that 3 of the 5 product images already ...
0
votes
2answers
62 views

Magento 2: Display Image in exported excel file from custom grid

I am creating a custom admin grid (using Bock not UI Component) with custom collection. In that grid, I have a column of product image. Please see below screenshot: There are two way to export grid ...
0
votes
1answer
608 views

Products import success but products not imported

I am trying to import products using the system>import in Magento 2. The system say: CSV file has no errors. Import works fine. But still no products are created from the given data. Also ...
0
votes
1answer
634 views

How do I Export group pricing?

I know how to go about exporting all of my products into a CSV but I noticed that it only has MSRP, Price and Special price but does not have Group Prices that I have gone in and manually set. Where ...
1
vote
3answers
3k views

getting this error “Skipping import row, required field ”website“ is not defined” when importing customer list in dataflow import method

getting this error "Skipping import row, required field "website" is not defined" when importing customer list in dataflow import method
1
vote
0answers
222 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/...
0
votes
0answers
25 views

Magento2: How can I make custom import / export product functionality?

I want to make custom import / export functionality? 1) Schedule or Cron wise Import Export. 2) Upload product from Google Sheet. Any one can do help in this?
6
votes
3answers
9k 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> &...
4
votes
6answers
12k 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 ...
0
votes
0answers
70 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.
2
votes
3answers
1k 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
1answer
27 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
205 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
2k 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
156 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
35 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
878 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 ...