Importing SKUs and Inventory

SKUs or Stock Keeping Units is the description of items that can potentially be moved in or out of an Inventory. SKUs can be moved into or moved out from any Inventory (any Branch and/or Container) by creating an incoming or an outgoing Logistic. Logistics are automatically maintained in the normal course of doing business when you raise invoices or make purchases.

While Webrino allows you to manually add or edit individual SKUs, its easiest to import SKU and inventory information from a CSV (comma-separated values) file. As an administrator, you can define all your SKUs in a Microsoft Excel spreadsheet and save the file into .CSV format. Then this data can be directly imported into Webrino.

Learn more about SKUs, Inventory and Logistics

 

  Importing SKUs

Check which CSV file you should download: In the main menu, go to: Administration > System Configuration. search for Keyword "autogen_sku". Look at the Key / Module column in the resulting table and check against "inventory_autogen_sku_keys". If the Value column of this variable is true then your copy of Webrino is set up to use part numbers auto-generated by Webrino. Otherwise, you are defining your own custom part numbers.

 

Download the CSV template for importing SKUs with auto-generated part numbers by Webrino or custom part numbers defined by your Business.

The spreadsheet format is described below with Column A being the left-most column, Column B the one to the right of Column A and so on. All columns are mandatory unless specified otherwise. If any field contains a comma, ensure that the field contents is within double quotes (if you're using Microsoft Excel then this is done automatically):

Part Numbers auto-generated by Webrino:

  • Column A: Should be the SKU Name. Eg: BrandName 500 GB SATA Internal Hard Disk
  • Column B: Description of the SKU. Eg: 500 GB Internal HDD at 7200RPM connected via SATA cable
  • Column C: Unit of storage. Eg: Nos. or Kgs. or Liters
  • (Optional) Column D: Category of the SKU. Eg: Computer Parts. If supplied and the category doesn't exist, the category is automatically created.
  • Column E: Apply Excise Duty (India). Specify: "Y" for Excise applies, "N" if there is no excise duty.
  • (Optional) Column F: Quantity to trigger Inventory Low events.
  • (Optional) Column G: Quantity to trigger Inventory High events.
  • (Optional) Column H: Lead time (in days) to replenish the inventory.
  • (Optional) Column I ...onwards...: Pricing Info (see below for details)

Pricing columns I & J: This is the sale price and rental price columns in INR (currency #1). Eg: a value of 16500 in Column I would indicate a sale price of the SKU at INR 16,500 per Unit of storage. To specify rental price in Column J, separate the prices with duration by semicolons. Eg: 3500/m;1000/w;200/d in this column would indicate a monthly rental price of INR 3,500; weekly rental price of INR 1,000 and a daily rental price of INR 200.

Pricing columns K & L: Same format as for I & J but these prices are in USD (currency #2).

Pricing columns M & N: Same format as for I & J but these prices are in GBP (currency #3).

Part Numbers custom defined by your Business:

Insert a new Column A: Custom Part number. The other columns are the same as defined above, except they are shifted right by the new column. That is, SKU Name will become Column B, Description will become Column C, Unit of storage Column D and so on.

To import SKUs, choose the following in the Webrino menu:
Administration > Webrino Wizards > Import SKUs

 

Importing Inventory

Importing inventory is not yet available. To build up your inventory, first import all your SKUs and define the branches where the inventory will be stored. After that, add all Incoming Logistics to build your current inventory levels. See SKUs, Inventory and Logistics for more details