Questions tagged [csv]

Denotes questions related to CSV file management on Magento (import,export,creation,modification)

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

Upload Product Images By CSV

I want to upload small, thumbnail and swatch image to many products by CSV. Images will be the same. When I import csv, the process is showing success and I can see those images are uploaded at the ...
0
votes
0answers
30 views

Magento 2.3 base image not appearing after product import

What might be the reason? Or where should I start looking for a fix in the Magento import process? What happens? When we import product (or only images to an existing product) to CSV through import ...
0
votes
2answers
40 views

Magento 2 GIF Animation is not working on frontend — no solutions for previous questions

I am trying to upload .gif image for few products , image is uploading from csv successfully and animation also working in admin panel. But issue here is when i am checking this product on frontend ...
0
votes
0answers
30 views

How to import configurable product in Magento 2 using custom CSV file

I want to import configurable product in Magento 2 using a custom CSV file. My CSV file like this How to import it with this file? Please help me! UPDATE I can import by this CSV but it not show in ...
0
votes
0answers
15 views

Line break into Magento CSV import description field

I need some help because I don't know how to fix this problem. On my import CSV, I have a description field but when I go to the front office after the import, the line break is not taken into ...
1
vote
1answer
37 views

Custom Export Report issue in Magento 2

I need to export the custom grid to the csv file. I have used the below code in my listing.xml file. <exportButton class="Magento\Ui\Component\ExportButton"> <argument name="data" ...
0
votes
1answer
22 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
27 views

Export Custom Gird CSV and Excel file not working

I have followed how to make CSV and Excel from here Export to csv showing undefined index UiComponentFactory.php but an exception is throw while clicking export Exception #0 (Magento\Framework\...
0
votes
0answers
35 views

Magento2.3.0 Getting error, when Import Group product via CSV

