Requirement:
On the website, we do not have the matrix item feature. Instead, we maintain a single item record, with all its variants established as distinct custom records and linked to the item within the custom tab. Based on the item option selected in the item record, we need to display the item options table in the product detail page.
Solution:
Currently in the NetSuite item record, we have the item variants attached as custom record under the custom sub tab.
In the above screenshot, the item option selected is the “Item Variant”.
For the ‘Item Variant‘ option, which includes two values – ‘shade’ and ‘mould,’ the table will display as image given below.
The current website implementation places ‘Shades’ in the top header of the table and ‘Mould’ on the left end of each row.
There have scenarios where only one value, (for example, ‘shade’ or ‘mould,’) may be present, and in such cases, variant values will be displayed on the top and the corresponding boxes will be displayed below that. Please refer to the image below for clarification.
Above each item option table, we will display headings that represent the top-level variant names, differentiating each table from other item options tables if they are present. We will make use of the existing functionality. Beneath each column, you can input the quantity of items you wish to purchase. If a specific variant value is unavailable, the respective box will be displayed in Gray.
Depending on the selected item option, we will showcase the item variants table on the Website Product Detail page.
We are not considering the Add to cart functionality for now.
Scope & Limitation
- To display the item along with its chosen variants in the sales order, we would need to pass these values during the checkout process.
However, as we lack login access to both NetSuite and the website, we are unable to assess the current functionality of the ‘Add to Cart’ feature on the website. Therefore, we are not considering the effort required to display the selected item variant in the cart page, checkout page, and sales order at this time.
- Any changes to the proposed solution will be considered as change request.
- If we need to configure anything extra in sandbox, that will be extra effort.
Assumption
- We will make use of the existing extension.
- We will keep the same UI.
- Based on the item option selected in the item record, the item variant table will display.
- We will do the development first in sandbox domain, we are expecting that the sandbox has the latest back from production and include a well configured domain, with the current functionalities available in the production domain. If we need to configure anything extra in sb, that will be an extra effort.
Prerequisites
- The login credentials for the NetSuite and Website (SB and production) should be provided.
- Item options and its values for the remaining items should be shared and should be available in the item record.