# Import Old Orders

## Overview

By default, Sellercloud automatically imports orders from your connected sales channels as you receive them. However, there are situations where you may need to **Import Old Orders** that have already been shipped for reporting or accounting purposes. Accurate historical data is crucial for generating insights, allowing you to conduct reliable performance analysis and financial audits. When importing old orders into Sellercloud, it’s essential to ensure they don’t reduce your current inventory levels or trigger unnecessary shipping updates to the respective channels.

To import your historical order data, you must open a ticket with [Sellercloud Support](https://descartessystems.aha.io/pages/7630831494839563427) and provide the prepared file containing your order information.

To handle this task, you can use the generic **General Old Orders Format XLS plugin**, which:

- Imports orders from an Excel spreadsheet.
- Prevents shipping updates to the source channel.
- Prevents orders from reducing your current inventory count by default, but you can set **DontCountInventory** to **False** to disable this option.
- Sets the orders’ **Payment Status** to **Charged** and their **Shipping Status** to **Fully Shipped**.
- Defaults the **Ship Date** to the current date unless you set a custom date.
- Defaults the **Channel** to **Website** unless you set another channel.

[Post-Order Plugins](https://descartessystems.aha.io/pages/7630851978766039997) skip orders imported by the **General Old Orders Format XLS** plugin.

Consider the following technical details:

- The plugin does not process files exceeding 10,000 lines to ensure performance stability.
- The [Shipping Warehouses](https://descartessystems.aha.io/pages/7630851404428729610) in your file must not be [Bin-Enabled](https://descartessystems.aha.io/pages/7630855423338040913). Orders imported to such warehouses will not be marked as shipped.
- Communication to the sales channel (e.g., shipping updates) will not work for any orders imported with this plugin. It should **only** be used to import orders for reporting or accounting purposes.

## Prerequisites

To import orders using this plugin, [download the spreadsheet template](https://descartessystems.aha.io/attachments/7632325579565293713) with the column headers below and complete it.

The orders you are importing must meet certain minimum requirements:

- **OrderID** – Enter the order’s unique identifier on the originating channel. Corresponds to the **Channel Order #** field in Sellercloud. The system will automatically assign a Sellercloud **Order #** upon import.

If an order with this **Channel Order #** already exists, the plugin will skip it.

- **OrderDate** – Enter the order date in **MM/DD/YYYY** format.
- **ShipFirstName** – The first name of the shipping recipient.
- **ShipAddress1** – The first line of the shipping address.
- **ShipCity** – The city of the shipping address.
- **ShipStateCode** – The state code of the shipping address.
- **ShipZipCode** – The ZIP or postal code of the shipping address.
- **ShipEmail** – The email address of the shipping recipient.
- **BillFirstName** – The first name of the billing contact.
- **BillAddress1** – The first line of the billing address.
- **BillCity** – The city of the billing contact.
- **BillStateCode** – The state code of the billing contact.
- **BillZipCode** – The ZIP or postal code of the billing contact.
- **BillEmail** – The email address of the billing contact, also used as the **Customer Email**. If you don’t enter it, the **Customer Email** will be generated following this format: **OrderSourceOrderID@sellercloud.com**

The column headers outlined below are recommended but **optional**– you can leave them blank. However, your spreadsheet must include these headers even if you don’t use them.

- **ChannelID** – Enter a channel ID to set the order’s **Channel**. If you don’t set a value for this column, the plugin will default the **Channel** to **Website**. Click the dropdown for a list of all accepted channel IDs.

- Local\_Store = 0
  - eBayOrder = 1
  - eBaySingleItem = 2
  - Yahoo = 3
  - Amazon = 4
  - PriceGrabber = 5
  - Website = 6
  - Buy = 7
  - NewEggMall = 12
  - Magento = 15
  - QuickBooks = 16
  - RMS = 17
  - Cart32 = 18
  - Sears = 19
  - FBA = 20
  - Wholesale = 21
  - Overstock = 22
  - NewEggdotcom = 23
  - Etsy = 24
  - Bonanza = 25
  - PriceFalls = 26
  - Wayfair = 27
  - UnbeatableSale = 28
  - VendorCentral = 29
  - Hayneedle = 30
  - SmartBargains = 31
  - uBid = 32
  - ATGStores = 33
  - StacksAndStacks = 34
  - Sharkstores = 35
  - BestBuy = 36
  - Kohls = 37
  - Staples = 38
  - OneStopPlus = 39
  - Meijer = 40
  - Sonsi = 41
  - Walmart = 42
  - HSN = 43
  - NewEgg\_Business = 44
  - KMart = 45
  - Wish = 46
  - SPRichards = 47
  - FingerHut = 48
  - Groupon = 49
  - Walmart\_Marketplace = 50
  - ShopHQ = 51
  - PriceMinister = 52
  - GS = 53
  - DrugStore = 54
  - MercadoLibre = 55
  - JET = 56
  - ElevenMain = 57
  - SearsVendor = 58
  - Choxi = 59
  - TradeMe = 60
  - Tanga = 61
  - Target = 62
  - GrouponMarketplace = 63
  - Reverb = 64
  - BedBathAndBeyond = 65
  - Dropship\_Central = 66
  - DSW = 67
  - Houzz = 68
  - Gilt = 69
  - BestBuyDS = 70
  - TopHatter = 71
  - HomeDepot = 72
  - MassGenie = 73
  - Cdiscount = 74
  - GrouponGateway = 75
  - SBN = 76
  - GoogleExpress = 77
  - Target\_Plus = 78
  - WFS = 79

- **DontCountInventory** – The default value is **True**, which means the order will not reduce your inventory. For the order to reduce your current inventory, set to **False**.
- **ShipDate** – Enter the shipping date in **MM/DD/YYYY** format. If you don’t, the plugin will use the current date.
- **ChannelOrderNumber2** – Sets **Channel Order # (2)**, a second order identifier from the sales channel.
- **ProductID** – The unique Sellercloud identifier (SKU) of a product in the order.
- **ProductDescription** – The name of the product in the order. If you don’t enter a value here, the product name of the ordered SKU will be applied.
- **QtyPurchased** – The quantity of the purchased product.
- **UnitPrice** – The unit price of the product. If you don’t enter the **UnitPrice** of the ordered product, the [Site Price](https://descartessystems.aha.io/pages/7630845832590662069) will be applied. If the **Site Price** is **0**, the order will come in with **No Payment**.
- **Tax** – The tax on the order.
- **ShippingTotal** – The total cost of shipping for the order. Alternatively, you can name this column **ShippingCost**.
- **ShipFromWarehouseName** – The name of the [Shipping Warehouse](https://descartessystems.aha.io/pages/7630851404428729610).

You must select a **Ship From** warehouse that is not [Bin-Enabled](https://descartessystems.aha.io/pages/7630855423338040913). A bin cannot be determined automatically upon import, and orders assigned to such warehouses will not be marked as shipped.

- **ShippingMethodRequested** – The requested shipping method for the order.
- **ShippingCarrierRequested** – The requested carrier for shipping the order.

Make sure to enter the **ShippingCarrierRequested** and **ShippingMethodRequested** exactly as spelled in the dropdowns on the **Ship Items** page, accessible from the **Actions** menu on each order.
- **RushOrder** – Enter **True** if it is a [Rush](https://descartessystems.aha.io/pages/7630851295162501658) order; otherwise, enter **False**.
- **ShipCompanyName** – The company name associated with the shipping address.
- **ShipLastName** – The last name of the shipping recipient.
- **ShipAddress2** – The second line of the shipping address.
- **ShipCountry** – The country of the shipping address.
- **ShipPhone** – The phone number of the shipping recipient.
- **BillCompanyName** – The company name associated with the billing contact.
- **BillLastName** – The last name of the billing contact.
- **BillAddress2** – The second line of the billing address.
- **BillCountry** – The country of the billing contact.
- **BillPhone** – The phone number of the billing contact.

## Import Old Orders

Once your spreadsheet is ready, you can import your orders:

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 **General Old Orders Format XLS**.
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 complete.

[Back to top](https://help.sellercloud.com/sellercloud-knowledge-base/orders/order-management/import-old-orders~7630852759901615923#top)