Restore Orders from Website Following Restoration of Sage Backup

If for any reason Sage is updated from a backup, you can restore orders from the website using the following procedure.

In the Woosage Control Centre go to Woosage>Utilities

1. Stop the Woosage Service 
   
2. Scroll down to Clear Database Tables and tick Orders
   
3. Click the red Clear Tables button
   
4. Go to Settings>Website and change the WooCommerce Order Window to cover the number of days you want to restore orders for, making a note of the previous setting
   
5. Click Save Settings

In the website go to WooCommerce>Orders

1. Using the checkbox in the first column, tick the all the orders you want to restore
   
2. Use the Bulk Actions dropdown at the top of the page and select Mark Not Exported To Sage
   
3. Click the Apply button next to the dropdown
   

In the Woosage Control Centre go to Woosage>Utilities

1. Start the Woosage Service 
   

The orders should then be re-imported to Sage.

When complete restore the WooCommerce Order Window to it previous setting

• Related Articles

• Failed Orders

  WooCommerce SKU codes must match the Sage Product Codes for each order line item, otherwise, the order will fail to import to Sage, even if there are correct order line items within the order.   Orders will also fail if the Sage Account Code is not ...

• Woosage50 Orders Settings

  WooCommerce order are imported in to Sage according to the setting in Settings>Orders. The settings are shown below and this article provides additional information to supplement the tooltips. Order status options - select all the status conditions ...

• Bulk Import of Sage Account Codes from Sage to Wordpress

  Introduction Assuming you have first installed the Woosage plugin on your website, you can add Sage Accounts Code to User Profiles. Warning. If you are making changes to a live website we strongly advise you to take a database backup prior to ...

• Creation of new website products from Sage

  Woosage has a feature that allows you to create new product in WooCommerce from Sage. However, as WooCommerce has comprehensive product presentation features that are not present on Sage, such as short & long descriptions, attributes and variations, ...

• Order Information Posted to Sage

  Woosage posts information from the WooCommerce Orders into Sage Sales Orders or Invoices in the following sections (as per Sage Order tabs): Details Billing address details are posted unless the billing address override is off, using the settings ...