Elbuz picks up the IPC Group price list from your mailbox, reads the Excel attachment and maps IPC code, category, manufacturer, model, dealer price and RRP. The name comes from manufacturer and model.
When you need this:
- IPC sends the price list only by email — the app takes the latest IPC email.
- The IPC file has no name column — it's built without a doubled brand.
- The short price list marks stock with “Y” — two rules sort out stock.
- IPC products aren't found by SKU — code and model go into the right fields.
Where to start: save the IPC email file and create an “E-mail” source.
What the IPC source does
- Picks up the price list from email — the latest IPC email that matches the selection condition.
- Maps the columns on its own from a sample file, however many manager contacts sit above the table.
- Builds the product name from manufacturer and model; puts the IPC code into “Supplier SKU” and the model into “Manufacturer SKU”.
- Reads stock in the short price list once you add two rules.
- Takes IPC warehouse stock from an open file as a separate source.
How to connect the IPC price list from email
IPC Group has no API for dealers — the price list arrives by email as an Excel attachment. So the IPC source is a regular email source (how a price list from email works).
- Save the file from the IPC email to your computer — you'll need it as a sample.
- New source wizard. On the “From where” step, choose the “E-mail” tile and add the saved file — the wizard says: “First attach a sample file from the supplier — we will map the columns from it.” The app maps the columns from this sample on its own (columns).
- Email. On the last step, click “Set up file retrieval” — the “Source” section of the card opens. Choose a mailbox in the “Mailbox that receives the price lists” list or connect a new one with “Add” (mailbox).
- Selection condition. In the “Price list receiving settings” builder, add “Sender” equals
noreply@ipcgroup.com.uaor your IPC manager's address. To avoid going through old mail, set “Number of days (max)”, for example1. Several files in the email — “File name” containsprice_ipc(email selection condition). - Import the price list with the “Import” button in the source card — now the file comes from email.
The app takes exactly one email — the latest one that matches the condition. If there are no emails, the log shows “There are no emails matching the specified filter! Processing the previous file.” and the run uses the previous file.
If the source was created without a sample, the columns are mapped on the first email with a price list, and products are imported right away. If mapping fails, the run stops with “Column addresses for loading data from the price list are not filled in!”.
What IPC sends: full and short price list
The mailing comes from noreply@ipcgroup.com.ua; some dealers get the price list from their IPC manager's personal address. The attachment is an .xls file named like 12345_…_price_ipc_2026…. There are two kinds of file, and they are mapped differently.
| What | Full price list | Short price list |
|---|---|---|
| Attachment name | …_price_ipc_<date> | …_price_ipc_n_… |
| Above the table | the date and contacts of all managers — the header row shifts when managers are added or removed | the date and one manager's contact, headers in row 3 |
| A “Артикул” (SKU) | IPC product code — mostly a number, occasionally letters | same |
| B “Категорія” (Category) | IPC category | same |
| C “Виробник” (Manufacturer) | brand | same |
| D “Модель” (Model) | model without brand: JH24DT180S | model with brand: Aiwa JH24DT180S |
| E “VIP-Дилер UAH*” (VIP dealer) | dealer price in UAH | same |
| F “РРЦ” (RRP) | recommended retail price in UAH | same |
| G “Наличие на складе” (In stock) | no such column | Y — in stock, empty — out of stock |
Neither kind has a separate product name column, let alone photos, descriptions or specifications: only code, category, brand, model and prices.
Price and RRP in UAH
Auto-detection doesn't set a currency in the “Price” and “RRP” rows, so prices are treated as being in your database's main currency. If your main currency isn't UAH, choose UAH in the “Currency” column of both rows in the “Columns” section — otherwise prices are converted as a foreign currency.
Which columns the app maps on its own
From the sample file, the app finds the header row and recognizes columns by their names; manager contacts above the table don't get in the way. For the IPC price list, the result is:
| Field in the “Columns” section | Full price list | Short price list |
|---|---|---|
| “Supplier SKU” | A | A |
| “Category from the price list” | B | B |
| “Manufacturer” | C | C |
| “Model” | D | D |
| “Manufacturer SKU” | D | not set — the model already includes the brand |
| “Price” | E | E |
| “RRP” | F | F |
| “Name” | C and D separated by a space | D |
| “Stock status (from price list)” | — | G |
1
Supplier SKU = 12
Name = 3,{ },43
Manufacturer SKU = 4- Supplier SKU is column 1: the IPC product code from column A.
- Name is built from columns 3 and 4: manufacturer and model separated by a space.
- Manufacturer SKU is column 4: the model is the real manufacturer part number.
- The IPC “Артикул” is the supplier's code, not the manufacturer SKU. That's why it goes into “Supplier SKU”, and the model becomes the manufacturer SKU. Otherwise a search by manufacturer SKU would look for internal IPC codes in the catalog.
- Name. In the full price list, it's manufacturer plus model: “Aiwa JH24DT180S”. In the short one, the model already includes the brand, so the model alone becomes the name, with no “Aiwa Aiwa…”.
- Rows above the table and items with only an RRP and no dealer price don't become products: they have no price.
Auto-detection works only on a new source — until column names are saved in it (how auto-detection works).
The IPC source was connected long ago
For a source that is already mapped, the app updates only the header names and keeps your column addresses. Compare the “Columns” section with the table above and fix the “Column address”:
- “Supplier SKU” —
A. If it's empty, the IPC code, the only stable product identifier, doesn't get into the price list. - “Manufacturer SKU” —
Donly for the full price list. For the short one, leave it empty: “Aiwa JH24DT180S” won't match “JH24DT180S” in a catalog card. - “Name” —
C,{ },Dfor the full price list orDfor the short one (joining columns).
If the mapping is a mess, create a new source in the wizard with a sample file and the same selection condition: auto-detection will start from scratch.
How to read “Y” stock
The full price list has no stock column: it contains only what IPC sells, so all products get “In stock”. Neither kind gives an exact quantity.
The short price list marks stock with the letter Y; an empty cell means the product is out of stock. The standard stock words don't include Y, so without your own rules all products, empty ones included, become “In stock”. Add two rules on the “Availability” tab:
- status “In stock”, with
Yin “Availability values from the price list”; - status “Out of stock”, value
{EMPTY}(literally, in capitals and in curly braces — that's how the app catches an empty cell).
1
Y = in stock2
{EMPTY} = out of stock- Y in the In stock rule: this is how IPC marks a product that is in stock.
- {EMPTY} in the Out of stock rule: an empty cell means the product is not available.
Add a rule with the “Add” button in the tab's top bar. How the decision is made and what happens to quantity — Stock in a supplier price list.
How IPC products are found in the catalog
A new price list is matched to the catalog with three out-of-the-box types: manually matched pairs, search by manufacturer SKU, and search by name (matching types). For IPC this means:
- full price list: the model in column D is a real manufacturer SKU, so search by it works if “Manufacturer SKU” is filled in your catalog cards;
- short price list: the manufacturer SKU isn't filled, matching goes by the “brand + model” name — search by name drops Cyrillic and special characters, so it's the brand and model that get compared.
Whatever isn't found automatically, match manually: Manually matching supplier products to the catalog.
IPC warehouse stock XML
Besides the email, IPC keeps an open XML file that needs no login: https://price.ipcgroup.com.ua/xml/priceIPCwarehouse.xml. It's not the whole price list but a short list of warehouse items:
- IPC code (
art, the same as column A in the email), category, brand, name; - price, RRP (
rrc); - availability (
availability) and quantity (quantity).
Connect it as a separate source by link (price list by link). XML auto-detection doesn't recognize the art, rrc and availability tags — enter their addresses in the “Columns” section manually.
Scenarios
IPC switched from the full price list to the short one
What to do. In the “Columns” section, leave D in “Name”, clear “Manufacturer SKU”, and set “Stock status (from price list)” to G. On the “Availability” tab, add the “Y” and “{EMPTY}” rules.
What you get. Names without a doubled brand; products with an empty cell are “Out of stock”.
The price list comes from an IPC manager, not the mailing
What to do. In the email selection condition, set “Sender” to the manager's address and “File name” contains price_ipc.
What you get. The app takes the manager's latest email that actually has the price list, not other attachments from your correspondence.
You need IPC warehouse quantities
What to do. Create a second IPC source by link to the warehouse stock XML and enter the tag addresses manually.
What you get. IPC warehouse items have a quantity in the price list; the rest of the range comes from the email, without quantity.
What to do when the email isn't found or the columns are wrong
| What you see | Why | What to do |
|---|---|---|
| “There are no emails matching the specified filter! Processing the previous file.” | The selection condition doesn't find the email: a different sender address, or the email is older than “Number of days” | Compare the sender address in the latest IPC email with the condition; increase “Number of days” (connection) |
| “Column addresses for loading data from the price list are not filled in!” | The app didn't recognize the columns in the sample or in the first file from email, or auto-detection is turned off with the “Detect columns automatically” switch | Check that the email really contains an IPC price list, and map the columns manually using the table (columns) |
| Short price list: all products are “In stock”, although the “Наличие на складе” column has many empty cells | The standard stock words don't include “Y”, and no rule fired | Add the rules “Y” → “In stock” and “{EMPTY}” → “Out of stock” (stock) |
| Names like “Aiwa Aiwa JH24DT180S” | It's the short price list, but “Name” is built from manufacturer and model; there the model already includes the brand | In the “Column address” of the “Name” row, leave only D |
| IPC products aren't matched by SKU | “Manufacturer SKU” is set to column A (the IPC code) or to the model with brand | “Supplier SKU” — A; “Manufacturer SKU” — D for the full price list, empty for the short one (source connected long ago) |
| IPC prices are converted at an exchange rate | The database's main currency isn't UAH, and no currency is set in the price rows | Choose UAH in the “Currency” column of the “Price” and “RRP” rows (price and RRP) |
| IPC products have no photos | IPC provides photos neither in the email nor in the XML | Fill the cards with content search (where to get photos) |
FAQ
Does IPC have an API for automatic price list import?
No. IPC sends the price list by email in Excel, so the IPC source is set up as a price list from email, and the app picks up the latest email on its own (connection).
What does “Артикул” mean in the IPC price list?
It's IPC's internal product code, not the manufacturer SKU. Put it in “Supplier SKU”. In the full price list, the manufacturer SKU is the “Модель” (Model) column.
Where do I get photos and descriptions for IPC products?
IPC doesn't send them. Cards are filled with content search by brand and model (Content search for products).
Can I send an order to IPC from Elbuz?
No, IPC has no API for orders, and the “Send to supplier” button doesn't work for IPC. You can create a supplier order in Elbuz and send it to your IPC manager.
Can I request a fresh price list from IPC in Elbuz?
No. The app takes what IPC sent in its latest email; a new price list appears when a new email arrives.
Where to find it and who has access
- Menu
- Directories → Processing price lists → List of price lists
- Mailbox and email selection condition
- source card, the “Source” section
- Columns
- source card, the “Columns” section
- Stock rules
- source card, the “Availability” tab
- Access right
- the “List of price lists” window and “Import settings: price list file”
- Prepare
- the mailbox IPC sends the price list to, and the file saved from the email as a sample
Related topics
- If the mailbox or email selection condition isn't set up — How to receive a supplier price list from an email.
- If the IPC columns were mapped wrong — Price list column mapping.
- If IPC products aren't found in the catalog — How to set up automatic product matching.
- If the price list was imported but prices on the website are old — How to import a price list and get prices into your catalog.
