Import Order Information From a File

Import Order Information From a File

Overview

With Sellercloud, you can import orders automatically from most popular marketplaces and shopping carts. However, sometimes, you may have to import orders manually. For example, you may have to import orders or specific order-related information from marketplaces that are not integrated with Sellercloud or from an external database. Wholesale orders can be imported as well. You can do this using Sellercloud’s Order Import tool. To access the Order Import tool, go to Orders > Tools > Import Order Info Via File. Then, check the next sections of this article for more details about each option in the tool. The Order Import tool offers the following options:

You may also be able to download orders to Sellercloud directly from a channel without manually importing a file. See Download Orders From a Channel for more information.

Import Orders

There are a few different ways to import orders from a file. You can import orders from specific channels supported by the import feature, create custom mappings and import from other channels, or even use an order import plugin.

Via Profile

If you can’t import orders from your channel using the Import Channel Orders option because the channel is not on the list, you can still import your orders using an Import Mapping Profile. The mapping profile allows you to Map Custom Spreadsheet Column Headers to Sellercloud Fields. The mapping process essentially makes any file with order information compatible with Sellercloud. Once you create a profile and have your orders file ready, you can import it as follows:

  1. Go to Orders > Tools > Import Order Info Via File.
  2. Select Import Orders Via Profile.
  3. Select the Company where you want to import orders.
  4. Select your import mapping Profile.
  5. Select your orders' File.
  6. Click Import.

Via Plugin

When setting up Channel Integrations Via Plugins, you usually have an Order Import plugin that automatically downloads orders from EDI, XML, or other files using Scheduled Tasks. However, you can also use Order Import plugins to manually import orders from supported files.

  1. Go to Orders > Tools > Import Order Info Via File.
  2. Select Import Orders Via Plugin.
  3. Select the Company where you want to import orders.
  4. Select your order import Plugin.
  5. In the File field, upload a file format that the plugin works with.
  6. Click Import.

Channel Orders

Since each channel is different, the file templates you can use to upload channel orders include different column headers. In general, you need to download the orders directly from your channel first. Sellercloud also includes downloadable templates for some channels supported by the Import Channel Orders feature. You can import orders from the following channels:

To import channel orders:

  1. Go to Orders > Tools > Import Order Info Via File.
  2. Select Import Channel Orders.
  3. Select a Company.
  4. Select a Channel.
  5. If there’s a template available for your channel, you can click the Download Template icon and populate the fields in the file.
  6. Click File and select your orders' file.
  7. Click Import.

Wholesale Orders

To import wholesale orders:

  1. Go to Orders > Tools > Import Order Info Via File.

  2. Select Import Channel Orders.

  3. Select a Company.

  4. Set the Channel to Wholesale.

  5. Click the Download Template icon and populate the fields in the file. You don’t need to populate all the fields in the template, but be sure not to remove any column headers. Check below for more information about the template.

  6. Click File and select your order file.

  7. Click Import.

For multi-item orders, every line item should be inserted into a separate row with all required columns filled out on each respective row. Multi-item orders will be imported as one single order (they will not be split into separate orders).

Here are some important details about the column headers in the order import template:

Import Shipping Costs

Shipping rates quoted by your carrier are estimates based on your supplied information. Other shipping charges may apply, and your final Shipping Cost may differ from the estimate, which will cause discrepancies in your orders’ Profit and Loss. Sellercloud allows you to correct such discrepancies by manually importing order shipping costs in bulk. See Import Order Shipping Cost for more information on this topic.

Import Tracking

When dropshipping, vendors often send tracking information in a file. Sellercloud provides a template you can use to import tracking information, such as the shipping date, carrier name, shipping method and cost, and more. Note that the tracking information will be imported to the customer order, not the auto-generated PO enabled by the dropshipped request. It will be uploaded to the channel with the next automatic feed. See Tracking Import for Orders and POs for more information on this topic.

Import Other Order Information

Other than orders, tracking, and shipping costs, Sellercloud also allows you to replace order SKUs and import Amazon transparency codes or P&L adjustments in bulk. Refer to the lists below for descriptions of the column headers you must fill out in each spreadsheet template. Import Bulk Replace Order SKUs File - Replace any products on order in bulk.

Import Amazon Transparency Codes - Import Amazon Transparency Codes used to identify individual product units and verify authenticity.

Import P&L Adjustments - Manually adjust your Orders’ P&L in bulk.