Giftiser
Let them go shopping themselves
1
Validation Check

System validates all required fields and data before proceeding

Required Fields:
  • Company Name
  • Username
  • Catch Phrase
  • Email
  • Phone Number
  • Address
  • Website
  • Currency
  • Logo (must not be default "nologo.png")
Working Hours:
  • At least 1 working day selected
  • Opening and closing hours must be set
Relational Data:
  • At least 1 Category assigned
  • At least 1 Brand assigned
  • At least 1 Age group assigned
  • At least 1 Gender assigned
❌ If Validation Fails:

Show error modal with list of missing requirements → Process STOPS

⬇
2
Duplicate Detection

System checks for existing sellers with matching data (only if validation passes)

Checked Fields:

Username Exact match (case-insensitive)
Email Exact match (case-insensitive)
Company Name Trimmed & case-insensitive
Address Trimmed & case-insensitive
Website Normalized (removes http://, www., trailing /)
Phone Normalized (only digits compared)
⚠️ If Duplicates Found:

Show warning modal with side-by-side comparison:

  • Current seller data vs. Existing seller data
  • Highlighted duplicate fields
  • Cancel Button → Stop publishing
  • Confirm & Publish Anyway Button → Override and proceed to Step 3
✅ No Duplicates Found:

Proceed automatically to Step 3

⬇
3
Publishing

System performs database updates to make seller live (only if no duplicates OR user confirmed)

Database Operations:

Table Action
eg_seller_categories Change status from pending → assigned, mark deleted as inactive
eg_seller_brands Change status from pending → assigned, mark deleted as inactive
eg_seller_ages Change status from pending → assigned, mark deleted as inactive
eg_seller_genders Change status from pending → assigned, mark deleted as inactive
eg_users_sellers53113 Update publish_status = 'Published', set publish_date = NOW()
✅ Success!

Show message: "Seller information found unique and complete. Published on Giftiser.com."

Page reloads after 2 seconds to reflect published status

🔑 Key Features

🛡️ Validation First

Never checks duplicates if basic requirements aren't met

🔍 Smart Detection

Normalizes data before comparison (e.g., "123-456-7890" matches "1234567890")

⏸️ Pending System

Changes only become live when published

🔓 Override Option

Admin can force publish even if duplicates exist

🔒 Transaction Safety

All changes happen together in one operation

📊 Transparency

Clear comparison shows exactly what's duplicate

📝 Notes for Admins

  • Pending Items: When sellers make changes (add/remove categories, brands, etc.), those changes are marked as "pending" and only become live after publishing
  • Deleted Items: Items marked for deletion are kept in database but set to inactive upon publishing
  • Re-Publishing: Already published sellers can be re-published after making changes. The same validation and duplicate checks apply
  • Duplicate Override: Use cautiously. Only confirm duplicates if you're certain they're legitimate separate businesses
  • Normalization: The system is smart about matching similar data (e.g., "www.example.com" and "example.com" are considered duplicates)

📅 Document Version: 1.0 | Last Updated: March 19, 2026

System: Giftiser.com Seller Publishing System