+4Looking for instructions on how to map the export from Acumatica to Shopify. I want to export the URL of the order in Acumatica to Shopify. This will help users quickly open the order in Acumatica.
I can map the actual order number via the standard available fields. However, that’s a static field with out the URL. I’m looking for info on how to map the URL at the beginning.
Best answer by Yuri Karpenko
The URL of each order follows this patter: https://{companyWebsite}.acumatica.com/Main?CompanyID={companyID}&ScreenId=SO301000&OrderType={orderType}&OrderNbr={orderNbr}
So, if your Acumatica URL is jeff96.acumatica.com, and your company is Production, and your order is SO 12345, then your URL will look like this:
https://jeff96.acumatica.com/Main?CompanyID=Production&ScreenId=SO301000&OrderType=SO&OrderNbr=12345
In your mapping for Sales order, you can use this formula then:
=Concat( 'https://jeff96.acumatica.com/Main?CompanyID=Production&ScreenId=SO301000&OrderType=', [SalesOrder.OrderType], '&OrderNbr=', [SalesOrder.OrderNbr])
+6The URL of each order follows this patter: https://{companyWebsite}.acumatica.com/Main?CompanyID={companyID}&ScreenId=SO301000&OrderType={orderType}&OrderNbr={orderNbr}
So, if your Acumatica URL is jeff96.acumatica.com, and your company is Production, and your order is SO 12345, then your URL will look like this:
https://jeff96.acumatica.com/Main?CompanyID=Production&ScreenId=SO301000&OrderType=SO&OrderNbr=12345
In your mapping for Sales order, you can use this formula then:
=Concat( 'https://jeff96.acumatica.com/Main?CompanyID=Production&ScreenId=SO301000&OrderType=', [SalesOrder.OrderType], '&OrderNbr=', [SalesOrder.OrderNbr])
+4The URL of each order follows this patter: https://{companyWebsite}.acumatica.com/Main?CompanyID={companyID}&ScreenId=SO301000&OrderType={orderType}&OrderNbr={orderNbr}
So, if your Acumatica URL is jeff96.acumatica.com, and your company is Production, and your order is SO 12345, then your URL will look like this:
https://jeff96.acumatica.com/Main?CompanyID=Production&ScreenId=SO301000&OrderType=SO&OrderNbr=12345
In your mapping for Sales order, you can use this formula then:
=Concat( 'https://jeff96.acumatica.com/Main?CompanyID=Production&ScreenId=SO301000&OrderType=', [SalesOrder.OrderType], '&OrderNbr=', [SalesOrder.OrderNbr])
Thanks. This helped me get it into a text line metafield, but I can’t get it into a URL metafiled. Do you know why that is?
+6+4No error, it says completed. I do have the HTTPS just like you typed me the example above.
+1Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.