Remove Underscore Line Item Properties from Shipstation

This step listens for new orders in ShipStation and captures the basic order information needed to retrieve the full order details. The trigger activates whenever ShipStation receives a new order notification, whether from your ecommerce platform, marketplace, or manual entry. It passes the order ID to the next step so the workflow can fetch complete order details including line item properties that need cleaning.

This step uses the order ID from the trigger to pull the full order record from ShipStation's API, including all line items and their associated properties. The system automatically configures the API call using the order ID captured in the previous step. This retrieval is essential because the initial trigger only provides basic order information, but the cleaning process needs access to the detailed line item properties where underscore fields are stored.

This custom code step processes each line item in the order and filters out properties whose names start with an underscore character. The script loops through all items in the order and removes unwanted properties from the options array. However, there appears to be a bug in the current code - it's checking for a space character instead of an underscore. The corrected version should filter properties where the first character is an underscore rather than a space.

const Mesa = require('vendor/Mesa.js');

module.exports = new (class {
  script = (prevResponse, context) => {
    const vars = context.steps;
    let updatedShipstationOrder = vars.shipstation_1;

    // Remove line item properties starting with underscore
    for (let item of updatedShipstationOrder.items) {
      item.options = item.options.filter(option => 
        option.name.charAt(0) !== "_"  // Fixed: was checking for " " instead of "_"
      );
    }

    Mesa.output.next({updatedShipstationOrder: updatedShipstationOrder});
  };
})();

This step takes the cleaned order data and sends it back to ShipStation using their Create/Update Order API endpoint. The code retrieves your ShipStation API credentials, constructs the proper authorization header, and makes a POST request to update the order with the cleaned line item properties. You'll need to create a ShipStation credential in MESA before this step will work - the credential should contain your ShipStation API key and secret. The updated order replaces the original in ShipStation with all underscore properties removed from line items.

const Mesa = require('vendor/Mesa.js');

module.exports = new (class {
  script = (prevResponse, context) => {
    const vars = context.steps;
    let updatedShipstationOrder = vars.custom.updatedShipstationOrder;

    // Get ShipStation credential (needs to be created first)
    let credential = JSON.parse(Mesa.credential.get('shipstation'));
    let authHeader = Mesa.request.base64_encode(`${credential.key}:${credential.secret}`);

    let options = {
      "headers": {
        "Content-Type": "application/json",
        "Authorization": "Basic " + authHeader,
      }
    };

    let url = 'https://ssapi.shipstation.com/orders/createorder';
    let results = Mesa.request.post(url, updatedShipstationOrder, options);   

    Mesa.output.next(prevResponse);
  };
})();