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
1 answer
2k views

How to remove products from the particular store view in magento2

I have created three website views and three store views in magento2(English, French & German). I have uploaded the products through the default magento2 CSV import option and mapped them to all ...
1 vote
1 answer
2k views

Magento 1.9 - Catalog -> Manage Products not Exporting All Products To CSV

I am having an issue where exporting products under Catalog -> Manage Products in the admin panel is not exporting the entire product collection to a CSV. It is only exporting a small number of ...
2 votes
3 answers
5k views

Category has not been created. URL key for specified store already exists

I am trying to upload my stock through the Magento 2 admin panel via CSV. I am getting the following error: Category "Default Category/Aftermarket and Parts/Spare Parts/ Fasteners/Screws and Bolts/...
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)) { ...
1 vote
2 answers
239 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
3 answers
1k views

How do I open a csv file in the root of my module directory?

I've been writing a rather complicated module as of late. One of the steps I need to do is pre-populate one of the models with all of the data it needs to work right. This data is slowly replaced ...
1 vote
3 answers
1k views

CSV product Import stuck on Please wait..." hang

I have a problem with Magento 2 import section. I am trying to import a product from CSV, the page stop loading but the loading icon is always present and Magento don't check data. what is the ...
3 votes
2 answers
2k views

Error 500 internal server error validate key magento

I'm new to Magento which makes me a big newbie. I have recently set up a localhost store using XAMPP. Now I want to import 500 products with my CSV file. I've looked up the CSV file structure and I ...
0 votes
1 answer
1k 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. ...
2 votes
2 answers
2k 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-...
3 votes
2 answers
1k views

Is there any tool to Convert magento 1 Product import csv file to magento 2

I have Magento 1 Product Import CSV file, I need to convert Magento 2 Product Import CSV Format. Is there any tool out there?. If not there means, Suggest me How to Convert it. Because ...
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 ...
0 votes
2 answers
3k views

Magento 2 : Cannot set product stock status to "Out of stock" using csv

I tried to import a product using CSV with is_in_stock value to '0' and after the import, the stock status still shows "In stock" CSV looks like this : sku,is_in_stock DC3508BR,0 What am I ...
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 ...
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"
1 vote
2 answers
2k views

Editing default translations files

I have edited some translations in my multi language e-commerce site. In particular, I want to change some words in the English version site. In the homepage there is a menu which contains word BAG: ...
7 votes
2 answers
8k views

Magento 2 Import categories using csv

I have around 500+ categories in my csv. I'm trying to import only categories using csv. Can anyone knows how to import only categories in magento 2 using csv?
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.
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/...
2 votes
1 answer
1k views

CSV Validation In magento 2

I am working on Magento 2.2.5, need to validate CSV file for import. How to skip row? like I don't want to save any data of row 2, then how to skip that row. I am using only one attribute set, so I ...
2 votes
2 answers
1k 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 the import page - is always loading. ...
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 ...
4 votes
5 answers
6k views

Magento 2: how can I remove columns in exported csv from order grid?

I want remove columns while exporting order grid data in magento 2. I google it but didn't find solution. Like I want to remove these fields from exported csv. Payment Method Total Refunded Customer ...
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-...
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 ...
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->...
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 ...
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 ...
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 ...
5 votes
4 answers
11k views

Magento 2: Import multiple select attribute values using CSV

How can we import multiple select attribute values using CSV ? For example SKU "test" has two values for attribute "xyz" - "val1" and "val2". When I use both value as val1<space><comma>&...
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 ...
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 ...
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? <...
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 ...
3 votes
1 answer
427 views

Creating a csv file that contains product details magento 1

I am trying to create a csv, using script that contains the below product attributes in magento 1. id, title, description, link, image_link, price, availability Has anyone implemented it? Any thoughts ...
0 votes
3 answers
4k views

Magento 2 : How to Import Color and Size Swatch Attributes Using CSV

How to import color and size swatch attributes using csv.
0 votes
3 answers
6k views

Magento2: Need help to create custom export

I'm creating a custom module(multi-vendor) where i need to create one feature where admin can export the product details(CSV) data along with vendor details (which is assigned to some specific product)...
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" ...
2 votes
2 answers
5k views

Magento 2 Import - General system exception

I try to import customer data into Magento2 which got exported from a Magento2 store, but something wont work... Since its a 1:1 Magento export, the import should be perfectly fine or am I wrong ...
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 ...
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.
2 votes
3 answers
6k views

Magento 2 Programmatically update attribute fields from csv

I had a custom script for 1.9 that did this but it does not work on 2.0. Could someone provide any help or pointers to help get this working. Once a day I would like the script to update the magento ...
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 ...
2 votes
2 answers
1k views

Magento 2 how to import custom link type products

We have created custom link types like consumable, recommended, etc..like cross-sells, upsells, related. Now we would like to implement the import functionality for these custom types. We have written ...
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
1 vote
3 answers
5k views

CSV Import with multiple categories and commas in category names

I have a CSV of products to import and each product has multiple categories, some with commas in the category name. To import a product and asign multiple categories, I would usually add a CSV column ...
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 ...
2 votes
1 answer
1k views

Configurable Product CSV Import - Simples not associating

I've been trying to import some configurable products via the csv importer in magento ce 2.2.3. After running the import all products appear in the admin, however if I edit the configurable product, ...
1 vote
1 answer
1k views

How to upload Multiple Images Of same product using CSV FIle in magento 2.0?

I am Trying to upload Multiple image of same product in magento 2 using csv file. I am adding one image each on base_image, small_image, and thumbnail_image and other remaining images on ...
3 votes
2 answers
21k views

What is the best image fromat and size for products in magento

I am new on Magento and as per my requirements, I have to import the products data along with images using CSV files and my all of products images are placed in a remote location, let say http://www....

1
2 3 4 5
13