Export Warehouse Lists to CSV or Excel
Almost every list in the QrX warehouse can be exported as a CSV or Excel file: stock, history, receipts, purchase orders, counts, pick lists and more. The export runs in the background with the filters you see on the screen, and you download the file when it is ready. This article is for warehouse staff, merchants with QrX warehouse stock and fulfilment partners.
Which Lists You Can Export
Warehouse > Stock: the stock list, the low stock alert rules, the serial numbers of an item and the report of items shipped without a serial number.
Warehouse > History: the stock history, the write-offs report and the stock analysis report.
Warehouse > Backorders and Warehouse > Tasks: backorders, put-away tasks and replenish tasks.
Warehouse > Inbound: receipts, returns, returns to sender and quarantine.
Warehouse > Transfers, Warehouse > Counts, Warehouse > Pick lists and Warehouse > Partner switches.
Warehouse > Team: the team tasks.
Warehouse > Purchasing: purchase orders, purchase advice, dropship lines, suppliers and stock value.
Warehouse > Pack station: the pack queue, the singles, and the snoozed and held orders.
Warehouse > Dashboard: packaging usage, that is how many boxes were used per merchant and box type (no costs), and Warehouse > Partner activity.
Settings > Warehouse > Warehouses: the warehouses with their address, contact and GLN; in a warehouse, its zones, locations and containers.
Warehouse > Purchasing: also the lines of one purchase order and the items of one supplier.
Warehouse > Stock: also the lots.
Warehouse > Team and Settings > Warehouse > Staff skills: the skills of your team.
Settings > Warehouse > Reason codes and Units of measure: the reason codes, units and pack units.
Fulfilment partners, the 3PL billing screens: 3PL clients, charges, statement lines and invoices.
Export a List
Open the list and set the filters you want, for example a warehouse, a state or a search text.
Click the Export icon in the header or filter row.
Choose CSV or Excel. For lists with dates (stock history, write-offs, packaging usage and partner activity) also choose From and To. One export covers at most one year.
Click Start export. You see "Export started" and can keep working.
Click the Show your exports icon next to it. When the export shows Ready, click the download icon.
Your Exports
The Exports panel lists all your own exports, newest first, with the list, the format, the status, the number of rows and when it was made. More rows load as you scroll; the refresh icon reads the list again. The statuses are Waiting, Being made, Ready, Failed (with the reason) and Expired. Only you see your exports; colleagues see their own.
Limits
A file is kept for 24 hours. After that it shows Expired: export the list again.
A CSV file holds at most 200,000 rows. An Excel file holds at most 1,000,000 cells (rows times columns). Export a larger list as CSV, or narrow the filters or the dates.
You can run 3 exports at the same time. Wait until one is ready before you start a fourth.
An export that takes longer than 15 minutes stops. Narrow the filters and try again.
The write-offs export holds the same rows as the report on screen (at most 500).
Column names in the file are in English and the same in every language, so a spreadsheet or import keeps working. Dates are in UTC.
The CSV buttons that existed before (for example Export CSV on the stock history and on partner activity) still work as before.
Who Can Export
You need two things: the permission to open the list (for example View stock for the stock list, or the purchasing permission for purchase orders) and the permission Export stock history. Without both, the export icons are not shown. When your permission is taken away before the export runs, it fails with "Your access changed before the export ran."
Frequently Asked Questions
The export failed with "Too many rows". What now?
Choose CSV instead of Excel, or narrow the filters or the date range, and export again.
Can a colleague download my export?
No. Each person sees and downloads only their own exports. Send the file yourself, or ask the colleague to export the list.
When to Contact Our Support Team
Contact QrX support when an export stays on Waiting or Being made for more than 20 minutes, or fails with "The export could not be made" several times in a row. Include the list, the time and the filters you used.