You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Integrin <in...@gmail.com> on 2014/08/19 12:18:27 UTC
Deleting Product from Catalog
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
Re: Deleting Product from Catalog
Posted by Integrin <in...@gmail.com>.
- 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 <
jacques.le.roux@les7arts.com> 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.
>>
>>
Re: Deleting Product from Catalog
Posted by Jacques Le Roux <ja...@les7arts.com>.
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.
>
Re: Deleting Product from Catalog
Posted by Rong Nguyen <ro...@olbius.com>.
@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,...)!
-----
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.
Re: Deleting Product from Catalog
Posted by Integrin <in...@gmail.com>.
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 <su...@tcs.com> 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 +919212246407/Sec +917503046188
> BUZZ/VOIP: 4141145
> Mail to: sumit.pandit@tcs.com
> Web site: www.tcs.com
> ____________________________________________
>
>
>
> ----- Original Message -----
> | From: "Rong Nguyen" <ro...@olbius.com>
> | To: user@ofbiz.apache.org
> | 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
>
>
>
Re: Deleting Product from Catalog
Posted by Sumit Pandit <su...@tcs.com>.
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 +919212246407/Sec +917503046188
BUZZ/VOIP: 4141145
Mail to: sumit.pandit@tcs.com
Web site: www.tcs.com
____________________________________________
----- Original Message -----
| From: "Rong Nguyen" <ro...@olbius.com>
| To: user@ofbiz.apache.org
| 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
Re: Deleting Product from Catalog
Posted by Rong Nguyen <ro...@olbius.com>.
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.
Re: Deleting Product from Catalog
Posted by Pierre Smits <pi...@gmail.com>.
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 <in...@gmail.com> 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
>