Questions tagged [csv]

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

Filter by
Sorted by
Tagged with
1
vote
2answers
621 views

Error in Importing CSV in Magento 2

I am getting error like below while I am trying to import product as CSV in Magento 2 Admin Panel. My Import screen is like below. UPDATE I am getting new error now.
1
vote
1answer
97 views

How we can extend Varien_File_Csv class in magento?

I want to open CSV file in a+ mode for append content. I open Varien_File_Csv class and check for that but I did not found any option for open file in a+ mode.
1
vote
2answers
87 views

Custom Product Export proper format

I used below controller to export Product Information. It export But my problem is all value come only header. How to display proper format public function exportmeAction(){ try{ $...
1
vote
3answers
939 views

Css and Js are not loaded after install fresh Magento 2.1.3

I have installed Magento 2.1.3 after installation I go at admin but the admin link are not seeing proper I think some CSS and JS are missing , After I run deploy static command and re index and ...
1
vote
1answer
923 views

unable to update Status of product from csv

When I change the status field of product from enable to disable or vice versa via updating through csv using data flow profile, it is not updating value of status, simply leaves status of a product ...
1
vote
1answer
435 views

magento2: table rates csv file with ISO-3166-2-Code shows issue

In the column "Region/State" im using ISO-3166-2-Codes for Germany (https://de.wikipedia.org/wiki/ISO_3166-2:DE) , but Magento is showing me this Message: How can I solve this ? - Update: In the ...
1
vote
1answer
2k views

Magento 2: Import with required attributes

If I want to import products via csv-file I need to have all the required attributes as columns in my csv-file right? Can anyone tell me what the attributes 'price_type', 'price_view','shipment_type',...
1
vote
1answer
2k views

Magento 2 : get csv file download in frontend based on click of button

How can i download csv file in magento 2 using below code is from controller, public function execute(){ $resultRedirect = $this->resultFactory->create(ResultFactory::TYPE_REDIRECT); $...
1
vote
2answers
131 views

CSV Contain No In formation

I download Order information But in that csv no information what mistake i made How to download csv with data public function downloadAction(){ $orderId = $this->getRequest()->getParam('id'); ...
1
vote
3answers
331 views

Update CSV using Varien_File_Csv();

I am using Varien_File_Csv to save CSV data. $csv = new Varien_File_Csv(); $csv->saveData($fileName, $data); This approach always rewrites the CSV output file. Is there any way to use append ...
1
vote
1answer
73 views

Short Description Limitation Error When Importing CSV File

I Have created CSV file with all attributes particularly in 'short_description' field, I added value in table format as below > <table cellspacing=""0"" cellpadding=""0""> <col width="...
1
vote
2answers
4k views

CSV Import with multiple categories and commas in category names

I have a CSV of products to import and each product has multiple categories, some with commas in the category name. To import a product and asign multiple categories, I would usually add a CSV column ...
1
vote
1answer
3k views

Invalid config field backend model

I'm having some trouble understanding why magento is throwing this exception when I attempt to access my backend. This appears, at least to my eyes, to be configured correctly. Any ideas? Below is ...
1
vote
2answers
115 views

Imported CSV file returning no values

I'm creating a module that will allow me to upload some data from a csv file to our database. However, this file doesn't seem to be returning anything, any idea why? public function uploadData(...
1
vote
1answer
406 views

how to import new products or update existing stock from csv file [closed]

I've three types of products in my store. Each Grouped product holds a simple product and a configurable product and configurable product in grouped product hold three simple products. Now I want to ...
1
vote
1answer
369 views

Blue Jalappeno Order Export - How do you modify the csv export file?

(I am not 100% sure that this is the extension but I think so - it is in Community/Webshopapps/ordermanager and looks like the most likely extension listed at http://www.magentocommerce.com/magento-...
1
vote
1answer
72 views

Magento import price from 10 CSV to 1000 in magento

When I import a CSV file and set the price to 5,95(euros) the products import without a problem except for one. The price which was 5,95 or 12,95 turned into 595,00 or 1.295,00. Does anyone have ...
1
vote
1answer
2k views

Exported catalog not importing to Magento Community

We are using HostGator and they have Magento Community among their Quick Installs. I used their install method, had issues from the start. Nothing they did fixed anything. I had created all of our ...
1
vote
1answer
2k views

Import products for store view

I try to translate my product names in the new English store view and import changes, but when I import the csv, it override the default data. sku,_store,name 31006,default,Небе 31006,en,Sky After ...
1
vote
1answer
32 views

Magento 1.9 How to change CSV Separator

I want to export records in CSV files. All data are Separated with , I want it be Separated by ;
1
vote
2answers
113 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
vote
1answer
50 views

Magento 2 : Import product with custom csv

I have a custom product csv file https://drive.google.com/file/d/1f9t4REhn8-Ant58zRB6S0yRx1Rh1PctX/view?usp=sharing how can I import it in Magento 2. Do you have any idea?
1
vote
1answer
63 views

Custom Export Report issue in Magento 2

I need to export the custom grid to the csv file. I have used the below code in my listing.xml file. <exportButton class="Magento\Ui\Component\ExportButton"> <argument name="data" ...
1
vote
1answer
44 views

Magento2 - Failed to import products

We are trying to import products into Magento 2.2.5, but whenever we run the import, we get the following error: Imported resource (image) could not be downloaded from external resource due to ...
1
vote
1answer
219 views

How to translate escapehtml (Filter by)

Hello i cant to translate this one http://prntscr.com/kt3mrb my code is <div class="block-content filter-content"> <?= $block->getChildHtml('state') ?> <?php if ($...
1
vote
1answer
433 views

How to change Magento2 export product MULTI VALUE SEPARATOR?

In product import, there is interface input box to select multi value separator which is comma. But in product export, we cannot select separator so it will mix up with the field separator.
1
vote
2answers
282 views

How to import the CMS content in CSV file

I want to import the CMS content in to .csv file. So can anyone has used any tool to import the CMS content.
1
vote
1answer
1k views

Magento 2 CSV bulk upload product for multi website with a different price

Need to upload CSV for multi website e.g "base,us" base will have £100.00 us will have $110.00 I have a sample where I change price from admin But when I export CSV I only see the price for the ...
1
vote
1answer
46 views

Magmi Special charactars not allowing to upload

I am facing an issue when uploading Products with Magmi only when excel sheet contains special charactars so, I followed link & tried saving with `Libre Office Calc with UTF-8', but that didn't ...
1
vote
1answer
45 views

Can I set different titles from names of upsell products?

Can I set alternative names in upsell products list? I would like to set an attribute "upsell_name" in CSV import so labels in red circles would be altered. For example for product "Long name ...
1
vote
1answer
81 views

Custom Product Export description space

I export Custom csv to the product public function exportmeAction(){ try{ $products = Mage::getModel("catalog/product")->getCollection(); $products->addAttributeToSelect(...
1
vote
3answers
283 views

Product Export Show Error

How to download csv in my local system....? controller.php public function exportmeAction(){ try{ $products = Mage::getModel("catalog/product")->getCollection(); $products-&...
1
vote
1answer
522 views

How to export store's csv that Excel will read properly?

In Sales > Orders when I export csv and open it in excel some characters are not encoded properly. e.g: ü is exported as: ü etc. Do suggest some solution to this problem. Thanks
1
vote
1answer
1k views

Shipping rate depending on the source and destination in magento 2

I need to set special shipping cost for the transactions between hubs(Riyadh, Jeddah & Dammam). And between Hubs and Substations too. I don't know how to write the csv file. Can anyone help?
1
vote
1answer
370 views

Magento 2: language pack not working properly after .csv file was edited

I installed this language pack https://github.com/splendidinternet/Magento2_German_LocalePack_de_DE. Everything worked fine. Then I edited the following line in the magento-path\app\i18n\splendid\...
1
vote
3answers
3k views

Magento 2 Programmatically update attribute fields from csv

I had a custom script for 1.9 that did this but it does not work on 2.0. Could someone provide any help or pointers to help get this working. Once a day I would like the script to update the magento ...
1
vote
1answer
1k views

Magento 2 category export to CSV file

I would like to export created Magento 2 categories to CSV file and create upgrade script that imports csv file to Magento 2 just like sample data csv file.
1
vote
1answer
124 views

How to import images through csv? [duplicate]

I have uploaded 2000 simple products through csv just now. But i didnt include images. How we can upload images at a time through csv?
1
vote
1answer
71 views

How to import image from filesystem url instead of /media/import?

I am new to magento, I have around 8000 Products have to import them through CSV.. but the images are in the filesystem and the other user who has access to magento magento with limited permission ...
1
vote
1answer
116 views

Solution needed for bulk import Magento CSV

For a client i need a solution to import 10.000 products (daily). He gets a CSV or XML (both available) through FTP on a daily base. The CSV file has custom headers. There a no Magento default row ...
1
vote
1answer
549 views

Inline Translation Not Working

Went to try and do some inline translations for a german store view I set up. I made a french store view at the same time. While new to inline translations, I translated a block of text in the german ...
1
vote
2answers
466 views

Importing product videos

We have thousands of products with videos to move from the old shop system and we need a way to import videos to Magento. Is there some nice product video extension that would allow to import via csv? ...
1
vote
2answers
1k views

How do I export gallery images using dataflow profiles onto different columns or otherwise

Hi I'm trying to do a dataflow profile in magento that has all the specs I need. However I can't separate the images out onto different columns of the csv or by a different type of delimiter within ...
1
vote
1answer
2k views

Export CSV file from order grid

I wanna export CSV from sales -> orders grid with only selected lines and not all commands like with the default button. If there's a solution for that ? Thank you for advance
1
vote
1answer
201 views

sort data by a column in getCsvFile()

i am using this following code to export my grid: /** * Export order grid to CSV format */ public function exportCsvAction() { $fileName = 'orders.csv'; $grid = $this->getLayout()-&...
1
vote
1answer
571 views

Magento Import Problem For same csv

Hello I am trying to upload product attribute value for french store. but some of csv row not able to execute and giving Error "Skipping import row, required field "sku" is not defined.". For getting ...
1
vote
1answer
706 views

Magento CSV Product Import Set Parent Category URL Key for use on Catalog list Category page

-- Update -- I think the issue is in the category list view. It generates the product link to the product, for the page, in a loop. I have it getting the product categories, and using that to build ...
1
vote
1answer
2k views

Magento & fputcsv strange empty row at beginning of file

I'm writing some info to a .csv file in Magento: public function batch_update_attributeAction(){ $attribute_id = $_GET['attribute_id']; $table_name = $_GET['table_name']; $input = $_GET['...
1
vote
1answer
211 views

I cannot see newly uploaded products in “Manage Products” in the admin

I uploaded around 100 new products by CSV but cannot see them in "Manage Products" in the admin (having no filters on the search). Strangely I can see them in the tables in the database and when I ...
1
vote
2answers
2k views

Can't get value from attribute “eancode”

I want to export some orders from Magento 1.7, but I'm stuck on 1 thing. I have an attribute in Magento, named 'eancode'. I want to put the eancode from every product in the export, but it shows a ...