How to Download and Prepare the Fulfilment Center Report in Odoo
Table of Contents
This guide shows you how to download the Fulfilment Center Report from Odoo and sort it in Excel by hardware family. No technical knowledge is needed. Every step has a screenshot, and the red boxes and numbers show where to click.
Result: one Excel file named AllTransfer_YYYYMMDD with an All sheet that contains every order, plus one sheet per hardware family: Dish POS, Dish Pay, DPL and Dish Order.
Before you start
When: every working day, at the end of the day, right after the Versandstatus upload is finished.
What you need:
- Access to Odoo
- Microsoft Excel installed on your computer
Prepare the report
Step 1: Open the Fulfilment Center
- Log in to Odoo. The home screen shows all the available apps.
- Click Fulfilment Center (red box).
Odoo home screen: click Fulfilment Center
Step 2: Check the filter and download the report
- The Fulfilment Center Report opens in a list view. In the search bar, make sure the Transferred filter is active (1). The report must show every order in Transferred status.
- Click the download icon at the top left of the list, just below the report title (2).
An Excel file is saved to your computer, usually in the Downloads folder.
Fulfilment Center Report: (1) Transferred filter, (2) Download button
Tip: If the Transferred filter is not in the search bar, open the Filters menu and select Transferred.
Step 3: Open the file and rename the sheet
- Open the downloaded file with Excel. It contains one sheet, Sheet1, with one row per order.
- Double-click the Sheet1 tab at the bottom, type All and press Enter.
The downloaded file opened in Excel
Step 4: Turn on the filters
- Click any cell in the first row (the header row).
- Go to the Data tab and click Filter. You can also press Cmd + Shift + F (Mac) or Ctrl + Shift + L (Windows).
A small arrow now appears in every column header.
Filter arrows are now visible in the header row
Step 5: Create one sheet per hardware family
Orders are split by hardware family, based on the Product column. Each family gets its own sheet. Name each sheet exactly as written in the Product family column below. Use the article number to double-check that you are copying the right products.
| Product family (sheet name) | Product name | Article number |
|---|---|---|
| Dish POS | POS Screen D3 PRO | 122206241 |
| Hardware TSE | 114205231 | |
| Mini Server M3 | 120204241 | |
| Printer DPT201 | 123210241 | |
| POS Router | 111207241 | |
| Cash Drawer | 103203231 | |
| Handheld Smartphone L2s Pro | 107206232 | |
| Netgear Switch | 113208231 | |
| POS Cradle without battery slot | 105206231 | |
| Access Point EA U6 Pro | 101208231 | |
| POS Buzzer | 102203241 | |
| Dish Pay | S1F2 | 125211241 |
| V400c | 124211241 | |
| DPL (DISH POS Lite) | DISH POS Lite Desktop Terminal | 146220261 |
| DISH POS Lite Cash Drawer (small) | 151220261 | |
| DISH POS Lite Cash Drawer (Large) | 152220261 | |
| DISH POS Lite Miniserver (rental) | 147220261 | |
| DISH Pay Payment Terminal AMS1 | 148220261 | |
| Paper Rolls | 149220261 | |
| DISH POS Lite TSE Stick | 153220261 | |
| Dish Order | DISH Professional Order Hardware | 121206231 |
Note: DISH Pay Payment Terminal AMS1 belongs to the DPL sheet, not the Dish Pay sheet.
Repeat the following for each of the four families:
- Click the + button at the bottom to add a new sheet. Double-click the new tab and type the family name, for example Dish POS.
The + button adds a new sheet
- Go back to the All sheet and click the filter arrow in the Product column header.
- Untick (Select All), tick only the products of that family and click OK.
The Product column filter on the All sheet
- Click any cell in the table and press Cmd + A (Mac) or Ctrl + A (Windows). This selects all visible rows, including the header row. Copy with Cmd + C or Ctrl + C.
- Go to the family sheet, click cell A1 and paste with Cmd + V or Ctrl + V.
- Return to the All sheet, open the Product filter again and click Clear Filter.
Important: Copy the rows, never cut or move them. The All sheet must keep every order.
Step 6: Save the file
- Click File and then Save As.
- In the Name field (1), type AllTransfer_YYYYMMDD, using the date of the next working day (see below).
- In the Sensitivity menu (2), choose Unrestricted.
- Click Save.
Save dialog: (1) file name, (2) Sensitivity = Unrestricted
Which date to use: Use the day the orders will be handled, which is the next working day, not the day you prepare the file.
- Prepared on Thursday, October 29, 2026 → AllTransfer_20261030 (Friday)
- Prepared on Friday, October 30, 2026 → AllTransfer_20261102 (Monday)
Final check
Before you close the file, make sure that:
- The All sheet still contains every order and has no filter active.
- There are four family sheets named Dish POS, Dish Pay, DPL and Dish Order.
- Each family sheet starts with the header row in row 1.
- The file name uses the date of the next working day and the sensitivity is set to Unrestricted.
Your report is now organized by hardware family and ready to be used.