Frooition CSV Export
JewelTrak generates the CSV file you upload to Frooition. Frooition has no public API, so the workflow is:
- Select items on the Frooition Listings page and download the CSV
- Log in to frooition.com
- Upload the CSV into their bulk uploader
- Frooition wraps each row in your branded HTML template and pushes the listing to eBay
This is for shops that pay Frooition for branded listing design and want JewelTrak to stay the source of truth for inventory and pricing, without re-keying anything.
Why use this vs. JT’s direct eBay integration?
| JewelTrak Direct eBay | Frooition CSV | |
|---|---|---|
| Listing description design | Plain text or your own HTML | Frooition’s branded template |
| Inventory + price sync | Automatic (QOH→0 retires listing) | Manual (re-upload CSV as inventory changes) |
| Item Specifics | Structured via eBay API (Metal, Main Stone, etc.) | Limited (universal product IDs only) |
| Operating cost | Your eBay seller fees only | Frooition subscription + eBay fees |
Your shop’s layout — nothing to configure
Your previous system built the Frooition file with a layout written for your shop. JewelTrak does the same: JewelTrak sets up your shop’s Frooition layout, and it builds every column exactly as your previous system did, from the same places. There is no settings page and no Frooition tab on an item.
What a layout does depends on the shop. For example:
- One shop’s layout takes the title and description from the item’s Website settings (for jewelry with a loose stone linked into it, from the stone’s Website settings), uses the six-digit stock number as the SKU, and only lists web-ready items: a preset appraisal, the three website texts and a main photo.
- Another shop’s layout codes the SKU, adds a fixed “Item Details” block to every description, and sets the eBay category from the item’s Main Group.
If your shop’s layout hasn’t been set up yet, the download says so instead of building a file. Contact JewelTrak support to have it set up.
A piece with several stones
When a piece of jewelry has more than one loose stone linked into it, and those stones have different Website text, the file gets one row per stone, all under the piece’s SKU, just as your previous system produced. Stones with the same Website text, or none, come out as a single row. If you see a row titled for a stone that no longer belongs with the piece, the stone’s own Website settings are out of date: correct or clear them.
Images
The image columns hold the item’s photos, followed (for shops that list their paperwork on eBay) by the certificate, the video and the preset appraisal. eBay displays images only, never PDFs, so each document goes in as its JPG copy. For jewelry, the photos and certificates come from the loose stones linked into the piece, and the piece’s own photos are used only when those stones have none. A loose stone with no photos gets its shape’s stand-in picture. A certificate that has no JPG yet gets one made from its PDF the first time it’s exported, and anything missing is left out rather than linked. Up to 20 images in total.
eBay category and item specifics
When an item has its eBay category and item specifics saved in JewelTrak (Metal, Metal Purity, Main Stone, Ring Size and so on), the file carries them, so you no longer pick them by hand in Frooition after the upload. They go in as extra rows under the item’s row, which is how Frooition’s import expects them.
Where you enter them. Open the item, then Sales Channels → Frooition. If your shop also lists on eBay directly, the eBay tab shows this same section; it’s one set of values, entered once for both.
- eBay category comes first: it decides which item specifics are listed. JewelTrak picks one from the item’s Main Group (a Ring goes to Fine Jewelry > Rings); change it if it’s wrong. Changing it keeps every value you’ve already entered.
- Item specifics lists the specifics shops usually fill in for that category. Values JewelTrak already knows (metal, metal purity, type, ring size, and the details of any loose stone linked into the piece) are filled in and marked From JewelTrak; your shop’s defaults are marked Shop default. Fill in the rest, usually the diamond details. Click into a box to see the values commonly used on eBay, or type your own.
- Specifics that take several values (such as Occasion or Style) take one value at a time: type it and press Enter.
- Add another specific adds one the list doesn’t show.
- Save item specifics saves them; from then on they’re marked Saved, and that saved set is what the next export sends. On an item with nothing saved yet the button is ready straight away, so you can keep what JewelTrak filled in without changing anything.
Shop defaults (at the bottom of the same panel, for users who manage sales channels) are values that apply to every item, such as Brand = Unbranded or Country of Origin = United States. They’re filled in on any item that has nothing saved yet, underneath what JewelTrak knows about the item.
An item with nothing saved gets no item-specific rows, and Frooition keeps whatever you already picked there. That matters because a Frooition import replaces all of a listing’s item specifics with the ones in the file: JewelTrak only ever sends an item’s complete set.
The Frooition Listings page
Online → Listings → Frooition is where you build the CSV. It lists your available items. Search to find items, then check the rows you want. Because Frooition is a manual CSV upload (no API), there’s no “listed/unlisted” state here: the CSV simply contains whatever you’ve selected. Unchecking a row removes it.
- Show selected only (in the bulk-action bar) collapses the table to just your checked rows, even across pages, so you can review the full set before exporting.
- Download CSV of selected items (top right) produces the file from your current selection.
Selection persists as you page and filter within the session, so you can build a set across multiple pages and download it in one go.
Items left out. Your layout only includes the items your previous system would have listed. After the download, a notice at the top of the page lists anything it left out and why, such as “Website settings missing Long Web Description” or “No preset appraisal with a title and a value”. Fix the item and download again.
After download
- Log in to frooition.com
- Open the bulk listing tool
- Upload the CSV
- Frooition validates, renders and pushes to eBay
Workflow tips
- Re-export when inventory changes. Frooition doesn’t auto-sync. If you change a price in JT, re-export and re-upload that row to update the eBay listing.
- Select everything for a batch. A 50-item Frooition upload is one CSV, not 50.
Troubleshooting
- Frooition says the file is incompatible. The export is a standard comma-separated CSV with every cell in double quotes, the same layout Frooition has always accepted. If you downloaded the file before September 18, 2026, download it again; older exports were tab-separated and Frooition rejects them. Upload the file as downloaded, without opening and re-saving it in Excel first.
- An item you selected isn’t in the file. Check the notice at the top of the page after the download: it names each item left out and the reason.
- Image links don’t load in Frooition’s preview. Paste one into a browser. JewelTrak’s image links are public; if one fails, tell JewelTrak support which item it was.