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.

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.

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.

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.

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 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).