Narrow a search
- For
- Counter and shop staff, Store managersStaff, managers
- Access
- Products: Look up
On this page
Use filters to list the products that answer a question, such as everything on promotion or every controlled drug in stock.
List products by what they are
- Open Products. Before you search, Quick views offers ready-made questions: Online, out of stock, Hidden online, in stock, On promotion, Overridden online and Controlled drugs. Select one to run it.
- Or choose your own filters from the row under the box. A filter applies as soon as you choose it, and a filter you set shows its value in teal. Select its x to take it off, or Clear filters to take them all off.
- To search by name as well, type it in Barcode or name. Filters and the name both apply. With a filter set you can leave the name empty.
- To change the order, choose from the sort menu at the end of the row. It shows the order in use, Best match to begin with.
Every filter has to hold at once. Choices inside one filter are alternatives: two schedules means either.
| Filter | What you choose |
|---|---|
| Online | In BigCommerce (visible or hidden), Visible online, Hidden online, or Not online. |
| Stock | A condition on one store's stock, on the Total across stores, or on Web stock, such as Harbour < 5. Add up to five conditions. |
| Schedule | One or more of the drug schedules. General is unscheduled and S2. |
| Promotion | On promotion (a running promotion at any store) or No promotion. |
| More | Has an override or No override, and whether to hide products deleted in Minfos or show only those. |
The sort menu orders by stock (all stores, or one store's), name, price, cost or margin, and lets you flip the direction. Without a sort, the closest names come first, then the most stock. Cost and margin use the main store's cost.
What happens next
The list says how many products matched. Select any to open it. With Products → Export products access, a link above the list ("Export all 12 as CSV") saves every match as a CSV file.
If something goes wrong
The Online and Web stock filters aren't available
Mortar is still reading the web store's product list, which takes a few minutes after it starts, or has no connection to the web store. Search without those filters in the meantime.
No products match
Try fewer filters. Mortar names the filters it applied in the message.
No more products match
You are on a page past the last one. Select Back to the first page.