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


  • 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

    Copy Link
  • 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

    Copy Link
  • Warren Harding 132 posts 275 karma points
    Sep 23, 2021 @ 23:36
    Warren Harding
    0

    Awesome thank you

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft