Lighting Assortment Gap Analysis: Finding the Missing Price, Style, and Application Slots

Start a lighting assortment gap analysis by mapping the current range for a defined customer, country and channel on a comparable price basis. Test the apparent missing positions against sales, availability and identifiable enquiries before requesting new products. The result should tell a product manager whether to restore supply, adjust a variant, investigate a new design or gather better evidence. The worksheet below supports that decision without requiring a fabricated market-size estimate.

Choose the Range Action the Evidence Can Support

• Set the customer, application and price comparison before counting designs.
• Map distinct offered variants and their availability alongside design families.
• Use sales, costs and enquiries according to their actual definitions.
• Turn a supported missing position into a focused supplier brief with a next evidence milestone.

Define the Customer, Channel and Comparable Price Basis

Define the target customer, country, channel and analysis period before grouping products. An assortment slot is a customer, application, design and price position within that channel. Use a comparable price basis for every item placed in it. A showroom serving residential designers and a distributor supplying independent retailers may require separate views even when they share products.

Choose the transaction level being compared. To assess shopper-facing coverage, use selling prices with a stated currency, effective date, tax treatment and included scope. Keep regular and promotional prices distinguishable. To assess buying feasibility, maintain the supplier quotation and estimated landed-cost build-up separately. Mixing a factory quotation with a showroom selling price creates a gap that comes from the comparison itself.

A price record needs an explicit currency. Google Merchant API represents price using an amount and a currency code. For this worksheet, retain that pairing and add the commercial context needed for your own comparison. The API representation supplies no market price bands or margin target. Google Merchant API price representation.

Prepare the application questions and product information behind this scope using relevant lighting design and procurement resources. Keep the actual range decision tied to the distributor’s records and customer requirements.

Define price-band boundaries from the chosen commercial position and label them in the worksheet. Terms such as lower, middle and upper band need an internal definition before colleagues classify products. Record boundary treatment so an item on an edge enters the same band each time. Where countries use different price structures or channels carry different inclusions, retain separate views and document any later comparison.

Map Distinct Variants Across Application and Design Language

Map current SKU variants across application, design language, price band, scale, material and channel. SKU means stock keeping unit, the internal identity used to track an offered variant. Include availability and lifecycle status beside it. A family offered in several finishes can add choice within a position while leaving a different application or scale requirement uncovered.

Use the current assortment export as the starting population. Retain active items, identify temporarily unavailable variants, and label planned, discontinued or special-order products separately. Preserve the connection between each family and its offered variants. A future design can belong in the development pipeline while the current coverage view still shows the customer’s present options.

Stable trade-item references help keep these records joinable. GS1 explains that GTIN identifies trade items that can be priced, ordered or invoiced through a supply chain. Preserve existing GTIN and SKU relationships where the business uses them, with the design family and analytical slot in their own fields. GS1 explanation of trade-item identification.

Give design language a short, consistent description that colleagues can apply, such as restrained geometric, expressive organic or traditional decorative. Record scale through the relevant dimensions and installation context. Preserve material identity alongside the finish. The category manager should resolve ambiguous labels before comparing coverage, especially when sales teams use different names for the same visual family.

Keep the main view readable by using application and price band as axes, with style, scale and material as filters or labels. Investigate a specific customer requirement through those filters instead of creating every possible combination as a presumed development target. Note whether the customer can see, specify and obtain the fitting through the relevant channel.

Installed interiors can help colleagues explain an application or design relationship. Identify the feature being discussed and then connect it to the actual offered item. For contextual references, review Kinglong’s published lighting projects.

Copy the Assortment Gap Worksheet

Use this proposed assortment gap worksheet to record a defined slot, current coverage, comparable price basis, evidence and diagnosis. Assign a responsible owner and a next validation action. Create a record for a specific candidate gap, with linked SKU and opportunity details where needed, so the team can see what would change the decision.

Replace the brackets with your own inputs. Keep the worksheet issue and the source-export dates in its header. Blank, unknown and genuinely absent coverage should remain distinguishable. If a field lacks evidence, write the question and the person responsible for answering it.

Keep the evidence references sufficiently specific to revisit. A dated stock report and a named opportunity record let another manager check the interpretation. A comment such as “customers ask for this” needs a traceable basis before it can support product investment. Record any missing field as part of the diagnosis.

Use candidate families to test whether an existing design could occupy the proposed position. Record the required deviations and the questions for supplier confirmation. Kinglong’s decorative-lighting collections provide starting references for that comparison.

Test Each Empty Slot Against Sales, Availability and Enquiries

Treat an empty assortment cell as a hypothesis. Join sales and availability context with deduplicated enquiries, then distinguish an existing suitable fitting that is unavailable from an uncovered requirement or an evidence gap. That classification determines whether the next task belongs to purchasing, product development or further customer research.

First check what the sales record actually measures. Keep the report period, discounts, returns and cost completeness visible. Also ask whether the item was available and presented to the relevant customers during that period. Weak sales with little exposure or interrupted supply leave a different question from weak sales despite sustained availability and relevant presentation.

Revenue rankings have a defined purpose. Shopify’s ABC guidance says it uses retail prices without applying discounts, and item cost does not enter the grade. Use a grade with that definition to understand revenue concentration, then assess the commercial contribution using the appropriate complete cost and sales records. Shopify ABC analysis definitions.

