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 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 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 in your file must not be Bin-Enabled. 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 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 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.

You must select a Ship From warehouse that is not Bin-Enabled. 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 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. You will receive a Notification once the job is complete.

Back to top