Radhika R – knowledgebase JJ

Add LiveChat to your SuiteCommerce using Google Tag Manager

First SC Google Tag manager bundle need to be installed Then we need to Link Google’s client ID with NetSuite As a next step, go to SuiteCommerce Advanced section. Choose which of your NetSuite website and domain would you like to link with Google Tag Manager. Once you’ve done that, click on the Configure button. On the next screen, proceed… Continue reading Add LiveChat to your SuiteCommerce using Google Tag Manager

Resolve Company Field Missing From Individual Lead Record Created Using Contact Us Form

When submitting a Contact Us form generated from SMT with the Company field populated, the corresponding field on the individual lead record will be empty. A workaround is to use an Additional Field and link this to the Company field. Solution While logged in to SMT on your website, navigate to the page that contains… Continue reading Resolve Company Field Missing From Individual Lead Record Created Using Contact Us Form

Setting a custom list as a facet field

The user wants to create a facet field that sources the options from a custom list that they created. Create a Custom List Navigate to Customization > Lists, Records, & Fields > Lists > New Name: Add name depending on user’s preference Values sublist: Add list items depending on user’s preference Fill out other fields as needed ClickSave Create the Item field to be displayed on the web store… Continue reading Setting a custom list as a facet field

Hide Item from a Customer segment

User needs to hide item from a customer segment, such as client segment A, but make it visible to other customer segments, such as client segment B. Solution Navigate to Commerce > Content Management > Commerce Categories Select View beside the Commerce category with the item you want to hide Under Items tab, take note of all the items Go to Lists > Accounting… Continue reading Hide Item from a Customer segment

How to create a database table using Sequelize code

The Sequelize model you create using the sequelize.define() method comes with a sync() method that you can use to create a table.The table created using the sync() method will follow the model definition for its column(s).For example, suppose you have the following User model defined in your code: The call to User.sync() above will cause… Continue reading How to create a database table using Sequelize code

How to format the date for date types values using Sequelize

Customizing Sequelize date format with Sequelize.fn() Thesequelize.fn()method is used to call a native database function to modify the way your query worksFor example, you can call the UPPER() function of MySQL and apply it to a column that you have as follows: The sequelize.fn() method is used to call a native database function to modify the way… Continue reading How to format the date for date types values using Sequelize

How to execute/ use a raw query with Sequelize

When using Sequelize to manipulate your database from a JavaScript application, there might be cases where you want to just execute a raw SQL query instead of using Sequelize Model methods. By default the function will return two arguments – a results array, and an object containing metadata (such as amount of affected rows, etc).… Continue reading How to execute/ use a raw query with Sequelize

Resolve Web Store Credit Card-based Sales Orders Not Automatically Processed for Authorization

For Web Store-generated Sales Orders, when both Credit Card and Terms is tried to be set on the Sales Order during creation (e.g. through user event scripts), the back end logic checks whether if a Terms value is being set and applied. If found, the Authorization Process is skipped. Terms being prioritized over Credit Card… Continue reading Resolve Web Store Credit Card-based Sales Orders Not Automatically Processed for Authorization

Resolve Commerce Category error with same URL facets in SuiteCommerce Advanced

This will occur if a commerce category URL fragment contains the word or phrase that is defined in either the URL Component for facets list or defined in the SuiteCommerce Configuration record. A page not found will be displayed when displaying the commerce category. This effect would be the same vice-versa.Example:1. Create custom “Color” item… Continue reading Resolve Commerce Category error with same URL facets in SuiteCommerce Advanced