Questions tagged [csv]

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

Filter by
Sorted by
Tagged with
17
votes
3answers
16k views

Importing orders from a CSV into Magento programmatically

We're switching from an old, outdated point-of-sale system to using Magento 1.7 as our POS exclusively. Not unexpectedly, one of the challenges we're facing is how to get almost 20 years of records ...
15
votes
5answers
23k views

Import & Export all categories using csv file (without extension)

I want to import all the categories in magento using CSV file, I tried to do using extension http://www.magentoworks.net/importexport-magento-category-extension/ it works but i want to do it using ...
12
votes
3answers
5k views

magento 2: 'i18n:collect-phrases' command creates different csv files

php bin\magento i18n:collect-phrases -o "C:\xampp\htdocs\magento\app\design\i18n\xx_YY.csv" -m collects all phrases in the magento application and outputs a csv file with 4 columns: php bin\magento ...
10
votes
4answers
35k views

Adding images with CSV import

I have been running into problem after problem with the CSV export/import functions. My currently problem is that I cannot seem to assign 'image', 'small_image', and 'thumbnail' attributes to any ...
9
votes
1answer
2k views

CSV Import: How can I import related products in Magento 2?

How can I import related products via csv in Magento 2? In my csv file I have a row with attribute related_skus with example data "11-111,22-222" for a product. But in admin Products->Catalog in this ...
8
votes
2answers
5k views

Can i use dataflow import to update products

I am really sorry for asking this. I feel like this is a stupid question, but honestly I have googled until the term googling has lost all meaning. I just want to do a bulk update of product ...
7
votes
6answers
20k views

Is there a way to export all categories into a csv?

Is there a way to export all categories into a csv? Im moving data from a non-magento store into a fresh build.
7
votes
1answer
556 views

How to import not confirmed customers via CSV import?

I'm trying to import customers via CSV Import: System > Import/Export > Import > Customers > Append Complex Data I'd like to import customers which are "not confirmed" after import. ...
6
votes
2answers
3k views

How to use Quotation mark in translation CSV Magento 2

I'm trying to change the following in a custom translation file but can't get it to work: "Check "Remember Me" to access your shopping cart on this computer even if you are not signed in." to "...
6
votes
3answers
9k views

Read input csv file and convert it to array

I have an input file form in phtml to import data from csv file type like this: <div class="import-shipping"> <div class="header"> <h4>CSV File:</h4> </div> &...
6
votes
5answers
8k views

Product custom attribute import with CSV Magento 2.2

I am trying to import product with CSV in Magento2. In first case all attributes are default attributes so import works fine. Now In second case I have added some custom attribute in my Magento 2.2 ...
6
votes
5answers
7k views

How to improve product inventory daily updates from CSV file?

I'm working on a 10000 products Magento store. I scheduled a cronjob to run everyday at 7am to read a CSV file and update each product inventory and set it out of stock if new QTY is less than 1. ...
5
votes
2answers
24k views

Import products with multiple categories

Hi I am importing products in my 1.7.0.2 new setup, I already added the categories. when i import the csv product file, all go well. But the problem is the product is added to only subcategory, it is ...
5
votes
2answers
3k views

Magento :Write form data to csv file

I want to write data in a form to a csv file. I have used the following code: $data = array(); $data['name'] = $this->getRequest()->getParam('name'); $data['company'] = $this->getRequest()-&...
5
votes
2answers
2k views

magento 2 / can't set addImageToMediaGallery path

i created php file in root folder and trying to create simple product programatically in magento 2. testimg folder locating in root. I always thow the error: The image does not exist. Here is code: $...
5
votes
3answers
2k views

Magento 2 import products with images

I'm trying to import a CSV file with new products that contain local images but I am receiving the following error: Imported resource (image) could not be downloaded from external resource due to ...
5
votes
1answer
1k views

update product programmatically magento 2

Whats wrong in my following code ? I am using a script to insert and update product details using csv. Products are inserting / updating without any issues. But only after updated a product... I ...
5
votes
1answer
993 views

Magento dataflow import (stop indexing on the fly)

There are, basically, two ways when importing product via csv file in Magento. a) import b) dataflow import a) option, works faster, I assume that is because this option want index all the data on ...
5
votes
1answer
625 views

Where to put downloadable csv file in custom module and generate download link in phtml?

I have a csv file, i want to put it inside my custom module folder app/code/Vendor/Module but i don't know where to put the csv file inside my custom extension folder, and how to generate link to ...
5
votes
1answer
3k views

Export configurable products with associated simples in one csv

I'm not quite sure how this is done. I want to export a csv with configurable products along with the associated products. Then I would like to import them over on another magento install. How is this ...
5
votes
3answers
9k views

I'm Looking for a sample CSV product file to import into test store

I have my first Magento test site running and I'm looking for a sample CSV product file to import for testing. Does anybody know where I can download one? Ideally I'd like the file to contain lots of ...
4
votes
1answer
1k views

Admin Grid - Remove columns from export

I am in a situation, where I need to display an email_address1 in grid, and during export have to use other one (email_address2). For this I have added two columns in grid, with email_address1 is ...
4
votes
3answers
3k views

Magento 2: Import multiple select attribute values using CSV

How can we import multiple select attribute values using CSV ? For example SKU "test" has two values for attribute "xyz" - "val1" and "val2". When I use both value as val1<space><comma>&...
4
votes
3answers
5k views

Customer CSV export fails with blank page

