Products with no categories

[Scott Gray]

Hi

Is there any way to find products that aren't associated with any
category?  For example, let's say we're adding 10 new products everyday
but occasionally you forget to associate a product with a category,
would this mean the product is lost until someone notices that it's
missing from the ecommerce pages?

Thanks
Scott

[Si Chen-2]

It can still be searched but if it's not in ProductCategoryMember it  
won't show up in categories' product listings.

On Jun 30, 2006, at 6:35 PM, Scott Gray wrote:

> Hi
>
> Is there any way to find products that aren't associated with any  
> category?  For example, let's say we're adding 10 new products  
> everyday but occasionally you forget to associate a product with a  
> category, would this mean the product is lost until someone notices  
> that it's missing from the ecommerce pages?
>
> Thanks
> Scott

[Scott Gray]

Hi Si

That would be a bit of a disaster wouldn't it?  If you were fully
stocked on a new product for a month before someone realizes it's not
attached to any listings?  Should we create a search link on the Catalog
Admin Main Page called something like 'Display Products with no Categories'?

Thanks
Scott

Si Chen wrote:

> It can still be searched but if it's not in ProductCategoryMember it
> won't show up in categories' product listings.
>
> On Jun 30, 2006, at 6:35 PM, Scott Gray wrote:
>
>> Hi
>>
>> Is there any way to find products that aren't associated with any
>> category?  For example, let's say we're adding 10 new products
>> everyday but occasionally you forget to associate a product with a
>> category, would this mean the product is lost until someone notices
>> that it's missing from the ecommerce pages?
>>
>> Thanks
>> Scott
>
>

[cjhowe]

didn't there used to be in the catalog manager a link
that would list all products that were without a
category?  I don't see it there anymore

--- Si Chen <[hidden email]> wrote:

> It can still be searched but if it's not in
> ProductCategoryMember it  
> won't show up in categories' product listings.
>
> On Jun 30, 2006, at 6:35 PM, Scott Gray wrote:
>
> > Hi
> >
> > Is there any way to find products that aren't
> associated with any  
> > category?  For example, let's say we're adding 10
> new products  
> > everyday but occasionally you forget to associate
> a product with a  
> > category, would this mean the product is lost
> until someone notices  
> > that it's missing from the ecommerce pages?
> >
> > Thanks
> > Scott
>
>

[BJ Freeman]

if you handy with SQL and understand the entity relations you can use
the webtools.


Chris Howe sent the following on 6/30/2006 7:02 PM:

> didn't there used to be in the catalog manager a link
> that would list all products that were without a
> category?  I don't see it there anymore
>
> --- Si Chen <[hidden email]> wrote:
>
>> It can still be searched but if it's not in
>> ProductCategoryMember it  
>> won't show up in categories' product listings.
>>
>> On Jun 30, 2006, at 6:35 PM, Scott Gray wrote:
>>
>>> Hi
>>>
>>> Is there any way to find products that aren't
>> associated with any  
>>> category?  For example, let's say we're adding 10
>> new products  
>>> everyday but occasionally you forget to associate
>> a product with a  
>>> category, would this mean the product is lost
>> until someone notices  
>>> that it's missing from the ecommerce pages?
>>>
>>> Thanks
>>> Scott
>>
>
>

[Scott Gray]

I guess at the end of the day, we could just drop everything and use
webtools ;-)

Scott

BJ Freeman wrote:

> if you handy with SQL and understand the entity relations you can use
> the webtools.
>
>
> Chris Howe sent the following on 6/30/2006 7:02 PM:
>> didn't there used to be in the catalog manager a link
>> that would list all products that were without a
>> category?  I don't see it there anymore
>>
>> --- Si Chen <[hidden email]> wrote:
>>
>>> It can still be searched but if it's not in
>>> ProductCategoryMember it  won't show up in categories' product
>>> listings.
>>>
>>> On Jun 30, 2006, at 6:35 PM, Scott Gray wrote:
>>>
>>>> Hi
>>>>
>>>> Is there any way to find products that aren't
>>> associated with any
>>>> category?  For example, let's say we're adding 10
>>> new products
>>>> everyday but occasionally you forget to associate
>>> a product with a
>>>> category, would this mean the product is lost
>>> until someone notices
>>>> that it's missing from the ecommerce pages?
>>>>
>>>> Thanks
>>>> Scott
>>>
>>
>>
>

[cjhowe]

It's a relatively easy script to make (although a
resource hog I would imagine)
find all product
iterate through them their related
ProductCategoryMember and if it returns null, add that
product to your list

--- Scott Gray <[hidden email]> wrote:

> I guess at the end of the day, we could just drop
> everything and use
> webtools ;-)
>
> Scott
>
> BJ Freeman wrote:
> > if you handy with SQL and understand the entity
> relations you can use
> > the webtools.
> >
> >
> > Chris Howe sent the following on 6/30/2006 7:02
> PM:
> >> didn't there used to be in the catalog manager a
> link
> >> that would list all products that were without a
> >> category?  I don't see it there anymore
> >>
> >> --- Si Chen <[hidden email]>
> wrote:
> >>
> >>> It can still be searched but if it's not in
> >>> ProductCategoryMember it  won't show up in
> categories' product
> >>> listings.
> >>>
> >>> On Jun 30, 2006, at 6:35 PM, Scott Gray wrote:
> >>>
> >>>> Hi
> >>>>
> >>>> Is there any way to find products that aren't
> >>> associated with any
> >>>> category?  For example, let's say we're adding
> 10
> >>> new products
> >>>> everyday but occasionally you forget to
> associate
> >>> a product with a
> >>>> category, would this mean the product is lost
> >>> until someone notices
> >>>> that it's missing from the ecommerce pages?
> >>>>
> >>>> Thanks
> >>>> Scott
> >>>
> >>
> >>
> >
>

[BJ Freeman]

I subscribe to having the db on a separate machine than the application.
it really speeds things up when your in 100K records.
Then using Cursors you don't load the whole Recordset into the
application. Which ofbiz does.
so it is not as much a resource hog as some might think.

Scott if you looking for a solution. why not put in the jira so people
can add snippets that might help.


Chris Howe sent the following on 6/30/2006 8:10 PM:

> It's a relatively easy script to make (although a
> resource hog I would imagine)
> find all product
> iterate through them their related
> ProductCategoryMember and if it returns null, add that
> product to your list
>
> --- Scott Gray <[hidden email]> wrote:
>
>> I guess at the end of the day, we could just drop
>> everything and use
>> webtools ;-)
>>
>> Scott
>>
>> BJ Freeman wrote:
>>> if you handy with SQL and understand the entity
>> relations you can use
>>> the webtools.
>>>
>>>
>>> Chris Howe sent the following on 6/30/2006 7:02
>> PM:
>>>> didn't there used to be in the catalog manager a
>> link
>>>> that would list all products that were without a
>>>> category?  I don't see it there anymore
>>>>
>>>> --- Si Chen <[hidden email]>
>> wrote:
>>>>> It can still be searched but if it's not in
>>>>> ProductCategoryMember it  won't show up in
>> categories' product
>>>>> listings.
>>>>>
>>>>> On Jun 30, 2006, at 6:35 PM, Scott Gray wrote:
>>>>>
>>>>>> Hi
>>>>>>
>>>>>> Is there any way to find products that aren't
>>>>> associated with any
>>>>>> category?  For example, let's say we're adding
>> 10
>>>>> new products
>>>>>> everyday but occasionally you forget to
>> associate
>>>>> a product with a
>>>>>> category, would this mean the product is lost
>>>>> until someone notices
>>>>>> that it's missing from the ecommerce pages?
>>>>>>
>>>>>> Thanks
>>>>>> Scott
>>>>
>
>

[Scott Gray]

Hi BJ

I can figure out a solution, I just wanted to make sure i wasn't missing
something before i got to work.

Thanks
Scott

BJ Freeman wrote:

> I subscribe to having the db on a separate machine than the application.
> it really speeds things up when your in 100K records.
> Then using Cursors you don't load the whole Recordset into the
> application. Which ofbiz does.
> so it is not as much a resource hog as some might think.
>
> Scott if you looking for a solution. why not put in the jira so people
> can add snippets that might help.
>
>
> Chris Howe sent the following on 6/30/2006 8:10 PM:
>> It's a relatively easy script to make (although a
>> resource hog I would imagine)
>> find all product
>> iterate through them their related
>> ProductCategoryMember and if it returns null, add that
>> product to your list
>>
>> --- Scott Gray <[hidden email]> wrote:
>>
>>> I guess at the end of the day, we could just drop
>>> everything and use webtools ;-)
>>>
>>> Scott
>>>
>>> BJ Freeman wrote:
>>>> if you handy with SQL and understand the entity
>>> relations you can use
>>>> the webtools.
>>>>
>>>>
>>>> Chris Howe sent the following on 6/30/2006 7:02
>>> PM:
>>>>> didn't there used to be in the catalog manager a
>>> link
>>>>> that would list all products that were without a
>>>>> category?  I don't see it there anymore
>>>>>
>>>>> --- Si Chen <[hidden email]>
>>> wrote:
>>>>>> It can still be searched but if it's not in
>>>>>> ProductCategoryMember it  won't show up in
>>> categories' product
>>>>>> listings.
>>>>>>
>>>>>> On Jun 30, 2006, at 6:35 PM, Scott Gray wrote:
>>>>>>
>>>>>>> Hi
>>>>>>>
>>>>>>> Is there any way to find products that aren't
>>>>>> associated with any
>>>>>>> category?  For example, let's say we're adding
>>> 10
>>>>>> new products
>>>>>>> everyday but occasionally you forget to
>>> associate
>>>>>> a product with a
>>>>>>> category, would this mean the product is lost
>>>>>> until someone notices
>>>>>>> that it's missing from the ecommerce pages?
>>>>>>>
>>>>>>> Thanks
>>>>>>> Scott
>>>>>
>>
>>
>