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
277 views

Import csv without column names

I need to import articles from a non magento csv file which does not contain any column names. How can I tell the import that product name is in column 1? Anyway todo this without changing the csv ...
1
vote
1answer
91 views

How to bulk import products with images into Magento 2 from CSV file

I'm sitting with Magento 2.3.3. I have a CSV file with some products but when I import the products no images are attached. My imported fine, but when I press Import I get the error message "...
1
vote
0answers
28 views

Magento 2 : Import product error

I have a product csv file and when I import it in admin then is the result https://prnt.sc/pf3rhl Thank in advance. update: I did change all ” to " and this is the result:
1
vote
0answers
24 views

Magento 2 Column names: “_super_attribute_price_corr” are invalid

I'm trying to do a Magneto 1 to magneto 2 import, using the built in Magento 2 importer. I keep receiving the error "Column names: "_super_attribute_price_corr" are invalid". Did the attribute name ...
1
vote
1answer
160 views

Magento 2: Import categories images external url via csv

I have import categories via CSV and I would like to import category image from external URL. I have used Magento ver. 2.3.1 I have tried to save images to the category but can't able to get success. ...
1
vote
0answers
280 views

Magento 2: How to import export Categories in csv via backend using Entity Type catalog_category

I have to need import export categories in csv same as product, in Magento 2 provided same thing for product. I have tried below code but facing issue in Model file path Vendor/CategoryImportExport/...
1
vote
1answer
43 views

Profiler output data

Who can explain to me about data output in profiler report in csv format? I have the next data but don't know what is mean. cache_frontend_create,0.023024,0.011512,2,"2,560,880",0 magento,8.667415,8....
1
vote
1answer
102 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, ...
1
vote
1answer
21 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 ...
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
2answers
191 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-...
1
vote
0answers
30 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 ...
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 ...
1
vote
1answer
54 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 '...
1
vote
1answer
369 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 ?
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: ...
1
vote
1answer
243 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?
1
vote
0answers
100 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.
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 ...
1
vote
1answer
335 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
102 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
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.
1
vote
1answer
276 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 ...
1
vote
0answers
26 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 ...
1
vote
0answers
81 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
0answers
193 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 ...
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
328 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 ...
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
724 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?
1
vote
1answer
256 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
208 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
118 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 "...
1
vote
0answers
144 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. ...
1
vote
0answers
34 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 ...
1
vote
0answers
58 views

How to understand magento 2 profiler output?

I've just enabled profiler on my M2 site (csvfile output). But I can't understand its content. Is there any software that could make the output data more understandable?
1
vote
0answers
101 views

Manipulate customer grid column data in csv(export)

I added a custom column in customer grid i.e subscriber_status which is showing correctly. In DB the actual value saved as either 1(subscribed) or 3(unsubscribed). Currently I am able to manipulate ...
1
vote
0answers
469 views

general system exception happened additional data: class name and class type already exists

while importing in magento 2 getting this error general system exception happened additional data: class name and class type already exists. when i check in var/import_history/filename_error.csv ...
1
vote
0answers
217 views

Magento product with many custom options, need to update the prices with unique values for each product

I have simple products with 1,815 custom options which are tartans, and I need to update the price with unique values for each product. Would I be able to achieve this using a CSV import or do I need ...
1
vote
0answers
74 views

Multiple CSV Automation - Distributors product feeds for ecommerce importing

I am looking for a way to merge / automate 3 CSV files which each have different headings, i need to import these files automatically into Magento but they need to be mapped to attributes that Magento ...
1
vote
0answers
38 views

Magento, photo import ( csv ) from url, no direct link

How do I import CSV a photo from a url? It is not a direct link though. There is a link to the product page with description and a photo gallery. here is how the link ends /product.php/pid-...
1
vote
0answers
305 views

Automatic import csv

Is there a way to automatic import product wholesale csv to magento2 I know some extensions has column mapper but my csv doesnt have the requered headers like productype etc, so the import fails. ...
1
vote
0answers
201 views

not getting associated product's sku in export CSV Magento 1.9.2

I am trying to get associated product's Sku of configurable products in exported CSV file but not getting. Here is my Action XML in "Dataflow-Advanced profiles" - <action type="catalog/...
1
vote
2answers
2k views

Category has not been created. URL key for specified store already exists

I am trying to upload my stock through the Magento 2 admin panel via CSV. I am getting the following error: Category "Default Category/Aftermarket and Parts/Spare Parts/ Fasteners/Screws and Bolts/...
1
vote
1answer
481 views

Import Module to allow for multiple CSV imports in a batch setting

<?php /** * Copyright © 2013-2017 Magento, Inc. All rights reserved. * See COPYING.txt for license details. */ /** * Import model * * @author Magento Core Team <core@magentocommerce....
1
vote
1answer
347 views

Fail to import large file on Magento 2 from admin

I succeeded importing a csv file size 319KB with 357 products. But failed to import a csv file size 571KB with only 349 products. Please help me to fix the problem.
1
vote
0answers
571 views

import products csv file fails with 'Specified URL key already exists in row(s)' error

I have the following error "Specified URL key already exists in row(s): 99, 124, 179, 190, 194, 222, 271, 297, 326, 328, 329, 332". When I tried to import some 338 simple products with created ...
1
vote
0answers
92 views

How to skip some column to write csv data

I would like to skip some column to write data in CSV when it generate. Here is my code to generate CSV in magento. it would be start writing from column no 20 for first row only then continue with ...
1
vote
0answers
21 views

Can not find products after uploading test .csv

i have successfully uploaded a test csv but the product i am using to test does not exist in the admin panel anywhere? Any known problems like this. I am still learning so sorry if the answer is ...