Correction to Shipping Amount and Discount Calculation Logic

Released May 27, 2025

Some Shopify orders are showing negative shipping amounts due to the shipping discount being subtracted twice during transformation. The shipping discount is currently included in the Total Cart Discount Amount, but not in the Total Discount Amount, leading to inconsistent discount representation.

Exclude the Shipping Discount from the Shipping Amount calculation in the Shopify Order Base transformation script. Adjust the Cart Discount calculation by explicitly subtracting the Shipping Discount from the Total Discount Amount in the same script. This update will ensure that shipping and discount values are accurately reflected in reporting and analytics.