Jewellery line sheet generator

Why jewellery line sheets need extra columns

A general catalogue tool gives you a name, a price and a photo. That is enough for a tea towel and not enough for jewellery, where the same style exists in several metals and stones at different prices. If the line sheet only says “Fine Hoop Earrings”, a buyer cannot tell the silver from the vermeil, and the order comes back wrong.

This page reads jewellery attribute columns and keeps them beside the price:

• Metal or material — sterling silver, 14k gold vermeil, brass. Usually the largest driver of the price difference between two otherwise identical rows.
• Stone — left blank on plain styles, which is normal and does not leave a gap on the sheet.
• Size or length — ring sizes, chain lengths, hoop diameters. Buyers order size runs, not single pieces.
• Style number — one per variant, not one per design, so the order can be entered without a follow-up email.

Import a spreadsheet with columns called Metal, Stone or Size and they are detected automatically and combined into one attribute column. You can also type everything in by hand.

Pricing columns buyers expect

Wholesale price and MSRP side by side, plus minimum order quantity. Jewellery buyers work on keystone or better, so showing MSRP lets them check the margin without asking. Where you set MSRP is a commercial decision and this tool does not calculate one for you.

This tool lays out and formats the information you enter. It makes no assessment of materials, gemstones, purity, hallmarking or value.

Questions

How do I show the same style in several metals?

Give each variant its own row and its own style number, with the metal in its own column. They then sit next to each other on the sheet with the price difference visible, which is what a buyer needs to order accurately.

What if a piece has no stone?

Leave the cell empty. Empty attributes are skipped rather than printed as blanks, so plain styles do not leave gaps.

Does it check metal purity or value the pieces?

No, and deliberately so. It formats what you type. It performs no gemological, hallmarking, purity or valuation assessment of any kind.

Can I use it for a lookbook instead?

Switch the layout to catalogue grid for a photo-led version of the same products. Nothing needs re-entering.

Your data

This tool does no server-side processing at all. Product names, SKUs, prices, descriptions, photos and your logo are handled entirely by JavaScript in your browser and are never transmitted. We count how many people start the tool and how many produce a catalogue, and nothing else — see the privacy note for exactly what that means.