Ram Digital Store

About Ram Digital Store

Ram Digital Store is a digital product store with a catalogue, cart, guest purchases, QRIS payments, fulfilment, invoices, and an admin dashboard. It distinguishes account product purchases from user account upgrade services and connects stock with payment status.

I developed the frontend, backend, database, payment integrations, digital delivery, and tests. The technical focus includes consistent stock reservations and handling transaction status changes.

My contributions

Catalogue, cart, and guest checkout

I built catalogue, category, and product detail pages, quantity selection, and multi-item carts. I implemented guest checkout and token-based order pages so buyers can follow their purchases. Cart items connect to a parent order to unify payment status and order outputs.

Product management and admin operations

I developed product, category, stock, order, and promotional popup management. I added CSV/XLSX imports, stock exports, and server-side order search. Dashboard chart loading is deferred so those components do not add to the admin page’s initial load.

Stock reservations and order expiry

I worked on available/sold stock calculations, checkout reservations, and reservation release when payment is not completed. I also separated fulfilment paths for account products and user account upgrades. Import validation helps keep stock data consistent with the processes that consume it.

QRIS integration and webhook verification

I connected payment providers, including the KlikQRIS integration, to order invoices. I checked callbacks/webhooks and confirmed status with the provider before updating orders. This connects external payment information with product access in the application.

Payment reconciliation and recovery

I handled late callbacks, transactions not yet found, and payments confirmed after local order expiry. I added reconciliation and admin recovery to handle timing differences between polling, callbacks, and expiry jobs against the relevant order status.

Digital delivery, invoices, and email

I connected valid payments to fulfilment, detail disclosure, invoices, and email delivery through Brevo. I improved invoice resending from cart parent orders, email retries, and admin delivery controls. Product detail availability follows the application’s access duration resolver.

Database and admin access control

I migrated runtime storage to PostgreSQL and removed the previous Supabase runtime dependency. I worked on admin authentication, same-origin mutation protection, Turnstile validation, and payment checks. I also connected object storage, image processing, and spreadsheets to store operations.

Transaction scenario testing

I wrote Vitest tests for payment verification, race conditions, expiry, recovery, and access duration resolution. These scenarios check relationships between orders, stock, and provider status when processes arrive at different times, including multi-item carts and fulfilment linked to parent orders.