MongoDB CRUD for Documents/Upsert a document

Insert the document if no match exists.

Section: Update and delete

Upsert a document

javascript
javascript
db.products.updateOne({ sku: "A103" }, { $set: { name: "Desk Lamp", price: 39 } }, { upsert: true })
Explanation

Upserts are handy for idempotent seed and sync scripts.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Update and delete
Update one document with $set
Modify selected fields without replacing the whole document.
OpenIn sheetjavascriptsame section
Update many documents
Apply one change to many matching documents.
OpenIn sheetjavascriptsame section
Replace one document
Swap the entire document body.
OpenIn sheetjavascriptsame section
Delete one document
Remove the first matching document.
OpenIn sheetjavascriptsame section
Delete many documents
Remove all matching documents.
OpenIn sheetjavascriptsame section
Insert one document
Create a single document.
OpenIn sheetjavascript1 tag match