Deleting Product from Catalog

[Sakthivel Vellingiri]

Hi Ofbiz Users,

- It appears there is no service method available to delete a product from
catalog
- Is this by design?
- What is the recommended best practice to logically delete a product from
catalog that was created in error?
- Thanks in advance for any pointers

Regards

[Pierre Smits]

Yes, it is by design, given the many dependencies. But you can expire
products.

Regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com


On Tue, Aug 19, 2014 at 12:18 PM, Integrin <[hidden email]> wrote:

> Hi Ofbiz Users,
>
> - It appears there is no service method available to delete a product from
> catalog
> - Is this by design?
> - What is the recommended best practice to logically delete a product from
> catalog that was created in error?
> - Thanks in advance for any pointers
>
> Regards
>

[Rong Nguyen]

Hi Integrin,

- It appears there is no service method available to delete a product from
catalog

>> YES

- Is this by design?

>> YES

- What is the recommended best practice to logically delete a product from
catalog that was created in error?

>> You can do it by setting thruDate of product to the date you want to delete.

[Sumit Pandit]

Dear,

Term "Delete"! I would say 'unassociate'.

First thing as per design, product could not directly associate with Catalog. Catalog is associated to category and category is associated with products. It is the way how a product is associated with catalog.

Therefore you could not find any direct link(or service) at catalog screen to unassociate product from catalog.

You have to delete/expire product with category under selected catalog to not to be shown in catalog.


--
Thanks & Regards
Sumit Pandit
Solution Architect, Digital Software Solutions Group
Tata Consultancy Services
Work Phone Number: 124 6101145
Cell Number: Pri [phone]/Sec [phone]
BUZZ/VOIP: 4141145
Mail to: [hidden email]
Web site: www.tcs.com
____________________________________________



----- Original Message -----
| From: "Rong Nguyen" <[hidden email]>
| To: [hidden email]
| Sent: Tuesday, August 19, 2014 3:54:40 PM
| Subject: Re: Deleting Product from Catalog
|
| Hi Integrin,
|
|
| > - It appears there is no service method available to delete a
| > product from
| > catalog
|
| >> YES
|
| > - Is this by design?
|
| >> YES
|
| - What is the recommended best practice to logically delete a product
| from
| catalog that was created in error?
|
| >> You can do it by setting thruDate of product to the date you want
| >> to
| >> delete.
|
|
|
| -----
| Rong Nguyen
|
| Olbius JSC
| Deliver highest business value
| http://www.olbius.com/
| --
| View this message in context:
| http://ofbiz.135035.n4.nabble.com/Deleting-Product-from-Catalog-tp4654023p4654027.html
| Sent from the OFBiz - User mailing list archive at Nabble.com.
|
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you

[Sakthivel Vellingiri]

Thanks all for the pointers,

@Rong Nguyen, i could not find thruDate in the "Product" entity, is it by
any chance release_date? if it is any other field for expiring product
please advise

Regards



On Tue, Aug 19, 2014 at 6:29 AM, Sumit Pandit <[hidden email]> wrote:

> Dear,
>
> Term "Delete"! I would say 'unassociate'.
>
> First thing as per design, product could not directly associate with
> Catalog. Catalog is associated to category and category is associated with
> products. It is the way how a product is associated with catalog.
>
> Therefore you could not find any direct link(or service) at catalog screen
> to unassociate product from catalog.
>
> You have to delete/expire product with category under selected catalog to
> not to be shown in catalog.
>
>
> --
> Thanks & Regards
> Sumit Pandit
> Solution Architect, Digital Software Solutions Group
> Tata Consultancy Services
> Work Phone Number: 124 6101145
> Cell Number: Pri [phone]/Sec [phone]
> BUZZ/VOIP: 4141145
> Mail to: [hidden email]
> Web site: www.tcs.com
> ____________________________________________
>
>
>
> ----- Original Message -----
> | From: "Rong Nguyen" <[hidden email]>
> | To: [hidden email]
> | Sent: Tuesday, August 19, 2014 3:54:40 PM
> | Subject: Re: Deleting Product from Catalog
> |
> | Hi Integrin,
> |
> |
> | > - It appears there is no service method available to delete a
> | > product from
> | > catalog
> |
> | >> YES
> |
> | > - Is this by design?
> |
> | >> YES
> |
> | - What is the recommended best practice to logically delete a product
> | from
> | catalog that was created in error?
> |
> | >> You can do it by setting thruDate of product to the date you want
> | >> to
> | >> delete.
> |
> |
> |
> | -----
> | Rong Nguyen
> |
> | Olbius JSC
> | Deliver highest business value
> | http://www.olbius.com/
> | --
> | View this message in context:
> |
> http://ofbiz.135035.n4.nabble.com/Deleting-Product-from-Catalog-tp4654023p4654027.html
> | Sent from the OFBiz - User mailing list archive at Nabble.com.
> |
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you
>
>
>

[Rong Nguyen]

@Integrin Solutions: You can set thruDate for the link between product and others(Category,...)

You can delete by using SQL to DB, or create your own service, but in general it's not good(Entity relational,...)!

[Jacques Le Roux]

Le 19/08/2014 13:08, Rong Nguyen a écrit :
> @Integrin Solutions: You can set thruDate for the link between product and
> others(Category,...)
>
> You can delete by using SQL to DB, or create your own service, but in
> general it's not good(Entity relational,...)!

Another underlying reason is possible auditing. So you could still create SQL scripts to remove your products. But in case you are in need of history,
it good to keep things ready for that...

Jacques

>
>
> -----
> Rong Nguyen
>
> Olbius JSC
> Deliver highest business value
> http://www.olbius.com/
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Deleting-Product-from-Catalog-tp4654023p4654034.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Sakthivel Vellingiri]

- Good point Jacques,
- Will expire the products and keep it in the system
- Thanks all for the pointers

Regards


On Tue, Aug 19, 2014 at 9:56 AM, Jacques Le Roux <
[hidden email]> wrote:

> Le 19/08/2014 13:08, Rong Nguyen a écrit :
>
>  @Integrin Solutions: You can set thruDate for the link between product and
>> others(Category,...)
>>
>> You can delete by using SQL to DB, or create your own service, but in
>> general it's not good(Entity relational,...)!
>>
>
> Another underlying reason is possible auditing. So you could still create
> SQL scripts to remove your products. But in case you are in need of
> history, it good to keep things ready for that...
>
> Jacques
>
>
>
>>
>> -----
>> Rong Nguyen
>>
>> Olbius JSC
>> Deliver highest business value
>> http://www.olbius.com/
>> --
>> View this message in context: http://ofbiz.135035.n4.nabble.
>> com/Deleting-Product-from-Catalog-tp4654023p4654034.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>