I have a hard time solving this problem.
The problem is that the products are not shown on the front-end category pages and on the product listing pages after importing via csv –
It only shows We can not find products that match the selection.
However, if I go to the product in Admin and then RE SAVE without any changes, and I delete the cache of that product
it will be shown in front – on the product listing pages and on the category pages – and it will be displayed in the layered navigation
One thing I noticed is that after saving the product again in Admin, you are automatically adding Color Black to the
product – even if I have not selected it –
Then I tried my import file by adding Black color to the products in the import file to verify if they are displayed in
front end – but this did not solve the problem
In the table of the database I also noticed the saved products and then added Black to the column color_value
and color column 49
I tried to match these settings for the products that were not saved in the administrator but again these are not
show in the front
I imported more than 30000 via csv – all
1. are displayed in Admin
are displayed in the correct categories in Admin
It can be seen in the front going directly to the product page
Tested with the manufacture of products in stock with quantity 10 and exhausted with quantity 0, both will not be shown
List of products / category pages until they have been saved in admin
- Run reindex and delete all the caches
I have configured Magento to show products out of stock
The quantity for the products and the values of is_in_stock are set correctly after the import and also the production is
I have tried to export the products that I have saved and show on the pages of the product list and then match each one
attribute for import; however, after re-importing, the products NOT saved in Admin are not displayed in the front
Category and product listing pages.
I spent more than 4 weeks on this and tried a lot of things and trial and error.
I checked the catalog table catalog_product_flat_1 and verified all the imported attributes and compared the
showing on the front end and those that are not, and made them identical, however, still will not show
in the front unless the product has been saved again in admin.
This is the same case when importing through another extension or application for Magento, for example, Firebear – this
The problem is always occurring or whatever it is that I use a CSV import.
Another problem is that if I return to store the products and then show them in the front, when I update those same
products through csv import: the values, for example, price and quantity, and is_in_stock, only change in admin and not
in the front – in the category pages of the product list – then I have to re-save and clear the cache and then the
Updated changes are reflected in the front
I'm really stuck in