Case Study: Products are Not Visible at Front-End after Magento Import Unless Re-Saved
Browsing through forums and blog posts we have come across very common issue store owners experience after Magento import. We will try to get to the root of the problem and find out the ways to debug it and check what’s wrong, considering different situations possible.
Upload was reported to be successful and the products are actually available at back-end, but not accessible through front-end. The strange thing is that when opening a products and changing nothing, just re-saving the products works fine and 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:
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!
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:
- Create a new product in admin
- Make sure that this newly-added product is visible on front-end
- Export it
- Delete created product
- Import previously exported product from .csv
- Clear cache and reindex data
- Check that product is visible on front-end (it should be)
- Compare your CSV with the exported one and try to figure out what is missing from it
- 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.
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.