Django ORM POC for SFMC Catalog - Githubissues

openedx / course-discovery

Service providing access to consolidated course and program metadata

https://edx-discovery.readthedocs.io/en/latest/

GNU Affero General Public License v3.0

57 stars 171 forks source link

Django ORM POC for SFMC Catalog #4409

Closed AfaqShuaib09 closed 3 weeks ago

AfaqShuaib09 commented 1 month ago

PROD-4137

This PR adds management command to populate the course-catalog for SFMC

Testing:

Testing Instructions:

Run the following command:


./manage.py populate_product_catalog --product_type={product_type} --output_csv={csv-file-name} --product_source={product_source} --use_gspread_client=True

Verify that the course data has been populated successfully.

To test the gspread integration:
- Create a service account with your Google account.
- Add the service account credentials to the private.py file.
- Create a new Google Sheet from your account and add the sheet ID to the PRODUCT_CATALOG_SHEET_ID variable in the private.py file.
- Run the command again to ensure the changes are reflected.