Export Orders

Overview

Sellercloud allows you to export order information into files. This can be useful for multiple reasons – most commonly, syncing with third-party services or backing up your data. In this article, you will learn how to export orders and understand the different export options.


Export Options

There are different ways to export orders from Sellercloud. The table below describes each option:

Order Export MethodExported DataSupported File FormatsAdditional Customization
Standard FormatThis option exports a predefined set of the most commonly used Sellercloud order data. You can’t determine which specific data to export.
  • .xlsx – Excel spreadsheets.
  • .csv – Comma-separated values files.
  • .txt – Tab-delimited text files.
Not possible.
Export Mapping ToolThis option exports a custom set of Sellercloud order data that is based on your selected Export Mapping Profile. For details about the order data you can export, see Export Mapping Columns.
  • .xlsx – Excel spreadsheets.
  • .csv – Comma-separated values files.
  • .txt – Tab-delimited text files.
Not possible.
PluginThis is the most flexible option. When the above options are not sufficient, you can request a custom plugin that exports any order data of your choice. Building a new customization is considered a billable service. See Sellercloud Pricing for more information.The file type of the export is based on your plugin.Open a ticket to Sellercloud Support with your requirements, and you will receive an estimate of the final cost.
With a custom plugin, you can also modify orders upon export, allowing for more complicated tasks, such as splitting an order, changing warehouses, and more, based on your desired conditions and actions. Open a ticket with Sellercloud Support to request such a plugin.

Standard Format Columns

The Standard Format export option uses a template that provides the following order information:

Standard Format Export Columns
  • OrderID – The Sellercloud order ID, commonly found on the Manage Orders Page or the Order Details Page.
  • OrderItemID – The unique order-specific line item ID of the original SKU on the order.
  • KitItemID – The component SKU (or original reference ID coming from the channel).
  • UserID – The unique numerical ID of the customer.
  • UserName – The customer’s email address.
  • eBayUserID – Your eBay seller account’s username.
  • FirstName – The customer’s first name.
  • LastName – The customer’s last name.
  • CompanyName – The name of the customer’s company.
  • SiteCode – The country code of the marketplace.
  • TimeOfOrder – The date when the order was placed.
  • SubTotal – The total amount charged for the ordered items before any discounts, tax, shipping, etc.
  • ShippingTotal – The total amount charged for shipping.
  • OrderDiscountsTotal – The total of all discounts applied to the order. 
  • ShippingDiscountsTotal – The total of all discounts applied to the shipping cost. 
  • HandlingFee – Expenses for order handling, including warehouse storage costs, shipment costs, packing costs, and more.
  • InsuranceTotal – The amount the buyer paid for order insurance.
  • GiftWrapCharge – The amount the buyer paid for Gift Wrapping.
  • DropShipFeeTotal – The fee charged by the vendor for dropshipping.
  • GrandTotal – The total amount of the order, calculated as follows: (Subtotal + Shipping Total + Handling + Insurance + Gift Wrap + Tax) – (Discount + Shipping Discount).
  • Status – The order’s general processing status.
  • PaymentStatus – The payment status shows whether the order has been fully paid, partially refunded, or awaiting payment.
  • PaymentDate – The date when the payment for the order was made.
  • PaymentReferenceNumber – The unique reference number of the payment.
  • PaymentMethod – The payment method used for the order.
  • ShippingStatus – The order’s shipping status. 
  • ShipDate – The date when the order was shipped.
  • ShippingFee – The fee owed for shipping the order.
  • ShipFirstName – The shipping recipient’s first name.
  • ShipLastName – The shipping recipient’s last name.
  • ShipCompanyName – The name of the company receiving the shipment.
  • ShipAddress1 – The first line of the shipping address.
  • ShipAddress2 – The second line of the shipping address.
  • ShipCity – The city of the shipping address.
  • ShipState – The state code of the shipping address.
  • ShipZipCode – The postal code of the shipping address.
  • ShipCountry – The country code of the shipping address.
  • ShipPhoneNumber – The shipping recipient’s phone number.
  • BusinessName – The name of the customer’s company, specifically for Wholesale orders.
  • OrderShippingPromiseDate – The Ship-By Date by which you need to ship the order before the channel marks it as late shipping. 
  • OrderSource – The source channel from which the order originated.
  • OrderSourceOrderID – The source channel’s unique identifier for the order.
  • OrderCurrency – The order’s currency.
  • eBaySalesRecordNumber – The unique identifier assigned by eBay to each individual transaction.
  • ShippingMethodSelected – The shipping method selected on the order.
  • IsRushOrder – Indicates if the customer has paid extra to upgrade the shipping service. See Rush Order for more information.
  • InvoicePrinted – Indicates if an Invoice has been printed for the order.
  • InvoicePrintedDate – The date when the invoice has been printed.
  • ShippingCarrier – The shipping carrier selected on the order.
  • PackageType – The type of packaging used for shipping.
  • CompanyID – The company’s unique identification number in Sellercloud.
  • OrderSourceOrderTotal – The total amount of the order from the source channel.
  • StationID – The unique identification number of the shipping Station.
  • CustomerServiceStatus – Indicates the actions needed from customer service.
  • TaxRate – The rate at which tax is applied to the order.
  • TaxTotal – The total amount paid for tax.
  • GoogleOrderNumber – The order number on Google Shopping.
  • IsInDispute – Indicates if the order has been disputed on eBay.
  • DisputeStartedOn – The dispute’s start date.
  • PaypalFeeTotal – The amount charged by PayPal for payment processing.
  • PostingFeeTotal – The amount charged by the channel for posting the ordered product.
  • FinalValueTotal – The order’s Final Value Fee.
  • ShippingWeightTotalOz – The total weight of the shipment in ounces.
  • ProductID – The unique Sellercloud SKU of a product on the order.
  • Qty – The number of product units on order.
  • DisplayName – The product name.
  • LineTotal – The total cost associated with a single line item on the order.
  • eBayItemID – The unique identifier for an item on eBay.
  • BackOrderQty – The item quantity that is on Backorder.
  • OriginalUnitPrice – The original unit price of the item before any adjustments or discounts.
  • OriginalShippingCost – The original cost of shipping before any adjustments or discounts.
  • AdjustedUnitPrice – The updated unit price of the item after discounts and adjustments.
  • AdjustedShippingCost – The updated cost of shipping after discounts and adjustments.
  • TrackingNumber – The tracking number for an order’s shipment.
  • SerialNumber – The ordered item’s Serial Number.
  • InventoryAvailableQty – The quantity of the ordered item that is available in inventory.
  • LocationNotes – Notes related to the ordered item’s Location.
  • UPC – The ordered item’s UPC.
  • MarketingSource – The channel through which the marketing was conducted.
  • ShippedBy – The username of the employee who shipped the order.
  • DeliveryDate – The order’s Delivery Date.
  • ShipFromWarehouse – The warehouse from which the order is shipped.

