Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Track, Price and Sell One-Off Coral Frags Without a Spreadsheet and a Phone Full of Photos?
Problems We Solve

How Do We Track, Price and Sell One-Off Coral Frags Without a Spreadsheet and a Phone Full of Photos?

Marine aquatics shops sell one-off coral frags priced by hand, with photos on a phone. We build frag records with photos, till codes and web listing.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Coral frags and colonies are often one-offs: each piece is different, priced individually and photographed for social media. Shops track them on a spreadsheet and a phone camera roll, and the till sells them on a generic key. We build a frag record with a unique code, photo, tank location and price, printed plug tags your till can scan, and an automatic listing on your website that disappears the moment the frag sells.

A frag tank and a camera roll

Your marine section has a frag tank with dozens of small coral frags on plugs, plus a few larger colonies in display systems. Each one is different: colour, size, growth form. Your marine specialist photographs new frags on a phone, posts some on social media, and writes prices on a spreadsheet and on little tags stuck to the rack.

A customer messages about a frag they saw online. The specialist is off, and nobody else can tell from the photo which plug it is. At the till, frags are rung through on a coral key at the price on the tag, if the tag has not fallen off. The frag sold on Saturday is still being advertised online on Monday, and two more people message about it.

Why one-off stock is hard to manage

Tills and websites are built for products that repeat: many units with one barcode and one price. Coral frags are closer to art: each is unique, priced on its own merits and sold once. That does not fit the usual tools.

  • Each frag has no barcode or product record of its own.
  • Photos live on one person's phone.
  • Prices are on handwritten tags and a spreadsheet.
  • The till sells frags on a generic key, so nobody knows which one sold.
  • Online and social posts are not updated when a frag sells.

What the camera roll costs you

Customers who enquire about a frag that has already gone are disappointed, and staff spend time answering messages about stock that no longer exists. Frags sold on a generic key at the wrong price, because a tag fell off or was swapped, are lost margin. Without a record, you cannot see which types of frag sell quickly, what they fetch, or how long they sit.

It also makes the whole marine section depend on one specialist, because only they know which frag is which.

A record and a code for every frag

  1. When a frag goes on sale, staff create a record on a phone: photo, type, size notes, tank and rack position, and price.
  2. A small waterproof tag or plug label is printed with a unique code, which your till scans to sell exactly that frag at its price.
  3. Frags are listed automatically on your website with their photo and price, or on a simple frag page if you do not sell online.
  4. When a frag sells at the till or online, it is marked sold everywhere at once, and the listing disappears.
  5. Customer enquiries about a frag can be matched to its record by code, so any member of staff can find it.
  6. Reports show sell-through by coral type and price band, and frags that have been on sale for a long time.
TaskSpreadsheet and phoneFrag records
IdentityA photo on one phoneUnique code and record
PriceHandwritten tagStored and scanned
At the tillGeneric keyScan sells that frag
OnlinePosts not updatedListing removed on sale
InsightNoneSell-through by type and price

How corals are grown, cut and kept is your specialist's craft. The system only handles identity, price and sale.

A frag tank that sells itself

New frags are photographed and tagged as they go into the tank. Customers browse the frag page on your website or social links and message about a specific code. Any staff member can find it in the tank by rack position and sell it at the right price.

When a frag sells, it disappears from the website straight away. The specialist can see which coral types move fastest and price new frags with evidence, and the section keeps running on their day off.

Is your frag tank run from a camera roll?

  • Frag photos live on one person's phone.
  • Prices are on handwritten tags.
  • The till sells frags on a generic key.
  • Customers ask about frags that have already sold.
  • Only one person knows which frag is which.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Do we need a website to use this?

No. A simple frag page can be hosted for you, or the records can be used in store only.

Will the tags survive in the tank area?

We use waterproof labels suited to damp environments. For plugs, we check what fits your racks.

Can it post to social media?

It can create a post ready to share with the photo and code. Posting stays with you.

What drives the cost?

Till integration, website listing and label printing.

Keep reading

More on Problems We Solve

Start here

Tell us where your pet shop admin gets stuck

Describe how stock, prices and customers move through your pet shop or aquatics centre today, which till, website and suppliers you use, and where the spreadsheets and paper take over. We will tell you what we would build and what we would leave alone, and if your current system already does it with a setting you have not switched on, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →