Pincode serviceability via workspace

Summary

Pincode serviceability is required by a client to identify the list of pin codes which are serviceable for delivery. This helps the client to accept orders from only those locations which are serviceable. The serviceability of a pincode keeps on varying depending on multiple factors like stressed courier location, any natural calamity, geographical or political disturbances etc. A pincode which is serviceable now can be unserviceable tomorrow due to multiple factors.

With the help of this BRD, we would like to provide the client access to the serviceable pin codes on the Eshopbox workspace.

Current approach and limitations

Currently, the courier partner shares the updated list of serviceable pin codes over email or we can download the same from their courier panel. Each courier has different pincode serviceability. Example:

• A pincode serviceable from Delhivery can be unserviceable from Ecom Express.

• A pincode serviceable from Delhivery Express can be unserviceable from Delhivery standard.

Available options to the client to track pincode serviceability:

• Integration Eshopbox API: This is a readily available option but the limitation with this approach is that this requires development efforts at the client end and all clients are not able to proceed with this.

• Track emails from Eshopbox: Whenever there is a change in serviceability, Eshopbox sends an email to the client having a list of serviceable pin codes. The limitation is that:

  • for the new clients, we cannot ensure this is provided or not

  • how existing clients are able to track this

  • is Eshopbox sending the email to the correct POC?

Project objective

With this BRD, we would like to:

• import updated pin code serviceability in the Eshopbox workspace (access only for internal users)

• provide access to serviceable pin codes to the client on the Eshopbox workspace.

• send a notification to the client when there is a change in pincode serviceability.

Open

Requirement

1. Eshopbox to import a list of serviceable pin codes into the workspace. (This option will be available on the Eshopbox workspace only eshop.myeshopbox.com.)

   1. Login to Eshopbox workspace.

   2. Navigate to settings > Pincode serviceability > Import

   3. CSV template:

      1. Pincode (By default populated with all the pin codes of India.)

      2. City

      3. State

      4. State code (Still open if required or not, as in the existing report we are sharing with the client)

      5. Express prepaid (Yes or No)

      6. Express COD (Yes or No)

      7. Standard prepaid (Yes or No)

      8. Standard COD (Yes or No)

      9. Reverse pick up (Yes or No)

   4. Upload template > Done.

      1. An import will be a complete success or complete failure. No partial success.

      2. The template will by default have a list of all the pin codes of India and the user is expected to populate the remaining fields. This is to ensure that the client is sent a complete list of pin codes. In case any pincode is non-serviceable the user can mention No under the column Prepaid and COD.

   5. Check for import to complete and fix the errors if any. (To be documented if approach finalised)

2. Notify the client when there is a change in pincode serviceability.

   1. Create a new notification setting for the Eshopbox workspace. (Pincode serviceability)

   2. This will be a real-time and daily update notification to which the client can subscribe.

   3. By default, the notifications will be enabled for all users.

   4. Trigger:

      1. Real-time: As soon as the import is completed on the Eshopbox workspace.

      2. Daily update: Daily morning at 9 AM, with the existing pincode serviceability.

   5. Details available in CSV in the notification:

      1. Pincode

      2. City

      3. State

      4. State code (Still open if required or not, as in the existing report we are sharing with the client)

      5. Express prepaid (Yes or No)

      6. Express COD (Yes or No)

      7. Standard prepaid (Yes or No)

      8. Standard COD (Yes or No)

      9. Reverse pick up (Yes or No)

3. Access to the client to browse the pin code serviceability on the Eshopbox workspace.

   1. Login to Eshopbox workspace.

   2. Navigate to settings > Pincode serviceability

   3. List of pincode with details:

      1. Pincode

      2. City

      3. State

      4. Express prepaid (Yes or No)

      5. Express COD (Yes or No)

      6. Standard prepaid (Yes or No)

      7. Standard COD (Yes or No)

      8. Reverse pick up (Yes or No)

   4. Export CSV with pincode serviceability

   5. Link to API integration and help article.