DynPricing Admin

	Details	Actions
{{ overviewIcon(row.type) }} {{ row.label }} {{ row.subtitle }}	{{ row.meta }} --

info No active configuration available.

{{ state.selectedItems.projects.length }} project(s) selected

	Order	{{ t('tableSort.projects.domain') }}	{{ t('tableSort.projects.strategies') }}	{{ t('tableSort.projects.warehouse') }}	{{ t('tableSort.projects.status') }}	Modified	Actions
		{{ project.domain }} {{ project.slug \|\| 'N/A' }}	{{ strategy.name }} None	{{ project.warehouses_mask \|\| 'N/A' }}	{{ project.is_active ? 'Active' : 'Inactive' }}	{{ project.modified_by }} {{ project.modified_at ? formatDateTime(project.modified_at) : '' }} -	history

Showing {{ paginationBounds('projects').from }}-{{ paginationBounds('projects').to }} of {{ tableMeta.projects.total }}

Page {{ tableMeta.projects.page }} of {{ tableMeta.projects.pages }}

{{ state.selectedItems.strategies.length }} strateg(ies) selected

	🎨	Order	Project	{{ t('tableSort.strategies.name') }}	{{ t('tableSort.strategies.route') }}	{{ t('tableSort.strategies.global_rule') }}			Modified	Actions
			{{ project.domain }} -	{{ strategy.name }}	{{ route.name }} {{ strategy.route \|\| 'N/A' }}	{{ truncate(strategy.global_rule) \|\| 'N/A' }}	{{ rule.name }} None	{{ strategy.is_active ? 'Active' : 'Inactive' }}	{{ strategy.modified_by }} {{ strategy.modified_at ? formatDateTime(strategy.modified_at) : '' }} -	history

Showing {{ paginationBounds('strategies').from }}-{{ paginationBounds('strategies').to }} of {{ tableMeta.strategies.total }}

Page {{ tableMeta.strategies.page }} of {{ tableMeta.strategies.pages }}

{{ state.selectedItems.rules.length }} rule(s) selected

	🎨	Order	Strategy	{{ t('tableSort.rules.name') }}	{{ t('tableSort.rules.expression') }}	{{ t('tableSort.rules.filter') }}	{{ t('tableSort.rules.status') }}	Final	Modified	Actions
			{{ strategy.name }} -	{{ rule.name }}	{{ truncate(rule.dsl_expression) }}	{{ truncate(rule.filter_expression) \|\| 'N/A' }}		🛑 Final -	{{ rule.modified_by }} {{ rule.modified_at ? formatDateTime(rule.modified_at) : '' }} -	history

Showing {{ paginationBounds('rules').from }}-{{ paginationBounds('rules').to }} of {{ tableMeta.rules.total }}

Page {{ tableMeta.rules.page }} of {{ tableMeta.rules.pages }}

shield

No guardrails found

Click "New Guardrail" to create your first reusable pricing constraint

{{ state.selectedItems.guardrails.length }} guardrail(s) selected

	Order	{{ t('tableSort.guardrails.name') }}	{{ t('tableSort.guardrails.expression') }}	{{ t('tableSort.guardrails.note') }}	{{ t('tableSort.guardrails.status') }}	Application Mode	Modified	Actions
		{{ guardrail.name }}	`{{ truncate(guardrail.dsl_expression, 80) }}`	{{ guardrail.note \|\| '-' }}		{{ guardrail.application_mode === 'global' ? '🌐 Global' : guardrail.application_mode === 'filter' ? '🔍 Filter' : '📍 Local' }}	{{ guardrail.modified_by }} {{ guardrail.modified_at ? formatDateTime(guardrail.modified_at) : '' }} -	history

Page {{ tableMeta.guardrails.page }} of {{ tableMeta.guardrails.pages }}

					Validity	Global			Actions
#{{ rule.id }}	{{ rule.domainLabel }} {{ truncate(rule.domainDetail, 80) }}	{{ truncate(rule.targetSummary, 80) }} {{ truncate(rule.targetDetail, 80) }}	{{ truncate(rule.actionSummary, 80) }} {{ truncate(rule.actionDetail, 80) }} {{ flag }}	{{ rule.updatedLabel \|\| '?' }}	{{ rule.validityLabel }}	public Yes ?	{{ rule.statusLabel }}	{{ rule.ownerName \|\| '?' }}
No rules found.

Showing {{ paginationBounds('singleRules').from }}-{{ paginationBounds('singleRules').to }} of {{ tableMeta.singleRules.total }}

Page {{ tableMeta.singleRules.page }} of {{ tableMeta.singleRules.pages }}

				Actions
{{ tier.tier_name }}	{{ tier.tier_remote_id }}	{{ tier.project_domain \|\| 'Shared' }}	{{ tier.description }}

Showing {{ paginationBounds('pricingTiers').from }}-{{ paginationBounds('pricingTiers').to }} of {{ tableMeta.pricingTiers.total }}

Page {{ tableMeta.pricingTiers.page }} of {{ tableMeta.pricingTiers.pages }}

