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 tagged [importexport]

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

0
votes
0answers
14 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 ...
0
votes
0answers
13 views

magento 2 product export missing columns

I did an export after migrating products from PrestaShop to Magento 2 and not all the columns are exporting. Only the last 9 columns are being exported starting from "bundle_price_type". Not really ...
0
votes
0answers
19 views

Working with Product Exports in Excel

Trying to manage our company's products through bulk csv uploads. I very much prefer to work in Excel. Mainly because of sorting by color on items I've conditionally formatted. And some other smaller ...
0
votes
0answers
24 views

Duplicate SKUs in Export

Just started working at a company that uses Magento (I believe it's a version 2.2). I'm familiar with some other eCommerce platforms but have little experience in Magento. This company updates ...
0
votes
1answer
23 views

How to remigrate products and customer from M1=>M2

I have remigrated data with delta migration from magento1 to magento2 for order, customer changes in profile and reviews. But I am unable to remigrate new products, new categories and new customer ...
0
votes
0answers
16 views

bulk product images uploading fails

I am trying to bulk upload images for products I am getting the following error: imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s)...
0
votes
1answer
20 views

Unable to export categories

I am having trouble exporting categories into a csv file when I go to system>import/export>dataflow-profile>entity type. The only options I get is products and customers. Is there a way to enable the ...
0
votes
0answers
17 views

Magento 1.9 Image import using Dataflow and CSV file

I am trying to import image, small_image and thumbnail of a product using Magento built-in Dataflow and the CSV. CSV "sku","image","small_image","thumbnail" "10913-76084","/MILLERCAT 76084.jpg","/...
1
vote
1answer
40 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
56 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
65 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
24 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
36 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
22 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
36 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
21 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
40 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
13 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
87 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
15 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
32 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
28 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
20 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
121 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
156 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
29 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
491 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 ...
1
vote
0answers
65 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
480 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
40 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
67 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
50 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
113 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
93 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
12 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
25 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
61 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
65 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
178 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
227 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
40 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
17 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
145 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
61 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
224 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
2k 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 ...