INSERT INTO `tbl_ShopifyOrders_Fact`(
    `f_Name`,
    `Email`,
    `Financial Status`,
    `Paid At`,
    `Fulfillment Status`,
    `Fulfilled At`,
    `Accepts Marketing`,
    `Currency`,
    `Subtotal`,
    `Shipping`,
    `Taxes`,
    `Total`,
    `Discount Code`,
    `Discount Amount`,
    `Shipping Method`,
    `Created At`,
    `Lineitem Quantity`,
    `Lineitem name`,
    `Lineitem Price`,
    `Lineitem Compare At Price`,
    `Lineitem sku`,
    `Lineitem requires shipping`,
    `Lineitem taxable`,
    `Lineitem fulfillment status`,
    `Billing Name`,
    `Billing Street`,
    `Billing Address1`,
    `Billing Address2`,
    `Billing Company`,
    `Billing City`,
    `Billing Zip`,
    `Billing Province`,
    `Billing Country`,
    `Billing Phone`,
    `Shipping Name`,
    `Shipping Street`,
    `Shipping Address1`,
    `Shipping Address2`,
    `Shipping Company`,
    `Shipping City`,
    `Shipping Zip`,
    `Shipping Province`,
    `Shipping Country`,
    `Shipping Phone`,
    `Notes`,
    `Note Attributes`,
    `Cancelled At`,
    `Payment Method`,
    `Payment Reference`,
    `Refunded Amount`,
    `Vendor`,
    `Outstanding Balance`,
    `Employee`,
    `Location`,
    `Device ID`,
    `Id`,
    `Tags`,
    `Risk Level`,
    `Source`,
    `LineItem Discount`,
    `Tax 1 Name`,
    `Tax 1 Value`,
    `Tax 2 Name`,
    `Tax 2 Value`,
    `Tax 3 Name`,
    `Tax 3 Value`,
    `Tax 4 Name`,
    `Tax 4 Value`,
    `Tax 5 Name`,
    `Tax 5 Value`,
    `Phone`,
    `Receipt Number`,
    `DateImported`,
    `myUID`
)
SELECT
    (
        `Name`,
        `Email`,
        `Financial Status`,
        `Paid at`,
        `Fulfillment Status`,
        `Fulfilled at`,
        `Accepts Marketing`,
        `Currency`,
        `Subtotal`,
        `Shipping`,
        `Taxes`,
        `Total`,
        `Discount Code`,
        `Discount Amount`,
        `Shipping Method`,
        `Created at`,
        `Lineitem quantity`,
        `Lineitem name`,
        `Lineitem price`,
        `Lineitem compare at price`,
        `Lineitem sku`,
        `Lineitem requires shipping`,
        `Lineitem taxable`,
        `Lineitem fulfillment status`,
        `Billing Name`,
        `Billing Street`,
        `Billing Address1`,
        `Billing Address2`,
        `Billing Company`,
        `Billing City`,
        `Billing Zip`,
        `Billing Province`,
        `Billing Country`,
        `Billing Phone`,
        `Shipping Name`,
        `Shipping Street`,
        `Shipping Address1`,
        `Shipping Address2`,
        `Shipping Company`,
        `Shipping City`,
        `Shipping Zip`,
        `Shipping Province`,
        `Shipping Country`,
        `Shipping Phone`,
        `Notes`,
        `Note Attributes`,
        `Cancelled at`,
        `Payment Method`,
        `Payment Reference`,
        `Refunded Amount`,
        `Vendor`,
        `Outstanding Balance`,
        `Employee`,
        `Location`,
        `Device ID`,
        `Id`,
        `Tags`,
        `Risk Level`,
        `Source`,
        `Lineitem discount`,
        `Tax 1 Name`,
        `Tax 1 Value`,
        `Tax 2 Name`,
        `Tax 2 Value`,
        `Tax 3 Name`,
        `Tax 3 Value`,
        `Tax 4 Name`,
        `Tax 4 Value`,
        `Tax 5 Name`,
        `Tax 5 Value`,
        `Phone`,
        `Receipt Number`,
        `DateImported`,
        `myUID`
    )
FROM
    `tbl_ShopifyOrders_Staging`
WHERE
    `tbl_ShopifyOrders_Staging`.myUID NOT IN(
    SELECT
        myUID
    FROM
        `tbl_ShopifyOrders_Fact`
);