Deleted product information persisting

Hot Topic

hiding the parameters in the address bar
IE 7 opening to Run Once page with error on it.
Biztalk Adapters Sample
after successful RC1 install other services fail
.NET objects hosted in IE works unstable
Address bar on Popups won't go away
Aggregates in WDS 3.0 OLE DB provider
InternetQueryOption Unicode change in IE7
Help me Uninstall Old IE7 Beta 2 to install RC1 !!
IE7 issue with Integrated Windows Authentication in IIS

IE Development

Banners offline after 11pm
Commerce Server 2007 Performance Guide is now available online!
code repository
Extending Commerce OrderForm
CS 2007 Starter Site - stored procedure 'dbo.inv_CheckInventory' doesn't exist
web service authentication
MSN search toolbar latest version?
#msntb_toolbar_full_name#
Here is my first application
IE7 cookie problem

Deleted product information persisting

I am getting an error when attempting to add a new product: "A Product named 1234 already exists."

I had added a product with the same properties before, along with discounts associated with the product. I then deleted the product and the discounts associated with it. The product can no longer be found in the catalog manager by searching or browsing. I've also looked through the productcatalog database, and found no entries for that product. The discounts have remained in the system and are visible in the Marketing Manager as Deleted Items.

What do I need to do to add this product again

Thanks :)

Answer this question

Deleted product information persisting

  • ogtr

    You should try purging the deleted items from the catalog and creating the product again.

  • aggrothingy

    Colin -

    The error still occurs after I cycle the application pool and after I reset IIS.

    Thanks,

    Mike

  • kperson

    Also change you Check the <CatalogName>_CatalogDeletedProducts table in your ProductCatalog DB and check if an entry for Product "1234" is present

  • Michael Vanhoutte

    Mike,

    Can you do run a SQL Profiler trace to see what is happening at the SQL level If the catalog system is reporting the product as still existing it must be there somewhere. I am assuming this is a base catalog and not a virtual catalog.

    Cheers,
    Colin


  • Talyrond

    Michael,

    Just out of curioisity can you cycle the application pool on the web services I'm curious if it is getting caught in cache somewhere.

    Cheers,
    Colin



  • Deleted product information persisting
Answer this question