You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Scott Gray <le...@gmail.com> on 2006/07/01 03:35:05 UTC
Products with no categories
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
Re: Products with no categories
Posted by Scott Gray <le...@gmail.com>.
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
>
>
Re: Products with no categories
Posted by Scott Gray <le...@gmail.com>.
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 <le...@gmail.com> 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 <si...@opensourcestrategies.com>
>>> 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
>>>>>
>>
>>
>
Re: Products with no categories
Posted by BJ Freeman <bj...@free-man.net>.
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 <le...@gmail.com> 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 <si...@opensourcestrategies.com>
>> 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
>>>>
>
>
Re: Products with no categories
Posted by Chris Howe <cj...@yahoo.com>.
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 <le...@gmail.com> 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 <si...@opensourcestrategies.com>
> 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
> >>>
> >>
> >>
> >
>
Re: Products with no categories
Posted by Scott Gray <le...@gmail.com>.
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 <si...@opensourcestrategies.com> 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
>>>
>>
>>
>
Re: Products with no categories
Posted by BJ Freeman <bj...@free-man.net>.
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 <si...@opensourcestrategies.com> 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
>>
>
>
Re: Products with no categories
Posted by Chris Howe <cj...@yahoo.com>.
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 <si...@opensourcestrategies.com> 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
>
>
Re: Products with no categories
Posted by Si Chen <si...@opensourcestrategies.com>.
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