DEV Community: Sikah Sebastien

Why Bullion Inventory Doesn't Behave Like Normal E-Commerce Inventory

Sikah Sebastien — Fri, 11 Sep 2026 01:51:07 +0000

If you've built inventory for a typical e-commerce store, the core assumption is almost always: a SKU represents an interchangeable unit, and inventory is a quantity count against that SKU. Sell one, decrement the count. Restock, increment it. Any unit of SKU-X is identical to any other unit of SKU-X — that's what makes it a SKU in the first place.

A decent chunk of bullion inventory doesn't fit that model, and pretending it does creates real bugs.

Some units are genuinely fungible — and some aren't
A generic 1 oz gold coin from a large mint run is close to the classic fungible-SKU case: any unit is interchangeable with any other unit of the same product, year, and condition. Standard quantity-based inventory works fine here.

A serialized bar is a different object entirely. Per the LBMA's own Good Delivery marking specification, a compliant bar carries a serial number — up to 11 digits or characters — that has to match the number on its accompanying assay card exactly. That's not a SKU. That's closer to a VIN on a car, or a serial-tracked asset in an ERP system: each physical unit is a distinct entity with its own identity, not an interchangeable instance of a product type.

Model that as plain SKU-quantity inventory and you've thrown away information you can't get back — you know you have "3 units of 10 oz PAMP bars in stock," but you've lost which specific serial number a customer is actually going to receive, and whether that serial number's assay card is the one currently sitting in your safe or the one that shipped out last week.

A 1 kilogram silver bar with its own serial number, distinct from generic quantity-tracked coin inventory
Photo: Gilded Bullion
What this actually requires in the data model
A serialized item needs its own row, not a quantity field. Each physical bar or coin with a unique serial should be a distinct record with its own lifecycle (in stock → reserved → shipped), not a decrement against a shared count.
The serial number is a second key, not metadata. It has to be queryable and unique-constrained independently of your internal product/SKU ID, because a customer service question ("is serial #4471829 legitimate") comes in referencing the manufacturer's number, not your internal ID.
Fungible and serialized items can share a product page but not a storage model. A 1 oz gold coin listing might sell against a simple quantity count, while a 10 oz bar listing on the same site needs to reserve one specific serialized row per sale. Building one inventory abstraction that handles both cleanly is harder than it looks at first glance — a naive "everything is a SKU with a count" model works for one and silently breaks for the other.
Returns and buy-backs need to reunite an item with its original identity. If a customer sends back a serialized bar, the system needs to match it to its specific record, not just credit a generic quantity — this matters directly for verification workflows, since a returned item's serial should match what was actually shipped, not just the product type.
Where the two models have to coexist
This is the same distinction that makes something like a jewelry-grade alloy less traceable than an investment-grade bar with a named refiner — one is priced and tracked as a fungible commodity, the other as a discrete, individually verifiable asset. A real bullion catalog has both, often on the same page (buy 1, or buy 10, of a serialized bar), which means the inventory layer has to support per-unit identity without forcing every product into that heavier model unnecessarily.

Gilded Bullion's own catalog runs on exactly that split — our gold bar listings track serialized inventory per-unit where the product is serialized, while coin listings run on simpler quantity tracking. If you're modeling something similar, the mistake to avoid is treating "inventory" as one uniform concept across your whole catalog when the underlying items aren't actually uniform.

General information about data modeling and inventory systems, not investment or legal advice.

Alexander Sterling is the founder and CEO of Gilded Bullion, a US-based online dealer in gold, silver, platinum and palladium bullion.

Why Precious Metals Pricing Data Is Trickier to Cache Than You'd Think

Sikah Sebastien — Thu, 10 Sep 2026 22:35:17 +0000

If you've ever built or consumed a price feed for equities or crypto and assumed precious metals would follow the same pattern — one continuous number, ticking constantly, one "true" source of truth — the actual structure of gold pricing will surprise you. There isn't one price. There are at least two, they're produced by different mechanisms, and neither one is exactly what a retail checkout page shows you.

The market is nearly always open, but the "official" price isn't continuous
Gold futures on CME trade close to around the clock. Per CME Group's own contract specifications, the 1-ounce gold contract runs "24/7 with the exception of the following maintenance windows: Saturday at 2:00 a.m. to 4:00 a.m. CT" and a two-minute daily gap Monday through Friday at 4:00-4:02 p.m. CT. So from a "when is there a live tick" standpoint, gold behaves almost like crypto — sparse, short, predictable gaps rather than a real market close.

But that continuous futures feed isn't the benchmark most of the bullion industry actually prices against for settlement purposes. That's a separate mechanism entirely.

The benchmark price is a twice-daily auction, not a tick
Per the LBMA's own documentation, the LBMA Gold Price is set twice a day — 10:30 and 15:00 UK time — through an electronic auction where a chairperson sets a starting price, participants submit buy/sell orders by volume, and the auction concludes once the net imbalance falls within a 10,000 oz tolerance. It's explicitly described as producing a settlement price, not a running feed: "all volume tradeable at that price," for that one moment.

So you've got two legitimately different data objects with the word "gold price" attached to them: a near-continuous futures tick that updates constantly but reflects one exchange's order book, and a twice-daily settlement number that's contractually referenced across huge parts of the physical bullion trade but is stale by definition the instant after it's published.

A 1 oz gold coin, priced against a live spot feed rather than the twice-daily benchmark auction
Photo: Gilded Bullion
Where this actually bites you as a developer
TTL choice isn't obvious. Cache a futures-derived spot feed too long and you're visibly stale during active trading hours. Cache the LBMA auction result with a short TTL and you're just re-fetching a number that's correct but was already correct an hour ago — wasted requests for zero freshness gain.
"Market closed" isn't a clean state. Unlike equities, there's no single well-defined closed period to fall back to a last-known-good value cleanly — the maintenance windows are short and asymmetric (a 2-minute daily gap, a 2-hour weekend gap), so your fallback logic needs to handle brief gaps gracefully rather than a predictable multi-hour close.
The number a customer sees usually isn't either of the above, unmodified. Retail pricing (ours included) applies a per-product premium on top of whichever spot feed it's built on, and that premium can itself change independently of the metal price — so "the price" a cache serves is really a composite of at least two independently-updating values, not one.
Practically, this pushed us toward pricing every listing dynamically against a live feed rather than a periodically-refreshed cached price — our gold bullion listings reprice continuously through the day rather than on a fixed refresh interval, specifically because the "safe" cache window for this kind of data is much shorter than it looks at first glance. Same logic applies on the silver bullion side, where spot moves proportionally faster relative to price than gold does.

If you're building anything that touches a metals price feed — a portfolio tracker, a checkout, an alert system — worth deciding up front which of the two numbers you actually need, because they answer different questions and neither substitutes cleanly for the other.

This is general information about market structure, not investment, tax or legal advice; precious-metal prices can fall as well as rise.

Alexander Sterling is the founder and CEO of Gilded Bullion, a US-based online dealer in gold, silver, platinum and palladium bullion.

What Actually Happens to Gold Prices When the Dollar Weakens

Sikah Sebastien — Tue, 08 Sep 2026 01:30:00 +0000

It's not superstition and it's not a coincidence — there's real arithmetic and real investor behavior behind the pattern.

Anyone who's watched gold prices for more than a few months has heard some version of "gold goes up when the dollar goes down." It's a real pattern, and it's grounded in two separate mechanisms rather than one vague correlation — though, like most market relationships, it isn't a law of physics.

The first mechanism: it's arithmetic
Gold is priced globally in US dollars. As CME Group's own market commentary puts it plainly, "a stronger dollar means it takes fewer dollars to buy the same amount of gold" — and the reverse holds when the dollar weakens: it simply takes more dollars to buy the same ounce, which shows up as a higher dollar price even if nothing about global gold demand changed at all.

