[Skip to content](#main)

[→](/)

[![Avunu](/brand/avunu-logo.svg)![Avunu](/brand/avunu-logo-light.svg)](/)[Services](/services/)[Consulting](/services/consulting/)[ERP](/services/erp/)[Odoo](/services/erp/odoo/)[ERPNext](/services/erp/erpnext/)[Custom software](/services/custom-software/)[Devices & IoT](/services/devices-iot/)[Websites](/services/websites/)[Infrastructure](/services/infrastructure/)[Partners](/partners/)

[Work](/work/)[Open source](/open-source/)[Knowledge base](/kb/)[About](/about/)

[About Avunu](/about/)[Team](/about/team/)[Insights](/insights/)[Contact](/contact/)

[Client portal](https://erp.avunu.net/projects)[Start a project](/start/)

- [Services](/services/)[Consulting](/services/consulting/)
- [ERP](/services/erp/)
- [Odoo](/services/erp/odoo/)
- [ERPNext](/services/erp/erpnext/)
- [Custom software](/services/custom-software/)
- [Devices & IoT](/services/devices-iot/)
- [Websites](/services/websites/)
- [Infrastructure](/services/infrastructure/)
- [Partners](/partners/)

[Work](/work/)[Open source](/open-source/)[Knowledge base](/kb/)[About](/about/)

- [About Avunu](/about/)
- [Team](/about/team/)
- [Insights](/insights/)
- [Contact](/contact/)

[Client portal](https://erp.avunu.net/projects)[Start a project](/start/)

Data Steward

Audited data corrections for Frappe and ERPNext admins, including bulk merge, item-to-variant conversion, and bank clearance fixes, each gated behind a setting.

[Open source](/open-source/)

Data Steward

Frappe & ERPNext
Stable
MIT

[View on GitHub (opens in a new tab)](https://github.com/Avunu/data_steward)[Documentation (opens in a new tab)](https://docs.avunu.net/data-steward/)

PlatformFrappe & ERPNext

LicenseMIT

StatusStable&#xA;

Repository[Avunu/data_steward](https://github.com/Avunu/data_steward)

Part of

Used in[Textile & home-decor printing](/work/textile-print-shop/)
,&#x20;
[Timber-frame structures manufacturing](/work/timber-frame-manufacturer/)
,&#x20;
[Professional services](/work/avunu-erp/)

Frappe protects your data by making some operations hard on purpose. Sometimes an administrator really does need to merge a pile of duplicate customers, turn an existing item into a variant, or fix a bank clearance date that reconciliation got wrong. Data Steward adds those tools for experienced admins cleaning up real-world data. Each one is switched off until you turn it on, and every correction is recorded on the document it changed.

## Features

**Bulk merge.**
&#x20;Select two or more records in any list view and merge them with "Merge Selected." System Manager only.

**Item to variant.**
&#x20;Convert an existing Item into a variant of a template item by choosing its attribute values.

**Clearance date corrections.**
&#x20;Set a Payment Entry's clearance date, or manually clear a Journal Entry against its matching Bank Transaction and remove that clearance again.

**Full-width interface.**
&#x20;The desk uses the full screen width, unless you have already chosen a container width.

**Safety gates.**
&#x20;Each tool is enabled separately in Data Steward Settings and checked again on the server. Each also needs a role and your write permission on the document, and adds a comment to it.

## Getting started

Install it with bench, then open&#x20;
**Data Steward Settings**
&#x20;and enable only what you need. Test on a copy of your site first. Data Steward replaces the earlier&#x20;
`jailbreak`
&#x20;app: install it, then uninstall&#x20;
`jailbreak`
, and it copies over the settings you had. The&#x20;
[README](https://github.com/Avunu/data_steward#coming-from-jailbreak)
&#x20;explains the move.

```
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">bench</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">get-app</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">https://github.com/Avunu/data_steward.git</span>
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">bench</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">install-app</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">data_steward</span>
```

Highlights

Merge duplicate records across any DocType from the list viewConvert existing items into variants of a templateSet or remove clearance dates on Payment Entries and Journal EntriesEvery tool is off until an admin enables it, and each needs a roleEach change leaves a comment on the document it touched

Related projects

[All open-source projects](/open-source/)

[ERPNext TaskView](/open-source/erpnext_taskview/)

Active&#xA;

A project and task workspace for ERPNext, with timers and hour budgets for staff and a portal where customers follow and work on their projects.

MIT[GitHub](https://github.com/Avunu/erpnext_taskview)

[ERPNext CIS Plus](/open-source/erpnext_cis_plus/)

Stable&#xA;

Simpler customer, contact, and address management for ERPNext, with address validation, geolocation, and a map of your customers.

MIT[GitHub](https://github.com/Avunu/erpnext_cis_plus)

[Automated Subscriptions](/open-source/automated_subscriptions/)

Active&#xA;

Automatic billing for ERPNext Subscriptions, with payment requests, billing anchors, proration, consolidated invoices, and credit notes.

MIT[GitHub](https://github.com/Avunu/automated_subscriptions)

Need help with it?

Need a large cleanup done safely? Our ERPNext implementation team does data cleanup and migrations.

[Explore ERPNext implementation](/services/erp/erpnext/)[Start a project](/start/)

Services

- [ERP implementation](/services/erp/)
- [Odoo](/services/erp/odoo/)
- [ERPNext](/services/erp/erpnext/)
- [Custom software](/services/custom-software/)
- [Devices & IoT](/services/devices-iot/)
- [Websites](/services/websites/)
- [Infrastructure](/services/infrastructure/)

Resources

- [Our work](/work/)
- [Open source](/open-source/)
- [Knowledge base](/kb/)
- [Insights](/insights/)

Company

- [About](/about/)
- [Team](/about/team/)
- [Partners](/partners/)
- [Contact](/contact/)

Clients

- [Project portal](https://erp.avunu.net/projects)
- [Invoices](https://erp.avunu.net/)
- [Support](https://erp.avunu.net/)

[![Avunu](/brand/avunu-logo-light.svg)](/)[\<av-icon data-jx-static>\<svg viewBox="0 0 24 24" width="20" height="20" fill="currentColor" stroke="none" stroke-width="1.6" stroke-linecap="round" stroke-linejoin="round" aria-hidden="true" focusable="false">\<path d="M20.400 20.500h-3.600v-5.600c0-1.300 0-3-1.800-3s-2.100 1.400-2.100 2.900v5.700H9.400V9h3.400v1.600c.5-.9 1.600-1.900 3.400-1.900 3.600 0 4.300 2.400 4.300 5.500v6.300zM5.300 7.400a2.100 2.100 0 1 1 0-4.100 2.100 2.100 0 0 1 0 4.100zm1.800 13.100H3.600V9h3.500v11.500zM22.200 0H1.800C.8 0 0 .8 0 1.700v20.600c0 .9.800 1.700 1.800 1.700h20.400c1 0 1.800-.8 1.800-1.700V1.700C24 .8 23.200 0 22.200 0z">\</path>\</svg>\</av-icon>](https://www.linkedin.com/company/avunu)[\<av-icon data-jx-static>\<svg viewBox="0 0 24 24" width="20" height="20" fill="currentColor" stroke="none" stroke-width="1.6" stroke-linecap="round" stroke-linejoin="round" aria-hidden="true" focusable="false">\<path d="M12 .3a12 12 0 0 0-3.8 23.4c.6.1.8-.3.8-.6v-2c-3.3.7-4-1.6-4-1.6-.6-1.4-1.4-1.8-1.4-1.8-1-.7.1-.7.1-.7 1.2.1 1.8 1.2 1.8 1.2 1 1.8 2.8 1.3 3.5 1 .1-.8.4-1.3.7-1.6-2.7-.3-5.5-1.3-5.5-5.9 0-1.3.5-2.4 1.2-3.2-.1-.3-.5-1.5.1-3.2 0 0 1-.3 3.3 1.2a11.500 11.500 0 0 1 6 0c2.300-1.500 3.300-1.200 3.300-1.200.6 1.700.2 2.900.1 3.200.8.8 1.200 1.900 1.200 3.200 0 4.600-2.800 5.600-5.500 5.900.4.400.8 1.100.8 2.200v3.300c0 .3.2.7.8.6A12 12 0 0 0 12 .3">\</path>\</svg>\</av-icon>](https://github.com/Avunu)[Client portal](https://erp.avunu.net/projects)[Start a project](/start/)

Avunu LLC · 948 East Philadelphia Street, York, PA 17403 · (717) 814-8540Knowledge base articles are in the public domain[Privacy](/privacy/)[Terms](/terms/)
