Stack Exchange Network

Stack Exchange network consists of 174 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
0answers
23 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
27 views

Problems Importing Product CSV file

I have a big issue with reading my csv file. When i do a 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
14 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
21 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
43 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
31 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
13 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
20 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
8 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
2answers
28 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
19 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
38 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'...
0
votes
1answer
20 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
20 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 ...
2
votes
2answers
227 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 ...
1
vote
0answers
41 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
100 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
39 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
13 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
28 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
45 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
1answer
28 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 ...
0
votes
0answers
61 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
162 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
196 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
26 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
1answer
36 views

Magento 1.9.2. - Complete import of configurable products

I'm trying to import the new configurable products on my magento store with the eMagicOne program for Magento. I am following this guide: https://www.mag-manager.com/useful-articles/how-to-create-...
0
votes
1answer
77 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
112 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
25 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
162 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
96 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
51 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
104 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) ...
1
vote
0answers
34 views

Can't Upload products via CSV file

I am trying to import products from import/export profile in magento 1.9. I am trying to import a csv file but the csv file is not being imported and the following error is being displayed. Does ...
0
votes
0answers
82 views

Magento2 Product Import issue

I have an issue with "country_of_manufacture" field where I have put the country code like US and I am getting the error message for all the rows, I have checked no space in that column. Second, I ...
1
vote
1answer
53 views

How to translate escapehtml (Filter by)

Hello i cant to translate this one http://prntscr.com/kt3mrb my code is <div class="block-content filter-content"> <?= $block->getChildHtml('state') ?> <?php if ($...
0
votes
0answers
44 views

how to add images with create excel sheet

I have generated excel sheet using the following code: $filename = 'offer_'.time().'.xlsx'; $xmlObj = new Varien_Convert_Parser_Xml_Excel(); $xmlObj->setVar('single_sheet', $filename); $xmlObj->...
0
votes
1answer
52 views

Exporting customer addresses messes up CSV

I have been trying to export customer addresses from magento, but I have a issue with the 2nd line off the street address. No matter what way i export it ( magentos dataflow or directly from the ...
0
votes
0answers
16 views

How To Update the cost of a product by using the advanced pricing in import function

How To Update the cost of a product by using the advanced pricing in import function. In my csv file if i add the cost field it was showing an error.so any one can help me???
0
votes
3answers
41 views

How to increase the length of the product meta_description in Magento1.9 (when importing)?

How to increase the limit of meta_description in magento1.9 .When we have import bulk of products during CSV then showing meta_description limit error.Please give me any solution?
0
votes
1answer
206 views

How to change Magento2 export product MULTI VALUE SEPARATOR?

In product import, there is interface input box to select multi value separator which is comma. But in product export, we cannot select separator so it will mix up with the field separator.
0
votes
0answers
27 views

How can I download the file generated by “export product stock” option? Magento.-1.9

Basically I need to download the resulting file using the "Export product stock" function. I know that this file is saved in the var/export directory but I need to download it at the same time it is ...
0
votes
1answer
99 views

how to get current csv row number in magento2?

I want to add condition on rownumber : like if ($row==1){ echo "test"; } else{ echo "done"; } file path:Magento\ImportExport\Model\Import\Source\csv protected function _getNextRow() { $parsed = ...
0
votes
1answer
463 views

How to download products in a CSV file?

We are going to migrate our products to Shopify and we need to download the products in a CSV file? Is that possible? How do you do that? using Porto theme
0
votes
0answers
82 views

export all the invoice with it transaction id and payment method

I want to export all the invoices with its transaction id and payment method. I have attached image above for reference so which table should be inner join in order to display in admin panel grid. ...
0
votes
0answers
61 views

Magento 1.9 Error 524 During Products Import

I am working on Magento 1.9. When i try to import products CSV file on Magento. The following repose i got in Network TAB of inspector: Error 524 Ray ID: 4xxxxxxxxxxxxfa • 2018-07-02 06:59:...
1
vote
1answer
52 views

Magento 2 Import product are not updated in front

I imported 1500 products from a CSV file that went well. In the back office when I look at my individual product, the value of the attribute is good. However, when I look in the list of products still ...