Import Stock - Revision history

Marks at 23:38, 11 February 2015

2015-02-11T23:38:56Z

Marks at 21:55, 9 February 2015

2015-02-09T21:55:22Z

Marks at 21:43, 9 February 2015

2015-02-09T21:43:49Z

Marks at 21:42, 9 February 2015

2015-02-09T21:42:23Z

Marks at 21:40, 9 February 2015

2015-02-09T21:40:13Z

Marks at 21:30, 9 February 2015

2015-02-09T21:30:10Z

Marks: Created page with "Once you have inventory list imported, you can import stock levels. Here are the steps: # First export your inventory list with the UID. You will need this UID to properly impo..."

2015-02-09T21:17:37Z

Created page with "Once you have inventory list imported, you can import stock levels. Here are the steps: # First export your inventory list with the UID. You will need this UID to properly impo..."

New page

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

Here are the steps:
# First export your inventory list with the UID. You will need this UID to properly import stock quantities
# Export your warehouse locations with UID
# Create at least one stock value manually, see [[

@@ Line 20: / Line 20: @@
 ### ItemName (optional)
 ### ItemNumber (optional, should have either item name or number to identify the items)
-### Quantity
+### Available  (Quantity to add)
 ### LocationUID
 ### ItemCost
@@ Line 27: / Line 27: @@
 ## Use the Inventory Export file from step 1 to enter all the stock levels
 ## 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
 ## [[File:InventoryStockImport.png]]

@@ Line 37: / Line 37: @@
 ## Map the fields and set "Attempt Match" for Item UID
 ## [[File:StockImport2.png]]
-## [[File:MatchingRecord.png]]
+##

@@ Line 37: / Line 37: @@
 ## Map the fields and set "Attempt Match" for Item UID
 ## [[File:StockImport2.png]]
+## [[File:MatchingRecord.png]]

@@ 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.
 ## [[File:StockImport1.png]]
 ## [[File:StockImport2.png]]

@@ Line 24: / Line 24: @@
 ### ItemCost
 ### ItemRetail
-# Use the Inventory Export file from step 1 to enter all the stock levels
+# Setup the Stock Import excel.
 ## 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.
 ## [[File:InventoryStockImport.png]]
 ItemUID	ItemName	Quantity	LocationUID	VendorUID	ItemCost	ItemRetail
 IN10-13-051501412507	VMX Router Extreme	1	LC10-13-051357561250	VN10-19-051338231876	124.55	345

@@ Line 3: / Line 3: @@
 Here are the steps:
 # First export your inventory list with the UID.  You will need this UID to properly import stock quantities
 # Export your warehouse locations with UID
-# Create at least one stock value manually, see [[
+# Create at least one stock value manually, see [[Inventory Stock Levels]]