Visiting "/bulk/ecommerce/": Throw an exception after Django Upgrade.

[asadiqbal08]

Steps to Reproduce

While testing the Django-3.2 Upgrade changes, We noticed a bug while visiting the ULR /ecommerce/bulk/ hit an endpoint /api/products and generate an exception.

more than one row returned by a subquery used as an expression

Need to look around the query pattern that is causing the issue.

Expected Behavior

No exception should be there while visiting the page.

Actual Behavior

An exception occurred as described above.

Stacktrace

web_1     |     return real_execute(self, sql, params)
web_1     |   File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 66, in execute
web_1     |     return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
web_1     |   File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
web_1     |     return executor(sql, params, many, context)
web_1     |   File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute
web_1     |     return self.cursor.execute(sql, params)
web_1     |   File "/usr/local/lib/python3.7/site-packages/django/db/utils.py", line 90, in __exit__
web_1     |     raise dj_exc_value.with_traceback(traceback) from exc_value
web_1     |   File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute
web_1     |     return self.cursor.execute(sql, params)
web_1     | django.db.utils.ProgrammingError: more than one row returned by a subquery used as an expression

[pdpinch]

@briangrossman are you still using this web UI? I think the answer is "yes" but it would be good to confirm.

When we fix this, please be sure to add an appropriate unit test.

[briangrossman]

@asadiqbal08 and @pdpinch
Yes. This is in use.
FYI: Individuals are able to make bulk purchases with a credit card. They receive enrollment codes that they can distribute to learners.