We’re rewarding the question askers & reputations are being recalculated! Read more.

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

How to add fake CSV column names to custom importexport models to make them validate on import?

I have created an importexport module for csv import for a custom model. This module is to support CSVs supplied from multiple sources, so are not all marked up the same. Generally, this is not a ...
1
vote
0answers
1k views

products upload with csv magento 1.9.0.1 [closed]

I am trying to upload products on magento 1.9.0.1 with CSV file. I added one product directly in magento then downloaded CSV file for adding more products on it. When I import products they do show ...
1
vote
0answers
901 views

Change order status after successful FTP export [closed]

I am using a Cron job to export orders to a third party warehouse system every two hours via FTP which has been working fine. The problem is I need to change the order status once the FTP upload has ...
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['...
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 ...
0
votes
1answer
2k views

Dataflow Profiles

Currently im pulling my hair out trying to get Magento to import a csv file. I have followed the following steps. Exported csv from Magento to get the layout 100% correct. Opened it in OpenOffice as ...
0
votes
1answer
4k views

Importing Products in csv file - empty columns

I am currently adding all my products into a csv file ready to import into my store. To get the template i exported my existing products and am using that csv as the template which contains every ...
4
votes
2answers
983 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 ...
3
votes
1answer
211 views

static attribute not handled by csv importer

I created a static product attribute with corresponding source model: /* @var $installer Mage_Catalog_Model_Resource_Setup */ $installer = $this; $installer->startSetup(); $installer->getConnection()-...
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 ...
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
638 views

Import products via TXT files

Is there a way to import product information via TXT files into Magento? Supplier has only TXT files and no CSV available. I have the impression that MAGMI does not support TXT file type.
2
votes
2answers
2k views

Parsing a CSV file for custom options script

First off I'm new to Magento, so please forgive me for my ignorance. I would like to read from a CSV file that has item_id, sku, and the custom options data so I can use it in a foreach loop. I'm ...
1
vote
1answer
2k views

what is the maximum length for meta_keyword, meta_description and meta_title

While Uploading CSV, There are some constraints that we have to follow, Like lengths of the attributes : Please Provide the length of following attributes: "meta_keyword" "meta_title" "...
0
votes
1answer
3k views

Issue when programmatically creating custom product options

I'm working on a product upload custom module. For that I want to create custom options programatically. I put following code in model. But it always add the custom option to the last product only. I ...
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 ...
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 ...
0
votes
1answer
1k views

Table Rate - Item vs Destination

A quick question with regards to the csv which needs to be created for implementing these rules. I have a basic rule where for example shipping to Belgium for one item starts at £3.00 Then for every ...
0
votes
1answer
709 views

Export wishlist as CSV

A customer of us has a special need for his site.He wants each customer to be able to download his wishlist as CSV. Now my question is: I know how to do that on the back-end for my module using in ...
3
votes
1answer
360 views

Adding the same product image path to multiple products through csv import issue

I am trying to add products by duplicating them in a CSV file. It seems to work fine but when I update the product image path with the same path to multiple products it doesn't seem to update. When ...
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 ...
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 ...
0
votes
1answer
207 views

Is there a way to insert products through the spread sheet programmatically?

Is there a way to send products into magento or edit them in any way programmatically without going through the API. I understand one can load products and edit products by putting them in a spread ...
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 ...
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 ...
2
votes
2answers
3k views

Magmi: On the fly category creator/importer root catalog [closed]

We are using a multistore deployment. In the csv we have as follows: (mind you these are not literal, just examples) store: using the store code for the store view, e.g.: substore1_en websites: ...
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 ...
1
vote
0answers
495 views

Importing products - process lasts forever [closed]

I have two Magento 1.7.0.2 installations: one is on a shared hosting installed using cPanel and the other is a local install I've done on my Ubuntu Server 12.04 machine. Since the one on the shared ...
1
vote
2answers
2k views

CSV import and auto create manufacturers

I have created a script which generates CSV file. I have one problem. The Manufacturers are coming from the data are not in Magento and practically cannot be created in advance. Is there any way to ...
0
votes
1answer
5k views

Order CSV Export - what fields does it export?

I am exporting orders Sales > Orders to CSV. The problem is, I can't see which fields are actually exported. If anyone has any insight, I would much appreciate it.
1
vote
1answer
920 views

Bulk customer upload?

I've been searching a kind of extension to upload customers in a bulk but I didn't find anything. Do you have any system to upload a lot of customers via csv, xls.. etc? Or there's an option that I ...
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 ...
2
votes
2answers
2k views

Magmi image import sets majority of product images, but not all [closed]

I've been using Magmi to do a mass import of both product data and then going over the product data to reference product images via SKU. I've been able to get Magmi to import product data without ...
1
vote
3answers
715 views

How do I change name of 45000+ products via single import?

I am working on one Magento Commerce store and want to change name of 45000+ products via single import. There are too many products on website with all CAPITAL product name. This is creating big ...
1
vote
1answer
274 views

Import csv without column names

I need to import articles from a non magento csv file which does not contain any column names. How can I tell the import that product name is in column 1? Anyway todo this without changing the csv ...
2
votes
3answers
2k views

bulk apply (or csv import) fixed product tax

I have a csv file with more than 400 items to import. All the attributes are imported fine except for the fixed product tax (that is the same for all products). I tried to manually create one on a ...
2
votes
1answer
2k views

magento import not working for products set with visibility of 1 (not visible individually)

I have a spreadsheet which I use to import my simple products. Originally, I only had products on there which had their visibility set to 1 (not visible individually) - as they were meant to be ...
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 ...