Questions tagged [magmi]

Magento Mass Importer (MAGMI) is an open source project to improve on the infamously poor speeds of Magento's default import tools.

The Magento Mass Importer (MAGMI) project's initial goal was to provide a product mass import script from CSV files that match the Magento dataflow CSV export format.

As explained in Project Origins page, the Magento dataflow was not an option when dealing with several thousands product catalogs.

The main project goal is to achieve dataflow like operations with a reasonable speed.

There are also various plugins available for the MAGMI script which allow for on-the-fly operations, including manipulation of the product data and creation of categories. Details at the Magmi Wiki.

For latest changes visit Github page.

344 questions
0
votes
2 answers

Magmi Not Importing When CSV Files Contains Commas

I have installed and made some successful product imports in to Magento using Magmi, but as soon as I try to import any data where the spreedsheet columns have commas [,] Magmi will not perform the import. For example when I save the data in this…
Jimnibob
  • 1
  • 3
0
votes
2 answers

Convert text formatted with whitespace to html

I have a csv file which I need to import on a php-based system - Magento to be specific. There is a field which contains the description of a product and is whitespace formatted for indentation as well as dashes (-) used for list items. I could use…
zarun
  • 910
  • 9
  • 26
0
votes
2 answers

Magmi Import SQL import, works on local server

I have been using Magmi for a long time, and had issues with it so far, but now I'm trying to do a CSV import with Magmi, and for some reason it throws this SQL error, and have no idea how to fix it. Magento: 1.8.1.0 PHP: 5.3.3-7+squeeze18 MySQL:…
dasmikko
  • 696
  • 2
  • 8
  • 29
0
votes
1 answer

Magmi on Magento 1.4.2CE visibility always catalog&search + error w/page_layout & options_container

I'm relatively new to Magmi but have had to mess with EDI and csv files on many different systems over the years... I have only been importing simple products with magmi for starters and have a couple of questions/problems At first all of my…
0
votes
1 answer

magmi Value Replacer not working properly

{{ ValueRemapper::use_csv('../../var/import/xyz1.csv')->map({item.Categories}) }} Xyz1.csv has following value Internal Use/Magmi Test Category;Fashion Appliances;Electronics/Others Electronics CAMERAS;Mobile Accessories/Other Now i am trying to…
Macki
  • 31
  • 1
  • 3
  • 8
0
votes
1 answer

Magmi delete attribute value

How do you delete a attribute value with magmi? I tried these cases and none worked
SinisterGlitch
  • 195
  • 3
  • 25
0
votes
1 answer

1 item, many configuration options

Example item ___________________________________________________ | ITEM | COLOR | SIZE | QTY | PRICE | SKU | =================================================== | Shirt | Black | S | 35 | $8.00 | ShirtBS | | Shirt | Black | M | 52…
Kender
  • 1,191
  • 3
  • 15
  • 34
0
votes
0 answers

Magmi CLI appears to run but no products imported

Like the title says, magmi cli appears to run (it pauses for a period of time and then returns to the prompt) but no products are imported. I can run the profile from the web interface and everything works as expected but the same profile with cli…
Gareth
  • 1
  • 1
0
votes
1 answer

Upload configurable product using magmi

I am trying to upload configurable product using magmi Here is my csv sku | attribute_set | type | category_ids | name | shoes_size | …
0
votes
1 answer

Magento html image import via Magmi?

Does anyone know how to import images from an html link using Magmi? Can you give show me a screen shot of how the links are suppose to work? I have tried on my end a couple different ways and can not get it to work. Below is a screen shot link of…
0
votes
1 answer

Magmi changing SKU for no apparent reason

Im making a import for a client using Magmi. and the weirdest thing is happening. Imagine a list of products by SKU sku1 sku2 sku3 when the import is finished it looks like this sku1 sku1 sku3 i have no idea why this is happening and why Magmi…
SinisterGlitch
  • 195
  • 3
  • 25
0
votes
1 answer

Magmi error when source column has "(" or ")" in header

I am using the Column Mapper to map columns from my source file to the respective system columns. I get an error when the source column header has a "(" or ")" in there. The error occurs within the magmi UI. Here is an example: Mapped columns list:…
shnozolla
  • 468
  • 10
  • 20
0
votes
1 answer

Magmi timing out

I am using Magmi to import my products into magento. The speed is fantastic, however, on larger imports, the import process stops when it gets to 118 seconds elapsed, every time +/- 1 second. I checked the php settings on my server the ones i think…
user2231688
  • 195
  • 1
  • 3
  • 15
0
votes
1 answer

magento magmi categories creation of the fly

I cannot create my products categories correctly on my magento store using magmi because my csv file is not compliant with magmi my csv header is this: Item Code,Price,Stock,Item Title,Category,Sub Category,Manufacturer,Part…
0
votes
4 answers

SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES) -

I am trying to import images using magmi. I am getting SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES) - error. I tried changing username and password for database.But I am unable to change, as I click save…
Mukesh
  • 7,630
  • 21
  • 105
  • 159