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