category

tag

touch_app

person

search

date_range

ID	Entity Type	Entity Name	Action	User	Date & Time	Actions
{{ log.id }}	{{ log.entity_type === 'project' ? 'domain' : log.entity_type === 'strategy' ? 'hub' : log.entity_type === 'rule' ? 'rule' : log.entity_type === 'single_rule' ? 'rule_folder' : 'shield' }} {{ log.entity_type === 'single_rule' ? 'single rule' : log.entity_type }}	{{ log.entity_name }}	{{ log.action_type === 'create' ? 'add_circle' : log.action_type === 'delete' ? 'delete' : 'edit' }} {{ log.action_type }}	person {{ log.user_name \|\| 'Unknown' }}	{{ formatDateTime(log.created_at) }}
No log entries found.

Showing {{ setupLogMeta.from }}-{{ setupLogMeta.to }} of {{ setupLogMeta.total }}

Page {{ setupLogMeta.page }} of {{ setupLogMeta.pages }}

Field	Old Value	New Value
{{ field }}	{{ formatValue(change.old) }}	{{ formatValue(change.new) }}

ID	API Key	Endpoint	Method	Status	IP Address	User Agent	Date & Time
{{ log.id }}	{{ log.api_key_prefix \|\| 'N/A' }}	{{ log.endpoint }}	{{ log.method }}	{{ log.status_code }}	{{ log.ip_address }}	{{ log.user_agent \|\| '-' }}	{{ formatDateTime(log.created_at) }}
No API key usage logs found.

Showing {{ apiKeyLogsMeta.from }}-{{ apiKeyLogsMeta.to }} of {{ apiKeyLogsMeta.total }}

Page {{ apiKeyLogsMeta.page }} of {{ apiKeyLogsMeta.pages }}

Loading sales data...

Crunching numbers 📊

error {{ salesAnalytics.error }}

🏢 Domain: 🏆 Period: Sort by:

Total: {{ formatNumber(salesAnalytics.topProducts.totals.total_quantity) }} items | €{{ formatNumber(salesAnalytics.topProducts.totals.total_revenue_eur, 0) }} revenue

Loading top products...

#	Product ID	Product Name	Domain	Qty	Orders	Revenue €	Avg Price €	Margin €	Margin %	Last Sale	Actions
{{ index + 1 }}	{{ product.product_id }}	{{ product.product_name \|\| '-' }}	{{ product.domain }}	{{ formatNumber(product.total_quantity) }}	{{ formatNumber(product.order_count) }}	€{{ formatNumber(product.total_revenue_eur, 2) }}	€{{ formatNumber(product.avg_price_eur, 2) }}	€{{ formatNumber(product.total_margin_eur, 2) }}	{{ product.margin_percent }}%	{{ product.last_sale_date }}	bug_report

inventory_2

No products found for the selected period.

📦 Total Orders

💰 Revenue (incl. VAT)

€{{ formatNumber(salesAnalytics.summary.total_revenue || 0, 2) }}

💵 Revenue (excl. VAT)

€{{ formatNumber(salesAnalytics.summary.total_revenue_novat || 0, 2) }}

📋 Total Items

🛒 Total Cost

€{{ formatNumber(salesAnalytics.summary.total_cost || 0, 2) }}

📊 Gross Margin

€{{ formatNumber(salesAnalytics.summary.total_margin || 0, 2) }}

📈 Margin %

{{ salesAnalytics.summary.margin_percent || 0 }}%

💰 Left on Table (31d)

€{{ formatNumber(salesAnalytics.missedRevenue.summary?.last_31_days?.left_on_table || 0, 0) }}

{{ salesAnalytics.missedRevenue.summary?.last_31_days?.cheaper_count || 0 }} orders

📉 Position Penalty (31d)

€{{ formatNumber(salesAnalytics.missedRevenue.summary?.last_31_days?.position_penalty || 0, 0) }}

{{ salesAnalytics.missedRevenue.summary?.last_31_days?.expensive_count || 0 }} orders

Loading revenue data...

domain_disabled

No domain data found for the selected period.

Domain	Orders	Revenue	Rev. (excl. VAT)	Cost	Margin	Margin %	Missed €
{{ domain.domain }}	{{ formatNumber(domain.order_count) }}	€{{ formatNumber(domain.revenue, 2) }}	€{{ formatNumber(domain.revenue_novat, 2) }}	€{{ formatNumber(domain.cost, 2) }}	€{{ formatNumber(domain.margin, 2) }}	{{ domain.margin_percent }}%	€{{ formatNumber(getDomainMissedRevenue(domain.domain), 0) }} -
TOTAL ({{ salesAnalytics.domainStats.length }} domains)	{{ formatNumber(salesAnalytics.domainStats.reduce((a, b) => a + b.order_count, 0)) }}	€{{ formatNumber(salesAnalytics.domainStats.reduce((a, b) => a + b.revenue, 0), 2) }}	€{{ formatNumber(salesAnalytics.domainStats.reduce((a, b) => a + b.revenue_novat, 0), 2) }}	€{{ formatNumber(salesAnalytics.domainStats.reduce((a, b) => a + b.cost, 0), 2) }}	€{{ formatNumber(salesAnalytics.domainStats.reduce((a, b) => a + b.margin, 0), 2) }}	{{ salesAnalytics.summary.margin_percent \|\| 0 }}%	€{{ formatNumber(salesAnalytics.missedRevenue.summary?.last_31_days?.missed_revenue_lowest \|\| 0, 0) }}

