# 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](https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M-BV4YRkYBYw5A4UAJL%2F-M-pMhAEtaSwgFDO6U_y%2F-M-pNjSaqnBlcRJliaXr%2FScreen%20Shot%202020-02-11%20at%2012.51.22.png?alt=media\&token=0bc6486d-f6db-4a79-bc20-3d8ae2ba7571)

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](https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M-BV4YRkYBYw5A4UAJL%2F-M-pMhAEtaSwgFDO6U_y%2F-M-pPKpNc9ZTjo-4O25F%2FScreen%20Shot%202020-02-11%20at%2013.00.36.png?alt=media\&token=1dee299d-8cc0-43f6-bac7-d5093a3ab0bc)

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](https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M-BV4YRkYBYw5A4UAJL%2F-M-pQ9IlxuCi09QHEKLN%2F-M-pQZMWospqTeBFd9rU%2FScreen%20Shot%202020-02-11%20at%2012.59.14.png?alt=media\&token=ba644ff5-8848-4beb-aa97-859e09de3251)

{% 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="../production/production-management/product-management" %}
[product-management](https://manual.unosofbooks.com/production/production-management/product-management)
{% 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](https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M-BV4YRkYBYw5A4UAJL%2F-M-pfMGeeAFPRLisLO12%2F-M-pfderCgxdQoC9vSQL%2FScreen%20Shot%202020-02-11%20at%2013.14.38.png?alt=media\&token=8e2478ec-bf5f-482e-9b9d-e08a3eb05d96)

![Find your file in your PC](https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M-BV4YRkYBYw5A4UAJL%2F-M-pfs1zc5YbJAz2dczC%2F-M-phFXtSAir0gN0RPmS%2FScreen%20Shot%202020-02-11%20at%2013.15.18.png?alt=media\&token=2ece9cc1-d5f4-401e-a8e0-10b62f7a0c6e)

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

![Upload File Button](https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M-BV4YRkYBYw5A4UAJL%2F-M-phM91jOhOVwP7rHzv%2F-M-phsrwetE3b0c2zo4u%2FScreen%20Shot%202020-02-11%20at%2014.26.15.png?alt=media\&token=5723dd90-aa8b-4909-902c-bc68fa3545b3)

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](https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M-BV4YRkYBYw5A4UAJL%2F-M-plqlg1HlBvocubWBe%2F-M-pmgkkG7NSSfqXF10g%2FScreen%20Shot%202020-02-11%20at%2014.46.52.png?alt=media\&token=23c5860c-8edd-474d-a33e-7402c9b16957)

The minimum prices effect the following management tool:

{% content-ref url="../sales/search-purchase-orders/minimum-pricing-check" %}
[minimum-pricing-check](https://manual.unosofbooks.com/sales/search-purchase-orders/minimum-pricing-check)
{% endcontent-ref %}