Visit the Givebacks Help Center

Articles in this section

See more

How-to: Add Multiple Auction Items to Your Experience at Once

Avatar
Melanie paul
  • Updated
Follow

Use MemberHub's Import Spreadsheet to add multiple Auction items at once instead of adding them one at a time.

If you’re creating an Auction in MemberHub and have many Auction items, you can save time and effort by downloading and completing a spreadsheet that will allow you to import all Auction items at once.

Import Your Auction Items

  1. Go to MemberHub Fundraisers and log in.
  2. Select Experiences from the left menu.
  3. If you have chosen a list view, click on the Experience title. If you have chosen a grid view, click on the Experience image.
  4. Select Edit Experience.
  5. Select Auction in the timeline at the top: import_auction_items_1.png
  6. Scroll down to Add auction items, and select Import multiple items: import_auction_items_2.png
  7. Download the provided spreadsheet and fill it out. import_auction_items_3.png Note that some columns are required. For more detailed instructions on how to fill out the spreadsheet, see the sections below.
  8. Upload the completed spreadsheet. If there are any errors, we’ll let you know so you can fix them: import_auction_items_4.png
  9. Once your spreadsheet is uploaded and error-free, click on Start Import.

  10. Fill Out the Spreadsheet

    Required Columns

    The following columns must be filled out before you can import your items. Note that the Category column is only required if you’re sorting your items into categories — if you aren’t, the Category column won’t appear on your spreadsheet and won’t need to be filled out.

    Title

    • What this is: The name of your item
    • Format: Words
    • Example: Handmade ceramic dish set

    Starting Bid

    • What this is: The amount of money you want the bidding to start at for that item
    • Format: Numbers, no symbols
    • Example: 200

    Bid Increment

    • What this is: The minimum amount someone needs to bid over the current top bid
    • Format: Numbers, no symbols
    • Example: 50

    Category (only appears if item categories are enabled)

    • What this is: The category your item will be grouped under (helpful if you have many Auction items so bidders can easily find the items they’re interested in)
    • Format: Words. If you’re adding items to an existing category, the category name should exactly match the category you created in setup. You can also use this column to create new categories.
    • Example: Homewares

    Optional Columns

    We suggest filling out the following columns to give donors more information about your Auction items and make your records more complete, but they aren’t required.

    Buy It Now Price

    • What this is: The amount of money someone can pay if they want to buy the item instead of bidding for it.
    • Format: Numbers, no symbols
    • Example: 1000
    • Learn more: Can I Add Buy It Now to My Auction Items?

    Image URL

    Item Description

    • What this is: A brief description of the item
    • Format: Words
    • Example: Unique and timeless twenty-piece dish set handmade by a local potter
    • What this is: A string of words that will be inserted at the end of the URL for this item, making it easier for you to share links to specific items with your bidders.
    • Format: Words, no spaces, although dashes (-) can be used in between words if needed
    • Example: handmade-dish-set

    Fair Market Value

    Number Available

    • What this is: The quantity of an item that is up for auction
    • Format: Numbers, no symbols
    • Example: 2

    Hide This Item from the Experience Page

    • What this is: A feature that lets you add an item to your item list but hide it from the Experience page in case you want to reveal a special item partway through the Auction to generate excitement
    • Format: Yes or No, not case sensitive
    • Example: No

    Item Donated By

    • What this is: The name of the person, company, organization, etc., who donated the item for auction
    • Format: Words
    • Example: John Smith

    Item Reference Number

    • What this is: A unique number that is assigned to an item so you can easily find the item in your records
    • Format: Numbers, letters, and dashes are all accepted
    • Example: 1-SKU99K34

    Good to Know

    Your template will include an example item row. You will want to delete this line from the spreadsheet before you upload your items. If the example item is accidentally uploaded, you can simply delete it.

Related articles