Importing auction items from a CSV file

With the Auctions app, you can add or update many auction items at once from a CSV file, rather than entering each one by hand. This is the fastest way to get a donated-item spreadsheet into an auction, and the same tool updates items you have already created.

To import items:

1. Open the Auctions Manager.
2. Click the title of the auction you want to import into.
3. Click the Items tab.
4. Click Import Items.
5. Under Import File, choose your CSV file.
6. Click Next.
7. Review the preview — see below.
8. Click Import.
9. Click Done.

Note: Nothing is written until you click Import. Clicking Next only shows you what would happen.

Preparing the file

The file must be a CSV saved as utf-8. Click Download sample import file on the import screen to get a working example with the correct headers.

Rules the file has to follow:

• The first row must be the column header row. Columns may be in any order, and you can leave out any column you do not need.
• Rows with a blank id create new items. Rows with an id update that item.
• Categories are matched by name, and created if they do not already exist.

Columns

Purpose	Columns
Identity	id, name, number
Type and grouping	type, category, featured
Pricing	starting_bid, bid_increment, buy_now_price, reserve_price, retail_price
Value shown to bidders	fair_market_value, fair_market_value_priceless
Descriptions	description_online, description_print, donated_by
Visibility	visibility, published
Shipping	requires_shipping, shipping_cost
Inventory	has_quantity_limit, quantity
Internal	fulfillment_details, internal_notes

Values are written the way you would say them, not in code:

• type — Silent, Live, or Fixed Price
• visibility — Public or Private
• featured, published, requires_shipping, has_quantity_limit, fair_market_value_priceless — Yes or No

Note: Photos cannot be imported. Add them on each item, or bring them across with Copying items from a previous Auction.

The preview

The preview lists one row per item with its Action, Number, Item, Category, Type, Visibility, Price, Increment and Status.

Read the Action column first — it tells you whether each row will create a new item or update an existing one. A row you expected to update but which shows as a create usually means its id is blank or wrong.

Rows with a problem are marked in the Status column and are the only rows held back. Everything else still imports, so you do not have to fix an entire file to make progress.

Changes that are blocked

Once an item has bids or purchases, the import will not let you change the things bidders have already acted on:

• The item's type
• Its prices — starting bid, bid increment and reserve price for bidding items; buy now price for fixed price items
• A decrease in quantity on an item that has been purchased. Increases are allowed, so you can restock.

A blocked row shows a message naming the activity and what it refused, for example: Item has 3 bid(s) — blocked change(s): starting bid. Edit the item directly to change these.

Two things make this less restrictive than it sounds. The check compares values, so re-importing an unchanged file never trips it. And everything else about the item — name, descriptions, donor, fair market value, retail price, notes, fulfillment details, featured, and quantity increases — stays editable no matter how much activity it has.

If you genuinely need to change a price on an item with bids, edit that item directly.

Updating items you already have

The reliable way to update in bulk is to export first, edit, then import the same file back:

1. Export the auction's items — see Exporting auction items to a CSV file.
2. Edit the values you want to change, leaving the id column untouched.
3. Import the file.

Because the export includes each item's id, every row matches an existing item and updates it rather than creating a duplicate.

Related articles:

• Exporting auction items to a CSV file
• Copying items from a previous Auction
• Managing Auction Items