philjw

Apologies, John. I don’t seem to receive email notifications of a reply. I’ll look into that.

The answer is no. The Tax Class is Standard.

Hi @wpnomad,

This is what I get for a 98104 zip code in Seattle. Let me know if this helps.

09-04-2023 @ 05:47:31 – Requesting: taxjar/v2/taxes – {“from_country”:”US”,”from_state”:”WA”,”from_zip”:”98033″,”from_city”:”Kirkland”,”from_street”:”xxxxxxxxxxx”,”to_country”:”US”,”to_state”:”WA”,”to_zip”:”98104″,”to_city”:”Seattle”,”to_street”:”xxxxxxxxxxx”,”shipping”:”8.6″,”plugin”:”woo”,”line_items”:[{“id”:”xxxxxxxxxxx”,”quantity”:1,”product_tax_code”:””,”unit_price”:”11.50″,”discount”:”0″},{“id”:”xxxxxxxxxxx”,”quantity”:1,”product_tax_code”:”99999″,”unit_price”:”44.98″,”discount”:”0″}]} (WCS Tax)
09-04-2023 @ 05:47:31 – Received: {“tax”:{“amount_to_collect”:2.06,”breakdown”:{“city_tax_collectable”:0.23,”city_tax_rate”:0.0115,”city_taxable_amount”:20.1,”combined_tax_rate”:0.1025,”county_tax_collectable”:0.06,”county_tax_rate”:0.003,”county_taxable_amount”:20.1,”line_items”:[{“city_amount”:0.0,”city_tax_rate”:0.0,”city_taxable_amount”:0.0,”combined_tax_rate”:0.0,”county_amount”:0.0,”county_tax_rate”:0.0,”county_taxable_amount”:0.0,”id”:”xxxxxxxxxxx”,”special_district_amount”:0.0,”special_district_taxable_amount”:0.0,”special_tax_rate”:0.0,”state_amount”:0.0,”state_sales_tax_rate”:0.0,”state_taxable_amount”:0.0,”tax_collectable”:0.0,”taxable_amount”:0.0},{“city_amount”:0.13,”city_tax_rate”:0.0115,”city_taxable_amount”:11.5,”combined_tax_rate”:0.1025,”county_amount”:0.03,”county_tax_rate”:0.003,”county_taxable_amount”:11.5,”id”:”xxxxxxxxxxx”,”special_district_amount”:0.26,”special_district_taxable_amount”:11.5,”special_tax_rate”:0.023,”state_amount”:0.75,”state_sales_tax_rate”:0.065,”state_taxable_amount”:11.5,”tax_collectable”:1.18,”taxable_amount”:11.5}],”shipping”:{“city_amount”:0.1,”city_tax_rate”:0.0115,”city_taxable_amount”:8.6,”combined_tax_rate”:0.1025,”county_amount”:0.03,”county_tax_rate”:0.003,”county_taxable_amount”:8.6,”special_district_amount”:0.2,”special_tax_rate”:0.023,”special_taxable_amount”:8.6,”state_amount”:0.56,”state_sales_tax_rate”:0.065,”state_taxable_amount”:8.6,”tax_collectable”:0.88,”taxable_amount”:8.6},”special_district_tax_collectable”:0.46,”special_district_taxable_amount”:20.1,”special_tax_rate”:0.023,”state_tax_collectable”:1.31,”state_tax_rate”:0.065,”state_taxable_amount”:20.1,”tax_collectable”:2.06,”taxable_amount”:20.1},”freight_taxable”:true,”has_nexus”:true,”jurisdictions”:{“city”:”SEATTLE”,”country”:”US”,”county”:”KING”,”state”:”WA”},”order_total_amount”:65.08,”rate”:0.1025,”shipping”:8.6,”tax_source”:”destination”,”taxable_amount”:20.1}} (WCS Tax)
09-04-2023 @ 05:47:31 – :: Adding New Tax Rate :: (WCS Tax)
09-04-2023 @ 05:47:31 – {“tax_rate_country”:”US”,”tax_rate_state”:”WA”,”tax_rate_name”:”US-WA-KING-SEATTLE Tax”,”tax_rate_priority”:1,”tax_rate_compound”:false,”tax_rate_shipping”:1,”tax_rate”:10.25,”tax_rate_class”:””} (WCS Tax)
09-04-2023 @ 05:47:31 – Tax Rate ID Set for 272 (WCS Tax)
09-04-2023 @ 05:47:31 – :: Tax Rate Found :: (WCS Tax)
09-04-2023 @ 05:47:31 – {“272”:{“rate”:10.25,”label”:”US-WA-KING-SEATTLE Tax”,”shipping”:”yes”,”compound”:”no”}} (WCS Tax)
09-04-2023 @ 05:47:31 – :: Updating Tax Rate To :: (WCS Tax)
09-04-2023 @ 05:47:31 – {“tax_rate_country”:”US”,”tax_rate_state”:”WA”,”tax_rate_name”:”US-WA-KING-SEATTLE Tax”,”tax_rate_priority”:1,”tax_rate_compound”:false,”tax_rate_shipping”:1,”tax_rate”:10.25,”tax_rate_class”:””} (WCS Tax)
09-04-2023 @ 05:47:31 – Tax Rate ID Set for 272 (WCS Tax).

