Questions tagged [csv]

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

Filter by
Sorted by
Tagged with
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
563 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
645 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
446 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
575 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
428 views

Magmi Image path not found [closed]

I am uploading 1000 products to Magento 1.9 using Magmi's Image Attributes Processor and receive the following error SKU 3800231 - Image attributes processor v1.0.33 - path/853698004078.jpg cannot ...
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
1answer
3k views

Imported products not showing up on front end - Magento 2

tried searching but couldn't find an answer. Apologies in advance if it's a duplicate question. I've imported a bunch of products to a new Magento 2 setup. I created the CSV files and added all ...
2
votes
0answers
52 views

Magento deleted my products [closed]

I am trying to import a spreadsheet with some products in csv with a standard sku, as alm001-alm002-etc. I already have some registered products of 001-560, but when I import the new .csv file (beyond ...
2
votes
0answers
797 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
244 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
1answer
1k views

How to import configurable products?

We have imported the simple product using system -> Import/Export -> Dataflow profile -> Import All Products We want to associate this product with configurable product. How we will ...
2
votes
0answers
146 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
0answers
449 views

Magmi Updating Product url_key [closed]

I'm looking to run a .csv dump file in magmi that updates the products url_key to ensure that all products keep their original key after a full export and import of products. (url_key may change due ...
2
votes
1answer
238 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 ...
2
votes
1answer
1k views

Exporting to CSV creates displaced rows and way too many

So I have maybe less than 150 total products but my CSV file is reaching 900 rows. Additionally there are displaced rows with some things tripled or doubled. Is there a way to clean this up before ...
2
votes
0answers
46 views

Different products name in the different store views under the same store [duplicate]

I have my product info translation csv for multi store. I need to change my language for each product name. What step do I need to take to accomplish this? How can I do this with the import/export ...
2
votes
2answers
3k views

Magmi: On the fly category creator/importer root catalog [closed]

We are using a multistore deployment. In the csv we have as follows: (mind you these are not literal, just examples) store: using the store code for the store view, e.g.: substore1_en websites: ...
1
vote
3answers
543 views

Do you enter your new products directly into your live site?

Our admin side of our site has been running extremely slow when we're entering new products and saving them. We typically have 8 people entering products at once and we're being told that because of ...
1
vote
1answer
397 views

Import Product Dimensions (Length, Width, Height) in Magento 2

I am trying to import dimension data to a Magento 2.2.6 store. The Magento attributes are present on the product, but I cannot figure out how to import to these fields. I have tried length and ...
1
vote
2answers
501 views

php - create csv export file, based on product values

I currently have the following script, that change the producttitle of a product with a specific ID. Now I want to re-write the script, so that it does not update the attributes but generates a .csv ...
1
vote
2answers
771 views

Custom CSV export for last 1000 orders

I would like to export the last 1000 orders with following fields: order id, customer email, first name, last name. Is there an easy way to export a CSV like this? I do have access to PHPMyAdmin.
1
vote
3answers
1k views

Importing prices csv is taking a long time

In Magento 2, there are roughly 115,000 products in the store. There are 7 customer groups. When importing prices via csv, the batch upload slowly imports the price but eventually crawls to a stop. ...
1
vote
1answer
502 views

magento 2 varien_file_csv

I have a script from Magento 1 that I ned to convert to Magento 2. The script uses Varien_File_Csv that I can't find in Magento 2, and so can't the Magento 2. Where is this file in Magento 2 found? Or,...
1
vote
1answer
1k views

How to add Upload Button for importing a csv file in the Custom Admin Grid Container?

I'm creating a custom module where i have a requirement to add a upload button to the Grid container for uplaoding a csv file and execute it to update a attribute value in the database. how do i ...
1
vote
2answers
2k views

magento can't upload large csv file

this is my file upload code when i try to upload file which has size more than 75mb i can't upload file i did't get any error i also change php.ini file still its not working $uploader = new ...
1
vote
1answer
183 views

.csv tax file only uses the *last* line of the file for tax rates

Can someone look at a .csv tax file and tell me what I'm doing wrong with it? It is totally ignoring all the lines in the file, and only using the zip code in the last line of the file to produce tax ...
1
vote
2answers
2k views

Import csv file through a shell script

Is Importing a csv file through a shell script a good idea? Why yes and why not? What are the principal issues? Thanks!
1
vote
3answers
5k views

Exporting a CSV File

I need to export a CSV file with all the product weights on it, i tried to do it in the back end but i get this error Request Timeout This request takes too long to process, it is timed out by the ...
1
vote
1answer
757 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....
1
vote
1answer
85 views

Custom Model Mass Importer

I built a module that has a custom Model and database table it includes an admin backend model manager which allows me to export the data to a CSV/Excel file. What is the best way to go ahead and add ...
1
vote
1answer
3k views

How to import customers in magento-2 using csv?

Currently i am working on magento-2 .I have imported products successfully. Now i want to be import customers . I dont have any demo csv for import customers .
1
vote
1answer
421 views

Magento category export and import with id and path

Is there a way to export and import categories with paths and ids? Anyone maybe have already written code?
1
vote
2answers
791 views

Programatically put meta description in Magento cms Pages

I have more than 500 cms pages in my Magento store, and i want to change all meta descriptions based on a CSV file. There are two columns in my csv file: Cms Page identifier Meta description
1
vote
2answers
1k views

How to Import images to a multi store Magento website thorugh CSV file?

I am running a Magento 1.9.1 website, which is a multi-store website.My need is to import images to each particular store .My stores are Sports,Music and default. For eg:- my products are sku1 and ...
1
vote
1answer
618 views

I want to create a shop with affiliate products, i need to import them from csv feed

I want to import products from csv file. But how to get product images from an url? The csv file contain the image url and affiliate link too. I need to import this two fileds in specific places.
1
vote
2answers
10k views

import configurable products csv [closed]

I'm trying to import a csv which contains both configurable and simple products. I'm using the built-in "Import all products" profile, and using this example: "attribute_set","type","category_ids","...
1
vote
2answers
73 views

Varien_File_Csv_Multy Class Not Found

I am trying to instantiate the class Varien_File_Csv_Multy which is located in lib/Varien/File/CsvMulty.php $csv= new Varien_File_Csv_Multy(); echo get_class($csv); and $csv= new ...
1
vote
1answer
1k views

CSV Mapping while importing products

I am working on one custom module where i imported products from csv successfully.But i am doing like first field must be sku and second should be name.But the issue is if someone change the sequence ...
1
vote
2answers
967 views

how to upload orders from csv in front end by customer?

I have customer type as wholesaler.if any wholesaler logged into magento from front end he should be able to place bulk orders through csv as an option. I mean he knows all product skus. Is there any ...
1
vote
1answer
2k views

what is the maximum length for meta_keyword, meta_description and meta_title

While Uploading CSV, There are some constraints that we have to follow, Like lengths of the attributes : Please Provide the length of following attributes: "meta_keyword" "meta_title" "...
1
vote
2answers
2k views

CSV import and auto create manufacturers

I have created a script which generates CSV file. I have one problem. The Manufacturers are coming from the data are not in Magento and practically cannot be created in advance. Is there any way to ...
1
vote
1answer
920 views

Bulk customer upload?

I've been searching a kind of extension to upload customers in a bulk but I didn't find anything. Do you have any system to upload a lot of customers via csv, xls.. etc? Or there's an option that I ...
1
vote
3answers
715 views

How do I change name of 45000+ products via single import?

I am working on one Magento Commerce store and want to change name of 45000+ products via single import. There are too many products on website with all CAPITAL product name. This is creating big ...
1
vote
1answer
124 views

How to Create a excel file in custom module?

I want to create an excel format file for download in Magento 2 <item name="buttons" xsi:type="array"> <item name="add" xsi:type="array"> <item name="name" xsi:type=...
1
vote
1answer
87 views

Magento2 : How To Add New Words To Arabic Language Pack ar_SA.csv File

Hello I want to add new words to already available arabic language pack csv file. Can anyone tell me how i can add new words?
1
vote
1answer
627 views

Magento 2 Write to CSV within Controller

I have the following code: protected $_fileSystem; protected $_directoryList; public function __construct( \Magento\Framework\Filesystem $fileSystem, \Magento\Framework\App\Filesystem\...