Difference between revisions of "Import Stock"

From High5Wiki
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
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
+
### Available  (Quantity to add)
 
### LocationUID
 
### LocationUID
 
### ItemCost
 
### ItemCost
Line 27: Line 27:
 
## Use the Inventory Export file from step 1 to enter all the stock levels
 
## 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 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.
+
## Add a column Available 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.
 
## Save this file for example StockImport.xls
 
## Save this file for example StockImport.xls
 
## [[File:InventoryStockImport.png]]
 
## [[File:InventoryStockImport.png]]
Line 37: Line 37:
 
## Map the fields and set "Attempt Match" for Item UID
 
## Map the fields and set "Attempt Match" for Item UID
 
## [[File:StockImport2.png]]
 
## [[File:StockImport2.png]]
 
+
##
  
  

Latest revision as of 23:38, 11 February 2015

Once you have inventory list imported, you can import stock levels.

Here are the steps:

  1. First export your inventory list with the UID. You will need this UID to properly import stock quantities
    1. Go to Utilities>Export
    2. Select Inventory table
    3. Select the following fields to export:
      1. UID
      2. Name (optional to identify the item)
      3. Number (optional, should have either item name or number to identify the items)
      4. Cost
      5. Retail1
  2. Export your warehouse locations with UID
  3. Create at least one stock value manually, see Inventory Stock Levels
  4. Export Stock as a template for importing
    1. Go to Utilities>Export
    2. Select MatDetail table
    3. Select the following fields to export:
      1. ItemUID
      2. ItemName (optional)
      3. ItemNumber (optional, should have either item name or number to identify the items)
      4. Available (Quantity to add)
      5. LocationUID
      6. ItemCost
      7. ItemRetail
  5. Setup the Stock Import excel.
    1. Use the Inventory Export file from step 1 to enter all the stock levels
    2. Add column LocationUID and the value from step 4
    3. Add a column Available 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.
    4. Save this file for example StockImport.xls
    5. InventoryStockImport.png
  6. Import the Stock file
    1. Always perform a backup before importing!!
    2. Go to Utilities>Import
    3. Select the file from the step above, in this example StockImport.xls. Make sure the file type is selected. If you exported an xlsx file, then set filetype to xlsx.
    4. StockImport1.png
    5. Map the fields and set "Attempt Match" for Item UID
    6. StockImport2.png


ItemUID ItemName Quantity LocationUID VendorUID ItemCost ItemRetail IN10-13-051501412507 VMX Router Extreme 1 LC10-13-051357561250 VN10-19-051338231876 124.55 345