The second mechanism: it's about where investors want their money
The same CME commentary notes that gold becomes "less attractive as a non-yielding asset when the dollar strengthens and U.S. interest rates rise, making dollar-denominated assets more appealing to investors seeking returns via yields." Flip that around: when the dollar weakens and yields fall, holding a Treasury or a dollar deposit gets less rewarding, and an asset that pays no yield at all — like gold — loses less of its relative appeal by comparison.

Obverse of an American Gold Eagle coin, priced against live spot
Photo: Gilded Bullion
A real, recent example of both mechanisms at once
The World Gold Council's own market commentary for February 2026 is a clean case study. Gold rose about 5% that month to roughly $5,222/oz, and the Council's own attribution model pointed to "a weaker US dollar, particularly against EM currencies" as a major driver, with a lower 10-year Treasury yield adding further support. Gold ETFs took in $5.3 billion in new assets that same month, with strong buying from both North America and Asia.

The currency detail is worth sitting with too: gold gained 4.8% in dollar terms that month, but the actual experience varied a lot by country. Because the rupee strengthened, Indian gold buyers actually saw local prices fall about 3.5% the same month gold hit new dollar highs. UK buyers, by contrast, saw a 6.4% gain in sterling terms. Same global gold price move, three very different local outcomes — which is the currency-filter effect in action, not a contradiction of the dollar-gold relationship.

Where this breaks down
The inverse relationship isn't a rule you can trade blind. Both the World Gold Council's and CME's commentary note stretches — including 2023-2024 — where gold and the dollar rose together, because both were acting as safe havens during the same period of broad uncertainty. When something bigger than currency mechanics is driving markets, the usual pattern can simply stop holding for a while.

A 100 troy ounce silver bar, priced against the same live spot mechanics as gold
Photo: Gilded Bullion
What this means if you're buying rather than trading
None of this is a timing signal — dollar direction is genuinely hard to forecast, and gold has plenty of drivers besides the dollar (central bank buying, real yields, geopolitical demand). What it does mean is that a headline about "the dollar falling" or "the dollar rallying" is relevant context for why gold moved that week, not noise to ignore. Gilded Bullion's gold bullion listings reprice against live spot throughout the day, so the same dollar move that shows up in the headlines shows up in the listed price the same day, not with a lag.

If you're comparing forms rather than just timing, our gold coin listings and bar listings both track the same underlying spot price — the dollar mechanics above apply the same way regardless of which form you're holding.

FAQ
Why does gold usually rise when the US dollar weakens?
Two reasons: gold is priced in dollars globally, so a weaker dollar mechanically takes more dollars to buy the same ounce, and a weaker dollar with lower yields makes non-yielding assets like gold relatively more attractive to investors seeking returns elsewhere.

Does gold always move opposite to the dollar?
No. The inverse relationship holds often but not always — during periods of broad uncertainty, both the dollar and gold can act as safe havens and rise together, which has happened in several recent stretches.

Does a weaker dollar affect gold's price the same way in every country?
No. Gold's dollar-denominated price move gets filtered through each country's own currency. A market whose local currency also strengthened against the dollar can see a much smaller gold gain, or even a loss, in local terms, even while the US dollar price of gold rises.

This is general information, not investment, tax or legal advice; precious-metal prices can fall as well as rise, so consider your own situation or speak to a licensed adviser.

Alexander Sterling is the founder and CEO of Gilded Bullion, a US-based online dealer in gold, silver, platinum and palladium bullion.

Kilo Gold Bars: Who Actually Buys a 32-Ounce Brick

Sikah Sebastien — Sun, 06 Sep 2026 20:46:56 +0000

It's heavier than it sounds, and much lighter than the bar the actual gold market runs on.

A 1 kilo gold bar holds 32.1507 troy ounces of gold. Picture that next to a stack of one-ounce coins — thirty-two of them, roughly — and it starts to feel like a serious amount of metal. Then look at what the institutional gold market actually trades in, and the kilo bar shrinks back down to a fairly modest size.

The bar you're picturing is much bigger than a kilo
The London Bullion Market Association's Good Delivery specification sets the standard wholesale gold bar at 350 to 430 fine troy ounces, with a minimum fineness of 995.0 parts per thousand. Refiners aim for a nominal weight around 400 ounces. That's the bar that moves between central bank vaults, bullion banks, and refiners — roughly twelve to thirteen times the weight of a kilo bar.

