How to Build a Skin Booster Product File: Specifications, Lots, Expiry Dates, and Stock Status

0 0 9 minutes read

A skin booster inventory can become difficult to control long before the product list looks large. One commercial name may have several presentations. Different batches may arrive with different expiry dates. Some units may be available for sale, while others are reserved, returned, damaged, or awaiting inspection.

A single spreadsheet row with a product name and total quantity cannot show these differences. It may tell the purchasing team that 30 boxes are in stock, but it does not show which batch should be dispatched first or whether some boxes are being held.

A more reliable system separates stable product information from changing batch and inventory information. This creates a product file that buyers, warehouse teams, and quality staff can all use.

A Product File Is Not a Regulatory Dossier

The term “product file” in this guide means an internal procurement and inventory record. It does not replace a regulatory submission, technical file, medical device file, or manufacturer’s quality documentation.

The file should help a business answer five practical questions:

What exactly is the product?
Which presentation was purchased?
Which batches are currently held?
When does each batch expire?
What is the current status and location of every unit?

This distinction is especially important for skin boosters. Products grouped under that commercial term may differ in composition, presentation, labelled purpose, route of use, and regulatory status. Their legal classification can also vary between markets. A category name should therefore never replace the exact information printed on the individual product label.

Start With a Product Master Record

The product master record contains information that normally remains stable between orders. Each distinct presentation should receive its own internal SKU.

For example, a prefilled syringe and a box of multiple vials should not share one SKU simply because they have the same brand name. Different concentrations, fill volumes, pack counts, or formulations should also be recorded separately.

A useful master record should contain:

Field	What to Record
Internal SKU	A unique code created by the buyer
Full commercial name	Exactly as printed on the packaging
Brand	Brand shown on the product
Manufacturer	Legal manufacturer stated on the label or documents
Product type	The description supported by the product documentation
Composition or active ingredients	Labelled ingredients and stated amounts
Presentation	Prefilled syringe, vial, ampoule, powder-and-solution set, or another form
Fill volume or quantity	Amount per syringe, vial, or container
Pack configuration	Units per box and boxes per case
Labelled storage conditions	Copied exactly from the label or supplied instructions
Intended market	Country or region where the stock will be supplied
Labelled use	The manufacturer’s stated intended use
GTIN or barcode	Where present
Required documents	Documents expected before the product is released into stock
Record owner	Person or department responsible for updates

Avoid filling missing fields with assumptions taken from a similar product. If the packaging does not provide enough information, mark the field as pending and request the relevant document from the supplier.

Create a Separate Record for Every Batch

Stable product data and batch data should not be stored in the same editable row. If a new delivery replaces the previous lot number and expiry date, the history of the earlier stock may disappear.

Instead, connect the master SKU to a separate batch record. Every received batch should have its own entry, even if the product and packaging are unchanged.

The batch record should include:

Internal SKU
Supplier name
Purchase order number
Invoice or delivery reference
Manufacturer’s batch or lot number
Manufacturing date, if stated
Expiry date
Date received
Quantity received
Quantity released
Quantity reserved
Quantity dispatched
Quantity returned or rejected
Current balance
Warehouse location
Storage condition check
Document review status
Current inventory status
Date of the latest update
Name of the person making the update

The batch number and expiry date should be copied directly from the physical unit or its traceable outer packaging. Retyping these details from an informal sales message creates avoidable errors.

The World Health Organization’s good storage and distribution guidance recommends maintaining comprehensive records for receipt, storage, issue, and distribution. It identifies product description, quantity, supplier or customer details, batch number, and expiry date among the information that may be needed. The guidance also states that records should be accurate, traceable, and readily retrievable.

Standardize Specifications Before Comparing Products

Names alone are not enough for comparing skin booster inventory. Two listings may sound similar while differing in concentration, volume, number of units, physical form, or preparation requirements.

When reviewing skin booster products, buyers should compare the complete presentation rather than relying on the category name or front-label description. The internal record should preserve the exact volume, concentration, pack count, dosage form, labelled use, and storage instructions associated with each item.

Use fixed units wherever possible. If purchasing records use boxes while warehouse staff count syringes or vials, define a conversion rule in the master record.

For example:

1 case = 20 boxes
1 box = 2 syringes
Base inventory unit = 1 syringe

The system can then calculate case, box, and unit quantities without mixing them. This is particularly useful when products are reserved or dispatched in quantities smaller than a full case.

Use Controlled Inventory Statuses

Free-text notes such as “waiting,” “problem stock,” or “not ready” are difficult to filter. A fixed list of inventory statuses makes the record easier to review.

A practical status list may include:

Pending receipt: Ordered but not physically received.
Under inspection: Delivered but not yet checked and released.
Available: Approved for normal allocation or dispatch.
Reserved: Assigned to a confirmed order but still in storage.
Quarantined: Separated while a discrepancy or quality concern is reviewed.
Damaged: Packaging or product damage has been identified.
Returned: Sent back by a customer or returned to the supplier.
Recalled: Isolated in response to a formal recall notice.
Expired: Past the labelled expiry date.
Disposed: Removed from inventory under the applicable disposal procedure.

Only one primary status should apply to a stock quantity at a time. If part of a batch is quarantined, split that quantity from the available balance rather than marking the entire batch with two conflicting statuses.

Make Receiving the Main Data-Control Point

The best time to create or update a batch record is when the shipment arrives. This allows the team to compare the purchase order, delivered goods, labels, and supporting documents before the stock becomes available.

A receiving check should cover:

Product name and presentation.
Number of cartons, boxes, and individual units.
Batch number and expiry date.
Seal and packaging condition.
Label completeness and legibility.
Required storage conditions.
Evidence of transport conditions when applicable.
Presence of the expected batch documents.
Differences between ordered and received goods.
The market for which the product is labelled.

