Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [csv]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
296 views

Update Inventory and prices in Magento using a CSV

We would like to update inventory quantities and prices in our Magento store from our ERP system. We can generate CSV file in our ERP to be imported into Magento. We need CSV file format layout. ...
1
vote
0answers
89 views

How to skip some column to write csv data

I would like to skip some column to write data in CSV when it generate. Here is my code to generate CSV in magento. it would be start writing from column no 20 for first row only then continue with ...
-1
votes
1answer
433 views

Custom product import script break after 1 product import!

I am using custom product import script to import the simp0le products. I have uploaded almost 40k products on the website. But now, only 1 product import and then the script stop. What is the wrong ...
0
votes
0answers
135 views

Getting Please fix errors and re-upload file while csv product import Magento ver. 1.9.2.1

I am getting below error while product import from admin. As there is no particular error (mostly error in csv formats) i am not able to debug. File permission of media folder In Export of Products ...
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 ...
0
votes
1answer
112 views

Products stock status change after csv import

For some reason my out-of-stock products reappear as 'in stock' whenever I update the product by a csv import. Even if I import a single column; the 'sku' column, the affected products suddenly ...
0
votes
3answers
679 views

Magento 2 - product image in product description page is incorrect

I imported csv file to upload product image in magento 2. The upload image is displaying only in category list page and shopping cart page. In product description page a different image from uploaded ...
1
vote
0answers
21 views

Can not find products after uploading test .csv

i have successfully uploaded a test csv but the product i am using to test does not exist in the admin panel anywhere? Any known problems like this. I am still learning so sorry if the answer 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()-&...
2
votes
4answers
3k views

How to get product price after a discount was applied

I tried to get the product price after a catalog price rules was applied and i can't. The code that i use to do this: //load product by id $product = Mage::getModel('catalog/product')->load($...
0
votes
1answer
107 views

when i upload CSV, it is display 0 error. but while import, it gives error as Cannot add or update a child row: a foreign key constraint fails

When I upload CSV file it gives 0 error. After this I click on import button. It gives following error: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a ...
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'=&...
1
vote
3answers
693 views

How Can I Create Custom Order Using CSV with multiple Products along with Custom Price?

Many times I did the manual order for the customer, some order consists 100's of products, how can I create custom order by using CSV? Is possible import order by CSV? or is possible to import order ...
1
vote
1answer
859 views

Magento 1.9 - Catalog -> Manage Products not Exporting All Products To CSV

I am having an issue where exporting products under Catalog -> Manage Products in the admin panel is not exporting the entire product collection to a CSV. It is only exporting a small number of ...
0
votes
2answers
2k views

Import Multiple Category with Product CSV

I am trying to import product through Magento 2 Admin Panel using CSV file. My CSV file looks like below I have categories like All Category/Bikes, Scooters & Ride-Ons and All Category/Fashion ...
1
vote
0answers
66 views

Magento customer import not defined issue

I want to import customers to magento via import/export profile my csv look like this: ID,Name,Company,Email,Group,Telephone,ZIP,Country,State/Province,Customer Since,Website,Controle:,Status: 1163,...
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 ...
2
votes
0answers
642 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. ...
0
votes
1answer
356 views

Multiple Inventory slots for Different warehouses

I have found a great script that allows for quick inventory updating via a php script, and it does work well. I am able to just go by SKU, quantity, and set each as is_in_stock. My question then ...
1
vote
2answers
612 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.
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 ...
0
votes
1answer
119 views

How to change the product image position using CSV?

I'm trying to update Product's image position using CSV file. I've already uploaded images in Products. So how to change already inserted product image position using CSV file?
1
vote
1answer
604 views

How to update data if product sku already available in magento using custom script for product import?

I have created custom import script for simple product csv import in magento. It is working fine for the newly products. But I want to update the products if sku already exists. How can I achieve ...
0
votes
0answers
83 views

How to translate sells emails (Your order confirmation ) Magento 2.1.2?

so I'm having trouble to translate the order confirmation email template. the problem is with the lower part where the totals are shown see the image below: This is the Totals.php where it's declared,...
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/ ...
0
votes
1answer
3k views

Magento 2 : How to Import Color and Size Swatch Attributes Using CSV