Check which variants an inventory report includes. Shopify defines sell-through as quantity sold divided by sold quantity plus remaining inventory, and includes variants only if sold before or during the selected period. Review the exact period and join the report back to the full assortment export so a missing report row remains distinguishable from an absent product. Shopify inventory-report scope.

Enquiries need their own interpretation. Google Analytics describes generate_lead as measuring a generated lead, for example through a form. Use the underlying business records to establish distinct opportunities and outcomes before calling those events buying demand. Repeated messages about the same room requirement should remain connected to the same opportunity. Google Analytics lead-event definition.

For each unresolved request, capture the requested application, scale, style and price expectation, the proposed alternative and the reason it was accepted or rejected. A candidate gap becomes more actionable when independent opportunities share a specific unmet requirement. A disagreement about price still requires comparable price evidence before it becomes a feasible development target.

Work Through a Coverage Gap and an Availability Gap

In this hypothetical assortment trial, slot A has a suitable existing SKU that is unavailable. Slot B has no current fit and distinct enquiries, with price validation still open. Slot C has neither a current fit nor demand evidence and is deferred. These illustrative inputs lead to an availability action, focused validation and deferral respectively.

Follow slot B through the worksheet. Link the opportunity references, record the requested scale and application, and identify why current candidates fail. Retain the intended design language while asking the supplier which changes are feasible. The next decision needs an aligned proposal and a comparable commercial basis, followed by customer feedback on that specific proposal.

If the customer’s acceptable price and the proposed scope cannot be reconciled, revise the brief or stop that development route. If the only available evidence is repeated discussion of the same opportunity, retain the limited evidence status and investigate further. Neither branch requires filling the blank cell merely to complete the matrix.

Turn a Supported Gap Into a Supplier Development Brief

Preserve the required application and design function when asking for alternatives. Kinglong’s decorative-lighting value engineering guide discusses retaining agreed functions while reviewing construction options. Apply that question to the defined range position.

A development brief should identify the uncovered customer and application, retained design features, comparable price target and relevant existing products. List technical and commercial unknowns, then name the evidence needed for the next decision. Keep the shopper-facing price target separate from the supplier’s requested quotation basis and the distributor’s internal commercial assessment.

Choose the narrowest justified route. A suitable existing product may need clearer positioning or restored availability. An existing family may need a different scale or configuration, subject to supplier confirmation. A genuinely different requirement may justify a new design discussion once its demand and commercial assumptions have been tested.

State which attributes are essential and which can change. Include dimensional references, intended application, material expectations, channel presentation needs and the applicable technical-market questions for the responsible reviewers. Identify what a proposed sample or drawing must demonstrate and who will review it. Agree actual quantities, sample scope, charges and timing through the supplier discussion.

Close the brief with a decision milestone. A proposal might proceed to sample review when it meets the documented requirement and has a comparable commercial scope, while unresolved market or cost assumptions remain visible. Preserve the rejected alternatives and reasons so another supplier response can be assessed against the same need.

Bring Kinglong a Defined Range Slot to Discuss

Bring the current range export and completed gap record, including target country, customer and channel, required application and style, scale/material needs and the comparable price basis. Add the relevant sales and enquiry evidence with its limitations. Identify the open technical and commercial questions that require a supplier response.

Ask for a response against the identified slot and distinguish a current collection option from a proposed variation or new design. Keep each answer linked to the relevant gap record. This gives the category manager a basis for comparing what is offered and deciding which remaining input belongs with the supplier or the distributor’s own customer research.

Kinglong publicly describes custom decorative lighting and OEM/ODM collaboration. Ask which design and sample deliverables apply to the range requirement, then agree scope, quantities, charges, timing and responsibilities. Use the resulting clarified deliverables and outstanding supplier questions to update the brief. You can discuss the range brief with Kinglong.

Frequently Asked Questions

Can a small distributor run this analysis with limited sales history?

Yes, if it labels the evidence as limited and uses the result to choose a focused validation step. Start with the actual range, availability records and identifiable customer opportunities. State which channels and periods the data cover. A narrow proposal shown to the relevant buyers can help answer a specific open question while broader demand remains unproven.

Should a low-selling image product be removed from the range?

Judge it against its documented role, including showroom presentation or coordinated-family coverage, before deciding to remove it. Record the intended contribution and the evidence used to assess it. If that role remains important, choose how to review it alongside direct sales, stock commitment and associated enquiries so the decision has an explicit basis.

Does a slow-selling finish prove the entire design family is weak?

Assess the finish variant alongside its availability, display exposure, channel and the performance of the other variants. Check whether customers could actually see and obtain that finish, and retain recorded objections. If the issue concerns only that variant, investigate a focused finish or presentation action before changing the whole family’s place in the range.

What if landed costs are still unknown?

Until landed costs are confirmed, keep price-band and margin assumptions provisional and list the missing cost inclusions before accepting the commercial case. Obtain comparable quotation scope, packaging, logistics and relevant channel-cost inputs from the responsible parties. Preserve the currency and date of each input. The team can continue validating the product requirement while the final margin case remains open.