Questions tagged [importexport]

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

163 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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. ...
4
votes
0answers
148 views

Advanced Pricing Import Export issue

I am having an issue with the Advanced Pricing import. I am importing a new pricing file and I selected Replace as the action, but it is not replacing the file. There are 9,219 line items in the file ...
4
votes
0answers
201 views

Magento 2 : Email on customer Import

I have to import customers from Magento import customer feature and at the time of import there should be the email sent to customer and template should be registered_no_password so customer can set ...
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
847 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 ...
3
votes
0answers
2k views

How to export/import orders in Magento?

I am moving companies website from old installation 1.7.1 to fresh installation of Magento 1.9.3. I have moved now all the Product and Customer data easily - how do I export/import orders? I have ...
3
votes
0answers
264 views

Problem importing images from a CSV file - Magento ver. 1.9.2.2

Magento ver. 1.9.2.2 I've been working on this issue for several days and have read numerous articles. I have uncovered a few clues but can't tell where the hang up is. Here is a link to a test CSV ...
2
votes
0answers
37 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 ...
2
votes
0answers
234 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....
2
votes
0answers
25 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) ...
2
votes
0answers
164 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 ...
2
votes
0answers
21 views

Emergency - our site down for 2 days. Ready to deploy on a new server but missing custom options; any way to put same custom options on all products?

Magento 1.9.4 Our old Magento store (1.9.1) hosted at Hostforweb just stopped working (long story - first it was extremely slow = unusable; then the hosting company says they can move it to another ...
2
votes
0answers
26 views

regular Export on Magento 1.9.1 exporting custom options 12 times

Magento 1.9.1 We are exporting products from Magento 1.9.1 and importing them into Magento 1.9.4 When this regular export/import was done - I noticed that custom options showed up 12 times. I ...
2
votes
1answer
153 views

password_hash convert into simple md5 format

How to export all customers in simple username , email, and simple md5 format csv.
2
votes
0answers
43 views

Media image cron upload is failing to upload any images to my simple products

Front image should only load for configs and this works fine. Simples should load front and back and all other angles. It looks for F (front) and B (back), sets those to 1 or 2, everything else is ...
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: ...
2
votes
1answer
742 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 ...
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 ...
2
votes
3answers
600 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 ...
2
votes
0answers
137 views

Product Imports using ho-nl/Ho_Import not displaying in frontpage until I choose an additional category and save

Im working with Catalog_Product Import using extension ho-nl/Ho_Import. My current import procedure place the product with a checkbox in its category as you can see on the image. But the problem is ...
2
votes
0answers
2k views

How to Move Products, Attributes, Images, and Customers From One Magento Installation to Another

I have Magento 1.9.2.1 installed and I also installed a test Magento installation in a subdomain. Basically, the theme I have installed on my current Magento installation was designed for an older ...
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
42 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 ...
1
vote
0answers
235 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/...
1
vote
0answers
36 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....
1
vote
0answers
75 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 ...
1
vote
1answer
25 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
1answer
155 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
0answers
30 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, ...
1
vote
0answers
39 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
1answer
284 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/...
1
vote
0answers
111 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.
1
vote
1answer
26 views

Magento1 to Magento2 import only catalog configuration and its associated product query

I have 2 website first is magento1 and second is magento2. so i have import only configurable(with associated product) product from magento1 to magento2 . so what table to be taken magento1 and ...
1
vote
0answers
10 views

1st did Dataflow import which does not do custom options; Did a regular import after that few times - now have duplicate custom options

Magento 1.9.1 --) Magento 1.9.4 It's 2019 so you would think migrating All products from Magento 1.9.1 to Magento 1.9.4 would be smooth sailing right? I would expect to click Export on one system, ...
1
vote
0answers
73 views

Magento 1 - How to exclude column data from export csv file?

I want to exclude Email and Billing Telephone columns data from orders export csv file for specific user. I am using Rave Infosys Order Import / Export extension. These columns data should be empty ...
1
vote
1answer
315 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 ...
1
vote
0answers
126 views

Magento Bulk Import Functionality Best Approach

We are developing a multi vendor module . In this module vendor will upload an excel sheet to import simple and configurable products. I have a few questions here to proceed. I need a better approach ...
1
vote
2answers
300 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 ...
1
vote
0answers
116 views

Product URL Key gets deleted when importing custom options - Magento 2

I have been able to successfully import product custom options on my Magento 2 website. But after the import when I check I can see the URL key that was there in the backend is deleted. Every time I ...
1
vote
1answer
241 views

Importing products takes too long on a fresh install of Magento 2 v2.2.4

Backstory: Suddenly, my MySQL database for Magento 2 has failed and been corrupted (This is a development installation and used to enter products data) and I don't have backup of the database except ...
1
vote
0answers
117 views

Magento 2: Missing entity types in CSV import

I have a fresh instance of Magento 2.2. In the Import tab, there are only "Products" entity types. Should I enable anywhere rest? Like e.g "advanced pricing"? Edit. SOLVED -> Module "...
1
vote
1answer
62 views

Magento 2.2.2 - Import Product Images Categorically

To import all the product images, we are using below approach On the Magento server, upload the image files to the default folder for importing product images: pub/media/import In the CSV data, enter ...
1
vote
0answers
22 views

Magento 2.2.1 - Admin Product Export Problem

When i try to export product to CSV. My Admin panel get's wierd. Please take a look at the screenshot. The Admin Panel is getting shifted to the Admin Workarea and export never works. Any help here. ...
1
vote
0answers
171 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 ...
1
vote
1answer
177 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 ...
1
vote
0answers
265 views

create attribute option at product import time in magento 2

I want to create attribute option value at product import time. i used some link but i have no luck with this. Magento2 - programmatically add product attribute options https://dev98.de/2016/12/21/...
1
vote
0answers
347 views

Category does not exists in rows: 119, 120, 121, 122, 123, 124, 125… Problem in importing products in magento 1.9

I tried to import product from import/export. I got an error Category does not exists in rows: 119, 120, 121, 122, 123, 124, 125... What i did was : Checked uppercase, lowercase, whitespace from ...
1
vote
0answers
578 views

How add custom field (Product Sku) in Order export CSV magento2.2?

I need to export my orders to csv. I need two fields product sku and qty. sales > Order > export Any way to add Product SKU's as comma separated or any extension that can do it?
1
vote
0answers
187 views

M2 attribute handling, import , custom attributes

currently i use import/export for creating configurable products automatically. this is also quite a buch of work , because attributes aren't imported like in 1x. The optional attributes section in ...
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. ...