How to Import Products from Brand Catalogs and CSV Files in SpaSphere

Browse professional beauty brand catalogs, import products with one click, or bulk-import from CSV to stock your spa inventory.

10 min read

Building your product inventory from scratch is tedious -- entering name, SKU, price, cost, description, and image for every single item can take hours. SpaSphere solves this with two powerful import features: a built-in Brand Catalog browser that lets you import pre-loaded products from professional beauty brands with a single click, and a CSV import tool for migrating product data from spreadsheets or other systems. Both approaches get your inventory populated in minutes instead of hours, with accurate pricing and professional product images already attached.

Why This Matters for Your Spa

Time spent on manual data entry is time not spent on clients. If it takes three minutes to manually enter each product and you carry 100 SKUs, that is five hours of admin work just to set up your inventory. The brand catalog cuts this to under 15 minutes by providing pre-populated product data -- names, descriptions, SKUs, retail prices, wholesale prices, and product images -- direct from brand partners. The wholesale-to-retail margin is calculated automatically, so you can see at a glance that a $32 retail serum you buy for $19 wholesale gives you a 41% margin. For spas switching from another platform, the CSV import lets you export your existing product data and bring it into SpaSphere without re-entering a single field. Either way, you avoid the data entry errors that lead to incorrect pricing on your website and embarrassing conversations with clients about why their receipt does not match the shelf tag.

Key Capabilities

  • Brand catalog browser with pre-loaded professional beauty brand product data
  • One-click import from catalog to inventory with product images, pricing, and descriptions
  • Bulk selection by individual products or entire categories for large-scale imports
  • Size and category filters in the catalog browser (retail, pro, bulk sizes)
  • Margin preview showing wholesale cost, retail price, and calculated margin before you import
  • CSV bulk import for migrating existing product data from spreadsheets
  • Import progress tracking with a real-time progress bar during bulk operations

Browsing Brand Catalogs

1

Open the Brand Catalog browser

On the Inventory page, click the Browse Brand Catalogs button in the header. A full-screen modal opens showing all available brand catalogs.

Brand Catalog browser showing brand cards with logos, taglines, product counts, and partner tags
The brand catalog lists professional beauty brands with their logos, product counts, and any active partner incentives.
2

Select a brand

Click on a brand card to enter its product catalog. The catalog view shows the brand's header information including the total number of products available and the average margin across the catalog. Each brand card may also display partner tags and incentive badges for special pricing programs.

3

Browse and filter products

Once inside a brand catalog, you can:

  • Search by product name, ingredients, or keywords using the search bar
  • Filter by category using the sidebar on the left, which shows categories with product counts
  • Filter by size using the size tabs (All, Retail, Pro, Bulk) to find the right size tier

Products are displayed in a grid of cards showing the product image, category badge, name, description, retail price, margin percentage, and weight.

Brand catalog product grid showing product cards with images, prices, margin percentages, and category badges
Product cards show pricing, margin, and size at a glance so you can make informed import decisions.
4

Preview product details

Click any product card to open a detailed product modal. The detail view shows:

  • Full product image
  • Category and SKU
  • Retail price, wholesale price, and calculated margin
  • Product weight
  • Product benefit bullets
  • Usage directions
  • Full ingredient list (expandable)

This gives you everything you need to evaluate a product before adding it to your inventory.

Product detail modal showing product image, pricing breakdown, benefits, directions, and an Import to Inventory button
The product detail view shows pricing, margins, benefits, and ingredients before you commit to importing.
5

Import individual products or in bulk

You have three ways to import from the catalog:

  • Import a single product -- Click "Import to Inventory" from the product detail modal
  • Select multiple products -- Use the circular checkboxes on product cards to build a selection, then click "Import Selected" in the selection bar
  • Select entire categories -- Check the boxes next to category names in the sidebar to select all products in those categories at once
  • Import all products -- Click "Import All" in the catalog header to import every product from the brand

During import, a progress bar tracks the operation in real time, showing how many products have been processed out of the total.

6

Review import results

After the import completes, SpaSphere displays a summary notification showing how many products were imported, how many were skipped (because they already exist in your inventory), and how many failed. Imported products immediately appear in your inventory table with their catalog images, pricing, and details pre-filled.

Use category import for efficient restocking

If you carry an entire product line from a brand -- for example, all of their facial serums or their complete hair care range -- use the category checkbox in the sidebar to select the whole category at once. This is much faster than selecting products individually and ensures you do not accidentally miss an item. SpaSphere automatically skips products that already exist in your inventory, so there is no risk of creating duplicates even if you import a category that overlaps with products you have already added.

Importing from a CSV File

If you have product data in a spreadsheet -- either exported from another system or compiled manually -- SpaSphere's CSV import processes it in bulk.

1

Open the Import modal

On the Inventory page, click the Import button (the upload icon) in the header. The Import Products and Inventory modal opens.

Import Products and Inventory modal with a CSV file upload field and format instructions
The CSV import modal accepts a standard CSV file with columns for product and inventory data.
2

Prepare your CSV file

Your CSV file should include these columns:

  • name (required) -- Product name
  • sku -- Stock keeping unit
  • price -- Retail price
  • cost -- Wholesale/acquisition cost
  • quantity -- Units in stock
  • location_id -- Your location identifier
  • category -- Product category
  • brand -- Brand name
  • shop_visibility (optional) -- Set to "true" or "false" (defaults to false)
3

Upload and import

Click the file input to select your CSV file, then click Import. SpaSphere processes each row, creating product records and associated inventory entries.

4

Review the results

After processing completes, SpaSphere displays a results summary showing the number of products successfully imported and any errors. If errors occurred, each one is listed with a specific error message so you can correct the data and re-import the failed rows.

Clean your CSV before importing

The most common import failures are caused by missing required fields, incorrect data types (text in a numeric price column), or encoding issues from Excel exports. Open your CSV in a text editor before importing to verify that the headers match the expected column names exactly and that numeric fields like price and cost contain only numbers. Spending two minutes on data validation before uploading prevents a frustrating cycle of partial imports and error corrections.

Imported Product Defaults

When you import products from a brand catalog, SpaSphere sets the following defaults:

  • Active -- Set to true (the product is visible in your inventory)
  • Shop Visibility -- Set to true (the product is visible on your public website)
  • Type -- Set to "Product" (retail type)
  • Retail Price -- Pulled from the catalog's retail price field
  • Cost -- Pulled from the catalog's wholesale price field
  • Margin -- Automatically calculated from retail and wholesale prices

After import, you can edit any product to change these defaults -- for example, turning off Shop Visibility for items you want to sell in-person only, or adjusting the retail price for your local market.

Frequently Asked Questions

Ready to try this in your spa?

$1 for 30 days. No contracts. We migrate everything for you.