D2D Feed App – A Complete E-Commerce Application Built Using Oracle APEX

 

Project Overview

D2D Feed is a real-world e-commerce web application developed using Oracle APEX, designed to manage product ordering, cart handling, secure payments, and order tracking with barcode generation.

The application supports role-based access, Google social login, and Stripe payment integration, making it a complete end-to-end solution.

1. User Registration & Authentication

The application starts with a secure Sign Up and Login system.

  • Only permitted associations/users are allowed to sign up

  • Authentication methods:

    • Normal username & password

    • Google Social Sign-In

  • Two user roles:

    • Admin

    • User

This ensures controlled access and role-based functionality.




2. Home Page – Category-Based Navigation

After successful login, the user lands on the Home Page, which displays multiple product categories using a Classic Report with Card Layout.

 Available categories include:

  • Vegetables

  • Groceries

  • Fruits

  • Medicines

  • (and more…)

Each category card is clickable and visually designed for better user experience.




3. Product Listing & Purchase Flow

When a user clicks on a category:

  • All products under that category are displayed (again using card-based reports)

  • Each product shows:

    • Product name

    • Price

    • Action buttons

Available actions:

  1. Buy Now

    • Allows purchasing a single specific product immediately

  2. Add to Cart

    • Users can add multiple products

    • Products remain in the cart until checkout



4. Order Placement & Payment

  • Users can place an order for multiple products together

  • Integrated Stripe Payment Gateway for secure online payments

  • Only successful payments are processed further



5. Application Navigation

The app contains two main navigations:

  1. Home

    • Displays all categories

    • Used for browsing and shopping

  2. My Orders

    • Displays all successfully paid orders

    • Each ordered product includes a generated barcode

    • Useful for order tracking and verification




6. Barcode Generation

  • After a successful payment:

    • Each product in the order is assigned a barcode

  • Barcodes are displayed in My Orders

  • Helps with:

    • Product identification

    • Order verification

    • Future scanning use cases



7. Admin & User Roles

  1. User

  • Browse categories & products

  • Add to cart / Buy products

  • Make payments

  • View order history with barcodes

  2. Admin

  • Manages products and categories

  • Oversees orders and transactions

  • Ensures only permitted associations can register


8. Technologies Used

  • Oracle APEX

  • PL/SQL & SQL

  • HTML, CSS, JavaScript

  • Stripe Payment Gateway

  • Google OAuth Social Login

  • Classic Reports with Card UI

  • Barcode generation


8. Key Learnings

Through this project, I gained hands-on experience in:

  • Role-based authentication

  • Secure payment integration

  • Cart and order management

  • Session handling

  • UI/UX improvements in Oracle APEX

Comments

Post a Comment

Popular posts from this blog

Barcode and QR Code Generation in Oracle APEX

Image
  Introduction In modern applications, Barcodes and QR Codes are widely used to identify products, track inventory, enable quick access to information, and simplify scanning operations. Oracle APEX does not provide built-in barcode or QR generation components, but with the help of JavaScript libraries and Interactive Reports , we can implement this feature efficiently. In this blog, I explain how I implemented Barcode Generator and QR Code Generator in Oracle APEX 24.2 , how data is stored and fetched from database tables, and how barcodes and QR codes are rendered dynamically in reports. Why Barcode and QR Code Are Needed Unique identification of products Faster scanning compared to manual entry Reduced human errors Easy integration with scanners and mobile devices Useful for inventory, billing, logistics, and asset tracking   Flow Create a Form Page to enter product details Save product data into database tables Display data using Interactive...
Read more

Interactive Grid Customization in Oracle APEX

Image
Tweaking the Toolbar for Better Control and Usability Introduction: Oracle APEX Interactive Grid provides a rich, feature-packed interface for working with tabular data. While the default toolbar offers many capabilities, not all of them are required in every application. In real-world projects, simplifying the toolbar and adding targeted custom actions improves usability and keeps the interface aligned with business requirements. This blog explains two Interactive Grid toolbar customizations implemented in Oracle APEX 24.2. The first customization removes the Finder Drop Down from the toolbar. The second customization adds a custom button to the Interactive Grid search bar and links it to a JavaScript action. All changes were implemented using standard Oracle APEX features without plugins. Topic 1: Tweak the Toolbar – Remove “Finder Drop Down” The Finder Drop Down in the Interactive Grid toolbar allows users to search, filter, and apply conditions on the grid data. In controlled ...
Read more

Hybrid Wizard Application with UI Enhancements in Oracle APEX

Image
  Introduction: Customer onboarding is one of the most critical workflows in any enterprise application. A long or complex form often leads to poor user experience, incomplete submissions, and data inconsistency. To address this, I designed and implemented a Hybrid Wizard–based Customer Onboarding Application using Oracle APEX , combining guided wizard navigation with flexible UI components such as popups, dynamic actions, and reusable lists. The goal of this application was to provide a smooth, step-by-step onboarding experience while maintaining visual clarity and ease of interaction for end users. Why a Hybrid Wizard Approach Traditional wizard pages strictly follow a linear, multi-page flow, while modern UI patterns demand flexibility such as popups, dynamic menus, and contextual forms. Instead of using a fully rigid wizard, I implemented a hybrid wizard model where structured steps guide the user, but individual steps can leverage custom pages, popup dialogs, and dynami...
Read more