Warehouse Connector Help Return to Warehouse Connector App
GitHub
  • Warehouse Connector Overview
  • Manage Sales Orders
    • Order Flow
    • Common Error States
    • How do I sort or search an order?
    • How do I create an order?
    • How do I update an order?
    • How do I print an order invoice?
    • How do I hold an order?
    • How do I unhold an order?
    • How do I archive an order?
    • How do I delete an order?
    • How do I clear order errors?
    • How do I export orders to a CSV file?
  • Manage Purchase Order
  • Manage Products
  • Manage Customers
  • Configure General Settings
  • Shopify Store Integration
  • Amazon Store Integration
  • NetSuite Integration
  • MasonHub Integration
  • GLO/NAV Integration
  • Impress Integration

# How do I export orders to a CSV file?

Warehouse Connector allows you to export a comma-separated values (CSV) spreadsheet of your orders from the Sales Orders page.

To export orders to a CSV file:

  1. On the Sales Orders page, click Export.export Orders CSV

  2. On the Reports page, select the order Status for which you want to generate the CSV file. Select **All **if you want to generate the file for all the order statuses.select the order status

  3. Select the store Source for which you want to generate the CSV file. Select **All **if you want to generate the file for all the store sources.store source

  4. Select the option for the orders that you want to export. For example, if you want to export your order data by date, then select the Orders by date option and set the start and end dates for the orders that you want to export. Select All orders if you want to export the data for all the orders.generate report

  5. Click Generate Report.

    The generated CSV is available in the Order Reports section as follows.Orders CSV

Order export CSV structure

The following table describes the format of the CSV file that will be created when you export orders.

Field Description
Source Order Number The order number from the source such as Shopify.
Name The name of the customer.
Email The customer's email address.
Phone The customer's phone number.
Order Date The date when the order was placed.
SKU The product's stock keeping unit that is unique to the product.
UPC The universal product code.
Title The title of the product.
Vendor The line item product vendor.
Warehouse The physical warehouse where the product is stored.
Price The price of the product.
Quantity The quantity of the product.
Reference Number A number that is generated by a destination channel, such as 3PL partner, where order is sent.
Order Source The source from which the order was made, such as Shopify.
Shipping Code The shipping code, such as UPSGND for the UPS Ground.
Source Shipping The shipping source, such as UPS.
Order Status Current status of the order.
Tracking Number The carrier-specific tracking number that can be used to track the Shipment.
Ship Date The date when the order was shipped.
Shipping Cost The cost of shipping.
Error The errors if any.
Error Message The error message.
Archived Indicates whether the order is archived.

← How do I clear order errors? How do I sort or search a purchase order? →

Didn’t find what you are looking for?
Tell us about your project Learn how you can keep your business competitive in an app-connected world. File a support ticket File a support ticket for critical issues that require a higher level of support.
Warehouse Connector © 2020