After going back and forth with support over several days, I find out that shipstation is mapping the "Total Order" amount to the "Total Paid" field, regardless of payment status. We import our Shipstation orders to Quickbooks and my 'awaiting_payment' status orders are importing as paid. I'm going to make the safe assumption that all marketplace api's export the actual 'amount paid'! This is the field that should be mapped to 'total paid' in order details!!!!
Jaime Reyes Growers House commented
I will certainly be able to find more examples. I'll get some to you shortly, both with and without discounts.
We are using Brightpearl and ShipStation connects and imports the orders, it is just that one variable that is not being read properly.
Growers House Growers House commented
This would be VERY helpful to have working properly for us too. The Order Total is for the total of "That order's individual shipment" - Not the Total Paid on the entire order.
We run into this daily. We have a rule set to add Signature Required when the Order Total (*that* shipment) value is greater than $750. Scenario for a single order follows:
Customer orders 100 items that sell for $10/each, we have 99 of them in stock so we ship 99 of them on one shipment who's value is $990 (over $750, so the automated rule adds a signature required to *that* shipment (costing us $6).
Later on,we ship the last single item (the 100th) all by itself, but when that order goes to ShipStation with an Order Total of $10 (under the $750 Order Total), but ShipStation only considers the Paid Total, so the Automation rule adds a signature required flag costing us $6 on a $10 item that FedEx automatically covers the first $100 if anything happens to that package.
Not to mention the inconvenience for a customer who has to be sure to be home to receive small inexpensive followup items, just to sign for them.
Which selling channel are you seeing the imported amounts for both Total Order and Amount Paid as being the same amount?
Also, are there discounts that should be applying to the amount paid that are not and do these show in the marketplace but when the orders import into ShipStation they disappear?
And if so, is there an example order that you can give me from your account so we can look over this with our support team?