BoB1 Changeover

When switching over to BoB2 and after running eBay Order import for the first time we need to use this SQL as a way of drawing the line between the two systems.
UPDATE
    [Order]
SET
    OrderStatusId = 40
FROM
    [Order]
    LEFT JOIN eBay_Order ON [Order].id = ebay_order.nopOrderId
WHERE
    eBay_Order.SellingManagerSalesRecordNumber <= X
Updated on 2 June 2023

Was this article helpful?

Related Articles

Leave a Comment