Review criteria
- +Special orders by customer
- +Deposit and balance
- +Vendor ETA and status
- +Ready-for-pickup flags
Lighting Special-Order Log in Lighting Store
A suggested spreadsheet layout for lighting store work, tracking orders, customer, fixture, deposit, eta.
Last updated: August 2026
We haven’t built a ready-made workbook for this one yet. The templates below do the same job, with formulas and sample data, and you can download them today. The suggested columns are further down if you’d rather build your own.
Working templates you can use today
Real Excel workbooks with formulas, dropdowns and sample data. Try each one in your browser before downloading.
Lighting Store
Lighting Project Quote Builder
Open template →
Tailor & Alterations Shop
Alteration Order Tracker
Open template →
Chocolatier
Chocolate Batch Tracker
Open template →
Comic Book Store
Comic Pull-List Manager
Open template →
Auction House
Consignor Settlement Tracker
Open template →
Ski & Snowboard Tune Shop
Ski Tune Queue Tracker
Open template →
Build your own
Suggested columns for “Lighting Special-Order Log”
Format: No ready-made file yet (column guide)Columns: 5
Columns to start with
- Orders
- Customer
- Fixture
- Deposit
- ETA
- Copy the column list and paste it into cell A1 of a new Google Sheet or Excel workbook.
- Split it into columns: Google Sheets Data → Split text to columns; Excel Data → Text to Columns (comma).
- Or skip the setup and start from one of the working templates on this page.
Review evidence
What to verify before choosing Lighting Special-Order Log
Use the review criteria below to decide whether this template fits your workflow.
Often worth considering when
- +Stores managing special orders
- +Anyone tracking deposits and ETAs
Pause before choosing when
- -Automated customer texts
- -Live vendor catalog sync
About Lighting Store
Why people consider this option
- +Track fixtures and pricing without paid retail software
- +Keep every special order and quote in a file you own
- +Know your margin on each fixture and bulb
What to review before acting
- -No POS or e-commerce without a tool
- -Bigger showrooms need real retail software
Trust FAQ
Questions people ask before copying a template
Does the Lighting Special-Order Log work in both Google Sheets and Excel?
Yes. It is built with standard functions and no macros, so it opens and works the same in Google Sheets or Microsoft Excel — on desktop or your phone.
Is the Lighting Special-Order Log really free?
The core template is free to copy and use. There is no paid tier — copy the suggested columns into a new sheet, or start from one of the working templates on this page.
What does the Lighting Special-Order Log track?
It tracks orders, customer, fixture, deposit, eta. The suggested columns are listed in order; add totals or highlights with basic formulas like SUM once your data is in.