Create Price Markup based on Categories. [SOLVED]
Posted: Sat Sep 09, 2023 1:41 am
Hi Folks
Looking for a module where I can specify a markup number (example 1.10) in Category and then all products that belong to that category would show a price of base price * Markup number = displayed selling price.
I am NOT looking at changing the prices in the products table. I just want to show the price to the visitors/customers on the site.
However the price shown is based on the product table price plus a percentage (markup) that is indicated in the Categories.
EXAMPLE:
Let's says Product A is part of Category 1
The Product A price in the product table is 100$
Somewhere in Categories, maybe under the DATA tab, I would have a field called "Markup"
So for Category 1 under DATA TAB in MARKUP, I enter 1.10
In our case, a product can only be part of one sub-category. We sell NGK Products (automotive spark plugs, ignition).
Example
Top Category NGK Spark Plugs
Sub-Category NGK Spark Plugs - NGK Laser Platinum
Sub-Category NGK Spark Plugs - NGK Standard
Sub-Category NGK Spark Plugs - NGK Laser Iridium
Sub-Category NGK Spark Plugs - NGK Racing
etc.
So for Product A it would only be one of the Sub-Category, like NGK Laser Iridium
So on the site, when a customer looks up Product A, it would show selling price of 110$ (100 * 1.10)
So basically is there a way to enter a field in Categories where we enter a number (example 1.10, 1.05, 0.85 or leave blank, etc)
Then opencart would use product table price * the MARKUP number entered in the Category Table.
I found this in Marketplace, but it is based on Customer Groups. I basically would need something like that but based on the Products Category.
https://www.opencart.com/index.php?rout ... p%20prices
Thank you.
Frank V.
Looking for a module where I can specify a markup number (example 1.10) in Category and then all products that belong to that category would show a price of base price * Markup number = displayed selling price.
I am NOT looking at changing the prices in the products table. I just want to show the price to the visitors/customers on the site.
However the price shown is based on the product table price plus a percentage (markup) that is indicated in the Categories.
EXAMPLE:
Let's says Product A is part of Category 1
The Product A price in the product table is 100$
Somewhere in Categories, maybe under the DATA tab, I would have a field called "Markup"
So for Category 1 under DATA TAB in MARKUP, I enter 1.10
In our case, a product can only be part of one sub-category. We sell NGK Products (automotive spark plugs, ignition).
Example
Top Category NGK Spark Plugs
Sub-Category NGK Spark Plugs - NGK Laser Platinum
Sub-Category NGK Spark Plugs - NGK Standard
Sub-Category NGK Spark Plugs - NGK Laser Iridium
Sub-Category NGK Spark Plugs - NGK Racing
etc.
So for Product A it would only be one of the Sub-Category, like NGK Laser Iridium
So on the site, when a customer looks up Product A, it would show selling price of 110$ (100 * 1.10)
So basically is there a way to enter a field in Categories where we enter a number (example 1.10, 1.05, 0.85 or leave blank, etc)
Then opencart would use product table price * the MARKUP number entered in the Category Table.
I found this in Marketplace, but it is based on Customer Groups. I basically would need something like that but based on the Products Category.
https://www.opencart.com/index.php?rout ... p%20prices
Thank you.
Frank V.