Build a Multi-SKU Essential Oil Order Sheet That Stays Clear

Decide what makes one order line unique

An oil name alone is not a complete ordering identity. The same material can be requested in different fills, bottles, label languages or set formats. Define the configuration fields that make a line distinct for your project, then give each complete configuration a stable SKU or line reference. Keep that reference unchanged while its description remains unchanged.

Start with the material specification reference and add fill, bottle, closure, label artwork and outer packing references as applicable. Separate a new configuration from a correction to an existing record. If your business has customer-facing product codes, keep a mapping to the purchasing reference so sales, production coordination and receiving can identify the same item without relying on a shortened name.

Put the quantity unit beside every quantity

Use explicit fields for ordered quantity and ordered unit. For example, '240 bottles' is different from '240 sets' even if each set contains the same bottle. When quoting bulk liquid, keep the liquid mass or volume unit as stated and do not treat a container's nominal capacity as the quantity ordered. Units should survive every export, email and printed copy of the sheet.

Record packing separately: bottles per inner pack, bottles per carton, cartons per pallet where agreed, and whether partial cartons are allowed for that line. Do not infer these from a photograph or from a previous order. If quantities must change to fit a confirmed packing arrangement, show the proposed revision and obtain agreement instead of silently altering the bottle count.

• Ordered quantity and ordered unit
• Fill per bottle or material quantity basis
• Units per case and case count
• Partial-case question and agreed treatment

Split similar products into visibly different rows

Consider a hypothetical draft with three lines. EO-LAV-10-EN requests 240 lavender bottles at the specified 10 mL fill with English label L03. EO-LAV-30-EN requests 120 bottles at a different fill using its own bottle and artwork references. EO-LAV-10-FR requests 120 bottles matching the first fill but with French label L07. These are three configurations even though the oil name is shared.

If the supplier confirms 24 bottles per carton for the first line, that line's 240 bottles correspond to ten cartons. This calculation is only valid for the stated, confirmed packing arrangement. Keep the bottle quantity visible alongside the carton result. The example does not establish an available fill, case size, language option or order minimum for PanPan Aroma.

Create a compact template with connected references

A workable sheet starts with project reference, version, date and status above the table. The table can contain line ID, material specification, fill, bottle, closure, label, carton, ordered quantity, unit and case packing. Add approval status and an open-question field. Use full references or links to the controlled files rather than long artwork descriptions that can become inconsistent.

Keep shared instructions outside the table only when they truly apply to every line. If a label route, destination or packaging condition differs, put the difference on the affected row. Avoid merged cells that make sorting or copying ambiguous. Any total should identify what it sums; a grand total of bottles plus sets plus kilograms has no useful purchasing meaning.

• Line ID | specification | fill | bottle and closure
• Label version | outer pack | quantity | unit
• Case configuration | approval status | open question
• Project version | change date | reviewer

Reconcile the sheet at quotation, release and receiving

Ask the supplier's quotation to use your line references, or keep a clear mapping to its own codes. Compare each line before approving the order: specification, packaging, quantity and unit should agree. A note such as 'assorted oils' is not enough when the split across the assortment affects the actual work. Resolve missing rows and duplicates before treating the total as accepted.

When a row changes, preserve the earlier version and record what changed and why. At shipment and receiving, reconcile the packing information to the accepted lines and investigate differences under the agreed process. PanPan Aroma can review a multi-SKU brief for sourcing and partner manufacturing; a precise sheet helps coordinate that review without implying that every proposed combination is currently available.