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
41 views

how to read nth number of row in csv magento

yesterday i was working read data from csv in magento. I know that i can read date from csv in magento using this function. Varien_File_Csv() but what i want to know is how to read a fix number of ...
0
votes
1answer
108 views

Magento2: Can I import product attributes in a CSV file to edit their Storefront Property values?

Can I import product attributes in a CSV file to edit their Storefront Property values?
0
votes
1answer
190 views

Export CSV in Shipping Rates doesn't work

I have Magento 2.1.1 in production mode. I go to: Stores -> Configuration -> Sales -> Shipping Methods. When I try to export the CSV example to upload the rathes, the system after 10 seconds ...
0
votes
1answer
117 views

multiple category_ids breaking in CSV

If you have 2 categories a product needs to be in and the category is over 100 - you get a value that looks like this "100,101" The problem is excel automatically reads this as a number and you cant ...
0
votes
0answers
203 views

Magento Product Image Import selection store-wise not working

I have installed Magento CE-1.9.2.4 in my local system, and created two stores namely "personal"(default) and "business". Now I want to import a product's images in such a way that both store should ...
0
votes
1answer
245 views

Magento find out from which csv file are the translations loaded [duplicate]

I have Magento-1.9.2.4 ce installed in one of my client's site along with module Scommerce CashBack. Now when I place an order which has cashback amount applied to it, I want to translate the label ...
0
votes
1answer
760 views

Exporting Full Custom Grid Data

Trying to export the full grid data of a custom module. The function itself works but there's a limit of 20 (well a limit of how many rows are visible on the page). I need to export the full data from ...
0
votes
1answer
345 views

Uploading Images labels

I'm uploading images labels using a CSV file contains the following columns (store,sku,image_label,small_image_label,thumbnail_label) and that's worked perfectly. The problem is when i have a product ...
0
votes
0answers
3k views

CSV import: Problem with comma as multiple value separator (Magento 2)

I have to import products with CSV Products Import (System->Import) in Magento 2. But I have problems with the Multiple value separator. If I choose the standard separator comma, it doesn't import ...
0
votes
1answer
439 views

after configurable product being imported, on editing it shows attributes to make configurable

I have successfully imported a configurable product with all it's simple products. But on editing the configurable product from backend, it shows global attributes to make configurable product like ...
0
votes
1answer
448 views

Magento Product Images upload not working in my code

I have below code which should update product images in Magento using product sku from csv file. In my csv file, there are two columns, First column in Product SKU and second with Image Name. <?...
0
votes
3answers
722 views

How do I open a csv file in the root of my module directory?

I've been writing a rather complicated module as of late. One of the steps I need to do is pre-populate one of the models with all of the data it needs to work right. This data is slowly replaced ...
0
votes
2answers
2k views

Magento2: Need help to create custom export

I'm creating a custom module(multi-vendor) where i need to create one feature where admin can export the product details(CSV) data along with vendor details (which is assigned to some specific product)...
0
votes
4answers
744 views

Export Products on a Category

Is there a way that I can export all products on a certain category via CSV or excel file?
0
votes
2answers
158 views

Can't translate a line

I'd like to translate a line in checkout > payment information but I dont' find the CSV file. I tried to add the translation on mage_sales.csv but it didn't work. Can you help me?
0
votes
2answers
717 views

Error: Export orders to CSV - Correlation Name

I am getting the following error when trying to export orders to CSV but am none the wiser on how to fix it! EDIT: I am using an observer to add a Country column please see my module below, how can I ...
0
votes
1answer
456 views

Magento 1.9 stops and doesn't import entire CSV. And don't set stock

I'm trying to import a huge CSV with simples and configurable products to Magento 1.9.2.3 but it import only first 80 records/products. And without set product qty and is_in_stock columns. CSV runs ...
0
votes
1answer
355 views

Export CSV NOT showing ALL Prods - using Magento 1.9.2.2

I'm using Magento 1.9.2.2. When I do a Product Export CSV, NOT all the Products are exported to CSV. However, when use the Data Profile > Export All Products, the output CSV is correct. I prefer ...
0
votes
2answers
766 views

Error while importing a csv file in the admin

My project had an extension called webshopapps product matrix Which was copied from another project and had been configured . But now when I replace it with the new extension by placing its files ...
0
votes
1answer
101 views

