Start directly in Tradix
Open a collection with its fields prepared. Review the name and fields, create the collection and add your pieces. You can also import your Excel file into that same collection.
Set up my collectionFROM YOUR PIN BOARD TO YOUR INVENTORY
Your pins, neatly organized. Every variant has its place.
Distinguish series, references and finishes with a clear system. Keep track of the pins you own, those you want and those you wish to trade.
Choose how to start: directly in Tradix or with a free Excel file you can import later.
A SYSTEM YOU CAN KEEP USING
One record per variant. Track quantities separately.
Use a recognisable name and a stable reference. For identical pieces, record the number under Quantity; if an important characteristic changes, create another record.
YOUR CRITERIA, ALL IN ONE PLACE
A template to start. Your fields to continue.
The same image may have a different finish, size or edition. Use your own reference and create a separate record when the variant matters to your collection.
What you can record
- Series and reference
- Group by theme or collection and assign a reference to help recognize every variant.
- Finish and condition
- Record whether the pin is enamel, metal or another technique. Add condition and fastening type in Tradix if needed.
- Purchase price and notes
- Record the unit cost and keep personal notes in private fields.
THREE EXAMPLES TO UNDERSTAND THE SHEET
Owned, wanted and for trade mean different things.
Quantity is what you already own. Wanted quantity is how many you want to acquire. For trade uses 1 to offer an item and 0 not to offer it.
North Lighthouse pin
- Quantity
- 2
- Wanted quantity
- 0
- For trade
- Yes
Botanical Garden pin
- Quantity
- 1
- Wanted quantity
- 0
- For trade
- No
Central Station pin
- Quantity
- 0
- Wanted quantity
- 1
- For trade
- No
Purchase price is the amount paid per unit in euros. Leave it blank if unknown; zero means you paid nothing.
FROM EXCEL TO YOUR COLLECTION
Prepare your data. Review before saving.
The file has one sheet, one header row and three fictional examples. Replace or remove them and add your own items.
Download Excel templateKeep a copy of the original
Save a copy before editing. Keep the headers in the first row, replace the examples and avoid merging cells within the data.
Map columns when importing
Select the file under Import. If you have already created the collection, choose it as the destination; you can also create a new one. Before confirming, check the sheet, one row per item, headers in row 1 and the column mapping.
Choose what you want to share
New imported collections start private. Review which fields will be public and add photographs to the records before sharing.
FROM FILE TO FIELD
How your data reaches Tradix.
The sheet uses columns the importer recognises. Always check the preview: you can change a column’s destination or add custom fields before saving.
Quantity and Wanted units are whole numbers from zero upwards. For trade uses 1 or 0. Keep a reference such as 00123 as text so its leading zeros are preserved.
Import my file into Tradix →Excel column → Destination
- Name
- Name
- Quantity
- Quantity
- Series
- Private custom field
- Reference
- Private custom field
- Finish
- Private custom field
- Purchase price
- Purchase price per unit
- Wanted quantity
- Wanted
- For trade
- For trade
Before you start
A few common questions
Can I start without using Excel?
Yes. The button to start in Tradix opens a collection with prepared fields and no sample items. Sign in or create your account, then adapt the fields and save the collection.
Can I use the template without an account?
Yes. Download it and use it in Excel without signing up. To import it into Tradix, you need your own account and available capacity in your plan.
Does the template include images or a complete catalogue?
No. It includes three fictional examples to show how to organize the data. You add your own items; photographs are added later in Tradix.
Will trade lists be created automatically?
No. The sheet stores quantities and wanted and trade flags. Lists are created from your account and require a plan that includes them.
CONTINUE AT YOUR OWN PACE