Inventory File Upload

Follow

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

mceclip0.png

 

3) Upload your file

Now you are ready to upload your file to the system: Go to OMS -> Tools -> Product Inventory File Upload

OMS--Product-Inventory-Management.jpg

 

Choose your file and click Import. The tool accepts both Excel and CSV formatted files.

choose-inventory-file.jpg

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

processing-inventory-file.jpg

For large files, over 20 product MPIDs, you are able to scroll through pages to view entire file contents.

processing-inventory-file-pages.jpg

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.

processing.jpg

The system will give you a brief summary and a list any mpids that were not updated.

upload-complete.jpg

 

Trouble Shooting

mceclip0.png

- 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

 

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.