Questions tagged [csv]
Denotes questions related to CSV file management on Magento (import,export,creation,modification)
599
questions
0
votes
1
answer
11
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-...
0
votes
1
answer
23
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->...
- 17
0
votes
1
answer
26
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 ...
0
votes
1
answer
16
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 ...
0
votes
1
answer
77
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 ...
0
votes
1
answer
18
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 ...
0
votes
0
answers
25
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 ...
- 1
0
votes
0
answers
33
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?
<...
- 15
0
votes
1
answer
39
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 ...
- 23
0
votes
0
answers
27
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 ...
- 303
0
votes
0
answers
66
views
How can I create redirects from old URL keys to new ones using a CSV import in Magento 2.3.5-p1?
I have updated the 'url_key' column in my Magento CSV file and imported it successfully. However, the old URLs are still returning a 404 error, even though the new URL keys have been updated correctly....
0
votes
0
answers
30
views
How i export customer order data in csv file using controller
How i write the code for this button for exporting order data csv particular order
I fetch the following details
Reference Number
Ship Carrier
Ship Service
Ship Billing
Ship To Company
Ship To ...
- 77
0
votes
2
answers
472
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 ...
- 494
0
votes
0
answers
28
views
How to compare one column value with all column value in csv file using php
I want to compare one column value with all csv column values like below way.
https://i.stack.imgur.com/XJTdO.png
In the above Image compare the A2 cell value with all values then after comparing the ...
- 63
0
votes
1
answer
25
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.
- 616
0
votes
0
answers
37
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 ...
1
vote
0
answers
84
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 ...
- 141
0
votes
1
answer
9
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?
0
votes
0
answers
103
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 ...
1
vote
0
answers
602
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\...
0
votes
1
answer
301
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?
- 1
0
votes
1
answer
62
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:
0
votes
1
answer
197
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 ?
0
votes
1
answer
194
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 ...
0
votes
0
answers
495
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 ...
- 382
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))
{
...
- 21
2
votes
1
answer
500
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';
...
- 21
0
votes
1
answer
31
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 ...
- 136
0
votes
1
answer
206
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"
- 7
0
votes
1
answer
230
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
- 382
0
votes
1
answer
135
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 ...
- 12.9k
1
vote
0
answers
195
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
1
vote
0
answers
284
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 ...
- 149
0
votes
1
answer
694
views
Magento 2 Create custom export entity type
I want to create custom export CSV entity type in magento 2
- 3,671
0
votes
1
answer
805
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 ...
- 3,671
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\...
- 313
0
votes
1
answer
527
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 , ...
- 626
0
votes
1
answer
861
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 ...
0
votes
0
answers
219
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 ...
- 477
1
vote
1
answer
46
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 ...
- 11
0
votes
1
answer
316
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/...
- 12.9k
0
votes
2
answers
499
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" ...
- 448
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?
- 66
0
votes
0
answers
496
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?
- 1
0
votes
1
answer
338
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?
- 1
0
votes
0
answers
165
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 ...
- 139
0
votes
1
answer
674
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 ...
- 51
0
votes
1
answer
105
views
Data/profile export categories name instead of Ids (Magento 1.9)
I have done this script to runs data/profile using ssh terminal to export csv data of all products inside of magento 1.9.
I need to have the category name (structure tree) instead of category Ids but ...
0
votes
1
answer
485
views
Magento 2.4 sales_order_invoice_grid populate custom column with values
I have added the column transaction_id to my sales_order_invoice_grid.
Vendor\Module\etc\adminhtml\di.xml
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:...
- 149
0
votes
0
answers
313
views
I want to import csv file into multiple tables in magento 2.4.please advice
I am new to magento. I want to import csv file into multiple tables. I created a import.xml, CustomImport.php, RowValidatorInterface.php. After that i created a module, and registraion.php. Even ...
