Products are not displaying in Frontend after import in Magento

Question

I have imported products using System - Import/Export - Import option.

I can see my products in Admin panel, but not in Frontend.

I tried Re-indexing, cache clear, cache refresh, physical cache remove.

also checked product stock status, availability etc. Everything is ok.

But they are not displaying in frontend. I marked onething, If I open product that I imported using csv, just saved without any change, it starts displaying. But I have 100s of products. So I can't use this solution.

So please help me where I am going wrong in csv. below is my csv screenshot.

Solution

You need to ensure that the products are attached to a website.

This can be done via a bulk update:

• Access the product listm select all
• Alter attribute
• Products information -> websites

It can also be done in the csv by using a "_product_websites" field and setting it to the website name or 'base'.