Importing from Salesforce
Bring customers, stores, hotels, applicants, workers, programs, shifts, texts and documents in from Salesforce CSV exports, without duplicates.
If you ran your staffing business in Salesforce, you can bring your records into Operations from CSV exports. Open Configuration → VMS setup → Salesforce import.
What you can import
Import in this order, so later records can find the ones they belong to:
- Customers (Salesforce Accounts)
- Stores
- Hotels
- Applicants
- Resources (your workers)
- Programs, with their weekly projects
- Projects
- Shifts
- Resource requests
- Text history, dashboard messages and documents
Import a file
- Pick one kind of record per file.
- Choose Choose CSV file and upload an export from a Salesforce report or Data Loader, up to 10 MB and 20,000 rows. Include the record Id column.
- Check the column mapping. Columns are matched to Salesforce's usual names, and you see the values from the first row.
- Choose Preview. Nothing is saved yet.
- Choose Import.
Results
Each row shows one of these:
| Result | Meaning |
|---|---|
| New | A new record was created |
| Update | An existing record was updated |
| Matched | An existing record was found and linked to the Salesforce Id |
| No change | Nothing to update |
| Skipped | The same Id appears twice in the file |
| Error | Not imported, with the reason |
Turn on Show problems only to see what to fix. Past imports keeps the counts and problem rows for each run.
No duplicates
Every row's Salesforce Id is remembered. Importing the same export again updates the records instead of creating new ones. The first time, records are matched to what you already have: customers by name, stores by banner and store number, hotels by name and city, applicants by email, and workers by payroll ID, then email.
Blank cells never clear values you already have. States can be names or codes, money can be written like $17.50, and dates like 3/9/2025.
Good to know
- Applicants become candidates and are added to the job with a matching title, with their status mapped. No emails or invites are sent.
- Shifts dated before today are skipped, so history stays in Salesforce and only upcoming work comes over. Times are read in the store's time zone.
- Text history is added to each person's inbox conversation. Nothing is texted. A STOP in the history opts the person out.
- Dashboard messages become announcements to the reps they targeted.
- Documents are saved on the person's profile.
