cancel
Showing results for 
Search instead for 
Did you mean: 

Products missing from frontend

SOLVED

Products missing from frontend

 

Hi there,

I made import of some products via .CSV. Products and atributes are ok, import is succesfully done instead product is missing in relevant category. All required fields are checked and it is filled as should be.

  • Stock Availability - OK
  • Qty - OK
  • Visibility - OK
  • Catalog - OK
  • Price - OK.

The most strange is when I go to edit product in backend and just hit save (without any changes), the product become visible in frontend.

Import was made with csv created with Open Office

5 REPLIES

Re: Products missing from frontend

Hi @mtsolov

 

Did you assign categories using the csv to the imported products? 

 

Also did you re-index after the product import.

---
Problem Solved Click Accept as Solution!:Magento Community India Forum

Re: Products missing from frontend

Yes, all products is assigned properly to its category

 

sku_store_attribute_set_type_category_root_category_product_websitescolorcostcountry_of_manufacturecreated_atcustom_designcustom_design_fromcustom_design_tocustom_layout_updatedescriptiongallerygift_message_availablehas_optionsimageimage_labelmanufacturermedia_gallerymeta_descriptionmeta_keywordmeta_titleminimal_pricemsrpmsrp_display_actual_price_typemsrp_enablednamenews_from_datenews_to_datepage_layoutpricerequired_optionsshort_descriptionsmall_imagesmall_image_labelspecial_from_datespecial_pricespecial_to_datestatustax_class_idthumbnailthumbnail_labelupdated_aturl_keyurl_pathvisibilityweightqtymin_qtyuse_config_min_qtyis_qty_decimalbackordersuse_config_backordersmin_sale_qtyuse_config_min_sale_qtymax_sale_qtyuse_config_max_sale_qtyis_in_stocknotify_stock_qtyuse_config_notify_stock_qtymanage_stockuse_config_manage_stockstock_status_changed_autouse_config_qty_incrementsqty_incrementsuse_config_enable_qty_incenable_qty_incrementsis_decimal_divided_links_related_sku_links_related_position_links_crosssell_sku_links_crosssell_position_links_upsell_sku_links_upsell_position_associated_sku_associated_default_qty_associated_position_tier_price_website_tier_price_customer_group_tier_price_qty_tier_price_price_group_price_website_group_price_customer_group_group_price_price_media_attribute_id_media_image_media_lable_media_position_media_is_disabled
749 DefaultsimpleApple/iPhone 4/4SDefault Categorybase   2016-02-04 12:49:47    Ефектен аксесоар с няколко 3D слоя.   Websitepics/vennus_zaby-d.jpg        Use configUse config3D гръб VENNUS iPhone 4/4S Жаба   22,90Силиконов гръб за телефон
Материал: TPU
3D ефект с пригинална картинка
Съвместимост: Само с посочения модел
Функционалност:
Websitepics/vennus_zaby-d.jpg    10Websitepics/vennus_zaby-d.jpg    20.10001     1.0000 3 1                          88Websitepics/vennus_zaby-d.jpg 10

Re: Products missing from frontend

https://youtu.be/xUharEmX5Js

There is a video of  error

Re: Products missing from frontend

Hello.

 

I had the same problem and it was the matter of website (check your website value in file) and encoding- should be UTF-8.

 

As workaround to fix this, you can try to massively attach your existing the products to a website. Go to your back-end:

1) Catalog-> manage products

2) Select products you need to update (or select all)

3) Actions - Update attribute - Submit

4) Chose tab Websites and check the box to apply website to selected products.

 

Here is also case study on the problem -

https://www.mag-manager.com/useful-articles/case-studies/case-study-products-are-not-visible-at-fron...

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.

Re: Products missing from frontend

Thank you so much.

Solved