+4
Looking 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
View original
+1
+4
No error, it says completed. I do have the HTTPS just like you typed me the example above.
+6
+4
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])
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
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])
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.