The Lock Guys, Inc.

Inventory Tracker

ADMIN

Vehicle:

Loading...

Copy to Other Years

Year Range

to

Add Vehicle

Add a vehicle to the dropdown list that doesn't have any SKUs in the system yet.

Year

Make

Model

Customer Contacts

New Customer Contact

Customer Name *

Phone Number

Tech Name *

SKU (if ordering a key)

Follow-up in (days)

Notes *

📘 User Guide

Edit Help Page

Page Title

SKU Comparison

Parts Cross Reference

Submit Field Report

Year *

Make *

Model *

Key System

Job Type *

Result *

Programmer Used

Key Type Used

Notes

Photos (optional)

All Field Reports

Feedback

Share suggestions, report issues, or leave comments.

All Feedback

Change Password

You must change your password before continuing.

User Management

Add New User

Username

Password

Admin access

Activity Log

Login

Add SKU

Key Info

SKU *

Item Type

# of Buttons

FCC

Alt FCCs

IC

Main OEM Part #

Alt OEM Parts

Frequency

Chip Info

Alt SKUs

Description

Notes

Location

Drawer

Row

Column

Box #

Inventory & Pricing

Quantity

Restock Threshold

Alt Reorder Listing (optional)

Spare Key ($)

All Keys Lost ($)

Dealership ($)

Car Fitments

📊 Financial Dashboard

to

Add Expense

Date

Category *

Amount $ *

Description *

📋 Bulk Cost Import

Upload a CSV with SKU and Cost columns to set base-level key costs. These will be used as the starting average cost and will naturally blend with real PO data as you receive orders.

CSV Format: Two columns — first column is SKU, second is cost. Header row optional.
Example: LEX-23, 42.50
Pre-filled with all SKUs that have no cost yet. Open in Excel, fill in Column B, save, upload below.

Overwrite existing costs (by default, SKUs that already have an avg cost from POs are skipped)

📦 Historical Purchase Order

This will NOT change inventory quantities. It records purchase history and updates average cost calculations for the financial dashboard.

Vendor *

Vendor Order #

Sales Tax $

Shipping $

Notes

Line Items

💰 Historical Sale

This will NOT change inventory quantities. It records sales history for the financial dashboard and revenue tracking.

Sale Name *

Sale Date *

Notes

Items Sold

Inventory Adjustment

📦 Purchase Orders

New Purchase Order

Vendor *

Vendor Order #

Sales Tax $

Shipping $

Notes

Line Items

Receive Purchase Order

💰 Sales

New Sale

Sale Name *

Sale Date

Notes

Items Sold

Quantity Adjust

One SKU per line: SKU, quantity. Positive = add, negative = remove.

Note (optional)

Batch Pricing Update

Group (optional)

Item Type (optional)

Select group, type, or both. Leave prices empty to skip.

Spare Key ($)

All Keys Lost ($)

Dealership ($)

Upload CSV

Inventory (adds) Sales Report (removes)

Drag & drop CSV or

Inventory History

Loading...

Reorder Report

Loading...

Drawer Map

In Stock

Low Stock

Empty

Guides

Title

Content

Vehicle Compatibility (links this guide to vehicle landing pages)

-

Select a guide from the dropdown above${''}

Admin Tools

Loading...

Inventory History

Export / Import CSV

CSV Data Update

Upload CSV to mass-update fields. Blank cells skipped. Quantity never changed.

Database Backup

Bulk SKU Import

Historical Data Entry

Enter past purchase orders and sales for financial tracking. These do not affect current inventory quantities but do count toward average costs, revenue, and profit calculations.

Archive Old History

Inventory Usage Report

Track SKU usage and restocks over a date range.

Quick Range

Start

End

Sort

Inventory Audits

Monthly audits check a random sample (~10%) of SKUs. Quarterly audits cover the entire inventory. Due on the 1st of each month/quarter.

Data Audit

Danger Zone

Type DELETE ALL to confirm.