# Reports for Bulk Order Management

The reports available in the Bulk Coop section are ideal for enterprises on the OFN platform, such as buying groups, who use the [Group Buy feature](https://guide.openfoodnetwork.org/basic-features/products-1/group-buy-for-bulk-ordering).

There are four reports in this section are:

|                 | Use                                                                                                                                                                                                                            |
| --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| Supplier Report | <p>List products by supplier.</p><p>A good place to look to see if</p><p>enough of a product has been </p><p>ordered to justify the supplier's<br>bulk size.</p>                                                               |
| Allocation      | <p>Lists products by customer.</p><p>A good place to look to </p><p>ensure you over / under</p><p>allocate bulk buy items to</p><p>customers evenly (ie. one </p><p>person is not short on all</p><p>items in their order)</p> |
| Packing Sheet   | <p>Re-packing products delivered <br>a supplier in bulk for customer </p><p>collection</p>                                                                                                                                     |
| Customer totals | <p>Documents refunds to/extra</p><p>payment required by customer</p><p>after adjusting stock levels</p><p>to make up a bulk order</p>                                                                                          |

## Data

The data in each report is as follows:

|                                              | Supplier Report | Allocation | Packing | <p>Customer</p><p>Totals</p> |
| -------------------------------------------- | --------------- | ---------- | ------- | ---------------------------- |
| Customer                                     | N               | Y          | Y       | Y                            |
| Supplier                                     | Y               | N          | N       | N                            |
| Product name                                 | Y               | Y          | Y       | N                            |
| Variant details                              | Y               | Y          | Y       | N                            |
| Bulk unit                                    | Y               | Y          | N       | N                            |
| Quantity Purchased                           | Y               | Y          | Y       | N                            |
| Units required                               | Y               | Y          | N       | N                            |
| Unallocated                                  | Y               | Y          | N       | N                            |
| Max excess quantity                          | Y               | Y          | N       | N                            |
| Date of order                                | N               | N          | N       | Y                            |
| <p>Amount paid, owing</p><p>& total cost</p> | N               | N          | N       | Y                            |

{% hint style="warning" %}
Products stocked by a hub which do not have bulk buy enabled will display with Bulk Unit = 0
{% endhint %}

![Bulk Coop Supplier Report](https://791054635-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-L9rgk4wEweX_zxXIzmW-887967055%2Fuploads%2FGEjCaOuCyTsaka6WfzGA%2Fbulk%20suppliers%20report.jpg?alt=media\&token=d908ac96-af51-4243-a435-e0494538d66e)

![Bulk Coop Allocation](https://791054635-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-L9rgk4wEweX_zxXIzmW-887967055%2Fuploads%2FsDJcN8hN6GY1abh7ONbn%2Fbulk%20allocation%20report.jpg?alt=media\&token=be98a81a-bee9-46f0-a773-8f6ab135e3f9)

![Bulk Coop Packing](https://791054635-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-L9rgk4wEweX_zxXIzmW-887967055%2Fuploads%2FUg2ddXs1JLTsXZYoDTzy%2Fbulk%20coop%20packing%20sheets.jpg?alt=media\&token=1ad771dc-8caf-4d29-bf1c-c30f841f9b7b)

![Bulk Coop Customer Payments](https://791054635-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-L9rgk4wEweX_zxXIzmW-887967055%2Fuploads%2F2nsiGtwWHOAAaCX4YzZa%2Fbulk%20coop%20customer%20payment.jpg?alt=media\&token=5419bf7a-7279-4a46-94cb-80d69336a597)

## Example: Bulk Co-op Suppliers Report

This report will show the following information:

* Did customers order enough of a product to justify ordering the bulk size from the supplier?
* How much extra product are customers willing to purchase to help the group reach the bulk size threshold (if [Group Buy](https://guide.openfoodnetwork.org/products-1/group-buy-for-bulk-ordering#enabling-group-buy-for-a-product) is enabled)
* How many bulk sizes are required to meet customer demand?
* If the bulk size is ordered, how much stock will be left over.
* How many customers will be disappointed if this product isn’t ordered?

See the example below for an illustration of how the Bulk Co-op Totals by Supplier report can be used:

Example 1: Where the bulk ordering quantity has been reached:

![Radishes](https://791054635-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-L9rgk4wEweX_zxXIzmW%2F-Lm42XLqo4KpLY0-_CcM%2F-Lm4Aqf5ITkJoWjGG3q3%2FRadishess.png?alt=media\&token=ac2a305d-2414-4401-9343-7a58d0c479b2)

Example 2: where the bulk order quantity has not been reached:

![Bok Choy](https://791054635-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-L9rgk4wEweX_zxXIzmW%2F-Lm42XLqo4KpLY0-_CcM%2F-Lm4B1BIG4FRhKT0VVcI%2FBok-Choy.png?alt=media\&token=798ba9aa-2a6e-4117-ae0f-9e7c3ae5ec0e)

* *Note the ‘Bulk Co-op Allocations’ report is similar in function to this report, but shows each customer’s order individually, rather than the cumulative total across all customers.*
