Duplicated tax_lines for subscription products???

mwex501
Shopify Partner
11 0 5

One of my clients has an issue where orders are unable to import into Unleashed inventory management system. We evened down the issue to only Recharge subscription orders.

Unleashed states the issue is with the tax data in the API. On the orders in question, Shopify outputs the tax_lines object multiple times, once for each line item. If an order has 3 line items of subscription products, the tax_lines object outputs 3 times.

Recharge states that these tax_lines are created solely in Shopify, not by their interaction with the orders.

 

Consider this:

--------------------
Non-subscription order with 3 line items. Produces a single tax line object (as it should):

 

"tax_lines": [{
"price": "3.04",
"price_set": {
"shop_money": {
"amount": "3.04",
"currency_code": "GBP"
},
"presentment_money": {
"amount": "3.04",
"currency_code": "GBP"
}
},
"rate": 0.23,
"title": "IE VAT"
}
],

 

-------------------
Subscription order with 2 subscription line items. Produces 2 tax line objects (should only produce 1).

 

"tax_lines": [{
"price": "1.37",
"price_set": {
"shop_money": {
"amount": "1.37",
"currency_code": "GBP"
},
"presentment_money": {
"amount": "1.37",
"currency_code": "GBP"
}
},
"rate": 0.23,
"title": "IE VAT"
}, {
"price": "1.37",
"price_set": {
"shop_money": {
"amount": "1.37",
"currency_code": "GBP"
},
"presentment_money": {
"amount": "1.37",
"currency_code": "GBP"
}
},
"rate": 0.23,
"title": "IE VAT"
}
],

 

---------------------
The Unleashed software will attempt to import each tax_line object as valid, doubling, tripling, etc, the taxes for the order as a result.

What can we do to make sure these orders do not have superfluous tax lines in the data?

Thanks!

Replies 11 (11)

TNN
Shopify Partner
3 0 1

We have a client who is experiencing the same issue with Unleashed but with orders generated through Appstle Subscriptions & Loyalty. All orders generated through the subscription with only one item will process just fine, but all orders with multiple products will generate additional tax lines (GST in this case). This results in 10% + 10% (20%) for two items, 10% + 10% + 10% (30%) for three items, and so on.


The Unleashed devs provided this as an example:

example.jpg

We've reported the issue to the Appstle developers but have responded to us saying they don't apply the tax rates, they just issue a request to the Subscriptions API via a SubscriptionBillingAttemptCreate call. Given this post and that it's happened with another product, it leads me to believe this is an issue occurring within the Subscriptions API.

 

I've also performed a test with the client where we created subscription orders using products with and without taxation set. The subscription orders where an item was taxable had tax lines equal to the number of products in the order, regardless of taxable status (i.e., an order with 2 taxable and 1 non-taxable would have 3 tax lines). The test item that wasn't taxable had an empty tax lines array.

 

Any assistance with this would be hugely appreciated.

mwex501
Shopify Partner
11 0 5

@TNN There was not out-of-the-box fix or solution. The only option available to us was to build our own API integration between Shopify and Unleashed which was cost prohibitive for this client.

alg97
Tourist
3 0 1

@TNN were you able to solve this in any way? I'm experiencing the similar problem with the combination ReCharge - Shopify - Unleashed where the tax lines are added..  

alg97_0-1669294666950.png

 

TNN
Shopify Partner
3 0 1

Sadly no. We tried to raise it with Appstle and Unleashed to contact Shopify through whatever support channels they have (since advisor support washes their hands of anything to do with the API). Nothing but radio silence since the initial correspondence.

 

At this point we've just provided the client with a spreadsheet to ID the orders that weren't imported to provide a quick and dirty reference for stock adjustments. Editing the orders affected isn't possible without GraphQL knowledge and dev experience, which we don't really have. We might also try asking Unleashed if they can at least give a workaround option to truncate tax lines to just the first item for each product.

 

Either way I'm afraid I don't have anything else to offer right now. Will definitely post an update if we get some momentum somewhere.

Jiazhen
Shopify Partner
23 1 1

I think I've figured this out.

The subscription product must have ticked `charge tax on this product`. By removing the tick, the additional tax line will be removed

alg97
Tourist
3 0 1

Can you provide more information? We don't have a specific subscription product, the products are available either as one-time purchase or as subscriptions. So we still need to have "charge tax on this product" activated in Shopify. 

Philibert_Dugas
Shopify Staff
36 13 16

Thanks for the report! This should be fixed, let us know if there's still any issues

To learn more visit the Shopify Help Center or the Community Blog.

Jiazhen
Shopify Partner
23 1 1

Hi, thanks for the update.

Just to clarify, it's fixed as in that subscription API now can consolidate the tax line? For example, if "charge tax on this product" is ticked, it won't duplicate the tax lines?

alg97
Tourist
3 0 1

Thanks for taking action on this! Just checked this morning and it seems the issue has been fixed now. Since the patch on the 27th, all orders have gone through without any problems.

Philibert_Dugas
Shopify Staff
36 13 16

👍 the Subscriptions API should have the same behaviour as the checkout now. The duplicate tax lines issue should not be happening anymore

To learn more visit the Shopify Help Center or the Community Blog.

TNN
Shopify Partner
3 0 1

Just checked this with our client, we can see two orders from 29Jan23 (Australian time), which had multiple line items successfully imported into Unleashed! Orders prior to this date appear to have not been imported yet, but we can retry them.

We're monitoring to be 100% sure but it's made our week to see this finally addressed.