Multi-site orders
Set older orders to the site ID on the order.
When upgrading sites with historical orders to the multi-site functionality, set the site ID on each existing order. Use the following scripts as a starting point. 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 22 days ago