Price Calculator for Product Options

Hello,

We're looking for a solution/proposal to achieve the following:

• Calculate a products price based on a series of product options and the quantity chosen. The unit base price would originate from a series of price discounts based on ordering higher quantities (see the table below).

• We also need a simplified way to administer the base pricing of all of these products (1000 products) if there are future base price changes, either by saving each products base prices with the quantity price breaks in the database for easy exporting and editing or by referencing a spreadsheet that includes the product id, where the price breaks occur and the unit price at each price break which would be referenced when the customer chooses a quantity.

• The starting minimum quantity and the price break points will vary for certain products.

• The options need to function the same way as this site/product: https://bicgraphic.com/CA/euclid-mug-15-oz (Choose " No. I want to see advanced options.")

Please let me know if there are existing extensions that would accomplish this or a proposal to modify an existing extension to achieve it.

We're using Journal 3 and Opencart 3.0.3.1.

Hi Paul,
Hope you are doing great,

I can assist you with the same.
PM sent with details, please check.

Thanks,
Maria J

p419 wrote: ↑

Tue Jul 14, 2020 11:18 pm

Hello,

We're looking for a solution/proposal to achieve the following:

• Calculate a products price based on a series of product options and the quantity chosen. The unit base price would originate from a series of price discounts based on ordering higher quantities (see the table below).

• We also need a simplified way to administer the base pricing of all of these products (1000 products) if there are future base price changes, either by saving each products base prices with the quantity price breaks in the database for easy exporting and editing or by referencing a spreadsheet that includes the product id, where the price breaks occur and the unit price at each price break which would be referenced when the customer chooses a quantity.

• The starting minimum quantity and the price break points will vary for certain products.

• The options need to function the same way as this site/product: https://bicgraphic.com/CA/euclid-mug-15-oz (Choose " No. I want to see advanced options.")

Please let me know if there are existing extensions that would accomplish this or a proposal to modify an existing extension to achieve it.

We're using Journal 3 and Opencart 3.0.3.1.

Can you clarify the details please? Looking at your post it seems to me that all of this can be accomplished via standard OpenCart quantity discounts. And you can change basic product prices and quantity discounts easily in one go via our Export/Import tool.

BTW.: Is there any reason why you have to use Journal3 rather than a standard compliant OpenCart web theme?

JNeuhoff wrote: ↑

Wed Jul 15, 2020 12:42 am

p419 wrote: ↑

Tue Jul 14, 2020 11:18 pm

Can you clarify the details please? Looking at your post it seems to me that all of this can be accomplished via standard OpenCart quantity discounts. And you can change basic product prices and quantity discounts easily in one go via our Export/Import tool.

BTW.: Is there any reason why you have to use Journal3 rather than a standard compliant OpenCart web theme?

Hello JNeuhoff,

I don't think standard Opencart will achieve the price formatting we're looking for (But I could be wrong), as shown here : https://bicgraphic.com/CA/euclid-mug-15-oz.

Based on the original example table I included it would be as follows:

Buy from 1 to 72 = $6.13 per item (Base Price) x actual quantity + the cost of each option choice shown (could be a flat charge or a charge per unit)
Buy from 144 to 287 = $5.80 per item (Base Price) x actual quantity + the cost of each option choice shown (could be a flat charge or a charge per unit)
Buy from 288 to 575 = $5.47 per item (Base Price) x actual quantity + the cost of each option choice shown (could be a flat charge or a charge per unit)
Buy from 575 to 1007 = $5.16 per item (Base Price) x actual quantity + the cost of each option choice shown (could be a flat charge or a charge per unit)
Buy from 1008 and higher = $4.87 per item (Base Price) x actual quantity + the cost of each option choice shown (could be a flat charge or a charge per unit)

The minimum quantity and where the price breaks occur would also change for different products. Some products have a minimum order of 10 while others could be 300.

Do you think this can be handled with standard Opencart functionality?

Any thoughts are appreciated.

Do you think this can be handled with standard Opencart functionality?

Yes, I think so. Take a look at the OpenCart admin backend, at the product edit page, for the tabs

Tab Data: Minimum Quantity
Tab Discount

JNeuhoff wrote: ↑

Wed Jul 15, 2020 1:26 am

Do you think this can be handled with standard Opencart functionality?

Yes, I think so. Take a look at the OpenCart admin backend, at the product edit page, for the tabs

Tab Data: Minimum Quantity
Tab Discount

Thank you for the reply JNeuhoff.

That works perfectly for the quantity and quantity discounts. We also have an option called "Decorating Method", if they choose the option value "Screen Print - Two Colour" it needs to add a flat set up charge of $65 + a run charge of .24¢ per unit. The .24¢ works fine when added as a price for the option value but there doesn't seem to be a way to add the flat rate set up charge of $65.

Is there a workaround for that in the native Opencart?

Please let me know when you have a moment. Thanks.

That works perfectly for the quantity and quantity discounts. We also have an option called "Decorating Method", if they choose the option value "Screen Print - Two Colour" it needs to add a flat set up charge of $65 + a run charge of .24¢ per unit. The .24¢ works fine when added as a price for the option value but there doesn't seem to be a way to add the flat rate set up charge of $65.

Is there a workaround for that in the native Opencart?

Standard OpenCart only subtracts or adds the option value prices. In order to also add a flat rate charge, dependent on the selection of a product option, it would require some modifications of OpenCart. Or you could use our Instant Option Price Calculator which would allow you to override the standard option price calculation via a pre-defined formula on a per product basis.

JNeuhoff wrote: ↑

Wed Jul 15, 2020 4:09 am

Standard OpenCart only subtracts or adds the option value prices. In order to also add a flat rate charge, dependent on the selection of a product option, it would require some modifications of OpenCart. Or you could use our Instant Option Price Calculator which would allow you to override the standard option price calculation via a pre-defined formula on a per product basis.

Thanks for the help JNeuhoff, I'll look into your Instant Option Price Calculator.

p419 wrote: ↑

Tue Jul 14, 2020 11:18 pm

Hello,

We're looking for a solution/proposal to achieve the following:

• Calculate a products price based on a series of product options and the quantity chosen. The unit base price would originate from a series of price discounts based on ordering higher quantities (see the table below).

• We also need a simplified way to administer the base pricing of all of these products (1000 products) if there are future base price changes, either by saving each products base prices with the quantity price breaks in the database for easy exporting and editing or by referencing a spreadsheet that includes the product id, where the price breaks occur and the unit price at each price break which would be referenced when the customer chooses a quantity.

• The starting minimum quantity and the price break points will vary for certain products.

• The options need to function the same way as this site/product: https://bicgraphic.com/CA/euclid-mug-15-oz (Choose " No. I want to see advanced options.")

Please let me know if there are existing extensions that would accomplish this or a proposal to modify an existing extension to achieve it.

We're using Journal 3 and Opencart 3.0.3.1.

Hello Paul,

Hope you are doing well.

We can help you with this if you didn't find the solution, please message us regarding the same.

Thanks!!!!

Hi Paul,

We should be able to help with this, would you be able to drop us an email to get an estimate?
info@antropy.co.uk

Kind regards,
Alex
www.antropy.co.uk