We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [csv]

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

Filter by
Sorted by
Tagged with
0
votes
2answers
29 views

How to export all product sku and cateogry id in csv format runing custom script?

I am using Magneto2.3.1 and i need to export all product sku and cateogry id in csv format runing custom script?if anyone know and idea share code please
0
votes
0answers
12 views

Magento 2 - Keep csv data description spaces while creating programatically

I am trying to create a new product using CSV custom script for which I refer Programmatically create a simple product in magento 2 Which is creating a product but it removes all spaces when we set an ...
1
vote
1answer
39 views

Magento 2 How to send file to another server on predefined location?

I am trying to upload a custom exported CSV to another server FTP on particular location. Step 1: Added FTP Class in constructor protected $ftp; public function __construct( \Magento\Framework\...
0
votes
1answer
16 views

M2 - Not creating nl_NL.csv in static files

I'm running Magento 2 in developer mode, but I need to translate the error message: Provided Zip/Postal Code seems to be invalid. Example: 1234 AB/1234AB. If you believe it is the right one you ...
0
votes
0answers
10 views

Magento 2 - base price + percentage to be displayedand used for calculating price

A Magento store needs to update prices based on CSV every day. The price given is "base price", instead of pre-processing said CSV to add profit, how can I add a certain percentage to price? Found ...
0
votes
0answers
27 views

In Magento 2 Product Update via Import CSV file

Need to update the product data via CSV file through import action. I am facing an issue to display the bundle product in front-end of the website after updating the product via import action. ...
0
votes
0answers
18 views

Image import errors (csv)

I'm trying to import 500 images (at a time, 13000 total) using a csv. I keep getting the following error: Imported resource (image) could not be downloaded from external resource due to timeout ...
1
vote
1answer
56 views

How to bulk import products with images into Magento 2 from CSV file

I'm sitting with Magento 2.3.3. I have a CSV file with some products but when I import the products no images are attached. My imported fine, but when I press Import I get the error message "...
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
16 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
13 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
67 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
25 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
29 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
18 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
48 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
37 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
84 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 ...
1
vote
0answers
19 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
43 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
43 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
77 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
57 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
34 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
23 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
56 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
27 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
34 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
66 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
47 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
28 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
133 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
27 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
26 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
41 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
43 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
230 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
143 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
84 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
72 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
45 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
42 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
80 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
33 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 ...