Stack Overflow
Stack Overflow

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
1
vote
1 answer

Magmi - Cleared Catalog/Categories - Sqlstate Invalid Parameter on Import

I have been using magmi to import products and related categories / images into magento. Everything was setup and working correctly. I cleared Magento catalog and categories using the Magmi advanced utility and now on import i receive the following…
Kintra
  • 11
  • 1
1
vote
1 answer

Magmi Price Change for Magento

I am using UnderstandingE's version of Magmi. I use Magmi to automatically import a CSV file from our supplier. The supplier's CSV has a column that says the price that we will pay to our supplier - "wholesale_price." But that is not the price that…
Boba
  • 11
  • 1
1
vote
0 answers

Magmi all records found but only a few imported

I am facing a weird behavior using magmi. as you can see in the image, Magmi sql data-source processes 93 sku as it says in Global Stats but only 1/1 sku is imported into magento as it says in run-time infos. Additionally, that imported record was…
s_h
  • 1,476
  • 2
  • 27
  • 61
1
vote
2 answers

Update products with unique identifier different from sku

I would like to update magento products with Magmi. The import csv file (with products to be updated) contains a column with unique id values but they are different from the sku values in database. Sku identifiers aren't available in this import csv…
user7786
  • 31
  • 2
1
vote
3 answers

Which magento table contains product url slug

The problem I'm having is that I import products with Magmi (magento product import open source solution), but I want to change the url slug. I need to know which table in magento database contains slug so that I could maybe feed it somehow…
user3150977
  • 33
  • 1
  • 7
1
vote
1 answer

Magento deleted items and addresses shown on new invoice?

I used Magmi to import and delete items, and today a customer made a purchase of one single item and guess what : His name was changed to Peter Hoang(the default magento customer name), also the address was changed and another 4 items were added to…
Nikos Zeolini
  • 21
  • 3
1
vote
2 answers

Magmi: Import "Not Logged In" Pricing

I am trying to use magmi to import group and tier pricing for the not logged in group and am not sure what the format is for my csv headers or where to find it. I have successfully used group and tier price imports with magmi on all…
njm5785
  • 135
  • 1
  • 10
1
vote
1 answer

recover sort order/position values using magmi with multiple website/store/storeviews

I've been using Magmi with great success, creating and updating our magento products on a daily basis. Our production retail site generally uses the default/admin values for store. When I make new categories and populate them I generally use the…
Party Supply Jake
  • 13
  • 3
1
vote
1 answer

Magmi Datapump set stock to 0 and is_in_stock to 0

I'm having a little trouble with the Magmi Datapump API and setting a stock to zero (and out of stock). I am able to update stock, for example if I send this to ingest, it updates and puts it in stock: array ( 'sku' => '1234', 'qty' => 77, …
jayjay06
  • 13
  • 3
1
vote
2 answers

How to import category name in magmi in magento

HI i am using magmi to import data below is my data structure sku;name;attribute_set;categories "100";"Product 1";"Default";"SHOP" "101";"Product 2";"Default";"SHOP/About Us" in this it is working fine but it is not importing category name. Please…
Rohit Goel
  • 3,396
  • 8
  • 56
  • 107
1
vote
0 answers

Magmi - importing html description

I am using magmi datapump (Magmi version 0.7.18) to import products into Magento 1.7 from an xml feed, and I have a problem with product descriptions. The product descriptions in the xml feed contain html tags (example below)
Clain Alexandru
  • 135
  • 2
  • 9
1
vote
0 answers

Magmi is not updating products

I have installed Magmi on a store running Magento 1.7 It works brilliantly to import the products with my CSV. I then alter the price values in the same CVS, re-upload and run Magmi to update but nothing changes in the Magneto Products list. I have…
webpod
  • 35
  • 7
1
vote
2 answers

Is there a way to parse the data in Magmi before storing in DB

Is there in Magmi a way to parse on the fly the data from a column before to save in the DB. Just an example. Let's say I have the Images column with a list of images with a kind of "prefix". this way: "IMG: myimage.png". I wanna to remove all the…
Claudio Ferraro
  • 4,551
  • 6
  • 43
  • 78
1
vote
3 answers

Magmi import error

trying out the Magmi importer. Saved a file under the /var/import directory, which is found by Magmi and displayed in the dropdown of the file to import section, but when I run the import process I get the error message "NO FILE".
user2999370
  • 11
  • 1
  • 2
1
vote
1 answer

magento create a csv file with product sku and categories for use witth magmi

I need to generate a csv file with product sku and the category tree, so I can later import it with Magmi On the fly category creator/importer plugin. I need to get something like this: sku;categories "100";"My Products/Sample Products/Sample…
igrossiter
  • 744
  • 1
  • 12
  • 26
1 2 3
…
22 23