Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 4 of 4

Thread: Mapping Unpublished Proudcts?

  1. #1
    linhoff is offline Junior Member
    Join Date
    Jul 2009
    Posts
    27

    Default Mapping Unpublished Proudcts?

    We have a "New Item" category which is unpublished. Items get filed here until ready for public view, and are then mapped to a published category.
    We have recently migrated to Multistore 9.2, and find that apparently only published categories show in the Admin mapping trees.
    Furthermore, selecting "Proudcts for Category" for the unpublished category shows ALL products, regardless of mapping.
    Can someone advise how we can map to/from a unpublished category, as we could in the previous version of ASPDNSF.

    Thanks!

  2. #2
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default

    To find those products mapped to a category only tick the box "Show Selected Only"

    Not sure about the mapping products to an unpublished category not showing up in the mapping tree. I know this was a bug in 9.0.1.3 (which were still on) but never found it if this was fixed. Have you tried publishing the category, then adding a product and unpublishing the category again before resetting the cache?

    Failing that you could possibly run a SQL script to assign those ProductID's to the category as it will physically exist in the Category table.

  3. #3
    linhoff is offline Junior Member
    Join Date
    Jul 2009
    Posts
    27

    Default

    Thank you for pointing out the check box filter - that solved 60% of our problem. Simple fix. Kind of wish the listed products were clickable, so you could select an item from the list to edit the product properties (beyond the price, SE, Inventory, etc. provided).
    As it is now, from what I have observed, you would have to manually make a list of items shown on the screen, then switch to Manage Products and search for it. It works, but not elegantly.
    Thank you for responding so promptly!

  4. #4
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default

    You could try a SQL command such as

    update ProductCategory set CategoryID = 2
    where ProductID in (
    'Example1',
    'Example2',
    'Example3')