I am using magento2.3.0 when I import CSV through group product with associate product getting an error in back end side. If anyone has an idea please share your inputs. {"error": "Invalid file ...
0
votes
1answer
31 views

Magento 2 problem importing external images from csv

I have Magento 2.2.8 and need to import lots of products, the problem is with images (I would rather not import all image files, but a reference via link). They are in an external URL and CSV file ...
2
votes
1answer
20 views

Magento 2 Localization Adding Links in CSV

How to add text with link in csv file of a module. For example, "An error occurred" I want to add text with link like below for this message. "An error occurred.Please contact our customer service&...
1
vote
1answer
73 views

Magento 2: Import categories images external url via csv

I have import categories via CSV and I would like to import category image from external URL. I have used Magento ver. 2.3.1 I have tried to save images to the category but can't able to get success. ...
0
votes
0answers
23 views

Define Color&Text Swatches when uploading configurable products via csv?

We are trying to upload our configurable products using CSV since it seems to be the fastest way so far (much faster than using the API). We managed to create the configurable products by hand and ...
0
votes
0answers
22 views

Export Csv Content Magento 2

Is there any way to export the values of "Description" for Default Store View into a csv ? I run a export but it is showing only the Description content of the Default Scope . Im able to see the ...
0
votes
0answers
31 views

How to export Transaction ID and Credit Card Approval to CSV

I've been writing a script that exports a CSV into a directory. The CSV contains the information of the order, once the order has been made. The issue i'm having is exporting the information for ...
0
votes
0answers
30 views

Export All Products From Magento to XML File

I'm trying to export all our listed products from our magento site to an XML file - appears the only option via admin site is to do this via CSV - this comes out unreadable. Can you advise?
0
votes
0answers
108 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/...
0
votes
0answers
25 views

Take by Magmi a Magento attribute value

I would like to add to a price I have in CSV a percentage that I have on an attribute (when I update the product). For example, in my CSV I have: sku price xx 18,08 On Magento I have a ...
0
votes
1answer
73 views

Magento 1.9 : Create a CSV of product SKU, Quantity and Price

I'm trying to work out how to create a downloadable CSV file that contains fields for Product SKU, Quantity (should be set to 5 if more than 5 in stock) and Price in Magento 1.x. Price in this ...
0
votes
0answers
56 views

Magento 2.3.1 error when importing stock - Cannot get auto increment value

I have installed fresh magento 2.3.1 and tried to import stock, but every time I got error "Cannot get autoincrement value". The product is added to store, but Quantity is empty, and Salable Quantity ...
1
vote
1answer
40 views

Magento2 : How To Add New Words To Arabic Language Pack ar_SA.csv File

Hello I want to add new words to already available arabic language pack csv file. Can anyone tell me how i can add new words?
0
votes
0answers
26 views

Can't edit custom options via CSV import - Magento 2

I'm trying to update custom option values using the Import/export function. I have exported products as CSV and edited the values in custom_options column. When I try to import the spreadsheet back ...
1
vote
1answer
35 views

Profiler output data

Who can explain to me about data output in profiler report in csv format? I have the next data but don't know what is mean. cache_frontend_create,0.023024,0.011512,2,"2,560,880",0 magento,8.667415,8....
1
vote
0answers
33 views

Configurable variation is unidentifiable - Magento 2.3.1

I'm getting the Configurable variation is unidentifiable error when trying to import the configurable items to Magento 2.3.1. I think I have the correct format for the csv, using the defined format, ...
0
votes
1answer
23 views

Magento2 import sales tax rates via admin panel

I have a Excel file saves as a .csv and no matter what I do it keeps saying invalid file format. I exported the excel the tax rates that where on the site then edited the file in excel and saved as ...
0
votes
1answer
25 views

Import reviews from Amazon

[M1] We are selling some products on Amazon that we are selling on our website. We have plenty of reviews on multiple items, and we'd like to import those reviews on our Magento site. I have ...
1
vote
1answer
17 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
0answers
64 views

How to translate “ This is a required field. ” in magento 2

How to translate " This is a required field. " in magento 2. I was change in file csv but it not working, please help me!
0
votes
1answer
31 views

Magento 2:- How to add order export feature to seller dashboard?

I'm using Marketplace and there is separate dashboard for each seller from where seller can manage their sections e.g-products,stores,orders etc. for now,on order grid seller can't export the order ...
0
votes
0answers
10 views

Repeated rows value in csv

i have created custom php script to get order csv. i am getting order detail with item which is coming fine now but if i have 2 item in 1 order id its create 2 rows with repated detail in remaing ...
0
votes
0answers
120 views

Magento 2.3.1 import images with external link still not working

trying to pull image from external url during import but get: "1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 2" here is ...
0
votes
1answer
81 views

export csv file from magento 1.9 to import product csv in magento 2.3.0

I have a task to import products from m1 to m2. I having the csv file with products(from magento 1 export) at the moment. When i try to "Check Data" on import page - it always loading. How can i ...
1
vote
0answers
9 views

Import Order Csv With Items detail

I am creating order CSV file which is creating fine now I added item detail in order and show column in my CSV now I want if order has 2 items then 2 row creates in 1st row master column field like ...
1
vote
1answer
37 views

Magento2 - Failed to import products

We are trying to import products into Magento 2.2.5, but whenever we run the import, we get the following error: Imported resource (image) could not be downloaded from external resource due to ...
0
votes
0answers
42 views

How can I use native product csv import magento 2

I am trying to use magento 2 native csv import in my custom module. I am using following step to achieve requirement after some R&D but not working for me. I place csv file with sample data at ...
0
votes
1answer
36 views

Magento 2.1.17 product imported but product images not show

I want to import product in Magento 2.1.17 product imported but images show error - Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in ...
2
votes
0answers
117 views

Magento 2 - Import product quantity is empty after product csv import

In Magento 2.3.1, When I Go to admin panel System -> Import -> Products and Upload product CSV. Product imported with all information but miss qty, it shows empty. Any help, experience and ...
1
vote
2answers
94 views

Magento2: custom options import using CSV

I am working on CSV import to create a custom option for Products I am facing the issue with the error Notice: Undefined index: type in /var/www/html/home/vendor/magento/module-catalog-import-...
0
votes
1answer
38 views

How to establish connection between Magento 2 and some ERP Software?

I am working on ERP Magento 2 Connector. I have a query about it How is it practical to make connection with some ERP through csv formate data. I mean we can create REST/SOAP APIs but how can we tell ...
0
votes
0answers
13 views

Problem Translation Page Checkout

I've a seriously problem in my italian store view it is as if the word "Checkout" had disappeared, I tried to modify the translations in csv, even to delete it in the it_IT file, but nothing has ...
0
votes
0answers
10 views

Missing rows after a succesful import of a CSV file. Any ideas of why's this happening?

I've been having this issue ALL day long. Each time I try to import a CSV file in Magento, everything goes quite well, no errors, no changes needed, then I get the "Import Succesful" notification. ...
1
vote
0answers
25 views

import csv in mariadb

We import csv files in mariadb, 1 csv takes about 30 minutes. For daily sync of csv files thats about 3-4 hours and judge that as too much. Magento 2.3, Update on save is activated + Mysql tuner ...
0
votes
0answers
75 views

How to add new column in order csv export

I am trying to add a new field called quantity to the order csv export, but I am not able to do it. With all the other fields that get exported, I want another column called quantity which shows the ...
0
votes
0answers
27 views

How to import a CSV in Magento 2 of configurable product?

I have multiple products that are configurable and there is a problem that some child has same variations but with different SKU or Magento does not accept more than the allowed configuration so I ...
0
votes
1answer
132 views

Import a csv file in Bo magento 2

We have prepared a script that convert the csv of product that belong to our customer then we converted to the format that magento accepted (mapping of attributs with some condition on attributs to ...
2
votes
0answers
68 views

Magento 2.2.5 - Delete all products and products images

I have a site with Magento 2.2.5, with thousands of products imported via Magmi v0.7.23-git with csv. I tried to delete all these products with the Magmi utility 'Clear Catalog v1.0.4', and then ...
0
votes
1answer
106 views

Custom Product export in Magento 1

I want to Product export. But I need Only data which I need. For example, I need not "gift_message_available" attribute value. So Please tell me what I should I have created the profile. but When I ...
1
vote
1answer
249 views

Import Product Dimensions (Length, Width, Height) in Magento 2

I am trying to import dimension data to a Magento 2.2.6 store. The Magento attributes are present on the product, but I cannot figure out how to import to these fields. I have tried length and ...
1
vote
0answers
21 views

Magento CSV Stock import not making M2EPro update my listings

I am importing a CSV of stock levels into Magento2 (2.1.6) but that is not triggering any updates to happen to my M2E Pro ebay listings. It seems that the CSV import doesn't use Magento core, so it ...
0
votes
1answer
93 views

Magento 2: CSV Importing issue ,import successfully and did't show any products

While importing product CSV Magento didn’t give any error and import successfully. but didn’t show any products on customer view. If products already added it didn’t update the product content. I ...