💰 Left on Table (31d)

... {{ morphLeftOnTable31d }}

{{ salesAnalytics.missedRevenue.summary?.last_31_days?.cheaper_count || 0 }} orders ({{ calcOrderPercent('cheaper') }}%) where we're CHEAPER
= sum of (lowestPrice − ourPrice)

📉 Position Penalty (31d)

... {{ morphPositionPenalty31d }}

{{ salesAnalytics.missedRevenue.summary?.last_31_days?.expensive_count || 0 }} orders ({{ calcOrderPercent('expensive') }}%) where we're EXPENSIVE
= €{{ formatNumber(salesAnalytics.missedRevenue.summary?.last_31_days?.total_price_diff || 0, 0) }} price diff × 25%

📊 Today

... {{ morphToday }}

💰 €{{ formatNumber(salesAnalytics.missedRevenue.summary?.today?.left_on_table || 0, 0) }} | 📉 €{{ formatNumber(salesAnalytics.missedRevenue.summary?.today?.position_penalty || 0, 0) }}

📈 Last 7 Days

... {{ morphLast7Days }}

💰 €{{ formatNumber(salesAnalytics.missedRevenue.summary?.last_7_days?.left_on_table || 0, 0) }} | 📉 €{{ formatNumber(salesAnalytics.missedRevenue.summary?.last_7_days?.position_penalty || 0, 0) }}

📉 Last 31 Days

... {{ morphLast31Days }}

💰 €{{ formatNumber(salesAnalytics.missedRevenue.summary?.last_31_days?.left_on_table || 0, 0) }} | 📉 €{{ formatNumber(salesAnalytics.missedRevenue.summary?.last_31_days?.position_penalty || 0, 0) }}

🔄 Live Feed

● Auto-refresh ON ● Paused

🔴 Live Feed {{ salesAnalytics.missedRevenue.showOnlyMissed ? '🎯 Only with competitors (red + green)' : '📋 Show all orders' }}

{{ salesAnalytics.missedRevenue.soundEnabled ? '🔊' : '🔇' }} Auto-refresh

Loading live feed with competitor analysis...

Time	Order	Product	Domain	Our Price	Lowest Comp.	Median	Diff (Lowest)	Missed €	Compare
{{ formatDateTime(item.datum) }}	{{ item.ordernumber \|\| item.oid }}	{{ item.product }}	{{ item.domain }}	{{ item.currency === 'EUR' ? '€' : item.currency }}{{ formatNumber(item.sale_price, 2) }}	{{ item.currency === 'EUR' ? '€' : item.currency }}{{ formatNumber(item.lowest_competitor, 2) }} -	{{ item.currency === 'EUR' ? '€' : item.currency }}{{ formatNumber(item.median_competitor, 2) }} -	{{ item.diff_to_lowest > 0 ? '+' : '' }}{{ formatNumber(item.diff_to_lowest, 2) }} -	€{{ formatNumber(item.missed_revenue, 2) }} ✓ Best -	🔗 Compare {{ item.competitor_count }} comps -
No orders with competitor data found. Try increasing the record limit or uncheck the filter. No recent orders with competitor data found.

📉 Daily Missed Revenue (EUR) Total: €{{ formatNumber(salesAnalytics.missedRevenueDaily.reduce((a, b) => a + b.missed_eur, 0), 0) }}

Date	Orders	Items	Revenue	Rev. (excl. VAT)	Cost	Margin	Margin %	Missed €
{{ day.date }}	{{ formatNumber(day.order_count) }}	{{ formatNumber(day.item_count) }}	€{{ formatNumber(day.revenue, 2) }}	€{{ formatNumber(day.revenue_novat, 2) }}	€{{ formatNumber(day.cost, 2) }}	€{{ formatNumber(day.margin, 2) }}	{{ day.margin_percent }}%	€{{ formatNumber(getMissedForDate(day.date), 0) }} -
No data for selected period.

Last 100 orders, sorted by date descending

Loading orders...

Date/Time	Order ID	Domain	Items	Total	Cost	Margin	Missed €	Status
{{ formatDateTime(order.datum) }}	{{ order.oid }}	{{ order.domain }}	{{ order.item_count }}	€{{ formatNumber(order.order_total, 2) }}	€{{ formatNumber(order.total_cost, 2) }}	€{{ formatNumber(order.margin, 2) }} ({{ order.margin_percent }}%)	€{{ formatNumber(order.missed_revenue, 2) }} -	{{ order.status_label }}
No orders found.

