Multi-site orders
1 min
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)