Large print jobs and exports
How big packing slip, label, prep list, order list and export jobs are prepared in parts and saved as one file, and whether to export a CSV or an Excel file.
Every print job and export works for any number of orders. A large one is prepared in parts that the server can answer quickly, and your browser joins them into one file, in order, before it downloads. Nothing is left out and there's no limit to work around.
A job is prepared in parts when it has more than:
- 50 orders of Slips or Thermal packing slips (Orders)
- 500 orders, or about 1,200 printed lines (products, variations and each order's notes), in a Prep List (Orders, Print All Windows or one window's prep list on a presale, and the presale Products card)
- 100 orders in an Order List PDF
- 250 orders, or 1,000 labels, of product labels (Labels on Orders, a presale or window's Product Labels, and Re-print in Printing → Label Print History)
- 250 orders in Export (Orders) or Download Sales Report (Dashboard), 2,000 customers in More → Export CSV or Export for Excel (Customers), or 1,000 attendees in an event's Export
A smaller job is one file straight away, as it always was.
While it's preparing
A dialog shows the progress, for example "Preparing… part 2 of 4". Keep the tab open until it finishes; the file then downloads. A large product label job is recorded first, 500 orders a step (these steps count in the progress), and saved to Label Print History before its first label prints, so it's listed there even if you stop the printing. Stopped while it is still being recorded, nothing is saved or printed.
- Cancel stops the job. Nothing downloads.
- If a part fails because the connection dropped or the server was busy, it's tried again by itself. If it still fails, the dialog says which part and why, for example "Part 3 of 4 couldn't be prepared. The connection dropped. Try again." or "The server took too long to answer. Try again." The parts already prepared are kept: select Try Again to continue from that part, or Cancel. Offline, the dialog says "You're offline. Reconnect, then choose Try Again."
What the joined file looks like
Packing slips and product labels for more than 1,000 orders come as several files of up to 1,000 orders each, named "Packing Slips 1 of 3" and so on; the dialog says how many first and downloads each as it's ready (your browser may ask once to allow several downloads). Cancel stops before the next file; Try Again continues from the file and part that failed. Label files after the first start on a fresh sheet. Prep lists, the Order List PDF and CSV exports are always one file.
Each file is the same as one made in one go: the same pages in the same order. Compact packing slips and the Order List PDF flow from page to page as one print would, page numbers ("Page 3 of 40", "Customer Order List · 3 / 40") count across the whole file, and product labels fill every label sheet after the first, starting the first sheet at your Start at Label Position. A CSV export has one header row and every order or customer once.
On Orders, Select All … Matching Orders selects every matching order for printing (up to 50,000); only status, payment and archive changes stop at 10,000 at a time. A presale's prep lists and labels include all of its orders.
CSV or Excel
Every export (Export on Orders and on an event's attendees, Download Sales Report on the Dashboard, More on Customers) offers two files with the same columns and rows:
- Export for Excel (Download for Excel on the Dashboard) is an Excel file (.xlsx). It opens as it is in Excel, Numbers and Google Sheets, on a phone too: names with accents (José, Zoë) show as typed, amounts are numbers you can add up, and the first row stays in view as you scroll.
- Export CSV (Download CSV) is a plain CSV file. It opens with accents intact when you double-click it in Excel or Numbers, or in Google Sheets on a computer (File → Import). Use it to bring your orders or customers into another program that asks for a CSV. The Google Sheets phone app shows three extra characters () before its first column's name; on a phone, use the Excel file.
Still need help?
Email support@bakebug.com with your store name and order number (if it's about an order), or ask other bakers in the Bakebug Community.