H3XED

Fix Magento Products Not Showing on Frontend After CSV Import

Please note that this post is over a year old and may contain outdated information.
If you create your products via CSV import and they're not showing up on the frontend, you may have missed some internal attributes. A common one to miss is _product_websites, which usually defaults to "base" when you create a product in the admin panel. To fix this and other missed attributes, follow these steps:

Step 1: Create a new product in the admin panel and fill out all the normal attributes you'll be using. You can use random information like "asdf" or "test"; it doesn't need to be a legitimate product. Make a note of the SKU you use.

Step 2: Export your new product by going to System > Import/Export > Export (select Products for Entity Type), typing in the SKU for your new item, and hitting Continue at the bottom. This will download a CSV containing that new product.

Step 3: With the exported CSV in hand, you can see all of the required fields used by Magento. Use this new CSV as a template to create/update your products. Now you won't miss any important attributes.


Other Things to Try


If your products are still not showing up, be sure to go through the following checklist to make sure a product is configured properly to show up on the frontend.

  • Make sure the product Status is Enabled (CSV file: status set to 1).
  • Make sure the product Visibility is set to Catalog, Search (CSV file: visibility set to 4).
  • Make sure the product is In Stock (CSV file: is_in_stock set to 1).
  • Make sure the product has a quantity available (CSV file: qty is greater than 0).
  • Make sure the product is in a category.
  • Flush and update your cache in System > Cache Management.
  • Reindex your data in System > Index Management.
Share This Post
Twitter
Learning Magento
Magento Beginner's Guide
Magento Beginner's Guide
See More Details
Magento SEO
Magento SEO
See More Details

Comments (2)

Oliver Russell   May 24, 2017
Have you check if you have imported/exported from CSV correctly? If not cross check it from here: https://magenticians.com/import-export-magento-2-products-csv/
Haseem Mujahidh   Sep 28, 2014
thank you very much.my major problem solved.. CHeers
Share This Post
Twitter
Learning Magento
Magento Beginner's Guide
Magento Beginner's Guide
See More Details
Magento SEO
Magento SEO
See More Details
H3XED © Nick Vogt   RSS   Policies   Twitter