Inventory

Items

Items are either goods that you purchase from your vendors and sell to your customers, or, services that you provide for which you get paid. In Zoho Inventory, you can add these items with ease and manage their inventory such that, every time you create a purchase request to your vendor, its stock increases and when you sell the items, its stock decreases automatically.

The upcoming sections will guide you in detail on the various ways in which you can add your items and manage them in Zoho Inventory.

Create New Item

To create a new item in Zoho Inventory:

1. Go to the Items module under Inventory from the left sidebar.

2. Click the New Item button or the + New button on the top.

   

You can also create an item from a transaction on the fly. Here’s how:

1. Open a new sales or purchase transaction.

2. Go to the Item Details section and click the empty space under it.

3. Click the + Add New Item option from the drop-down.

   

In the New Item page, fill in the following details:

• Add Primary Details
• Add Sales & Purchase Details
• Add Inventory Tracking Details

Primary details

1. Choose whether your item should be classified under Goods or Service.

   Pro Tip: Service items can be used for adding packing costs, labor costs and other services. These items will not be displayed in while creating packages and shipments. You cannot track inventory for these items.

2. Enter the Name of the item.

3. Record the SKU (Stock Keeping Unit) for the item.

   Insight: The SKU field will serve as one of the unique identifiers for an item. Here, you can store your item’s barcode information, so that you can scan and retrieve the item while creating transactions.

4. Choose from or enter a unit of measurement (E.g. Kgs, Pieces, Liters etc.) for the item in the Unit field.

5. Choose a category or add a new category for your item. Learn more about item categories in Zoho Inventory.

6. Click the Returnable Item checkbox if you accept sales returns for this item. Sales returns can be created only for those items you qualify as returnable.

   

7. Upload different images of your item. You can upload up to fifteen images for an item.(File format: .gif, .png, ,jpeg, .jpg, .bmp; Max File Size: 5 MB each). Choose one picture as the primary image.

   

8. Record the dimensions of the item. This will be helpful if you want to calculate the package geometry for an order.

9. If applicable, you can record other product codes associated with the item in the UPC, EAN, MPN and ISBN fields.

   Insight: The UPC and EAN fields are numeric fields. The MPN and ISBN are alphanumeric fields that support alphabets, numbers, spaces and even hyphens.

   

Sales & Purchase Details

1. Enter the Selling Price and Purchase Price for the item.

2. Associate a sales account (The default account will be Sales) and a purchase account (The default account will be Cost of Goods Sold).

   Pro Tip: You can also add a new account under ‘Cost of Goods Sold’ by clicking the + New Account option from the Account drop-down. You can then associate the new account to the item to keep track of the purchases.

3. Add a brief sales and purchase description for your item which will be displayed on all the respective transactions.

4. Choose a tax preference for your item.

   

Inventory Tracking Details

1. Select the Track Bin Location for this item option if you wish to track the bin locations for this item. You cannot disable this option once you have recorded transactions for this item.

2. If you have enabled Advanced Inventory Tracking in Settings for your organisation, choose whether you want to track your items by serial numbers or by batch. If you want neither, choose None and proceed.

3. Select an account to track the inventory for your items.

4. Select an Inventory Valuation Method:

   • FIFO (First In, First Out): In this method, the inventory gets tracked based on the First In, First Out system, which lets you assess the value of your inventory. This simply means the oldest inventory items recorded are sold first. Learn more about FIFO.
   • WAC (Weighted Average Costing): In this method, the average cost of all the inventory items will be calculated. The average cost is then used to determine the Cost of Goods Sold (COGS) and the value of your remaining inventory. Learn more about WAC.
   

5. Select the Reorder Point. A notification will be sent out to you, which will help you keep tabs on the stock levels of your items so you never run out of stock.
6. Enter the Opening Stock (if any) and Opening Stock Value, which is the average purchase price of the item. If you have enabled multi-warehouse, enter the Opening Stock and Opening Stock Value for each warehouse.

Advance Inventory Tracking

Zoho Inventory provides two advance features to track your stock flow accurately. But first, make sure to enable Advance Inventory Tracking in your item preferences and check the Track Inventory option in the New Item page to access the advanced inventory tracking options for your item.

• Serial Number Tracking
• Batch Number Tracking

Track Serial Numbers

To track your item by serial numbers:

1. Open the new item page and fill in the necessary details.

2. Choose the Track Serial Number option under Advanced Inventory Tracking.

3. If you’ve entered an opening stock, you can add serial numbers for the given opening stock in the field below.

4. If you have enabled multi-warehouse in your organization, click the ellipsis icon at the end of each warehouse row and click Add Serial Numbers.

   

5. Enter the serial number for the opening stock given in each warehouse.

   Insight:

   • You can enter up to 200 serial numbers for an opening stock.
   • You can either enter the serial numbers manually or scan the barcode of the item.
   

6. Click Save. The serial numbers will now be available for your sales transactions. You can also choose to save the item and enter the serial numbers at a later point while creating a bill.

Track Batch Numbers

1. Open the new item page and fill in the necessary details.

2. Choose Track Batches under Advanced Inventory Tracking.

3. If you’ve entered an opening stock, you can add batch details for the given opening stock in the fields below.

4. If you have enabled multi-warehouse in your organization, click the ellipsis icon at the end of each warehouse row and click Add Batches.

   

5. Enter the batch details for the opening stock given in each warehouse.

   Insight: You can enter up to 100 batch numbers for an opening stock.

   

• You’ll also be able to enter batch numbers for items while recording a new bill.

Import Items

To import items into your Zoho Inventory account:

1. Navigate to the Items module under Inventory from the left sidebar.

2. Click on the icon.

3. Select the Import Items option.

   

4. Click Upload File to browse and select the file to upload from your device.

5. To update the details of all your items at one go, you can choose the overwrite option while importing. Learn how.

6. Choose the character encoding involved from the drop-down. By default, the character encoding is UTF-8(Unicode).

7. Choose the File Delimiter(comma or semicolon). By default it will be comma for a .csv type file.

8. Click Next to proceed to mapping the fields.

   

9. To overwrite duplicate records, you must choose a unique field (Item Name, Item ID or SKU) which will be mapped with the equivalent field from the import file. If the values match, then its corresponding records will be overwritten with the data in the import file. For example, if you want to update item names, you can choose Item ID or SKU as the unique field. If the SKU/Item ID that you’re trying to import exists, then its corresponding item name and other details will get updated.

10. Zoho Inventory finds similar fields and maps them automatically. You can make changes, if needed.

11. Check the box near the Save these selections for use during future imports option to automate mapping for future imports.

12. Click Next to proceed to the Preview window.

    

13. View a summary of the number of invoices ready for import, number of skipped records and unmapped fields will be shown.

14. Click Previous to make any changes. If everything is ready, click Import.

    

Import Items from Zoho Books

Zoho Books is an in-house accounting platform that is built to seamlessly integrate with Zoho Inventory. This means that all your customer information, item information, transactions etc., entered in one of these platforms will automatically be available in the other, thus, preventing double entry.

If you already have an organization in Zoho Books, learn how you can integrate it with Zoho Inventory.

Import Products from Zoho CRM

You can pull the items into Zoho Inventory from Zoho CRM. Learn more about:

• Integrating Zoho Inventory with Zoho CRM.
• Configuring your product sync.
• Triggering an instant sync between Zoho Inventory and Zoho CRM.