Export Orders

You can export orders manually with an action or automatically with a Scheduled Task. Both options require you to select one of the Export Options described in the previous section.

Manually

To export a single order:

  1. Go to the Order Details Page.
  2. Click Actions and select Export Orders.
  3. Select from these options:

    1. Standard: For a standard export, select Standard and choose your desired file type.
    2. Plugin: For a plugin export, select Plugin and then choose the plugin.
    3. Mapping Profile: For a mapping profile export, select Mapping Profile and then choose the profile.
    4. Optionally, check Mark Orders as Exported if you need to track which orders have been exported. This changes the value of the Is Exported status to True.
  4. Click Export, and a Queued Job will be created.
  5. Next, you have two options:
    1. Click the link in the success message at the bottom of the screen to access the Queued Job. Once the job finishes, you can refresh the page and click the Download icon to the right of the Output File.
    2. Wait for the Notification, which confirms that the job has been processed, and click Download File.

To export multiple orders:

  1. Go to Orders > Manage Orders.
  2. Find and select the orders.
  3. Click the Actions button and select Export Orders.
  4. Select from these options:

    1. Standard: For a standard export, select Standard and choose your desired file type.
    2. Plugin: For a plugin export, select Plugin and then choose the plugin.
    3. Mapping Profile: For a mapping profile export, select Mapping Profile and then choose the profile.
    4. Optionally, check Mark Orders as Exported if you need to track which orders have been exported. This changes the value of the Is Exported status to True.
  5. Click Export, and a Queued Job will be created.
  6. Next, you have two options:
    1. Click the link in the success message at the bottom of the screen to access the Queued Job. Once the job finishes, you can refresh the page and click the Download icon to the right of the Output File.
    2. Wait for the Notification, which confirms that the job has been processed, and click Download File.

Automatically

To automate an order export:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. Complete as follows:

    1. Click Task Type and select Export Orders.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. Click the link in the success message at the bottom of the screen to configure the task details.
  5. Click the Edit button on the top right.
  6. In the Details section:

    1. Click the User ID menu and select your username.
    2. Click the Saved Search menu and select a Saved View created to target specific orders.
    3. Click the Export Via menu and select General Format to export common order data to an Excel spreadsheet in .xlsx format. You can also select a Plugin or a Mapping Profile.
    4. Optionally, you can check Mark Orders As Exported if you need to track which orders have been exported. This will change the value of the orders’ Is Exported status to True.
  7. Configure the Export Options section per your preference.
  8. In the Frequency section, specify the task frequency.
  9. In the General section, click the Enable toggle button.
  10. Click Save on the top right.

These Client Settings affect order exports:

  • Export Kit Parent Only When Exporting Orders – When you export orders with Kit Products, kit components will be excluded from the file, and only the kit parents will be included.
  • Show Zero Price For Kit Items In Order Export – When you export orders with kit products, the prices of the kit components in the exported file will be 0. This setting doesn’t affect the prices of kit parents.
  • Enable Order Exported Workflow – Enable the Is Exported order status and its associated actions on the Order Details Page (Set Exported and Set Not Exported), the Manage Orders page, and the checkbox Mark Orders As Exported on the scheduled tasks page. This status can also be updated with the Order Rule Engine.
  • Always Mark Orders Exported After Generating Order Export File – When you export orders to a file, the orders’ Is Exported status will be set to True.
  • Mark Orders As Expoted When Exported Via Scheduled Task – When a Scheduled Task exports orders to a file, the orders’ Is Exported status will be set to True.
  • Default Order Export Plugin – Set a default plugin that will be automatically preselected each time you export orders. You can still view your plugins list and manually select any other plugin from it.
  • Enable Order Export In Yugster Format – Enable the Export in Yugster Format action on the Manage Orders page, which exports orders in a .csv format with headers compatible with UntilGone. See UntilGone Account Integration to learn how to fully integrate this channel.

Was this article helpful?

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