Hello, we are trying to get orders data incrementally, including associated line items on the order. As we understand, line items have their own updated_at field, just like orders.
What would be the updated_at for an order reflects updates to the order line items and the value changes accordingly?
As in if we use updated_from filter for orders, will be get orders that have their line items updated? Thank you.
Hi @sv_iq_321
Welcome to the ShipHero community!
Orders and line items are related in many ways. If you change the price on a line item, it could affect the subtotal of the order, so the update_at will change for both the order and the line item.
On the other hand, if you change the profile field, the updated_at of the line item won’t change.
I hope that was clear enough. Feel free to ask me any other questions.
Have a nice day!
Thank you. How about fulfillment updates on order line, say quantity_shipped or backorder_quantity ? Would that be treated as an updated at the order level?
Hi @sv_iq_321
quantity_shipped most likely will be recorded in the order_history, or if its the only line_item, it will change the fulfillment_status of the order. That could be an udpate at the order level.
backorder_quantity could not update the order updated_at if the product run out of stock.
Basically, if any field of the orders level is changed, it will update the updated_at.
Have a nice day!