Hello,
I need to extract Shipping Arrival Date? This is crucial point of ordering this addin
thank you
dotConnect for Magento
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: dotConnect for Magento
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