Creating New Inventory Sitoo Supply Items in NetSuite

Steps for Creating New Inventory Sitoo Supply Items in NetSuite

Open the template below, This template is for the import into NetSuite.
- https://rallyhouse-my.sharepoint.com/:x:/p/sofie_card/IQBS85u5TSgjS4dpBWEy1M0LAevktyPsrU8o8iRUjHW0-lQ?e=jbU5fA
- Select ‘File”
- Hover over ‘Create a Copy’
- Select ‘Download a Copy’
- Open the downloaded copy and select ‘Enable Editing’ at the top
  - You may also have to right click on the sheet tab at the bottom of the page and select ‘Unprotect this sheet;
All of the green boxes are what is needed to be completed.
- If the box is NOT green, it is already set to the correct information, or will changed based on what is put into the green boxes.
Insert the following information for each item that needs to be created,
- Item Name/Style Number
  - If there is not a specific style number for Rally House already created, the Vendors item number can be used.
- Display Name/Code (POS Name)
  - Please be specific on these names,
    - Include the general description of the item and the quantity contained
      - EX: (Each), (Pack of 25) ect.
- Primary Units Type
  - The following is a list of the Units of Measure available in NetSuite.
    - https://3847979.app.netsuite.com/app/common/units/unitstypelist.nl?whence=&siaT=1771342157531&siaWhc=%2Fapp%2Faccounting%2Ftransactions%2Fpurchord.nl&siaNv=ct2
- Class Mapping
  - The following is a list of the current Class Mapping sections created in Netsuite.
    - https://3847979.app.netsuite.com/app/common/custom/custrecordentrylist.nl?rectype=2109
- Item Vendor
  - The name of the vendor has to be exactly what it says in NetSuite, Please copy and paste the vendors name from NetSuite to ensure all is correct.
- Purchase Price
  - This will be the Vendors price, the price that should be on the PO when it is sent to the Vendor.
- Facet Sub Department
  - The following is a list of the Face Sub Departments available in NetSuite.
    - https://3847979.app.netsuite.com/app/common/custom/custrecordentrylist.nl?rectype=2178
Once all of the correct information is entered into the Excel document,
- Select ‘File’
- Select ‘Save As’
- Create a name for your file
- Save this file as ‘ CSV (Comma delimited) (*.csv)’
Use the following saved import template
- https://3847979.app.netsuite.com/app/setup/assistants/nsimport/importassistant.nl?recid=2114&new=T
  - Attach your newly saved CSV file,
  - Select ‘Next’
  - Select ‘Next’
  - Select ‘Next’
  - Hover over the arrow next to the blue ‘Save & Run’ button,
  - Select ‘Run’

Tips for ensuring your items are set up correctly after importing

Display Name/Code (POS Name)
- This should be the same as the field Thumbnail Product Alt Text
  - This will be the Name that is displayed on Sitoo (POS)
Adding a picture to your item,
- Save the picture of the item to your computer in a ‘JPG’ form,
  - The name of this picture should be the style number and ‘-1’
    - EX: Style number ‘123456’
      - Picture name: ‘123456-1’
- Log into NetSuite and navigate to ‘Documents>Files> File Cabinet’
  - In the file cabinet, locate the following folders,
    - Web Site Hosting Files : Rally House Hosting Files : assets : images : products
- Upload your saved picture into this folder
- On the Parent item
  - Select ‘Edit’
  - Check the box “Has Associated Image”
  - In the ‘Item Thumb’ box place the name of your file and ‘.jpg’
    - EX: Style number ‘123456’
      - Picture name: ‘123456-1’
        
        Item Thumb name: ‘123456-1.jpg’
    - Hover over ‘Actions’ and select ‘Mass Update Matrix’, finally select ‘Submit’
If the item comes directly from the vendor it should be marked as
- Drop Ship Item = True
- Is Drop Ship Item = True
If the item comes from 915-Fulfillment it should be marked as
- Drop Ship Item = False
- Is Drop Ship Item = False
Facet Dept = Sitoo Supply Items
Team = Sitoo Supply Items
Do Not Run PAT Scripting = True
Exclude Store Pickup = True
Do Not Display in Website = True