Before opening a new ticket, please verify SureDone status at https://status.suredone.com and also review our helpful articles below.

Start a new topic

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


image

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,

image

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. 

csv
(971 Bytes)

Thank you Rohit,

This has been fixed issue.


Regards,

Naveen

Login or Signup to post a comment