Import Orders


Overview

Orders can be imported automatically from popular marketplaces as well as from many shopping carts. Each channel is different and requires its own method for order importing. You can import orders from marketplaces that are not integrated with Sellercloud, or from a database, by using the Order Import tool. Wholesale orders can be imported as well. Note that you have two types of orders: manual orders and channel orders.


Manual Orders

You can import manual orders either via a profile or a Wholesale channel.

Via Profile

  1. Go to Orders > Tools > Import Order Info > Import Orders Via Profile.
  2. Select a company, a profile, import a template file, and press Import.The image shows the Import Orders via Profile tab

Via Wholesale Channel

  1. Go to Orders > Tools > Import Order Info > Import Channel Orders.
  2. In the Import Channel Orders panel, select a Company and Wholesale in the Channel field.
  3. Click the Download template icon and populate the fields in the downloaded file. Read more about this in the Populate the Template section below.
  4. Import the saved file and click Import.The image shows the Wholesale orders import.

Import Orders via Plugins

You can import orders based on the plugin they use.

  1. Go to Orders > Tools > Import Order Info > Import Orders Via Plugins.
  2. Select a company and a plugin.
  3. In the file field, upload a template format that corresponds to the plugin itself. If unsure about the template format, contact Sellercloud support.
  4. Click Import.

Channel Orders

  1. Go to Orders > Tools > Import Order Info > Import Channel Orders.
  2. In the Import Channel Orders panel, select a company and a channel.
  3. Click the Download template icon and populate the fields in the downloaded file. Read more about this in the Populate the Template section below.
  4. Import the saved file and click Import.The image shows the download channel order panel.

Download Orders from Channel

You can download orders directly from a channel instead of populating and importing the template. To do so, go to Orders > Tools > Download Orders from Channel  > Select an option. Note that every channel has different options. The table below provides information on all of them.

Options Descriptions
Company Selects the company of the orders.
eBay Site Selects the eBay site (e.g. USUK, etc).
eBay Item ID Allows you to enter the IDs of the desired eBay items.
Order Source OrderID List Allows you to enter the Order ID list.
Use Large Merchant Services Allows to send large amounts of inventory to eBay and download multiple order information.
Data Range Sets a data range for the downloaded orders.
Download FBA Orders Enables download for FBA orders.
Website Selects the website for orders downloaded from website plugins.
Order IDs List Allows you to enter the Order IDs list.
Download WFS Orders Enables the download of Walmart Fulfillment Services orders.
Delivered

Populate the Template

Populating all of the fields is optional, but the column headers must remain in the template when importing an order. For multi-item orders, every line item should be inserted onto a separate row with all required columns filled out on each respective row.

The image shows the Excel template.

  • The OrderID will import as the OrderSourceOrderID. The system will assign a Sellercloud Order ID.
  • The orders will come in as Paid.
  • If you don’t fill out the price of the item being ordered, the plugin will pull the Site Price from that product in Sellercloud. If Site Price is zero, the order will come in as Unpaid.
  • Multi-item orders will import as one order (that is, they will not be split into separate orders).
  • The RushOrder column can hold either a 1 or a TRUE to mark the order as rush. Anything else (or just leaving it empty) will set the order to NOT rush.
  • ShipFromWarehouseName should be the name of the warehouse that you want the inventory to be deducted from. This column is optional.
  • If you don’t fill in ProductDescription, it will pull the product name from the SKU being ordered.
  • If you don’t fill out ShipToEmail, Sellercloud will automatically generate an email as OrderSourceOrderID@sellercloud.com
  • If you decide to fill them out, ShippingCarrierRequested and ShippingMethodRequested must be filled out exactly as how they are spelled on the dropdowns on the Ship Items page (located from the Action menu on each order).

 

Importing orders

Orders can be imported automatically from popular marketplaces as well as from many shopping carts. Each channel is a little bit different and requires its own method for order importing. You can import orders from marketplaces that are not integrated with Sellercloud, or from a database, by using the Order Import tool. Wholesale orders can be imported as well. 

The instructions below detail how to use the standard Sellercloud import format. However, you can import a file that is formatted differently by using the Order Import Mapping Tool.

  1. Go to Orders > Import Orders.
  2. Select a Company.
  3. Click Channel > Website.
  4. Select General Format from the Cart Type. Use this template even when importing wholesale orders.
  5. Download Sample. Always use this exact template and always in an xls or xlsx format.
    Populate required fields:

    1. OrderID— This ID will import as the OrderSourceOrderID. The system will assign a
    2. Sellercloud order ID.
    3. OrderDate
    4. ShipFirstName
    5. ShipLastName
    6. ShipCity
    7. ShipStateCode
    8. ShipZipCode
    9. ProductID
    10. QtyPurchased
  6. For multi-item orders, every line item should be inserted onto a separate row with all the required columns filled out out on each respective row.
  7. Save File.
  8. Select Channel > Website. Click Cart Type > General Format.
  9. Choose the file > Process Order.

Was this article helpful?