Skip to main content

Exporting order data

Important

The structure of the CSV file or the column names can be updated by NewStore at any time. Consider this if you rely on this file for integration purposes.

You can export orders as a CSV file. The exported CSV file contains all order details including the products in the order, the order status, fulfillment information, the time and timezone in which the order was placed, external identifiers for the items in the order (if configured), the associate who placed the order, shipping details, prices and discounts applied, payment information, the tax calculation method, and return reasons (if any).

Permission required
This action can be performed by users with the Export orders permission.

To export order data:

  1. Set the filters to display the orders you want.

    For example, you can set filters to only display the orders from yesterday to today and at a specific location.

    Technical configuration
    The following section involves working with technical configurations and APIs. Contact your IT support team for more information.

    The filtered data is based on the default timezone configured for the tenant, even if the user's local timezone is enabled in NewStore Omnichannel Manager. See Configuring timezones .

  2. Click Export.

Technical configuration
The following section involves working with technical configurations and APIs. Contact your IT support team for more information.

To add extended order and order item attributes to the order data export, see Configuring order export .

CSV columns in the order export​

  • Channel: See channel in the glossary.

  • Status:

    note

    These statuses can differ from the statuses visible on the Orders tab .

    • pending: The item is pending and will be routed after the grace period.
    • routing: The item is being routed for delivery. See About order routing .
    • accepted: The fulfillment request for this item has been received and accepted by the fulfillment location and is being fulfilled.
    • picking: The item is being picked.
    • mispick: The associate couldn't find the item and flagged the item as mispicked. The item will be routed to another location, and the ATP for the item is set to 0, at the location. The stock on hand for the item remains unchanged.
    • on_hold: There is an issue with the item that requires a manual resolution (example: insufficient inventory)
    • packing: The item is being packed.
    • mispack: The item was found damaged. The order isrerouted , and the ATP is reduced to exclude the number of damaged items, at the location. The `stock on hand` for the item remains unchanged.
    • labeling: The item has been packed. The return and shipping labels are being added to the package. This status corresponds to the Printing status in the order detail page .
    • ready: The item is ready to be picked up by the customer or by the delivery provider.
    • shipped: The item has been shipped.
    • in_transit: The item has been given to the delivery provider. It is being routed to the right delivery center.
    • out_for_delivery: The item is being delivered to the customer.
    • delivered: The item has been delivered.
    • canceled: The item was canceled by the customer.
    • returned: The item has been returned.

  • Order Date/Time: When the order was placed.

  • Timezone: The timezone of the location where the order was placed.

  • Product Name: The name of the item. If the order contains more items, more CSV lines will reference the same order number with different Product Name values.

  • Color: The main color of the item.

  • Size: The size of the item.

  • Fulfillment Location: The ID of the location from which the item was fulfilled. It can be a store or a DC.

  • Fulfillment Type: The service level of the shipping option.

  • Carrier: The name of the shipping provider in charge of the delivery.

  • Product Net: The net price of the item.

  • Product Tax: The tax value of the item.

  • Product Subtotal: The price of the item, including taxes.

  • Shipping Cost: The cost to ship the item.

  • Currency: The currency used for the order.

  • Payment Method: This column is not supported and will be blank for every row.

  • Email: The email of the customer.

  • Billing First Name: The first name that appears on the invoice.

  • Billing Last Name: The last name that appears on the invoice.

  • Billing Phone: The phone number that appears on the invoice.

  • Billing ZIP: The ZIP code that appears on the invoice.

  • Shipping First Name: The first name field of the shipping address.

  • Shipping Last Name: The last name field of the shipping address.

  • Shipping Phone: The phone number field of the shipping address.

  • Shipping ZIP: The ZIP code field of the shipping address.

  • Product Catalog Price: The price of the item.

  • Product Price Adjustment: The aggregated discounts on the item.

  • Product Discounted Price: The final price of the item after applying the price adjustment value.

  • Applied Coupon Code: The coupon code that was applied on the order.

  • Reason for Discount: The reason of the discount.

  • Reason for Return: The reason why the customer returned the item.

  • Associate Name: The name of the associate who took care of the order.

  • Associate Email: The email address of the associate who took care of the order.

  • Tax Strategy: The tax calculation service used for this order.

  • Demand Location: See demand location.

  • Customer Display ID: The human-readable identifier for the customer associated with the order. Displayed as Customer ID in the customer profile and in the order details.

  • Approver Name: The name of the associate who approved the order.

  • Approver Email: The email of the associate who approved the order.

  • SKU: The SKU of the item.

  • Product ID: The product ID of the item. If the product ID is the same as the SKU in your business, you'll see the same identifier in both fields. This field is not displayed if it is not configured for display for your business.

    Technical configuration
    The following section involves working with technical configurations and APIs. Contact your IT support team for more information.

    To add the product ID to the export, see Displaying product ID .

  • EAN13: The EAN13 of the item.

Related topics