How to Bulk Update Option Prices

Summary

Once you have all of your options added to the “Option Catalog”, you may find that you are wanting to change the price of a large number of the options. This page explains how this can be done by exporting them into a spreadsheet, making the changes, and then importing the spreadsheet back into TSA and bulk updating the options.

Steps

1. Navigate to System > Catalogs > Options

2. Click on Export and Import in the upper right-hand corner, this will bring up a modal

   Open

   

3. Click download .xls

   1. This will download a spreadsheet to your computer

4. Duplicate the downloaded spreadsheet

   1. This is not required but is recommended that you save the original somewhere you can get it later if needed

5. Make the appropriate edits to the duplicated spreadsheet

   1. It is also recommended that you save the edited spreadsheet with a different name e.g, “new prices 02-2022”

6. Navigate back to the Export and Import screen and click to upload

   1. This will open a file browser where you can select the edited spreadsheet

7. Click Verify and Apply

   1. This allows you to double-check everything is correct

      Open

      

8. Click Apply

   1. The new prices will be applied