​@ggesswein , yes, we’re exporting orders to Shopify, and they come through as fulfilled and paid. You can’t export invoices (at least you couldn’t last time I checked). Your use case seems exactly what Acumatica has built that process for. What issues are you encountering?

​@ggesswein 

Our goal is to give customers visibility to their Acumatica sales orders and invoices in their Shopify account. 

I think Acumatica build this Export Feature exactly for this purposes. What is you challenge? Did you checked the Wiki? → 

https://help.acumatica.com/(W(173))/Help?ScreenId=ShowWiki&pageid=d6ea8e6f-14bc-4a91-9ac3-dadce204606c

Thank you ​@Yuri Karpenko and ​@PatrickSchlenker90 for your quick replies! Our IT team will give this another try. I’ll share any roadblocks we encounter (if any) with the community, or if we have success. Thanks! 

Greg’s IT here.  Yes, thank you.  With some fiddling we got the completed history orders to sync back to Shopify via the connector, They are marked as paid, but with Shopify status of “Unfullfilled”  I cannot find any combination of entity mapping to to change that field.  I can pass the Acumatica status as a metafield but it still is customer confusing. 

So you know of anyway to change the Shopify “unful filled?”

Thanks

​@jharsh , not sure what Acumatica version you’re on. But this is what I’ve seen (below). In other words, you should be able to map the fulfillment status:

Be careful though, since whatever you set up in this mapping will apply to all orders that are synced from Acumatica to Shopify.

Let us know if you have further questions.

Thanks Yuri,

Can you resend the image, the right value is cut off,

Best,

John

​@jharsh , we don’t use that mapping. It was for illustration only. But here’s what I would do (as far as formula in that field):

=Switch(=SalesOrder.Status]='Completed', 'FULFILLED', ISalesOrder.Status]='Invoiced', 'FULFILLED', 'UNFULFILLED')

This means if order is Invoiced or Completed, then use Fulfilled status, otherwise - Unfulfilled.