Upload Events in Bulk in Shift4 Venue

Description: Learn to upload and modify events in bulk using a CSV file in Shift4 Venue. This process is recommended for organizations with large seasonal schedules, such as MLB and NBA teams.

Upload Events in Bulk

1. Open the CSV template, or use the one provided to you. Note that the template contains sample data that must be removed or overwritten before use.
2. Select File > Download > Comma Separated Values (.csv) to download the file.
3. Enter the events to upload. Refer to the Formatting Requirements section below.
4. Add any required custom fields as the rightmost columns in the spreadsheet.
5. In Shift4 Venue, navigate to Events > Events.
6. Select Upload Events.
   Note: Do not select Import Events. These are separate functions.
7. Select Choose File, then select the CSV file.
8. After the success message displays, refresh the Events page to view the uploaded events.

Warning: The upload tool does not display errors for invalid formats or data. Verify the following fields before uploading: date and time fields, home and away color values, and image URLs. If the upload fails, no events are created and the following message displays: "UNDEFINED EVENTS SUCCESSFULLY IMPORTED. PLEASE RELOAD YOUR PAGE TO VIEW THESE EVENTS."

Formatting Requirements

All columns must be filled in before uploading. Follow the requirements below for each field type.

Dates and Times

• Dates must follow YYYY-MM-DD format (for example, 2017-10-15).
• Times must follow HH:MM AM/PM format (for example, 07:00 AM).

Time Zones

Select one of the following time zone values:

• UTC
• Eastern Time (US & Canada)
• Pacific Time (US & Canada)
• Mountain Time (US & Canada)
• Central Time (US & Canada)
• Hawaii
• Alaska
• Arizona
• Central America
• Mexico City
• Indiana (East)
• Atlantic Time (Canada)
• Mid-Atlantic

Image URLs

1. Import the image into the Shift4 Venue Media Manager, or identify an image already imported.
   • Access the Media Manager by adding /media_manager to the end of the Shift4 Venue base URL. For example: https://vikings-production-canopy.venuenext.net/media_manager
2. After the image is available in the Media Manager, build the image URL.
   • Start with the base URL and replace the organization or team name. For example: http://ui-config-layout.venuenext.net/vikings/
   • Append /production and the image filename. For example: /production/vikings.webp
   • Full example: http://ui-config-layout.venuenext.net/vikings/production/vikings.webp

Custom Fields

The following custom fields are commonly used when uploading events. Add these as the rightmost columns in the CSV file.

• display_date — Controls how the date displays in the app. Allows custom formatting (for example, Mon, Jan 3rd).
• marketplace — Enter true to include the event in the marketplace, or false to exclude it.
• marketplace_display_name — Sets the event name as it appears in the marketplace.
• swiper — Enter true to add the event image to the carousel.

Note: Events marked swiper = true are added to the carousel image pool. The carousel displays a set number of images at a time. Events are automatically removed from the carousel after their event date passes, and the next event in line is added automatically.

Modify Events in Bulk

1. On the Events page in Shift4 Venue, select Download Events to export the current events to a CSV file.
2. In the CSV file, update the values that need to change.
   • Important: Do not modify or delete the event_uuid column. Removing or changing this value causes the update to fail.
   • Delete any columns that are not being changed.
   • Follow the same formatting requirements described in the Formatting Requirements section above.
3. Return to the Events page in Shift4 Venue and select Bulk Update Events.
4. Upload the modified CSV file.