Engrana manual

Contents › Sales

Channel price list

In short

Price list exports for the channel's customer: which products and prices go into the file, which columns and in what format, when and where the file is sent — by email, to the customer's server (FTP, FTPS, SFTP), via a permanent link or to the installation's "Own FTP". Below — the send log.

Why it matters

  • Give the customer fresh prices and stock regularly, without manual work.
  • Fit the file to the customer's software: their own columns, separator and number format.
  • See what was sent and when, and spot sharp price jumps in time.

Who can

A manager with the sales channels permission and the administrator.

How to do it

  1. New export. Name, file format, separator and whether the first row holds headers.
  2. What goes into the price list. Brands and suppliers in the customer profile ("All", "Only these", "All except these"; brands can be loaded from a file), safety stock, "Show at most, pcs", "Skip if fewer than, pcs" and "on request" items with quantity 0.
  3. Columns. "Start from a template" or "Add column": header, what the column holds or a fixed value, and format (decimals, decimal separator, truncation, "If empty", UPPERCASE). "How the file will look" shows the first rows.
  4. Where to send. Email (a ZIP attachment; over 10 MB — a link valid for 7 days), FTP / FTPS, SFTP, link or "Own FTP". "Check the connection" before saving.
  5. When. Manually only, at set times or every N hours (Madrid time). To the customer's server you can send only the changes between full files.
  6. Send now or Download file to check it by hand.

Common messages

  • "Check prices" — the price changed by more than 20 % in many rows; the price list is sent anyway.
  • "Email is not configured…" — you cannot send by email: contact the installation administrator.
  • "The connection did not pass the check" — check the server, port, user and password, or save without checking.
  • "Server key…" — it is remembered on the first send; if the server changes its key, sending stops: "Reset" and enter the password again.
  • "No rows…" — check stock, quantity rules and channel prices.

Questions and answers

Will the customer see our purchase price or the supplier in the price list? No. Columns can only hold our own data: brand, part number, name, EAN, price with and without tax, quantity, lead time, availability and so on; purchase price and supplier are not among them. Suppliers in the customer profile only limit which on-order products go into the file.

Why is a product missing from the price list although it is in stock? For example: the warehouse is not one of the channel's warehouses, all the stock is reserved, the brand is not in the customer profile, after the safety stock fewer units remain than "Skip if fewer than, pcs", the product has no channel price, or the price is below the minimum allowed by the markup rule. How many rows were skipped because of quantity and price is shown in "How the file will look".

The customer downloads the price list by link, but the prices are old — why? The file behind the link is only updated when the export is sent — with "Send now" or on schedule; the link does not build the file by itself. When the file was updated and how many times it was downloaded is shown under the link.

How do I cut off access through an old link? "New link" — the previous one stops working at once; give the new link to the recipient.

What happens if the customer's server did not respond during a scheduled send? If nothing went out, the send is retried automatically up to two more times — after 5 minutes, then after another 10. If the file already reached at least one recipient, or the cause is in the settings (for example, the password, folder or server key), there is no retry: the cause is in the "Deliveries" block.

Where next

  • "Marketplaces and sales channels" — the channel's settings, prices and warehouses.
  • "Channel orders" — receiving orders against this price list.