Blank Pre_tax_price in line_items table

Hi,

I recently encountered an issue, where the pre_tax_price in the line_items table is empty. However, quantity and and price columns seem to be correctly populated. Previously this has been working just fine. Any ideas what might be possible causes for the blank pre_tax_price field?

Hey @DeveloperQ

I have some context - my understanding with pre_tax_price is that it was only available to Shopify Plus Stores for a time and was largely an undocumented property/field in the API.

It’s actually been deprecated now, as it was used prior to a recode of the discounts function. Not sure if the order in question was an older order, but I believe most shops shouldn’t have orders with a pre-tax-price now. Let me know if that helps at all!

Hi @DeveloperQ ,

Pre_tax_price could be equal to 0 when a discount cancel the full amount of the line_items.

Is your order have discounts ?

Have a nice day,

Thomas.

Hi @Luke_K , we’re having the same issue on our store.. and the issue seems to have started when we downgraded from Shopify Plus to Advanced Shopify… if we were to upgrade again would that fix the problem? and if so will it be a permanent fix? or is there a chance the pre tax field will be removed soon and we should start looking at an alternative source for that data? Thanks

1 Like

Hi @Luke_K ,

I am interested in an alternative way to calculate the field pre_tax_price by using other fields from line_items so I could get the same result.
A vast majority of our customers have been using these fields when using Fivetran and we planned to add these fields but there is no documentation.

Please advice how to workaround the deprecation.