You are viewing this site in staging mode. Click in this bar to return to normal site.

KhooSeller Guides

(Formerly iPages Support)

SKU Locations

This article is for SKU locations. For warehouse locations, see Warehouse Setup

When you import stock into a warehouse, SKUs can have a location. This is divided into Zone, Aisle, Bay, Shelf and Bin. Zones can also be used when applying allocation rules

1) To do a stock take, go to MC Inventory - Data Exchange - Inventory Stock - Export

Choose a warehouse and click "export"

  

 

Here you will get a file that looks like this:

 

warehouse_title warehouse_zone_title location_aisle location_bay location_shelf location_bin qty batch_reference date_expiry date_manufacture inventory_guid inventory_batch_item_guid location_guid warehouse_guid warehouse_zone_guid
Warehouse name Zone name Aisle Bay Shelf Bin quantity Batch number Expiry Manufacture Date Key field for master inventory item Key field for master batch item  Key field for master location  Key field for master warehouse location  Key field for master warehouse zone. 

 

2) Update the rows as required.

If you want to change the quantity for an existing item, change the qty in the column for that SKU.

If you want to Move stock of an SKU to a new location, add or change the location_bin or other 'location' fields to the row.

If you want to Zero stock for an SKU set the qty column to Zero

If you don't want to edit an SKU either leave it alone or delete the entire row. (Don't leave the SKU but with blank data. Just delete the entire row).

If you want to add stock to several locations, add a new row for the new locations with the same SKU, but with blank GUIDs for the new rows:

 

 

3) Save the file as a CSV file and reimport to the Import section:

 

 

 

4. See also: allocation rules with multiple locations. These determine how stock is prioritised when picking. 

SKU Locations

This article is for SKU locations. For warehouse locations, see Warehouse Setup

When you import stock into a warehouse, SKUs can have a location. This is divided into Zone, Aisle, Bay, Shelf and Bin. Zones can also be used when applying allocation rules

1) To do a stock take, go to MC Inventory - Data Exchange - Inventory Stock - Export

Choose a warehouse and click "export"

  

 

Here you will get a file that looks like this:

 

warehouse_title warehouse_zone_title location_aisle location_bay location_shelf location_bin qty batch_reference date_expiry date_manufacture inventory_guid inventory_batch_item_guid location_guid warehouse_guid warehouse_zone_guid
Warehouse name Zone name Aisle Bay Shelf Bin quantity Batch number Expiry Manufacture Date Key field for master inventory item Key field for master batch item  Key field for master location  Key field for master warehouse location  Key field for master warehouse zone. 

 

2) Update the rows as required.

If you want to change the quantity for an existing item, change the qty in the column for that SKU.

If you want to Move stock of an SKU to a new location, add or change the location_bin or other 'location' fields to the row.

If you want to Zero stock for an SKU set the qty column to Zero

If you don't want to edit an SKU either leave it alone or delete the entire row. (Don't leave the SKU but with blank data. Just delete the entire row).

If you want to add stock to several locations, add a new row for the new locations with the same SKU, but with blank GUIDs for the new rows:

 

 

3) Save the file as a CSV file and reimport to the Import section:

 

 

 

4. See also: allocation rules with multiple locations. These determine how stock is prioritised when picking.