> For the complete documentation index, see [llms.txt](https://manual.unosofbooks.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://manual.unosofbooks.com/pricing-1/minimum-pricing.md).

# Upload Minimum Pricing

{% hint style="danger" %}
Master Level application.
{% endhint %}

## Uploading Minimum Pricing

This is the primary page for uploading a general minimum price per variety and length for all your orders. If a purchase order contains a variety which does not meet the minimum price uploaded in this module, that purchase order will not be possible to invoice. 

{% hint style="success" %}
Home / Customers / Pricing / Product Minimum Pricing\
<https://farm.unosof.com/index.cfm?event=Product.Pricing.Min.Upload>
{% endhint %}

![Minimum price upload module](/files/-M-pNjSaqnBlcRJliaXr)

To upload new minimum prices, download the Excel file by clicking the CSV(,) or the CSV(;) button in the upper left corner of the page.

{% hint style="info" %}
The file format depends on the configuration of your Excel sheet.
{% endhint %}

![Download buttons](/files/-M-pPKpNc9ZTjo-4O25F)

Open the downloaded excel file and input the desired minimum price, in the Stem Price column, as shown on the image below, and save your file in your PC.

![Minimum Price Excel Sheet](/files/-M-pQZMWospqTeBFd9rU)

{% hint style="warning" %}
Do not delete any columns or rows, nor edit names or lengths from the excel file.
{% endhint %}

{% hint style="info" %}
The items that require a price, come from the field Commercial Name in Manage products. Its possible to cluster many SKU's into one line item to price, learn more at Manage Products.
{% endhint %}

{% content-ref url="/pages/-M4UoWSSDlyVC\_6YSBjW" %}
[Manage Products](/production/production-management/product-management.md)
{% endcontent-ref %}

Return to the Unosof Minimum price module and open your saved file, by clicking on the Choose file button in the upper right corner.

![Choose File Button](/files/-M-pfderCgxdQoC9vSQL)

![Find your file in your PC](/files/-M-phFXtSAir0gN0RPmS)

Upload the file to the system by clicking on the Upload file button in the upper left corner of the screen.

![Upload File Button](/files/-M-phsrwetE3b0c2zo4u)

This will bring up a format to add the price sheet details:

* Market: Select for whom is this price sheet is activated. You can select all customers from a market or markets.
* Customer: Apply this price sheet to a customer, or a group of customers.
* Price Sheet Name: Name your price sheet as desired (Valentines, Summer 2020, OM prices, etc)
* Price Range Min: Negotiation range from the price input. Price - Negotiation range min= Minimum acceptable price to sell a variety. Prices below this calculation cannot be invoiced)&#x20;
* Price Range Max: Negotiation range from the price input. Price + Negotiation range max=Maximum price acceptable to sell a variety. Prices above this calculation cannot be invoiced.&#x20;

After setting the Pricing Sheet details, save it to the system by clicking the Process File button in the upper right side of the page.

![Price Sheet details](/files/-M-pmgkkG7NSSfqXF10g)

The minimum prices effect the following management tool:

{% content-ref url="/pages/-M3RTkYmHSzte6KAtVqo" %}
[Minimum Pricing Check](/sales/search-purchase-orders/minimum-pricing-check.md)
{% endcontent-ref %}