Sequelize provides support for most data types that you can find in SQL-based databases. When defining types, you can use both Sequelize class and DataTypes class interchangeably as shown below: const User = sequelize.define( “User”, { firstName: DataTypes.STRING, lastName: Sequelize.STRING, }, { timestamps: false, } ); Some of the data types supported by Sequelize are… Continue reading Sequelize data types list
Author: Radhika R
Resolve Error: “No content to map due to end-of-input” upon Save when Creating or Editing Domain
When creating new domain or editing an existing domain, hitting save will give you an error: “Unable to deploy Secure domain, because the provisioned amount would be exceeded.” knowing that you still have provisioned amount of webstore to use. Also, checking the logs will also show you error: “No content to map due to end-of-input”… Continue reading Resolve Error: “No content to map due to end-of-input” upon Save when Creating or Editing Domain
Personalized Catalog Views in SMT Preview Is Not the Same as Logged User
When logging in to the website as Contact (Type is Company), some Commerce Categories do not reflect as defined in Personalized Catalog Views (Customer Segment). But when viewing the PCV via Site Management Tools and selecting the Customer Segment, it shows the right view of the Commerce Categories. Solution 1. Customer must be on a… Continue reading Personalized Catalog Views in SMT Preview Is Not the Same as Logged User
How to check if email address is already in use or not using express-validator in Node.js ?
We use ‘express-validator’ middleware to implement this functionality. Command to install express-validator: npm install express-validator Steps to use express-validator to implement the logic: Install express-validator middleware. Create a validator.js file to code all the validation logic. Validate email by validateEmail : check(’email’) and chain on all the validation with ‘ . ‘ Use the validation name(validateEmail) in the routes as a… Continue reading How to check if email address is already in use or not using express-validator in Node.js ?
Setting Up the SuiteCommerce Analytics Data Feature
Prerequisites The SuiteCommerce Analytics Data feature requires these or later application versions: NetSuite 2021.2 SuiteCommerce 2021.2 or SuiteCommerce Advanced 2021.2 The SuiteCommerce Cookie Consent extension prerequisites are the same as for the feature: NetSuite 2021.2 SuiteCommerce 2021.2 or SuiteCommerce Advanced 2021.2 Enable the SuiteCommerce Analytics Data Feature To enable the SuiteCommerce Analytics Data feature: Go… Continue reading Setting Up the SuiteCommerce Analytics Data Feature
Hide New Registration Option even without Advanced Site Customization
Scenario There are scenarios where users need to allow only existing customers to be able to do a Checkout from the Web Store. The option to do so can be found under (Administrator) Commerce > Websites > Website List > Edit > Shopping Tab > Type of Customer Registration = existing customers only. However, this is not… Continue reading Hide New Registration Option even without Advanced Site Customization
Custom Role Cannot Access Configuration Record
Scenario A user with custom role cannot access a Configuration record. An error has occurred, Notice(SuiteScript) Error: Only the users with the following permissions: “Documents and Files”, “Website (External) publisher”, “Set Up Domains”, “Set Up Web Site”, “SuiteScript”, “Custom Record Types” can modify the configuration record. Solution Navigate to Setup > Users/Roles > Manage Roles Custom Role: Click Edit Click Permissions… Continue reading Custom Role Cannot Access Configuration Record
Invalid Promotion Coupon Code for Discount in Webstore
Promotion Coupon code is not working in Webstore. Solution 1. Navigate to Lists > Marketing > Promotion > New 2. Select a Promotion Type (Order-Based Promotions, Item-Based Promotions, Standard Promotion) 3. Make sure to select the website under Site Field(custrecord_advpromo_channel) 4. Click Save Note: This is for Standard and Advanced Promotions only.
Proposal For Enhancing Reorder Feature for Liquid Pixels Items
Proposal Summary This proposal outlines the scope of enhancing the existing reorder functionality to allow customers to review and edit personalized checks using Liquid Pixels before placing an order. This enhancement aims to improve customer satisfaction by providing an opportunity for customers to verify and modify their personalization details before finalizing their orders. The estimated… Continue reading Proposal For Enhancing Reorder Feature for Liquid Pixels Items
Unable to view Workflows using Custom Role
Unable to view Workflows using custom Role Solution To access a workflows on the Workflows page (Customization > Workflow > Workflows) a user must have Full permission for the base record on which the Workflow was built. If you are able to see just some of the Workflows using custom role follow those steps: 1) Login as Administrator and go to Customization > Workflow… Continue reading Unable to view Workflows using Custom Role