At a recent gold price near $4,334 an ounce, a single 400 oz Good Delivery bar is worth in the neighborhood of $1.7 million. It's not a retail product. It's never been designed to be one.

A 1 kilogram gold bar, 32.15 troy ounces, .9999 fine
Photo: Gilded Bullion
The kilo bar fills the gap underneath it
A kilo bar is typically cast or minted to .9999 fine — higher purity than the 995 minimum the LBMA requires for the big institutional bar. At the same $4,334 spot price, a kilo bar runs around $139,000: a fraction of the 400 oz bar's value, but still a size most individual buyers never encounter.

Form Weight (troy oz) Approx. value at $4,334/oz Who actually holds it
1 oz coin 1.00 $4,334 Most individual buyers
10 oz bar 10.00 $43,340 Larger individual positions
1 kilo bar 32.15 ~$139,341 Serious individual and family-office buyers
LBMA Good Delivery bar ~400 ~$1,733,600 Central banks, bullion banks, refiners
The kilo bar's real position is as a bridge: too large and illiquid for a first purchase, far too small to touch the institutional market. It exists for buyers who've outgrown coins and small bars but have no reason to hold a bar the size of a cinder block.

A 100 oz silver bar shown for size comparison against smaller gold formats
Photo: Gilded Bullion
Why consolidate at all
The same fabrication-cost logic that makes a 100 oz silver bar cheaper per ounce than ten 10 oz bars applies here. Fewer, larger units mean fewer casts, fewer assay checks, fewer individual certificates — and that saving shows up as a lower premium over spot on a kilo bar than on the equivalent weight in one-ounce coins.

The trade-off is liquidity. A kilo bar sells as one unit. If you need to raise cash for a smaller amount, you're selling the whole thing or none of it — unlike a stack of coins, where you can sell exactly what you need.

Who this size actually suits
Buyers consolidating an existing position. Someone holding a large number of smaller coins or bars sometimes trades up to fewer, larger units to reduce the average premium paid.
Buyers who won't need partial liquidity. If the plan is to hold the position as a whole and not sell in pieces, the kilo bar's lower per-ounce cost is a clean advantage with no real downside.
Not first-time buyers. The absolute dollar commitment is large, and there's no ability to test the waters with a small purchase first.
If part of the plan eventually involves selling some of it back rather than the whole bar at once, that's worth weighing before buying — Gilded Bullion, like most dealers, buys gold, silver and platinum back from the public, but a kilo bar still comes back as one transaction, not several.

Current kilo gold bar listings reprice against live spot, if you want to see today's premium over the metal value.

The one-line rule
Buy a kilo bar only if you're comfortable holding it as a single, undivided unit. If there's any real chance you'll want to sell part of your gold and keep the rest, several 10 oz gold bars of the same total weight cost a little more per ounce but buy you the flexibility a kilo bar doesn't offer.

FAQ
How many troy ounces are in a 1 kilo gold bar?
32.1507 troy ounces. A kilogram is a metric weight and gold is priced in troy ounces, so the conversion isn't round — 32.15 oz is the figure used across the trade.

Is a kilo gold bar the same as the bar used in the wholesale gold market?
No. The LBMA's Good Delivery gold bar runs 350 to 430 fine troy ounces, nominally around 400 ounces — roughly twelve to thirteen times heavier than a kilo bar. That bar moves between institutional vaults and isn't sold to individual buyers.

Who buys kilo gold bars?
Mostly buyers consolidating a meaningful position into fewer, larger units to reduce per-ounce fabrication cost, rather than first-time or small buyers. Because a kilo bar can't be sold in pieces, it suits someone who doesn't expect to need partial liquidity.

This is general information, not investment, tax or legal advice; precious-metal prices can fall as well as rise, so consider your own situation or speak to a licensed adviser.

Alexander Sterling is the founder and CEO of Gilded Bullion, a US-based online dealer in gold, silver, platinum and palladium bullion.