Before you start
- Start from the template, or use your own sheet. Exports from eBay and other crosslisting tools usually work as they are: common column names such as “Item name”, “Qty”, “Custom label (SKU)” and “Image 1” are recognized.
- Files can be .xlsx, .csv or .tsv, with up to 10,000 rows and 50 MB. Split bigger files.
- The first row holds the column names. In an .xlsx file, the sheet named “Items” is read, or else the first sheet.
- Only Title is required. Leave any other column out, or leave its cells blank.
- If a column name isn’t recognized, you choose which field it fills, or leave it out, before the import starts.
- To start, open Listings, choose Import, then Upload spreadsheet.
Columns
Capital letters, spaces and underscores in column names don’t matter.
| Column | What it holds | Example |
|---|---|---|
| Title | What it holdsRequired. Up to 500 characters. Titles over 80 characters get a shortened version for eBay, Mercari and Poshmark, which you can edit when you review the import. | ExampleLevi’s 501 Original Fit Jeans Men’s 32x30 Dark Wash |
| Description | What it holdsUp to 9,999 characters. HTML, as in eBay exports, is turned into plain text. | Example |
| SKU | What it holdsYour own item number. Also used to spot items you already have. | ExampleBIN-A12 |
| Price | What it holdsA number. $ signs and commas are fine. | Example$45.00 |
| Original price | What it holdsShown on Poshmark. | Example120 |
| Cost | What it holdsWhat you paid. Buyers never see it. | Example8.50 |
| Quantity | What it holdsA whole number. Blank means 1. | Example1 |
| Brand | What it holdsAs written. “None”, “Unbranded”, “N/A” or “Unknown” means no brand. | ExampleLevi’s |
| Category | What it holdsAn eBay category number, a category name or path, or blank. See Category. | ExampleWomen > Accessories > Scarves |
| Size | What it holdsAs written. | ExampleM, 10.5, W32 L30 |
| Condition | What it holdsSee Condition. | ExampleNWT |
| Color | What it holdsOne color, or two. See Color. | ExampleNavy/White |
| Secondary color | What it holdsOne color. | ExampleWhite |
| Style tags | What it holdsUp to 3. | ExampleVintage, Streetwear |
| Weight (lb) and Weight (oz) | What it holdsPackage weight. Partial ounces round up to the next whole ounce. | Example1 and 4 |
| Weight | What it holdsPackage weight in one cell, with its unit: lb, oz, g or kg. | Example1.5 lb |
| Length (in), Width (in), Height (in) | What it holdsPackage size in inches. Blank uses your account defaults. | Example12 |
| ZIP code | What it holdsThe ZIP code you ship from. Blank uses your account default. | Example90210 |
| Free shipping | What it holdsYes or no. | ExampleYes |
| Notes | What it holdsPrivate notes, such as where the item is stored. | ExampleShelf 3 |
| Photos | What it holdsSee Photos. | ExampleIMG_1234.jpg | IMG_1235.jpg |
| Status, Date sold | What it holdsRows marked “Sold”, or with a sold date, are not imported. | ExampleSold |
Category
The Category cell can hold any of these:
- An eBay category number, such as
57988. It is used exactly, as long as it is a current eBay category. - A category name or path, such as
ScarvesorWomen > Accessories > Scarves. Prismalist picks the closest category, using the title as well. - Nothing. Prismalist picks the category from the title.
Prismalist sets the matching category on each marketplace. When it isn’t sure about one, the review asks you to confirm it, and you can change any row’s category there.
Condition
| Condition | Words that work |
|---|---|
| New With Tags | New with tags, NWT, BNWT |
| New Without Tags | New without tags, NWOT, BNWOT, New other, Open box |
| New With Tags or New Without Tags | New, Brand new, NW (with tags when the title or description mentions tags) |
| Like New | Like new, EUC, Excellent, Mint, Nearly new |
| Used Good | Good, Very good, GUC, VGUC, Used, Pre-owned, Gently used |
| Used Fair | Fair, Poor, Acceptable, Flawed |
- Capital letters, dashes and underscores don’t matter, so “pre-owned”, “Pre Owned” and “NewWithTags” all work.
- Condition numbers from an eBay export work too.
- “For parts or not working” isn’t supported. Those rows are imported without a condition.
Color and style tags
- Write a color name. Shades such as Navy or Off-White are matched to the closest standard color.
- Two colors can share the Color cell when separated by
/-+,or&, such asNavy/White. The second becomes the secondary color if that column is blank. - Style tags are separated by
,;or|. The first 3 are kept.
Photos
Each item takes up to 16 photos, in the order you list them. Use a Photos column, or numbered columns such as Image 1, Image 2, read from left to right. In one cell, separate photos with | or a line break.
Each photo can be:
| Type | Example | Works when |
|---|---|---|
| A web link | Examplehttps://example.com/photos/jeans-1.jpg | Works whenThe link starts with http:// or https://. Dropbox and Google Drive share links work when anyone with the link can view the file. |
| A file name | ExampleIMG_1234.jpg | Works whenYou add the photo along with the sheet. The file extension is optional. |
| A folder | ExampleJeans 501/ | Works whenYou add the folder along with the sheet. Its photos are used in the order they were taken. |
| Blank | Example | Works whenYou add a folder named exactly like the item’s SKU. |
- Add photos when you upload the sheet: choose a folder, a ZIP file, or individual photos, or drag them in. JPG, PNG, WEBP, HEIC and AVIF all work.
- If two folders hold a photo with the same name, write the folder too, such as
Jeans 501/IMG_1234.jpg. - Keep Prismalist open until the photo uploads finish. If they stop, Resume photos lets you choose the same photos again and uploads only the missing ones.
Blank cells
When a cell is blank, Prismalist fills what it can from the item’s title and description:
- Category.
- Brand, when the title starts with it.
- Size and color, for clothing and shoes.
- Condition, from clear wording such as “NWT”, “like new” or “gently used”. A lone “new” or “used” isn’t enough.
- The eBay item specifics the category requires, such as Style or Material.
What you write in a cell is always kept as written. Blank ZIP codes and package sizes use your account defaults.
Review and import
- Prismalist checks every row first and shows how many are ready, how many to check, and how many won’t be imported.
- To check: rows with something to look at, such as a category to confirm, a value that wasn’t recognized, or a photo that wasn’t found. Fix them in the review, or import them and fix them later in the listing.
- Same item?: when a row looks like an item you already have, Prismalist asks. Same item leaves the row out; Different imports it. Rows with exactly the same SKU or title as an item you have are left out without asking.
- Choose Import when you’re ready. Items arrive as drafts, and nothing is published until you list it. View drafts shows the items from this import.
More questions? Contact support