On the Import Assistant Field Mapping page, you need to map CSV file columns to NetSuite fields, so that data is imported into records correctly. For a matrix items import, the key fields that you need to map are: Item Name/Number Matrix Type Subitem of Each matrix option field Depending on your CSV file column… Continue reading Matrix Items Import – Mapping Fields
Author: Jista George
Import of Matrix Items – Prerequisites
Before the import of matrix items do the following , Ensure that the Matrix Items feature is enabled, at Setup > Company > Setup Tasks > Enable Features, on the Items & Inventory subtab. Set up a custom list and a custom item field for each matrix option, at Customization > Lists, Records, & Fields > Lists… Continue reading Import of Matrix Items – Prerequisites
Set Default Term for New Customer Records
Solution 1. Navigate to Setup> Accounting> Accounting Lists. 2. Select Term on the Filter. 3. Click Edit on the desired term, then enable the Preferred checkbox. 4. Click Save.
Invalid Item Reference Key xx – import error
The error occurs when adding related items data to an item record. The Import Assistant supports the import of related item sublist data for item records when the Web Site feature is enabled. Related Items data are mapped to the NetSuite field Presentation Items 1: Item (Req) and you have the option to choose the following reference types: Names (Item Name/Number or Web Store Display… Continue reading Invalid Item Reference Key xx – import error
Declare the variable as editable – editable() Function
The metadata to expose a variable takes the form of an editable() function call wrapped inside a comment in your Sass files. This function call accepts a JSON object as its single argument with the following properties: type – declares the variable type. This property is required.Possible values include: color – displays a color picker in SMT. string – declares a value… Continue reading Declare the variable as editable – editable() Function
Expose a variable for customization
Open the Sass file containing the variable you want to expose. Create an inline comment (//) or a block comment (/* … */) immediately following the variable declaration.You can use either comment method. For example:$sc-primary-color: red; //Copy$sc-primary-color: red; /* */Copy Use the editable() function within your comment tags to declare the variable as editable. Save the file. If… Continue reading Expose a variable for customization
CSV Import – Invalid Parent Reference Key
The error occurs because the Show Display Name with Item Codes option is enabled in General Preferences. There are two ways to resolve this error: Disable the Show Display name with Item Codes option in General Preferences. Update the CSV file used for the import to include the item name/number display name/code. External ID and Matrix Option fields are… Continue reading CSV Import – Invalid Parent Reference Key
Workbook for SuiteCommerce Analytics Data – Backup data before category/item CSV import
Go to Analytics > Workbooks tab. Click New Workbook. Click New Dataset. If you already have a dataset, you can click the Dataset Name instead of creating a new dataset. Select a record type to analyze. The search bar is helpful for locating a record type. To search, enter any word or character from the record type name. No… Continue reading Workbook for SuiteCommerce Analytics Data – Backup data before category/item CSV import
Single File Import – Quantity Pricing Schedule
To import pricing data using one file only, you should include one row for each item. All of that item’s data must be on the same row. (Note that the example below omits the item’s name, which would be required if the Add data handling option was selected.) Mapping – Map to corressponding fields under… Continue reading Single File Import – Quantity Pricing Schedule
Setting Up Custom Lists and Item Fields for Matrix Options
Before you import matrix items, you need to set up a custom list and a custom item field for each matrix option. Each custom list represents a matrix option such as size or color , and includes the set of possible values for that option. Each custom item field provides an interface for display and… Continue reading Setting Up Custom Lists and Item Fields for Matrix Options