🚀 Salesforce Bulk Update with Generated UUID CLI

> A powerful and beautiful command-line tool for bulk updating Salesforce records with generated uuid with interactive HTML reports.

!Node
!License

✨ Features

- 📊 Beautiful HTML Reports with dark/light theme
- 🔍 Interactive DataTable with sorting, search, and pagination
- 📥 CSV Export functionality
- 🆔 Auto UUID Generation for external IDs
- 🎨 Colorful CLI Output with step-by-step progress
- ⚡ Salesforce CLI Integration using sf commands
- 📈 Real-time Statistics (processed, failed, total records)
- 🌐 Auto-opens Report in your default browser

Screenshot

!Example-1

Using this in Integration Workflow Editor

!Example-Workflow Editor

📋 Prerequisites

- Node.js 16.x or higher
- Salesforce CLI (sf) installed and authenticated
- Active Salesforce org connection
- Make sure to have required ExternalId field (example: External_Id__c) in the SObject
!Example- ExternalId

$3

``bash
npm install -g @salesforce/cli
`

$3

`bash
sf org login web -a myorg
`

🔧 Installation

$3

`bash
npm install -g sf-bulk-upsert-uuid
`




📖 Usage

$3

`bash
sf-uuid-filler -o -s -q [options]
`

$3

| Option | Description | Example |
|--------|-------------|---------|
| -o, --org | Salesforce org username or alias | myorg@example.com |
| -s, --sobject | SObject API name | Account, Contact |
| -q, --query | SOQL query to fetch records | "SELECT Id, Name FROM Account" |

$3

| Option | Description | Default |
|--------|-------------|---------|
| -e, --external-id | External ID field name | Auto-generates UUID |
| -w, --wait | Wait time for bulk job completion | 10 |
| -f, --file | Use existing CSV file instead of query | - |

💡 Examples

$3

`bash
sf-uuid-filler \
-o myorg@example.com \
-e External_Id__c
-s Account \
-q "SELECT Id, Name, Industry, AnnualRevenue FROM Account WHERE Industry = 'Technology' LIMIT 100"
`

🎨 HTML Report Features

The generated HTML report includes:

$3

- Total Records: Number of records processed
- Processed: Successfully updated records
- Failed: Records that failed to update
- SObject: Target object name

$3

- Job ID
- Org Username
- Instance URL
- API Version
- SOQL Query (if used)

$3

- Sorting: Click column headers to sort
- Search: Global search across all columns
- Pagination: 10, 25, 50, 100, or All records per page
- Export: Download data as CSV

🔄 Workflow

1. Authenticate: Connects to Salesforce org using provided username
2. Query: Executes SOQL query to fetch records (or uses CSV file)
3. Process: Adds external ID (UUID if not specified)
4. Generate CSV: Creates temporary CSV file with records
5. Bulk Update: Executes Salesforce bulk API operation
6. Report: Generates beautiful HTML report
7. Open: Auto-opens report in default browser

🛠️ Advanced Configuration

$3

The CLI provides detailed error messages:
- ❌ Org authentication failures
- ❌ SOQL query errors
- ❌ Bulk API errors
- ❌ File I/O errors

📊 Sample Output

`
sf-uuid-filler -o ea10 -s Product2 -q "SELECT Id, Name, External_Id__c FROM Product2" -e External_Id__c

╔════════════════════════════════════════════════════════════╗
║ Salesforce Bulk Update Tool v1.0.0 ║
╚════════════════════════════════════════════════════════════╝

[1/5] Fetching Salesforce org information...
Executing: Getting org details
› Warning: @salesforce/cli update available from 2.113.6 to 2.114.5.
✓ Connected to: https://dhs000000qasyma4-dev-ed.develop.my.salesforce.com
✓ API Version: 65.0

[2/5] Querying Salesforce records...
Executing: Executing SOQL query
✓ Retrieved 190 records

[3/5] Processing records...

✓ CSV file created: /private/tmp/bulk-update-2025-12-11T12-23-39-848Z.csv

[4/5] Executing bulk update...
Executing bulk update command: sf data update bulk -f "/private/tmp/bulk-update-2025-12-11T12-23-39-848Z.csv" -s Product2 -w 10 -o ea10 --json
Starting bulk job...
Executing: Bulk update operation
› Warning: @salesforce/cli update available from 2.113.6 to 2.114.5.
✓ Bulk update completed successfully
Job ID: 750Hs000018XUmfIAG
Records Processed: 190
Successful Records: 190
Records Failed: 0

[5/5] Generating HTML report...
✓ Report generated: /private/tmp/bulk-update-report-2025-12-11T12-23-47-209Z.html

╔════════════════════════════════════════════════════════════╗
║ Operation Completed! ║
╚════════════════════════════════════════════════════════════╝

`

🐛 Troubleshooting

$3


Solution: Install Salesforce CLI
`bash
npm install -g @salesforce/cli
`

$3

Solution: Login to your org
`bash
sf org login web -a myorg
`

$3

Solution: Reduce record count or increase wait time

This project is licensed under the MIT License.

👤 Author

- Mohan Chinnappan

🙏 Acknowledgments

- Salesforce CLI team for the amazing sf` command
- Commander.js for CLI framework
- DataTables for interactive tables
- Tailwind CSS for beautiful styling

🔮 Future Enhancements

- [ ] Support for bulk delete operations
- [ ] Real-time progress tracking
- [ ] Email notifications on completion
- [ ] Retry failed records
- [ ] Schedule bulk operations
- [ ] Multi-org support in single run
- [ ] Custom field mapping
- [ ] Dry-run mode

---

Made with ❤️ for the Salesforce community