Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

1
vote
1answer
19 views

Magento2 - issue when importing bundle products

This is a Magento 2.2.2 project... last season (it was 2.1.* then) we achieved to import this catalog using native import/export module (after several hours playing with .csv files) But this season, ...
0
votes
0answers
25 views

Magento2: How to Import and export CSV file from admin panel?

How to import and export custom CSV file from admin panel demo? I want to add the custom shipping price state and zip code wise in the database from the admin panel. Then I will apply extra the ...
1
vote
1answer
28 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
0answers
20 views

Import/Export is not visible in Admin

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
1answer
31 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
1answer
20 views

How to change base_url of other stores?

I exported a live database from a magento installation with 2 websites and 3 different stores and imported it on another magento installation. I already changed the base_url of the main store, but ...
1
vote
1answer
34 views

Magento in maintenance mode after importing database from live to test

I created a dump of my live database and imported it into staging by using n98-magerun. ./n98-magerun.phar db:import live.sql But now my website is in maintenance mode, even though there is no ...
0
votes
1answer
19 views

Magento2 : Product Import not working properly

I have imported two product into magento2 via CSV. After import it said "imported successfully", two products created but no product name, price, images etc updated with product. Even earlier import ...
0
votes
0answers
33 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 ...
0
votes
0answers
12 views

Out of memory while trying to get order last increment Id

While using magento 1.9. I'm trying to get order last increment id using the following code while exciting the code in command line: error_reporting ( E_ALL ); ini_set('display_errors', 1); ini_set('...
4
votes
0answers
55 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 ...
0
votes
0answers
10 views

Index product and categories URL rewrites stopped working after importing products

I just used the import feature to import configurable products for the first time and now I get an error on Catalog URL Rewrites. The first time I tried importing configurable products, it failed ...
1
vote
0answers
22 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 ...
0
votes
1answer
27 views

I want to Import Attribute sets, names and values in magento 1.9 easy way

I want to Import Attribute sets, names and values in magento 1.9 just like using magmi for "on the fly categories", if there is an easy way like that will be helpful as i'm having around 10,271 ...
0
votes
0answers
13 views

Custom source model attribute value in export csv multiselect

