Holiday Lights Inventory Management

Holiday lighting services require specialized inventory tracking that goes beyond standard cleaning supplies. Current Clean Estimate V2 keeps Holiday Lights stock in the same location-scoped Field > Ops inventory ledger used for other consumables, then adds Holiday install/takedown allocation.

Navigate to Field > Ops to manage Holiday Lights inventory.

Current V2 includes the richer V1-style item catalog, on-hand stock, reorder alerts, an append-only movement history, supplier purchase orders with partial/full receiving, install allocation, and takedown returns/shrinkage. Dedicated warehouse detail pages, demand projection, and end-of-season reporting remain required parity. A dedicated strand-testing workflow is intentionally out of scope.

When a customer accepts a Holiday Lights package, the linked install and takedown work carries the saved installation week, removal timing or request, customer and crew notes, and storage preference. Those fields guide the office and crew without auto-booking an exact route day or changing inventory counts. Keep material allocations attached to the install job and record reusable material returns against the takedown job; the saved storage choice remains part of that accepted handoff.

Why Separate Inventory Tracking

Holiday lighting inventory has characteristics that make it unsuitable for general inventory tracking:

• Seasonal usage. Supplies are purchased, deployed, retrieved, and stored on a yearly cycle. They sit idle for months between seasons.
• Condition tracking. Light strands degrade over time and must be tested before each season. General inventory items do not need condition assessments.
• Customer allocation. Strands and hardware are often allocated to specific customer installations and must be tracked at that level.
• Reusability. Unlike cleaning chemicals that are consumed, lighting supplies are reused across multiple seasons, making asset tracking essential.

Current V2 covers richer item attributes, supplier purchasing and receiving, stock movement, job allocation, and returns/shrinkage in the shared Ops inventory. Material-demand projection and end-of-season analysis remain open parity work.

Inventory Categories

The holiday lights inventory organizes items into categories that reflect the types of supplies used in lighting installations.

Light Strands

Light strands are the core product. Track them by:

Clips and Mounting Hardware

Track the clips, hooks, and fasteners used to attach lights to rooflines, gutters, and architectural features.

Electrical Supplies

Storage Supplies

Adding Inventory Items

Adding a Single Item

1. Navigate to Field > Ops.
2. In Inventory catalog, select Add inventory item.
3. Fill in the item details:

• Item name -- A descriptive name (e.g., "C9 LED Warm White - 50 ft").
• Category -- Select from Light Strands, Clips, Electrical, or Storage.
• Unit -- The counted unit, such as strand, box, or each.
• Service location -- The office or warehouse location that owns the stock.
• Reorder point -- The quantity threshold that triggers a low-stock alert.
• Opening quantity -- The stock already on hand when the item is created.

1. Save the item. The opening quantity creates the first append-only Received

movement automatically, preserving the opening count in the ledger.

Use Adjust after creation for later received, returned, allocated, shrink, or corrected-count movements. An item's unit can be corrected before its first movement; after stock history exists, the unit stays fixed so every prior quantity retains the same meaning.

Bulk Entry

V1's batch-entry and richer warehouse-detail controls have not yet been restored in V2. Add current items individually so every opening quantity remains auditable.

Purchase Orders

Current V2 status: supplier purchase orders and partial/full receiving are available from Field > Ops > Purchase orders. The workflow uses V1's useful order lifecycle on V2's location-scoped, retry-safe inventory ledger.

Purchase orders track orders placed with suppliers for new lighting supplies. They help you plan seasonal purchasing, track costs, and manage receiving.

Creating a Purchase Order

1. Navigate to Field > Ops > Purchase orders.
2. Click Create order.
3. Enter the supplier information:

• Supplier name
• Contact information
• Expected delivery date

1. Add line items:

• Select or enter the product name.
• Specify the quantity ordered.
• Enter the unit cost.
• The line total calculates automatically.

1. Review the purchase order total.
2. Click Create draft, review the order, then click Mark ordered after

placing it with the supplier.

Purchase Order Statuses

Each purchase order moves through a lifecycle:

Receiving a Purchase Order

When a shipment arrives:

1. Open the purchase order.
2. Click Receive.
3. Enter the quantities received beside each delivered line item.
4. Click Receive delivery.

The system updates inventory automatically and records a Received movement for each line. If only a partial shipment arrived, enter only those quantities; the PO changes to Partially received and keeps the remaining quantities open. The same retry cannot add stock twice, and V2 refuses quantities above what was ordered. Simultaneous deliveries that share catalog items lock those items in a stable order before stock changes are written, avoiding conflicting receipt order while keeping each delivery atomic.

Pre-Season Purchasing Workflow

Most holiday lighting businesses follow a purchasing calendar:

Strand-testing scope

