|
You can search on Description, Category and/or Article code. You can, alternatively (but not recommended), leave all fields blank and you will have a list of all products.
Article code Enter the article code, if you know it.
Description You do not have to type the whole description. If you know how the description begins, you can enter the first letters (only).
Category If there are many items in a category, we suggest that you search for Category and (part of) the description, if you know it.
Search-tips If you enter "boards blue" under the Description, you will get products containing both "boards" and "blue" in any order. If you enter "boards+blue", you will get items containing "boards" plus items containing "blue". That is to say, in the latter case you will get the same hits as if you had first searched on "boards", then "blue".
"Out" Out = out of stock = not possible to place an order (because the supermarket can not handle back orders).
Pro Interface The pro interface is designed for those who use the supermarket on a regular basis. You should only use this method if you know exactly what you want.
Retailers The lowest prices will be displayed if you search for "bulk rate" (in the Description field).
Advanced Search
|
To find values that are
|
Use this operator
|
Example
|
|
Less than what you type next
|
<
|
<40
finds all the records less than 40
|
|
Less than or equal to what you type next
|
<=
|
<=05:00:00
finds all the records less than or equal to five o'clock
|
|
Greater than what you type next
|
>
|
>05:00:00
finds all the records after 5:00
|
|
Greater than or equal to what you type next
|
>=
|
>=Smith
finds all the records whose name is "Smith" and all records
alphabetically after "Smith"
|
|
An exact match, although the field may contain other values
|
= (before criteria)
|
=Smith
finds all the records where the name is "Smith," including
"John Smith," but not Smithson
|
|
An exact match, in the order you specify, and the field contains
no other values
|
== (before criteria)
|
==Smith
finds all the records where the name is "Smith," but
not "John Smith" or "Smithson"
|
|
Within the range you specify
|
... (3 periods)
|
12:30...17:30
finds all the records between 12:30 and 17:30
|
|
Duplicate values
|
!
|
!
finds all the records that have duplicate values in a
field
|
|
Today's date
|
//
|
//
finds all the records that have today's date
|
|
Invalid dates or times
|
?
|
?
finds all the records that have invalid dates or times
|
|
One unknown or variable text character
|
@
|
@on
finds all the records that have 3 characters and end in "on,"
like "Don"
|
|
Zero or more unknown or variable text characters
|
*
|
*smith*
finds all the records that have "smith" in the name, like
"Smithson," "Blacksmith"
|
|
Literal text in a field (to find characters that aren't automatically
searched, such as ",")
|
" "
|
", Ltd."
finds all the records that have ", Ltd."
|
|
Empty fields (for example, records of unfilled orders)
|
=
|
=
finds all the records that have no values
|
|