Product Log

Catalog your purchases or collections using name or UPC!

PURPOSE

Product Log is a customizable purchase and collection tracker built using the flutter SDK. Users can enter product information to be stored in a local SQLite database. No information is stored on the cloud, making all information secure on the user's device. I created a Product Log as a way for my mom, who is very into scrapbooking, to log her collection of markers and other tools. I now use Product Log to document my collection of speedcubes and accessories.

ABOUT

Product Log allows you to catalog purchases and collections using an intuitive GUI. You can add products by scanning their UPC or simply using the add product button. Users can recall product information through scanning the UPC, entering the product name, or finding it under the log tab. A multitude of product information is able to be stored, with only product IDs (autogenerated or scanned) and names being required. Short descriptions of each field are listed below.

ID

The product ID is used as the primary key of the SQL database. It's used internally for lookups and recalling product information. The product ID is either autogenerated or is derived from the product's UPC code. Users will generally not enter product ID manually, but can if they wish.

IMAGE

The product's image is a quick snapshot of what the product looks like. It is stored internally in the SQL database, not as a file on the device. Users can take a picture of their product with the camera icon, or upload an image with the upload icon.

NAME

The name of the product and the only required field. Simply used so the user can identify the product.

MANUFACTURER

The producer or the original creator of the product.

DESCRIPTION

User-generated description of the product, such as its physical appearance, function, how to use, etc.

QUANTITY

How many of these products have been purchased? Generally used with a price to compute the total price.

PRICE

How much the product originally cost, used with quantity to calculate a total price.

SOURCE

Where the product was purchased from, or how the product was acquired.

SITE LINK

If this product was purchased from a website or has a website attached to it.

RATING

A star rating from 0-5 (decimals allowed) for how happy the user is with a specific product.

FAVORITE

If this product is a favorite or not. If it is, it will glow red and have a filled-in heart icon.

HIDE-UPC

You can hide the UPC for products (especially those without them and autogenerated IDs) using this checkbox. You can also hide all UPCs without needing to use this button (such as for a basic collection) using collection mode on the settings page.

INITIAL PURCHASE DATE

When this product was first purchased by the user.

TAGS

Users can enter as many tags as they'd like about a product. These tags can be used to group products. The search functionality works with tags.

FIND PAGE

Here you can either scan a barcode or search for a product by ID. Scanning a barcode opens a barcode scanning screen, and when a barcode is detected it is automatically searched and looked up. If it exists, the product is shown, if not, the user is prompted to confirm if they wish to create the product.

LOG PAGE

This page includes a list of products that can be sorted or searched within. The sort button allows sorting by ID, Name, Date Added, or Rating. The search button allows users to search for products by name, name portion, tag, or tag portion.

SETTINGS

Users can change a few settings to customize their experience. These settings include changing between light and dark mode, changing their primary color, changing the collection name, changing their currency symbol, and managing the database. Users can backup or import their SQLite databases here. Users can also toggle collection mode.

COLLECTION MODE

Collection mode simply hides all UPCs and removes the ability to scan barcodes. This setting exists for users who just wish to catalog a simple collection without scanning barcodes.