# Bulk Updating Open Order Pricing

{% hint style="warning" %}
*Due to the extensive changes applied by this tool and the potential for error if used without caution, this tool is reserved for **Admin user accounts only**. This tool is used to enact mass, system-wide updates. This cannot be undone! Use with care! We highly recommend using the "**Price Update Review**" report under the **Orders** category to review the pricing and orders that will be affected by a mass price update.* 
{% endhint %}

## Before Updating

1. Navigate to "**Reports**" > "**Reports - New Tab**"

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FkaPCXHWF4yg4LGAsbA3V%2Fimage.png?alt=media&#x26;token=fd765091-ef4d-456d-8172-e02f5e7a5b52" alt=""><figcaption></figcaption></figure>

2. Review your new **Pricing Template Defaults** using the **Price Update Review** report under the Orders category of the Reporting page to make sure everything is correct.

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FrnBJ3DKMQnM4s2wJH3vc%2Fimage.png?alt=media&#x26;token=31855961-b3b7-4ecb-9fc7-c5460f478f66" alt=""><figcaption></figcaption></figure>

***

## Using the Open Order Price Update

After reviewing your existing prices with the **Price Update Review** report, you can navigate to the **Resources** > **Products & Pricing** menu.

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FQvXqWAejyrz30dAoli2O%2Fimage.png?alt=media&#x26;token=989a54e7-c408-41e6-9270-bb656aa97593" alt="" width="237"><figcaption></figcaption></figure>

You will use the top section to input parameters similar to the **Ticket Query** menu, with the results displaying in the lower section of the table. You can also leave these parameters set to ***ALL***, to have all of the available products displayed.

Each line will display a single product, the Location where the product is available, and then the price template and its associated pricing. This template pricing is applied as the default price when adding products to new orders. [Click here review Products, Pricing, and how Price Templates are applied in this article](https://help.tacinsight.com/fast-weigh-knowledge-base/how-to-guides/how-to-update-pricing).

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FHFHpq2Wk5f8ARs7qZBKt%2Fimage.png?alt=media&#x26;token=ca7f43d2-6dc0-402d-a81a-74860eabfc66" alt=""><figcaption></figcaption></figure>

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FXBT0Oz2654vBUtLKQGGp%2Fimage.png?alt=media&#x26;token=6ba70b9c-4bfb-47cd-a439-1592cd7efd42" alt=""><figcaption><p>When adding our "Default" product to an order, it will be priced at $18/Unit, but $13/Unit with our "Loyalty Discount" template.</p></figcaption></figure>

* After making the desired inputs and adjusting the rates as needed, click the Open Order Price Update button on the top-right of the Product Pricing table.

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FaV0AylTnGOEej3xHE0hG%2Fimage.png?alt=media&#x26;token=5cf5a9d1-38a2-44ff-94aa-d2fc656e2256" alt=""><figcaption></figcaption></figure>

<figure><img src="https://490131596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0LJDMCSYOqplCEgCo73X%2Fuploads%2FKhCI5kGUgEe480Uaqo5k%2Fimage.png?alt=media&#x26;token=1467c879-430d-4b22-9594-1edfbb2d19b9" alt=""><figcaption></figcaption></figure>

* (Optional) Set the **Region,** **Location,** and **Customer** that will be affected by this price update.

{% hint style="danger" %}
If the Region, Location, and Customer selections are left as **ALL**, this price update will affect all Open Orders. Making a selection in these drop-down menus will apply the price update to the all Open Orders for that selection. Example: Specifying a Region will affect all Open Orders within that Region, but selecting a Customer will affect their orders only.
{% endhint %}

* Check the boxes for the information you want to update from the template pricing menu to the Order-Products on Open Orders.
  * *Update Pricing*: Updates the Material Rate on the Order-Products from the Pricing column.
  * *Update Freight Charge Rate:* Updates the Freight Charge Rate on Order-Products within the "More" menu.
  * *Update Surcharges*: Updates the Surcharge Rate and type on the Order-Products within the "More" menu.
  * *Update Adjustments*: Updates the Adjustments on the Order-Products within the "More" menu.
  * *Update Minimums:* Updates the Minimums on the Order-Products within the "More" menu.
  * Click **\[✓Update]** to run the Open Order Price Update tool for **all Active and Inactive Orders marked as Open** that match your set criteria.

Once your selections have been made and the **\[Update]** button is clicked, your Open Orders will be updated to use the new pricing applied to the Pricing Template.

{% hint style="info" %}
If you have updated pricing using the Open Order Price Update tool and have tickets that have not yet been billed at the previous rates, you will want to de-select the **\[Reprice ✅]** when batching these tickets to avoid any unintended rate changes. This reprice option will adjust the rates on the tickets to match the current rates available on the order.
{% endhint %}