Sign in Register
Go to solution
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.

  • Zac 223 posts 575 karma points
    Apr 18, 2011 @ 16:11
    Zac
    0

    Clearing test products and baskets

    Hi Søren et al,

    Is the following SQL from here still relevant to v1.5.0.2? i.e. can I use this to clean up the products and baskets?

    --DELETE PURCHASEORDERS AND ASSOCIATED DATA
BEGIN TRAN
UPDATE uCommerce_PurchaseOrder SET BillingAddressId = NULL
DELETE FROM uCommerce_Shipment
DELETE FROM uCommerce_OrderAddress
DELETE FROM uCommerce_OrderProperty
DELETE FROM uCommerce_OrderLine
DELETE FROM uCommerce_Payment
DELETE FROM uCommerce_OrderStatusAudit
DELETE FROM uCommerce_PurchaseOrder
DELETE FROM uCommerce_Address
DELETE FROM uCommerce_Customer
--COMMIT

    http://www.publicvoid.dk/DeletingPurchaseOrdersAndBasketsFromTheDatabaseInUCommerce.aspx

    Many thanks,

    Zac

     

    Copy Link
  • Søren Spelling Lund 1797 posts 2786 karma points
    Apr 19, 2011 @ 10:54
    Søren Spelling Lund
    0

    Hi Zac,

    It will still work. This one is just for orders though.

    Copy Link
  • Zac 223 posts 575 karma points
    Apr 19, 2011 @ 10:55
    Zac
    0

    Oops, I meant purchase orders not products! Thanks Søren

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft