Stock-taking

The platform enables you to verify the quantities, weight, or any other quantifiable attribute of items in your inventory.

Prerequisite

Before stock-taking, the inventories first need to exist under the Inventory section. See the guide on setting up inventory.

If you haven’t set up inventory locations, ensure that they’re set up.

You then need to customize the Stock-take Data Capture fields so that you can gather the details you need about the inventories.

There are several ways to stock-take.

Stock-taking from the smartphone app

If you have barcodes or NFC tags, you can scan them using our iOS & Android apps, then indicate the adjustment that should be made.

On the smartphone app, go to Stock-take, then fill out the form with the total stock count. You should then indicate what should be done with the inventory totals.

You can either have the app increment, deduct, or set their new values.

Stock-taking from the web app

From the Manage Inventory > Stock-take page, go to Add New Records > Add A Single Record option.

On the page that follows, fill out the form and indicate how the inventory should be adjusted.

If you’re using Bluetooth or USB scanners, you can scan the barcodes or NFC Tags, then fill out the spreadsheet (based on your custom fields).

On that web spreadsheet, unless indicated otherwise, the app will increment the inventory values being counted.

To have a deduction made, simply append “-” to the number. For example, “-5” to deduct 5.

To have the value replaced, simply append “=” to the number. For example, “=10” to set an inventory’s new value to 10.

Stock-taking by importing CSV files

You can also import data by going to the Add New Records > Import From CSV option.

When importing CSV files, ensure that your data is aligned properly as shown on the example templates.

Stock-taking via automated workflows

Using Zapier

Using Zapier, you can automate how stock-takes are recorded in your account. For example, you could edit a Google Sheet or Excel spreadsheet row, and have the data on that row automatically used to create an inventory stock-take record.

You first need to set up a Zap trigger.

After that, choose the app Ventipix Asset & Inventory Manager, and the action Create Stock Take.

Click on Continue, then authenticate your account.

In the step that follows, map data from your Zap trigger on to the fields that you want to populate automatically.

Proceed to then test the integration, and turn the Zap on.

Using Microsoft Power Automate

Using Microsoft Power Automate, you can also automate how assets are added to your account from other platforms (flows). For example, you could set up a trigger or schedule whereby data from the source platform is automatically used to create an asset in your account.

In your Power Automate account, set up a new flow, for example, “Automated – from blank” or “Scheduled – from blank“.

After that, choose the connector with the data source, and its appropriate action. If using Excel, you would choose, “list rows present in a table“. For example:

If using Google Sheets, you would choose, “Get rows“. For example:

Once the connector has been set up with all its authentication requirements, and file location details, proceed to add a new step.

In this new step, search for “Ventipix Asset and Inventory” connector. Then, under its Action menu, select, “Create an asset or inventory record“.