---
title: "Create Alternate Product Codes"
canonical: "https://kb.myframeworks.com.au/space/FRAM/28409252/Create%20Alternate%20Product%20Codes"
format: markdown
---
[Version 5.15.6+]

# Overview

<span style="color: #172b4d">The </span>**Create**<span style="color: #172b4d"> </span>**Product Alternate Codes**<span style="color: #172b4d"> Import function allows you to import new Product Alternate Codes for your products in Frameworks. </span>Alternate product codes can be used as 'shortcuts' or 'hotkeys' to the product. An alternate code cannot be an existing product number or barcode.

> ✅ Refer to the **Alternate Codes **section of the [Product Maintenance ](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28378114)User Manual for more information.

# Accessing the Create Alternate Product Codes Task

To access the **Create Alternate Product Codes **scheduled task perform the following:

1. Click the **Frameworks Menu** and navigate to **Inventory > Utilities & Scheduled Tasks > Create Alternate Product Codes** via the navigation tree.
2. The **Create Alternate Product Codes** screen will open on the **Import Criteria** tab.

![image](media://da8cdc4f-1522-4f34-a174-9d0d17750045)

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

To make it easier to import alternative codes for your products you can download a template. By downloading a template, you will ensure that you have the correct fields available to update or modify. To download a template, from the **Import Criteria **tab, perform the following:

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

> ⚠️ Ensure that the **Product Code **and** Alternate Code **fields are selected before downloading the template as the import requires both these fields.

# Uploading the Alternate Product Codes

To upload and import the edited product.csv file, from the** Import Criteria **page, perform the following:

1. Click **Upload CSV, **choose the file created in the above steps and then click the** Upload** button. Once the .csv file has been up uploaded next to **Import File:** it will display the filename that is going to be imported.
2. Enable > Macro (inline-media-image)

 **Report Only **to confirm the changes before importing or disable> Macro (inline-media-image)

 to import the changes into Frameworks.

> ⚠️ The** Report Only** checkbox is enabled by default. When enabled, the import will produce a report only of the imported changes to be made without processing the changes themselves. This is useful to ensure that there are no errors with the import. Disable the checkbox to import the changes into Frameworks.

3. Click the **Schedule** tab. The scheduled task is defaulted to run **One Time** and is set to run at the *current system date and time*.

> ℹ️ If you are performing a large product import you might want to delay the import to not impact performance. To do this update the **Start date** and **time** or use the **Date Finder** icon to search for an appropriate date and time to run the task.

4. Select the task notification options to **Send a notification** or **Send Email** once the import has run.
5. Click **Submit **to import the .csv file. An information box will pop up advising that the task has been submitted. Click on **OK.**
6. On the **Output** page, under the **Generated Reports** section, click on the **report** links to review the import.

> ⚠️ If the** Report Only** option was enabled and there were no errors in the generated report repeat the above and disable **Report Only**. If there were any errors in the generated report, resolve the errors before importing and possibly run the report only option until it is error free.

7. Click on the **Close **button in the bottom right once the task is completed.

# Additional Information

> ✅ Refer to [Schedule Task - Scheduling and Output](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28402256) for more information about notifications and scheduling.