> ## Documentation Index
> Fetch the complete documentation index at: https://help.mathership.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Order Exports
> Export and process order data using PDF or CSV attachments
# Order Exports
Mathership can provide order data in export-friendly formats.
Order exports are mainly used when vendors want to process incoming orders outside the Mathership interface, for example in Excel, an ERP system, or an internal order workflow.
## What are order exports?
Order exports are structured representations of order data.
They can include information such as:
* Article numbers
* Article names
* Quantities
* Packaging
* Prices, if available
* Customer number
* Order ID
* Customer email
* Order timestamp
In the current order flow, exports are mainly created as email attachments.
## Export formats
Mathership can generate order attachments in two formats:
| Format | Use case |
| ------ | ------------------------------------ |
| PDF | Human-readable order document |
| CSV | Structured order data for processing |
If no specific format is selected, Mathership uses PDF by default.
## PDF exports
PDF exports are useful when vendors want to read, print, or archive an order.
Use PDF if you want to:
* Print the order
* Read the order manually
* Archive the order as a document
* Forward the order internally
* Keep a readable copy of the order
PDF is the default export format.
## CSV exports
CSV exports are useful when vendors want to process the order data in another system.
Use CSV if you want to:
* Open the order in Excel
* Import the order into an ERP system
* Copy article numbers and quantities
* Process orders automatically
* Match products using article numbers
The CSV file uses a semicolon as separator.
## Standard CSV structure
The standard CSV export contains one row per order item.
For German users, the CSV columns are:
| Column | Meaning |
| ------------- | -------------------------------------- |
| Artikelnummer | Vendor article number |
| Artikelname | Product name |
| Menge | Ordered quantity |
| Gebinde | Packaging |
| Gesamtpreis | Total price for the line, if available |
For other languages, the CSV columns may be shown in English:
| Column | Meaning |
| -------------- | -------------------------------------- |
| Article Number | Vendor article number |
| Article Name | Product name |
| Quantity | Ordered quantity |
| Packaging | Packaging |
| Total Price | Total price for the line, if available |
The CSV column language depends on the customer's selected language.
## Prices in exports
If a product has a price, Mathership can calculate the line total.
The line total is calculated from:
```txt theme={null}
price × quantity
```
If no price is available, the CSV can show the price as unavailable.
Missing prices do not prevent the order export from being created.
## Attachment format setting
The order attachment format is stored on the customer company.
Available values are:
| Value | Result |
| ----- | -------------------------- |
| pdf | Orders are attached as PDF |
| csv | Orders are attached as CSV |
If the setting is empty or missing, Mathership uses PDF.
## Changing the export format
Customers can change their order attachment format in their company settings.
Only valid formats are accepted:
* PDF
* CSV
If another value is submitted, Mathership rejects the setting.
The export format belongs to the customer company. It affects order emails sent from that customer account.
## File naming
Mathership creates filenames automatically.
The filename can include:
* Customer number
* Order ID
* Timestamp
* Customer email
* Mathership reference
Example PDF filename:
```txt theme={null}
4711_order_123_1710000000000_customer_at_example_de_mathership.pdf
```
Example CSV filename:
```txt theme={null}
4711_order_123_1710000000000_customer_at_example_de_mathership.csv
```
This helps vendors match the attachment to the correct customer and order.
## Customer numbers in export filenames
If a customer number exists for the vendor-customer relationship, Mathership can include it in the filename.
If no customer number exists, Mathership may use the customer company ID instead.
This is useful when vendors use customer numbers in their ERP, accounting, or internal order processing systems.
## Export delivery
Order exports are sent as attachments with order emails.
When a customer sends an order, Mathership can:
1. Create the order
2. Create the order items
3. Generate the order email
4. Generate the PDF or CSV attachment
5. Send the email to the vendor
The vendor receives the order export in the selected attachment format.
## Vendor notification email
The export is attached to the vendor notification email.
The email is sent to:
* The vendor notification email, if available
* Otherwise the vendor user's email address
Vendors should keep their notification email address up to date to receive order exports reliably.
## Custom CSV formats
Mathership can also support custom CSV formats for specific customers or workflows.
A custom CSV format may include additional rows or columns, such as:
* Store name
* Timestamp
* Store number
* Order date
* Estimated delivery date
* Article number
* Order quantity
* Packaging unit
* Article description
* Price
* Unit reference
Custom CSV formats are useful when a vendor or customer needs a specific import layout.
## Example: Standard CSV export
A simple CSV export can look like this:
```csv theme={null}
Artikelnummer;Artikelname;Menge;Gebinde;Gesamtpreis
1001;Tomato Sauce;12;Bottle;36.0
1002;Pasta;5;Box;25.0
```
## Example: Missing price
If a product has no price, the CSV can still include the item.
```csv theme={null}
Artikelnummer;Artikelname;Menge;Gebinde;Gesamtpreis
1001;Tomato Sauce;12;Bottle;36.0
1003;Olive Oil;2;Can;-
```
## Example workflow
A typical export workflow looks like this:
1. Customer creates an order
2. Customer selects products and quantities
3. Customer sends the order
4. Mathership checks the customer's export setting
5. Mathership generates a PDF or CSV attachment
6. Mathership sends the order email to the vendor
7. Vendor downloads or processes the attachment
## Best practices
### Use CSV for system processing
Use CSV if orders are imported into Excel, ERP software, or another structured workflow.
### Use PDF for manual processing
Use PDF if your team reads, prints, or manually archives orders.
### Maintain article numbers
CSV exports are most useful when products have article numbers.
Article numbers help vendors match incoming order rows to their own product database.
### Keep customer numbers updated
Customer numbers make it easier to identify customers in exported filenames and internal systems.
### Check missing prices
If totals are important, make sure product prices are maintained before relying on export totals.
## Common problems
### CSV does not contain prices
Check whether product prices are stored.
If a product has no price, Mathership may show the line total as unavailable.
### Wrong export format is sent
Check the customer's order attachment format setting.
The format should be either:
* pdf
* csv
### Vendor did not receive the export
Check that:
* The order was sent, not only saved as draft
* The vendor notification email is correct
* The email did not go to spam
* The vendor company has a valid email address
### CSV import does not work
Check that:
* The receiving system expects semicolon-separated CSV files
* Article numbers are available
* Column names match the expected language
* The file was not modified before import
### Filename does not contain customer number
Check whether a customer number exists for the vendor-customer relationship.
If no customer number exists, Mathership may use the customer company ID instead.
## Related pages
Understand order email attachment formats.
Learn how order emails are sent to vendors.
View the full details of an order.
Configure customer-side order settings.