Post by world-of-satellite » Tue Aug 21, 2012 1:38 am

Anyone able to help with this please?

Cart version I'm using is 1.5.3.1, upgrade right now is not really an option due to theme etc..

Not sure when this started. I'm getting wrong unit rates values when a customer purchased more than one item. Single goods are fine. See screenshots attached. I do not understand why the rates are wrong when a customer orders 2 or more of the same item.

The sub-total, VAT and Total are all correct. Unit price and line total are wrong.

Anyone please able to help with this?

Attachments

multiple-invoice.PNG

multiple-invoice.PNG (18.11 KiB) Viewed 4388 times

single-order.PNG

single-order.PNG (9.59 KiB) Viewed 4388 times

single-invoice.PNG

single-invoice.PNG (16.51 KiB) Viewed 4388 times

Last edited by i2Paq on Sat Aug 25, 2012 5:59 pm, edited 3 times in total.
Reason: Version added

Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by world-of-satellite » Tue Aug 21, 2012 1:39 am

Another attachement.

Attachments

multiple-order.PNG

multiple-order.PNG (10.6 KiB) Viewed 4387 times


Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by world-of-satellite » Tue Aug 21, 2012 2:04 am

Another issue I've found is that if any discounted rates are set for volume quantities they are not being picked up.

For instance I have a product that is £5 each. I've set a discount that if 5 units are purchased it becomes £4.50 each. The standard rate of £5 is still being used.

Desperate for help with this one please.

I'll pay for whoever can fix.

Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by world-of-satellite » Tue Aug 21, 2012 2:17 am

Cart version I'm using is 1.5.3.1, upgrade right now is not really an option due to theme etc..

Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by world-of-satellite » Tue Aug 21, 2012 4:32 am

This issue is something to do with VAT.

The unit rate of the TM-5402 in screenshots above is £115.8333 + VAT.

So it looks the unit rate when you view an order is adding 20% for a single item, then 20% for two items.

If I edit an order all the rates are correct. The issue only occurs when simply viewing an order and printing an invoice.

Heres a screenshot from edit an order.

Attachments

edit-order.PNG

edit-order.PNG (34.99 KiB) Viewed 4371 times


Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by world-of-satellite » Tue Aug 21, 2012 4:40 am

On my set site I've set one Geozone for United kingdom > All zones.

I've got one UK VAT Tax rate 20% for UK.

I've got one UK tax class set to store address which is UK.

Sreenshot of Settings > Option > Taxes attached.

I'm willing to pay for whoever can fix this please.

Attachments

taxes.PNG

taxes.PNG (17.89 KiB) Viewed 4371 times


Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by world-of-satellite » Tue Aug 21, 2012 1:37 pm

I've just removed all products from my test site and remove all geo zones, tax classes etc..

Setup one geo zone for UK, one VAT rate.

Add one test product, basic not options etc...

The problem as stated above is only occurring when viewing an order or printing invoice. Insert and edit order show correct figures.

This is what is happen: -

Single item: -

Product selling price 1.00 + VAT
View order or invoice shows unit rate as 1.20, should show as £1.00. Line Total = £1.20, should be £1.00.
VAT should not be added to unit rate.

Two of the same item: -
Product selling price 1.00 + VAT
View order or invoice shows unit rate as 1.40, should show as £1.00. Line Total = £2.80, should be £2.00
40% VAT added to unit rate/

Three of the same item: -
Product selling price 1.00 + VAT
View order or invoice shows unit rate as 1.60, should show as £1.00. Line Total = £4.80, should be £3.00
60% VAT added to unit rate.

This pattern carries on throughout, adding an additional 20%, if 5 items are added, 100% VAT is added to unit rate.

Sub total, VAT and Invoice/order total are 100% correct though. These are calculated from the correct prices, not the unit rates shown on view order or invoice. See posted screenshots above.

Please can anyone provide commercial support to fix this issue.

Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by world-of-satellite » Tue Aug 21, 2012 2:44 pm

After a sleepless night I found the fix for the VAT issue http://forum.opencart.com/viewtopic.php ... 20#p329382 Thank you to ADD Creative for posting the fix, I should have looked in the bug thread 1st ::)

Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by world-of-satellite » Tue Aug 21, 2012 2:47 pm

Fix for post three found here http://forum.opencart.com/viewtopic.php?f=131&t=38147 Thank you to UKsitebuilder, woohoo all sorted again :)

Now need some sleep lol!

Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by bigchili » Tue Aug 21, 2012 10:26 pm

You just had an entire conversation with yourself in this thread. :crazy:

Awesome.

User avatar
Active Member

Posts

Joined
Wed May 16, 2012 3:00 am


Post by world-of-satellite » Wed Aug 22, 2012 12:42 pm

