How to Search Query for Returning Items Available for Store Pickup in Netsuite Suite Commerce?

Hello Everyone,

This is most common functionality used in Suite Commerce. In this post we are going to describe how to query Item with availability in Netsuite.

To create a field set that includes information about item quantity available for store pickup:

1. Go to Setup > SuiteCommerce Advanced > Set Up Web Site.
   
2. Click the Field Sets subtab.
   
   1. Enter a Name for the field set. For example, enter Store Pickup.
      
   2. Enter a Field Set ID for the field set. For example, enter storepickup_details.
      
   3. Select Item for Record Type.
      
   4. (Optional) Enter a description for the field set.
      
   5. In the Field Set popup window, select the store pickup related field names identified in the table below.
      
   6. Click Add.
      
3. Click Save
4. Use the field set in a query to the Item Search API

Item Fields Related to Store Pickup

The table below shows the item record fields that correspond with fields exposed to field sets.

Field Label on the Locations Subtab of the Item Record	Field Set Field Name	Field ID
Allow Store Pickup	Store Pickup Allowed	isstorepickupallowed
Quantity Available For Store Pickup	Available For Store Pickup (Detail)	quantityavailableforstorepickup_detail

When you use the isstorepickupallowed field with the Item Search API and set it to true, the Item Search API returns the item IDs of all the matching items for which store pickup is enabled. When this field is set to false, the Item Search API returns the item IDs of all the matching items for which store pickup is not enabled.
If you enable the Multi-Location Inventory feature and host a SuiteCommerce Advanced web site, you can access the item quantity per location.
If you use the quantityavailableforstorepickup_detail field with the Item Search API, you can also access the item quantity available for store pickup per location.

http://www.mywebstore.com/api/items?isstorepickupallowed=true

&fields=quantityavailable_detail,quantityavailableforstorepickup_detail

Response:

"items":[
      {
            "internalid":388,
            "quantityavailable_detail":{
                  "quantityavailable":90.0,
                  "locations":[
                        {
                              "internalid":2,
                              "quantityavailable":39.0
                        },
                        {
                              "internalid":3,
                              "quantityavailable":51.0
                        }
                  ]
               },
               "quantityavailableforstorepickup_detail":{
                     "locations":[
                           {
                                 "internalid":2,
                                 "qtyavailableforstorepickup":39.0
                           },
                           {
                                 "internalid":3,
                                 "qtyavailableforstorepickup":51.0
                           }
                     ]
               }
      },
      {
            "internalid":387,
            "quantityavailable_detail":{
                  "quantityavailable":150.0,
                  "locations":[
                        {
                              "internalid":2,
                              "quantityavailable":150.0
                        }
                  ]
            },
            "quantityavailableforstorepickup_detail":{
                  "locations":[
                        {
                              "internalid":2,
                              "qtyavailableforstorepickup":150.0
                        }
                  ]
            }
      },
      {
            "internalid":107,
            "quantityavailable_detail":{
                  "quantityavailable":4.0,
                  "locations":[
                        {
                              "internalid":2,
                              "quantityavailable":3.0
                        },
                        {
                              "internalid":3,
                              "quantityavailable":1.0
                        }
                  ]
            },
            "quantityavailableforstorepickup_detail":{
                  "locations":[
                        {
                              "internalid":2,
                              "qtyavailableforstorepickup":3.0
                        }
                  ]
            }
      }
],

Thanks
Abhi



 Download Netsuite Guru Android App
Follow Me on Linkedin
Our FB Page