Skip to main content

Questions tagged [csv]

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

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

Blank fields in csv product export

I’m trying to export around 6500 products through a csv file and importing it onto another e-commerce platform. However there are blank columns which is interfering with the import. Why are their ...
Wajdy's user avatar
  • 1
0 votes
3 answers
52 views

How to change order export file name Magento 2?

I need to change order report export file name "export.csv" to "custom.csv"
SURENDER SINGH's user avatar
0 votes
1 answer
51 views

Product import, additional images and additional image labels

When we try to import products from the Magento 2 back office with the csv example below, we define several images (base, thumbnail and small) and we also add additional images. If we define labels ...
Kallard's user avatar
  • 21
0 votes
2 answers
23 views

Magento2: Unable to transfer/move the CSV file from var/report to another server

I'm unable to move the generated csv file from my var/report folder to another sftp server. Please help me.
venkata prasad's user avatar
1 vote
1 answer
44 views

Import Product With Pipe Sign as configurable_variations

I have an Product Attribute with following values : https://prnt.sc/u8JrDsg_noG0 now when I am trying to import with that : https://prnt.sc/jyArfXbh5Ezs It gives me error : https://prnt.sc/...
Mark Philips's user avatar
0 votes
0 answers
38 views

Change the order of the images

Does anyone know if it is possible to change the order of the images already imported through a CSV template? Example this is the loaded order I want to alternate it by this order I appreciate the ...
Erick Vernaza's user avatar
0 votes
1 answer
28 views

Export products to a CSV file and post it to a URL/downloadable link

I work for a digital marketplace and we require our partners to provide us with a CSV file of all their products that is downloadable/posted to a URL and set to be updated daily in order to ensure up-...
Majorly2108's user avatar
0 votes
1 answer
178 views

magento 2 admin create and download csv file and loading problem

Please loading issue solve. I try to reload or redirect but that is not working. $resultRedirect = $this->resultFactory->create(ResultFactory::TYPE_REDIRECT); $resultRedirect->...
Rubel Parvaz's user avatar
0 votes
1 answer
58 views

How to remove a product from a specific website by uploading a CSV file

Currently, I want to delete products from a specific website in bulk, as it is a huge list of SKU's, So I want to do this via a CSV file. But I have not identified which field removes the check mark ...
Erick Vernaza's user avatar
0 votes
1 answer
31 views

Export of products in CSV files

Does anyone know why the CSV export file does not appear, when I make the export I get the notification that it is ready, however, the file is not found, this should appear with the date on which the ...
Erick Vernaza's user avatar
0 votes
1 answer
243 views

Import products 2.4.6-p1 error SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key

We did an upgrade from version 2.4.3 to the version 2.4.6-p1 and we started to have a problem on cloud environments (production and staging, but mostly on production) but not locally. So, the steps to ...
Pedro H Lima's user avatar
0 votes
1 answer
32 views

Setup particular product tax in all countries

I want to add a 5% additional tax to a particular simple product in all countries. I looked into Fixed Product Tax, but that only allows to choose from one country at a time. If I wanted to add the ...
Kristaps Briks-Dravnieks's user avatar
0 votes
0 answers
53 views

Export orders with addresses in xml

I have a problem with a Magento ver. 1.9.4.5 website with well over 55.000 customers in it's database and I need to export them. I have spent hours trying with System/export/profile and selecting ...
Urus221's user avatar
0 votes
0 answers
68 views

How to add utf-8 on the default export csv

I have used the default export csv of magento 2 in the listing.xml. I have a problem when I have a japanese character in the export.csv file the japanese characters are broken. How can I fix it? <...
jsnewbie21's user avatar
0 votes
0 answers
51 views

When exporting the product, the exported CSV file is too small and the content is incomplete

The version of my magento2 is 2.3.5-p1. My export steps are as follows: System ->Export Select 'Products' for Entity Type Select 'CSV' for Export File Format, there is only one option available ...
Alex's user avatar
  • 23
0 votes
0 answers
47 views

SQL Error when importing stock csv

Since we have updated to magento 2.4.6 when we want to import stock via csv we now receive an error. systemException Additional data: SQLSTATE[42000]: Syntax error or access violation: 1064 You have ...
Michael's user avatar
  • 303
0 votes
2 answers
779 views

