Small consistency issue with batch create/export functions

1

after moving from a demo to real company file, the batch create refused to take unit price. all my items were there along with active status but no price.

after much trial and error i found that “Export” titles the column “Unit Price”, while the spreadsheet used for import uses a “UnitPrice” (no space). I copied entire columns therefore including a space where there shouldnt have been. took the space out works fine. throw that at the end of the to-do list lol.

2

That is why when using Batch create feature, you are asked in the first step to download empty spreadsheet template so you know what columns Manager will expect.

However I do think it’s a good idea to keep Export consistent with Import. So something will be done about it.

1 Like