how's it going. I'm trying to export customers as a CSV file via System > Import/Export > Export, and I just get a blank page as a result. I select Entity Type of Customers and Export File Format of ...
4
votes
2answers
984 views

How to add csv file in attributes

I am beginner in Magento, I want to add csv file for attributes, as we have 500 attributes, so we can not upload it 1 by 1 because it takes time. Please suggest me simple way to upload attributes by ...
4
votes
1answer
2k views

Magento 2.1.2 - Importing multiselect attribute values from CSV

Is it possible to create values for a multiselect attribute via CSV upload? For example we want to populate a multiselect attribute for Car Year. We added a few sample entries and the ...
4
votes
1answer
1k views

How to add CSV Import/Export Functionality

I have created custom gallery extension but I need to implement an import and export or gallery data in the CSV Format. I did too much research but couldn't find any useful link to find solution so ...
4
votes
1answer
852 views

How to override an installed language module in magento 2?

I installed this language module : https://github.com/Imaginaerum/magento2-language-fr-fr Now, due to the Magento translation loading order : Loading the module translations Load theme translation ...
4
votes
1answer
2k views

Why is my csv file not importing successfully in the Dataflow Profile even when it was verified as valid in Check Data?

Hi I am trying to create simple products and a configurable product, then associate those simple products to the configurable product using one csv file. I went to System > Import/Export > Import and ...
4
votes
1answer
223 views

What happens in Magento 1.9 if the browser window is closed during import?

What happens in Magento 1.9 if the browser window is closed during import? Is the import process simply terminated or does it continue in the background? I'm using Magento 1.9's built in feature. I ...
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
2answers
10k views

Importing Images via CSV in Magento

I am running Magento 1.9.0.1 and am having really bad issues with the Product Images showing on import via CSV. I have been researching this issue for 3 days with no luck. When I upload an image ...
3
votes
5answers
6k views

Can i import the bundle products in magento by using csv?

i want to import the bundle products by using csv in magento.i am import the bundle products by using dataflows its import the bundle products but its not show the bundle items in backend. headers my ...
3
votes
3answers
3k views

Are there any csv import logs kept?

We've been trying to import a csv of products on to our Magento store, Magento doesn't show any errors when it checks the file, and it reports the import as successful once it has "finished". The ...
3
votes
1answer
1k views

Magento 2 : Priority of translation, proper way

I'm trying to set up a spanish-english store. I have my dictionary that I want to reutilize for other stores. It has all translations in spanish. I install this dictionary on app/i18n/vendor/es_es/ ...
3
votes
3answers
2k views

run sql query and save result in csv

I want to run a sql query in a PHP file and save the result in a csv file (inkl. header). Unfortunately I don't get it done. It looks like I can't use mysql_* on the result. Does anyone know how to ...
3
votes
1answer
2k views

Remove var Translator = new Translate from <head> section

When I install my language files (nl_NL) in my Magento 1.9.2.2 install, in the head section appears a JS tag that starts with: var Translator = new Translate({... What follows is a whole lot of ...
3
votes
2answers
18k views

What is the best image fromat and size for products in magento

I am new on Magento and as per my requirements, I have to import the products data along with images using CSV files and my all of products images are placed in a remote location, let say http://www....
3
votes
3answers
380 views

How can i remove Multiple Assigned Categories of products remove from selected Category

I need to remove Multiple Assigned Categories of products remove from selected Category. Eg. Product1 assigned to cat1, cat2, cat3. I need my product remove from the category cat3. How can I do it by ...
3
votes
1answer
6k views

csv file format for setting table rate in magento 2

I need to set special shipping cost for 1-3 business days(first 5 kg) for the states Dubai & Sharjah in UAE, but I don't know how to write it in the csv file. Do anyone know the format? Thanks.
3
votes
2answers
2k views

How to replace existing values by NULL or removing them using CSV import

Our client uses Magento CSV import/export functionality to import and export stocks and pricing regularly. Special prices for the products keeps changing. While importing special prices, if we keep ...
3
votes
2answers
122 views

Include en_US translation file in extension

When developing an extension is there an reason other than simply "Best Practice" to include a en_US or extension base language translation file? Example I write an extension with some text where ...
3
votes
1answer
5k views

How to add import option to our custom module

I have created new custom module with the admin form like to create new Products. I have created successfully.All are working fine.But now i want to add one more feature to this module. I can import ...
3
votes
1answer
1k views

Base Image, Small Image, Thumbnail Image radio buttons are not selected after product images CSV import [duplicate]

I have successfully imported product images using CSV file, but Base Image, Small Image and Thumbnail Image columns in Images tab, are not selected. No Image is selected by default. So product images ...
3
votes
1answer
271 views

Magento Export/Import billing_vat

When I use dataflow profiles to export customers the exported CSV-file does not contain the customers billing_vat field. I only get the taxvat field. I believe I have to modify the parser to include ...
3
votes
4answers
3k views

How do I give the right path for fopen() function?

I want to create (write) a csv file in a specific folder. the name of this folder is attin_csv. In the image you can see where is located this folder. This is my code: $csv[0] = $header; //...
3
votes
1answer
860 views

Custom csv Import not working in magento 2.3

While doing importing from backend for custom table its trowing following error systemException Additional data: Error in data structure: entity values are mixed but its correct validated in ...
3
votes
1answer
412 views

Fatal error : Call to a member function getBackendModel() on null in app/code/core/Mage/ImportExport/Model/Import/Entity/Customer.php on line 425 M-1

I got error while importing the customer using CSV in the admin.