Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


These support forums are now closed for new topics and comments.
Please head on over to http://eureka.ucommerce.net/ for support.

  • Arlan 58 posts 184 karma points
    Dec 24, 2014 @ 16:48
    Arlan
    0

    Can't delete product

    I am having error "SKU already exists within catalog", however i cant find the product with this SKU.

    How would i go about deleting the product with this SKU?

     

  • Martin 181 posts 740 karma points
    Dec 28, 2014 @ 14:46
    Martin
    0

    Hi Arlan,

    I will recommend you to take a look directly in uCommerce product table through SQL Management Studio (or other tool). The table is called uCommerce_product. If the product is not in the table then try to take a look on the table design for that table and see what max length is for the field SKU (there is a chance your SKU is too long) but you have to check it through SQL manager.

    Best regards Martin

  • Arlan 58 posts 184 karma points
    Dec 29, 2014 @ 05:10
    Arlan
    0

    Hi Martin

    I connected to the table uCommerce_Product but i dont see the Sku records in there (I have over 130 products in uCommerce with 13 digit SKU numbers)
    maybe you can point me what i need to do, how would i search for a SKU number  9781935806370 in database?

     

     

  • Martin 181 posts 740 karma points
    Dec 29, 2014 @ 18:18
    Martin
    100

    Hi Arlan

    you can append WHERE Sku = '< SKU >'

    Then it should show at least one row.

  • Arlan 58 posts 184 karma points
    Dec 30, 2014 @ 05:54
    Arlan
    0

    Thank you Martin
    I was able to delete the product.
     

  • Arlan 58 posts 184 karma points
    Jan 05, 2015 @ 16:20
    Arlan
    0

    Here is what i did

    ALTER TABLE [reedypressucommerce].[dbo].[uCommerce_Product] NOCHECK CONSTRAINT [FK_uCommerce_Product_ParentProduct]

    DELETE FROM [reedypressucommerce].[dbo].[uCommerce_ProductProperty] WHERE ProductId='416'

    DELETE FROM [reedypressucommerce].[dbo].[uCommerce_ProductDescription] WHERE ProductId='416'

    DELETE FROM [reedypressucommerce].[dbo].[uCommerce_PriceGroupPrice] WHERE ProductId='416'

    DELETE FROM [reedypressucommerce].[dbo].[uCommerce_CategoryProductRelation] WHERE ProductId='416'

    DELETE FROM [reedypressucommerce].[dbo].[uCommerce_Product] WHERE ProductId='416'

    SELECT TOP 1000 [ProductId]

          ,[ParentProductId]

          ,[Sku]

          ,[VariantSku]

          ,[Name]

          ,[DisplayOnSite]

          ,[ThumbnailImageMediaId]

          ,[PrimaryImageMediaId]

          ,[Weight]

          ,[ProductDefinitionId]

          ,[AllowOrdering]

          ,[ModifiedBy]

          ,[ModifiedOn]

          ,[CreatedOn]

          ,[CreatedBy]

          ,[Rating]

      FROM [reedypressucommerce].[dbo].[uCommerce_Product]

    Instead of deleting sku i deleted the product id of that sku

Please Sign in or register to post replies

Write your reply to:

Draft