CURRENT INFRASTRUCTURE:
-
Wix Database (Existing)
- Collection Name: Serialkey
- Collection ID: Import879
- Structure:
- Columns A, B, C: Serial numbers for 3 SOFTWARE
- Columns D, E, F: Usage status (customer email + purchase date)
-
Wix E-commerce Setup
-
Products Configuration:
- SKU: {SOFTWARE 1}
- SKU: {SOFTWARE 2}
- SKU: {SOFTWARE 3}
-
Triggered Emails:
- {SOFTWARE 1}: ID: UVWeg0X
- {SOFTWARE 2}: ID: UVWfDsM
- {SOFTWARE 3}: ID: UVWffUP
- Each email template contains placeholder: {SERIAL HERE}
-
Customer Member Area: Already configured
-
REQUIRED AUTOMATION WORKFLOW
:
- Trigger: Detection of completed order (order_paid status)
- Database Query: Locate unused serial key for purchased product
- Database Update: Mark serial as used (record customer email)
- Email Processing: Replace {SERIAL HERE} placeholder in corresponding triggered email
- Communication: Send email to customer
- Member Area Update: Copy email content to customer’s private page
ALTERNATIVE CONSIDERATION:
Instead of email-heavy communication, implement a structured member area with dedicated sections:
-
My Downloads
- Dynamic Google Drive links based on purchased software
-
My Serial Keys
- Display activated serial numbers from automation workflow
-
My Tutorials
- Installation guides
- YouTube tutorial links
- Product documentation
Technical Considerations:
- Email delivery optimization to avoid spam filtering
- Secure storage and transmission of license keys
- Integration between Wix database and member area
- Scalable architecture for additional products
Could you please:
- Confirm if this implementation is feasible
- Provide a cost estimate for the complete solution
- Suggest any technical improvements to the proposed workflow
Thanks for reading
Seb