Since you have the columns in the db already the next step is to update the insert and update pages. You should work on one first, then the other.
The insert page is Products_Insert and the update page is Products_Update. If you have made any customizations to these pages you should make sure to back them up first.
On the insert page you will need to add in a new form element to hold the new value. Once you add in this new form element you will need to edit the insert server behavior. You can just double click on it in the server behaviors tab. The only thing you need to change is on the screen where the columns are associated with the values from the form. You need to select your newly added column and using the lightning bolt icon select the new form element you just added. That is it for the insert page.
For the update page you will do the same thing but you will want to default the form field to the value that comes from the recordset. You can set the value like the other inputs, just update the name of the column to be the new column you added to the table.
Make sure that you are testing the pages out after you make any changes to ensure that things are working as you expect them to be. PowerStore has a bit gong on in these pages and it can be easy to break the store whenever you make edits to these pages.
