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
Export formats
Mathership can generate order attachments in two formats:| Format | Use case |
|---|---|
| Human-readable order document | |
| CSV | Structured order data for processing |
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
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
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 |
| 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: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 |
|---|---|
| Orders are attached as PDF | |
| csv | Orders are attached as CSV |
Changing the export format
Customers can change their order attachment format in their company settings. Only valid formats are accepted:- CSV
File naming
Mathership creates filenames automatically. The filename can include:- Customer number
- Order ID
- Timestamp
- Customer email
- Mathership reference
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:- Create the order
- Create the order items
- Generate the order email
- Generate the PDF or CSV attachment
- Send the email to the vendor
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:Example: Missing price
If a product has no price, the CSV can still include the item.Example workflow
A typical export workflow looks like this:- Customer creates an order
- Customer selects products and quantities
- Customer sends the order
- Mathership checks the customer’s export setting
- Mathership generates a PDF or CSV attachment
- Mathership sends the order email to the vendor
- 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:- 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
CSV and PDF Attachments
Understand order email attachment formats.
Email Notifications
Learn how order emails are sent to vendors.
Order Details
View the full details of an order.
Order Preferences
Configure customer-side order settings.