Questions tagged [importexport]

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

164 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
588 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
195 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. ...
1
vote
1answer
171 views

“Use default value” with category in AvS/FastSimpleImport : how?

I'm trying to import a category array with AvS/FastSimpleImport where: Index 0: the default scope Index 1: values for the it store Index 2: values for the en store The goal is to set Use default ...
1
vote
0answers
220 views

Magento 2 creating product attributes through CSV import

I need to create a module that can create custom product attributes as per the csv provided. I need it to import CSV via Magento 2 default csv import and validator. I know that we need two table ...
1
vote
0answers
92 views

How to skip some column to write csv data

I would like to skip some column to write data in CSV when it generate. Here is my code to generate CSV in magento. it would be start writing from column no 20 for first row only then continue with ...
1
vote
0answers
26 views

Shipment section in admin pannel is not shown

In admin panel under sales > order while trying to create shipment , no tabs under the Items to Ship is shown. After enabling and disabling every module one by one i found that one of custom module ...
1
vote
0answers
41 views

Simple products detached from configurabe products after import

I imported a simple spreadsheet into Magento 2.1.3 with stock updates and image updates. However, what this export seems to have also done is detach the simple products from the master configurable ...
1
vote
1answer
539 views

Why are there duplicate products exported with a different store view?

Why are duplicate product entries are exported from a magento 2 install that's data was migrated from magento 1? The duplicate entries of products don't have names and some other attributes but they ...
1
vote
0answers
331 views

Magento 2 product import by PHP (Configurable,Categories)

In Magento 1 I use http://avstudnitz.github.io/AvS_FastSimpleImport/ for product/category tree import.For Magento 2 I found https://github.com/firegento/FireGento_FastSimpleImport2 but seems like it ...
1
vote
0answers
115 views

Magento 1.9.2.4 not exporting simple products

I've run into a weird issue where my Magento site (1.9.2.4) isn't exporting all my products. It successfully exports all my configurables, but that's it - none of the simple products contained within/...
1
vote
0answers
278 views

How to create import button in system configuration and save import CSV data in magento2?

I need like Table Rates Shipping Import / Export CSV. I have used this reference:: $_FILES in Magento2 ECG : system configuration. but it's not working for me. Anyone have idea about it?
1
vote
1answer
296 views

magento2 bin/magento indexer:reindex this command delete the data from catalog_product_index_price

I am uploading products via xls and this is working fine.I am uploading bundle/simple products After that when all process complete. then I run bin/magento indexer:reindex by script for reindexing. ...
1
vote
0answers
204 views

export and import of products problems in magento 2

I exported products from Magento 2.0.5 and want to import to Magento 2.1.1 I got the following error: Data validation failed. Please fix the following errors and upload the file again. Following ...
1
vote
0answers
92 views

Write to CSV file in chunks at a time

I am trying to write product data to a CSV file in order to export to a third party. I need to break the operation down into chunks in order to prevent timeouts when writing large amounts of data. ...
1
vote
0answers
357 views

Magento community 2.1.2 schedule product csv upload from ftp

I want to import product csv file automatically from ftp. I am using magento community 2.1.2 edition. There is no schedule import/export option available in this edition. Please suggest me a good ...
1
vote
0answers
14 views

During importing a previous export of products Configurable products don't have simple products any more

I exported all products and then cleared all products. When I try to import the same products, I can do this, but configurable products don't have th associated simple products any more. What happens ...
1
vote
0answers
384 views

Magento 2 downloadable file in backend

I'm encountering a problem when using the native export module in admin. I'm using an admin account with a specific role that can only access to catalog and system / export If my first action is to ...
1
vote
0answers
74 views

Catalog + Categories + Attribute Set import / export tool

I am looking for a comprehensive import / export tool for Magento 2.0. I have a typical development environment where there is a dev instance, a staging and production environment. I am embarking on ...
1
vote
0answers
521 views

Magento 2.1.1 - product import error - looking for solution

