Manage your inventory counts for stocked items by uploading a spreadsheet or csv file.
A subscription to Net32’s API is required to use this feature.
This article will review:
- How you can view and download a template with all your stocked products that have low or zero inventory
- How you can create your own template and prepare your file for upload
- How to upload and process your file
1) Download your template
Before you start, you need an inventory template file that has either mpid or vpcode in the first column, followed by inventory in the second column. If you choose to identify your products with your "vpcode" please note that the system requires an exact match to identify the vpcode and update your product.
This formatting is required by the tool. Other columns such as MPCODE (Manufacturer Code), BRAND, DESCR are included in the file for product clarification but are ultimately ignored by the tool.
Downloading your template is easy via the Product Inventory Management tool on OMS. Simply go to OMS -> Tools -> Product Inventory Management, search for out of stock, low inventory, or all stocked items and click "download". Detailed, step-by-step instructions can be found in the Inventory section on the Net32 Vendor Help page.
Alternatively, the Net32 Data team can provide you an inventory file for uploading your inventory. These files can be requested through the OMS Data Help Tool.
2) Prepare your file
Once you have your inventory file with either mpid or vpcode in the first column, followed by inventory in the second column, you need to check the following before uploading the file:
- Duplicate MPIDs will prevent the file from being imported
- Inventory numbers must be numerical (0 thru 9999).
- Any negative numbers will be updated to 0. Any inventory numbers over 9999 will be updated to 9999
3) Upload your file
Now you are ready to upload your file to the system: Go to OMS -> Tools -> Product Inventory File Upload
Choose your file and click Import. The tool accepts both Excel and CSV formatted files.
4) Processing the File
The content of your file will display on the OMS screen. It is not editable on screen. Any errors or updates should be corrected in the file and then re-uploaded.
Please ensure to stay on the System Processing screen until the process is complete. Leaving the screen before the upload is complete will cause an incomplete upload, only updating the products that were updated before leaving the screen
For large files, over 20 product MPIDs, you are able to scroll through pages to view entire file contents.
Once the process has been completed, you will receive a summary and/or error report if applicable.
Please stay on the System Processing screen until the process is complete.
The system will give you a brief summary and a list any mpids that were not updated.
Trouble Shooting
- Check your input file and make sure that all column names are spelled correctly and do not have any spaces
- Column names are case sensitive, therefore, do not capitalize
- Do no use any dash or underscore for mpid
First column: >mpid or vpcode
Second column: inventory
Comments
Please sign in to leave a comment.