Products missing from frontend

[mtsolov]

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

[Mukesh Tiwari]

Hi @mtsolov

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

Also did you re-index after the product import.

[mtsolov]

Yes, all products is assigned properly to its category

sku

_store

_attribute_set

_type

_category

_root_category

_product_websites

color

cost

country_of_manufacture

created_at

custom_design

custom_design_from

custom_design_to

custom_layout_update

description

gallery

gift_message_available

has_options

image

image_label

manufacturer

media_gallery

meta_description

meta_keyword

meta_title

minimal_price

msrp

msrp_display_actual_price_type

msrp_enabled

name

news_from_date

news_to_date

page_layout

price

required_options

short_description

small_image

small_image_label

special_from_date

special_price

special_to_date

status

tax_class_id

thumbnail

thumbnail_label

updated_at

url_key

url_path

visibility

weight

qty

min_qty

use_config_min_qty

is_qty_decimal

backorders

use_config_backorders

min_sale_qty

use_config_min_sale_qty

max_sale_qty

use_config_max_sale_qty

is_in_stock

notify_stock_qty

use_config_notify_stock_qty

manage_stock

use_config_manage_stock

stock_status_changed_auto

use_config_qty_increments

qty_increments

use_config_enable_qty_inc

enable_qty_increments

is_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

Default

simple

Apple/iPhone 4/4S

Default Category

base

2016-02-04 12:49:47

Ефектен аксесоар с няколко 3D слоя.

Websitepics/vennus_zaby-d.jpg

Use config

Use config

3D гръб VENNUS iPhone 4/4S Жаба

22,9

0

Силиконов гръб за телефон Материал: TPU 3D ефект с пригинална картинка Съвместимост: Само с посочения модел Функционалност:

Websitepics/vennus_zaby-d.jpg

1

0

Websitepics/vennus_zaby-d.jpg

2

0.1000

1

1.0000

3

1

88

Websitepics/vennus_zaby-d.jpg

1

0

[mtsolov]

https://youtu.be/xUharEmX5Js

There is a video of  error

[Store_Manager · Accepted solution]

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...

[mtsolov]

Thank you so much.

Solved