Editing Import Stock
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 20: | Line 20: | ||
### ItemName (optional) | ### ItemName (optional) | ||
### ItemNumber (optional, should have either item name or number to identify the items) | ### ItemNumber (optional, should have either item name or number to identify the items) | ||
− | ### | + | ### Quantity |
### LocationUID | ### LocationUID | ||
### ItemCost | ### ItemCost | ||
### ItemRetail | ### ItemRetail | ||
− | + | # Use the Inventory Export file from step 1 to enter all the stock levels | |
− | |||
## Add column LocationUID and the value from step 4 | ## Add column LocationUID and the value from step 4 | ||
− | ## Add a column | + | ## Add a column Quantity and set the quantity you want to import. NOTE: This is good for initial quantity or for ADDING stock, it should NOT be used for setting stock level as this will ADD the quantity set and imported. |
− | |||
## [[File:InventoryStockImport.png]] | ## [[File:InventoryStockImport.png]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
ItemUID ItemName Quantity LocationUID VendorUID ItemCost ItemRetail | ItemUID ItemName Quantity LocationUID VendorUID ItemCost ItemRetail | ||
IN10-13-051501412507 VMX Router Extreme 1 LC10-13-051357561250 VN10-19-051338231876 124.55 345 | IN10-13-051501412507 VMX Router Extreme 1 LC10-13-051357561250 VN10-19-051338231876 124.55 345 |