PROPOSAL SUMMARY
This proposal outlines the scope of Auto-Generation of Item Numbers, Auto-population of Design number Attributes on Item record and the Price Calculator.
REQUIREMENTS
- Knot & Co. seeks to implement an automatic generation feature for the item Name/Number on the item record when creating new records. This functionality will streamline the process by automatically generating a unique and appropriate item Name/Number for each new record.
- Knot & Co. requires the automatic population of attribute values based on the selected Design number within the item record. This feature will streamline the process by populating the relevant attributes corresponding to the Design number chosen by the user.
- Knot & Co. intends to develop a Rug Price Calculator that should display the cost of rugs based on their design and size. This calculator will be accessible to external users who do not have NetSuite access. The aim is to provide a user-friendly interface that allows customers to easily input the desired design and size parameters and instantly view the corresponding rug price.
DELIVERABLES
- We will auto-generate the item numbers in a sequential order while creating the item record.
- To add/ Adjust the Design number, we will establish the custom record and will proceed by creating essential dropdown fields within this record, including Collection, Design, Country, Quality, Pile/Content, Background color, Border color, and more.
- To streamline the process, we will implement customization that automatically populates the design number attributes based on the selected Design number on the item record. Additionally, we will establish the item’s display name/code to be identical to the design number for consistency and clarity.
- In order to maintain a comprehensive price list for both standard and custom sizes, we will create a custom record that will store the dataset. This dataset will be organized based on the designs collection.
- The Price calculator would display the cost of rugs based on their design and size. This calculator will be accessible to external users who do not have NetSuite access.
- Using this the customers can select the Rug design, Size, Color and add required dimensions and clicking on the calculate button will provide with the cost per piece.
- The values in the price calculator fields will be populated based on the custom records set up in the NetSuite.
- The price calculation will be based on the cost per square foot, the total square footage entered, and, if the selected color is custom, the custom color cost per square foot.
- We will add fields on the item record that will allow users to select the size and design of the item. Following the saving of the record, the system will automatically perform the calculations to determine the square feet and cost per piece.
- Please look at the attached link for the mock-up demonstrating the following functionalities: (Auto-generating item numbers, automatically populating attribute values based on the selected design number, Rug Price calculation).
JJ Mockup for Autogenerate item number And JJ Mockup for Price calculator
ASSUMPTION
- At the time of the item record creation the Item number/ name field will not show the number. After record saving the item number will populate.
- Currently, the system does not consider the context of item deletion. For instance, let’s say the most recently created item is automatically assigned the item number 10. If this item is deleted or inactivated, the next created item will be assigned the number 11 instead of reusing the number 10.
- This is only applicable for the inventory items.
- The dropdown list of the display name attributes (Collection, Design, Country, Quality, Pile/Content, Background color, Border color, etc) will provide by the Knot&co.
- Knot&Co. Should have to share the price tier list for each design and size.
- Suitelets are utilized to retrieve data from NetSuite and populate it in the price calculator. However, there may be concurrency issues that arise from multiple users accessing the calculator simultaneously.
- The videos provided are intended for mock-up purposes only. The design and arrangement can be further improved.
ESTIMATED EFFORT
Estimated Efforts: 94 Hours
| Task | Time (In Hour) |
| Analysis | 4 |
| Auto-generate the item numbers | 14 |
| Automatic population of attribute values based on the selected Design number | 8 |
| CSV import of Design numbers | 6 |
| Rug price calculator (Data base setup and CSV import of price tier lists) | 14 |
| Rug price calculator (External customer-facing page set up and mapping) | 34 |
| Price calculation on NetSuite | 8 |
| Documentation and Deployment | 4 |
| Testing | 2 |
Note: The estimates may vary depending on volume of data imported and complexity of customization.