Discussions
Item Import with Multiple Price Levels AND Currencies
OK we have previously been updating prices using CSV imports for many years, using these column headers in the Excel/CSV file:
Item Code Price Level:[price level 1] Price Level:[price level 2] Price Level:[price level 3]
...and so on. I just replace [price level] with whatever we've called the price level in the system. Item code is the 'Item Name/Number', and under each Price Level column we have the sell price.
Now we want to upload sell prices in our base currency and another currency...is there a way to specify this in the CSV header? I tried 'Price Level:[price level]:[currency]' but that didn't work.