---
title: "Stock Adjustment Import"
canonical: "https://kb.myframeworks.com.au/space/FRAM/28409292/Stock%20Adjustment%20Import"
format: markdown
---
# Overview

The **Stock Adjustment** **Import** allows import, in bulk, stock adjustments including adjusting the quantity on hand, the average cost for a given product, GL movements and more.

# <span style="color: #172b4d">Accessing the Stock Adjustment Import</span>

To access the Stock Adjustment Import, perform the following:

> Macro (rw-ui-steps-macro)
> 
> > Macro (rw-step)
> 
> Click **Frameworks **then navigate to **Inventory > Transaction Processing > Stock Adjustment Import **from the navigation tree.
> 
> > Macro (rw-step)
> 
> The **Stock Adjustment Import** page will open the **Import Criteria** page.

![image](media://24e05212-c081-4cb9-96c0-aace1e5d39ce)

# <span style="color: #172b4d">Downloading a Template</span>

<span style="color: #333333">To make it easier to import your </span><span style="color: #333333">**Stock Adjustment Import**</span><span style="color: #333333">, you can also download a template. By downloading a template, you will ensure that you have the correct fields available to update and/or modify. To download a template, from the </span><span style="color: #333333">**Stock Adjustment Import **</span>**> Import Criteria **<span style="color: #333333">tab, perform the following:</span>

> Macro (rw-ui-steps-macro)
> 
> > Macro (rw-step)
> 
> <span style="color: #000000">From the </span>**Update Field **<span style="color: #000000">menu select which fields you want to update/import. By default, all the fields are selected, hold the </span>**CTRL**<span style="color: #000000"> key down to select multiple fields.</span>
> 
> > Macro (rw-step)
> 
> <span style="color: #333333">Click </span>**Download Template**<span style="color: #333333"> to download the .csv template (stock_adjustment.csv) that will include all of the products and fields based on the above selections.</span>
> 
> > Macro (rw-step)
> 
> Open up the downloaded .csv template (stock_adjustment.csv) and add/edit the required product fields in the file.
> 
> > Macro (rw-step)
> 
> **Save **the file, keeping the .csv file format, ready for importing.

# Uploading the Stock Adjustment Import

> Macro (rw-ui-steps-macro)
> 
> > Macro (rw-step)
> 
> <span style="color: #333333">Click </span>**Upload CSV**<span style="color: #333333">** **</span><span style="color: #333333">and choose the file created in the above steps and then click the</span>** Upload**<span style="color: #333333"> button. Once the .csv file has been up uploaded next to </span>**Import File:**<span style="color: #333333"> it will display the filename that is going to be imported.</span>
> 
> > Macro (rw-step)
> 
> <span style="color: #333333">Enable the checkbox for </span>**Report Only **<span style="color: #333333">to confirm the changes before importing or </span><span style="color: #333333">**disable **</span><span style="color: #333333">to import the changes into Frameworks.</span>
> 
> ![image-20241115-080642.png](media://f6e8182f-70d1-4365-872d-985b258573af)
> 
>  
> 
> > ℹ️ <span style="color: #144563">If you are performing a large product import you might want to delay the import to not impact performance. To do this update the </span>**Start date**<span style="color: #144563"> and </span>**time**<span style="color: #144563"> or use the date finder </span>**Show Date Chooser**<span style="color: #144563"> icon to search for an appropriate date and time to run the task.</span>
> 
> > Macro (rw-step)
> 
> From the **Schedule **tab, select the task notification option to **Send a Notification **or **Send an Email **once the import has run.
> 
> > Macro (rw-step)
> 
> <span style="color: #333333">Click </span>**Submit**<span style="color: #333333">** **</span><span style="color: #333333">to import the .csv file. An information box will pop up advising that the task has been submitted. Click on </span>**OK.**
> 
> > Macro (rw-step)
> 
> <span style="color: #333333">On the </span>**Output**<span style="color: #333333"> page, under the </span>**Generated Reports**<span style="color: #333333"> section, click on the </span>**report**<span style="color: #333333"> links to review the import.</span>
> 
> > ⚠️ <span style="color: #6a4920">If the</span>** Report Only**<span style="color: #6a4920"> option was enabled and there were no errors in the generated report repeat the above and disabled </span>**Report Only**<span style="color: #6a4920">. If there were any errors in the generate report, resolve the errors before importing and possibly run the report only option until it is error free.</span>
> 
> > Macro (rw-step)
> 
> Click on the **Close **button in the bottom right once the tasked in completed.

# Additional Information

> ✅ Refer to [Stock Adjustments](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28384064) for more information.
> ✅ 
> ✅ Refer to [Scheduled Task - Scheduling and Output ](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28402256)for more information.