# Order Reports

## Orders and Distributors Report

{% hint style="success" %}
This report is a useful way to view customer orders as they are placed in more detail than on the [Order](https://guide.openfoodnetwork.org/hungarian/basic-features/orders/view-orders) list.
{% endhint %}

The Data fields you can see in this report are:

* Date & time the order was placed along with order ID
* Shipping method (and cost), payment method, customer notes
* Customer name, email, phone number, city (but not full address)
* For each product within an order, there is the name of the product, variant name, quantity (and Max quantity for bulk order items), cost
* Hub (distributor) address

![Orders and Distributors Report](https://1334376341-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-L9rgk4wEweX_zxXIzmW%2F-MVM0DHYV9WJxqIWcMiH%2F-MVM1UqlKeDYOqILjTj5%2Forders%20and%20distributors.jpg?alt=media\&token=a29b2252-9b33-44e4-b521-0ad5d9beeb0c)

{% hint style="info" %}
Filter by date and time to enable swift download.
{% endhint %}

## Orders and Fulfillment Reports

Under the Orders and Fulfillment Reports you will find four options: Order Cycle Supplier Totals, Order Cycle Supplier Totals by Distributor, Order Cycle Distributor Totals by Supplier and Order Cycle Customer Totals.

### Order Cycle Supplier Totals 

{% hint style="success" %}
As a **producer who supplies one or more hubs** these three reports are a great way to keep track of orders of your products which coming in **while an order cycle is open.** 
{% endhint %}

Unless you are also the coordinator or distributor of the order cycle these orders will not appear in your list of [Orders](https://guide.openfoodnetwork.org/hungarian/basic-features/orders/view-orders) but you may want to start planning your baking/picking before you receive the [supplier notification email](https://guide.openfoodnetwork.org/hungarian/shopfront/order-cycle/order-cycles-for-hubs#notify-producers-button) from the distributing hub.

A summary of the data found in each report is below:

| Report            | OC Sup Tots | OC Sup Tot by Dist | OC Dist Tot by Sup |
| ----------------- | ----------- | ------------------ | ------------------ |
| Producer          | Y           | Y                  | Y                  |
| Hub               | N           | Y                  | Y                  |
| Product           | Y           | Y                  | Y                  |
| Variant           | Y           | Y                  | Y                  |
| Amount            | Y           | Y                  | Y                  |
| Tot Units         | Y           | N                  | N                  |
| Current unit Cost | Y           | Y                  | Y                  |
| Total Cost        | Y           | Y                  | Y                  |
| Status            | Y           | N                  | N                  |
| Shipping Method   | Y           | Y                  | Y                  |
| Tot shipping cost | N           | N                  | Y                  |

{% hint style="warning" %}
Note that the Total Cost is not a simple multiple of Current cost per unit and amount.  

* The current cost per unit may vary over the time frame selected.  
* The value recorded in these reports is the current cost per unit at the time of the last order.
* The Total Cost is a sum of product costs at the time when each item was purchased.
  {% endhint %}

![Order Cycle Supplier Totals](https://1334376341-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-L9rgk4wEweX_zxXIzmW%2F-MVM3n7b7ZVL4rjkvUoW%2F-MVMO5qOu4JdaVQ1YlAJ%2FOC%20supplier%20totals.jpg?alt=media\&token=a7f4a5c5-5acf-4331-954b-5070439c559c)

![Order Cycle Supplier Totals by Distributor](https://1334376341-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-L9rgk4wEweX_zxXIzmW%2F-MVM3n7b7ZVL4rjkvUoW%2F-MVMOFDHYfq1V7c-ggcw%2FOC%20supplier%20totals%20by%20distributor.jpg?alt=media\&token=1ff959a3-6561-4c57-9082-756dbe1b7b00)

![Order Cycle Distributor Totals by Supplier](https://1334376341-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-L9rgk4wEweX_zxXIzmW%2F-MVM3n7b7ZVL4rjkvUoW%2F-MVMOM7Je2lXUA08-J9P%2FOC%20distributor%20totals%20by%20supplier.jpg?alt=media\&token=61981445-8311-44a0-98f7-1cbe5821f629)

{% hint style="success" %}
These reports are handy for calculating the amount to reimburse a producer for items supplied
{% endhint %}

### Order Cycle Customer Totals

{% hint style="success" %}
Useful for:

* Fulfilling orders on a individual basis 
* Preparing individual orders in bulk
  {% endhint %}

This report which contains the most data:

* Date & time the order was placed along with order ID
* Customer name, email, phone number, billing and shipping addresses
* For each product within an order, there is the name of the product, variant name, quantity, cost, price paid by the customer (item cost + fees), a break down of fees (Enterprise, payment method and shipping method fee associated with each product), producer
* Hub name.
* Payment Method and status (ie. paid, unpaid)
* Shipping Method, Delivery or Pick up

{% hint style="info" %}
The Shipping Address displayed for an order where the chosen shipping method is 'pick up' will be the address of the distributing hub.
{% endhint %}

The screenshot below shows the information contained in an Order Cycle Customer Totals report. 

![Order Cycle Customer Totals](https://1334376341-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-L9rgk4wEweX_zxXIzmW%2F-MVM3n7b7ZVL4rjkvUoW%2F-MVMR1N4A0VCZv8tI1OK%2FOC%20customer%20totals.jpg?alt=media\&token=12b18d09-22cf-4de9-b307-a4e438312c8c)