The ERC integration in Elbuz fetches dealer prices, RRP and per-warehouse stock itself — no files or emails.
When you need this:
- ERC ships to you from one warehouse only — availability and quantity come from it, other products are dropped.
- Some ERC products are in hryvnias, some in dollars — each product's currency is detected, hryvnia prices aren't multiplied by the rate.
- Prices must follow the ERC rate — the ERC invoicing rate is applied before each import.
- A purchase order must go to ERC — one button in the document sends it; status and waybill come back.
Where to start: ask your ERC manager for API access.
What the ERC integration can do
- Imports the ERC catalog — names, codes, dealer prices and RRP, barcodes, warranty, weight and dimensions, photos. The columns are mapped in advance.
- Takes availability and quantity — totals across ERC warehouses with no setup, or for your warehouse only.
- Keeps hryvnia and dollar prices in one price list — an ERC flag sets each product's currency.
- Converts dollar prices at the ERC rate for the import day.
- Pulls attributes and extra photos from a separate ERC service with a token.
- Sends purchase orders to ERC and gets back the shipping status and the number.
The ERC category and subcategory come with every product, and you match them to your categories the same way as for any price list (category matching).
What to ask your ERC manager for
ERC API access is granted by ERC itself, not by Elbuz. According to the ERC documentation (“ERC API. General guide”, version 1.40), the steps are as follows.
- Ask your ERC dealer account manager for API access. There's no separate API login: you sign in with the same email and password as on the ERC B2B portal.
- Give the manager the static IP address the requests will come from: ERC won't serve a request from any other address. Copy the address from the access settings window (where to find it): different accounts use different servers.
- If you need availability from one warehouse, ask for its number. The numbers from the documentation are in the table below, but only the manager knows which warehouse serves your contract.
- Optionally, a token for the attributes and photos service. This service isn't in the general ERC API guide, so you ask the manager for the token too (why).
- If you plan to send orders, access to creating orders via API. It's a separate permission at ERC: without it the catalog arrives, but ERC rejects orders (errors 105 and 110).
Which ERC request parameters to change
In the new source wizard, at the “From where” step, pick the “API” tile and ERC in the list. The program sets the service address https://connect.erc.ua/connectservice/api/specprice/DoExport, the format and the columns itself (what linking does). In the access window, enter the B2B portal email in “Login” and its password in “Password (token)”.
On the “Request parameters” card, three rows concern the price list. The eight rows starting with “Order:” are only needed for sending orders.
| Parameter | Default | What it does |
|---|---|---|
| “Language code” | ua | language of catalog names and categories; ERC accepts ru, ua, ru-ru, uk-ua |
| “API URL for attributes and photos” | empty | attributes service address with your token; empty — attributes and photos aren't requested (details) |
| “Import currency rate” | 1 | 1 — take the ERC rate for dollar prices before each import; any other value — leave the rate alone (details) |
1
API URL for attributes and photos2
Import currency rate3
Order: mode- API URL for attributes and photos — paste the ERC link with your token here to load characteristics and photos.
- Import currency rate — turns on applying the ERC exchange rate to prices given in dollars.
- Order: mode — this row and the ones below set how an order is sent to ERC.
What ERC sends and how availability is calculated
One request returns the whole catalog available to your account, in XML. The request can't filter by brand, category or warehouse, so filtering happens on the received data. The program waits up to 300 seconds for a response.
Columns that linking maps on its own. Sources connected earlier may have a shorter set: columns are set once, at the moment of linking.
| ERC tag | Field in Elbuz | Note |
|---|---|---|
code | “Manufacturer SKU” and the product ID in the price list | ERC |
gname | “Name” | |
sprice | “Price” | dealer price; currency — from the ddp tag |
ddp | “Currency” | 0 — dollar, 1 — hryvnia (details) |
RRP_UAH | “RRP” | in hryvnias |
category, { / }, subcategory | “Price category” | category and subcategory separated by “ / ” |
stock | “Stock status (from price list)” | true or false: stock exists in at least one ERC warehouse, not necessarily yours |
stock_qty | “Quantity” | sum of usable stock across warehouses; the program adds this tag itself |
vendor, pic, ean, warr | “Manufacturer”, “Product image link”, “EAN barcode”, “Warranty” | in the ERC response the manufacturer sits above its products; the program copies it into each product |
weight, width, height, depth | product weight and dimensions | ERC depth goes into the length field |
By default, availability means “somewhere at ERC”, including a warehouse that won't ship to you:
- Status comes from the
stocktag: true becomes “In stock”, false — “Out of stock”, with no setup. If ERC didn't send the tag, the program sets it itself from the warehouse total. - Quantity is the
stock_qtytag: the sum of all warehouses except 44, 55, 100_44 and 100_55 (damaged goods and damaged packaging). The program counts the>50range as 50. - A product only in a clearance warehouse will be “In stock” with quantity 0:
stockincludes clearance warehouses,stock_qtydoesn't. If that's a problem, put thestock_qtyaddress in the “Stock status (from price list)” row.
Stock for each warehouse sits next to it, in the whs block:
<whs><wh id="1" q="7" /><wh id="44" q="0" /><wh id="100" q=">50" />…</whs>
id is the warehouse number, q is stock minus reserve minus items being picked. Up to 50 inclusive, it's an exact number; above that, a range as text: >50 (51–100), >100 (101–300), >300 (301–500), >500 (501 and up).
ERC warehouse numbers
Warehouses from the ERC API documentation, version 1.40. ERC doesn't provide a warehouse reference list via API, so ask your manager which warehouse ships to you; the response may contain other numbers too.
Number in id | What it is per ERC documentation | Column address |
|---|---|---|
| 1 | warehouse 1 | //wh[@id='1']/@q |
| 5 | software warehouse | //wh[@id='5']/@q |
| 44 | damaged goods: scratches, small dents | //wh[@id='44']/@q |
| 55 | goods with damaged packaging | //wh[@id='55']/@q |
| 100 | warehouse 100, usable goods | //wh[@id='100']/@q |
| 100_44 | warehouse 100, goods of limited usability | //wh[@id='100_44']/@q |
| 100_55 | warehouse 100, goods with damaged packaging | //wh[@id='100_55']/@q |
Manufacturer
In the ERC catalog, the manufacturer name appears once above the group of its products, and the program copies it into each product with the vendor tag. If the “Manufacturer” column in the price list products is empty, enter the vendor address in the “Manufacturer” row of the “Columns” section and run the import.
How to take availability from one ERC warehouse only
You need this when you're shipped from only one warehouse. The examples use warehouse 100; replace the number with yours.
Availability from one ERC warehouse
Step 1. Warehouse address in the columns
In the “Columns” section of the source card, in the “Stock status (from price list)” and “Quantity” rows, enter //wh[@id='100']/@q in “Column address”. No “Quantity” row — add it with the “Add field” button.
The program looks up the address inside each product separately, so every product gets its own stock. Always put the number in single quotes: warehouses like 100_44 won't be found without them. From ranges like >50, >100 the program keeps the digits, so a quantity above 50 is a lower bound: >100 gives 100.
1
Stock status address2
Quantity address3
Price row with currency code- The address in the stock status row points to a warehouse number in single quotes.
- The same address in the Quantity row: the quantity is taken from the same warehouse.
- The Price row has the USD currency code, so the ERC rate is applied to it.
The address alone is enough for correct statuses: a number from 1 becomes “In stock”, zero — “Out of stock”. But products with zero stay in the price list, and a wrong warehouse number goes unnoticed — that's what step 2 is for.
Step 2. Rules on the “Availability” tab
On the “Availability” tab of the source card, add two rules with the “Add” button.
| Rule | Status | “Availability values from the price list” | “from” / “to” | Switches | “Rule order” |
|---|---|---|---|---|---|
| 1 | “In stock” | empty | 1 / 999999 | “Only import products with this status” — on | 1 |
| 2 | “Out of stock” | {EMPTY} | empty | “Only import products with this status” and “Set this status for all products” — off | 2 |
1
Import only products with this status2
{EMPTY} value- The checkbox in the In stock rule means products with zero stock leave the price list.
- The {EMPTY} value in the Out of stock rule is a safeguard against a wrong warehouse number.
Before comparing, the program strips spaces and the >, <, = characters from q, so >50 falls into the range as 50. Always fill in the upper bound: a range “from 1 to 0” never matches. Use a range, not a list like “1, 2, …, 9”: a list is compared exactly and will miss stock of 12 or >50.
The second rule guards against a wrong warehouse number. If ERC has no such warehouse, the address is empty for all products, and without the {EMPTY} rule the whole price list becomes “In stock” with quantity 0. With the rule, you get an empty price list and “Sharp drop in item count (100%)” in the log: the error is visible.
If you need the whole ERC catalog but availability from one warehouse only, don't turn on “Only import products with this status” in the first rule: products with zero stay with the “Out of stock” status. How the switch affects the base catalog is covered in the article on stock statuses.
- Start or end
- Action or result
- Decision: the path depends on the answer
Step 3. Check
After changing the address, run the source import: availability values stay from the old address until ERC sends the catalog again. The “Determine availability for products” button on the “Availability” tab checks rules against already imported rows, but not a warehouse change.
Above the rules grid, the hint “Availability values from the price list:” shows the values from the last import. For one warehouse, these are numbers up to 50 and the ranges >50, >100, >300, >500; true and false mean the address from step 1 wasn't saved. Stock reaches the site after the base catalog update.
How to get the currency of ERC prices right
ERC sells some products in dollars and some in hryvnias, and the sprice dealer price comes in the product's currency. The ddp tag says which: 1 — hryvnia, 0 — dollar. This is ERC's official explanation; in the ERC orders API the same field is called IsDDP.
Without the ddp setup, the program treats all prices as dollars, and a product costing 780 hryvnias ends up about 41 times more expensive in the price list. Check the “Columns” section: there should be a “Currency” row with the ddp address, and the “Price” row should have a multicurrency rule for UAH. If not, set it up once:
- Use the “Add field” button to add a “Currency” row and enter
ddpin “Column address”. - In the “Price” row, the “Currency” column must be USD — the currency of products with
ddp0. Not EUR: then dollar products would be counted as euros. - In the same row, click the dollar icon in the “Multicurrency” column — “Currency detection settings in the price list” opens.
- Click “Add currency”, choose UAH, and enter
1in “Text to search”. Leave “Column address” empty and “Exchange rate” at zero: the program takes the hryvnia rate from the currency list. - Run the source import.
1
Add currency2
Text to search: 13
Currency code UAH- Add currency: the currency is chosen from the list, here UAH.
- The search text 1 is how ERC marks hryvnia-priced products in the ddp tag.
- The currency code cell shows UAH.
A “0 → USD” rule isn't required: anything other than 1 uses the currency of the “Price” row. This doesn't affect “RRP”: RRP_UAH is always in hryvnias.
ERC rate for dollar prices
When “Import currency rate” is 1, after receiving the catalog the program makes a separate request to ERC for today's invoicing rate (the Kyiv rate and the crediting rate aren't used). The rate is written to “Exchange rate” of the “Price” and “RRP” rows with USD currency — you can see it in the “Columns” section.
- ERC didn't return a rate, or today's rate isn't set yet — the previous one stays.
- ERC responded with an error — the log shows “Supplier API error: …”.
- The currency list has no USD — the rate isn't saved, and the log shows “Supplier rate not saved: there is no USD in the currency list. Rate: ‹number›”.
- Need your own rate — set the parameter to 0 and enter the rate in the columns.
How to get ERC attributes and photos
The main ERC price list gives the name, prices, availability and one photo. Attributes, description and extra photos come from a separate ERC service with a separate token — not the one in “Password (token)”.
- Ask your ERC manager for a token — access to the product attributes and photos service (
wares.xml). You won't find it in your account on your own. - Build the link:
https://api.erc.ua/api/erc/wares.xml?token=YOUR_TOKEN, with no spaces in the token. - Paste the link into the “API URL for attributes and photos” parameter (request parameters).
- Import the price list and check attributes and photos in the price list products.
With the link, every import makes a second request: attribute groups, manufacturer, description and photos are attached to price list products by the ERC code (code). An empty parameter breaks nothing — the catalog, prices and stock come with the first request.
A wrong or expired token doesn't stop the import: the price list arrives, attributes and photos are skipped. The log shows “Supplier API error: attributes and photos were not loaded (check the token in “API URL for attributes and photos”)” with the ERC response after the colon. Get a new token and paste the link with it.
How to send an order to ERC
A purchase order created in Elbuz for the ERC contact is sent to ERC from the document itself. ERC gets a real order, so the program asks for confirmation. You can also send an unposted document.
Order settings
These are the “Order:” rows on the “Request parameters” card of the ERC source. The program takes them from the first active API source of the contact the document is issued to. The tax ID, payer and contract ID are shown by the “Get reference data” button in the same window — it doesn't create anything at ERC.
| Parameter | Default | What it does |
|---|---|---|
| “Order: mode” | 0 | 0 — pickup from the ERC warehouse, 1 — dropshipping: ERC ships the goods to your customer using the waybill from the document |
| “Order: ERC warehouse” | 1 | the warehouse where ERC picks the order: 1 or 5 |
| “Order: auto-reserve” | 0 | 1 — ERC reserves the goods right away within free stock |
| “Order: accounting documents” | 0 | 1 — ERC issues accounting documents; requires extended ERC access and a payer |
| “Order: payer (ID)” | empty | payer ID from the reference data |
| “Order: payer EDRPOU” | empty | instead of the payer ID, you can give the payer's EDRPOU code |
| “Order: consignee tax ID (IPN)” | empty | required for pickup; taken from the reference data |
| “Order: contract (ID)” | empty | optional; contract ID from the reference data |
Sending
Open the “Purchase order” document, click “Send to supplier” and confirm. The result appears as a message and is recorded in the document history.
1
Send to supplier2
Refresh status from supplier3
Not posted- Send to supplier — sends the order to ERC after confirmation.
- Refresh status from supplier — requests the status and tracking number from ERC.
- Not posted — an order can be sent even before it is posted.
The program sends nothing if:
- a line has no ERC code — the product isn't matched with the ERC price list; the names of such lines are in the message;
- in dropshipping mode, the waybill number in the document is empty;
- in pickup mode, “Order: consignee tax ID (IPN)” isn't filled in;
- accounting documents are on, but the payer isn't given either by ID or by EDRPOU;
- the document has no lines with a quantity above zero.
- Lines with the same ERC code are combined into one order line.
- Dropshipping. You create the waybill yourself, as for any shipment from a document; only its number goes to ERC.
- Resending doesn't create a duplicate. If ERC already has an order with this document's number, no new one is created, and you get “An order with this number already exists in ERC, it was not created again.” So ERC treats two documents with the same number as one order.
- “Pending approval” isn't an error. The order is created, the message is yellow — “Order in ERC is pending approval: …”, and the supplier status of the document is “Pending approval”. Approval then happens on the ERC side.
Status and waybill from ERC
The status doesn't update by itself — only with “Refresh status from supplier” in the menu next to the send button. The message shows the ERC order number and how much of the order has shipped. After shipping, the supplier status becomes “Partially shipped” or “Shipped”. The waybill number from ERC is written to the document if it's empty there.
When ERC rejects an order
An ERC rejection shows in the message: the error code and text. The most common ones, per ERC documentation:
| Code | ERC message | What to do |
|---|---|---|
| 105 | Access to automatic order creation mode is forbidden | ask your ERC manager for permission to place orders via API |
| 106 | Wrong , operation forbidden | give your ERC manager the IP address from the access settings window |
| 110 | Order creation is blocked | ask your ERC manager why it's blocked |
| 125 | Consignee tax ID or declaration not specified | fill in the tax ID for pickup or the waybill for dropshipping |
Scenarios
The warehouse you took goods from no longer ships
What to do. Ask your ERC manager for the new warehouse number. In the “Stock status (from price list)” and “Quantity” rows, set //wh[@id='‹number›']/@q, and on the “Availability” tab, the two rules from step 2. Run the import.
What you get. The price list keeps only products with more than zero in the new warehouse, with that warehouse's quantity. The rest disappear from the price list in the same import.
You need the whole ERC range, but availability from one warehouse
What to do. Same as above, but don't turn on “Only import products with this status” in the first rule.
What you get. All ERC catalog products in the price list: with stock in your warehouse — “In stock”, without — “Out of stock”. Stock of other warehouses isn't added to yours.
Hryvnia prices at the ERC rate
What to do. Leave “Import currency rate” = 1; in the “Columns” section, set dollar in the “Price” row and the currency by ddp, as in the currency section.
What you get. Before each import, dollar prices are converted at the ERC invoicing rate for the current day, and hryvnia prices stay as they are.
What to do when the ERC price list didn't arrive or availability is wrong
| What you see | Why | What to do |
|---|---|---|
| Products in stock that your warehouse doesn't have | Availability comes from the stock tag: “in at least one warehouse” |
Enter your warehouse address (step 1) |
| After changing the warehouse, all products are “In stock” with quantity 0 | The response has no warehouse with that number, so no row was recognized | Check the number and the quotes in the address, add the {EMPTY} rule (step 2) |
| The price list is empty, and the log shows “Sharp drop in item count (100%)” | A wrong warehouse number with the {EMPTY} rule and the “only with this status” switch |
Ask your ERC manager for the warehouse number and check the quotes in the address (warehouse numbers) |
| Products with large stock disappeared, small ones stayed | The rule has a “1, …, 9” list with exact comparison | Replace the list with the range 1 to 999999 (step 2) |
| A range rule recognizes nothing | Only “from” is filled in, “to” is zero | Set “to” to 999999 |
| The quantity in the price list is exactly 100 more than stock (7 became 107) | The source has no “Quantity” row, so the status's “Default quantity” is added to the number (details) | Add a “Quantity” row with the stock_qty address or your warehouse address |
| In a source connected long ago, the quantity is true or false | The “Quantity” row has the stock address |
Replace the address with stock_qty |
| “Supplier API error: 106 Wrong IP, operation forbidden…” | ERC doesn't know the IP address the request comes from | Give your ERC manager the IP address from the access settings window (what to ask ERC for) |
When the catalog didn't arrive: ERC error codes
If the ERC server is unreachable, the import log shows “Supplier API error: cURL Error #:…” with the network reason. If ERC refused, the line is the same, but after the colon there's the ERC code and text:
| Code | ERC message | What to do |
|---|---|---|
| 103 | Email or password (pass) not specified | fill in “Login” and “Password (token)” in the access settings window |
| 104 | User not found | check the B2B portal email and password |
| 106 | Wrong IP, operation forbidden | give your ERC manager the IP address from the access settings window |
| 107 | You don't have access to this operation | ask your ERC manager for API access |
In both cases, the run uses the previous file: prices and availability aren't fresh (why).
FAQ
Can I choose the ERC warehouse in the API parameters?
No. The ERC API has no warehouse parameter, and the catalog comes with all warehouses. You choose the warehouse with the column address — how to take availability from one warehouse.
Why is the product quantity 50 or 100 when the ERC warehouse has more?
Above 50 units, ERC returns a range instead of a number: “>50”, “>100”, “>300”, “>500”. The program keeps the digits, so the quantity is a lower bound: “>100” means 101 to 300 units, and the price list shows 100.
Can I add up stock from two selected warehouses?
No. Quantity is either the sum of all warehouses of usable goods (stock_qty) or one warehouse via the column address.
Can I import only certain brands or categories from ERC?
Not on the ERC side — the catalog comes whole. You cut what you don't need in Elbuz with ignore rules.
I changed the warehouse, but availability in the price list is old. Why?
Availability values are taken from the file during import. Run the source import again; the “Determine availability for products” button only recalculates values already imported (check).
Where it is and who has access
- Menu
- Directories → Processing price lists → List of price lists
- New ERC source
- new source wizard, the “From where” step → the “API” tile → ERC
- Access and request parameters
- source card, the “Source” section → “API settings”
- Availability and quantity
- source card: the “Columns” section and the “Availability” tab
- Sending an order
- “Purchase order” document → “Send to supplier”
- Access right
- the “List of price lists” window plus “Import settings” and “…price list file”
- Prepare
- access from your ERC manager, the email and password of the ERC B2B portal
Related topics
- If you need to understand what the program does with any API source and where to enter credentials — How to connect a supplier via API.
- If stock statuses aren't recognized the way you need — Product availability in a supplier price list.
- If you need to change a column address or add a field — Price list column mapping.
- If the ERC price list imported but prices on the site are old — How to import a price list and get prices into your catalog.
