Thanks for your patience, everyone.
I’m getting closer on this but, after changing the importer and comparing to my personal transactions, I keep finding my assumptions about the CSV contents are wrong around pricing.
The report provides these price values:
- Price Tax
- Shipping Charge
- Item Subtotal
- Item Subtotal Tax
Price field appears to be the unit price and must be multiplied by
Quantity to render the cost for that line item.
I was surprised the the amount paid is just
Price and not
Price Tax— essentially, the
Price field includes
I thought that the
Item Subtotal would be the
Price multiplied by the
Quantity for a given product. Strangely,
Item Subtotal seems to include other items on the same order… so it cannot be used as part of the line-item price (i.e. it is useless).
Given what I know now, my plan is to:
- Leverage the
Shipping Charge in the line-item total as it appears to be discrete for each line item (i.e. not a blanket shipping charge for all items in the order)
- Use (
Shipping Charge for the Tiller-spreadsheet
Price Tax as I believe it is included in
- Assume that coupons, discounts and gift cards are somehow addressed in the
Price field— honestly, there is not a lot to work with here if the price calculation is complex
I appreciate what you said, @eslimko. I think it is best to wait a bit longer for some data that is mapped more intelligently. I think I’m getting close.