Skip to content

[FEATURE] Add Reciept Info to Database #29

@Malechus

Description

@Malechus

Description
Database should include Payment ID and Receipt number for each attendee. This information can be pulled from the Square API (POST /v2/orders/batch-retrieve) using the OrderID already captured at time of sale and written to the Attendee and Order tables. We need to add the columns to the table and then add a script that will update the data.

This can be accomplished by adding the adding the columns to the Order table, and linking the Order table to the Attendee table (preferable) or by adding the columns to the Attendee table.

Acceptance criteria

  • PaymentID column added to DB
  • Receipt Number column added to DB
  • Script added that be run using cron jon
  • Script selects records missing the above data and updates from Square API

Metadata

Metadata

Labels

enhancementNew feature or request

Projects

Status

In Progress

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions