Try SureDone for FREE today!

We're software that helps growing brands & retailers grow and scale. Sync, sell and ship your products and inventory on online marketplaces and storefronts faster, easier and more accurately.

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