Orders

Exporting Orders

Export Orders to a CSV spreadsheet

  1. Go to Store > Orders
  2. To export all orders:
    1. Click Actions at the top right of the orders table, then click Export Orders.
  3. To export a subset of orders:
    1. Use the filters beside the search bar or click "More Filters" to see all available filtering options.
    2. As an example, to view orders that aren't fulfilled, apply a filter for Fulfillment Status or to view only shipping orders only, apply a filter for Order Delivery. If you are new to Order Filters, learn more here.
    3. Once all of your filters have been applied, click Actions > Export Orders.
    Screen Shot 2023-10-09 at 2.38.06 PM
  4. In the export modal, you can choose which CSV export you would like:

    exportOrders
    1. Order - One row for each order. Click here to download a sample.
    2. Order Detail - One row for each SKU in an Order. For example: If an order contains 2 SKUs, the order will display 2 rows in the export. Click here to download a sample.
    3. WSN 205 - Format commonly accepted by fulfillment companies. Each order or Commerce7 order shipment will display as a single row. Click here to download a sample.
    4. FedEx Ship Manager - Formatted for import to FedEx Ship Manager. Each order or Commerce7 order shipment will display as a single row. Click here to download a sample.
    5. GSO / GLS - Formatted for import to GLS. Each order or Commerce7 order shipment will display as a single row. Click here to download a sample.
    6. ShipCompliant - 1011 export formatted for import to ShipCompliant. Each SKU in an order will display as a single row. Click here to download a sample.
    7. UPS WorldShip - Formatted for import to UPS WorldShip. Each order or Commerce7 order shipment will display as a single row. Click here to download a sample.
    8. My UPS - Formatted for import to My UPS. Each order or Commerce7 order shipment will display as a single row. Click here to download a sample.

      Tip: If you require an export format not listed, we recommend exporting some of the formats above and comparing the data that you require. You might find that one of them provides you with the correct information and can be used after same manual adjustments. 
  5. Click Export Orders to begin the export.
    1. Most exports take a couple of seconds to a couple of minutes, but you'll receive an email notification when the export is complete. You can also check the status at any time by going to Bulk Actions in settings.
  6. When the export is complete, an Email Notification will sent which contains a link to download the export.

    email-5

    The download will also be available from the Bulk Actions area in settings.

    Screen Shot 2023-10-09 at 2.16.39 PM

 



FAQs

  • For the export types, what does "Each order or Commerce7 order shipment will display as a single row" mean?
    • If you haven't fulfilled any of the order in Commerce7, it will display as 1 row in the export.
    • If you've fulfilled the order inside Commerce7 in multiple shipments, in the export, the order will be broken out into those shipments. ie. The order will have 2 rows for 2 shipments or 3 rows for 3 shipments.
    • If you've fulfilled part of the order in Commerce7, the fulfilled portion will display as 1 row in the export and the unfulfilled portion will display as 1 separate row. 
  • When exporting orders for shipping carriers / fulfillment is there a way to split out orders that have more than 12 bottles into multiple rows since they will be fulfilled in more than 1 package?
    • Currently this is not possible. For most our shipping exports, one order is output to one row in the export. If however, you manually fulfill any part of the order in Commerce7 it will break out the Commerce7 shipments into multiple rows. (More info in the question above.)