Announcement

Collapse
No announcement yet.

Check Product Hide HTML when parent section hidden

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Check Product Hide HTML when parent section hidden

    If a section is hidden its child products are also hidden but their 'Hide on Website' box is not ticked. Thus if you run an SPP converter or similar the previously hidden products become visible as they have been moved from their parent section.

    I would like a way to cascade a Section's 'bHideOnWebSite' to the product's 'bSuppressHtml'

    This is so the SPPs would be generated but the products remain hidden

    Please can someone help me write an Access query along the following lines:
    • If Table Catalog Section bHideOnWebSite is checked
    • then Table Product check bSuppressHtml
    I am afraid I am not competent to do this on my own!

    Thank you
    Jonathan Chappell
    Website Designer
    SellerDeck Website Designer
    Actinic to SellerDeck upgrades
    Graphicz Limited - www.graphicz.co.uk

    #2
    OK. Let me try anmd be more specific.

    In The Catalog Section Table you can find the Section IDs of the sections that are 'Hide on Website'

    The Product Table has a column for Parent Section IDs (nParentSectionID) and the column for hide on website (bSuppressHtml)

    Either in Access or Excel is there a way to say:

    for an array or selection of values of 'nParentSectionID' change to respective values of 'bSuppressHtml' to true

    Thank you
    Jonathan Chappell
    Website Designer
    SellerDeck Website Designer
    Actinic to SellerDeck upgrades
    Graphicz Limited - www.graphicz.co.uk

    Comment


      #3
      I think you'd need to create an Update Query like this (but I haven't tested it):

      Click image for larger version

Name:	UpdateQuery.jpg
Views:	94
Size:	83.7 KB
ID:	555659
      John
      John Ennals
      www.tortoys.co.uk

      Comment


        #4
        Smashing - thank you so much John
        Jonathan Chappell
        Website Designer
        SellerDeck Website Designer
        Actinic to SellerDeck upgrades
        Graphicz Limited - www.graphicz.co.uk

        Comment

        Working...
        X