Post by BrandonBerner » Sat Jun 18, 2016 12:23 pm

OC 2.0.3.1

Product A has 3 options before you can ad to the cart.

Options:
1,000 - ($300)
5,000 - ($800)
100,000 - ($23,500)

When no option is selected, the price is $0

When the option "1,000 - ($300)" is selected, the price is updated to $300
When the option "5,000 - ($800)" is selected, the price is updated to $800
When the option "100,000 - ($23,500)" is selected, the price is updated to $23 It should show $23,500

Any prices above $999 are not being updated.

How can I fix this so when a customer selects an option over $999 for it to update the price correctly.

Thanks :)

Active Member

Posts

Joined
Sat Dec 15, 2012 4:49 am

Post by AlexDW » Sun Jun 19, 2016 1:34 am

What a extension you use to update price when option selected?

I think have 2 causes:
or you fill option in item card with comma (,) in cost - try fill without comma
or your extension works incorrectly and need to connect with his author

Useful Opencart extensions


User avatar
New member

Posts

Joined
Sun Jun 05, 2016 3:32 am

Post by BrandonBerner » Sun Jun 19, 2016 5:31 am

AlexDW wrote:What a extension you use to update price when option selected?

I think have 2 causes:
or you fill option in item card with comma (,) in cost - try fill without comma
or your extension works incorrectly and need to connect with his author

Hello Alex, thanks for your reply.

I cant find any extensions which assist the price update.

I have attached a picture of what my option field looks like.
Image

Active Member

Posts

Joined
Sat Dec 15, 2012 4:49 am

Post by Burt65 » Sun Jun 19, 2016 7:40 am

BrandonBerner wrote:
Hello Alex, thanks for your reply.

I cant find any extensions which assist the price update.

I have attached a picture of what my option field looks like.

Like Alex said, try to remove all the commas (,) including the Options Value.

As a matter of fact, just don't use commas anywhere....

Over 95% of all computer problems can be traced back to the interface between the keyboard and the chair...


User avatar
Active Member

Posts

Joined
Mon Nov 18, 2013 3:23 pm
Location - Oz

Post by BrandonBerner » Sun Jun 19, 2016 11:12 am

Burt65 wrote:
BrandonBerner wrote:
Hello Alex, thanks for your reply.

I cant find any extensions which assist the price update.

I have attached a picture of what my option field looks like.

Like Alex said, try to remove all the commas (,) including the Options Value.

As a matter of fact, just don't use commas anywhere....
Oh haha, now I feel stupid. I was looking under the Price section, not the Option Value section! Thanks Alex and Burt65

Active Member

Posts

Joined
Sat Dec 15, 2012 4:49 am

Post by BrandonBerner » Sun Jun 19, 2016 11:19 am

Burt65 wrote:
BrandonBerner wrote:
Hello Alex, thanks for your reply.

I cant find any extensions which assist the price update.

I have attached a picture of what my option field looks like.

Like Alex said, try to remove all the commas (,) including the Options Value.

As a matter of fact, just don't use commas anywhere....


AHHHHH! The problem continues.

I have removed the commas and its still showing the incorrect price when its above $999

Image

Active Member

Posts

Joined
Sat Dec 15, 2012 4:49 am

Post by i2Paq » Sun Jun 19, 2016 6:24 pm

A link to your shop would help.

You can set a single product price for any amount above 999?

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by BrandonBerner » Mon Jun 20, 2016 2:49 am

i2Paq wrote:A link to your shop would help.

You can set a single product price for any amount above 999?

Yes Single Product price displays above 999.

Only options with price variations cause this problem.


http://SMB.UpTImePC.com

Click any product that has the word (Custom) at the end of the name. Those products contain options with a variable price.

Active Member

Posts

Joined
Sat Dec 15, 2012 4:49 am

Post by i2Paq » Mon Jun 20, 2016 5:43 pm

Is this a additional mod that updates the price when an option is chosen?

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by BrandonBerner » Tue Jun 21, 2016 10:46 am

i2Paq wrote:Is this a additional mod that updates the price when an option is chosen?

I disabled all VQ Mods, refreshed, and Its still not showing any pricing over $999 correctly.

Active Member

Posts

Joined
Sat Dec 15, 2012 4:49 am

Post by Burt65 » Tue Jun 21, 2016 11:19 am

Hello Brandon I just had a look at your site.

When I select the product "HQ Instagram Likes (Custom)" it did show the price as 0 and select an option as "Please Select"

So far so good.

Now when I select the option of 250000 the price listed in your option is of 9,999.98 CAD and Opencart does change the price to 9.

If I select the option of 500000 the price listed in your option is of 1,599.98 and Opencart does change the price to 1.

Do you see the pattern? Opencart still only show you what ever number is after the comma. I know that you have said that you did remove all the commas, but:

1) there are still some commas somewhere either in the option, or + - Option Prices

2) the comma are now in the database under oc_product_option_value and you will have to check and remove them manually if any are there.

You can also try to delete the product and re-added it, but you definitely have a comma problem in your Opencart

Cheers

Over 95% of all computer problems can be traced back to the interface between the keyboard and the chair...


User avatar
Active Member

Posts

Joined
Mon Nov 18, 2013 3:23 pm
Location - Oz

Post by BrandonBerner » Tue Jun 21, 2016 11:43 am

Burt65 wrote:Hello Brandon I just had a look at your site.

When I select the product "HQ Instagram Likes (Custom)" it did show the price as 0 and select an option as "Please Select"

So far so good.

Now when I select the option of 250000 the price listed in your option is of 9,999.98 CAD and Opencart does change the price to 9.

If I select the option of 500000 the price listed in your option is of 1,599.98 and Opencart does change the price to 1.

Do you see the pattern? Opencart still only show you what ever number is after the comma. I know that you have said that you did remove all the commas, but:

1) there are still some commas somewhere either in the option, or + - Option Prices

2) the comma are now in the database under oc_product_option_value and you will have to check and remove them manually if any are there.

You can also try to delete the product and re-added it, but you definitely have a comma problem in your Opencart

Cheers
Thanks for all the time you have spent looking into this problem!

1) I have made sure there are no commas under any section of "HQ Instagram Likes (Custom)" in the options tab.
2) I am going to check the database now to see if I can find the comma.

I added a new product called Test. I created a new option called Test Option, and set 3 price variations without commas. I still see the price not displaying correctly. You can view this test product here: http://smb.uptimepc.com/index.php?route ... uct_id=426

Active Member

Posts

Joined
Sat Dec 15, 2012 4:49 am

Post by BrandonBerner » Tue Jun 21, 2016 12:24 pm

Burt65 wrote:Hello Brandon I just had a look at your site.

When I select the product "HQ Instagram Likes (Custom)" it did show the price as 0 and select an option as "Please Select"

So far so good.

Now when I select the option of 250000 the price listed in your option is of 9,999.98 CAD and Opencart does change the price to 9.

If I select the option of 500000 the price listed in your option is of 1,599.98 and Opencart does change the price to 1.

Do you see the pattern? Opencart still only show you what ever number is after the comma. I know that you have said that you did remove all the commas, but:

1) there are still some commas somewhere either in the option, or + - Option Prices

2) the comma are now in the database under oc_product_option_value and you will have to check and remove them manually if any are there.

You can also try to delete the product and re-added it, but you definitely have a comma problem in your Opencart

Cheers
Is there allowed to be commas for the Option Name? or is that not allowed either?

Example:
Option Name: Please select one, or more of the options below
Option 1 - 1000
Option 2 - 3000

Active Member

Posts

Joined
Sat Dec 15, 2012 4:49 am

Post by pprmkr » Tue Jun 21, 2016 12:40 pm

Code: Select all

newPriceValue = newPriceValue.substring(position1, position2);
                        if (newPriceValue.indexOf('.') == -1)
                        {
                            newPriceValue = "0";
                        }
                        if (finalPriceValue.indexOf('.') == -1)
                        {
                            finalPriceValue = "0";
                        }
                        finalPriceValue = parseFloat(finalPriceValue) + parseFloat(newPriceValue);
                        finalPriceValue = finalPriceValue.toFixed(2);
Your price updater does not calculate with real price, but gets some text from page ...
Price is displayed with settings from language ( thousands_ and decimal_point )

User avatar
Active Member

Posts

Joined
Sat Jan 08, 2011 11:05 pm
Location - Netherlands

