How to auto update the prices based on a variable I enter

Shopify Discussion

Topic summary

A jewelry website owner seeks a solution to automatically update product prices based on daily fluctuating gold rates, with variations across different carat levels (14K, 18K, 22K).

Proposed Solutions:

Custom Development Approach:

  • Build a custom app/script that fetches daily gold rates from APIs (Metals-API, GoldAPI)
  • Automatically calculates prices based on weight and carat per variant
  • Updates prices via Shopify Admin API or GraphQL
  • Most flexible for growing catalogs

Shopify Plus Option:

  • Use Shopify Functions for dynamic pricing at checkout
  • Requires coding knowledge and Shopify Plus subscription

Third-Party Apps:

  • Apps like “Gold Price Calculator” or “Live Price Updater” offer automated adjustments
  • Can set base formulas incorporating gold rate, weight, and making charges
  • Support different carat multipliers (e.g., 22K = 91.6% gold)

Manual/Semi-Automated:

  • Export products to CSV, apply Excel formulas with current gold rates, re-import
  • Can be partially automated using Google Sheets + Zapier
  • Suitable for smaller catalogs or weekly/monthly updates

Status: Discussion remains open with multiple viable approaches presented, ranging from fully automated to semi-manual solutions depending on technical capability and budget.

Summarized with AI on October 29. AI used: claude-sonnet-4-5-20250929.
1

Hello All,

I am trying to build my Jewellery website, but as you all know that gold prices are changing everyday, I want to update the prices of my products on the gold prices.

I am confused on how to do this the best way, hassle free. The gold prices vary for different variants of the jewelry based on the Carats

2

hi @sanchith

Dynamic pricing based on daily gold rates is a common challenge for jewelry stores, and there are a few ways you can set this up in a more automated, hassle-free way.

Option 1: Use a Custom Shopify App or Script
You can build (or have a developer build) a custom app or script that:

  • Fetches the daily gold rates from a trusted API (like Metals-API or GoldAPI).
  • Calculates prices based on weight and carat per variant (e.g. 14K, 18K, 22K).
  • Automatically updates your product/variant prices using the Shopify Admin API or GraphQL.

This is the most flexible and future-proof solution if your catalog grows.

Option 2: Use Shopify Functions (if using Shopify Plus)
If you’re on Shopify Plus, you can use Shopify Functions to apply dynamic pricing at checkout based on real-time gold rates — while keeping displayed prices stable if needed. However, this does require some coding and setup.

Option 3: Manual or Semi-Automated Update via CSV
If you’re just starting out and have a manageable number of products:

  • Prepare a product export CSV.
  • Calculate the new prices externally (e.g., with Excel formulas based on the daily rate).
  • Re-import the updated CSV to Shopify each day.

You can even semi-automate this with Google Sheets + Shopify CSV apps or Zapier.

3

Great question! Managing jewelry pricing with fluctuating gold rates can be tricky, but there are a few streamlined ways to handle this on Shopify:

Option 1: Use a Third-Party App
Apps like Gold Price Calculator or Live Price Updater automatically adjust product prices based on real-time gold rates.
You can set:

  • Base formulas (e.g., price = gold rate × weight + labor/making charges).
  • Different carat multipliers (e.g., 22K = 91.6% gold, 18K = 75% gold).

Option 2: Metafields + Shopify Functions
If you’re tech-savvy:

  1. Add metafields for each product’s gold weight and carat purity (e.g., weight_grams, carat_multiplier).
  2. Use a Shopify function or script to fetch daily gold prices (via API, e.g., GoldAPI) and recalculate prices.

Option 3: Bulk Price Updates (Manual but Simple)

  1. Export products to CSV.
  2. Use Excel formulas to adjust prices (e.g., =(GoldRate × Weight × Carat%) + MakingCharges).
  3. Re-import the CSV.

Tip: Schedule this weekly/monthly to reduce hassle.

Would you like recommendations for a specific app or help with formulas? Happy to clarify!

Best,
Adelina