csv file checks out perfectly, no errors, but I get: General system exception happened Additional data: Notice: Undefined index: in C:\Program Files (x86)\Ampps\www\jblattert\magento2\vendor\...
1
vote
0answers
168 views

Issue image mapping with magento1.9 bulk product upload in csv format

I had prepared the magento bulk product upload format in csv file and tested it. It's working fine, no issue in that. But, when i am uploading more than one product in the file 1st product image get ...
1
vote
0answers
587 views

Export group prices - CSV vs. Dataflow

We want to be able to export specific product data in MS XML Format using Dataflow. I realized it does not export group prices, whereas the CSV standard export does this. I couldn't see any option to ...
1
vote
1answer
504 views

How to export CMS Page data in Magento 2

I have added a custom attribute to CMS Page in magento 2. Can anyone please guide me How can I Export the value of that attribute of each CMS page through Custom Module? Thanks
1
vote
0answers
256 views

update qty per store view with csv file

actually in our website we have a cron function scheduled (every morning) to update the qty of all products of our catalog and works good. Following the code we are using now: <?php define('...
1
vote
0answers
223 views

Create a XML feed with advanced export

For our search provider we need a custom xml feed to export category content. So I was thinking of going the advanced profile route. Basically, what I want to create: <item><content_type>...
1
vote
1answer
585 views

Product Import: Recoverable Error: Argument 1 passed to Mage_Catalog_Model_Convert_Adapter_Product::saveRow() must be of the type array, boolean given

For some reason, the import function is throwing errors on roughly 10% of the products I am attempting to import. The strange thing is I can export the CSV direct from Magento using the typical export ...
1
vote
0answers
59 views

Populate dropdown values programmatically and check for existing ones

I'm using a piece of code to add dropdown values to a specific attribute. The code I'm using is: <?php require "app/Mage.php"; umask(0); Mage::app(); $installer = new ...
1
vote
0answers
40 views

Export and Import Location

Someone knows the location of the files important for Export and import? Like for an example: mywebsite/app/.... Because I want to repair it, because files are missing and I don't know where to put ...
1
vote
0answers
194 views

How to handle products URL's when exporting/importing products into Magento 2?

I have a small shop (less than 300 products) on Magento 1.7.2 and I want to move to Magento 2. Since I dont have many products, I think it would be easier to export the products (using CSV files) and ...
1
vote
0answers
871 views

assign products to categories theough excel sheet?

we are uploading products through .csv format System >import /export > Dataflow profile > import products we already have lot of categorries in backend how to assign those new products to the ...
1
vote
0answers
107 views

Problem with importing configurable products, associated products not shows up

I have the problem, that the "Associated Products" not shows up under the configurabel product. We are using Magento 1.9.1, I did the import over Import, then choose the file. Here is the file, ...
1
vote
0answers
2k views

how to give download link to var/export/export_customers.csv?

Normally after successful running export customers data flow profiles its saving data to var/export folder, but I want to download that file to desktop. Can you give any suggestions?
1
vote
1answer
159 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
1answer
273 views

Strange CSV file when export “orders”

When my customers exports a CSV file of the current orders, the export seems very strange. Here is a image that shows the layout of the CSV file: Any ideas what the problem could be? Thanks in ...
1
vote
1answer
21 views

ORDERS not showing as an Entity in Export function

Per this article, I should be able to export Order details... http://www.magentocommerce.com/knowledge-base/entry/how-to-export-orders However, when I go to the Export function ORDERS is not in the ...
0
votes
0answers
2 views

Problem downloading products from M1.9.3.6 Export/Entity/Product.php on line 947

I'm trying to download my products from Magento 1.9.3.6 and I keep getting an error: Fatal error: Unsupported operand types in public_html/app/code/core/Mage/ImportExport/Model/Export/Entity/Product....
0
votes
1answer
20 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
0answers
26 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 ...
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 ...
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 ...
0
votes
1answer
31 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
0answers
26 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?
0
votes
1answer
31 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
0answers
33 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
51 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
0answers
12 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 ...
0
votes
0answers
31 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
82 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..!
0
votes
2answers
34 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 ...