Post by Burt65 » Tue Jun 21, 2016 12:42 pm

How about:

Instead of "Please select one, or more of the options below"

"Please choose from the options below"

Why make it longer than necessary... ;)

Over 95% of all computer problems can be traced back to the interface between the keyboard and the chair...


User avatar
Active Member

Posts

Joined
Mon Nov 18, 2013 3:23 pm
Location - Oz

Post by BrandonBerner » Tue Jun 21, 2016 12:45 pm

Burt65 wrote:How about:

Instead of "Please select one, or more of the options below"

"Please choose from the options below"

Why make it longer than necessary... ;)

This was just an example. Is it ok to use a comma in the Option Name? or does this cause database problems also?


Here is a real example of an Option Name on my site: Enter Your Accounts Url, Link, or Username For Service #1

Active Member

Posts

Joined
Sat Dec 15, 2012 4:49 am

Post by Burt65 » Tue Jun 21, 2016 2:13 pm

Have you by any chance modify the product.tpl and maybe add some code that does modify the decimal place in options?

also note what pprmkr mentioned to you above regarding the language possibility

After this you are on your own... ;)

Over 95% of all computer problems can be traced back to the interface between the keyboard and the chair...


User avatar
Active Member

Posts

Joined
Mon Nov 18, 2013 3:23 pm
Location - Oz

Post by i2Paq » Tue Jun 21, 2016 3:00 pm

BrandonBerner wrote:
i2Paq wrote:Is this a additional mod that updates the price when an option is chosen?

I disabled all VQ Mods, refreshed, and Its still not showing any pricing over $999 correctly.
But your additional Price Updater us still active as OC does NOT have this automatic updater when an option is chosen.

Did you contact the creator of that mod?

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by BrandonBerner » Tue Jun 21, 2016 4:04 pm

pprmkr wrote:

Code: Select all

newPriceValue = newPriceValue.substring(position1, position2);
                        if (newPriceValue.indexOf('.') == -1)
                        {
                            newPriceValue = "0";
                        }
                        if (finalPriceValue.indexOf('.') == -1)
                        {
                            finalPriceValue = "0";
                        }
                        finalPriceValue = parseFloat(finalPriceValue) + parseFloat(newPriceValue);
                        finalPriceValue = finalPriceValue.toFixed(2);
Your price updater does not calculate with real price, but gets some text from page ...
Price is displayed with settings from language ( thousands_ and decimal_point )

This is begging to go way over my head. I am very eager to fix this problem. I had a customer who purchased a service from a drop down menu for $6,099, and he thought it was only $6 (due to the price updating problem). Now after I completed the service, he opened a dispute with PayPal, and PayPal has refunded him $6,093 (and I only received $6 for a $6,099 service!). Although the service did not cost me $6,099, it still costed me a fortune. I now have to confirm with my customers before the service starts that they are aware of the price, so this does not happen again.

So far I can see 3 possible solutions from reading this post.
1. What Burt65 said regarding Remove all commas from Option Values.
2. What you ppmkr have said, which does not compute with my brain
3. What i2Paq said regarding an additional Price Updater and a mod. Which I also dont understand.

Would you be able to send me step by step instructions?

I understand you all have other posts to answer also, so im willing to get whatever I can, and completely understand if you choose not write these instructions.
Last edited by BrandonBerner on Tue Jun 21, 2016 4:11 pm, edited 1 time in total.

Active Member

Posts

Joined
Sat Dec 15, 2012 4:49 am

Post by BrandonBerner » Tue Jun 21, 2016 4:06 pm

i2Paq wrote:
BrandonBerner wrote:
i2Paq wrote:Is this a additional mod that updates the price when an option is chosen?

I disabled all VQ Mods, refreshed, and Its still not showing any pricing over $999 correctly.
But your additional Price Updater us still active as OC does NOT have this automatic updater when an option is chosen.

Did you contact the creator of that mod?

I am having a hard time understanding what you are asking. I disabled all VQMods and the price still did not display correctly.

Would you be able to send me step by step instructions?

I understand you all have other posts to answer also, so im willing to get whatever I can, and completely understand if you choose not write these instructions.

Active Member

Posts

Joined
Sat Dec 15, 2012 4:49 am
Who is online

Users browsing this forum: No registered users and 68 guests