Page 1 of 1
dotConnect for Magento
Posted: Thu 09 Feb 2017 14:26
by kwasek83
Hello,
I need to extract Shipping Arrival Date? This is crucial point of ordering this addin
thank you
Re: dotConnect for Magento
Posted: Mon 13 Feb 2017 13:26
by Pinturiccio
Magento API does not allow getting such data. There is a SalesOrderShipments entity in Magento. You can only get the creation date of a shipment via the following query:
Code: Select all
SELECT sh.created_at as "Shipping Create Date", o.* FROM "SalesOrderShipments" AS sh inner join SalesOrders o ON sh.order_id = o.order_id