Questions tagged [importexport]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
53 views

Magento 2: How to get additional attribute in a separate column while Export products?

I want to get an additional attribute in a separate column while Export products. Please help.
0
votes
1answer
89 views

Magento2.3.2 exception(s): Exception #0 (Magento\Framework\Exception\LocalizedException):

Facing error while exporting customer main file Help to solve this issue...
0
votes
1answer
253 views

Magento2 how to access CSV file exists in var folder with website URL?

I am working with Magento 2.3.3 my instance is on the AWS server. On Magento2 how to access CSV file exists in var folder with website URL. i.e. I have one file resides on var/export/test.csv now I ...
1
vote
0answers
63 views

How to get Customer Id while exporting customer details in magento backend

I wish to download Customer Id while exporting customer details in Magento back-end? Systems -> Export->Customer Main file Can anybody guide me , how to include customer id while export ...
1
vote
1answer
812 views

Magento 2 how to import custom link type products

We have created custom link types like consumable, recommended, etc..like cross-sells, upsells, related. Now we would like to implement the import functionality for these custom types. We have written ...
3
votes
1answer
52 views

Trying to import data : Fatal error: Uncaught Error: Call to undefined method IMI\SVGProductImages\AllowSVGUploader::skipDbProcessing(

Is any one have idea about below error when i am trying to import data by custom importer. Fatal error: Uncaught Error: Call to undefined method IMI\SVGProductImages\AllowSVGUploader::...
1
vote
0answers
703 views

Import products via command line using Magento\ImportExport\Model\ImportFactory in Magento 2.3

I want to import products from .csv file using command line. Referring to this link: https://www.thirdandgrove.com/insights/importing-products-magento2-part2/ everything is working fine, except ...
1
vote
0answers
18 views

Magento 1 Import - If "Use Default Value" checked, skip to default view?

I'm starting to learn a bit about Magento import / export tool. The problem I'm having is that our store consists from 2 stores: - Default View - Canada - USA The way that we set it up is ...
1
vote
1answer
156 views

Magento 2.3 when Product export gets “Message is added to queue, wait to get your file soon" Not able to see export file in grid

When i tried to export the product from admin of Magento 2.3.2, i am not able to see the exported csv in below grid
2
votes
0answers
111 views

Magento 2: import special price for configurable products from M1

In Magento 1 the special prices were added to configurable products. In Magento 2 the special prices are set for simple products associated with the main configurable product. Is there an easy way ...
1
vote
1answer
157 views

How to create csv comma separated list from an array in PHP

I need to place every category in a separate category column. Like Category_1, Category_2, Category_3..... $categoryIds = implode('|', $product->getCategoryIds());//change the category ...
0
votes
1answer
62 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 ...
1
vote
1answer
292 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
212 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 ...
0
votes
1answer
472 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 ...
0
votes
1answer
51 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
4answers
17k views

Export file problem in Magento 2.3

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
1answer
39 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
2answers
1k 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
694 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
95 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
1answer
2k 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 ...
2
votes
1answer
1k 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
315 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
0answers
72 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
90 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 ...
3
votes
0answers
164 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 ...
1
vote
1answer
31 views

How to collect admin phrases?

I am using i18n:collect-phrases command but seems that it collects only frontend phrases. I need to collect only admin panel phrases! For example, I have downloaded some language pack, but it does ...
0
votes
1answer
122 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/...
1
vote
1answer
257 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 ...
2
votes
0answers
727 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
29 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) ...
1
vote
1answer
55 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
2answers
1k 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
38 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, ...
3
votes
1answer
1k 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 ...
0
votes
2answers
168 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 ...
1
vote
0answers
43 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
2answers
778 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
1answer
198 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.
0
votes
2answers
64 views

Exporting a Backup of All Orders

We are currently making a major overhaul to an old website of ours, and it is still using Magento Version 1.4.1.1. I know it is very outdated. We have a lot of orders here that we want to make a ...
2
votes
2answers
294 views

How to pass data from UI Form to PHP Class

I have created a form using UI component, This form has a select dropdown which displays option related to current entity id if form is in edit mode and all options if a new entity is being added by ...
2
votes
1answer
2k views

Magento 2 - Import custom product attributes through csv, can I import them using individual columns?

I was able to export the custom filterable product attributes into individual columns in CSV file using BSSCommerce export extension. Now I have a large amount of data need to update.I have searched ...
1
vote
1answer
32 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 ...
0
votes
2answers
124 views

Magento 2: URL key for specified store already exists

I have got the issue when import the category for specific SKU. General system exception happened Additional data: URL key for specified store already exists.
2
votes
0answers
27 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
112 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 ...
1
vote
0answers
20 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
2answers
7k views

Programmatically Update products attribute by sku for all store view

I am using below code to update product by sku but that is updating price for english store only , i will price of product to get updated in all store view . getObjectManager(); $state = $...
1
vote
2answers
602 views

"Image does not exist" Error when doing a Dataflow - Profiles import

Magento 1.9.1. --) Magento 1.9.4 I am setting up a newer version of our store on a different hosting account. I need to export PRODUCTS. I have tried to do a regular EXPORT and IMPORT but that just ...

1
2
3 4 5
9