Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [csv]

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

0
votes
1answer
17 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
27 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
12 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
7 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
24 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
28 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
23 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
37 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
48 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
30 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
54 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
18 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
26 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
47 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
26 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
30 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
30 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
18 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
32 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
1answer
120 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
69 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
14 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 ...
0
votes
1answer
67 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
10 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
37 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
29 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
55 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
90 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
21 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
277 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
54 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
167 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
41 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
15 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
29 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
80 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?
0
votes
0answers
37 views

csv - a way to just import attribute values

does anyone know if its possible to upload a CSV that just includes the existing sku and a column for a new attribute, i want to do this instead of adding this to my full csv which is absolutely ...
1
vote
0answers
138 views

Custom csv Import not working in magento 2.3

While doing importing from backend for custom table its trowing following error systemException Additional data: Error in data structure: entity values are mixed but its correct validated in ...
0
votes
1answer
413 views

How to upload and read csv file import into database in magento 2?

How to upload the csv file and read import into the database magento 2? <?php /** * XXXX_ProductImport extension * @category * @package XXXX_ProductImport * @copyright Copyright (c) 2018 * @...
3
votes
1answer
447 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?
1
vote
0answers
34 views

Magento 1 : How to Solve 404 Error while exporting csv file on custom module

I have facing issue (404 error /page not found error) while exporting csv file in custom module from system configuration. if anyone known then please tell me how to solve this 404 error.
0
votes
0answers
172 views

How to update product stock via CSV (Magento 2.x)

I am trying to update product stock quantity via CSV when I purchase new inventory. So far I've been using the out-of-the-box Magento product import. It works but I wonder if there is a better way. ...
0
votes
1answer
313 views

Looking for a sample CSV file to upload product list on V 1.9

Looking for a sample CSV file to upload product list on Magento 1.9 please help
0
votes
1answer
32 views

Image Thumbnail in product not selected after product import

I have problem with product thumbnail. When imported csv file of products I forgotten to add thumbnail column. So because I imported several files of products, I exported all products in one file and ...
0
votes
0answers
225 views

Magento 2 Import CSV File to Custom Module Table

As per my requirement, I want to import CSV into my custom table, for that i have reviewed the following URL http://www.blogtreat.com/how-to-import-csv-file-to-custom-module-table-in-magento-2/ In ...
1
vote
0answers
20 views

Magento 2 import adds info but the import process doesn't end

it's basically what the title says, and I'm only facing this issue when adding prices to products via csv import. I've already checked memory_limit, post_max_size values and they are good, because I ...
0
votes
0answers
116 views

Magento2: How to Import and export CSV file from admin panel?

How to import and export custom CSV file from admin panel demo? I want to add the custom shipping price state and zip code wise in the database from the admin panel. Then I will apply extra the ...
2
votes
1answer
73 views

Magento1.9 CSV generate but not download on save action

Here is my controller code :: public function saveAction() { $post_data=$this->getRequest()->getPost(); if ($post_data) { try { ...
1
vote
1answer
149 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 ...
1
vote
0answers
15 views

Limited images import to magento 1.9

I'm using magento 1.9 and importing products to system, but noticed strange thing: if product have over 5 images then I have problems to upload csv file, when I leave only 5 or less images (links) ...