Price Markups

Marlin GTX enables complex product prices to be automatically updated using markups.

A markup can be either an amount or a percentage that is added to an item’s normal cost, special cost, last cost, supplier list, or average cost.

Markup groups contain calculation rules such as amount or percentage, base cost, ranges and rounding.

Markup sets brings the different markup groups together (one per price type) into a single structure that can then be assigned to individual products, product groups and product supergroups.

These prices are then automatically applied when adding products to orders and invoices.

Markup Groups

Markup groups need to be added first, because they are used to build markup sets.

They define the dollar amounts or percentages by which prices are calculated.

Cost ranges can also be assigned to markup groups so that the markup added to an item depends on its cost.

Markup groups can be viewed and edited by selecting System > System Files > Products > Markup Groups from the menu bar.

Adding Markup Groups

System > System Files > Products > Markup Groups

New markup groups can be added by clicking on the Add button at the top of the Markup Groups window.

The Add Markup window will open.

In the Details tab:

• Enter a unique Code and Name to identify the markup.
• Base Price with SOH: Starting cost for calculating prices for products with stock on hand
• Base Price no SOH: Starting cost for calculating prices for products without stock on hand
• Amount:
  • If cost ranges will not be used: Enter dollar amount or percentage to be added to the starting cost
  • If cost ranges will be used Leave blank
• Calculation Method: Select whether the amount should be applied as a percentage, added as a dollar mount or as a percentage of the gross profit margin

It would make a lot more sense if this came before the amount part - add a ticket?

• Rounding Type: Select up, down or none
• Rounding Amount: Enter the amount to round to using the method selected above
  • Example: To round to the nearest 10 dollars, enter "10"

Cost ranges can also be assigned to markup groups so that the markup added to an item depends on its cost.

Cost Ranges

System > System Files > Products > Markup Groups > [Markup Group]

Cost ranges can be added to markup group by clicking on the Add button above the Cost Ranges list at the bottom of its Details tab.

The Add Cost range pop-up will open.

In the pop-up:

• Enter the Maximum Cost to define the range
• Enter the Markup Amount to apply to all costs below that amount
  • The fields will be % or $ depending on the Calculation Method selected previously
• Click Ok
• Repeat as required

:::

When you are finished adding Cost ranges, click on the Save button at the top of the module window.

Markup Sets

Markup sets link price types, such as retail or wholesale, to markup groups.

One all-encompassing markup set can be added, or multiple sets can be defined based on product types or brands.

Markup sets can be viewed and edited by selecting System > System Files > Products > Markup Sets from the menu bar.

Adding Markup Sets

System > System Files > Products > Markup Sets

New markup sets can be added by clicking on the Add button at the top of the Markup Sets Maintenance window.

The Add Markup Set window will open.

In the Details tab:

• Enter a unique Code and Name to identify the markup set
• Select a Retail Markup Group and Wholesale Markup Group to apply the set to, as required
• Click Save (top of module)

Markup sets can then be assigned using the methods below.

Assigning Markup Sets to Products

Markup sets can be assigned to individual products, product groups and product supergroups and even multiple products at once.

Individual Products

Markup sets can be assigned to products using maintenance files, which can be accessed by selecting Main > Products > Manage Products from the menu bar.

To assign a product to a markup set:

• Open the product's maintenance file in Edit mode
• Click on the Options tab at the top
• Use the Markup Set picker to select the set
• Click Save (top of module)

You can also assign markup sets to multiple products at once, using product groups and supergroups or bulk file maintenance (for a smaller amount of ungrouped products).

Product Groups

Markup sets can be assigned to product groups by selecting System > System Files > Products > Product Groups from the menu bar.

To assign a product group to a markup set:

• Open the product group in Edit mode
• Use the Markup Set picker to select the set
• Click Save (top of module)

need to write product groups doc

Product Supergroups

Markup sets can be assigned to product supergroups by selecting System > System Files > Products > Product Supergroups from the menu bar.

To assign a product group to a markup set:

• Open the product supergroup in Edit mode
• Use the Markup Set picker to select the set
• Click Save (top of module)

Multiple Products

Markup sets can be assigned to multiple items at once by selecting Tools > Bulk File Operations > Bulk File Maintenance from the menu bar.

The Select Master File window will open:

• Select Stock Master to open the Bulk Maintenance window.

To assign markup sets:

• Define a range of items.
  • Select a method for sorting the items from the Sort By drop-down
  • Press Alt + R to restrict the view and specify the range of items.
    For further assistance: See the Bulk File Maintenance Inform Guide
• Click Remove Columns (bottom left)
  • Click Remove All (bottom left)
  • Tick MarkupSetCode
  • Click Ok

For each item to update:

• Select the lower cell in the MarkupSetCode column and press F4 to select a markup set.
  • Note: You can only scroll the products list using the up and down keyboard arrows
• Repeat as required.
• Click Update (top right)
  • Confirm with Yes.
  • Click Yes or No to export the changes
  • Click OK to close the completion message