Magento 2: How to create CSV with UTF-8 encoding?

In my Magento store, I am facing one issue that I am not able to import the product with special characters. For the CSV base I have followed the below tutorial. Can anyone please help me how can I ...
MagentoDev's user avatar
0 votes
1 answer
26 views

Magento Translation

Can Anybody Please tell me when we should use %1 or {0} in the Magento Translation? In my opinion, I think One is used for the guest and the other is used for the Login Customer.
Rana Zain's user avatar
  • 662
0 votes
0 answers
56 views

update product price mass action updated with same price csv

I’m trying to import a custom csv just with sku, store_id, price and special_price. It working good but the problem is when I did updates in a same product but with different stores. I followed some ...
Rannye Rodrigues's user avatar
1 vote
0 answers
122 views

Magento 2.3 Export All Invoice In Excel csv or xlsx

I need to export of all my invoices in xlsx or csv format (33K invoices ) What I want is to export the invoice information in the form of columns: customer name, amount, product... Is there a way to ...
Said Erraoudy's user avatar
0 votes
1 answer
11 views

modify input allow_error_count in magento import

I'm new to magento development and I find myself able to modify the allow_error_count input by backend when making an import. Some clue?
Jean Pier R. Monti's user avatar
0 votes
0 answers
119 views

How to upload pdf file with csv

How can we upload a pdf file to Magento from an external server with CSV file? For example, I have this on the CSV file pdf_upload=https://www.externalserver.com/datasheets/97/D38999-24JJ24HB.pdf when ...
alfons mala's user avatar
1 vote
0 answers
690 views

How to create a script to export each product with all images, names, SKUs, dimensions as a CSV programmatically in Magento 2?

**This is a working code** **You Create a file path as i.e. http://localhost/magento241/exportproduct.php** <?php use Magento\Framework\App\Bootstrap; use Magento\Framework\App\Filesystem\...
Vikram Dhande's user avatar
0 votes
1 answer
344 views

Can I update order statuses via CSV?

Is it possible to update order status using CSV? If so, what would be the obligatory data and columns?
hopicuzo's user avatar
0 votes
1 answer
65 views

General system exception happened - The custom_range value wasn't found in the algorithms

When importing a csv spreadsheet I am getting the following error:
Magenteiro's user avatar
0 votes
1 answer
209 views

Update Product Stock and Price by uploading CSV using Command Line

I am updating products stock and price by uploading CSV in adminform magento2. I want to perform the same thing using command line. Is it Possible ? How ?
Syed Hassan Zamir's user avatar
0 votes
1 answer
215 views

Uploading Product Brand CSV in magento2

We have 67 products where we have just uploaded but the "Product Brand" has not been selected. I have tried the following: A singular coloumn with title "product_brand": Rudy ...
Names_Life's user avatar
0 votes
0 answers
669 views

Send csv file on email in Magento 2.4.0

I am generating order report in csv and saving that file in Var folder. Now i want to send that file on email without using any email template. How to i can send that file on email ? Kindly check ...
Wajahat Bashir's user avatar
0 votes
2 answers
1k views

How to read and validate csv input and the rows

