Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Reactivating retired products

Posted on by Microsoft Employee

As our investigation into products continues, along with the inability to re-parent a product, another action which is apparently impossible (at least according to the second part of this blog article but not the diagram at the top of the article), is reactivating a retired product.

We have attempted to use an on-demand workflow to change the status to Active, Draft and Under Revision but are greeted with an error message saying that a retired product cannot be changed.

In my opinion, a software package should never, ever be able to prevent an administrator from changing the status of a record. My assumption is that the implementation of the retire function is such that allowing a change of status sufficiently breaks the system in a catastrophic way and is therefore, simply wrong.

This post is partially a vent and partially a warning to others:

Never, ever, ever retire a product unless you are so damn sure that you will never under any conceivable circumstance want to re-activate it. For gods sake if you really do retire a product, change the product ID before you do because unless you disable de-duplication, you will never, ever, ever be able to use the product ID again. And yes Microsoft, sometimes product IDs, rightly or wrongly, are re-used.

Please, someone - I really hope we are wrong and that products can be un-retired.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reactivating retired products

    You can export the record, modify the ID and then re-import. This will then allow you retain your numbering if you forgot to update the ID prior to retiring the product

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reactivating retired products

    Looks like this is still an issue 3 years on, come on Microsoft get this fixed!!!!

  • RE: Reactivating retired products

    Also upvote idea.dynamics.com! ideas.dynamics.com/.../1917081

  • RE: Reactivating retired products

    Can confirm... its still an issue in V8.2 and V9.  

    I found this in Ideas.dynamics.com, please upvote!

    ideas.dynamics.com/.../1917081

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reactivating retired products

    14 months on and the "bug" still persists!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reactivating retired products

    Anyone facing this issue should log help desk tickets.  It is only by constant user "feedback" that this inane limitation will be removed.

  • RE: Reactivating retired products

    Is there any way to update the statecode and statuscode on an online installation?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reactivating retired products

    Thank You, It Worked!

  • Suggested answer
    Sina Khodaparast Profile Picture
    Sina Khodaparast 25 on at
    RE: Reactivating retired products

    Dynamics CRM Application till now has no way to revert the status of a Product Family or a Product (that has a parent) from Retired to Active/Draft.

    Unfortunately at on operational environment, a product family was set to retired by mistake and it was cascaded to all the subordinated products. Since there is no embedded way at the Application,the last solution is to update it at the DB.

    You can change the status of the product by placing an update query on the database. Here is the query.

    update Product set StateCode = 2, StatusCode = 0

    where (StateCode = 1 AND StatusCode = 2)

    Hint:  Retired  StateCode=1 , StatusCode =2

             Draft     StateCode=2 , StatusCode =0

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reactivating retired products

    Hey emj -- Have they updated you on whether or not this was fixed in the new update rollup? I cannot seem to delete a Product Bundle or even "un-retire" it in order to modify the associations with other entities.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans