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
19k 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 ...
16
votes
5answers
25k 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 ...
14
votes
3answers
8k 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
37k 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
6answers
15k views

Product custom attribute import with CSV Magento 2

I am trying to import product with CSV in Magento2. In the first case, all attributes are default attributes so import works fine. Now In the second case I have added some custom attributes in my ...
9
votes
1answer
3k 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
8answers
24k 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.
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
2answers
4k 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 "...
7
votes
4answers
18k 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> &...
7
votes
1answer
604 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
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. ...
6
votes
2answers
4k 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: $...
6
votes
1answer
3k 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 ...
6
votes
2answers
5k 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?
5
votes
2answers
25k 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
4k 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
3answers
3k 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
877 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
2answers
1k 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
3answers
17k 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 ...
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 ...
4
votes
3answers
8k 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
1answer
2k 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
2answers
11k 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 ...
4
votes
3answers
6k 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
1k 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
8k 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.
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
60 views

Creating a csv file that contains product details magento 1

I am trying to create a csv, using script that contains the below product attributes. (id, title, description, link, image_link, price, availability) in Magento 1 Has anyone implemented it? Or Any ...
4
votes
1answer
1k 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
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
1answer
260 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
4answers
4k views

Magento 2: how can I remove columns in exported csv from order grid?

I want remove columns while exporting order grid data in magento 2. I google it but didn't find solution. Like I want to remove these fields from exported csv. Payment Method Total Refunded Customer ...
4
votes
0answers
722 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
5k views

Magento 2: Create downloadable CSV

I want to export table content in downloadable csv format. In magento 1.x it can be achieve by _prepareDownloadResponse() how can we achieve same in magento 2. Looks like this function is missing in ...
3
votes
1answer
2k 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
2answers
20k 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
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
4k 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
112 views

How to get particular column data from the CSV?

I have read the data from the CSV $data = $fileCsv->getData($file); foreach ($data as $row => $data) { if ($row > 0) { print_r($data); } } I have got the content only the ...
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
3answers
977 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
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
126 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
6k 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
2answers
3k views

Data showing in Grid but not in export file Magento2

I have created a custom report, Used below code in my ui_component listing file. <column name="custom_tax_code" class="Vendor\Module\Ui\Component\Listing\Column\Quantity"> <argument name="...

1
2 3 4 5
12