Thanks for getting back to me. Currently, in Washington State where my client has a nexus, tax is applied to the full shipping fee ($10 for example).

So the answer to your last question is ‘yes, correct: Only 20% of the shipping cost should be taxed.’
I can’t paste a screenshot, but let’s try it as text:

Our Signature Bread Packaging – Two Sets of 25 (Ships Direct)??×?1= $11.50
Breader Together Energy Cookie Base & Packing Kit (3-pack)??×?1= $44.98
Subtotal = $56.48
Shipping: Flat Rate Box:?<bdi>$8.60</bdi>

Tax$2.06
Total<bdi>$67.14</bdi>

Tax for Seattle in this example, is 10.5%, and only the Bread Packaging is taxable. So the expected tax charged should be $1.39

Thank you for the response, Katerinaz.

I was hoping that you might have hit that before since you support the state of Washington and all the different tax rates used by each city.

Our example is selling both food items (zero-rate tax) and non-food products on the same site, which can’t be that unusual.

Do you have plans to update to support this in the future?

I will check the advanced shipping packages you suggest.

I’d be interested in this too, as I was surprised this wasn’t already an option.

It seems like a straightforward update. Thanks for documenting it Ramon.

– Phil Wooldridge

• This reply was modified 2 years, 2 months ago by philjw.

Hi Niklas,

I instrumented the plugin, and this is indeed the cause of the lost order items.

For the order I examined, the tax rate was 10.1% on 4 items costing $4.5 each.

WooCommerce seems to have calculated the tax to more decimal places or calculated the item total ($18) first before applying the tax.

The data WooCommerce Paypal Payments works with is a per item tax rounded up and then multiplied by the item count.

It seems that just dropping the order details is somewhat overkill. What data do you get to work with? Can you calculate the tax on the total rather that the individual items? Or just adjust the total (amount_total in the ditch_items_when_mismatch function) to match amount_value?

The order dropped the email too, but there was a billing email to work with.Can you address that too?

If this is not your responsibility, can you tell me who I should contact?

Thanks and regards,

– Phil

Hi Niklas,

I don’t think we are experiencing any subtotal mismatches. We have not yet found a pattern either.

I have dozens of examples, but obviously have to be careful to protect customer information.

This is the plugin log for order 8529. This was missing product information and an email address.

[{“op”:”replace”,”value”:{“reference_id”:”default”,”amount”:{“currency_code”:”USD”,”value”:”14.65″},”description”:””,”payee”:{“merchant_id”:”xxxxxxxxx”},”shipping”:{“name”:{“full_name”:”**xxxx**”},”address”:{“country_code”:”US”,”address_line_1″:”123 xyxyxyx”,”address_line_2″:””,”admin_area_1″:”WA”,”admin_area_2″:”Shelton”,”postal_code”:”98123″}},”custom_id”:”8529″,”invoice_id”:”WC-8529″},”path”:”\/purchase_units\/@reference_id==’default'”}]

One thing I do notice is how complex the tax calculations are in Washington state, where every town seems to have its own tax rate. Is this likely to be related do you think? On this order for example, the tax on an item (quantity=3) was $1.15 on $13.50.

Could you extend the logging to record when information is being dropped and why? It won’t take long to get results.

Thank you!

– Phil

This may be related. My client upgraded to this version of the plugin in December 2021, and since then fields have been randomly missing from the data sent to Paypal. Orders do seem to go through OK, though there have been random reports of failures too.

This is an example from yesterday (x’s replace client identifying info) where the order items (3 of them) and the customer email were not sent to Paypal, though all are present in the WooCommerce email. It means the email the customer receives from Paypal is often devoid of identifying inforation, which is causing some frustration.

2022-02-10T21:27:04+00:00 DEBUG PATCH https://api.paypal.com/v2/checkout/orders/XXXXXXXXXXXXXXXXXXXX
Request Body: [{"op":"replace","value":{"reference_id":"default","amount":{"currency_code":"USD","value":"26.91"},"description":"","payee":{"merchant_id":"XXXXXXXXX"},"shipping":{"name":{"full_name":"Ann Daaga"},"address":{"country_code":"US","address_line_1":"XXX Ct","address_line_2":"","admin_area_1":"WA","admin_area_2":"Redmond","postal_code":"XXXXX"}},"custom_id":"8953","invoice_id":"WC-8953"},"path":"\/purchase_units\/@reference_id=='default'"}]
Response Debug ID: b0c0f9773b071
Response: Array
(
    [code] => 204
    [message] => No Content
)

I am prepared to instrument the plugin code if that would help figure this out.