Inventory by store type

Inventory management for Shopify tanning product brands

Tanning brands sell self tanner, bronzer, and sun care in dozens of shades and formulas. Stockouts during spring and summer cost you sales you cannot get back once the season passes.

The inventory problems tanning product brands run into

  • Shade and formula sprawl. a single self tanner line can have light, medium, dark, and ultra dark versions, plus mousse, lotion, and drops, each a separate SKU to track and reorder.
  • Short shelf life on active formulas. DHA based tanners and SPF products degrade over time, so overstocking ahead of a slow season can leave you with expired stock you have to discount or toss.
  • Sharp seasonal demand swings. sales can jump heavily from spring into summer and drop off hard in winter, so the same reorder quantity that works in June will sit on a shelf in December.
  • SPF and sunscreen regulatory batches. some suppliers produce sunscreen in limited runs tied to compliance testing, which can mean longer waits if you order outside their production schedule.
  • Bundle and gift set timing. holiday gift sets and value packs need components ordered and assembled weeks ahead, which is easy to miss if you are only watching single SKU sales.

Seasonality and demand

Tanning demand usually builds from early spring, peaks around summer, and has a smaller secondary bump before winter holidays for gift sets and bronzing products. Many brands also see a short pre event spike around prom and wedding season. Plan your spring order earlier than feels necessary, because production and shipping time eats into the lead time you have before the first warm weekend. Winter is the time to run down stock of self tanners with shorter expiry windows and lean into SPF adjacent or bronzer products that sell year round in some climates.

Suppliers, lead times and minimums

Tanning brands typically work with contract manufacturers for formulated products like self tanner, bronzer, and SPF, and separate suppliers for application tools like mitts, gloves, and mirrors. Formulated product suppliers often have minimum order quantities tied to batch size, since mixing a smaller batch is not cost effective for them. Lead times vary: domestic contract manufacturers often take a few weeks once a formula is approved, while overseas suppliers for tools and accessories often take several weeks longer, especially around their own peak shipping periods. Case packs for lotions and mousses are common, so you often cannot order single units even if your sales are slow.

Worked example

Say your medium shade self tanning mousse sells 6 units a day in peak season. Your contract manufacturer has a lead time of 20 days, and you keep 5 safety days to cover any production delay. Reorder point = 6 x (20 + 5) = 150 units, so you place an order when stock hits 150. If you want 35 days of cover and you currently have 80 units on hand with 0 on order, order quantity = 6 x (20 + 35) - (80 + 0) = 330 - 80 = 250 units, which you would round up to the nearest case pack your manufacturer ships in.

Try it with your own numbers in the reorder point calculator, or size your buffer with the safety stock calculator.

A simple system to start this week

  1. List every shade, formula, and size as its own variant and confirm each supplier's case pack size and minimum order quantity.
  2. Set a lead time and safety day buffer for each supplier type, since contract manufacturers and tool suppliers rarely match.
  3. Mark expiry sensitive SKUs like DHA tanners and SPF products so you can watch for slow movers before they age out.
  4. Build your spring order plan in winter, working backward from your supplier's lead time so stock lands before demand picks up.
  5. Review your weekly reorder email and compare suggested quantities against any known short shelf life stock before approving.
  6. Record expiry dates in a separate spreadsheet or your manufacturer's batch records, since this is not something to track in Shopify alone.

How SteadyShelf fits tanning product brands

SteadyShelf tracks sales per shade and formula variant, factors in your seasonal pattern, and tells you when to order from each supplier based on their lead time. It rounds suggested quantities to your supplier's case packs and minimums, and drafts the purchase order for you to approve and send. It does not track expiry or lot numbers, so you still need to watch shelf life on DHA and SPF products yourself and use the sales data to catch slow movers before they expire.

$29/month flat, unlimited products and suppliers, 30-day free trial.

SteadyShelf is launching on the Shopify App Store. Join early access to get the install link first.

More: inventory management by store type · inventory glossary · Stocky alternatives

FAQ

Can SteadyShelf tell me when my self tanner is about to expire?

No. SteadyShelf does not track lot numbers or expiry dates. It can show you which variants are selling slowly, which helps you spot stock that might age out, but you need to track actual expiry dates separately, usually from your manufacturer's batch documentation.

I sell gift sets that bundle a tanner, mitt, and exfoliator. Does SteadyShelf handle that?

Not directly. SteadyShelf does not do bundle or BOM tracking, so it will not automatically tell you how many mitts to buy based on gift set sales. You should forecast and order each component SKU separately, and build in extra lead time to assemble sets before your sales peak.

I stock the same products in my Shopify store and a local salon. Can SteadyShelf manage both locations?

No. SteadyShelf does not handle multi-location transfers or multichannel sync. It forecasts and reorders based on your Shopify store's sales and inventory. If you supply a salon separately, you will need to manage that stock and any transfers between locations outside the app.

Let SteadyShelf do this math for every SKU

Order-by dates per supplier, seasonal forecasts and draft POs for your Shopify store. $29/month after a 30-day free trial.

Get early access