You can update many inventory items swiftly by updating their information through excel. This guide will show you how to export your inventory to excel, and then edit the information and import it back into the system.
1. Login into the system and access the Products menu. Select the Inventory tab and then Refresh at the bottom.
2. A window prompt will appear asking you to add items without history. Select Yes or No based on whether you want to include them.
3. Select the Copy ListView to ClipBoard option to copy the Listview of your entire list of SKUs to a clipboard. This will be pasted into your Excel document.
You can also export from the Sku List in the Skus tab:
4. Open your excel, and right click on the first cell in the first row and column. Select the Paste option to paste your copied clipboard.
5. You can update any of the columns. In this example, product numbers are being added that previously did not exist.
6. Once your changes for updating are complete, go to File in the top right corner of the screen and select Save to save your excel file.
7. Select Import Skus under the Skus tab. Select Import Skus list.
8. Select your saved excel file in the location that you previously saved it in. Overview of the next window:
Step 1: Ensure that the fields on the left match the fields on the right identically. Please leave fields to Default / Null if you don’t want to import or update.
Step 2: Select OK to proceed with the import.
9. A notepad will open with the result of your import if any error occurs.
10. If you want to revert the import changes you made, select Import Skus again (in step 7), then select Roll Back Last Sku Import in the drop-down menu that appears.