Keep the prices assigned to your customers up to date with YBM Connect. Use shared price groups for customers with the same pricing, or provide customer-specific prices when each customer needs an individual setup.

File requirements

• File type: .csv
• Encoding: utf-8 is recommended. UTF-8 files may include a byte order mark.
• Delimiter: comma ,
• Header: include exactly one header row
• Columns: exactly three columns in the documented order
• Price format: a non-negative decimal value, for example 12.50

The same format is used for automated SFTP imports and for price files that are prepared for YBM Connect. Do not use a spreadsheet export that changes the delimiter, column order or encoding.

Price groups and customers

Each YourBarMate customer can be associated with a price group. The price group can be an arbitrary identifier. Product prices are then configured for combinations of product identifiers and price groups.

Multiple customers can be associated with the same price group. If you don't have shared price groups and want to send prices per customer, we recommend that you set Price Group to the Customer ID.

Important: The price file is a complete snapshot when it is imported automatically. A price that exists in YBM Connect but is missing from the configured source file is removed. Test a complete file before enabling an automated import.

Columns

1. Price Group: The name of the product price group.
2. Product ID: The product identifier.
3. Price: The unit price of the product for this price group.

Use a decimal point, for example 12.50. A comma decimal separator and a leading currency abbreviation are also accepted by the importer, but the template uses the unambiguous decimal-point format. Prices cannot be negative.

An empty Price removes the current price for that product and price group. A price of 0 is a valid price and is different from an empty price. The product identifier and price group must not be empty.

Use the same Price Group and Product ID values consistently in every file. Neither field may be empty.

Example

Price Group,Product ID,Price
STANDARD,123456,5.80
RESTAURANT,123456,5.40

Each row assigns one price to one product and one price group. Keep the header and the column order unchanged.

Each combination of Price Group and Product ID should occur only once in a file. The referenced product must already exist in the YBM Connect catalog.

Customer-specific pricing

For customer-specific prices without shared price groups, use the Customer ID as the Price Group. This creates one price group per customer while retaining the same three-column format.

Import behaviour

Price imports are complete snapshots. All prices in the imported file replace the current prices covered by that import. Existing prices that are missing from the imported file are removed. An empty price is also treated as no price and removes the existing value.

Use one complete price file containing all price groups for the account. Do not split price groups across several files unless this has been explicitly agreed and configured with the YourBarMate team. Every imported price file is treated as a complete snapshot, so an incomplete file can remove prices unintentionally.

CSV pricing and the REST API

This CSV format supports one flat price per product and price group. More advanced pricing, such as scaled pricing or date-based price overrides, is available in the REST API documentation and is not represented in this CSV format.

Custom Format

You cannot provide your customer prices in the above format? Please get in touch, we might be able to help.