RS.GE customs declarations

Every parcel over the duty-free limit needs a customs declaration on RS.GE, and the declarations team tracked them on ClickUp boards by hand. For each task they checked whether duty was paid and a declaration issued, then downloaded the PDF and sent it to the customer to sign. RS.GE has no public API for this, its parcel lists are split per company account and its sessions break easily, so checking was slow and tasks ended up in the wrong status.

A session manager and four category fetchers (physical, online, unknown, export) page through the portal’s data into Postgres. Detail scanners add each parcel’s personal and goods data, and a track-lookup API returns a parcel’s status, goods and declaration PDF by tracking number. A pagination fix lifted the daily fetches from a hard 500-row cap to complete days (878 of 878 and 3,376 of 3,376 rows in tests). Node.js scripts check signed tasks against RS.GE and export held parcels with their invoices to Google Drive for HS-code work.

For each brand, two symmetric workflows run every 30 minutes on staggered schedules. Yellow Check moves a task to 'duty paid' once every parcel in it is released. Green Check confirms, parcel by parcel against the printed form, that the declaration covers them all, uploads the PDF to ClickUp, checks that the upload landed and moves the task to signing, which sends a Documenso envelope, an email and an SMS with de-duplication. Held parcels move to a red status, unknown tracks get a one-time warning comment, and every workflow reports to a shared error workflow.