Magento Expert Forum - Improve your Magento experience

Results 1 to 2 of 2

flat table product

  1. #1
    New member mat's Avatar
    Join Date
    Sep 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy flat table product

    Hello,

    Flat product table, once enabled should be used solely to display a product.
    Am I wrong ?

    So, if I add attributes, how can I add these in the flat tables..?

    example of a line I get on catalog_product_flat on my website:

    entity_id ; 268232
    attribute_set_id ; 9
    type_id ; simple
    availability_titelive ; 6
    cost ; NULL
    created_at ; 08/05/2014 13:55
    credit_amount ; NULL
    enable_googlecheckout ; 1
    fb_product ; NULL
    gift_message_available ; NULL
    has_options ; 0
    image_label ; NULL
    is_recurring ; NULL
    links_exist ; NULL
    links_purchased_separately ; NULL
    links_title ; NULL
    msrp ; NULL
    msrp_display_actual_price_type ; NULL
    msrp_enabled ; NULL
    name ; Mon Bloc De Dessin 3d &#59; Special Filles
    news_from_date ; NULL
    news_to_date ; NULL
    price ; 130.0000
    price_type ; NULL
    price_view ; NULL
    publication_date_titelive ; 01/12/2015 00:00
    recurring_profile ; NULL
    required_options ; 0
    shipment_type ; NULL
    short_description ; Une nouvelle collection de kits totalement inédite avec tout le matériel pour créer des images en 3 dimensions &#
    sku ; 9782215109372
    sku_type ; NULL
    small_image ; NULL
    small_image_label ; NULL
    special_from_date ; NULL
    special_price ; NULL
    special_to_date ; NULL
    tax_class_id ; 0
    thumbnail ; NULL
    thumbnail_label ; NULL
    updated_at ; 02/09/2014 16:57
    url_key ; mon-bloc-de-dessin-3d-special-filles
    url_path ; mon-bloc-de-dessin-3d-special-filles.html
    visibility ; 4
    weight ; 283.0000
    weight_type ; NULL

    etc..What I infer from this is the flat table isn't correctly getting all the new attributes I added. And (since the product page displays correctly that magento will look for what is missing using INNER JOIN). Great but best would be that all fields are correctly fed.

    Thanks for your help.

    Mat

    View more threads in the same category:


  2. #2
    Junior Member
    Join Date
    Aug 2014
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Hi, I recently started using flat product tables in Magento. It drastically sped up the site load time and I could never go back (to learn how to enable flat product and category tables, visit the following link and read Tip 4 - http://blog.nexcess.net/2010/10/22/6...duction-ready/)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •