Searching, saved searches and bulk actions
Find lots with filters, keep a search under a name, export it, and change many lots at once after you have seen what the change does.
When you have thousands of lots, you do not change them one by one. Search in Inventory, tick the lots you want, and change them together. BrickInvoice shows what the change does before anything happens.
Table of Contents
Search and filters
The search box looks at the item number, the name, the description and the location. Under More filters you can also narrow down on:
- the start of the item number (
300finds 3001, 3002 and so on) - the color
- the location, with
*for any text (A-*finds everything in rack A) - the quantity, from and to (a quantity of at most 0 shows the sold-out lots)
- the price, from and to
- lots whose price is locked
- Not sold in 6 or 12 months, for slow stock
Clear filters takes every filter off. To see the slowest stock first, sort the list on Last sold.
Sold-out lots are hidden unless you tick Show sold out next to the filters (see Overview). Export, selection and bulk actions follow what the list shows: without the tick, they leave sold-out lots out.
Everything you choose is in the address of the page, so you can bookmark a view or send it to a colleague.
Saved searches
When filters are active, Save search keeps them under a name, Show sold out included. Choose it from Saved searches to come back to the same view. You can keep up to 50 searches. Open a saved search and use the bin to remove it. A search you saved before sold-out lots were hidden opens without them. Tick Show sold out and save it again to keep them in.
Export to CSV
Export CSV downloads the lots of the current search, not only the page you see: item type, item number, name, BrickLink color number (colour_id), condition, location, quantity, price, state and whether the price is locked. A file holds at most 50,000 lots. If there are more, the file name says so.
Select lots
Tick the lots on the page, or the box in the table head for the whole page. When the whole page is ticked and more lots match your search, Select all matching lots reaches past the page. The selection is the search itself, so it holds exactly the lots you would see on every page. A selection can hold at most 5,000 lots. With more, narrow the search first.
Change many lots at once
With lots selected, choose an action and Continue:
- change the prices by a percentage, between -90 and +1000 (+10 raises every price by 10%)
- lock or unlock the price (this sends nothing to the stores)
- set the location (leave it empty to clear the location)
- put lots in a stockroom, or take them out
- set the sale percentage (it reaches the stores only when you sync the sale in Settings → Inventory)
- keep a lot on BrickLink when it sells out
- delete the lots
Check what this does shows the plan: how many lots change, how many are left alone and why (price locked, outside the sync, already as asked), and how many calls to BrickLink and Brick Owl it takes. Nothing has happened yet. When you confirm, BrickInvoice changes the lots in portions and shows how far it is. Stop halts it. What was done stays done. At the end it says how many lots changed, how many were left as they were and how many could not be changed.
If the lots changed between your check and your confirmation, BrickInvoice asks you to check again. A change of many lots, or of any deletion, asks for one more confirmation: this is the safety brake.
Reprice selection in the same bar starts a price round for the selected lots with your price rules.