# 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.*


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://guide.openfoodnetwork.org/basic-features/reports/reports-for-bulk-order-management.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.