Source model class Custom_Cat_Model_Catalog_Product_Attribute_Source_Btype extends Mage_Eav_Model_Entity_Attribute_Source_Abstract { public function getAllOptions() { $...
0
votes
0answers
19 views

I have 10,271 attributes in a database I want to add them to magento 1

I have 10,271 attributes in a database I want to add them to magento 1 (inside an attribute group name "specification"), then import all the attribute values in each of the previous attribute fields. (...
1
vote
1answer
93 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
2answers
65 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 ...
0
votes
0answers
21 views

Magento 1.9 Error 524 During Products Import

I am working on Magento 1.9. When i try to import products CSV file on Magento. The following repose i got in Network TAB of inspector: Error 524 Ray ID: 4xxxxxxxxxxxxfa • 2018-07-02 06:59:...
6
votes
1answer
291 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 ...
0
votes
0answers
16 views

Export untranslated languages in csv Magento 1.9.2.3

I wanted to have an export of all untranslated languages in csv or excel. For categories, blocks, pages, product attributes etc etc.. except products. What i try to achieve is for example: if German ...
0
votes
0answers
49 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
303 views

Magento2 set all product infos to “use default value”

I have a problem with imported products in Magento 2 shop. Import worked well, but all products have own product name, product description, short description and so on for Store View AND Default Store ...
0
votes
0answers
35 views

Magento2 create script import/export product simple and configurable

How to create a script import product simple and configurable product if anyone used code please reply me so I can use in root directory after import and export product. I am waiting for the positive ...
0
votes
1answer
47 views

Schedule Import Product not found in admin

Magento User guide https://docs.magento.com/m2/ee/user_guide/system/data-scheduled-import-export.html said that Scheduled Import/Export is implemented by default, and does not require additional ...
0
votes
0answers
49 views

What is the best way to import/create products , customers and orders in magento 2.x

I have a third party Soap API, I have to create products, customers, orders and other related data in Magento 2.x. periodically like every 24 hours. There are around 15k products and orders. What i ...
1
vote
1answer
71 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 ...
0
votes
0answers
79 views

Invalid value for 'country' in rows: 1

I'm trying to import customer .csv file into Magento admin using the scheduled import/export functionality. This is the error email log I am getting Log trace: 1: Connecting to server 2: Reading ...
0
votes
0answers
10 views

Export Product Entity Type data into Google Sheet using Importxml function

How to export Product entity type data from Magento export into Google Sheet using importxml function?
0
votes
0answers
22 views

All products are not exporting in magento 2?

There are 3641 products in a catalog but when export this by Magento admin it's export only 2135 products. We didn't apply any filter for that. If anyone has an idea then please let me know what will ...
1
vote
0answers
45 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 "...
0
votes
0answers
28 views

Export data into XML files programatically

I need to export Customer data and Order data programatically. without using a module, but with just plain php script. I need to export above both into separate files and into a folder outside my ...
0
votes
0answers
58 views

Export Orders in Cxml Format for Magento 2.2.2

I need to export orders Record from the backend in the Cxml Standard format. Currently when I looked at the order Export Page, Orders can only be exported in the Xml or Csv format. Is there any module ...
0
votes
0answers
13 views

Magento product import is not taken in some cases

When I try to import configurable products as magento standards, it is not working in some cases. They are, sku=107910026-6290367,size=1/2,17/32 in.|sku=107909900-6290364,size=1-15/16 in.|sku=...
0
votes
0answers
149 views

How to override catelog-import-export module from vendor?

I want to create "Category" option after "Products" in System > Import to import categories using csv. I have tried following code but it didn't worked for me. Can anyone please help me to create ...
0
votes
1answer
198 views

import parent and sub category with csv magento 1.9

I am uploading a CSV in Magento 1.9, and what i need is to import both categories and sub-categories, but now it is currently importing only sub-categories. Here is an example of how I the categories ...
1
vote
1answer
36 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
15 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
1answer
112 views

Fatal error on product export

There are only 3 products in the catalog, when I try to export them using System -> Import/Export -> Export I get this error: Fatal error: Call to undefined method ...
0
votes
1answer
59 views

Store Manager - Re-index during product import despite setting to false

I am trying to use Store Manager to import changes for 1 attribute on 650 products. Even though the "Reindex product data" is un-checked, Store Manager is STILL trying to re-index after every product ...
1
vote
1answer
157 views

importing customers from magento 1 that have more than one address

I have around 7000 customers that i exported from magento 1 and now need to import to magento 2. The customers have more than one address, any idea how i can fix this ? Header contains invalid ...
0
votes
1answer
1k views

How can Export Categories with product on Magento 2 [closed]

How can Export Categories with product on Magento 2 Magento 2 admin panel only product export/import but categories sequence problem, product not import , so i want to export all categories with ...
0
votes
0answers
87 views

systemException. Unable to serialize value. in row(s): 1

Whenever I try to import bulk amount of product data, it always throws an error as following: I have 10 thousand records in the csv. I don't know what is causing the problem. Has anybody faced these ...
0
votes
0answers
23 views

Separate category_ids in Export All Products

When exporting all products to a CSV, the "category_ids" column merges all the IDs into a single large number. A product inside the categories 2, 24, and 56 displays as "22456" in the category_ids ...
1
vote
0answers
278 views

Magento 2 Send email to customer when import [closed]

Hello Magento Experts, I would like to send email to customers when I am doing customer import on Magento 2. Please help me to achieve this. I found this is bug in Magento 2 here: https://github....
0
votes
0answers
88 views

Magento 2.1.5: Import History all files always shows in-progess

When I try import products via Csv. After all validation spinner keep spinning and in Import history page it it status remain "In Progress" Have anyone face this? Any Solution regarding this?
1
vote
0answers
73 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
1answer
183 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 ...
5
votes
2answers
4k 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> &...
1
vote
1answer
472 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 ...