Photographs of the label and delivered carton can support the record, but they should not replace searchable batch fields. A database cannot reliably issue an expiry alert if the date exists only in a photograph.

Any mismatch should be documented before the products enter available stock. Suspect, damaged, incorrectly labelled, or incomplete deliveries should remain separated while the responsible person reviews them.

Manage Expiry by Batch, Not by Product

A product-level expiry field is unreliable because one SKU may have several active batches. Each lot needs its own expiry date and remaining quantity.

Inventory should normally be allocated by the first-expiry, first-out principle, often called FEFO. This gives priority to identical stock with the earliest expiry date. FEFO is different from first-in, first-out because the batch received first does not always expire first.

Expiry alerts should reflect the company’s order volume, transport time, customer requirements, and internal policy. A distributor shipping internationally may need an earlier alert than a clinic purchasing for local use.

Useful alerts include:

Stock approaching the company’s minimum acceptable remaining shelf life.
Reserved stock that may expire before planned dispatch.
Slow-moving batches with newer stock arriving behind them.
Items that have passed their labelled expiry date.
Products whose expiry information has not been verified.

The system should not automatically change a manufacturer’s expiry date. Any formally approved extension would need reliable, product-specific and batch-specific support from the responsible authority or manufacturer, where legally applicable.

Connect Documents to the Correct Product and Batch

A document folder is only useful if each file can be matched to the relevant product, presentation, and lot. Generic file names such as certificate.pdf or skinbooster-new.pdf make later verification difficult.

A consistent name may follow this format:

SKU_DocumentType_BatchNumber_DocumentDate

The record can then link the batch to documents such as:

Commercial invoice
Packing list
Certificate of analysis, where applicable
Manufacturer’s instructions
Product label copy
Transport or temperature record, where required
Receiving inspection record
Supplier correspondence about a discrepancy
Return, complaint, or recall documentation

A certificate for one batch should not automatically be assigned to another. Likewise, a marketing brochure should not be treated as proof of a batch specification or regulatory status.

A catalogue can support initial product research, while a supplier page such as mjsbeautys provides a consistent point of contact for requesting commercial or product documents. Neither source should replace the label, instructions, or batch-specific records received with the goods.

Keep Market and Regulatory Information Separate

A product’s availability in one country does not prove that it can be legally marketed or used in another. The product file should therefore include a market-specific compliance section.

This may record:

Intended destination market
Product classification in that market
Registration or listing reference, if applicable and independently verified
Label language
Importer or responsible economic operator
Purchasing restrictions
Professional-use restrictions
Verification date
Source of the regulatory information

These fields should be reviewed by someone familiar with the destination market. The inventory database can store the decision, but it cannot make the legal assessment.

Preserve the Movement History

A current balance is not enough for traceability. The system should also retain every stock movement.

Each transaction should identify:

Date and time
Product SKU
Batch number
Quantity added or removed
Previous status
New status
Source or destination
Related order or document
Person responsible

This movement log helps reconcile physical stock with the recorded balance. It can also show which customers received a particular batch if a complaint, return, or recall must be investigated.

Edits should not erase the earlier value. If an expiry date or lot number was entered incorrectly, record the correction, who made it, when it was made, and why.

Spreadsheet or Inventory System?

A controlled spreadsheet may be enough for a small catalogue with limited order volume. It should still use protected fields, fixed status choices, regular backups, and clear editing responsibility.

A dedicated inventory or enterprise resource planning system becomes more useful when the business manages multiple warehouses, frequent batch movements, reservations, returns, or market-specific documentation.

The software matters less than the record design. A complex system with inconsistent product names and missing lot numbers is less dependable than a well-controlled spreadsheet with clear fields and responsible owners.

Frequently Asked Questions

Should every skin booster presentation have a separate SKU?

Yes, when the concentration, volume, pack count, physical form, or other purchasing specification is different. Separate SKUs reduce picking errors and make stock comparison more accurate.

Can several batches be combined into one inventory balance?

They can be shown as a total for planning, but the underlying records should remain separate. Batch identity, expiry date, location, and status must still be retrievable.

What should happen when the batch number or expiry date cannot be verified?

The affected stock should not be treated as normally available. Record the discrepancy, separate the units, and request confirmation from the supplier or manufacturer through the company’s approved review process.

Is a certificate of analysis required for every product?

Document requirements depend on the product, its classification, the destination market, and the company’s purchasing procedure. Where a batch-specific certificate is required, confirm that its product name and batch number match the delivered goods.

How should returned products be recorded?

Returned stock should have its own status and movement history. Do not place it back into available inventory until its identity, packaging, storage history, and suitability have been reviewed under an authorized procedure.

How often should inventory records be checked?

Updates should follow every receipt, allocation, dispatch, return, quarantine decision, and disposal event. Physical stock should also be reconciled at intervals defined by the company’s risk level and internal procedure.

Turn the File Into a Working Control Tool

A practical first step is to audit a small group of recently received products. Check whether the system can identify the exact presentation, current batch, expiry date, available quantity, warehouse location, and supporting documents without opening several unrelated files.

Any question that cannot be answered quickly should become a required field or a controlled step in the receiving workflow. The result is not simply a cleaner spreadsheet. It is a usable record that supports purchasing, stock rotation, order allocation, and batch traceability.

Plain-Text References

World Health Organization. WHO Technical Report Series No. 1025, Annex 7: Good Storage and Distribution Practices for Medical Products. 2020.
U.S. Food and Drug Administration. Quality System Regulation Labeling Requirements.
U.S. Food and Drug Administration. Shelf Life of Medical Devices.