Magento multi warehouse for POS by Ebizmarts

Module setup

Please see below for the recommended steps after you have the module installed in your Magento store.

Create Warehouses

  1. Create Warehouses in Magento Admin > Catalog > Ebizmarts Warehouse > Warehouses
  2. Go to Magento Admin > Configuration > Stock Warehouses.
  3. Select the store from the Current Configuration Scope.
  4. Associate a Warehouse to the store in the current scope.

Assign a product product to a warehouse

  1. Go to Catalog > Manage Products.
  2. Select the store again
  3. Select a product.
  4. Go to inventory.
  5. Qty in that screen is Magento default stock, it should be the total stock if you sum the stock for all your items on all your warehouses.
  6. Go to Warehouse Activity.
  7. You'll see there all the stock movements, like which order consumed stock, or when you added a new movement for that item. If you want to add stock for that item, click on the Add New Movement to Inventory, once added, you've have the quantities you've selected for that product, in the warehouse associated to the store selected in step 2.

Moving stock from warehouse A to warehouse B

  1. Go to Catalog > Manage Products.
  2. Select the origin store.
  3. Select the item.
  4. Go to Warehouse Activity.
  5. Click on Move Inventory.
  6. Select Destination, Quantity, Description or a note if you want and click on Save.


Stock bulk import

In order to import stock in bulk a CSV file is needed, please see below for instructions on how to get this done.

Create a CSV file with the following columns: warehouse, sku, sign, stock and comment.

Columns explained

  • warehouse: The warehouse code (that was added when the depot was created).
  • sku : The Magento product sku attribute.
  • sign: + to add stock, - to subtract stock or * to overwrite Magento stock value.
  • stock: The quantity to add or subtract.
  • comment: A comment to add to the movements table.
  • active: Place "yes" if you want to activate this product for this warehouse, "no" to deactivate it or leave it blank to leave as it is.

Once you finished creating the file please upload it to $MAGENTO_ROOT_DIR$/var/import/warehousestock.csv, the file name must be warehousestock.csv

Configure the profiler importer

Final step, login to your Magento admin panel, go to System > Import/Export > Dataflow-Advanced Profiles.

Select Import WarehouseStock(Ebizmarts), once selected in the left menu go to Run Profile, finally click on Run Profile in Popup.

Import via Magento's SOAP Api, see sample code here.