A supplier spreadsheet that lists 10 fragrances in three sizes looks like 30 entries. Add two concentration types and testers and the same 10 scents become close to 90 Shopify products. Most supplier files do not reflect that structure.
Fragrance sizes for upload teams decide more than which column goes into which field. They determine how many Shopify products exist and whether testers and concentrations share a page or get their own records. This article covers what to separate in the sheet you send, and how concentration and tester data change the product count before anyone logs in to Shopify.
Key takeaways
- Each combination of fragrance name and concentration type (EDT, EDP, Parfum) is usually a separate Shopify product, not a size option on one product page
- Sizes within a concentration become Shopify variants: a 30 mL, 50 mL, and 100 mL EDT is one product with three variants
- Tester bottles need their own Shopify product record, their own SKU, and their own images, not a variant slot on the retail listing
- Both milliliter and fluid ounce measurements belong in the handover sheet because product pages for fragrance typically display both
- A sheet with separate columns for name, concentration, size in mL, size in fl oz, SKU, price, and a tester flag removes the ambiguity before the upload starts
How fragrance sizes map to Shopify variants
Fragrance bottles come in standard retail sizes: 30 mL (1 fl oz), 50 mL (1.7 fl oz), 75 mL (2.5 fl oz), 100 mL (3.4 fl oz), and 150 mL (5.1 fl oz). Travel and discovery sizes run smaller, typically 5 mL, 7.5 mL, and 10 mL. Each size is a Shopify variant when the concentration stays the same across all of them.
For example, a single Eau de Toilette fragrance offered in three retail sizes becomes one Shopify product with three variants. The option name is "Size" and the values are "30 mL / 1 fl oz", "50 mL / 1.7 fl oz", and "100 mL / 3.4 fl oz". Each variant gets its own SKU, barcode, and price.
| Variant title | Metric | Imperial | SKU example |
|---|---|---|---|
| 30 mL / 1 fl oz | 30 mL | 1 fl oz | RIV-EDT-030 |
| 50 mL / 1.7 fl oz | 50 mL | 1.7 fl oz | RIV-EDT-050 |
| 100 mL / 3.4 fl oz | 100 mL | 3.4 fl oz | RIV-EDT-100 |
Shopify product variants let you combine up to three option types per product, with a maximum of 100 variants per product (as of November 2026). For a fragrance with a large size range, that is well within the limit. The practical constraint is that all variants on one product share the same description and product images, so the variants need to be genuinely the same fragrance.
Concentration types: when to split into separate products
Eau de Toilette (EDT) and Eau de Parfum (EDP) are the two concentrations a Shopify fragrance catalog most often carries. Some ranges also include Parfum or Extrait de Parfum, which sits at the top of the concentration scale, and lighter formulations like Eau Fraiche or Eau de Cologne.
The concentration matters for the product structure because it affects price, scent intensity, and longevity. An EDT and an EDP of the same fragrance name are often meaningfully different to the buyer. Upload teams need a clear decision in the brief on whether to nest them or split them.
Nest them as a variant option when: the price difference is small (under 20%), the brand presents them together, and both share the same set of bottle sizes. The variant option might be "Type" with values "EDT" and "EDP", combined with a "Size" option. Shopify's product options allow up to three option types per product, so size and concentration can combine without hitting a limit.
Create separate Shopify products when: the price gap is significant, the descriptions differ, or the scent character is different enough that a shopper searching specifically for one type would expect their own result. Separate products also make collection and filter setup cleaner, since a "Eau de Parfum" collection filter works against individual products, not variant values.
If your brief does not answer this question, an upload team will make a judgment call, and the choice is hard to reverse once the catalog is live. Spelling it out in the sheet takes two minutes.
Tester bottles: separate product, not a variant
Tester bottles carry the same fragrance as the retail version, usually in the same size, but with plain packaging, no outer box, or a box stamped "TESTER." They sell at a lower price, typically 20 to 40 percent below the retail bottle.
The structure question is whether to list a tester as a variant of the retail product or as a separate product.
Listing it as a variant means the product page shows "50 mL" at $95 and "50 mL Tester" at $62 side by side, under the same product title, with the same images. Customers comparing prices across tabs see both values and may expect the retail bottle at the tester price. For some stores this is acceptable; for most it creates confusion.
The cleaner structure is a separate Shopify product for each tester. The title follows the retail product title but adds "Tester": "Riviera EDT 50 mL Tester." The product gets its own SKU (usually matching the retail SKU with a suffix like "-TST"), its own images showing the plain or tester-stamped packaging, and its own price. Many stores place tester products in a separate collection or set them to not appear in search, which is not possible at the variant level without hiding the whole product.
What your team needs in the handover sheet for testers:
- A tester flag column (yes/no, or "TESTER" in the product name, consistently)
- The tester-specific SKU and barcode
- The tester price
- A note on whether tester images are included, and whether packaging images differ from retail
What fragrance sizes for upload teams look like in a handover sheet
The column structure below works for most fragrance catalogs. Each row in the sheet becomes one Shopify product or variant, depending on the decisions above.
| Column | What it contains | Example value |
|---|---|---|
| Fragrance name | Base scent name, no size or concentration in this column | Riviera |
| Concentration | EDT, EDP, Parfum, EDC, Eau Fraiche | EDP |
| Size (mL) | Metric figure only | 50 |
| Size (fl oz) | Imperial equivalent | 1.7 |
| Tester | Yes or No | No |
| SKU | Unique per size, concentration, and tester status | RIV-EDP-050 |
| Barcode (EAN/UPC) | As supplied; varies by size | 5012345678901 |
| Price | Retail price in the store's currency | US$110.00 |
| Shopify structure | Variant (V) or separate product (P) | V |
| Images included | File names or yes/no | RIV-EDP-050-01.jpg, RIV-EDP-050-02.jpg |
Separating the fragrance name from the concentration and size in the sheet means your team never has to parse a string like "Riviera 50ml EDP" to extract three separate data points. That parsing step is where SKUs and sizes get mixed up during bulk uploads.
If you work with a Shopify product data entry service for your fragrance catalog, sharing a sheet in this column format reduces back-and-forth considerably. For a range covering multiple concentrations and sizes, the product count grows quickly, and a clear structure at the start avoids corrections later.
Linking your fragrance data to the right Shopify fields
Once the handover sheet is in this structure, the mapping to Shopify is straightforward. The concentration and size columns become variant option values. The SKU and barcode columns map to the Shopify variant SKU and barcode fields. The price column maps to the variant price.
Product weight and dimensions go into the shipping fields per variant: bottle weight varies by size, and your team needs either actual weights or reasonable estimates to fill these accurately (Shopify uses weight for calculated shipping rates).
For fragrance, the product description covers the scent profile, the concentration, and the notes (top, heart, base). That description is shared across all size variants of the same product, which is why concentration differences that significantly affect the scent are better served by separate products.
The beauty cosmetics product upload service we provide handles this structure regularly. The handover sheet format above works across brands and concentration ranges.
For articles covering the same data preparation approach in other beauty categories, see haircare refill and salon sizes for upload teams and shade and finish names for makeup upload teams. For skincare-specific ingredient data handling, skincare ingredient data for upload teams covers the per-ingredient column structure.
Frequently asked questions
Can a fragrance tester be listed as a variant on the retail product?
Yes, it can, but most stores avoid it. A "50 mL Tester" variant sitting alongside a "50 mL" retail variant on the same product page shows both prices together. Customers may expect the retail bottle at the tester price or become confused about what they are buying. A separate Shopify product for each tester resolves this and lets you manage the tester's visibility, collection placement, and images independently from the retail listing. Shopify's variant structure supports either approach, but the clean separation is easier to manage at scale.
How many Shopify products does a fragrance with two concentrations and three sizes create?
It depends on your structure decision. If you treat each concentration as a separate product with size as a variant, 2 concentrations × 3 sizes = 6 variants across 2 products. If you treat both concentration and size as variant options on one product, you get 6 variants on 1 product. Add a tester for each concentration in the most common size (50 mL), and that adds 2 more products, for a total of 4 products. A range of 10 fragrances in this structure could easily be 40 or more Shopify products.
What happens if the supplier file uses product names like 'Riviera 50mL EDP'?
Your upload team will need to parse the name into separate columns before the upload. This takes time and introduces the risk of misreading a size or concentration abbreviation. The consistent pattern for fragrance is to send separate columns for name, concentration, and size from the start. If you receive data from a supplier in a combined name column, restructuring the sheet before you send it to your team is faster than correcting errors after products are live.
Do I need imperial measurements if the store sells globally?
For fragrance, yes. Milliliter figures are standard in most markets, but fl oz is expected by US shoppers in particular. Many fragrance brands print both on the bottle (for example "50 mL / 1.7 fl oz"), and product pages that show only mL receive questions from US buyers. Including both columns in your handover sheet means your team can fill both display fields in one pass rather than converting during the upload. The conversion formula (mL × 0.0338 = fl oz to two decimal places) is quick to apply but adds time per SKU across a large range.
What images should I send for fragrance products?
For retail bottles: a main product shot on a neutral background, a close-up of the bottle showing the label, and an angle or lifestyle shot where the brand has one. For testers: a front-on shot of the tester bottle or box showing the "TESTER" mark, so the customer can see clearly what they are buying. If your tester bottles have no outer packaging, one clean product shot is usually enough. Send image file names that match the SKU so your team can assign them without guessing. For more on how image preparation works as part of an upload job, see Shopify's guidance on managing product media.
