Flow of payment reco

Open

Ongoing flow

1- Cron runs who took invoice events from pub sub topic.

Pub/Sub Topic ID - create_invoices

Topic Name - projects/payment-reco-prod/topics/create_invoices

Api- _ah/api/epr/v1/invoice-event (GET)

Pub/Sub Details = retention duration= 7 Days | Acknowledgement deadline=10 min | Delivery type= Push

Cron Details = batch Size= 500 | Time = every 7 minutes from 7 to 21 Hours

resource=shipment | eventSubType=packed | status_log=packed

2. This cron Pull event in 100 batch and process this and store it in invoiceItemDetails Table. But if any event miss by any chance we don’t have any automatic process for this.

3. If step 2 working fine then save event in epr is done automatically. but we should have a table for this. if any event miss then we know.

4. Next step is to process payout report and save it in cpr and then reconcile .

5. Algolia Sync runs in every 10 minutes on at_updated column from epr table.

What should we change in this Flow for better result :-

1. Retention duration should be 15-20 Days

2. We should have a cron who runs 12 AM at every night that can check all the missing event and save it in Database.(Manually Historic Sync needed)

3. We should have one cron who can fetch Unmatched id from invoice_item details table and Expected_payment_report table and save the missing orders in epr table.

4. Now for all payouts firtly check reference_id of all orders. whether its order_id + sku OR order_id + esin .

5. then check data in payouts report whether is esin or sku .

6. After all this save the data and in cpr table with correct format .(Need to discussed)

7. Reconcile cron run 2 times in a day. when any order reconcile set status success and add this order in new table with reconciled column. (Now reconciled every 3 hours with )

8. One cron run every night who pick unmatched id from cpr and new table and reconciled again.(Manually Historic Sync needed with date or transaction id )

9. algolia sync format change- right now algolia sync runs every 10 min with 10 min interval on updated at column. instead of this it should use one new table. and in this table have all the orders that are synced.

Phases for Devlopment :-

1. Create invoice

2. Save in Expected payment report

3. Payout saved in epr with all the required fees

4. Reconciled Process

5. Algolia Sync