Skip to main content

Questions tagged [csv]

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

254 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
7 votes
2 answers
8k 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?
Ronak's user avatar
  • 797
5 votes
0 answers
414 views

Magento2 import stock sources successful but no changes made and not showing in import history

Preconditions (*) Magento ver. 2.3.4 About 10000 skus, this process has worked many times previously, suddenly stops working. No new modules or configurations have been done since last time the ...
Christopher Liddell's user avatar
4 votes
0 answers
769 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 ...
Rahul's user avatar
  • 739
3 votes
0 answers
324 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 ...
Muhammad Hasham's user avatar
3 votes
0 answers
244 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 ...
Fanny Ribard's user avatar
3 votes
2 answers
1k 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 ...
Rajkumar .E's user avatar
  • 3,570
3 votes
0 answers
861 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. ...
Creativity Group's user avatar
3 votes
0 answers
39 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 ...
lockykeaney's user avatar
3 votes
2 answers
2k 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 ...
fkr's user avatar
  • 31
3 votes
0 answers
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 ...
pasujemito's user avatar
3 votes
0 answers
299 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 ...
user1861582's user avatar
2 votes
0 answers
62 views

Add Attribute Bulk Value Using CSV File in Magento 2.3.3?

I have Magento 2.3.3 Store And I have too many Product Dropdown Attribute And One Attribute have a something 500 1000 value. So How can I add multiple values using CSV file or other options so, ...
Rohit Gohel's user avatar
2 votes
1 answer
239 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 ...
seanworld's user avatar
2 votes
2 answers
1k views

export csv file from magento 1.9 to import product csv in magento 2.3.0

I have a task to import products from m1 to m2. I having the CSV file with products(from Magento 1 export) at the moment. When I try to "Check Data" on the import page - is always loading. ...
Duddy Woody's user avatar
2 votes
2 answers
2k 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-...
Paras Arora's user avatar
2 votes
1 answer
166 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 ...
LolliPopPingu's user avatar
2 votes
1 answer
1k 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 ...
sam's user avatar
  • 489
2 votes
1 answer
1k 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, ...
matt's user avatar
  • 193
2 votes
0 answers
447 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 ...
Chris Graham's user avatar
2 votes
0 answers
42 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 ...
Darshan Jethwa's user avatar
2 votes
0 answers
2k 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?
Ashik Ali S's user avatar
2 votes
0 answers
197 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 "...
K. Maliszewski's user avatar
2 votes
0 answers
87 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 ...
Sergio Pera's user avatar
2 votes
3 answers
5k 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/...
Deadulus's user avatar
  • 245
2 votes
0 answers
797 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 >...
Manashvi Birla's user avatar
2 votes
0 answers
39 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'=&...
Alin Lupoiu's user avatar
  • 2,662
2 votes
0 answers
533 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 ...
Andras's user avatar
  • 169
2 votes
0 answers
724 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 ...
PublicDisplayName's user avatar
2 votes
0 answers
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 ...
Felix91627's user avatar
2 votes
0 answers
96 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("...
Evgen's user avatar
  • 21
2 votes
0 answers
1k 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 ...
Guest's user avatar
  • 363
2 votes
0 answers
270 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 ...
Chest Rockwell's user avatar
2 votes
0 answers
182 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 ...
user15151's user avatar
  • 581
2 votes
1 answer
305 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 ...
Lalit Kaushik's user avatar
1 vote
1 answer
44 views

Import Product With Pipe Sign as configurable_variations

I have an Product Attribute with following values : https://prnt.sc/u8JrDsg_noG0 now when I am trying to import with that : https://prnt.sc/jyArfXbh5Ezs It gives me error : https://prnt.sc/...
Mark Philips's user avatar
1 vote
0 answers
122 views

Magento 2.3 Export All Invoice In Excel csv or xlsx

I need to export of all my invoices in xlsx or csv format (33K invoices ) What I want is to export the invoice information in the form of columns: customer name, amount, product... Is there a way to ...
Said Erraoudy's user avatar
1 vote
0 answers
690 views

How to create a script to export each product with all images, names, SKUs, dimensions as a CSV programmatically in Magento 2?

**This is a working code** **You Create a file path as i.e. http://localhost/magento241/exportproduct.php** <?php use Magento\Framework\App\Bootstrap; use Magento\Framework\App\Filesystem\...
Vikram Dhande's user avatar
1 vote
0 answers
225 views

Problem with importing products in magento 2.4.1

Value for 'size' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 1, 2, 3, 4, 5, 6, 7, 8, 9
GerranoMargeno's user avatar
1 vote
0 answers
312 views

How to get columns header of csv in custom import module

Hi I created custom module for import data by helping module ( https://github.com/Smile-SA/magento2-module-custom-entity-import-export) In this case I need to get csv header names. I tried several ...
Singhe's user avatar
  • 149
1 vote
1 answer
62 views

Export attribute set and the attributes that are assigned to it

our attribute sets have become messy, things are assigned to them that shouldnt be and some things that should be havent. Is it possible for me to export to CSV the attribute set name and a list of ...
Lewis's user avatar
  • 11
1 vote
0 answers
143 views

Import add and update products with their attributes in a CSV file and cron job Magento2

I am using Magento 2.3.3 and wants to import products using cron and csv. I have google Sheet which contains all products data and sheet's data changes continuously. So I have to run a cron every day ...
saurabh garg's user avatar
1 vote
1 answer
50 views

Error while importing products through csv in magento 2

I am trying to update my product price through csv. When I run this import, I am getting this error: -> The value specified in the URL Key field would generate a URL that already exists. https://...
Nafsss's user avatar
  • 760
1 vote
1 answer
23 views

Magento 1.9 - After Export Products, Category few columns values like 000,000,000

After export products, category few columns like 12,223,234,544,348,000,000,000 what is mean 000. How to view what category it is? FYI - few products assigned to more than one category like 6 or 7 ...
zus's user avatar
  • 165
1 vote
0 answers
1k views

Import products via command line using Magento\ImportExport\Model\ImportFactory in Magento 2.3

I want to import products from .csv file using command line. Referring to this link: https://www.thirdandgrove.com/insights/importing-products-magento2-part2/ everything is working fine, except ...
SebastianT's user avatar
1 vote
0 answers
50 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:
MichaelHa's user avatar
  • 661
1 vote
1 answer
1k 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. ...
Kirti Nariya's user avatar
  • 3,471
1 vote
0 answers
25 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 ...
imtiazau's user avatar
  • 379
1 vote
0 answers
42 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 ...
Kurtz's user avatar
  • 41
1 vote
0 answers
33 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 ...
robgt's user avatar
  • 439
1 vote
0 answers
105 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 '...
Jaisa's user avatar
  • 2,606

1
2 3 4 5 6