Questions tagged [csv]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
61 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
1answer
491 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
24 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
158 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
223 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
311 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
95 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 ...
1
vote
1answer
199 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
1answer
187 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 ...
1
vote
0answers
20 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.
0
votes
3answers
94 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?
1
vote
1answer
413 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
1answer
146 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
975 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
1
vote
1answer
265 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 ...
2
votes
1answer
435 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, ...
0
votes
1answer
65 views

Hide columns under condition when exporting csv

Fyi, I did read from another similar post where I came to a good solution (Setting is system true will prevent it from getting exported). However, my problem is I would like to have two type of csv ...
1
vote
0answers
24 views

Adding multiple products (csv files taking too much time)

So we have a CRM/Accounting/Sales/Inventory system called BrightPearl. This is used as our product database and we can import and export data into it using CSV. Files. I say product database and use ...
0
votes
0answers
30 views

Magento 2 Products Not Showing on Website

So let me be as specific as possible about all the attempts. I am aware of how to successfully upload CSV into the backend. Prior to this product load I am referencing, there were 8 configurable pants ...
0
votes
1answer
49 views

Export magento orders per product

I need to export magento orders per product ( I want to get all the orders for a specific product) How could I do it?
1
vote
0answers
46 views

Running simple Data Flow import profile deletes records

I encountered a very weird issue. I am trying to run a very basic import data flow profile (done it a hundred times before) by using selected Magento columns: sku, category_ids and status which looks ...
1
vote
2answers
269 views

How to import the CMS content in CSV file

I want to import the CMS content in to .csv file. So can anyone has used any tool to import the CMS content.
0
votes
0answers
529 views

Create a cron job for importing csv files in magento 2

I am trying to schedule a cron job for importing csv files which consists of the product details. But the cron is not working. can anyone help me resolving this issue? I am using the following code ...
0
votes
2answers
63 views

Get Order by increment_id

I'm trying to read from a csv file a list of increment_ids and get order using them. if (($file = fopen('increment_ids.csv','r')) != FALSE) { while($data = fgetcsv($file,0,"\t")) { $...
1
vote
0answers
185 views

Magento 2: Export Order Shipping Address As Separate Fields

When I export orders as a csv file from Magento 2 admin, the shipping address is exported as a single field in the csv file, i.e. there is a column called "shipping address" with the entire address in ...
0
votes
0answers
58 views

Magento Table Rates

I was wondering if there was a way to name the different table rates? I have set by importing a CSV with the different rates + the country codes and I would like to give some of these methods names ...
0
votes
1answer
467 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 ...
1
vote
0answers
44 views

Update product programatically

I wrote a script for adding products programatically from a CSV. It's working fine. Now I need to update it to do followings, Check if product is already available (using SKU ) and if not, add new ...
1
vote
0answers
305 views

Import products and customer data programatically

I needed to programatically export and import customer data, product data and order details. I've successfully created my exports. I'm having problems with my import. I need to do this using an ...
0
votes
2answers
858 views

How to Change 'SKU' Label in product detail page using CSV Magento2

I don't have experience with change name using CSV. Actually, I want to change Name From 'SKU' to 'Product ID' using CSV in magento2.
2
votes
0answers
36 views

Product image import through csv throws required sku error

Ive multiple images for single product and Im trying to import it through csv as shown below. when I`m importing this csv file it gives me required sku error. So am i missing something here or my ...
0
votes
0answers
77 views

Configurable Product Turning into Simple Products Mass Import CSV Magento2

Hello StackExchange community! I am having a serious issue with my Magento CSV mass product import to Magento2. I have about 1800 SKUs to upload and am testing a configurable product and their ...
1
vote
1answer
33 views

After updating only product price through Csv using Sku code, it changes quantity to 0 in magento 1.6.0

We have updated only the price using Magento CSV import functionality, but it automatically changes my product quantity as well. Below is the CSV file format Can anyone suggest why this is ...
1
vote
0answers
703 views

Import Prices for different store views in Magento 2

I am importing the prices through CSV for different store views. It does not import the prices properly. Can you please give me the solution for it?
0
votes
1answer
2k views

How to add shipping rate according to weight?

Actually i trying to add shipping charges according to weight.i didn't use any code i did it through admin->sales->shipping method->table rate->import csv.but i facing problem bcoz its not taken ...
1
vote
1answer
246 views

Magento223: How to Import CSV during module installation

I have custom module in which i am importing csv file upon button click. I want to import the csv during module installation, i don't know how to implement it in install data file. Any help will be ...
1
vote
0answers
196 views

Magento 2 - creating a Custom Attribute of type Boolean and assigning its default value to all the existing products in the DB

I have created a custom Attribute for the Product which if type Boolean and set the default value as Yes. When I try to fetch the newly created attribute through Rest API I am not able to get the ...
1
vote
0answers
114 views

Magento 2: Missing entity types in CSV import

I have a fresh instance of Magento 2.2. In the Import tab, there are only "Products" entity types. Should I enable anywhere rest? Like e.g "advanced pricing"? Edit. SOLVED -> Module "...
0
votes
1answer
243 views

Product image uploading issue from external path magento 2?

I am uploading images from an external URL. Image uploaded in the dir but getting an error message: 1. Imported resource (image) could not be downloaded from external resource due to timeout or ...
1
vote
0answers
139 views

Magento 1.9.2.2 Datwflow Import Product Price Update CSV

i need to update some prices in the shop and made this many times in the last years. But now i have the problem that magento kills my product descriptions on update. My CSV file has only two fields. ...
0
votes
1answer
134 views

Upload Special Characters

I am trying to upload all my products but I keep getting errors. I have them with special Characters, When I check the data it is valid and good. With the next one I get this error: Please let me ...
0
votes
1answer
553 views

Magento 2 CSV image upload from external url saves image name with full url path

Does anyone know why magento saves image name with the full path or url e.g http://123.123.123.123/images/image.jpg will save the image name as http123123123123imagesimage.jpg. It doesn't seen right ...
5
votes
1answer
1k views

update product programmatically magento 2

Whats wrong in my following code ? I am using a script to insert and update product details using csv. Products are inserting / updating without any issues. But only after updated a product... I ...
1
vote
1answer
1k views

Magento 2 CSV bulk upload product for multi website with a different price

Need to upload CSV for multi website e.g "base,us" base will have £100.00 us will have $110.00 I have a sample where I change price from admin But when I export CSV I only see the price for the ...
0
votes
1answer
218 views

Grid csv/excel export not working

I currently can't export anything in the grids for products, clients and newsletters in my computer (and from another computer in another state). It downloads properly from my phone. When I click ...
0
votes
1answer
119 views

Bulk Products import are not showing on front end

I have uploaded bulk products through using a CSV file. The products get uploaded successfully and can be found on the back end, but they are not showing on front end. When I edit a product and save ...
1
vote
1answer
739 views

Magento 2. Custom grid. Can not exprot to csv

I've created custom grid block using UI component but I can not export it to csv file. I'm getting the error: Undefined index: attributes in vendor\magento\framework\View\Element\UiComponentFactory....
0
votes
1answer
291 views

import parent and sub category with csv magento 1.9

I am uploading a CSV in Magento 1.9, and what i need is to import both categories and sub-categories, but now it is currently importing only sub-categories. Here is an example of how I the categories ...
1
vote
0answers
33 views

Base table or view not found: 1146 - While importing products from one DB to another DB

I have a site in magento 1.9.2, I installed a new magento 1.9.2 on my localhost which is blank. I export all products by going into system->dataflow->exports and download file as a csv. Now I am ...