How can I mark up or discount prices?
Marking up an discounting prices in your database or at publication time
There are two ways to markup or discount values in CatBase:
- Use the Search and Replace function to change the prices in the data
- Use a Calculation to do the calculation as the data is published - this method doesn't change the data in the database, only the data that is published
- Find the records you want to modify (click on the Find Data button)
- With the list of records displayed, click on the search & Replace button at the top of the window
- Select the field you want to modify
- Select All Records in the Change from area
- Select either the Markup by or Discount by radio button and enter the percentage to change the values by
- Click OK
- In a Paragraph your Publishing Style Sheet, create an Element and choose the Element type: Calculation
- Choose either the Markup or Discount radio button
- Enter the markup or discount percentage
- Save the Calculation
Using Search and Replace to change the data in the database
Use a Calculation to do the calculation as the data is published
You can create a Calculation type Element in your Publishing Style Sheet to mark up or discount the prices when you publish your data. This only affects the published data - the data in the database isn't changed.
For more information about Publishing Style Sheets, see our Publishing Style Sheets Tutorial
Did this article answer your question?
If it didn't, please use the Contact form to ask us! Or simply send an email to support@catbase.com.