Questions tagged [csv]

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

232 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
1answer
1k 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?
4
votes
1answer
2k views

How to delete product images using magento csv import in magento 2?

Magento Version: 2.1.0 We have added the wrong image for some of the products when importing through Magento CSV import. we want to remove the images from those products and add new images or replace ...
4
votes
0answers
597 views

export group price and tier price in magento

How can we export group price and tier price in magento 1.9? Currently I am using profiler to export product price but I didn't get group price in exported csv file. Group price column shows blank ...
3
votes
1answer
847 views

Is there any tool to Convert magento 1 Product import csv file to magento 2

I have Magento 1 Product Import CSV file, I need to convert Magento 2 Product Import CSV Format. Is there any tool out there?. If not there means, Suggest me How to Convert it. Because ...
3
votes
0answers
36 views

Adding new products to a store with a template, without changing other products in the store

I have recently taken over a store at work that I did not build, nor do I have enough experience with Magento to be truly confident yet. I have a .csv product template, to add 195 new products to a ...
3
votes
0answers
2k views

How to export/import orders in Magento?

I am moving companies website from old installation 1.7.1 to fresh installation of Magento 1.9.3. I have moved now all the Product and Customer data easily - how do I export/import orders? I have ...
3
votes
0answers
264 views

Problem importing images from a CSV file - Magento ver. 1.9.2.2

Magento ver. 1.9.2.2 I've been working on this issue for several days and have read numerous articles. I have uncovered a few clues but can't tell where the hang up is. Here is a link to a test CSV ...
2
votes
0answers
135 views

Magento 2 - Import product quantity is empty after product csv import

In Magento 2.3.1, When I Go to admin panel System -> Import -> Products and Upload product CSV. Product imported with all information but miss qty, it shows empty. Any help, experience and ...
2
votes
0answers
72 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 ...
2
votes
0answers
91 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 ...
2
votes
1answer
445 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, ...
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 ...
2
votes
0answers
78 views

Magento 2 : Any Script or Extension to Attach Product Images to SKU

I am looking a script or extension to do this: I upload products via CSV, then run script or extension and attach product images (multiple) to the SKU, easy and fast and don't have to write in csv ...
2
votes
0answers
550 views

Custom csv import using data flow profile not working in magento-1.9.3.1

I want to custom import csv in a model using data flow profile. For that i have followed below steps : 1) Created a customimport.csv under var/import 2) Under admin > system >Import/Export >...
2
votes
0answers
32 views

Import programatically images in Magento issue

I have created a custom script to import products from csv. I succesfully imported image, thumbnaill, and small image like this: # media gallery initialization ->setMediaGallery (array('images'=&...
2
votes
0answers
642 views

Magento 2 Export Button CSV and XML Catalog Product Problem

I added Export Button to the grid catalog but still the following problem appears : Exception #0 (Magento\Framework\Exception\LocalizedException): A joined field with this alias is already declared. ...
2
votes
0answers
443 views

Magento import hangs

I am having some problems with base import on a Magento website. Problem is that the import hangs and remains stuck on the Please wait message. I checked, the var/importexport has all the necessary ...
2
votes
0answers
574 views

Magento 2.1.2 “Invalid option value” when importing configurable products

I'm trying to import configurable products into Magento 2.1.2. I have already imported the simple products. When trying to import the configurable products, it seems to happen randomly. In total I ...
2
votes
0answers
1k views

How to generate/export a custom format of CSV file?

I hope some one can help me. Now, I want to generate a csv file of my sales order, but I think existing magento 2 csv format is not fulfill my expectation. Could anyone can help me how to generate ...
2
votes
0answers
80 views

The problem with importing Product Sheet in the category, the title that has a comma

When importing faced such problem. If the path search has regular commas after each comma creates a new category. Example: Default Category/Event,Music and Image/ need to create a single category("...
2
votes
0answers
786 views

Migration: How can I map own product attributes and attributesets in Magento 2?

I tried several migration ways for products from Magento 1 to Magento 2: Data-Migration-Tool by Magento Including mapping but only for documents (tables) and fields (table columns). Another problem ...
2
votes
2answers
1k views

Error 500 internal server error validate key magento

I'm new to Magento which makes me a big newbie. I have recently set up a localhost store using XAMPP. Now I want to import 500 products with my CSV file. I've looked up the CSV file structure and I ...
2
votes
0answers
241 views

Error when exporting customer grid to csv "cannot define correlation name 'billing_street_first_line' more than once

EDIT: So I have narrowed it down to the fact that Magento does not like the JOIN when I am adding it to the collection. Is there anyway to make it so it doesnt duplicate the correlation name or ...
2
votes
0answers
144 views

CSV qty (quantity) import issue

I'm having a problem with the gty (and just with the guantity) when importing the products from csv. I'm doing the import from system -> import/export -> import -> Replace Existing Complex Data. I ...
2
votes
1answer
233 views

Load products in grid serializer after CSV import through AJAX

I want to use import feature like attached screen-shot in my custom module. please refer the attached screen-shot. Actually I want to load the products in grid which are mentioned in CSV after import ...
1
vote
1answer
63 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
20 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
135 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
235 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
84 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
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
149 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
27 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
52 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
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
0answers
94 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
315 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
98 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
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
52 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
186 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
307 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
712 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
250 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 ...