Clean Estimate V2 does not include a dedicated strand-testing log, metrics, or quality-history workflow. That workflow is intentionally outside the required product scope rather than an unfinished feature.

Seasonal Inventory Workflows

Holiday lighting inventory follows a distinct seasonal cycle. Each phase has specific inventory management tasks.

Pre-Season (August - October)

1. Audit existing inventory. Count all items in storage. Update quantities in the system to match physical counts.
2. Calculate needs. Review signed contracts and proposals to determine how many strands, clips, and accessories you will need for the upcoming season.
3. Place purchase orders. Order new stock to fill gaps between existing inventory and projected needs. Order early -- suppliers often run low on popular items by October.
4. Receive and organize. When orders arrive, receive them in the system, label them, and organize them in storage by type and color.

Installation Season (October - December)

1. Allocate inventory to jobs. When a job is scheduled, allocate the required strands and hardware from the job's service location.
2. Track deployments. Keep each material allocation attached to the install job rather than changing the catalog item's service location. This preserves the warehouse ledger while recording the correct property.
3. Monitor stock levels. Watch for low-stock alerts on clips, extension cords, and frequently used strand types. Place supplemental orders as needed.
4. Handle field issues. When material fails during installation, record the lost quantity as shrink with a useful note and pull a replacement from stock.

Retrieval Season (after each saved removal month)

1. Retrieve installed lights. Open the accepted takedown work to follow its

saved removal and storage preferences, then record the returned items as crews take down installations.

1. Inspect returned items. Separate damaged material physically and record shrink when stock cannot return to service. Dedicated condition and repair history remain part of the deferred end-of-season workflow.
2. Return to storage. Record the takedown return so reusable material is added back to inventory, then update its rack/bin storage detail if needed.
3. Reconcile. Compare the items returned from each customer against what was deployed. Identify any losses.

Off-Season (March - July)

1. Post-season audit. Conduct a full inventory count and reconcile with the system.
2. Retire damaged items. Remove items that are beyond repair from active inventory.
3. Analyze usage. Review which strand types and colors were most popular. Identify items with high failure rates. Use this data to inform next season's purchasing decisions.
4. Plan early purchases. Some suppliers offer pre-season discounts for orders placed in the spring. Identify your needs early and lock in pricing.

Low-Stock Alerts

Items with a quantity at or below their configured reorder point are flagged in the inventory catalog's Low stock summary and on each affected row. Select the Low stock filter to focus on only the items that need attention.

Set reorder points based on your peak weekly installation volume, not your average. Running out of C9 warm white strands during the busiest week of the season causes installation delays and lost revenue.

Storage Location Tracking

If you operate from multiple warehouses or storage facilities, create a separate catalog item for each service location that owns stock. The service location is fixed after creation so its ledger, purchase orders, and receipts remain connected. Use Storage location for the rack, aisle, bay, bin, or other within-warehouse detail, such as "Warehouse B · Bay 3." Job allocations track deployed material without changing either location field.

Cost Tracking

Purchase orders retain the unit and extended cost of every ordered line. Use that purchasing history to review:

• Calculate the true cost of each installation (materials plus labor).
• Determine which strand types offer the best margins.
• Identify whether reusing strands across seasons is cost-effective versus buying new each year.
• Set accurate pricing for your holiday lighting proposals.

Review your cost data at the end of each season to refine next year's pricing. Automated purchase-order-to-profitability reporting remains future parity; current reports do not silently treat PO costs as job costs.

Tips

• Label everything. Physical labels on storage bins that match your digital inventory categories save enormous time during the busy season.
• Track by customer. Recording which strands went to which property makes retrieval faster and helps you plan repeat installations with the same setup.
• Set aggressive reorder points for clips. Clips are inexpensive and used in high volume. Running out mid-season delays installations and frustrates crews.
• Reconcile after every season. Physical counts after retrieval season catch discrepancies before they compound year over year.
• Order popular colors early. Warm white and multi-color strands sell out at suppliers first. Place orders by August for guaranteed availability.
• Track cost per installation. Use purchase order data to calculate your material cost per job. This informs future pricing and margin targets.

Troubleshooting

Stock levels do not match physical counts

Conduct a manual count and update the system. Discrepancies usually arise from items deployed to customer sites without updating the location field, items damaged in the field without being recorded, or items moved between storage locations without logging the transfer.

Purchase order did not update inventory quantities

Make sure you clicked Receive on the purchase order and confirmed the received quantities. Simply changing the PO status manually does not trigger the inventory update. You must go through the receiving workflow.

Low-stock alerts are not appearing

Verify that reorder points are configured on your inventory items. Items without a reorder point will never trigger a low-stock alert. Open each item and set an appropriate threshold.