Searching...

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 handle this task, you can use the generic General Old Orders Format XLS plugin, which:

  • Imports orders from an Excel spreadsheet.
  • Prevents unnecessary 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.
The plugin does not process files exceeding 10,000 lines to ensure performance stability.

Prerequisites

First, complete the following prerequisites.

To use this functionality, open a ticket with Sellercloud Support and request that the General Old Orders Format XLS plugin be installed on your server.

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 create a new order with the same Channel Order #.
  • 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: [email protected]

Filling out the cells under the following column headers is 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 drop-down below for a list of all accepted channel IDs.

    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 ‘Old NoMoreRacks
    • 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. To have the order reduce your current inventory, set it 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.
  • 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.

Was this article helpful?

Yes No
Need Support?
Can't find the answer you're looking for?
Contact Support