The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [csv]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
12 views

How can I create custom csv from products

I want to create custom export csv with products information in everyday. Heads: 1. identifier;manufacturer;name;category;product_url;price;net_price;image_url;description;delivery_cost 2. ABC123;...
0
votes
0answers
12 views

Supplier Attribute With Csv

This is my product attrubute choose supplier but choose supplier is not coming from option. Its coming from different database so I want to do this: i want set this option with csv as well.
1
vote
2answers
49 views

Data showing in Grid but not in export file Magento2

I have created a custom report, Used below code in my ui_component listing file. <column name="custom_tax_code" class="Vendor\Module\Ui\Component\Listing\Column\Quantity"> <argument name="...
0
votes
1answer
22 views

Magento 2: Cannot override translation csv

I need to change the default text of the review submitted into another one. Right now, I have the default text which is "You submitted your review for moderdation" and I want it to change it in "...
0
votes
1answer
27 views

Magento 2 : Import product image with sku

I have a CSV file product image with SKU, I did import all product SKU in admin but not have an image. here is the CSV file I need import.
0
votes
1answer
25 views

Magento 2 Price of configurable is zero on store front

We make an import of CSV with products programmatically and getting prices $0.00 on the storefront for the first time. After some minutes it's getting normal. I am using Magento 2.2.9 Community ...
0
votes
0answers
16 views

Magento 2 : Change column title when import product csv file via programmatically

I have a product CSV file when I import it in Magento admin, I want to change column title eg : in the original file: NAME, CATEGORY...etc and I want to change to: name, categories...etc, hope anyone ...
0
votes
0answers
24 views

Magento 2 : Import product error

I have a product csv file and when I import it in admin then is the result https://prnt.sc/pf3rhl Thank in advance. update: I did change all ” to " and this is the result:
1
vote
1answer
44 views

Magento 2 : Import product with custom csv

I have a custom product csv file https://drive.google.com/file/d/1f9t4REhn8-Ant58zRB6S0yRx1Rh1PctX/view?usp=sharing how can I import it in Magento 2. Do you have any idea?
0
votes
0answers
36 views

Magento 2 - Products are being duplicated on frontend replacing other items

We're experiencing issues on our frontend, as new products being added to Magento are being overwritten by other items that are already online. We add items into Magento through a CSV which is run ...
0
votes
0answers
17 views

Import product from csv error Missing Column: sku

I'm using Magento 2.3.2, I tried to update product stock with my CSV that looks like this: It's separated by comma, first column is for sku and second column for qty, but when i tried to import it ...
0
votes
0answers
18 views

What does the following fatal error mean please when I try to export products to a CSV file?

The below comes up when I use the admin panel system and currently on Magention version 1.9.1.0 Open Source Fatal error: Unsupported operand types in /home/fxxxxs/public_html/app/code/core/Mage/...
1
vote
1answer
59 views

How to Create a excel file in custom module?

I want to create an excel format file for download in Magento 2 <item name="buttons" xsi:type="array"> <item name="add" xsi:type="array"> <item name="name" xsi:type=...
0
votes
0answers
11 views

Edit custom options in specific store using CSV

When I use CSV upload to edit information in a specific store, everything else works fine except Custom Options. The Custom Options get changed in ALL stores, even though I only specified a ...
0
votes
0answers
16 views

Magento 2 Column names: “_super_attribute_price_corr” are invalid

I'm trying to do a Magneto 1 to magneto 2 import, using the built in Magento 2 importer. I keep receiving the error "Column names: "_super_attribute_price_corr" are invalid". Did the attribute name ...
0
votes
2answers
33 views

Magento 2: Other required columns in CSV to update Name, Quantity & Price

I want to update products on my Magento 2 Website with csv bulk import. I have downloaded the export file but it has too many columns. I will only update the Product name, Quantity & Price. ...
0
votes
1answer
42 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
62 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
51 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
33 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
22 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
50 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
25 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
32 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
59 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
35 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
25 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
109 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
24 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
24 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
38 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
41 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?
1
vote
0answers
180 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
29 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
108 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
79 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
64 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
36 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
39 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
1answer
64 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
30 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
38 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
71 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
47 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
155 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
188 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
10 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
41 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 ...