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 3 of 3

Thread: Find (soft) Deleted products

  1. 02-14-2011, 07:37 AM #1
    kevanbulmer is offline Junior Member
    Join Date
    Jun 2009
    Posts
    20

    Default Find (soft) Deleted products

    Hi

    If a product is marked as soft deleted, it disappears from the product listing page in the admin system. How can I now find this product? searching for the product does not find the product.

    Thanks
    kb
  2. 02-15-2011, 02:20 AM #2
    kevanbulmer is offline Junior Member
    Join Date
    Jun 2009
    Posts
    20

    Default any answer to this?

    Its seems like this should be a common request, no?
  3. 02-15-2011, 03:13 AM #3
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    You'll need to un-soft-delete it, and mark it as unpublished.
    Code:
    UPDATE [Product] SET [deleted]=0, [Published]=0 WHERE [ProductID]=<your-product-id-here>
    Try this on your test server first!
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!