# Clear Old Orders

## Overview

Maintaining accurate order data is crucial for inventory and shipping management in Sellercloud. When managing old or externally processed orders, you may need to take the following steps to ensure reliable records:

- Prevent fulfilled orders from creating inventory discrepancies by reducing your current stock levels.
- Mark orders shipped after purchasing labels outside of Sellercloud, such as directly from a carrier.
- Mark old processed orders as shipped or void without triggering unnecessary shipping notifications to the channel.
- Remove outdated or externally processed orders from the Unshipped tab in Shipbridge.

To achieve these results, you can manage your orders with the generic **Clear Old Orders Format** plugin, which:

- Imports Excel spreadsheets to update existing orders by **OrderID**.
- Enables you to change their status to **Fully Shipped** or **Void**.
- Defaults the **Ship Date** to the order date unless you set a custom date.
- Prevents unnecessary shipping updates to the source channel.
- Prevents orders from reducing your current inventory count by default, but allows you to set **DontCountInventory** to **False** to disable this option.

The plugin does not update orders to a **Fully Shipped** status when the [Shipping Warehouse](https://descartessystems.aha.io/pages/7630851404428729610) is [Bin-Enabled](https://descartessystems.aha.io/pages/7630855423338040913). If an order is assigned to a bin-enabled warehouse and an attempt is made to mark it as shipped, the plugin will skip the entry.

## Prerequisites

First, complete the following prerequisites.

To use this functionality, open a ticket with [Sellercloud Support](https://descartessystems.aha.io/pages/7630851494839563427) and request that the **Clear Old Orders Format** plugin be installed on your server.

To use the **Clear Old Orders Format** plugin, [download the spreadsheet template](https://descartessystems.aha.io/attachments/7632314667530110221) with the column headers below and complete it.

- **OrderID** – Enter the Sellercloud **Order #**. To get a list of IDs, you can [Export Orders](https://descartessystems.aha.io/pages/7630851803327164839).
- **Status** – Set the order’s status:
  - Enter **SHIPPED** to set the **Shipping Status** to **Fully Shipped** and the **Order Status** to **Completed**.
  
    The **Order Status** will only be set to **Completed** if the order's **Payment Status = Charged**. Learn more about [Order Payments](https://descartessystems.aha.io/pages/7630857728928573574).
  - Enter **VOID** to set the **Order Status** to **Void**. The **Shipping Status** will remain unchanged.
- _(Optional)_ **ShipDate** – Enter the ship date in **MM/DD/YYYY** format. If you don’t, the plugin will use the order date instead.
- _(Optional)_ **DontCountInventory**– Set to **True** to prevent orders from affecting your current inventory levels. Set to **False** to allow inventory deduction.

## Clear Old Orders

Once your spreadsheet is ready, import it:

1. Go to **Orders > Tools > Import Order Info Via File**.
2. Select **Import Orders Via Plugin**.
3. Select the **Company**.
4. Set the **Plugin** to **Clear Old Orders Format**.
5. Upload your spreadsheet **File** in **.xls** format.
6. Click **Import**. This creates a [Queued Job](https://descartessystems.aha.io/pages/7630838476388116703). You will receive a [Notification](https://descartessystems.aha.io/pages/7630838100445037077) once the job is finished.