For customers upgrading sites to use the new site functionality with historical orders, old orders need to properly set the site ID on the order. Please use the following scripts as a starting point. You must implement your own logic to determine which orders belong to which sites.
--Update orders Update OrderGroup set SiteId = '' where OrderGroupId in (Select ObjectId from OrderGroup_PurchaseOrder) --Update subscriptions Update OrderGroup set SiteId = '' where OrderGroupId in (Select ObjectId from OrderGroup_PaymentPlan)
Updated 4 months ago