Extension Store E-commerce Storefront Vended Solution

Agency:	Iowa State University
Level of Government:	State & Local
Category:	70 - General Purpose Information Technology Equipment (including software).
Opps ID:	NBD18079812941860716
Posted Date:	Nov 30, 2023
Due Date:
Solicitation No:	RFQ-1000782 Addendum 1

Bid Information

Type	Request for Proposal (Public)
Status	Awarded
Number	RFQ-1000782 Addendum 1 (Extension Store E-commerce Storefront Vended Solution)
Issue Date & Time	5/10/2023 01:00:02 PM (CT)
Close Date & Time	6/30/2023 01:00:00 PM (CT)
Duration	1 month 20 days
Notes	Iowa State University of Science and Technology (ISU) is soliciting information from qualified contractors to provide the goods and/or services described herein. Contractors should read all materials carefully and note the due date. Contractors must submit all questions in the "Questions" tab related to this bid opportunity. Bid responses will ONLY be accepted online via ISUBid. Please allow adequate time to review and submit your response prior to the deadline.

Contact Information

Name	Jake Miller
Address	1340 Administrative Services Building 2221 Wanda Daley Drive Ames, IA 50011-1004 USA
Phone	(515) 294-4701
Fax
Email	millerja@iastate.edu

Awarded Suppliers

Supplier Name

Award Line Count

Award Amount

Data pager

Page size:

PageSizeComboBox

select

Your browser does not support inline frames or is currently configured not to display inline frames.

1 items in 1 pages

Salesforce.org

Bid Documents

Document name

Format

Data pager

Page size:

PageSizeComboBox

select

Your browser does not support inline frames or is currently configured not to display inline frames.

3 items in 1 pages

Award Detail Spreadsheet

Excel 2007 / XLS

Bid Invitation

Acrobat / PDF

Public Question & Answer

Acrobat / PDF

Bid Attachments

File Name

Description

File Size

Data pager

Page size:

PageSizeComboBox

select

Your browser does not support inline frames or is currently configured not to display inline frames.

5 items in 1 pages

ISU Instructions.pdf

Review the instructions for important information. REVISED APRIL 2022

174 KB

ISU General Terms & Conditions.pdf

Review the general terms and conditions carefully and any exceptions should be listed in the "Attributes" section. REVISED APRIL 2022

232 KB

Insurance Language - Professional Services & Software Dev (Off Campus) 09-2021.pdf

Insurance Requirements - Professional Services & Software Dev (Off Campus) 09-2021

131 KB

hecvat304.xlsx

Higher Education Community Vendor Assessment Toolkit (HECVAT) Download, complete and attach under the "Response Attachments" tab with your proposal.

1.26 MB

Extension Store overview diagram.png (please login to view this document)

Overview diagram

107 KB

Bid Questions

Question	In the diagram shared, there appears to be an ETL already present. What is that ETL and what is the vision for that ETL moving forward?
Answer	We are currently using “Hangfire” as a “scheduled jobs handler” to send out communications, etc. We intend to maintain the use of “Hangfire” for various internal task notifications such as low-inventory alerts, age-based review of content for relevancy, and slow-moving products.
Submitted	6/26/2023 08:26:41 AM (CT)

Question	Who owns the inventory?
Answer	SU owns the inventory, or it is owned by various partner organizations. Warehouse for physical inventory is housed by the Extension Store. In some cases, inventory is produced once it is ordered.
Submitted	6/26/2023 08:25:47 AM (CT)

Question	What does marketing look like?
Answer	We currently send emails regarding order completion and shipping. We intend to implement the use of a CRM with true automated marketing, however. We have investigated tools for this. Segmented marketing will be important to our operations in years to come. This will allow us to target specific verticals and demonstrate impact in areas of industry and interest to our legislative representatives.
Submitted	6/26/2023 08:25:03 AM (CT)

Question	Is there an idea regarding the total number of integrations (Database/SSO/CSM)?
Answer	Please see diagram added under attachments, an exact number of integrations is not known. Integrations include: internal backend ERP (Dashboard), SSO for ISU Staff (Azure), TouchNet, Marketing Cloud/Email & scheduled task processor.
Submitted	6/26/2023 08:24:26 AM (CT)

Question	How is credit card payment handled?
Answer	Payment via credit card occurs through TouchNet, to Bank of America, and then is transferred to an ISU account. Check payments also accepted, with payment mailed to Extension Store.
Submitted	6/26/2023 08:23:57 AM (CT)

Question	Who handles physical inventory?
Answer	ISU handles this whether it is physical product or seats available in an online class.
Submitted	6/26/2023 08:23:29 AM (CT)

Question	Who is responsible for troubleshooting should a customer have an issue?
Answer	ISU will field these questions.
Submitted	6/26/2023 08:23:09 AM (CT)

Question	Do you know the percent of products vs. courses are being sold?
Answer	Courses being offered is relatively new, but large growth is very possible. Currently the majority of sales are educational products.
Submitted	6/26/2023 08:22:53 AM (CT)

Question	Are APIs available through the firewall, or will vendors connect directly to database?
Answer	See answer to previous API question. Vendor would provide a JSON output that would be read by our back-end database for things such as Customer and Order data. Our back-end database would provide a JSON output that would be read by the vendor software for things such as product data.
Submitted	6/26/2023 08:22:28 AM (CT)

Question	Who will be responsible for API development?
Answer	These will be developed by ISU as needed to ensure appropriate data can be shared.
Submitted	6/26/2023 08:20:50 AM (CT)