Skip to content
English
Submit a Ticket
  • There are no suggestions because the search field is empty.

How to export large CSV Files?

If you tried to Export CSV and got the error "You cannot export more than 2500 orders," here's what's going on and how to work around it.

Why this happens

The 2,500-order limit is hard-coded into WSM and can't be overridden. It exists to keep large exports from timing out or corrupting the file.

How to work around it

Split the export into smaller batches using Advanced Search. The most reliable way is to narrow your search by date range so each export stays under 2,500 orders:

  1. Go to your order screen and open Advanced Search.
  2. Filter by Order Date — for example, one week or one month at a time depending on your order volume.
  3. Run Export CSV for that date range.
  4. Repeat for the next date range until you've covered the full period you need.
  5. Combine the resulting CSV files in Excel or Google Sheets if you need one master file.

You can also narrow by Order Status (e.g., only "Processing" orders) or by Customer if that gets you under the limit faster than a date range would.

Need it as one file, or need more than 2,500 records in a single pass? Our Client Experience Team can export the data directly from the database for you. This is billable time — submit a ticket and let us know the date range and format you need.

Reference: what each export type includes

WSM has the ability to create order exports in a variety of formats, each suited to different downstream tools (shipping, accounting, CRM).

Export XML — Automatically changes any New orders you're exporting to Processing, and creates an XML file. Used for accounting programs such as MAS, Microsoft Dynamics NAV (formerly Navision), and other third-party programs.

  • Included Customer Information: Email, Name, Billing Address, Shipping Address
  • Included Order Information: Shipping Method, Credit Card Type, Credit Card Expiration, Last 4 Digits, and Transaction Information
  • Included Product Information: Name, Product URL

Export CSV — Exports the filtered orders as a comma-separated file you can open in Excel or import into accounting/shipping programs. Includes all order and address information, plus responses to checkout questions.

  • Included Customer Information: Customer ID, Email, Name, Billing Address, Shipping Address, and Answers to Checkout Questions (limited to 3)
  • Included Order Information: Order ID, Subtotal, Shipping Amount, Handling Amount, Discounts, Tax, Total, Status, Date, Payment Method