Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


These support forums are now closed for new topics and comments.
Please head on over to http://eureka.ucommerce.net/ for support.

  • Damian Green 452 posts 1433 karma points
    Jun 12, 2013 @ 11:32
    Damian Green
    0

    How to access products no longer associated with a category

    I noticed that after deleting a ll the categories that a product products belong to there doesnt seem a way to access those prodcts again.

    Is there a way without jumping into the database?

    Also the same with categories - after they have been deleted they are still in the database - and only the top level is marked as deleted.  If i add in the top level again they all come back. Is this the way you perceive to undelete?  Again - you would have to jump into the database to locate a categpry name (if forgotten).

     

  • Nickolaj Lundgreen 233 posts 1132 karma points
    Jun 12, 2013 @ 11:41
    Nickolaj Lundgreen
    0

    You could execute a quick script that loops all products without a productCategoryRelation, and add them to a dummy category ?

     

  • Damian Green 452 posts 1433 karma points
    Jun 12, 2013 @ 12:38
    Damian Green
    0

    Yes i could but that would mean dipping into the database.  

    I wondered if i was missing a feature in UC that allows me to view all products whether in category or not - or like you say a section/category for products not attached to a category.

    I guess maybe this could be done by having a category called Deleted and you could manually move stuff in bedofre deleteing things and coose not to display this category in the site.

     

     

     

  • Nickolaj Lundgreen 233 posts 1132 karma points
    Jun 12, 2013 @ 13:07
    Nickolaj Lundgreen
    100

    Can you find the product by searching?

    I was think about a razor / C# script - dont know if that makes a difference to you compared to SQL

    var dummyCategory = Category.FirstOrDefault(x => x.Name == "dummy");
        foreach (var prod in Product.All().Where(x=> !x.CategoryProductRelations.Any()))
        {
            dummyCategory.AddProduct(prod,0);
        }
  • Damian Green 452 posts 1433 karma points
    Jun 12, 2013 @ 13:54
    Damian Green
    0

    Im not aversion to SQL or the script - i am just thnking about users using the site and a "what if".  Maybe I could create an admin control using code similar to what you have suggested.

    I've not trued playing with the backend forms of UC yet but will add it to my list! :)

    Cheers.

     

Please Sign in or register to post replies

Write your reply to:

Draft