About / Blog

Mass updating Document Statuses using QuoteWerks Medic Utility

We’ve had several enquiries over the years from QuoteWerks users wanting to update old Quote documents en-masse to archive them off with a “Closed” Status.

The QuoteWerks Medic Utility offers several pre-defined mass update options, but there’s no specific update to change a Document Status, so you’ll need to use the ‘Advanced Queries’ option within the QuoteWerks Medic Utility Database Manager screen.

The exact syntax for the query will depend on both the edition of QuoteWerks (Standard, Professional or Corporate) and exactly what you want to do, but as an example:

With Corporate re-hosted to SQL, the query will look something like:

UPDATE DocumentHeaders
SET DocStatus = ‘Closed’
WHERE (DocDate < ‘2011-01-01’)
AND (DocType = ‘QUOTE’)
AND (DocStatus <> ‘Lost’)
AND (DocStatus <> ‘Won’)
AND (DocStatus <> ‘Another Status Not To Be Changed’)

For Standard, Professional or Corporate not re-hosted to SQL, try:

UPDATE DocumentHeaders
SET DocStatus = DocStatus
WHERE (DocDate < #2011-01-01#)
AND (DocType = “QUOTE”)
AND (DocStatus <> “Lost”)
AND (DocStatus <> “Won”)
AND (DocStatus <> “Another Status Not To Be Changed”)

PLEASE NOTE that you should backup your QuoteWerks Document database BEFORE running any of these example queries! By their nature these queries may update many Dcouments in your database and the changes cannot be undone without restoring the database from a backup.

We hope that you find this tip useful. If there are other scenarios that you’d like to explore or tips for updating QuoteWerks Documents, then please comment below and one of the team will be pleased to help you out.

Thanks,

The Hilltops IT QuoteWerks Support Team

Related Stories

See all

Alternative ways to provide a software support service

Oct 10, 2024

Following on from the blog post I wrote about providing a successful software support service, and as part of the same discussion, we also brainstormed some alternative ways to provide software support to our customers. What do you think…? Do you think any of these could work better than the techniques we currently employ!? Personally […]

READ MORE

Providing a successful software support service… our thoughts

Oct 10, 2024

During a recent discussion about customer service desk techniques, we shared our experiences with various service providers like banks, phone companies, and dental offices. We talked about the pros and cons, good experiences, and less satisfying ones. This led us to brainstorm ways to improve our own service desk. I’m pleased to say that we […]

READ MORE

Copying the QuoteWerks QuoteValet URL to the Windows clipboard

Jan 31, 2019

The script below provides a way to quickly and easily copy the QuoteValet document URL for the current open document in QuoteWerks to the Windows clipboard. This can then be pasted into an email or other document to send to your customer. To implement the script, we suggest copy/pasting the below code into a text […]

READ MORE