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 132 posts 275 karma points
    Sep 23, 2021 @ 03:18
    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 4125 posts 22223 karma points MVP 9x c-trib
    Sep 23, 2021 @ 14:02
    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 132 posts 275 karma points
    Sep 23, 2021 @ 23:36
    Warren Harding
    0

    Awesome thank you

Please Sign in or register to post replies

Write your reply to:

Draft