Back to connectors… Back to Other...

Shopify v4.1PU5 Pull Unfulfilled and Partially Fulfilled orders (5 replies)

Sue Herrmannn
5 years ago
Sue Herrmannn 5 years ago

I have a client who is pulling down orders from their customer's Shopify website. Recently that customer chose to add digital videos to their product offering - these items are immediately fulfilled on the order. So if the order has both physical products that must ship and digital items, the order fulfillment status is set to Partially Fulfilled by the time I try to pull the order down.

Can I somehow enter both a status of Unfulfilled and Partially Fulfilled in the fulfillment status field of the shopify order reader event? Or do I need to run two jobs? One for unfulfilled and one for partially fulfilled? (I need to filter the reader event because the volume of orders is so huge, the reader times out if I don't have the filters set.)

Thanks! 

Support
5 years ago
Support 5 years ago

What happens when you put a comma in between the two statuses on the Reader?

Sue Herrmannn
5 years ago
Sue Herrmannn 5 years ago

I think I need clarification on which filters work and when. I have the following entered in the Shopify Order Reader event before I hit refresh on the screen:

Fulfillment Status = Partially fulfilled            (I only have one order from this morning with that status)

Order Status = Open

REQUIRED: Orders placed in the last: = 30m

When I hit refresh, it pulls all orders within the last 36 hours. Because it's Monday, none of these orders have been shipped. So I don't know if the Open order status is working. But it is definitely not pulling: only partially fulfilled or just the last 30 minutes.

Do these filters only work when you run the job? (I was under the impression that all filters should work with the Refresh in the Reader event, but if you ran the job, it paid attention to all filters except the REQUIRED filter - because it always pulls the last date time stamp from the Shopify lookup UTC + 24 hours...)

Sorry - but clarification on this will help me manipulate the data so I can tell you better what is working and what isn't... thanks! 

Support
5 years ago
Support 5 years ago

Sue, the timespan is only a design time parameter, it should be respected.

The Fulfillment Status enter: partial, unshipped

Order Status: open

Sue Herrmannn
5 years ago
Sue Herrmannn 5 years ago

Thanks! I had the values for the Fulfillment Status wrong. I was using what I saw in the order on Shopify... I should have realized there were behind the scenes values that I needed to use -- I'm assuming you found these using a json query on shopify? 

Support
5 years ago
Support 5 years ago

No, it's both documented in our documentation and the values can be found from the link to the Shopify API from our documentation.

https://www.realisable.co.uk/support/Documentation/shopify/Touchpoints/OrderDownload.htm

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close