↑↓ selectEnter openEsc close

    1. Elbuz

    How to receive a supplier price list from an email

    10 min readUpdated

    Elbuz signs in to your mailbox, finds the supplier's email by a condition, and takes the price list. No saving attachments or manual uploads.

    When you need this:

    • Price list sent as an attachment — the program takes the latest matching email and its file.
    • Gmail, Outlook, Ukr.net or another service — the wizard fills in servers and ports for 15 providers.
    • Several attachments in the email — a file name condition picks the right one.
    • A link instead of a file — the program pulls the address from the email text.

    Where to start: source card → “Source” section → “E-mail” tile → “Add” next to the mailbox list.

    What receiving a price list by email can do

    What it takes for the price list to be picked up from email

    The supplier sends the file as an attachment; the program signs in to the mailbox, finds the email, and takes the attachment.

    For this to work, you need two things at once: a selected mailbox and a saved email selection condition. One without the other isn't enough — and this is where people trip up most often.

    How to connect a mailbox

    You pick the mailbox in the “Mailbox that receives the price lists” list. Next to it are two buttons: “Add” opens the wizard for connecting a new mailbox, “Configure” opens the form of an already connected one. The mailbox choice is saved automatically.

    The wizard has two steps — “Provider” and “Account”. The first shows tiles for fifteen mail services: Gmail, Outlook / Office 365, iCloud Mail, Yahoo, Zoho Mail, GMX, Ukr.net, Meta.ua / i.ua, WP.pl, Onet.pl, Interia.pl, WEB.DE, Fastmail, AOL Mail, and “Other” → “Set up manually”. Server addresses and ports are already filled in for each, so you don't have to type them.

    For eight services — Gmail, Outlook, iCloud, Yahoo, Zoho, Ukr.net, Fastmail, and AOL — the wizard shows a separate hint: “This provider requires an app password (for third-party apps), not your regular account password.” Next to it is a link to the service's official setup guide. These services simply won't accept your regular password, however many times you enter it.

    Step two has “Email address”, “Password”, “Sender name”, and the “Server settings (IMAP/SMTP)” fold with servers, ports, and the “Use SSL” checkbox. The provider tile fills these in: IMAP port 993 everywhere, port per service (mostly 465; 587 for Outlook, iCloud, and WEB.DE), SSL on, inbox folder INBOX. After “Connect”, the program checks the connection and shows two lines, “IMAP: …” and “SMTP: …”, in green or red. A mailbox created by the wizard is linked to the source right away.

    Mailbox wizard, Provider step, with provider tiles
    1Gmail tile
    2Other: set up manually
    1. Gmail tile: server settings are filled in automatically.
    2. Other tile: choose it to enter the server settings manually.
    Mailbox wizard, Account step, with the app password hint
    1App password hint
    1. Gmail needs a separate app password: your regular account password will not work.

    How to specify which email is the price list

    Next, you tell the program which email to treat as the price list. This is done in the builder under the “Price list receiving settings” subheading. The hint above it says: “Create an email filter condition to receive the price list by email. Limit emails by date so as not to download all mail from the selected sender. Click the Add button and select a condition.”

    Condition fieldOperatorsWhat it gives you
    “Sender”equals, containsthe most reliable filter if the supplier sends from one address
    “Subject”contains, equalswhen there are several addresses but the subject is stable
    “Message content”containssearch by the email text
    “Number of days (max)”equalslimits the search to the last few days
    “File name”contains, equalsselects an attachment in the email, not the email itself

    The first four fields become a query to the mail server: “Number of days” turns into a limit on emails no older than a given date, the rest into a search by sender, subject, and text. The “contains” operator looks for a substring, “equals” for an exact match. “File name” works differently: it's not an email search condition but a mask that picks the right attachment among those already downloaded.

    The condition saves itself about a second after you stop typing, like the other fields of the “Source” section. The “Save” button under the builder is only for when you want to be sure: it writes the condition immediately and shows the toast “Condition Saved”.

    Mail is picked up only when both are set — a selected mailbox and at least one condition with a value. If either is missing, a red line appears under the builder: “No email selection condition is set. The price list will not be loaded from email until at least one condition with a value is set.” — or, if no mailbox is selected, “The condition is saved, but no mailbox is selected. The price list will not be loaded from email until a mailbox is selected in the “Email address” field.”

    Nothing is written to the run log in this case: the program simply doesn't sign in to the mailbox. So the only place you can see the cause is that line in the card.

    The Source section of an E-Mail price list: mailbox list, email selection condition and Save button
    1Mailbox list
    2Email selection condition
    3Save button
    1. Mailbox that receives the price lists, with the Add and Configure buttons next to it.
    2. A row of the condition builder that selects which emails are taken as the price list.
    3. Save stores the condition; Clear All resets the builder.

    What the program does with the email

    Once it has found emails by the condition, the program takes exactly one — the latest of them. If the supplier sent two price lists in a day, the one that arrived later is processed. This can't be configured.

    Before each run, the attachments folder is cleared, so old files don't mix with new ones. The program discards images from the email and keeps only files. The email the file was taken from is marked as read in the mailbox. This doesn't affect selection: the condition doesn't distinguish read and unread emails, so without a newer email the next run takes the same one again.

    A special case is when the email contains a link to the file instead of an attachment. Then you fill in the “Regular expression to get the price list link from an email” field: the program applies the expression to the email text, takes the address from it, and then behaves as if this were a source by link.

    If no emails match the condition, the log shows “There are no emails matching the specified filter! Processing the previous file.” — and the run doesn't stop; it continues with the previous file. This isn't treated as an error until the new price list is later than usual (how often the supplier sends the price list).

    It's a different story when the program couldn't check the mailbox. “Could not connect to mailbox ‹address› (server ‹server›): ‹reason›…” means the server didn't let the program in: wrong password, or the server or port changed. “Mailbox ‹address› (server ‹server›) returned an error while searching for the email…” means the connection worked, but the server failed during the search. In both cases the run is marked as an error, and the file left over from the previous email isn't used — products keep working from the previous run.

    An example of a supplier that sends its price list only by email is IPC: how to set up the selection condition and its file's columns is covered in the article IPC price list: connecting from an email and setting up columns.

    Four side exits — four log lines. After three of them there will be no new file from email; after “No price list file received…” the file can still come from a link in the email if a regular expression is set. Two exits mark the run as an error — incomplete access settings and a mailbox failure. The regular expression is checked at the end: a link found in the email replaces the attachment
    NoYesMailbox refused accessor the server failedNoYesNoYesYesReceiving the file by emailDoes the mailbox have IMAPserver, port, user and passwordfilled in?“Mail server (IMAP) access settings… are not specified.”Search for emails by condition:sender, subject, content, number ofdays“Could not connect to mailbox…”or “…returned an error whilesearching for the email”the run is marked as an errorWas at least one email found?“There are no emails matching thespecified filter!Processing the previous file.”The latest email is taken.Attachments are saved, images arediscardedIs there an attachment matching“File name”?Without this condition, any one fits“No price list file receivedto import data from.”The first such attachment becomesthe price list file,the email is marked as readIs a regular expression setand was a link found in the email?The file is downloaded from this linkand replaces the attachment
    • Action or result
    • Decision: the path depends on the answer

    Scenarios

    The price list arrives by email, sometimes twice a day

    What to do. Select the “E-mail” tile; in the “Mailbox that receives the price lists” list, click “Add” and pick the provider; for Gmail, Outlook, iCloud, Yahoo, Zoho, Ukr.net, Fastmail, and AOL, use an app password. In the condition builder: “Sender” — “equals” the supplier's address, “Number of days (max)” — for example, 2. If the email has several attachments, add “File name” — “contains” and a stable part of the price list's name.

    What you get. The program looks for emails from this address over the last few days, takes the latest one, and from it the first attachment that matches “File name”. The email is marked as read.

    What won't happen. The morning price list isn't processed if a second one arrived in the evening: only the latest email is taken. Without “Number of days”, the program will find an old email and import it even when there was no new one. Without a selected mailbox or a condition, mail isn't picked up at all, and the log says nothing about it — the cause is visible only in the red line under the builder.

    The email contains a link to the price list, not a file

    What to do. Set up the email selection condition as for a regular price list, and fill in the “Regular expression to get the price list link from an email” field.

    What you get. The program applies the expression to the text of the email it found, takes the address from it, and downloads the file as for a source by link.

    What won't happen. Without a selection condition or a selected mailbox, the program doesn't sign in to the mailbox, and the expression finds nothing.

    What to do when the price list doesn't arrive by email

    Common problems
    What you seeWhyWhat to do
    “Could not connect to mailbox…” or “Mailbox … returned an error while searching for the email…” The mailbox didn't let the program in, or the server failed while searching for the email; the file from the previous email isn't used Check the mailbox login, password, and server; a search failure is usually temporary (about the mailbox)
    “Mail server (IMAP) access settings for receiving price lists by email are not specified.” Something in the selected mailbox's access is empty: server address, port, user name, or password Click “Configure” next to the mailbox list and fill in what's missing (about the mailbox)
    “There are no emails matching the specified filter! Processing the previous file.” The selection condition didn't find a single email Loosen the condition: increase “Number of days”, replace an exact subject match with “contains” (about the condition)
    “No price list file received to import data from. (‹mask›)” The email was found, but no attachment matched the “File name” mask Remove the file name condition or replace “equals” with “contains” (about the condition)
    “IMAP Error: ‹text›” after clicking “Connect” The mail server didn't let the program into the mailbox Gmail, Outlook, iCloud, Yahoo, Zoho, Ukr.net, Fastmail, and AOL require an (about the mailbox)
    “Enter your email address and password.” The address or password isn't filled in in the mailbox wizard Fill in both fields on the “Account” step (about the mailbox)
    “Enter the IMAP server (or pick a provider).” “Other” is selected, but no server is entered Enter the server manually, or go back and pick a provider tile (about the mailbox)

    FAQ

    How many emails does the program take per run?

    Exactly one — the latest of those that match the selection condition. If the supplier sent two price lists in a day, the later one is processed. No setting changes this.

    I connected the mailbox, but emails aren't picked up. What's wrong?

    Most likely, no email selection condition is set: without it, the program doesn't sign in to the mailbox and writes nothing to the log. The cause is shown by the red line under the condition builder — about the condition.

    Why doesn't Gmail accept my password?

    Gmail, Outlook, iCloud, Yahoo, Zoho, Ukr.net, Fastmail, and AOL require an app password for third-party apps, not your regular account password. The wizard shows a hint and a link to the service's guide — about the mailbox.

    The supplier didn't send anything. Will the run fail?

    No. The log will show “There are no emails matching the specified filter! Processing the previous file.”, and the run continues with the previous file. It becomes an error when the new price list is late — how often the supplier sends the price list.

    Does the condition select only unread emails?

    No. The program marks the email it took as read, but the condition doesn't distinguish read and unread emails. Without a newer email, the next run takes the same one again.

    Where it is and who has access

    Menu
    Directories → Processing price lists → List of price lists
    Source card
    the “Source” section → the “E-mail” tile
    Mailbox
    the “Add” and “Configure” buttons next to the mailbox list
    Access right
    the “List of price lists” window plus “Import settings” and “…price list file”
    Prepare
    the mailbox and its password, the sender address or email subject, a sample file

    Why a source should have only one method set up — see the article on ways to receive a price list.

    Related topics

    Was this article helpful?

    Missing a feature? Tell us.

    We will add it for free if other users need it too.

    If only you need it, we will agree on it separately.

    Article contents

    Suggest an improvement

    Try Elbuz free