Whatnot lets you create listings in bulk from a CSV file instead of one at a time. It saves hours before a big show, as long as the file matches Whatnot's template exactly.
Before you start
- Use a computer. CSV imports work on whatnot.com from a desktop or laptop. They are not in the app.
- Pick the right template. Whatnot has one for the United States, Australia and the Netherlands, and separate ones for Coins, the United Kingdom, Germany, France and Belgium, and Japan.
- Make a copy. Open the template in Google Sheets and copy it before you edit, so the Values tab stays intact.
The columns, one by one
| Column | What goes in it |
|---|---|
| Category | A category from the Values tab, written exactly as it appears there |
| Sub Category | A sub category from the Values tab, exactly as written |
| Title | The listing title |
| Description | The listing description |
| Quantity | How many you have |
| Type | The listing type from the Values tab, such as Auction or Buy It Now |
| Price | The price, or the starting bid for an auction |
| Shipping Profile | A profile from the Values tab, or the name of a custom profile you already made in Whatnot. Not a weight |
| Offerable | TRUE on a Buy It Now listing if buyers may send offers |
| Hazmat | For items such as batteries and liquids |
| Condition | A condition from the Values tab, where the category asks for one |
| Cost Per Item | What you paid, for your own records |
| SKU | Your own inventory code |
| Image URL 1 to Image URL 8 | Up to eight links to photos, one per column |
Five columns must match the Values tab exactly: Category, Sub Category, Type, Condition and Shipping Profile. Do not change their spelling, capitals or formatting. For a code to put in the SKU column, see a SKU system for resellers.
How photos work
A CSV cannot hold a picture, so each photo goes in as a link. Whatnot asks three things of every link: it starts with https://, anyone can open it, and it needs no password or sign-in. To test one, open it in a private browser window. If the photo loads, the link will work.
Photos are optional at import. A listing imported to your inventory needs at least one image before you can publish it, and you can add it while the listing is still a draft.
Two ways to upload
| Import to Inventory | Upload to a show | |
|---|---|---|
| What you get | Draft listings you can edit, publish and reuse | Temporary listings for that one show |
| Where | Seller Hub, Inventory, Import from CSV | Seller Hub, Shows, open the show, Add, Create Temporary Listing, Upload CSV |
| Use it for | Stock you will sell across shows or in your shop | Items for a single show |
When you are done filling the sheet, download it as a CSV and choose that file.
Mistakes that make an import fail
- A value that is close, not exact. A category typed from memory, or with a different capital letter, does not match the Values tab.
- A weight in Shipping Profile. The column takes a profile name, not a number of ounces or pounds.
- Private photo links. A link that needs you to be signed in will not load for Whatnot.
- Uploading the same file twice. Each import creates new drafts. To fix a mistake, edit the drafts, or delete them in bulk and upload the corrected file, so you do not end up with duplicates.
- Forgetting your other marketplaces. An item you run in a show can still sell on eBay in the middle of it. See how to sell the same inventory on eBay and Whatnot.
Whatnot uploads in Resale Champ
There are two ways to get stock onto Whatnot from Resale Champ. You can list to Whatnot directly from each item, with no file at all. Or you can export a Whatnot upload file: your titles, descriptions, quantities, prices, conditions, costs, SKUs and up to eight photo links, already in the columns of Whatnot's template. You add the category and shipping profile, and import it.
Either way, items for a show are held off your other marketplaces until it ends, and whatever did not sell goes back up. See cross-list to Whatnot, or compare tools in crosslisting apps compared for Whatnot.
Common questions
Can you bulk upload listings to Whatnot?
Yes. Whatnot imports listings from a CSV file, either into your inventory as drafts or into a show as temporary listings. It works on whatnot.com from a computer, not in the app.
Where is the Whatnot CSV template?
In Whatnot's help article on bulk importing products from a CSV file. There are separate templates by country and for Coins. Open the one for you in Google Sheets and make a copy before editing.
Are photos required in a Whatnot CSV?
No. You can import products without images. A listing in your inventory needs at least one image before you can publish it, which you can add while it is a draft.
Why are my Whatnot image URLs not working?
Each link must start with https://, be open to anyone, and need no password or sign-in. Open the link in a private browser window. If the photo loads there, it will work in the file.
Why does my Whatnot CSV import fail?
Most often because Category, Sub Category, Type, Condition or Shipping Profile does not match the template's Values tab exactly, including spelling and capital letters.
Can Resale Champ create the Whatnot upload file?
Yes. Resale Champ exports your items in the columns of Whatnot's template, with photo links, and it can also list to Whatnot directly without a file.