Rating 0 stars - 0 votes

Case Study: Products are Not Visible at the Front-End after Magento Import Unless Re-Saved

Browsing through forums and blog posts, we have come across a very common issue that store owners may experience after Magento import. We will try to get to the root of the problem and find out the ways to debug it.

A Problem

The upload was reported to be successful and the products are actually available at the back-end, but not accessible through the front-end. The strange thing is that when opening a product and changing nothing, just re-saving, the product works fine and the item starts displaying. However, when quantities of imported goods are massive, it will be difficult and time-consuming even though you will have just to open each products without changes simply hit “Save”.

What can be wrong? & Workflow

The reasons of the issue can be various, so let’s see what might cause the difficulty:

Missing Data

First of all, make sure that you have Magento 1.7 or later.

In your file here should be all information needed for product to be visible at front-end, like:

  • status (enabled - 1),
  • quantity more than 0 or more than value put in “Minimum Qty for item’s status to be out of stock” field,
  • visibility - Catalog or Catalog, Search,
  • category path (with categories assigned to Root category),
  • website - in field “_product_websites” set base to assign default website - this is the most common problem that causes the issue!

File Structure

Magento itself is very peculiar about the information listed in the file as well as file structure. In case some of the columns headings are not the same as database fields, then they might not be recognized by Magento during import.

The simplest way to find out what structure is required and how is it different from your spreadsheet:

  1. Create a new product in admin
  2. Make sure that this newly-added product is visible on front-end
  3. Export it
  4. Delete created product
  5. Import previously exported product from .csv
  6. Clear cache and reindex data
  7. Check that product is visible on front-end (it should be)
  8. Compare your CSV with the exported one and try to figure out what is missing from it
  9. Try to import your CSV with added/fixed columns and add data until the product is imported so that it is visible on front-end


Not seldom in order to make shop more attractive and with some special unique design. However, buying and installing template you might need to make additional settings to adjust it. Thus, check in your template - maybe you have to make additional modifications there. If you are not sure, you may install default template and check if the products are visible. If with default design the products are displayed, compare template files - it might give you idea what should be modified in your new template for the products to be viewable.


If your Magento is highly-customized and those customizations influenced the core, you might have trouble with default functionality, which should be working properly, but actually it’s not. In case you are not sure if customization influenced visibility of your products at front-end, to check it you can have another Magento installation (but in this case default one) put in some subfolder (subdomain).

Moreover, if you think that you can simply dig in database tables and add values directly there, you are making huge mistake. It's Magento and things are not so easy here. You cannot add values to one column, let’s say visibility and expect that it will be working. Actually, things are much more complicated there and you have to add values to numerous tables.

Cache and Index

Finally, do not forget that for faster loading the pages are cached and indices are updated after changes, so it is required to flush cache and rebuild indices to see latest data reflected at store front.

Results & Alternative

So in case you have checked and tried all the above mentioned points, hopefully, you have found the solution and everything is working now. However, in case you are still experiencing the problem with products display, most likely there is deeper issue you need to investigate. Time is money, so most likely you would not like to lose sales. As permanent solution, use can use trial version of Store Manager for Magento -

The software has built-in Multi-Editor tool that allows to perform massive operations over bulks of products at once and in a few seconds, so with it you will have just to select products and let’s say put for all of them status “Enabled”.

This is not permanent solution, but it will allows you to save time and not to lose money while checking with your developer or trying to deal with the problem in some other way.

Related Articles:

Card image

Products Are Not Showing Up After Magento 2 Import

Most likely reasons why your products are not displayed at the store after the import. Read More...

Card image

Magento Import: 101 Questions & Answers

Frequently asked questions about Magento import (general questions, errors, categories/images import issues etc). Read More...

Card image

What to Check if You Cannot Upload Magento Images?

List of reasons causing the impossibility to import Magento images (cache, reindex, image size etc). Read More...

Card image

How to Perform Automated Product Import

Schedule Magento import to be accomplished on hourly, daily or weekly basis using the saved configuration. Read More...

Anup Kulkarni
Anup Kulkarni • 10/23/2017

did all the things but still not able to set the product images automatically in the front end, here is my code please any help will be appreciable. $storeId=Mage::app()->getStore('abrasive')->getId(); //find the store id, for the store, the product belongs to
$product = Mage::getModel('catalog/product');
// $product->setDescription($description);
//added, meta description to 'short description' field, you can change this value
// $product->setMetaKeyword('test meta keyword 2');
// $product->setMetaTitle('test meta title 2');
$stockItem = Mage::getModel('cataloginventory/stock_item');
$stockItem->setData('is_in_stock', 1);
'use_config_manage_stock' => 0, //'Use config settings' checkbox
'manage_stock'=>1, //manage stock
'min_sale_qty'=>1, //Minimum Qty Allowed in Shopping Cart
'max_sale_qty'=>2, //Maximum Qty Allowed in Shopping Cart
'is_in_stock' => 1, //Stock Availability
'qty' =>$qty //qty
$import = Mage::getBaseDir('media') . DS . 'import' . DS . $images1;
// echo $import;//exit();
$product->setMediaGallery (array('images'=>array (), 'values'=>array ()));
catch(Exeption $e)
{ echo $e->getMessage();

Magento Store ManagerMod Anup Kulkarni • 10/26/2017

Thank you for your question.
1. You need to add additional check for the file availability and directory access privilege:
$import = Mage::getBaseDir('media') . DS . 'import' . DS . $images1;
2. We’re not sure about this part:
$product->setMediaGallery (array('images'=>array (), 'values'=>array ()));
- It’s hard to say if it is required
3. As for this line:
You should check this method - addImageToMediaGallery as we’re not sure where it takes images from, For more details you can check main method description.
Here’s an example of how you can call the object:
$product->addImageToMediaGallery($path, $imageAttributeList, true, false);
If you still have issues - please, contact us via the email contact@mag-manager.com to receive further technical assistance.

Saravanan • 11/10/2020

Hi ,
I import the csv file with 50 attributes, its updated successfully, later i added two attributes and imported, rows are imported successfully, but not updated in database, i mean that two attributes is not created. please guide me. i am using magento2.

Magento Store ManagerMod Saravanan • 11/10/2020

Thank you for your question. To answer it, we need some additional info:

If you were importing attributes via Store Manager for Magento, please send to our email contact@emagicone.com the following:

  1. A type of connection.
  2. Store Manager version.
  3. The codes of the attributes that were not created.
  4. Attach the files:

  5. Your CSV file with attributes.
  6. Import configuration (save it at the last step in the Import Wizard).

Looking forward to getting this information from you. We'll be glad to help.