I have a problem with products imported from csv.
The import finishes successfully, the products appear ok on admin, but they don’t appear on the site. The products are all enabled and on Stock but they won’t appear on the site. If I select a product from admin and simply resave it (without making any changes) it appears ok on the site too.
I thought that I made something wrong in the csv file, so I’ve made this simple test:
1) I manually added a product from admin panel. The product appeared ok on the site.
2) I exported a csv file with the products (1 product in this case)
3) I deleted the product from the site
4) I imported the products using the file created at step 2) (I didn’t make any changes to the originally exported file)
Again, the import went successfully, the product appears ok on the admin panel, but it doesn’t appear on the site.
The product appears enabled and on stock. The category is saved ok. If I simply open it from admin and save it (without making any changes) it will appear ok on the site.
Obviously, to manually open every imported product and resave it is not a solution (I have about 5000 products in the csv file).
Do you have any idea what I should do so that imported products will automatically appear on the site?