How to upload diamond inventory from CSV

An inventory-based ring builder lets shoppers choose an actual stock stone. Ring Facet supports merchant-uploaded lists; direct supplier API connections remain a separate, developing capability.

Prepare your file

Export your supplier or stock spreadsheet as CSV or TSV. Excel workbook files must first be saved as CSV. Include stock number, shape, carat weight and total cost, or cost per carat so total cost can be calculated. Keep identifiers consistent between uploads. A new upload replaces the list: stones missing from the new file are treated as sold and removed.

Add colour, clarity, grading lab, certificate number and image or video URLs where available. For Natural or mixed-origin stock, include Diamond type. A missing origin column defaults to Lab Grown; unknown values are rejected.

Upload and review mappings

Open your configurator → 2. Diamond Feed → Upload a CSV.
Review the detected header row and mapped fields. Correct stock number, shape, weight and cost first.
If using cost per carat, map both that field and carat weight. The importer can derive total cost from their product.
Map Diamond type and optional grade, certificate and media fields. Review sample rows before importing.
Import and read the results. Investigate rejected rows rather than assuming every source row became selectable.

The dashboard distinguishes imported stones, sellable stones and stones shown in 3D. These counts describe different stages; an imported row is not proof that a shopper can choose it.

Set and verify markup rules

Use Your markup to configure the retail price rules for imported stone costs. Review the price preview with low- and high-cost examples. Check that each save succeeds; an error means the changed markup was not stored.

Keep supplier costs and retail amounts conceptually separate when preparing your file. Review your configured currency alongside the storefront currency before interpreting a price difference as a markup issue.

Activate inventory in Pricing

Upload and activation are separate. Open 3. Pricing → Diamond prices, choose the relevant Lab Grown or Natural tab, then select From my diamond feed. Configure the ring’s mounting price or setting-and-band prices by metal and save.

Inventory supplies the diamond price. Your setting and band pricing supplies the ring without the centre stone. Avoid charging the same diamond through both a mounting price and an inventory price. Review mounting pricing.

Diamond Feed controls showing priced-by-grade and inventory modes and a message that uploaded diamonds are not yet active. — Uploading a list and activating its use are separate steps. Use the relevant origin’s Pricing profile to confirm your intended method. Click to view at full size.

Verify stock on the storefront

Open the published builder and choose the intended origin and shape.
Select a known stock stone. Compare weight, grades, certificate details and media with your source list.
Compare its retail price and complete ring total with your markup and mounting rules.
Test a quote or cart flow and check that the selected stock identifier reaches the order or request.
Re-upload when your source list changes and review the import results again. CSV upload does not automatically refresh from your supplier.

Diamond feeds overview · Complete setup guide