Order details display on Vendor Order Listing page

  • Posts: 59
  • Thank you received: 4
  • Hikashop Business
2 years 3 months ago #344105

-- HikaShop version -- : 4.6.1
-- HikaMarket version -- : 4.1.0
-- Joomla version -- : 4.1.4
-- PHP version -- : 7.4.29
-- Browser(s) name and version -- : Firefox 102.0.1
-- Error-message(debug-mod must be tuned on) -- : none

Hey Jerome,

Got another order subtotaling issue, on the Vendor Order Listing page.

- Customer creates an order (using a FL delivery address to activate sales tax)

- My client will go to the Vendor Order Listing page to process the order...there they willl
....manually add shipping cost
.....change order status to verified
.... use email button to send notification to customer

On the vendor order listing page, the Order Details page displays.....

Subtotal
Shipping
Payment Fee
Tax (x%)
Total


- I next edit the Shipping to add a shipping cost

- When I do so the Order Details drop the Tax(x%) item as follows....

Subtotal
Shipping
Payment Fee
Total

The values are correct but it no longer displays the taxes.

How can I get the Taxes to properly display in the Order Details ?

I'm using the TaxCloud plugin to generate taxes.

Screenshots attached.

The login I sent you last week is still active.

Many thanks,

Dave

Attachments:

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
2 years 3 months ago #344107

Hello,

First, do you have the same issue when you edit the order in the backend ?

The TaxCloud plugin was not made to be compatible with HikaMarket, so it might not handle the fact that an order can be modified in the frontend.
We first need to understand the nature of the issue, if you can reproduce it in the backend ; if it's related to the TaxCloud plugin or if you could have the same issue without (with classical taxes).

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 59
  • Thank you received: 4
  • Hikashop Business
2 years 3 months ago #344125

Thanks Jerome,

I ran a couple tests....

With TaxCloud published.... I am seeing the same phenomena in the Hikashop backend. That is.... after I add shipping cost the tax line item disappears. The totals are correct but I'm missing that tax display line item.

I disabled TaxCloud and enabled a classic version of sales tax. I looked at the HikaMarket front end. Both before and after adding the shipping cost, the tax line item appears properly. I also, confirmed the same in the Hikashop backend.

What's the next step ?

cheers,

Dave

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
2 years 3 months ago #344129

Hello,

If you have the same issue in the HikaShop backend, it means that the problem should be fix in the TaxCloud plugin.
I'll move that thread in the HikaShop section, so the HikaShop support team will be able to investigate on that.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: daduts

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
2 years 2 months ago #344130

Hi,

We'll need a backend access and a FTP access in order to reproduce the issue in the backend and do some debugging.
Could you provide that via our contact form along with an order number we can use for our tests and a link to this thread for reference ?
www.hikashop.com/support/contact-us.html

Last edit: 2 years 3 months ago by nicolas.

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

  • Posts: 59
  • Thank you received: 4
  • Hikashop Business
2 years 2 months ago #344141

Contact form sent with details.

Many thanks for your attention,

Dave

Last edit: 2 years 2 months ago by daduts.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
2 years 2 months ago #344168

Hi,

I tried to reproduce the issue on your website backend but I wasn't able to.
I edited the order D7F4, and added the shipping fee (3) with the 6% and 0.18 of taxes, and the taxes of the order was properly updated from 0.34 to 0.52.
I also properly set the tax rate in the product and for the shipping of the order D7D2 and the total was properly calculated.
So I'm not following you. I must be missing some information on what you're doing.

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

  • Posts: 59
  • Thank you received: 4
  • Hikashop Business
2 years 2 months ago #344169

Thanks for looking Nicolas,

I’m using TaxCloud to compute the sales tax when the customer submits the order.

When my client than manually adds a Shipping cost, the tax display disappears.

I just confirmed this is still occurring using order D7G5.

You’ll note there I have added a shipping cost. The total includes tax. But a separate line for the tax no longer appears.