🏢 Domain: 🏆 Period: Sort by:

Total: {{ formatNumber(salesAnalytics.topProducts.totals.total_quantity) }} items | €{{ formatNumber(salesAnalytics.topProducts.totals.total_revenue_eur, 0) }} revenue

Loading top products...

#	Product ID	Product Name	Domain	Qty	Orders	Revenue €	Avg Price €	Margin €	Margin %	Last Sale	Actions
{{ index + 1 }}	{{ product.product_id }}	{{ product.product_name \|\| '-' }}	{{ product.domain }}	{{ formatNumber(product.total_quantity) }}	{{ formatNumber(product.order_count) }}	€{{ formatNumber(product.total_revenue_eur, 2) }}	€{{ formatNumber(product.avg_price_eur, 2) }}	€{{ formatNumber(product.total_margin_eur, 2) }}	{{ product.margin_percent }}%	{{ formatDateTime(product.last_sale) }}	🔧 Debug -
No products found for the selected period.

Domain: {{ salesAnalytics.orderDetail.order?.domain }}

Date: {{ formatDateTime(salesAnalytics.orderDetail.order?.datum) }}

Status: {{ salesAnalytics.orderDetail.order?.status }}

Payment: {{ salesAnalytics.orderDetail.order?.source }}

Currency: {{ salesAnalytics.orderDetail.order?.cur }}

Partner: {{ salesAnalytics.orderDetail.order?.partner }}

Order Items

Product ID	RegCIS	Qty	Price/unit	Total	Buy Price	Margin
{{ item.product }}	{{ item.regcis }}	{{ item.ks }}	€{{ formatNumber(item.priceks, 2) }}	€{{ formatNumber(item.price, 2) }}	€{{ formatNumber(item.buy_price, 2) }}	€{{ formatNumber(item.margin, 2) }} ({{ item.margin_percent }}%)
TOTALS				€{{ formatNumber(salesAnalytics.orderDetail.summary?.total_revenue, 2) }}	€{{ formatNumber(salesAnalytics.orderDetail.summary?.total_cost, 2) }}	€{{ formatNumber(salesAnalytics.orderDetail.summary?.total_margin, 2) }} ({{ salesAnalytics.orderDetail.summary?.margin_percent }}%)

							Actions
{{ tier.tier_name }}	{{ tier.project_domain \|\| 'Shared' }}	{{ displayNumber(tier.price_100) }}	{{ displayNumber(tier.price_200) }}	{{ displayNumber(tier.price_300) }}	{{ displayNumber(tier.price_400) }}	{{ displayNumber(tier.price_10000) }}

Showing {{ paginationBounds('marginLevels').from }}-{{ paginationBounds('marginLevels').to }} of {{ tableMeta.marginLevels.total }}

Page {{ tableMeta.marginLevels.page }} of {{ tableMeta.marginLevels.pages }}

					Actions
{{ route.name }}	{{ route.route \|\| 'N/A' }}	{{ route.description \|\| 'N/A' }}	{{ route.endpoint_url \|\| 'N/A' }}	{{ route.is_active ? 'Active' : 'Inactive' }}

Showing {{ paginationBounds('pricingRoutes').from }}-{{ paginationBounds('pricingRoutes').to }} of {{ tableMeta.pricingRoutes.total }}

Page {{ tableMeta.pricingRoutes.page }} of {{ tableMeta.pricingRoutes.pages }}

label

No dynamic tags found

Click "New Dynamic Tag" to create a tag that will be assigned to products matching a filter expression

{{ state.selectedItems.dynamicTags.length }} dynamic tag(s) selected

	Order	{{ t('tableSort.dynamicTags.name') }}	{{ t('tableSort.dynamicTags.expression') }}	{{ t('tableSort.dynamicTags.note') }}	{{ t('tableSort.dynamicTags.status') }}	Modified	Actions
		{{ tag.name }}	`{{ truncate(tag.dsl_expression, 80) }}`	{{ tag.note \|\| '-' }}	{{ tag.is_active ? 'Active' : 'Inactive' }}	{{ tag.modified_by }} {{ tag.modified_at ? formatDateTime(tag.modified_at) : '' }} -	history

Page {{ tableMeta.dynamicTags.page }} of {{ tableMeta.dynamicTags.pages }}

download Download Template

{{ selectedRrpItems.length }} items selected

	Date	Domain	Tag	EAN	Abra ID	Price	Currency	Type	User	Active	Actions
	{{ formatDate(item.datum) }}	{{ item.domena \|\| 'N/A' }}	{{ item.tag \|\| '-' }}	{{ item.EAN }}	{{ item.produkt }}	{{ item.cena }}	{{ item.mena \|\| 'CZK' }}	lock {{ item.typ === 'fixed' ? 'Fixed Price' : (item.typ === 'rrp' ? 'RRP' : 'Manual') }}	{{ item.user \|\| item.uzivatel \|\| 'N/A' }}	{{ item.aktivni == 1 ? 'Active' : 'Inactive' }}

