Use batch operations

Batch operations streamline large-scale creation, updating, and deletion of information in Manager. They can be used in certain tabs where control accounts contain subsidiary ledgers and bulk editing might be tedious. These tabs are also the ones most useful for migrating information from one business to another. Batch operations can be used for some Settings, too. Batch operations function for:

Batch operations are available whenever you see these three buttons in the bottom-right corner of the Manager window:

Batch Create

To add several elements at once, click Batch Create. Follow the instructions sequentially. First, copy the blank template from the template box and paste it into your spreadsheet program:

09 AM

The template contains only column titles. It tells you what information is required for the batch operation.

Illustrations in this Guide are for batch operations on inventory items, but procedures are the same wherever batch operations work. The blank template changes automatically.

Fill data into the empty spreadsheet template:

To understand each column, it may be helpful to first complete one entry of the type you are creating, completing all fields. Copy the resulting listing from the Batch Update window (see instructions below) and paste into a spreadsheet as an example. If columns are not understood, leave them blank. You can always edit them later.

Brilliant Industries enters information for some of its lighting products:

Then copy and paste the data from the spreadsheet back into Manager. Be sure to copy and paste the column headings in addition to the data.

Click Batch Create to enter the new items into Manager.

Brilliant Industries’ batch-created inventory items now appear in the Inventory Items tab:

Batch Update

Batch updates are somewhat simpler than batch creation, because the structure of the database is more obvious. Click on Batch Update. Again, follow the sequential instructions:

Brilliant Industries decides to raise prices on its LED products using the Batch Update function. It copies the Batch Update window and pastes the data into a blank spreadsheet:

Note that each line in the spreadsheet now has a unique Key.

Use the spreadsheet program to update data:

You can remove any rows you don’t need to update from the spreadsheet. Do not remove or modify any content in the Key column for rows you keep.

Brilliant Industries deletes the incandescent light bulb product, leaving only LED inventory items. It doubles their prices, using spreadsheet forumlae:

Copy and paste data from the spreadsheet back into Manager. Be sure to copy and paste column headings in addition to the data. Click Batch Update.

Brilliant Industries’ updated Inventory Items list shows increased sale prices on LED products. The 100W incandescent bulb’s listing has not changed:

You cannot add elements when using Batch Update, because a key is required for every row in the database. These keys are generated when new elements are added. To add elements in groups, use Batch Create.

Batch Delete

Batch Delete removes all entries in a tab that have no records associated with them. As with editing throughout Manager, the program will not allow you to delete anything that has already been referenced. Still, Batch Delete is a brute-force tool; it cannot be used to selectively remove entries.

When Batch Delete is clicked, Manager displays a list of all data that will be deleted, showing red strike-through lines to emphasize what will be removed. If you want to proceed, click the red button:

The Batch Delete operation cannot be reversed. Do not use it unless you are certain you want to permanently remove all data shown on the review screen. And always heed the caution to back up your data before any batch operations.



Subscribe to Updates

Subscribe to our newsletter and get exclusive product updates you won't find anywhere else straight to your inbox.

© 2017 - Based in Sydney, Australia but providing goodness globally