Multi-site

This topic describes how to set older orders to the site ID on the order.

For customers upgrading sites to use the new site functionality with historical orders, old orders must properly set the site ID on the order. 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)

Updated about 2 months ago