VAT bug?

  • Posts: 105
  • Thank you received: 6
  • Hikashop Business
8 years 9 months ago #230911

Hello team..

I have sent you 3 emails during the last 10 days about (what seems to be) a bug. Strangely, I did not receive a reply so I am posting my question here.

I am selling a number of digital products on my site. For the sake of brevity let's say I' m selling 2 products: A and B, plus a third one (let's call it C), which is a 50% discount bundle that contains A and B into a single file.

Unfortunately Hikashop doesn't offer a product bundle option. Had this option existed, the buyers of C would see products A and B, when they clicked on "Show the downloads, in the customer control panel. This would be extremely useful, for a number of reasons.

I decided to do some manual work to bypass the lack of the bundle feature.
I edited an order of C; in the "product list", I deleted C, and I added products A, B, instead. Finally I edited the "additional information", and I added the 50% discount, to correct the final cost.

So far so good. It worked very well with those orders that didn't have VAT.

But when I tried to do the same with an order from an EU country, I noticed that Hikashop charged the wrong VAT!
I sent you a number of screenshots in my emails. Please let me know if the emails never landed in your inbox.

I am looking forward to hearing from you about the issue. Also, please let us know if you have any plans to add the product bundle option in Hikashop.

Thank you.
Panos

Please Log in or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
8 years 9 months ago #231050

Hi Panos,

1.
For your bundle issue the best solution will probably be to directly tell me what you exactly do to bypass the lack of the bundle feature so that I can understand why and how you are having your issue.

2.
Regarding your emails I found them in our spam box, we are sorry about it.
It seems like your problem was coming from the fact that you didn't set any VAT value for the 55€ discount, so you'll have to add a value just before the "VAT(DE) (19%)" field.

Please Log in or Create an account to join the conversation.

  • Posts: 105
  • Thank you received: 6
  • Hikashop Business
8 years 8 months ago #231435

Hello Mohamed,
I tried your solution but it didn't work.

I will start over, this time with a real example. Please read carefully and let me know if there is anything that doesn't make sense:

I am selling 13 individual products on my site, delivered as digital downloads.
In addition I am selling a bundle which is a zip file containing all 13 product files. It's price is 50% the total cost of the 13 products. The
total cost is 136.50 euros. Therefore the bundle price is 68.25 euros.

A customer from Germany bought my bundle. He paid 68.25 + 19% (DE VAT) = 81.22 euros.

I edited his order this way:
In the Product List, I deleted the Bundle and I added the 13 products. So far so good.

Now look the Additional information section shows this:

Subtotal 136.50 €
Discount 0.00 €
Shipping 0.00 €- NONE
Payment fee 0.00 € - PayPal
VAT (DE) 25.94 €
Total 162.44 €

Please let me know how exactly I should edit the Additional information section so that it shows a discount of 68.25 euros, a VAT of 12.97 euros and a total of 81.22 euros.

It's really sad that Hikashop doesn't offer the bundle feature.

Please Log in or Create an account to join the conversation.

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
8 years 8 months ago #231601

Hi,

As Mohamed explained, you need to fill in the VAT amount when you edit the coupon in your order. Here is a screenshot:
take.ms/L78zC
And that's the result in the invoice:
take.ms/SSAW1
As you can see, the total is correct, and the VAT amount is correct too.

The following user(s) said Thank You: panefs

Please Log in or Create an account to join the conversation.

  • Posts: 105
  • Thank you received: 6
  • Hikashop Business
8 years 8 months ago #231943

Your image helped me understand which fields should be filled with the appropriate data. Merci!

Please consider adding the bundle option in Hihashop:
There are numerous sellers of digital products, using Hikashop. Offering bundles is an essential marketing strategy for us. Hikashop plays a pivotal role in our businesses. The lack of product bundling is, in my opinion, a serious disadvantage.

Please Log in or Create an account to join the conversation.

  • Posts: 105
  • Thank you received: 6
  • Hikashop Business
8 years 8 months ago #231952

One last question please.

Let's say that I decide to change the price of a product.
Will this change affect the Hikashop records of the past transactions ? I hope not!

Please Log in or Create an account to join the conversation.

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
8 years 8 months ago #231959

Hi,

1. The bundle feature is something we're preparing on our end. We're currently implementing a new cart system in HikaShop and it will be a first step in being able to support bundles.

2. Changing the price of a product won't affect the records of the past transactions.

Please Log in or Create an account to join the conversation.

  • Posts: 105
  • Thank you received: 6
  • Hikashop Business
8 years 8 months ago #232089

These are both great news. Merci Nicolas!

Regarding the suggested solution: there is still an issue with the VAT.
It is related to the last question I made, about how the changes in product prices can have a backward effect.
Let me give an example, to understand what I mean.

Last year a customer from Germany paid €60.90 + 19% VAT (€11.57) = €72.47 for my complete bundle.
2 months ago I changed the prices of some my products. Let's see the backward effect of these changes:

I followed the approach you and Mohamed suggested. The Total value in the "Additional Information" section is indeed correct (€72.47). But the VAT is not correct (it shows €11.12 instead of €11.57):

Subtotal	119.40 €
Discount	-58.05 €
Shipping	0.00 €- NONE
Payment fee	0.00 € - PayPal
VAT (DE)	11.12 €
Total	72.47 €

I am wondering if there can be a solution to this.

Thanks
Panos

Please Log in or Create an account to join the conversation.

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
8 years 8 months ago #232363

Hi,

I really don't understand what is the problem.
You're the one entering the VAT value you want in the popup along with the discount value you want.
If the VAT you get for the order as a result is not what you want, it means that what you entered in the VAT field of the coupon is not what you should have entered.
I don't see the link with the fact that the product prices changed.
Reduce the VAT value of the coupon of 0.45 and you'll get the VAT value you want for the order as far as I can see in your example.

Please Log in or Create an account to join the conversation.

  • Posts: 105
  • Thank you received: 6
  • Hikashop Business
8 years 8 months ago #232955

Nicolas, I am attaching two images that show the issue.

This transaction is from a VIES-registered company from Germany, who paid 63.20 euros for my 50% discount Bundle.

I edited the transaction as I explained in my previous posts.

Then I edited the additional information section, as shown in the image below:



I added two arrows in the image, to show you that there are two fields with no description. Its not obvious what goes where!
The help section doesn't prove enlightening either. I followed your suggestion and I entered 86.03 in the second field. The Total value is now correct: 63.20 euros). I am reminding you that the VAT should be 0.

And here is what shows up when I save.
It shows: VAT (DE): 23.83 euros !!.
In addition, the subtotal is 125.40 (compare this with the same value in the previous image, which was 149.23 euros). Completely confusing!


I exported the transaction and imported the CSV in Excel.
The order_full_tax value is 23.86 euros (which by the way is slightly different than 23.83 as shown in the second image).

There should be no VAT in this transaction.

Attachments:
Last edit: 8 years 8 months ago by panefs.

Please Log in or Create an account to join the conversation.

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
8 years 8 months ago #233123

There are four things for the discount in the popup:
1. A text field for the name of the coupon. You can put whatever in it or leave it empty, it doesn't change anything.
2. A text field for the value of the coupon. That value will reduce the total amount of the order.
3. A text field for the value of the tax reduced by the coupon value. If you look at my screenshot, you can see that this is the key to have the correct value in the VAT when adding/modifing the coupon. If you leave that field empty, like you show in your screenshots, you won't have a correct VAT amount in your order.
4. A dropdown with the selection of the VAT rate for the VAT amount of the coupon.

Please Log in or Create an account to join the conversation.

Time to create page: 0.124 seconds
Powered by Kunena Forum