How to import color and size swatch attributes using csv.
2
votes
3answers
2k views

magento 2 images on category page not visible

If I import products with csv the image is not visibly at the category page. If I go to the product page the image is showing. How is that possible. base, thumbnail, small image and swatch are fine. ...
0
votes
1answer
106 views

Product Area not showing after CSV Product Upload Issue

I have ran into a very strange issue with Magento, which I am hoping someone here can help with. Yesterday, we could add products & everything worked fine on the backend. The client ran a product ...
0
votes
1answer
248 views

MAGMI_RUN unable to find .CSV file

MAGMI has been successfully set up on my Magento environment (and Magento was set up via MS's web platform installer and is kicked off via MS's Webmatrix), and I can use it quite happily to import ...
1
vote
0answers
284 views

How Can I Bulk Import Image Label By CSV

I need to import image label of my images, how can i do it by csv,
0
votes
1answer
65 views

Simple text translation depending on store view

I am creating a simple module that displays a date. I need the days (Monday, Tuesday, etc.) to be translated in the store view language. I've gotten lost in all the different ways that this could be ...
2
votes
0answers
443 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 ...
1
vote
1answer
473 views

Magento export mysql result to csv

I am trying to run two mysql queries and export the results into a CSV. My issue is the second query I have is being written to a new row instead of just onto the same rows that the result from the ...
1
vote
0answers
28 views

Apostrophe inside magepage.csv makes SyntaxError

I'm confronting 2 Magento eCommerce, one is 1.9.2.1 and the other 1.9.3.2, they both have this translation inside Mage_Page.csv "- Use the %s, %s buttons to select year","- Usa i bottoni %s, %s per ...
3
votes
4answers
2k 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 ...
0
votes
1answer
142 views

How to change the CSV column position

Due to some reason client asked me to change the position of csv columns. They need necessary fields at starting of csv and blank fields(mostly) at end of csv so that they can easily fill the csv ...
1
vote
1answer
589 views

Trying to get CloudFront to work with Magento 2

My problem is that I upload all my products using the import function on Magento, it is easier to upload products in bulk using a CSV file in this way. I have a field for images, and I upload all my ...
1
vote
1answer
492 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
828 views

How to upload Multiple Images Of same product using CSV FIle in magento 2.0?

I am Trying to upload Multiple image of same product in magento 2 using csv file. I am adding one image each on base_image, small_image, and thumbnail_image and other remaining images on ...
1
vote
1answer
96 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
0answers
115 views

export enterprise url redirects

I am trying to export all my URL redirects from my Enterprise Magento instance. Is there a way to do this in the Admin or a SQL statement I can use to export it as a CSV? I am unable to find it in the ...
0
votes
1answer
312 views

problem for import with pimgento

I have this error when i try to import my categorie.csv in magento with the module pimgento (in the menu import pim data) General error: 1290 The MySQL server is running with the --secure-file-...
0
votes
1answer
3k views

programatically import csv - magento 2

I have a bpmn tool, it will generate CSV, that CSV contains single product. I need to import that csv file programatically. Already magento admin have that feature. please can anyone point key code ...
1
vote
0answers
175 views

Magento 2 xml/csv convert

I am trying to figure out how that an automatic feed (csv or xml) works within Magento 2. Does anyone know a page with information on how to do so? I have the xml product feed or the CSV product ...
1
vote
1answer
80 views

COD only for a particular city in a country how to write the csv file in magento 1.9 [closed]

I am using magento 1.9. And I want to set no cod for a country except for a city/state in that country.I'm stuck with creating the csv file. Can anyone help? Thanks.
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 ...
0
votes
1answer
561 views

Translate store language label in magento frontend

I wish to translate store language switcher label dropdown from english to simplified chinese. PFA for thes same.
0
votes
1answer
58 views

Export customers to CSV with Store Name

I'm using this code to export customers to CSV. I would like to add an extra column that is the STORE NAME, and not the ID. "store_id" works but only shows the ID (a number). I would like to show the ...
0
votes
2answers
50 views

Proper steps for translating from CSV file in magento

I want to translate some text using CSV file by going through following steps. Created CSV file named "Mynamspace_Mymodule.csv" in app/locale/en_US/ and feeded it with my translations like, "text to ...
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(...