If you want to use the same column in an import more than once, then it can be set up via an expression. For example, if your supplier SKU is the same as your SKU, then you may want to map both options to the same column in your file.

The column mapping screen shows a list of file columns which can be mapped one to one. However, the same column can be mapped multiple times by using an expression. In the following example of an inventory import, the file column SKU will be mapped to SKU and Supplier Code:

  • Create an import and proceed to the column mapping screen
  • Map your SKU column to SKU, if it hasn't already automatically mapped
  • Click the Expression button
  • In the Map To dropdown, select Supplier Code
  • Click the pencil icon to open the edit expression window
  • Select your SKU column from the Columns dropdown menu which will add v{SKU} to the editor
  • Click the OK button
  • Click the Run Now or Save button as appropriate