brands

  • mitchamus

    (@mitchamus)


    11 years, 5 months ago

    can anyone tell me how a brand thumbnail equates to the slug?

    the brand thumbnails can be taken from the wp_jigoshop_termmeta table with the meta_type of ‘brands_thumbnail_id’

    this will get you the ID of the post and the link to the guid of the image.

    but it seems that there is no linking between the thumbnail post and the slug of the brand in wp_terms?

    it seems that there is a row missing that associates the thumbnail into the start of the terms relationshship in the wp_term_relationships table.

    i will try inserting a row into this table and see what happens.

    has anyone else done this?

    https://wordpress.org/plugins/jigoshop/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter mitchamus

    (@mitchamus)

    11 years, 5 months ago

    Ok so following up on this – I think this is a bug.

    When a new brand thumbnail is added, no corresponding row added in to the wp_term_relationships table to relate the thumbnail to the brand.

    so for example – I want to click on a brand logo to all the brands products…

    In this scenario – firstly we retrieve all the brand thumbnails from the wp_posts table (using wp_jigoshop_termmeta keyed on meta_value to post wp_posts.ID and where wp_jigoshop_termmeta.meta_key=’brands_thumbnail_id’)

    so now we have the brand pics and the psot ID.

    BUT

    going to the wp_term_relationships table to get the brand slug based on the wp_posts.ID – there is NO record in this table to tie the thumbnail to the rest of the taxonomy.

    When a thumbnail is added in the brands admin, it needs to add this row into wp_term_relationships to tie the thumbnail to the rest of the brand taxonomy.

    I have not looked at or tested the admin function to test how this happens. for example – i do not know if this happens if you create a brand with no thumbnail and then add it in later, or if it just doesn’t work right off the bat.
    In any case – I think it’s a bug.

    Thread Starter mitchamus

    (@mitchamus)

    11 years, 5 months ago

    Also looks like the ?brands= category loader is half finished.

    loads products under the brand into the blog archive instead of the category page.

    Jigoshop Support – Marcin

    (@marcin_biegun-jigoshop)

    11 years, 5 months ago

    Hi mitchamus,
    Not sure if I understand it – where do you have “brands” taxonomy from?
    Is it a part of your theme? Jigoshop itself comes with product cats and tags only.

    Thread Starter mitchamus

    (@mitchamus)

    11 years, 5 months ago

    That would explain a lot 😉

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘brands’ is closed to new replies.