Questions tagged [csv]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
84 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 ...
0
votes
1answer
40 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
19 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
74 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
51 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
196 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
258 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
43 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 ...
0
votes
0answers
66 views

How can I use native product csv import magento 2

I am trying to use magento 2 native csv import in my custom module. I am using following step to achieve requirement after some R&D but not working for me. I place csv file with sample data at ...
0
votes
1answer
42 views

Magento 2.1.17 product imported but product images not show

I want to import product in Magento 2.1.17 product imported but images show error - Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in ...
2
votes
0answers
135 views

Magento 2 - Import product quantity is empty after product csv import

In Magento 2.3.1, When I Go to admin panel System -> Import -> Products and Upload product CSV. Product imported with all information but miss qty, it shows empty. Any help, experience and ...
1
vote
2answers
149 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-...
0
votes
1answer
70 views

How to establish connection between Magento 2 and some ERP Software?

I am working on ERP Magento 2 Connector. I have a query about it How is it practical to make connection with some ERP through csv formate data. I mean we can create REST/SOAP APIs but how can we tell ...
0
votes
0answers
14 views

Problem Translation Page Checkout

I've a seriously problem in my italian store view it is as if the word "Checkout" had disappeared, I tried to modify the translations in csv, even to delete it in the it_IT file, but nothing has ...
0
votes
0answers
10 views

Missing rows after a succesful import of a CSV file. Any ideas of why's this happening?

I've been having this issue ALL day long. Each time I try to import a CSV file in Magento, everything goes quite well, no errors, no changes needed, then I get the "Import Succesful" notification. ...
1
vote
0answers
28 views

import csv in mariadb

We import csv files in mariadb, 1 csv takes about 30 minutes. For daily sync of csv files thats about 3-4 hours and judge that as too much. Magento 2.3, Update on save is activated + Mysql tuner ...
0
votes
0answers
101 views

How to add new column in order csv export

I am trying to add a new field called quantity to the order csv export, but I am not able to do it. With all the other fields that get exported, I want another column called quantity which shows the ...
0
votes
0answers
32 views

How to import a CSV in Magento 2 of configurable product?

I have multiple products that are configurable and there is a problem that some child has same variations but with different SKU or Magento does not accept more than the allowed configuration so I ...
0
votes
1answer
233 views

Import a csv file in Bo magento 2

We have prepared a script that convert the csv of product that belong to our customer then we converted to the format that magento accepted (mapping of attributs with some condition on attributs to ...
2
votes
0answers
72 views

Magento 2.2.5 - Delete all products and products images

I have a site with Magento 2.2.5, with thousands of products imported via Magmi v0.7.23-git with csv. I tried to delete all these products with the Magmi utility 'Clear Catalog v1.0.4', and then ...
0
votes
1answer
235 views

Custom Product export in Magento 1

I want to Product export. But I need Only data which I need. For example, I need not "gift_message_available" attribute value. So Please tell me what I should I have created the profile. but When I ...
1
vote
1answer
370 views

Import Product Dimensions (Length, Width, Height) in Magento 2

I am trying to import dimension data to a Magento 2.2.6 store. The Magento attributes are present on the product, but I cannot figure out how to import to these fields. I have tried length and ...
1
vote
0answers
22 views

Magento CSV Stock import not making M2EPro update my listings

I am importing a CSV of stock levels into Magento2 (2.1.6) but that is not triggering any updates to happen to my M2E Pro ebay listings. It seems that the CSV import doesn't use Magento core, so it ...
0
votes
1answer
169 views

Magento 2: CSV Importing issue ,import successfully and did't show any products

While importing product CSV Magento didn’t give any error and import successfully. but didn’t show any products on customer view. If products already added it didn’t update the product content. I ...
2
votes
1answer
256 views

Cannot export customer list in Magento 2

I was trying to export a customer list to a CSV file in Magento 2 (2.2.7). But every time I try it comes up with a 500 error regardless of how many customers are included in the export. Exporting ...
1
vote
1answer
52 views

While import product custom options throws error in magento 2

While trying to import custom options for product throws the below error. Please provide me a solution SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4953' for key '...
0
votes
0answers
127 views

How to read data in CSV file and store it to database in Magento 2

$data = [ [ 'data_id' => 1, 'name' => 'Name1', 'bonus_points' => 123.45 ], [ 'data_id' =>...
0
votes
1answer
32 views

Problems Importing Product CSV file

I have a big issue with reading my csv file. When I do an export and open it in Google doc or Excel the price and qty not show correct. Magento 2.2.6 https://docs.google.com/spreadsheets/d/...
0
votes
0answers
41 views

Importing csv issue in order to populate table on Magento 2.3

i got a problem while i was trying to populate a table on Magento 2.3 I dont know why is this appearing, i was trying to populate the table salesrule_coupon with the following data on the csv ...
0
votes
0answers
61 views

Magento 1.7. - Update status attribute via Dataflow Profile

We are trying to UPDATE the status attribute via Dataflow Profiles and CSV file. The CSV is processed correctly (no error messages in the popup showing the process), so the settings in the Dataflow ...
0
votes
2answers
435 views

Importing from CSV to salesrule_coupon. Notice: Undefined index: sku

I've added on System > Data Transfer > Import another option in order to populate the table salesrule_coupon and i got on my csv the following: rule_id,code,usage_limit,usage_per_customer,times_used,...
0
votes
0answers
242 views

Importing products in CSV - URL Key already in use

this seems to be a common problem and a flaw in vthe magento 2 CSV system, i want to export my catalogue update the pricing across all products and then re-upload it - however it requires a URL key ...
0
votes
0answers
20 views

magento csv bug export then import

does anyone know why doing a full product export and then reimporting it causes so many URL key errors - it looks like Magento is trying to rebuild certain products and of course finds duplicate ...
1
vote
1answer
553 views

Magento 2 Write to CSV within Controller

I have the following code: protected $_fileSystem; protected $_directoryList; public function __construct( \Magento\Framework\Filesystem $fileSystem, \Magento\Framework\App\Filesystem\...
0
votes
0answers
17 views

How to import CSV file programatically from another directory?

I am trying to import CSV file programmatically for orders. My files are located on another location of the same server... How to achieve this?
0
votes
1answer
75 views

import question - can you just import SKU, price, qty?

i want to do an upload on Magento which doesnt involve uploading every column - eg product_type, categories etc i have all that data in - i just want to update my pricing and quantity, is that ...
0
votes
1answer
45 views

Magento2:importing csv category include in menu enable

when i import product's csv. All products and category created successfully also all categories include in menu. I want when i import csv , all thing will be done , but not include in menu categories. ...
0
votes
1answer
147 views

How to import Configurable product from csv with custom attributes using php script

I am trying to import a configurable products in magento 2 with custom attributes using a php script. How far I got the php script to create simple product without custom attributes as a newbie i don'...
1
vote
1answer
330 views

magento 2 in select all products in update attributes not working?

i have try to select all products in admin panel side catalog but its not working? selet all products and update attributes. its come to some of issues ?
0
votes
1answer
22 views

Magento 2 in import products attributes sku errors?

We can't find required columns: sku. Column names: "sku product_name swt_package_quantity swt_diameter swt_package_weight swt_length swt_width swt_material swt_for_use_with ...
1
vote
2answers
481 views

php - create csv export file, based on product values

I currently have the following script, that change the producttitle of a product with a specific ID. Now I want to re-write the script, so that it does not update the attributes but generates a .csv ...
2
votes
0answers
91 views

Run native csv import product magento 2, no way to set csv file in custom module

I followed steps in this topic Magento 2 run native product csv import programtically, but it didn't work. When I try to import product through a CSV file in back-office, the check data is correct and ...
0
votes
2answers
426 views

Magento 2 in how to add the attributes extra more then values in bulk import ? what is th csv formats?

drop down box values not working in admin panel side using bulk import..! products attributes values not working in bulk import in csv files ?
1
vote
0answers
44 views

magento 2 in how to products value will be imported?

I have three csv files 1).products attributes. 2).products details files. 3).products attributes values files . first 2 files will be imported but attributes csv files not imported. Error: ...
0
votes
0answers
21 views

how many fields do i require as a minimum for a magento csv upload

hi all i dont want to submit a CSV with every column present in magento 2 - whats the minimum amount of columns required - i would have imagined that its just SKU as a primary key but it just keeps ...
0
votes
0answers
32 views

csv import new attributes

i want to add a new attribute into Magento 2. However i want to import a csv without everything else - categories all the mandatory categories as i just get url conflicts, does anyone know if this is ...
1
vote
1answer
224 views

Magento 2 in how to add all products website id in main website?

i will try to database table values in website id in main website but not working.? how to bulk change the all products website id change?