In Mafelo, you can easily export customer orders as a table. The downloaded file in .xlsx format can be opened not only in Microsoft Excel, but also in free applications such as LibreOffice or Google Sheets (Google Drive).
Main benefits and use cases
Ordering prints: A ready-made list with file names, formats, and quantities is perfect for ordering prints from a photo lab.
No duplicates: The system automatically groups the same shots ordered by different clients (or the same client).
Contact database: In the generated file, you will find a summary of orders along with client contact details.
How to export orders to Excel
To download a list of ordered photos or prints as a spreadsheet, follow the steps below.
Important: File export works at the level of a single gallery (perform these steps in the view of a specific gallery) or a single order (if there are multiple orders in a gallery, simply go to the details of that specific order).
To avoid issues when later searching and filtering files based on the generated list:
Files uploaded to a gallery in Mafelo must have exactly the same names as your original files (e.g. RAW) on your computer's drive.
Go in Mafelo to the Gallery from which you want to download the order list.
Open the Client Orders tab. (If you want to export only one order out of many, click that specific order to go to its details).
Scroll down the page and click the Export photos or Export prints button below the order list.
From the dropdown menu, select the to Excel option.
What will you find in the generated file?
The system will generate a ready-made spreadsheet, however its main content will differ depending on which button you clicked:
If you selected "Export photos"
The main list in Excel will contain individually listed file names from all orders in a given gallery (or from the selected order).
Note: If a given file was ordered multiple times, it will appear on this list only once (no duplicates).
If you selected "Export prints"
The list will contain file names along with the exact formats and quantities for printing.
Important: If your offer includes "print included in the file price", those specific prints will not appear on this list. To get a list of those photos, you must use the "Export photos" button and go to the Photos (per client) tab.
Additional tab: Photos per client
Pay attention to the bottom bar in the open Excel file. You will find an additional tab (sheet) there named Photos (per client).
When you switch to it, you will see a detailed summary containing not only the file names assigned to a specific order, but also the full contact details of the client/clients.
Frequently Asked Questions (FAQ)
Can I export photos from multiple galleries at once?
No. Currently, the export is tied to a specific gallery. You need to generate the file list separately for each gallery.
Where can I find export instructions for other programs?
Mafelo also supports export to many other tools. Check the relevant guides for programs such as Lightroom, Adobe Bridge, Photoshop, or Windows and MacOS systems, by searching for "export" in our knowledge base.