Matching customer and product ID's to imported data

So, I am setting up a Magento store for a client, who currently has a few thousand products, customers and orders based in a Microsoft Access database and a basic web front end. Now I have access the ...
0
votes
1answer
74 views

CSV Import: editing configurable childs not working

I want to change the price of associated simple product for a configurable product. I want to do it by CSV import. this is my csv file. sku,price,_super_products_sku,_super_attribute_code,...
0
votes
1answer
387 views

Truncating old log tables giving error

we bought magento extension for uploading the products through excel sheet. we are uploading Products using csv file. now uploading speed is too much less. I am trying this query to increase upload ...
0
votes
0answers
128 views

Batch insert products (import multiple products at once)

I have an excel file with 125.125 rows in it. I loop through all the rows and save/update the products in my magento website. Now the problem is that I save the product every time I loop through a ...
0
votes
1answer
141 views

CSV “Pick slip” from Sales Order Grid

I would like to export placed orders (regardless of status) including products to a .CSV file. I want one row describing the order and one row for each product in the order. I want the output to be ...
0
votes
0answers
848 views

Product import hangs

I'm trying to import more than 1000 products. And import takes like 10s or less and hangs, imports like 10 products.. checked system.log only found warnings like ERR (3): Notice: Undefined index: ...
0
votes
0answers
43 views

How to Import bulk products (60000+) to magento? [duplicate]

I am having a list of 60000 products and I want to import them to magento website using csv. I have created the csv file by exporting a fake product from magento and then inserted the required data to ...
0
votes
0answers
3k views

Can not find required columns: sku

I'm trying a .csv import with the normal import function of Magento (not the dataflow). I first exported all the products from my store and used that sheet as a template for mine. When I try to ...
0
votes
0answers
50 views

Updating Customer records

I was wondering if the CSV import would update customer records or does it just create new ones? As last time i did an import using dataprofiles using an email address and postcode i already had on ...
0
votes
1answer
368 views

Which CSV-file to edit for correct translation for item TAX

I'm changing Magento invoice (translation & coloring) and everything went well i.e. Mage_tax.csv contains 'Grand Total (Incl. Tax)' and I can translate it into Ducth. But I can locate the correct ...
0
votes
1answer
345 views

Create XLS File with Multiple Sheets

I found this class in Varien Varien_Convert_Parser_Xml_Excel however, I couldn't find any source on how to create an XLS file with multiple sheets in it. Note that it needs to be XLS not CSV.
0
votes
0answers
199 views

Magento Export CSV: repeated columns?

I have a csv produced with DataFlow->export all products. Some columns seem to be repeated. Does anyone know the difference between the following sets of column names, all of which are found in the ...
0
votes
0answers
863 views

Add barcodes to CSV list

I have 7000 products ready to sell, however I'm going to link it up to a POS system so I can sell instore and online. Therefore I need to assign all my internal stock codes a barcode. What's the ...
0
votes
2answers
138 views

csv import of images does not work reliably

I am trying to import products with images into magento via a csv file. However, most of the times, the images are not imported, neither in the frontend nor the backend. I use columns "image", "...
0
votes
1answer
312 views

Dataprofiles fields mapping how to set base, thumbnail, small image via CSV file

I am trying to import and assign images i.e base image, small, thumbnailbut i am getting errors and my images are not assigning to the products. any help??
0
votes
1answer
953 views

Product Update with Url_Key & Store_Id Attribute Already Exists error in csv import with magento EE [closed]

When i am update product description in my magento enterprise edition, i get the url_key & store_id already exists error in csv import.
0
votes
1answer
845 views

Image Update via CSV import

I am running Magento 1.8.1.0 Community and have over 700 simple products that need images assigned to them. These images are already assigned and uploaded to the configurable products. I have done a ...
0
votes
1answer
32 views

Problems Importing Product CSV file

I have a big issue with reading my csv file. When I do an export and open it in Google doc or Excel the price and qty not show correct. Magento 2.2.6 https://docs.google.com/spreadsheets/d/...
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
votes
1answer
436 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 ...
-1
votes
1answer
762 views

How can i upload bulk images in magento [duplicate]

How can i upload bulk images with magento using import tool or Dataflow.
-1
votes
1answer
897 views

Import extension for category

Is there an extension which allows me to import the meta description for categories? Using version 1.9 community edition.