I have had to load my product categories by drilling direct into the MySQL database.

Each product can be in two Category 'trees' - one is genre and the other is artist.

So a CD from 'The Beatles' X might be in the Rock genre, and in the B- sub-category of the Artist category.

In the Genre, the breadcrumb is correct: Home > Genre > Rock > Beatles - CD Title

BUT in Artist the sequence is wrong: Home > B- > Artist > Beatles - CD Title instead of Home > Artist > B- > Beatles - CD Title

What have I not understood in the database? Thanks!
In General
Sunday, October 11 2015, 01:21 PM
Share this post:

Accepted Answer

Friday, October 23 2015, 12:29 PM - #Permalink
The reply is currently minimized Show
Responses (8)
  • Accepted Answer

    Wednesday, October 21 2015, 06:17 PM - #Permalink
    I'm not sure what you have done in the database, but I have noticed the same behaviour in the demo and other stores, so it seems to be a bug in Arastta and not your data.

    Example http://demo.arastta.org/en/tablets/test20/test25
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, October 21 2015, 06:32 PM - #Permalink
    Thanks Rune. Perhaps I can hack the php to echo the SQL calls.

    I haven't really understood the columns number in the categories. It says "number of columns to use for the bottom 3 categories. Only works for the top parent category"

    But increasing that to 5 for the top level one doesn't change the order in the breadcrumbs. ANd reducing it to 2 has no obvious effect.
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, October 21 2015, 06:46 PM - #Permalink
    I haven't looked at or tested the columns settings, but I guess it's related to the number of columns in a drop-down menu, and/or the "Refine Search": http://demo.arastta.org/en/tablets

    Edit: I added the ordering issue as a issue on GitHub: https://github.com/arastta/arastta/issues/228
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, October 22 2015, 07:24 PM - #Permalink
    Simon, what happens if you turn of SEO (if it's activated)?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, October 22 2015, 07:43 PM - #Permalink
    Aaha. 'Add Category to Products URLs' - this is the problem. Setting it OFF appears to fix it.

    I will give this some thorough checking later...
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, October 22 2015, 07:47 PM - #Permalink
    Hmmm. It only partly worked - but upset the other tree.

    Switch 'Use SEO URLs' off too seems to fix that too.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, October 22 2015, 07:50 PM - #Permalink
    'Add Category to Products URLs' isn't the culprit - just 'Use SEO URLs'
    The reply is currently minimized Show
  • Accepted Answer

    Friday, October 23 2015, 05:28 PM - #Permalink
    Thanks Rune for your help. Fix works fine for me.
    The reply is currently minimized Show
Your Reply