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.
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
Solved! Go to 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 -
Hi @mtsolov
Did you assign categories using the csv to the imported products?
Also did you re-index after the product import.
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 |
There is a video of error
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 -
Thank you so much.
Solved