Elbuz builds a price list for customers and dealers in XLSX or CSV from current catalog prices and delivers it by link, FTP, or email. Set up columns once; the file refreshes on schedule.
When you need this:
- Wholesale buyers need fresh prices daily — the schedule rebuilds and emails the file as an attachment to everyone.
- Each buyer gets their own columns — your headers, values from the catalog or a formula.
- Supplier prices next to yours — a consolidated price list shows one column per supplier.
- Import into the customer's accounting software — UTF-8 CSV with the delimiter they need.
Where to start: your first customer price list.
What a customer price list can do
- Columns, formulas, prices, and currency — what the file is made of and what the customer sees in each cell.
- Consolidated price list — supplier prices in rows or columns, price colors, the category tree.
- XLSX or CSV — a formatted Excel workbook or a text file for the customer's accounting software.
- Scheduled delivery — a permanent link, , or an email to every newsletter recipient.
- Fixing a mistake — what to do when a wrong file has already reached the customer.
Which format to choose: XLSX or CSV
You choose the format with the radio buttons on the “Select Format” card: , XLS, or CSV. XLSX is the default and the right choice in the vast majority of cases; XLS remains for those who need the old format. The formats are mutually exclusive: pick another one and the previous one is cleared automatically.
The difference isn't cosmetic: XLSX and XLS are written by one library and CSV by a completely different one, which explains all the differences.
1
Selected format: XLSX2
Column delimiter- XLSX is the selected format; XLS and CSV are the other two options.
- The column delimiter field is empty by default, which is the default state for CSV.
| XLSX / XLS | CSV | |
|---|---|---|
| Sheet in the workbook | one, named JumperSheet1 | no concept of sheets |
| Header | Calibri 10, bold, green; the first row is frozen and stays in place when you scroll | an ordinary first row |
| Column width | from the “Width” column | not applied |
| Price colors and hyperlinks | yes | no, plain text |
| Empty columns in the header | on a server without an activated license for the Excel library — 256 cells | exactly as many as there are columns |
| Cell length limit | 32,767 characters | none |
| File extension | as set in the name | .xlsx in the name changes to .csv — but only in the link. A file sent over FTP or as an email attachment keeps the extension from the “File name” field, so for these routes type .csv yourself |
The row about 256 cells needs its own explanation, because it isn't the app's behavior. The library that writes XLSX is commercial, and without an activated license it runs in trial mode: it takes the first row for itself and stretches it across the full width of the old format, up to column IV.
As a result, Ctrl+End jumps somewhere near the end of the sheet, and “Format as Table” grabs some 250 empty columns. Your data isn't affected. The demo account has this; if your own file has such a header, contact support — it isn't a template setting. The only workaround for now: send CSV.
CSV settings
The “CSV Configuration” card is always visible, even when XLSX is selected — with XLSX these two fields simply have no effect.
An empty “Column Delimiter” field means tab — and that's the worst option for the customer: double-clicking such a file opens it in Excel as a single column. Set a comma or a semicolon explicitly. If you type the word TAB in the field, the app replaces it with a real tab character.
Also, the delimiter must be exactly one character. The field lets you enter more, but only the first character goes into the file, and the log gets a warning: “Column separator “‹what you entered›” is not allowed: a single character is required. Used “‹what was taken›””.
When the “Enclosure character” field is empty, a double quote is used. Values are enclosed only where needed: when a value contains the delimiter, a quote, or a line break.
The card has two fields — “Column Delimiter” and “Enclosure character”. There is no way to set the line ending, and no need to: CSV lines always end with a line feed.
CSV is written in with a . That's exactly what Excel on Windows expects: the customer double-clicks the file and sees Cyrillic text, not random characters. You no longer need to walk the buyer through “Data → From Text”.
Scenarios
Your first price list for a customer: from template to schedule
Before you give the file to a customer
The customer loads the price list into their accounting software as CSV
- What to set up: CSV on the “Select Format” card; in “Column Delimiter”, exactly one character — the one the customer's software expects; if the file goes over FTP or by email, the
.csvextension in “File name”. - What you get: a text file in UTF-8 with a BOM — Excel on Windows opens Cyrillic correctly on double-click. Columns are separated by your character, and values are enclosed with the “Enclosure character” (empty field — a double quote).
- What you won't get: an empty “Column Delimiter” doesn't give you a comma — it means tab. If the delimiter has several characters, only the first goes into the file, and a warning goes into the log. The app changes
.xlsxto.csvonly in the link.
What to do when a customer can't open the file
| What you see | Why | What to do |
|---|---|---|
| The customer opened the CSV and sees random characters instead of Cyrillic | The file was opened not in Excel but in a program that doesn't read the BOM: the file itself is UTF-8 with a BOM, and Excel on Windows reads it correctly | Open it by double-clicking in Excel, or set the to UTF-8 in your importer (about CSV) |
| The customer opened the CSV and the whole file is in one column | The “Column Delimiter” field is empty, which means tab | Set a comma or a semicolon (about CSV) |
In the XLSX, Ctrl+End jumps to column IV, and the header has hundreds of empty columns |
The library that writes XLSX runs in trial mode: without an activated license, it stretches the first row to 256 cells | Your data isn't affected. Contact support — this is a server state, not a template setting; meanwhile, you can send CSV (about formats) |
| “Could not read the generated file for preview.” | The file was built, but it couldn't be read back | Check the format and that the file was actually built: the run log should have a line about the file upload (CSV settings) |
| “Could not create the Excel file on the server. The file was not generated — contact support.” | The extension for writing Excel didn't load. The file isn't built, and the link keeps the previous one | Temporarily switch the template to CSV and contact support |
| “Save failed” in the card's bottom bar | Autosave on the “Settings” tab didn't go through | Repeat the change and make sure “All changes saved” appears |
| “No access to data export” | The user's group doesn't have access to the export window | Ask the account owner to grant access (who has access) |
FAQ
A customer complains that the prices in the file are out of date. Why?
The file is rebuilt only during a run. Without a schedule, the link holds whatever was last built manually. Turn on the schedule.
Can I email the price list to customers automatically?
Yes, and only this export type can do it: pick a “Newsletter template” on the “Email newsletter” card, and the file goes out as an attachment on every run (about the newsletter).
How many columns can I add to the price list?
As many as you like — there is no limit. A typical customer price list has five to eight columns (about columns).
Why does the XLSX header have hundreds of empty columns?
It's a trace of the trial mode of the library that writes XLSX, not a template setting. Your data isn't affected. Contact support; meanwhile, send CSV (about formats).
Can I make a price list with supplier prices?
Yes: turn on “Create rows per contact” or the “Show values per supplier” column — you get a consolidated price list (how to build one).
Where to find it and who has access
- Menu
- Directories → Operations → Data export
- Desktop
- the “Export” shortcut, unless it was removed from the desktop — shortcuts are per user
- Template card
- select a row in the list → pencil button in the toolbar; or the pencil button that appears on the row when you hover over it. The window title is “Advanced settings ‹template name›”
- New price list
- “Add” button → “Price list file (XLSX, CSV)” group → “Price list (XLSX, CSV)”
- Access right
- the “Data export” window — one right covers the list, the card, and “Check”
- Prepare
- categories with names in the export language — otherwise their products drop out of the file
The “Price list file (XLSX, CSV)” group comes first in the “Add” menu. Besides “Price list (XLSX, CSV)”, it holds the OpenAI (ChatGPT Ads) feed, built on the same engine, and a prom.ua feed in XLS format.
In a new template, the “File name” field already contains export_price_summary.xlsx — change it to something your customer will understand. You can also clear the field completely: the app then uses the same default name, and the file at the permanent link keeps its name.
The price list card has three tabs:
- “Select fields” — the file's column builder;
- “Settings” — format, , the “What to export” checkboxes, delimiters, the newsletter;
- “Export limit (filter)” — filtering conditions. It has two inner tabs: “Base Catalog Items” and “Products from price lists”. The second one exists only in this template type.
The “Settings” tab uses : there is no “Save” button, and the bottom bar shows “Saving…” and then “All changes saved”. Every checkbox click goes to the database right away.
The “Export” button in the card header starts a live run. Before it starts, it asks for confirmation and states the scale: “Start the export. Products going into the file: N. The new file replaces the current one at the permanent link.”
- Once you confirm, the new file goes to the template's folder in the cloud, the link is updated, and all other files in the folder are deleted. A customer who picks up the price list by link gets whatever you have just done.
- To simply see the result of an edit, use the flask button next to it, “Check”: it writes to a separate file and sends it nowhere.
- The same dialog with numbers also opens when you start a run from a row in the template list — unless it has been turned off for the whole account in the “Export stop rules” window (about starting and the summary).
Related topics
- If a product didn't make it into the file or the export didn't start — How to set up product exports to a marketplace, a website or a file.
- If the customer's price needs a different markup — Pricing rules: how a supplier price becomes your price.
- If instead of a file for people you need a feed for ChatGPT ads — How to export a product feed for OpenAI (ChatGPT ads).