I’d like to have the tax line displayed.

I’ve further created a new order D7H6, where you can see what a freshly submitted order looks like. The tax is properly displayed there. Add a shipping cost there and I’ll bet the tax display line disappears.

Cheers,

Dave

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
2 years 2 months ago #344177

Hi,

I think there is a problem between what you're trying to do and how TaxCloud's API work.
The TaxCloud API we implemented years ago only allows the plugin to:
- send the data of a cart to get taxes
- send the data of an order (so that it can be used for tax remitance on TaxCloud's side
- cancel some products in an order already sent
- cancel a whole order
As far as I know, there is no mechanism in the TaxCloud API to update the shipping fee of an order or calculate the shipping fee of an already created order.
So a solution would be to manually create a tax rate, select it when you add the shipping price with the shipping tax you would manually calculate. But I'm not even sure this would work and it would mean that you wouldn't be able to use TaxCloud's tax declaration mechanism as the order on their end wouldn't match the one on yours.

I've actually checked the API they provided on api.taxcloud.net/ and it seems they now have a "returnedPro" method which allows you to update orders, so this might allow for such capability, but it require a special licence with them (probably something you have to pay to use) and would also need extra development in the plugin.
So I'm afraid I can't provide an easy solution here. I can only recommend to use precalculated shipping fees so that an update is not needed.

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

  • Posts: 59
  • Thank you received: 4
  • Hikashop Business
2 years 2 months ago #344180

Thanks Nicolas,

We are not taxing the shipping, rather only adding a shipping fee. Thus, the tax initially retrieved from TaxCloud is the correct amount.

Prior to adding the shipping fee it’s displayed properly in a Sales Tax line.

After adding the shipping fee the line displaying the Sales Tax disappears. All
I’m asking is for that line to remain.

After adding the shipping fee, the calculated Total for the order is correct and includes correct tax and shipping…so Hikashop is using the correct TaxCloud generated tax. It just isn’t displaying it.

So, all the correct data appears to be there. It seems to me this is only a display issue. It shouldn’t require another API call to TaxCloud rather just properly display the data we’ve previously displayed and are currently using.

Thanks for bearing with me on this one,

Cheers
: D

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
2 years 2 months ago #344235

Hi,

I think I found the problem.
The issue is that the detailed tax info for each product is not present in the orders. This is not a problem for the normal display once an order is created. However, when an order is modified, the taxes are recalculated based on several things including that detailed tax product information. And that's why the taxes from the products disappear when you set the shipping fee.
This is because the TaxCloud plugin actually provides the taxes to HikaShop when the cart is loaded, but not the detailed tax information for the unit price.
Change the code:

if(!empty($product->prices[0]->unit_price))
							$product->prices[0]->unit_price->price_value_with_tax = $product->prices[0]->unit_price->price_value + $item->TaxAmount/$product->cart_product_quantity;
					}
to:
if(!empty($product->prices[0]->unit_price)) {
							$tu = hikashop_copy($t);
							$tu->tax_amount = $tu->tax_amount/$product->cart_product_quantity;
							$product->prices[0]->unit_price->taxes[$tu->tax_namekey] = $tu;
							$product->prices[0]->unit_price->price_value_with_tax = $product->prices[0]->unit_price->price_value + $tu->tax_amount;
						}
in the file plugins/hikashop/taxcloud/taxcloud.php
That way it should properly set the detailed tax information for each product in the new orders that will be created and it should then not be a problem when you modify the order.
Please do the modification and confirm that new orders work properly on your website so that we can include the patch on our end for the next version of HikaShop.

The following user(s) said Thank You: daduts

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

  • Posts: 59
  • Thank you received: 4
  • Hikashop Business
2 years 2 months ago #344236

Thanks Nicolas

......this fix appears to be working.

note: I did it without removing the } in the first box.

many thanks

Dave

The following user(s) said Thank You: Philip

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

Time to create page: 0.074 seconds
Powered by Kunena Forum