Inventory

You are here:
Table of Contents

The platform enables you to track adjustments made to inventories. Multiple locations are supported, and adjustments for each location is accounted for separately.

Where multiple locations are involved, each inventory record would be associated with a single unique location.

Preliminaries

Inventory is the main point of entry for adding inventory data to the platform.

In order to add or import inventory, you first need to customize the Record Inventory Data Capture fields so that you can gather the details you need about them.

Location is a recommended field to have. If it does not exist, create one custom field named “Location”, with the Answer Type set to “Select”. In the “Options” column, enter comma-separated location details.

If the location has a barcode or NFC tag, then an appropriate Answer Type would be “Barcode Scan/ NFC Tag”.

When adding inventory, each inventory record in a location will need a unique identifier (a unique ID, SKU, etc, as long as it’s unique). This is what will be used when scanning barcodes or NFC tags.

After that, the next step would be to add the inventory data to the platform.

Adding inventory records from the web app

Option 1 – Add inventory records individually

Go to Manage InventoryInventory page, click on the Add Manually button. Fill in the form on the new page.

To edit the record, find it on the table, then go to Actions > Edit.

Option 2 – Import multiple inventories using a CSV file

Go to Manage InventoryInventory page, click on the Import From CSV button. Upload a CSV file based on the guidelines shown on the new page.

Existing records can be edited by uploading the CSV, provided that the Barcode/NFC Tag ID, and location value is the same.

Option 3 – Import from Apps such as QuickBooks, Square or Shopify

If your account is connected with QuickBooks Online, Square, or Shopify, you can import your inventories. To do so, go to Manage Inventory > Inventory, then click on the Import from Apps button.

Option 4 – Use an online spreadsheet

Go to Manage Inventory > Inventory page, click on the Scan To Spreadsheet button. On the new page, use our smartphone app to scan barcodes or NFC tags, then populate the rest of the spreadsheet.

Adding inventory records from the smartphone app

If you have barcodes or NFC tags, you can scan them using our iOS & Android apps, then fill in the form with your inventory details.

On the smartphone app, go to Add/Update Inventory Details, to add new or edit existing inventory.

Adding inventory records via automated workflows

Using Zapier, you can automate how inventory records are added to your account. For example, you could edit a Google Sheet row, and have the data on that row automatically used to create an inventory record.

You first need to set up a Zap trigger.

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

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.