Difference between revisions of "Import Stock"

From High5Wiki
Jump to navigation Jump to search
Line 35: Line 35:
 
## 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.
 
## 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.
 
## [[File:StockImport1.png]]
 
## [[File:StockImport1.png]]
 +
## Map the fields and set "Attempt Match" for Item UID
 
## [[File:StockImport2.png]]
 
## [[File:StockImport2.png]]
  

Revision as of 21:42, 9 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. Quantity
      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 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.
    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