Advanced Price Validity
To find all the available advance price validity csv imports navigate as follows:
SETUP – IMPORT/EXPORT – SAVED CSV IMPORTS
413 UK Subaru
419 UK Isuzu
457 I.M. NEV
415 Nordic
- Preparation of the file (Sample and columns below
400.31 | Parts Price Validity Master : Base Price |
EUR | Parts Price Validity Master : Currency |
PARTNUMBER | Parts Price Validity Master : Part Number |
RRP | Parts Price Validity Master : Price Category |
Lithuania | Parts Price Validity Master : Sales Market |
14/11/2022 | Parts Price Validity Master : Start Date |
IMG Jersey Holdings Limited : I.M. Group Limited : I.M. Facilities Limited : International Motors Limited : International Motors Nordic AB : Subaru Nordic AB | Parts Price Validity Master : Subsidiary |
This is the CSV format required to upload; Check for price format (two decimals) and leading zeros on the part number
- Import of the file to Price validity table (see sample template https://333032.app.netsuite.com/app/setup/assistants/nsimport/importassistant.nl?recid=462&new=T)
Result email
- Execute or wait for scheduled run of the script. Script will pick price changes ON the date of the “start date”
https://333032.app.netsuite.com/app/common/scripting/script.nl?id=4790
The job to update prices runs at 2am each morning