world-of-satellite wrote:After a sleepless night I found the fix for the VAT issue http://forum.opencart.com/viewtopic.php ... 20#p329382 Thank you to ADD Creative for posting the fix, I should have looked in the bug thread 1st ::)
Still need help on this please.

This fix only works if the order is put through manually through the back-end. If a customer places an order it still comes through wrong. We need to then manually edit the order, deleting the products and re-adding them manually.

Anyone please?

Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by Qphoria » Thu Aug 23, 2012 10:34 am

I cannot reproduce this. I see the same thing with both normal confirm and uber checkout.They are using the same base code for order saving.

The order is stored in YOUR default currency set in your store.
Perhaps you edited the order or something with the order editor and it is to blame
I tried both standard and uber with default currency of USD
I added 5 x $100 items to my cart
Switched to GBP which was like 68.83
When I checkout, both show me the order in the backend as 5 x 100 which is correct because you, as the admin, would want to see totals in your own currency to know how much you made.

So I'm guessing maybe a bug in the order edit or something

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by world-of-satellite » Thu Aug 23, 2012 12:33 pm

Qphoria wrote:I cannot reproduce this. I see the same thing with both normal confirm and uber checkout.They are using the same base code for order saving.

The order is stored in YOUR default currency set in your store.
Perhaps you edited the order or something with the order editor and it is to blame
I tried both standard and uber with default currency of USD
I added 5 x $100 items to my cart
Switched to GBP which was like 68.83
When I checkout, both show me the order in the backend as 5 x 100 which is correct because you, as the admin, would want to see totals in your own currency to know how much you made.

So I'm guessing maybe a bug in the order edit or something
Manual order edit and insert order in backend are fine now.

As I've posted this bug is present in my cart using UBER Checkout when a customer places a multiple order through the front end using UBER checkout. With uber disabled all is fine. Your more than welcome to have access to my cart, but the bug is 100% there and reproducible.

Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by world-of-satellite » Thu Aug 23, 2012 12:54 pm

Examples of the orders in the backend: -

Correct order with standard checkout
correct-order.PNG

correct-order.PNG (19.34 KiB) Viewed 4280 times

wrong order with UBER Checkout
wrong-order.PNG

wrong-order.PNG (19.13 KiB) Viewed 4280 times

Can be 100% reproduced, as I've said I'm more than willing to give you access Q.

Neither of the above orders have been edited, they are EXACTLY how the come through to the back end.

As I've already posted above this is what is happens: -

Single item: -

Product selling price 1.00 + VAT
View order or invoice shows unit rate as 1.20, should show as £1.00. Line Total = £1.20, should be £1.00.
VAT should not be added to unit rate.

Two of the same item: -
Product selling price 1.00 + VAT
View order or invoice shows unit rate as 1.40, should show as £1.00. Line Total = £2.80, should be £2.00
40% VAT added to unit rate/

Three of the same item: -
Product selling price 1.00 + VAT
View order or invoice shows unit rate as 1.60, should show as £1.00. Line Total = £4.80, should be £3.00
60% VAT added to unit rate.

This pattern carries on throughout, adding an additional 20%, if 5 items are added, 100% VAT is added to unit rate.

Sub total, VAT and Invoice/order total are 100% correct though. These are calculated from the correct prices, not the unit rates shown on view order or invoice. See posted screenshots above.

The fix posted here http://forum.opencart.com/viewtopic.php ... 20#p329382 fixed the backend issue, but this bug is still ocuring with UBER enabled

Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by world-of-satellite » Thu Aug 23, 2012 1:08 pm

I've found the issue what is causing this Q.

Uber Original: -

Code: Select all

				
				//'tax'        => $this->tax->getTax($product['price'], $product['tax_class_id']),
				'tax'        => $xtax,
My change that fixes the issue: -

Code: Select all

				'tax'        => $this->tax->getTax($product['price'], $product['tax_class_id']),
				//'tax'        => $xtax,

Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by world-of-satellite » Fri Aug 24, 2012 2:12 am

Any comment on the above fix Q?

Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by world-of-satellite » Sat Aug 25, 2012 4:16 pm

@ Q i'm rather disappointed that you couldn't comment on the above, considering I purchased your UBER checkout and my bug report was deleted from your extensions release.

Is this going to be fixed for future versions?

Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by world-of-satellite » Sun Aug 26, 2012 6:17 pm

Marked solved, but still no help or comment ::)

Active Member

Posts

Joined
Sun Jun 27, 2010 1:40 pm

Post by R_D » Thu Nov 29, 2012 7:36 pm

Hi,

I encounter this problem also, I don't have UBER but do you know how I can get the rates correct?

Thanks!

R_D
Active Member

Posts

Joined
Sun Jan 09, 2011 3:13 am

Post by R_D » Fri Nov 30, 2012 3:25 am

solved

R_D
Active Member

Posts

Joined
Sun Jan 09, 2011 3:13 am
Who is online

Users browsing this forum: No registered users and 11 guests