Multi-site orders
1 min
For customers upgrading their sites to use the new site functionality with historical orders, old orders must have the site ID properly set. Use the following scripts as a starting point. You must implement your 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)