public function execute() { $data = []; $file = $this->getRequest()->getFiles('refundcsv'); print_r($file);//display the input file name if (!isset($file)) { ...
Mythili's user avatar
  • 21
2 votes
1 answer
611 views

Csv files are not get generating in var folder

I want to generate a csv file in var folder. I used these lines of code it's not working. Can someone help me to figure it out public function execute() { $filepath = 'export/customerlist.csv'; ...
Mythili's user avatar
  • 21
0 votes
1 answer
35 views

Programatically mass change product prices

I am writing a module that uses a cli command get a csv file and use that to change the prices of a selection of products based on sku and new price retrieved from an CSV file. I have the logic for ...
AndrewRMillar's user avatar
0 votes
1 answer
243 views

CSV-import error: "Content of uploaded file was changed, please re-upload the file"

Has anyone had this problem? If I try to import a .csv file, it instantly says "Content of uploaded file was changed, please re-upload the file"
Dandy's user avatar
  • 7
0 votes
1 answer
349 views

Can we update Product Position in Category with CSV in M2?

Can we update products position with csv in Category ? If yes than please share share any sample or example. Thanks
Wajahat Bashir's user avatar
0 votes
1 answer
208 views

Why my CSV import worked but didn't apply the changes?

I imported a CSV file with 5 products, the CSV is successfully validated and imported, however, when I went into one of the products that I imported, the update didn't have an effect. After one hour I ...
Rafael Corrêa Gomes's user avatar
1 vote
0 answers
225 views

Problem with importing products in magento 2.4.1

Value for 'size' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 1, 2, 3, 4, 5, 6, 7, 8, 9
GerranoMargeno's user avatar
1 vote
0 answers
312 views

How to get columns header of csv in custom import module

Hi I created custom module for import data by helping module ( https://github.com/Smile-SA/magento2-module-custom-entity-import-export) In this case I need to get csv header names. I tried several ...
Singhe's user avatar
  • 149
0 votes
1 answer
833 views

Magento 2 Create custom export entity type

I want to create custom export CSV entity type in magento 2
Mohit Patel's user avatar
  • 3,833
0 votes
1 answer
977 views

How to validation CSV import in magento 2

I have Create custom CSV import functionally. But How to check which row data is blank and i want to show error like :- Required field is empty in row(s). So Please help me how to check which row is ...
Mohit Patel's user avatar
  • 3,833
0 votes
1 answer
28 views

Can I pass a file into a function?

I have a function from a 3rd party plugin that uploads data using a CSV. The beginning of the function in the resource model that does the work looks like this public function uploadAndImport(\Magento\...
web master's user avatar
0 votes
1 answer
660 views

Image not imported from CSV in Magento 2.4

I want to import some product with images with CSV so i have add my image in var/www/html/mag/var/import/images folder with lamptest.jpg name and added filename with base_image , small_image , ...
Prits's user avatar
  • 625
0 votes
1 answer
947 views

Magento 2 admin grid csv export not working properly

I added csv export in admin grid and want to have export functionality whether admin user have filtered results or not. now I'm filtering data by daterange. some dates are working properly and gives ...
Mahdi Alikhani's user avatar
0 votes
0 answers
238 views

Magento 2 : Add custom error message after csv import

i am trying to display custom text message after import csv is done in On the Admin sidebar, go to System > Data Transfer > Import. The messages appears but on reload page. Any thoughts how can ...
devhs's user avatar
  • 497
1 vote
1 answer
62 views

Export attribute set and the attributes that are assigned to it

our attribute sets have become messy, things are assigned to them that shouldnt be and some things that should be havent. Is it possible for me to export to CSV the attribute set name and a list of ...
Lewis's user avatar
  • 11
0 votes
1 answer
406 views

How to export all URL rewrites in a CSV?

I would like to export all my URL rewrites in a CSV, via Magento 2 admin panel I can't do it. I followed this guide below but I didn't find anything native. https://docs.magento.com/user-guide/...
Rafael Corrêa Gomes's user avatar
0 votes
2 answers
580 views

magento 2 "invalidAttributeName" Error while custom csv upload

Here Am trying to upload a custom data with csv. Below are some code example import.xml <?xml version="1.0"?> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ...
Praveen Negimani's user avatar
0 votes
0 answers
30 views

CSV file upload [duplicate]

Can anybody help me with how to upload the CSV file from the frontend of magento2?
Muhammad Ali's user avatar
0 votes
0 answers
591 views

How to submit a CSV file in admin and how read it in Magento2?

How to submit a CSV file in admin side and how read it in Magento2?
Ankita's user avatar
  • 1
0 votes
1 answer
353 views

How to Create a field in the UiForm in which the csv file can be uploaded and read on the submit to store its fields in database in magento2?

How to Create a field in the UiForm in admin panel in which the csv file can be uploaded and read on the submit to store its fields in database in magento2?
Ankita's user avatar
  • 1
0 votes
0 answers
174 views

Cron job is running but not updating Inventory

I am using mass product import and export Extension from Wyomind https://www.wyomind.com/magento2/mass-product-update-import-magento.html I have scheduled tasks to run csv profile after every 30 ...
Anonymous Record's user avatar
0 votes
1 answer
813 views

Importing images with special characters in path

I am trying to import a lot of images. Images for each product are placed in subfolders by product IDs and locale. The problem is that each locale specific folder name starts with a caret (^). Example ...
Georgian's user avatar

1
2 3 4 5
13