magento imported products with magmi are not visible on the website

开发者_开发技巧

I have a CSV file and it takes ages to import it with magento standard interface, import is ok. I tried to use open source solution called "Magmi" which imports the same file in seconds when magento takes days. The problem is that if the file is imported with magmi, products are not visible on the website, even though they show in admin panel. Does somebody know the CSV structure (obligatory fields) for a successful Magmi import to happen?

---

You need to reindex (System -> Index Management) after importing with magmi: not sure exactly which indexes are required, one I know for sure is Product Flat Data, even if you don't use the flat catalog.
As for the csv structure, export all products to have an example.

---

magmi automatically indexes "Category Products" (catalog_category_product) and "Catalog URL Rewrites" (catalog_url), but only if you use the "on the fly" indexer plugin. However, in order for the products to show up on the frontend, you need to run the "product price" indexer (catalog_product_price). It's one of the quickest indexes, so a full reindex is overkill, specially if you have many products.

remember you can execute the reindexing via command line to save some time. Inside /magento/shell/ execute php indexer.php --reindex catalog_product_price

Just type "php indexer.php" and you'll get a list of available commands.