Questions tagged [importexport]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
19 views

Magento 2 Products Base Image Missing on Frontend after Import

We've been having an issue with importing images via CSV spreadsheet into Magento 2. I'm able to import product images into the Magento admin via the columns Base Image, Small Image, Thumbnail and ...
2
votes
0answers
17 views

Magento2 import stock sources successful but no changes made and not showing in import history

Preconditions (*) Magento ver. 2.3.4 About 10000 skus, this process has worked many times previously, suddenly stops working. No new modules or configurations have been done since last time the ...
2
votes
0answers
14 views

Add Product Name to Advanced Pricing Export

I'm attempting to add the "Product Name" attribute export the Advanced Price List in Magento 2.3.4 but I cannot seem to get it to work. I am attempting to modify the AdvancedPricing.php ...
0
votes
0answers
13 views

Import Configurable Product in Magento2

I am trying to import configurable product in magento2 but my attribute options include "|" separator in label, due to that Magento cannot identify the correct attribute value during import. ...
0
votes
3answers
43 views

MAGENTO 2.4 EXPORT CSV FILE STUCK IN QUEU AND NEVER APPEARS TO DOWNLOAD IT

HELP..!! I am on Magento 2.4 trying to export products but EXPORT FILE STUCK IN QUEUE.... it never appears.. what can i do? Thanks in advance!
0
votes
1answer
21 views

Import/Export cannot be used with directory

We recently upgraded our website to Magento 2.4, but we have run into an issue with trying to import products using the import tool. When we upload a csv that has errors in it, we want to download the ...
0
votes
1answer
30 views

Magento2.3 - Can't Import product CSV file

I can't import CSV file. Got error https://prnt.sc/u0e9tr Data validation failed. Please fix the following errors and upload the file again. Number of columns does not correspond to the number of rows ...
0
votes
1answer
21 views

Magento2 importer importing only 400 rows everytime

I need to import 19000 price list in Magento system. My client break it into bunch of 5000 each. While importing we noticed a weird behaviour that everytime when importing every batch only 400 ...
0
votes
1answer
39 views

how to add import & Export functionality to custom grid in magento 2

I don't have any idea to do import and export functionality in Magento 2 for my custom module grid. Kindly help and suggest me some solutions.
1
vote
0answers
15 views

Import add and update products with their attributes in a CSV file and cron job Magento2

I am using Magento 2.3.3 and wants to import products using cron and csv. I have google Sheet which contains all products data and sheet's data changes continuously. So I have to run a cron every day ...
2
votes
3answers
160 views

Import new and update products and their attributes with a CSV file and cron job Magento2

I am using Magento 2.3.3 and wants to import products using cron and csv. I have google Sheet which contains all products data and sheet's data changes continuously. So I have to run a cron every day ...
0
votes
0answers
16 views

export only customers and orders tables data from one magento 2 db to another

Hi I recently migrated all customers and orders from M1(EE) to M2(EE) but here what i want to do export only customers and order tables to import into another db. Can any one give me advice on this....
0
votes
0answers
23 views

Is there an importable csv for New York State Taxes?

We have a small store and are currently migrating to Magento CE 2.3.5. We are based in New York and need to charge sales tax only for New York orders because we don't meet nexus in any other state ...
0
votes
1answer
19 views

how to share the admin configurations in magento 2.2.x

I am working with git, so i have added a module inside the project with code controllers,blocks,templates... and i have done also some change on this module's configuration on admin backend, so when i ...
0
votes
0answers
25 views

how to export the configuration for a specific module

good morning everyone , i have a configuration was set in the Magento 2 backend for a specific module , i have search on the web on it , and i have find that there is a command to do it : bin/magento ...
1
vote
1answer
39 views

Magento 2, Can we import 10K product of csv at once

I have a client who wants to import the 10k product at once, He is saying that he has done it earlier, but I don't think it is possible, I have never seen that much of products to get imported at once....
0
votes
2answers
51 views

Magento 1.9: How to translate TITLES and TITLES OPTIONS of the “Custom Options” of simple products?

I need to translate all the TITLES and OPTION TITLES of the Custom Options related to simple Magento products. The need is: 1- Export all the fields of the "custom Option" 2- Translate them (or how to ...
0
votes
1answer
24 views

Increase varchar limit fot small_image attribute

I am using Magento 2.3.4.I have imported the product sheet in back end. It throws the error "Attribute small_image exceeded max length in row(s): 1".I have to import image from external url the ...
0
votes
0answers
50 views

Import/Export URL rewrites Magento 2

I want to import URL rewrites entry from one magento instance to another magento instance. Both are magento 2.3.3 version. Is there any way to do this? what is the table name in the database where ...
0
votes
2answers
24 views

delete export record from which table?

for some reason, I have to delete this record from the table, (it is stuck, cannot download or delete) anyone know this record belongs to which table? so I can delete it by sql query Thanks
0
votes
0answers
13 views

i am trying to import the custom price attributes

When i'm trying to import the custom price attributes my file is read to import , but after clicking import button it is keeping on rotating , can anyone help to know after clicking import button ...
0
votes
2answers
56 views

Bulk Export Magneto 2 product PSV

I'm using Magneto 2.3.3 on Ubuntu 18.04. I'm having 141 000 products that I want to export to a CSV file. Nothing happens when I try to export. It just says Message is added to queue, wait to ...
0
votes
1answer
68 views

Import data in magento 2

Hi i want to import product on magento 2.2.9 if can any one help me with a good tutorial Also all my pictures are on externe server. I use Builderall platforme wich has magento 2 already installed ...
0
votes
1answer
14 views

Magento 1 - Hide products from customers

We have a problem with the visibility. We need to add some new configurable products, but the customers should not be able to see them, until we finished testing them. How are we supposed to do this ...
0
votes
2answers
56 views

Magento2: Product import errors

I am getting errors while import products. I have downloaded sample files and trying to upload the same on the website. But getting errors. Invalid value for Attribute Set column (set doesn't exist?)...
1
vote
1answer
32 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
35 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
38 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 ...
0
votes
0answers
44 views

Custom eav attribute not exporting on product

New to Magento, I'm using the core magento 2 module-catalog-import-export in order to export my products into a CSV file. Based on this URL pattern : https://mysite/admin/admin/export/index/key/...
1
vote
0answers
43 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 ...
0
votes
0answers
29 views

Add Import Export functionality to my custom grid in Magento 1

I want to add Import and Export functionality for my custom grid records of my custom module. I had created a custom table in the database. I want to add Import and Export functionality using PHP code....
1
vote
1answer
330 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
37 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
237 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 ...
0
votes
0answers
55 views

Emptying Attributes Values in magento product import not working for multistore view

I have setup an multistore view in Magento 2 and uploaded products through the default Magento 2 import. I need to empty the attribute values in bulk. So I have tried to import the empty value in ...
0
votes
0answers
18 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....
1
vote
0answers
17 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
95 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
56 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
83 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
35 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
120 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
147 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
287 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
37 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 ...
6
votes
4answers
10k 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
28 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
566 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
323 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
54 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 ...

1
2 3 4 5
9