How to Bulk Import Items – How can we help?

Event.Gives makes it easy to bulk import items such as auction items, raffle tickets, and fixed price items! In this example, you will learn how to bulk import auction items. However, it is very simple to bulk upload the other item types using the steps below and the CSV templates provided.

Step One

In order to access the CSV templates, you will want to start on your 'Items' tab.
You will then scroll down and click the 'Bulk Actions' dropdown.
From this dropdown, you will click 'Import Items'.

Screenshot_2021-10-12_at_11.31.39_AM.png

Once you click 'Import Items', it will prompt you to choose which item type you want to bulk upload.
Below each item type is an 'Example CSV' to base your spreadsheet on. This can be used as a template, simply delete the entry on line two.
See 'Example CSV' for the 'Auction Item' below:

Screenshot_2021-10-12_at_12.06.52_PM.png

I have translated the above 'Example CVS' into an Excel spreadsheet below, with my example items, to show you what it will look like below:

*Please note: All columns that have a numerical value within the example (B, E, F, G, H) will also need a numerical value within your spreadsheet, even if that value is 0 (zero), in order for the upload to be successful. In addition, the retail cost is a required field and must be a whole number of 1 or larger. Character limits also apply to certain columns such as the 'Item Title'.

cost= 0 (will not add an Item Cost)

reserve= 0 (will not add a custom minimum bid amount therefore the default Event.Gives Item Reserve Logic will be used which is 30% of the retail value)

buy_price= 0 (will not add the Buy It Now option)

bid_increment= 0 (will not add a custom minimum bid amount therefore the default Event.Gives Bid Increment Logic will be used which is 8% of the retail value)

Screenshot_2021-10-12_at_2.05.34_PM.png

In order to upload this document to the platform, you will want to save it as a CSV, shown below:

Screenshot_2021-10-12_at_2.10.44_PM.png

Step Two

Once you have your CSV saved, you will be able to return to the platform to finish uploading your items. From here, you will select the item type for your associated CSV that you have created. For my example, I will be clicking the 'Auction Item' button

Screenshot_2021-10-12_at_11.39.42_AM.png

Next, you will drag and drop your CSV file into the grey box, shown below, or simply click the grey box to browse and select your CSV file from your computer.

Screenshot_2021-10-12_at_2.17.07_PM.png

Once you have uploaded your CSV, you will see the image below. You will want to make sure the columns you created match up with the drop-down boxes created by the platform. If they do not match, you are able to click the drop-down box and change the selection to match the associated column. For example, you would want 'value' to match 'Retail Value' and 'name' to match 'Item Name'.
After you have completed the above step, press 'Next'.

Screenshot_2021-10-12_at_2.19.37_PM.png

The next step gives you an opportunity to fix any errors you may see within the columns. If there are no errors, simply press 'Import'. My example is pictured below:

Screenshot_2021-10-12_at_2.31.17_PM.png

If errors do occur, it will appear similar to the image below:

*Please note: Orange indicates an error in the corresponding field

Screenshot_2021-10-14_at_10.03.31_AM.png

From here, you are able to click on any orange fields that indicate an error and a small bubble will pop up, explaining the error. For example, in the images below, you can see that my errors are my character limit as well as a missing value in a required field.

Screenshot_2021-10-14_at_10.21.07_AM.png

Screenshot_2021-10-14_at_10.21.22_AM.png

Once you fix your errors, your screen will appear as pictured below. You will then be able to click the blue 'Import' button in the bottom right-hand corner.

Screenshot_2021-10-14_at_10.24.25_AM.png

Congrats! All of your items have been uploaded! The final step will be to go through each item you have uploaded and add images. Each item can have up to nine images in total. Instructions for adding images can be found below.

Step Three

In order to upload item images, you will first click the pencil image in the upper right-hand corner of your image item.

*Please note: All images should be horizontal and you can upload up to 9, to display with your item. Images need to be in either JPG, PNG, or, GIF format and no larger than 4Mb. In addition, the ideal image size is 1125x450.

Screenshot_2021-10-12_at_2.49.51_PM.png

You can either drag images in the grey box or click the grey box, in order to browse your computer for images.

Screenshot_2021-10-12_at_2.56.33_PM.png

From here, you can click the circle with three dots on an image to remove it or make it the primary image. In addition, you can click the 'Advanced Crop' button to adjust how the image appears.

Bidr_Manager_-_Events_-_5060_-_Items.clipular__5_.png

Happy fundraising!

Related articles