Creating a Search for Shopping Cart Information

The following examples show how you can use the SuiteScript 2.1 N/search module to create and run a search for shopping cart information.

Use the following code snippet to search carts from a certain website (ID:1) which contain a particular item (item ID:352):

              require(['N/search'], function(search) {
    // Create a search for shopping cart records
    var cartSearch = search.create({
        type: search.Type.SHOPPING_CART
    });

    // Create search filters
    var websiteIdFilter = search.createFilter({
        name: 'websiteid',
        operator: search.Operator.ANYOF,
        values: [1]
    });

    var itemIdFilter = search.createFilter({
        name: 'itemid',
        operator: search.Operator.ANYOF,
        values: [352]
    });

    // Create search columns
    var itemIdColumn = search.createColumn({
        name: 'itemid'
    });

    var itemQtyColumn = search.createColumn({
        name: 'itemqty'
    });

    var websiteIdColumn = search.createColumn({
        name: 'websiteid'
    });

    var customerIdColumn = search.createColumn({
        name: 'customerid'
    });

    // Add the filters and columns to the search
    cartSearch.filters = [websiteIdFilter, itemIdFilter];
    cartSearch.columns = [itemIdColumn, itemQtyColumn, websiteIdColumn, customerIdColumn];

    // Run the search
    var results = cartSearch.run();
});

Use the following code snippet to access the shopping cart using the customer record. This snippet is written to get carts from all websites visited by a certain customer (ID:324):

              require(['N/search'], function(search) {
    // Create a search for customer records
    var customerSearch = search.create({
        type: search.Type.CUSTOMER
    });

    // Create a search filter
    var internalIdFilter = search.createFilter({
        name: 'internalid',
        operator: search.Operator.ANYOF,
        values: [324]
    });

    // Create search columns
    var websiteIdColumn = search.createColumn({
        name: 'websiteid',
        join: 'shoppingcart'
    });

    var itemIdColumn = search.createColumn({
        name: 'itemid',
        join: 'shoppingcart'
    });

    var itemQtyColumn = search.createColumn({
        name: 'itemqty',
        join: 'shoppingcart'
    });

    // Add the filter and columns to the search
    customerSearch.filters = [internalIdFilter];
    customerSearch.columns = [websiteIdColumn, itemIdColumn, itemQtyColumn];

    // Run the search and get the value of the websiteid field in each result
    customerSearch.run().each(function(result) {
        var websiteIdField = result.getValue({
            name: 'websiteid'
        });
        
        // Work with the websiteid value
        
        return true;
    });
});

Related Topics