Help Center

Importing inventory

Spreadsheet import guide

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.

ColumnWhat it holdsExample
TitleWhat 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
DescriptionWhat it holdsUp to 9,999 characters. HTML, as in eBay exports, is turned into plain text.Example
SKUWhat it holdsYour own item number. Also used to spot items you already have.ExampleBIN-A12
PriceWhat it holdsA number. $ signs and commas are fine.Example$45.00
Original priceWhat it holdsShown on Poshmark.Example120
CostWhat it holdsWhat you paid. Buyers never see it.Example8.50
QuantityWhat it holdsA whole number. Blank means 1.Example1
BrandWhat it holdsAs written. “None”, “Unbranded”, “N/A” or “Unknown” means no brand.ExampleLevi’s
CategoryWhat it holdsAn eBay category number, a category name or path, or blank. See Category.ExampleWomen > Accessories > Scarves
SizeWhat it holdsAs written.ExampleM, 10.5, W32 L30
ConditionWhat it holdsSee Condition.ExampleNWT
ColorWhat it holdsOne color, or two. See Color.ExampleNavy/White
Secondary colorWhat it holdsOne color.ExampleWhite
Style tagsWhat 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
WeightWhat 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 codeWhat it holdsThe ZIP code you ship from. Blank uses your account default.Example90210
Free shippingWhat it holdsYes or no.ExampleYes
NotesWhat it holdsPrivate notes, such as where the item is stored.ExampleShelf 3
PhotosWhat it holdsSee Photos.ExampleIMG_1234.jpg | IMG_1235.jpg
Status, Date soldWhat 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 Scarves or Women > 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

ConditionWords that work
New With TagsNew with tags, NWT, BNWT
New Without TagsNew without tags, NWOT, BNWOT, New other, Open box
New With Tags or New Without TagsNew, Brand new, NW (with tags when the title or description mentions tags)
Like NewLike new, EUC, Excellent, Mint, Nearly new
Used GoodGood, Very good, GUC, VGUC, Used, Pre-owned, Gently used
Used FairFair, 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 as Navy/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:

TypeExampleWorks when
A web linkExamplehttps://example.com/photos/jeans-1.jpgWorks 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 nameExampleIMG_1234.jpgWorks whenYou add the photo along with the sheet. The file extension is optional.
A folderExampleJeans 501/Works whenYou add the folder along with the sheet. Its photos are used in the order they were taken.
BlankExampleWorks 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