Copied to clipboard

Flag this post as spam?

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


  • Warren Harding 78 posts 184 karma points
    26 days ago
    Warren Harding
    0

    Remove old test order before release

    Is it possible to simply truncate the vendrOrder* tables to remove the old test oders?

    Are there any other tables we would need to alter as well?

    Thank you

  • Matt Brailsford 3240 posts 17128 karma points MVP 8x c-trib
    26 days ago
    Matt Brailsford
    100

    Hi Warren,

    I think this should probably cover everything, but yea, it's basically all vendrOrder* tables

    TRUNCATE TABLE vendrOrderAmountAdjustment
    TRUNCATE TABLE vendrOrderPriceAdjustment
    TRUNCATE TABLE vendrOrderAppliedDiscountCode
    TRUNCATE TABLE vendrOrderAppliedGiftCard
    TRUNCATE TABLE vendrOrderLineAttribute
    TRUNCATE TABLE vendrOrderLineProperty
    TRUNCATE TABLE vendrOrderLine
    TRUNCATE TABLE vendrOrderProperty
    TRUNCATE TABLE vendrOrder
    

    Matt

  • Warren Harding 78 posts 184 karma points
    25 days ago
    Warren Harding
    0

    Awesome thank you

Please Sign in or register to post replies

Write your reply to:

Draft