Skip to the content
Product lookup

Narrow a search

For
Staff, managers
Access
Products: Look up

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

  1. 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.
  2. 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.
  3. 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.
  4. 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.

FilterWhat you choose
OnlineIn BigCommerce (visible or hidden), Visible online, Hidden online, or Not online.
StockA condition on one store's stock, on the Total across stores, or on Web stock, such as Harbour < 5. Add up to five conditions.
ScheduleOne or more of the drug schedules. General is unscheduled and S2.
PromotionOn promotion (a running promotion at any store) or No promotion.
MoreHas 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.

Checked against the product on 13 November 2026.