Easy add departments for large inventory list – Sketch

Go to File > Exports > Inventory and export with layout as List. Select the vendor if only doing a certain one. Click OK.
Save CSV.
Open CSV in Excel.
Delete column U and everything after it.
Select Column H (UPC), right-click and select Format Cells. Under the Number tab select number and change decimal places to 0. Click Ok.
Add department codes under column Q (Depart). Make sure codes match what is in TUS as they are case sensitive.
Save CSV file.
In TUS, go to Lists > Vendors and in the lower left Vendor drop-down select Multi-Vendor Import/Update. Click Import on the pop-up. Select the CSV file to import.
In the Multi-Vendor Import\Update options screen uncheck Code, Descriptions, Cost, and Retail if checked. Leave Depart checked. Click next to preview a few items to make sure the Depart codes are correct. If so, click OK.
Ready to Import? Click Yes.
Click OK when import is finished.

Updated on August 10, 2021