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

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

0
votes
1answer
10 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
20 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 ...
0
votes
0answers
13 views

Default Value for csv

I am using Magento 2.2.5.I have only one type of product_type an attribute_set, so we don't want to fill in CSV templates, we need to pass that value from code. In row validation i manually entered ...
0
votes
0answers
19 views

Magento 2.2.3: CSV file to read from, into existing script

I found this great script for updating Stock quantities. script php to update stock I am trying to use a csv file to be imported into the array to replace $products = [ 'test-product-1' => 3, '...
1
vote
0answers
14 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
17 views

Magento2: Import catalog price rules and cart price rules programmatically [closed]

In Magento-2, I want to import catalog price rules and cart price rules programmatically using CSV file. Anyone know, how to do this or do you know any good extension for this in Magento2 ?
0
votes
0answers
25 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 ...
0
votes
0answers
12 views

How to remove all product from category by CSV bulk sheet?

In Magento1 just I was uploading csv sheet sku , Category_id empty was remove all the products from the assigned category, why Magento 2 is not working ??
2
votes
1answer
36 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
28 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
22 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
29 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
30 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
14 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
24 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
12 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
31 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
36 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
20 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
48 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
136 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
46 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
21 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
32 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
2answers
53 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
25 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
16 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
114 views

Generate .csv file with order data, and save to upload dir

I started working with frontend in magento2 about 1.5 months ago, and now I was asked to add a feature to the website, which requires a bit of backend knowledge (module, events, file generation). ...
0
votes
1answer
20 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?
0
votes
0answers
112 views

Magento2 CSV product import qty and is_in_stock

we have to import products from old (not Magento) shop via CSV to new Magento2 shop. Import is working well, but the only field is_in_stock is not set correctly if we have quantity (qty) set a value ...
1
vote
0answers
16 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
1answer
82 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
195 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
0answers
10 views

How to add image in csv after using the script. Magento2

How to add image in csv after using the script. Magento2 if any have idea please share
0
votes
2answers
52 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")) { $...
0
votes
0answers
37 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
29 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
185 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
39 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
33 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
0answers
53 views

General System Exception Happened Product Import WITH Store View Code

Does anyone know of what could cause a general system exception error on product imports, besides a missing store_view_code column as the second column? I have this and am still getting an error upon ...
0
votes
2answers
252 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
1answer
32 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
37 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
27 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
280 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
390 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
84 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
146 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 ...