Import RRP Data from XLSX

Step 1: Select Import Options

Import Mode:

?

Update/Insert (Safe)

Updates existing prices by Product ID and Type. Adds new ones. Keeps other existing records.

Replace All (Dangerous)

Deletes ALL existing records and imports new data. Cannot be undone!

Note: Your file can contain both RRP and Fixed prices (use 'type' column: rrp/fixed)

cloud_upload

Click to select XLSX file or drag & drop

Supported formats: .xlsx, .xls

description {{ selectedRrpFile.name }} Processing... {{ state.rrpDatabase.error }} Ready for column mapping

Analyzing Excel file...

Step 2: Map Columns to Database Fields

{{ state.rrpDatabase.totalRows || 0 }} rows detected in Excel file

No columns detected - please check Excel file format

{{ state.rrpDatabase.fileColumns.length }} columns found

Found columns: {{ column.name }},

No columns detected

The Excel file appears to be empty or doesn't have a proper header row. Please ensure:

The first row contains column headers
The file is in .xlsx or .xls format
The file is not corrupted

{{ fieldLabel }} *

Import Preview - First 10 Products

Total: {{ state.rrpDatabase.previewData.length }} RRP: {{ state.rrpDatabase.previewData.filter(row => !row.type || row.type === 'rrp').length }} Fixed: {{ state.rrpDatabase.previewData.filter(row => row.type === 'fixed').length }} Will Create: {{ state.rrpDatabase.previewData.filter(row => row._exists && row._exists.action === 'create').length }} Will Update: {{ state.rrpDatabase.previewData.filter(row => row._exists && row._exists.action === 'update').length }}

Product Name	EAN/ID	Domain	Price	Type	Tag	Action
{{ row.name \|\| '-' }} ? Has validation errors	`{{ row.product_id \|\| '-' }}`	{{ row.domena \|\| '-' }}	{{ row.price \|\| '-' }} {{ row.currency }}	lock {{ row.type === 'fixed' ? 'Fixed' : 'RRP' }}	{{ row.tag \|\| '-' }}	{{ row._exists.action === 'update' ? 'Will Update' : row._exists.action === 'create' ? 'Will Create' : row._exists.action === 'verify' ? 'Needs Review' : '-' }} {{ row._exists.reason }}

Status Legend: Found in DB = Product exists, will update ? Similar Found = Similar product found, verify before import ? New Product = Will create as new product

RRP Prices Detected - Create Rules?

Import prices only Save pricing data to database without creating rules Import prices + Create single rules from RRP Automatically create/update pricing rules from RRP data (rules will be inactive by default)

info

Only Fixed Prices Detected

Your import contains only fixed prices. These will be imported directly without creating rules.

Single Rules Preview

What will happen:

