Help Center Importing
Spreadsheet columns
Every column Hermes can import, what goes in it, and the other names it recognizes.
Column names aren't case-sensitive, and spaces and punctuation are ignored, so "Purchase Price", "purchase_price", and "PURCHASE PRICE" all work.
| Column | What goes in it | Also recognized as |
|---|---|---|
| Name | Required. What the item is. | Item, Item name, Title, Product |
| SKU | Optional, must be unique. Match it to the eBay custom label for automatic matching. | Custom label, Custom label (SKU) |
| Status | Bought, In repair, Listed, Sold, Returned, or Written off. Blank: worked out from the prices. | Stage, State |
| Bin | New names are created for you. | Location, Shelf, Storage |
| Category | New names are created for you. | Type |
| Condition | New, Like new, Good, Fair, or For parts / broken. Other wording is kept as is. | |
| Description | Free text. | |
| Source | Where you found it. | Bought from, Where found, Sourced from, Supplier |
| Purchase date | 2026-10-01 or 10/1/2026. | Date bought, Bought on, Purchased, Buy date |
| Purchase price | What you paid. $ and commas are fine. | Cost, Price paid, Paid, Buy price, Cost of goods, COGS |
| Repair cost | Total spent on repairs; saved as one part. | Repairs, Parts cost, Parts |
| Platform | eBay, Facebook Marketplace, etc. New names are created. | Marketplace, Sold on, Listed on, Channel |
| List price | Required when Status is Listed. | Asking price, Listing price, Price |
| Listed date | Date listed, List date | |
| Listing URL | Must start with https:// | Link, URL, Listing link |
| Sale price | Required when Status is Sold. | Sold price, Sold for, Sale amount, Revenue |
| Sold date | Date sold, Sale date, Sold on | |
| Platform fees | Leave blank on a sale to work it out from the platform's fee rate. | Fees, eBay fees, Selling fees |
| Shipping cost | What you paid to ship it. | Shipping, Postage, Label, Shipping paid, Label cost |
| Shipping charged | What the buyer paid for shipping. | Buyer shipping, Shipping income, Shipping collected |
| Ad fees | Promoted listing fees. | Ad fee, Promoted fees, Promoted, Ad rate |
| Refunded | Money given back to the buyer. | Refund, Refunds, Refund amount |
| Shipped date | Date shipped, Ship date, Shipped | |
| Carrier | USPS, UPS, FedEx… | Shipping carrier, Courier |
| Tracking | Tracking number, Tracking #, Tracking no | |
| Notes | Comments, Memo |