Load price from mysql on product page, based on custom fields

-- HikaShop version -- : 4.2.1

Hello!

Each my product has about 5.000 - 20.000 variants of price. They are calculated based on a few customs fields of item.
I need to create a custom plugin, that will load the price from own MySQL table based on a custom fields and if-else conditions.

Actually, I already hired three freelancers on that, one stole our money and two of them give up a project. Despite I am not a programmer, I can do many things with PHP, javascript,...

I would love to ask if you could kindly give us advise on that. I believe I can do this, only what I need to know:

1) How to start a plugin. What function should I use to handle changes of custom fields on product page? Is there any, or can I use jQuery? I haven't found anything in API

2) How to overwrite the price of the product on product page and affect the price in cart, checkout, order in backend, confirmation email, everything..

Here is my product page:
elodyprsteny.cz/snubni/zlute-zlato/model-6441

Thank you very much for any help! I highly appreciate everything!

F.

Hello Nicolas!

Thank you so so much for tips. I spend day and night and I managed it to work. I only have 2 issues, which are not connected with this modification (I tested).

1. If I try to apply a coupon on discounted product (with setting to override discount) it calculates the wrong amount.
2. When I empty cart, I have not redirected anywhere

I recorded both issues there:
www.loom.com/share/213b27f04df04346b7f43e00cc6c273e

Just for sure, I will send you admin access via form (in case there will need to check something).


Thank you in advance for any tip or piece of advice!


Filip

Hello Nicols,

You are right about the second issue, I removed javascript that and cart is redirecting . Thank you.


About second issue, I beg to differ. I believe that it came from Hikashop mistake.

Price after coupon with discount override was calculated like:

$coupon->discount_percent_amount * $product->prices[0]->$price

$coupon->discount_percent_amount * $product->prices[0]->$price_without_discount

case 2:
if(isset($product->prices[0]->$price_without_discount)) {
	$coupon->discount_flat_amount += ($coupon->discount_percent_amount * $product->prices[0]->$price) / 100;
	$coupon->discount_flat_amount -= $product->prices[0]->$price_without_discount - $product->prices[0]->$price;
	if($coupon->discount_flat_amount < 0)
		$coupon->discount_flat_amount = 0;
		break;
	}

case 2:
if(isset($product->prices[0]->$price_without_discount)) {
// MISTAKE FIXED BELLOW
	$coupon->discount_flat_amount += ($coupon->discount_percent_amount * $product->prices[0]->$price_without_discount) / 100;
	$coupon->discount_flat_amount -= $product->prices[0]->$price_without_discount - $product->prices[0]->$price;
	if($coupon->discount_flat_amount < 0)
		$coupon->discount_flat_amount = 0;
	break;
}

Hello,

Maybe I am wrong, but...

If I set coupon handling of discount to "override discounted products" I expect to ignore discount and use coupon only.

For example:
Original price 1000
Discounted price 900
Coupon (20%)
Price after coupon with discount override: 800

Is this how it should work? If yes, then override discounted products not working, at least on my side.


F.

Hello, I am sorry for confusion. The main is that it is working for us

Thank you,
F.