Actual Shipping Cost

[heinscott]

Hello. Not sure if I am missing this, but where does Able store what a shipment actually costs? We track this information very carefully, and absolutely need it for proper profit/loss analysis.
Thanks

Scott

[Shopping Cart Admin]

Hello Scott,

It would be in the OrderItems table.

[heinscott]

Sorry... I think I may have not explained properly...
I didn't mean what the customer was charged for shipping, but what we were charged by UPS to ship the order.
Thanks,

Scott

[Shopping Cart Admin]

Hello Scott,

We don't have a way to get that figure, so there isn't a place to store it built into our system.

[heinscott]

I understand that... It's normal, though, for many companies to import data such as tracking numbers and shipping costs from some kind of 3-third party shipping software. Makes it easier to not to have to look in multiple spots when figuring out what people are ordering versus what the shipping cost to us was, etc... I assume that importing tracking won't be too much of a problem, but, the shipping cost would definitely be nice to have.
I suppose the best alternative is to add a separate table and data layer for this?
Thanks for the help,

Scott

[afm]

Shipper tracks both shipping costs (the amount the customer was charged by the merchant for shipping and the amount the merchant was charged by the carrier). You also can send the actual shipping cost back to AC, but as Mike pointed out there is no where to store it, so my version of the Shipping Agent does not store it. However the Shipping Agent code is open source (http://www.codeplex.com/ShippingAgent) so you could modify the code to store the actual shipping cost in your own table or other system.

[AbleMods]

I've been on-the-fence about writing something to do this for my business.

Kills me every month now as I have to edit hundreds of QuickBooks bills imported from AC7 to get shipping charge costs to match up with what I was charged by my distributors.

Orders and OrderItems data classes really need a custom fields class like ProductCustomFields. It'd give so much more flexibility for the backside of order management.

[sohaib]

Orders and OrderItems data classes really need a custom fields class like ProductCustomFields. It'd give so much more flexibility for the backside of order management.

I agree. I have posted a request for enhancement for the future version.