binlogo.GIF
 Help

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

tillbaka.gif