We can use this code to insert the data in a CSV file to a local database table. Just change the table name, database name, and data fields with your respective field name and others.
Month: May 2021
Adding facet field in SCA website
FACET OPTIONS WEBSITE SET UP Set up> suite commerce advanced>set up website> sca reference site example Search index subtab>facet fields Set the facet fields as in the image shown above. Now we need to add the facet field in the facet configuration Set up> suitecommerce advanced> configuration> select domain and website Shopping catalog subtab> facetsConfigure… Continue reading Adding facet field in SCA website
Cron job in django
SET UP installation: using the following command pip install django-crontab add it to installed apps in django settings.py: INSTALLED_APPS = ( ‘django_crontab’, … ) now create a new method that should be executed by cron every 5 minutes, f.e. in myapp/cron.py: now add this to your settings.py: CRONJOBS = (‘*/5 * * * *’, ‘myapp.cron.cron’)
Display Item fulfillment shipped status date in the saved search result
Formula (Date): case when {systemnotes.newvalue} = ‘Shipped’ then {systemnotes.date} else NULL end
Change the number of products in PLP
To change the number of products in plp in site builder sites ,we can change it editing the layout in the netsuite account. We can s change the number of rows, and columns applied . We can also display numbered page navigation links and links for sorting items on the page. using the layout. Steps… Continue reading Change the number of products in PLP
Custom reminder portlet
A portlet script for a custom reminder in the employee center role. The portlet script will only be available as suiteApp in the employee center. So when it set up by personalizing the dashboard the portlet must be select from suiteApp. /** *@NApiVersion 2.x *@NScriptType Portlet */ /******************************************************************************* * CLIENTNAME:AQUALIS * AQ-386 * * **************************************************************************… Continue reading Custom reminder portlet
Check the possibility of implementing credit limit
How does credit limit work?
How to implement a credit limit for customer
DECISION TREE CLASSIFICATION ALGORITHM IN MACHINE LEARNING
INDRODUCTION Decision Tree is a Supervised learning technique that can be used for both classification and Regression problems, but mostly it is preferred for solving Classification problems. It is a tree-structured classifier, where internal nodes represent the features of a dataset, branches represent the decision rules and each leaf node represents the outcome. Why use… Continue reading DECISION TREE CLASSIFICATION ALGORITHM IN MACHINE LEARNING
Display current category in the left navigation of category page
In the extension, call the PLP container and then modify the displayValues.
Exchange Rate Calculator
This script provides a better way to calculate the exchange rate in a more accurate way and also with better performance.