Import prices to database
Automatically create/update single pricing rules from RRP data (Fixed prices won't create rules)
Rules will be grouped by Tag + Domain combinations
All rules will be created in inactive state for safety
? You can activate and configure them in Single Rules section after import

Rule Strategy: RRP-based pricing

Estimated Rules: {{ new Set(state.rrpDatabase.previewData.filter(row => (!row.type || row.type === 'rrp') && row.tag && row.domena).map(row => row.tag + '|' + row.domena)).size }} rules (based on unique Tag + Domain combinations from RRP data)

Step 3: Import Complete

Successfully imported {{ rrpImportResult?.imported || 0 }} RRP records.

Single Rules Created/Updated:

{{ rule.action === 'created' ? 'Created' : 'Updated' }} rule "{{ rule.tag }}" ({{ rule.product_count }} products, {{ rule.sale_percent }}% discount) - Global

edit Edit Rule

All rules are inactive by default. Activate them in Single Rules section.

? RRP prices imported successfully. No single rules were created.

Single Rules Creation Warning

RRP prices were imported successfully, but there was an issue creating single rules:

{{ rrpImportResult.single_rules_error }}

Project / Domain* Product ID* Limit (max 100)

Short term (recent) Long term (history)

bug_report Debug Console

link GET {{ productLogEndpointPreview }}

error {{ productLogs.error }}

Loading product logs...

Entries: {{ productLogs.meta.count }}

Source: {{ productLogs.meta.scope === 'long' ? 'BigQuery history' : 'MySQL recent logs' }}

Domain: {{ productLogs.meta.domain }}

Limit: {{ productLogs.meta.limit }}

Fetched: {{ productLogs.meta.retrieved_at }}

Open endpoint

Average sell {{ formatCurrency(productLogStats.avgSell, productLogStats.currency) }}

Average buy {{ formatCurrency(productLogStats.avgBuy, productLogStats.currency) }}

Average margin {{ formatPercent(productLogStats.avgMargin) }}

Latest entry {{ productLogStats.latestAt }}

Price & Margin Timeline

Processed	Domain	Warehouse	Buy (w/o VAT)	Sell (with VAT)	Margin %	Strategy	Competition	Note	Debug	Explain
{{ row.processed_at \|\| row.recorded_at \|\| '--' }}	{{ row.domain \|\| productLogs.meta.domain \|\| '--' }}	{{ row.warehouse_id \|\| row.wh \|\| row.pricelist \|\| '--' }}	{{ formatCurrency(row.buy_price_without_vat \|\| row.buy_without_vat \|\| row.buy_price_with_vat \|\| row.buy, productLogs.meta.currency) }}	{{ formatCurrency(row.final_price_with_vat \|\| row.price_with_vat \|\| row.price, productLogs.meta.currency) }}	{{ formatPercent(row.margin_percentage \|\| row.margin) }}	{{ row.strategy_used \|\| row.strategy \|\| '--' }}	{{ row.competition_count !== undefined && row.competition_count !== null ? row.competition_count : '--' }}

Date	Buy (CZK)	Sell (CZK)	Margin %	Warehouse	Note	Explain
{{ row.datum \|\| '--' }}	{{ formatCurrency(row.cbuy \|\| row.buy, 'CZK') }}	{{ formatCurrency(row.cprice \|\| row.price, 'CZK') }}	{{ formatPercent(row.margin) }}	{{ row.wh \|\| '--' }}

Showing {{ displayRows.length }} BigQuery rows (limit {{ productLogs.meta.limit }}).

info No log records found for the current selection.

Debug details

{{ productLogDiagnostics.json }}

Date: {{ productLogExplanation.currentRow.processed_at || productLogExplanation.currentRow.datum || '--' }} Product: {{ productLogs.productId }} Domain: {{ productLogExplanation.currentRow.domain || productLogs.meta?.domain || '--' }}

Buy: {{ formatCurrency(productLogExplanation.currentRow.buy_price_without_vat || productLogExplanation.currentRow.buy || productLogExplanation.currentRow.cbuy, productLogs.meta?.currency || 'CZK') }} Sell: {{ formatCurrency(productLogExplanation.currentRow.final_price_with_vat || productLogExplanation.currentRow.price_with_vat || productLogExplanation.currentRow.price || productLogExplanation.currentRow.cprice, productLogs.meta?.currency || 'CZK') }} Margin: {{ formatPercent(productLogExplanation.currentRow.margin_percentage || productLogExplanation.currentRow.margin) }}

Original Note:

edit_note Human Explanation:

Generating AI explanation...

info No explanation yet. Click Edit to add one or generate with AI.

error {{ productLogExplanation.error }}

Product ID* Warehouse Limit (max 500)

link GET {{ globalProductLogEndpointPreview }}

error {{ globalProductLogs.error }}

Loading global product logs...

Entries: {{ globalProductLogs.meta.count }}

Product ID: {{ globalProductLogs.meta.product_id }}

Warehouse: {{ globalProductLogs.meta.warehouse }}

Limit: {{ globalProductLogs.meta.limit }}

Fetched: {{ globalProductLogs.meta.retrieved_at }}

Open endpoint

Recorded	Project	Warehouse	Buy Price	Sell Price	Margin	Strategy
{{ row.recorded_at \|\| '--' }}	{{ row.domain \|\| '--' }}	{{ row.warehouse \|\| row.wh \|\| '--' }}	{{ formatCurrency(row.buy \|\| row.buy_price_without_vat \|\| row.buy_price_with_vat, (globalProductLogs.meta && globalProductLogs.meta.currency) \|\| 'CZK') }}	{{ formatCurrency(row.price_with_vat \|\| row.price \|\| row.price_without_vat, (globalProductLogs.meta && globalProductLogs.meta.currency) \|\| 'CZK') }}	{{ formatPercent(row.margin) }}	{{ row.strategy \|\| row.strategy_used \|\| '--' }}

info No global log records found for this product.

Project / Domain* Max Age (days) Limit

filter_list Filters

Product ID Price From Price To EAN / Note

Showing {{ projectLogFilteredRows.length }} of {{ projectLog.rows.length }} records

error {{ projectLog.error }}

Time	Product ID	Buy Price	Price (VAT)	Margin	WH	Note/EAN	Actions
{{ formatDateTime(row.datum \|\| row.processed_at \|\| row.recorded_at) }}	{{ row.dataid \|\| row.product_id }}	{{ (row.buy \|\| row.buy_price_without_vat) ? formatPrice(row.buy \|\| row.buy_price_without_vat) : '-' }}	{{ row.price ? formatPrice(row.price) : (row.final_price_with_vat ? formatPrice(row.final_price_with_vat) : '-') }}	{{ (row.margin ?? row.margin_percentage).toFixed(1) }}% -	{{ row.wh \|\| row.warehouse \|\| '-' }}	{{ row.pozn \|\| row.note \|\| '-' }}	assignment bug_report

Showing first 200 of {{ projectLogFilteredRows.length }} filtered records. Use filters to narrow down results.

info No repricing logs found for this project in the last {{ projectLog.maxAge }} days.

Enabled Products

Products assigned to domains in product_website table - these can be repriced

analytics Products per Domain (filtered: {{ enabledProducts.domain }})

Domain	Total Products	Actions
{{ stat.domain }}	{{ (stat.total \|\| 0).toLocaleString() }}	visibility
Total ({{ enabledProducts.statsSummary?.domains_count \|\| 0 }} domains)	{{ (enabledProducts.statsSummary?.total_products \|\| 0).toLocaleString() }}

Domain Search (ID, EAN, Name) Limit In stock only

Showing {{ enabledProducts.rows.length }} of {{ enabledProducts.total }} products. More results available with specific filters.

error {{ enabledProducts.error }}

ID	Product ID {{ enabledProducts.sortDir === 'asc' ? 'arrow_upward' : 'arrow_downward' }}	Product Name {{ enabledProducts.sortDir === 'asc' ? 'arrow_upward' : 'arrow_downward' }}	Domain	Stock {{ enabledProducts.sortDir === 'asc' ? 'arrow_upward' : 'arrow_downward' }}	Added {{ enabledProducts.sortDir === 'asc' ? 'arrow_upward' : 'arrow_downward' }}	Actions
{{ row.id }}	{{ row.product }}	{{ row.product_name \|\| '-' }}	{{ row.domain }}	{{ row.quantity \|\| 0 }}	{{ formatDateTime(row.datum) }}	bug_report assignment

inbox

No products found for the selected criteria.

Project / Domain* Product ID* Strategy*

{{ repricingDebug.strategies.length }} strategies loaded.

error {{ repricingDebug.strategyError }}

error {{ repricingDebug.submitError }}

history Product Log

refresh Force data refresh (data cached 24h, DSL always fresh)

{{ repricingDebug.repriceResult.data_used.basic_data?.nazev_produktu || 'Product details' }} open_in_new

Sell (excl. VAT) {{ repricingDebugSummary.previousPriceWithoutVatFormatted }} {{ repricingDebugSummary.sellWithoutVatFormatted }} Sell (incl. VAT) {{ repricingDebugSummary.previousPriceWithVatFormatted }} {{ repricingDebugSummary.sellWithVatFormatted }} Margin {{ repricingDebugSummary.marginFormatted }} Markup {{ repricingDebugSummary.markupFormatted }}

{{ tag.severity === 'warning' ? 'warning' : tag.severity === 'error' ? 'error' : tag.severity === 'success' ? 'check_circle' : 'label' }} {{ tag.tag }}

Product ID {{ repricingDebug.repriceResult.data_used.basic_data.id }} RegCIS {{ repricingDebug.repriceResult.data_used.basic_data.regcis }} open_in_new Brand {{ repricingDebug.repriceResult.data_used.basic_data.brand }} Price Buy {{ formatCurrency(repricingDebug.repriceResult.data_used.basic_data.price_buy, repricingDebug.repriceResult.final_price?.currency || 'CZK') }} Warehouse {{ repricingDebug.repriceResult.data_used.basic_data.warehouse }} Warehouse Cnt {{ repricingDebug.repriceResult.data_used.basic_data.warehouse_cnt }} Sell (excl. VAT) {{ repricingDebugSummary.sellWithoutVatFormatted }} VAT {{ repricingDebugSummary.vatPercentFormatted }} Orders (30d) {{ repricingDebug.repriceResult.data_used.basic_data.orders_last_month }}

storefront Competition Prices ({{ repricingDebug.repriceResult.data_used.competition_prices.length }})

{{ comp.domain.toUpperCase() }} ↗ {{ formatCurrency(comp.price || (comp.price_with_vat / 1.2), repricingDebug.repriceResult.final_price?.currency || 'EUR') }} ({{ formatCurrency(comp.price_with_vat || (comp.price * 1.2), repricingDebug.repriceResult.final_price?.currency || 'EUR') }} incl.)

Strategy Overview

{{ strategy.applies === true ? 'play_circle' : 'pause_circle' }} {{ strategy.name }}

{{ strategy.active ? 'Active' : 'Inactive' }} {{ strategy.rules_matched }}/{{ strategy.rules_total }} rules match

Rules for {{ selectedRepricingStrategy.name }}

#	Name	Status	Filter result	Expression
{{ rule.priority \|\| '-' }}	{{ rule.name }}	{{ rule.active ? 'Active' : 'Inactive' }}	{{ rule.matched ? 'Matched' : 'Not matched' }}	`{{ rule.dsl_expression \|\| '-' }}`

DSL Variables Available

{{ Object.keys(filteredDslVariables.used).length + Object.keys(filteredDslVariables.unused).length }} / {{ Object.keys(repricingDebug.repriceResult.dsl_variables_available).length }} variables {{ Object.keys(filteredDslVariables.used).length }} used / {{ Object.keys(filteredDslVariables.unused).length }} unused

search

search_off No variables match "{{ repricingDebug.dslVariablesFilter }}"

Repricing Output

error {{ repricingDebug.repriceError }}

psychology

🤖 AI Price Explanation

terminal

Detailed Execution Log

Step-by-step repricing process

Structured JSON (data_used)

{{ JSON.stringify(repricingDebug.repriceResult.data_used, null, 2) }}

info No repricing output captured.

Last run: {{ repricingDebug.lastRunAt }}

link GET Product Data: {{ repricingDebugProductEndpointPreview }}

link GET Go Price: {{ repricingDebugGoPriceEndpointPreview }}

link GET Prepare Data: {{ repricingDebugPreparedataEndpointPreview }}

science

Reprice Simulate API

Test repricing with custom JSON data without using database. Send your own product data and get full execution log.

api API Docs

ID	Name	API Key	Domain	Endpoint Prefix	Last Used	Created	Actions
{{ key.id }}	{{ key.key_name }}	{{ key.api_key_display }}	{{ key.domain }} All domains	{{ key.endpoint_prefix }} All endpoints	{{ formatDateTime(key.last_used_at) }} Never	{{ formatDateTime(key.created_at) }}
No API keys found. Click "Create API Key" to add one.

Upload Date	Domain	Action	File Name	Status
hourglass_empty Loading PLA feeds...
error Error loading feeds: {{ state.plaFeeds.error }}
folder_open No PLA feeds uploaded yet. Use the "Upload New PLA Feed" button to get started.
{{ formatDate(feed.datum) }}	{{ feed.domain \|\| 'N/A' }}	{{ feed.action \|\| 'N/A' }}	{{ feed.filename \|\| 'N/A' }}	{{ feed.processed === 'processed' ? 'Processed' : 'Pending' }}

					Data Size	Actions
Loading cache data...
error Error loading cache data {{ state.productsCache.error }}
cached No cached products found
{{ formatDateTime(row.cache_date) }} {{ formatTimeAgo(row.cache_date) }}	{{ row.domain }}	{{ row.product_id }}	{{ row.product_name \|\| 'N/A' }}	{{ formatCurrency(row.final_price, row.currency \|\| 'CZK') }} N/A	{{ formatBytes(row.data_size) }}	bug_report assignment

Login to Admin Panel

{{ getPageDescription(activeTab).title }}

Configuration Overview

history Setup Log Entry #{{ setupLogDetailModal.data.id }}

compare_arrows Changes Summary

remove_circle Previous State

add_circle New State

API Key Usage Logs

📈 Sales Analytics

🏆 Top Products

📉 Daily Missed Revenue (EUR) Total: €{{ formatNumber(salesAnalytics.missedRevenueDaily.reduce((a, b) => a + b.missed_eur, 0), 0) }}

Order Detail: {{ salesAnalytics.orderDetail?.order?.oid }}

Order Items

Import RRP Data from XLSX

Step 1: Select Import Options

Import Mode:

Step 2: Map Columns to Database Fields

No columns detected

Import Preview - First 10 Products

RRP Prices Detected - Create Rules?

Single Rules Preview

Step 3: Import Complete

Single Rules Created/Updated:

Single Rules Creation Warning

Product Repricing Logs

Price & Margin Timeline

Debug details

psychology Log Entry Explanation

Original Note:

edit_note Human Explanation:

Global Product Logs

Project Repricing Log

filter_list Filters

Enabled Products

analytics Products per Domain (filtered: {{ enabledProducts.domain }})

Repricing Debug Console

{{ repricingDebug.repriceResult.data_used.basic_data?.nazev_produktu || 'Product details' }} open_in_new {{ repricingDebug.repriceResult.data_used.basic_data?.nazev_produktu || 'Product details' }}

storefront Competition Prices ({{ repricingDebug.repriceResult.data_used.competition_prices.length }})

Strategy Overview

Rules for {{ selectedRepricingStrategy.name }}

DSL Variables Available

Repricing Output

🤖 AI Price Explanation

Detailed Execution Log

Reprice Simulate API

User Management

API Keys Management

{{ apiKeyModal.isNew ? 'Create New API Key' : 'API Key Details' }}

Data Export/Import

Export Data

Import Data

Clone Project

Installation Health

System Diagnostics

Diagnostic Tools

PLA Feeds Management

Available Actions

Recent PLA Feeds

{{ editor.isNew ? 'Create' : 'Edit' }} {{ labelFor(editor.type) }}

auto_awesome Generate DSL Rule with AI

check_circle Generated DSL Expression ? Auto-applied to editor

info Explanation

science Test Result

shield Recommended Guardrails

Test Rule with Product Data

DSL Command Reference

Basic Operations

Competition Pricing

Conditional Logic

Variable Existence & Safety

Smart Pricing Templates with Guardrails

🏆 Be Cheapest on Market

💎 Cheapest for Premium Brands (Nina Ricci, Chloé)

Match Competition Median

Premium Positioning (Top 25%)

Dynamic Stock-Based Pricing

Match Competition Average

Fixed 30% Margin (Safe)

💱 Undercut by 50 Kč (Currency-Aware)

💱 Price with Min/Max Limits (200-2000 Kč)

{{ repricingDebug.repriceResult.data_used.basic_data?.nazev_produktu || 'Product details' }} open_in_new