Update Hard Goods Inventory
In this article, you will learn about how to upload Hard Goods Inventory with an Excel file.
User Roles: Accounts Receivables, Admin, Credit Manager, Procurement Manager, Sales Manager, Setup, and Shipping.
Table of Contents
Upload Hard Goods Inventory with an Excel File
To upload new products or update products in the inventory, do the following instructions:
Go to Setup and select Data Import.
Select Hard Goods - Inventory & Product List from the drop-down menu.
Optional: Download a template for updating your inventory.
There are two templates available:Empty Template. Use it to add new Hard Good products.
Excel file of your hard goods. Modify the information for your current hard goods.
Optional: Check the Update Inventory box to update existing products in the inventory with the information from the Excel file. The system will use the product ID when updating information to ensure accuracy.
Upload the file by dragging it to the file area or clicking and selecting it from your files.
Once the import process is complete, the system will send an email notification to the logged-in user confirming if the import was successful or if any records failed to upload. You can review the inventory and make necessary adjustments by going to the Setup > Products > Hard Goods screen.
File Size Limit
The system allows uploading a maximum of 5000 rows per file, and you can upload a maximum of 999 hard goods per line at once.
For Multi-Location Companies
If you choose to enable the "Update Inventory" option in step 4, you will need to select the locations for which you want to update inventory. Select "All" to update prices and costs for all locations at once.
Related Articles
-
Create Purchase Orders from Vendor Availability and K2K (Knowledge Base)
-
Data Import (Knowledge Base)
-
Create Standalone Purchase Orders (Knowledge Base)
-
Create a Template for Purchase Orders (Knowledge Base)
-
Add Hard Goods to a Purchase Order (Knowledge Base)