The inventory management template is an automated workflow that consists of 4 spreadsheet files and 3 forms. The first 3 spreadsheets are dedicated to different aspects of your inventory: items, check-in, and check-out. The items sheet is connected to both the check-in and check-out sheets.<\/span><\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/inventory-scanner-1.png” title_text=”inventory scanner 1″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
All of these spreadsheets are connected to a master sheet, which is your inventory database. This master sheet helps sort your data and provides insights into your inventory through a visual dashboard.<\/span><\/p>\nAdditionally, Sheetgo offers forms that simplify the inventory management process. There are three forms for each area of your inventory: item registration, check-in, and check-out. These forms include a barcode scanner system that can automate the entire item management process. Once you scan or input your items, Sheetgo automatically transfers the data into the corresponding spreadsheets for your use.<\/span><\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
4. Using the Sheetgo forms to input your items<\/span><\/h3>\nThere are 3 Sheetgo forms that will help you input your data into the spreadsheets.<\/span><\/p>\nRegister item:<\/b> Input new items into your inventory using the register item form.<\/span><\/p>\nCheck-in item: <\/b>Input the items that have entered the inventory with the check-in item form.<\/span><\/p>\nCheck-out item:<\/b> This form is used to show which items have left the inventory.<\/span><\/p>\nWhen you fill out the forms, Sheetgo will automatically transfer the data to the corresponding spreadsheet and update the rest of the sheets accordingly.<\/span><\/p>\nIn order to register an item, open the corresponding form and input the data into the fields.<\/span><\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/inventory-scanner-4.png” title_text=”inventory scanner 4″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Whenever you want to check in or check out an item, open the corresponding form and use your inventory scanner to read the barcode.<\/span><\/p>\nBear in mind that you can also use a mobile phone, a tablet or a computer camera to scan the barcode. Once you submit your forms, Sheetgo will automatically transfer your data to the other spreadsheets.<\/span><\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/inventory-scanner-2.png” title_text=”inventory scanner 2″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
5. Checking your master spreadsheet<\/span><\/h3>\nYou can track real-time inventory levels by opening the master spreadsheet at any time.\u00a0<\/span><\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/inventory-scanner-5.png” title_text=”inventory scanner 5″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
6. Schedule automatic updates<\/span><\/h3>\nIf you want to schedule automatic updates, click on the floating menu bar inside your workflow and select Automate.<\/span><\/p>\nSelect how often you want automatic updates: hourly, daily, weekly, or monthly.<\/span><\/p>\nSheetgo will automatically update the data in all spreadsheets.<\/span><\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/inventory-scanner-6.png” title_text=”inventory scanner 6″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
7. Share the workflow with your team members<\/span><\/h3>\nYour team members can have access to the forms and help you check in and check out the items.<\/span><\/p>\nIn order to share the workflow with your team members, click the <\/span>Share<\/b> icon and add their email addresses.<\/span><\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/inventory-scanner-7.png” title_text=”inventory scanner 7″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
How to use an inventory scanner in your inventory system<\/span><\/h3>\nThere you have it! Now your inventory management system is up and running.\u00a0<\/span><\/p>\nNow you can keep track of inventory with an easy-to-use inventory management system and a barcode scanner.<\/span><\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
An inventory scanner, also known as a barcode scanner or a scan gun, is a handheld device used to scan and read barcodes on products. These devices are often used in warehouses, factories, and retail stores to track and monitor inventory levels. We all know how important it is for manufacturers and retailers to keep […]<\/p>\n","protected":false},"author":50,"featured_media":42309,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[38],"tags":[],"class_list":["post-42307","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-inventory-processes"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/42307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/50"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=42307"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/42307\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/42309"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=42307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=42307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=42307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/icon-inventory-barcode-1.svg\"){kind=icon}
<\/div>\n![](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/template-banners-rating-2m.svg\")