Shipping method override for order export automation
Hello,
We do have a requirement to send vendor specific shipping service code in place of shipping service value available at suredone order data.
here are some example of map
| Carrier/Service | Shipping service in order | Shipping code in PO file |
| FedEx 2nd Day | Two Day Delivery | 124 |
| FedEx Next Day | Expedited Delivery | 123 |
I tried Suredone actions to export vendor specific shipping code in place of shipping service but that didn't work. Here are the example of code
[
{
"name": "438759_order_{{DATE}}_{{TIME}}.csv",
"date_format": "ymd",
"time_format": "His",
"order_payload_line_item": 1,
"order_update_export": {
"status": "ORDERED",
"itemstatus": "ORDERED"
},
"search": "source:=anchorstock itemstatus:= status:-=COMPLETE status:-=REJECTED status:-=CANCELED archived:=0",
"field_format": {
"shippingname": {
"combine": {
"fields": [
"shippingfirstname",
"shippingmiddlename",
"shippinglastname"
],
"delimiter": " "
}
}
},
"field_map": {
"ordernumber": "OrderNumber",
"Name": "shippingname",
"shippingcompany": "Company",
"shippingstreet1": "Address1",
"shippingstreet2": "Address2",
"shippingcity": "City",
"shippingstateprovince": "State",
"shippingpostalcode": "Zip",
"shippingcountry": "Country",
"countrycode": "CountryCode",
"sku": "SKU",
"title": "Product",
"quantity": "QtyOrdered",
"date": "OrderDate",
"price": "Price",
"total": "GrandTotal",
"email": "Email",
"shippingmethod": "shippingmethod",
"InsuranceAmount": "InsuranceAmount",
"NoteToCustomer": "NoteToCustomer",
"FlagCommercialAddress": "FlagCommercialAddress",
"FlagSignatureRequired": "FlagSignatureRequired",
"shippingphone": "PhoneNumber",
"BOCode": "BOCode"
},
"suredone_actions": [
{
"search": "shippingservice:=\"Two Day Delivery\"",
"setValue": {
"shippingmethod": 124
}
},
{
"search": "shippingservice:=\"Expedited Delivery\"",
"setValue": {
"shippingmethod": 123
}
}
]
}
]
Any help with above mentioned automation config will be highly appericated. Thanks in advance.
Hello Naveen,
If you have added shippingservice as an order item customer field, please try the search with "shippingservice":="Two Day Delivery"
Thanks,
SureDone Support
Rohit,
I already did that, you can verify the automations Anchor_order_export #1079
Thanks,Naveen
Naveen,
That is not the format I suggested, seems you have an additional " at the end of the string. Please retry.
Thanks,
Rohit
Rohit,
I tried that as well but it didn't work,
Thanks,Naveen
Hi Naveen,
Seeing some extra spaces towards the end of the string in your config, can you rectify and retry?
Best,
Rohit
Rohit,
Those have been fixed and still there is no success. Can have try to fix and run the automation to check the exact issue here?
Thanks,
Naveen
Naveen, this works now. Changed "suredone_actions" to "vendor_actions" and it worked. See attached debug file.
Thank you Rohit,
This has been fixed issue.
Regards,
Naveen