This screen is a powerful “spreadsheet-style” tool for managing prices in bulk.
It lets you filter down to the exact set of prices you want, select one or many rows, apply changes across the selection, then validate and save those changes.
It’s designed to make bulk pricing work faster and safer than editing prices one-by-one.
This page will only show you your personal Price Sheets that have already been created.
When you first open this screen, it loads a large amount of pricing data, so it may take a moment to appear—especially if you have a lot of brands and price sheets.
The grid uses “lazy loading” for performance. Check all may only select rows that are currently loaded/visible. If you need to select many rows, filter the grid first, then scroll and continue selecting until everything you need is checked.
Use the filters at the top of the screen to narrow the grid to a manageable set of rows before making changes. Common filters include Supplier, Price type (e.g., Retail), Currency (e.g., USD/CAD), and other attributes shown in your grid.
Making changes
- Filter the grid down to the prices you intend to update (supplier, price type, currency, etc.).
- Select the rows you want to update using the checkboxes.
- Click into the column/field you want to change (for example: margin %, markup, flags, rounding, structured markup).
- Choose how to apply the change (see below), then apply it to your checked rows.
Price Sheet
Name — Editable price sheet name column; changes propagate to selected rows.
Currency
Currency column added (read‑only for now) with future edit rules documented.
For safety, Mecka may prevent changing the currency of a price when that price has members or is referenced by other prices. This avoids breaking dependent pricing when currencies are flipped.
Pricing Type
— Dropdown for pricing type (domain 63) implemented; edit-in-cell loads dropdown on focus for performance.
Percentage
Implemented percentage‑based rule editor and UI; ensures percentage and flat rules are mutually exclusive.
The editor allows for a static change to n value or adjust the value by + or - percent (-2% means 24% goes to 22% and 25% goes to 23%)
• Member count: how many customers currently have this price assigned.
• Reference count: how many other prices depend on this price (for example, using it as a base price).
• B2C: you can only have one B2C price per currency per brand.
• B2B: you can only have one default B2B price per brand (used when adding new customers).
• eBay: the marketplace assignment follows the price’s currency (e.g., CAD → eBay CA, USD → eBay US).
• Amazon: similar to eBay—marketplace/region follows the price’s currency.
• MAP active and Additive pricing active: when enabled, the related behavior becomes active for that price (rules may vary by your configuration).
Rounding and Structured Markup
Rounding
When you check Rounding, a configurator appears so you can choose how rounding should work. Apply the rounding configuration to update all checked rows. To remove rounding, use the Remove option (rather than just unchecking) so it’s clear you intend to remove the configuration.
Structured Markup
When you enable Structured Markup, you can choose a reference price and define ranges/steps as needed. Select your settings and click Apply to update all checked rows. If you need to remove structured markup from selected rows, use the Remove option.
After you have made some changes to the items on the chart, these buttons to Validate or Cancel will appear.
Cancel: discards your in-progress changes and reloads the latest values from the database.
Validate: runs a “mock save” to check for problems. Any validation errors are listed on the screen so you can fix them before saving.
Save (appears after successful validation): persists your changes. Saving may take some time for large updates.
Best practices
- Always filter first before selecting rows or applying changes.
- Validate before you save and review any error list carefully.
- Make one logical change at a time (validate/save), especially when working with large selections.
- Watch member/reference counts before changing fields that may have downstream impact (like currency).
- After saving, allow a few minutes for pricing regeneration to complete before confirming downstream results.
Troubleshooting
- “My change didn’t apply to all rows.” Confirm the rows were checked (and loaded) before applying. With lazy loading, you may need to scroll to load more rows and select them.
- “Save isn’t available.” Run Validate first. If validation errors appear, fix them and validate again.
- “I can’t change the currency.” The price may have members or be referenced by other prices. This is blocked to prevent breaking dependent pricing.
- “The screen is slow / stuck loading.” Apply tighter filters, avoid very fast scrolling, and refresh if needed.
After saving: Mecka may run background processes to regenerate pricing for anything that changed. Your edits can be saved immediately, but downstream regenerated pricing may take a few minutes depending on volume.
Rules and restrictions
Rule: Dollar vs Percent (you can’t use both)
Some pricing rules allow either a dollar operation or a percent operation. The app enforces that you can only use one at a time. If both are set, validation will fail and show an error.
Base / From base may be read-only
Some fields (for example From base) may not be changeable on this screen. These are restricted because changing them safely requires updating multiple linked properties (brand, currency, supplier, references, etc.).
Flags and marketplace behavior
You can toggle flags such as B2C, B2B, eBay, Amazon, and other pricing behaviors. Some flags have rules to prevent conflicting defaults.
