Sort & Order data in Excel Sheets ready for import into NetSuite

Hey,

Please see links to sheet – I will share you into these:

https://docs.google.com/spreadsheets/d/1Ly9ubDv-GjqO9V3R8l_dDuyXpFUIvkkP/edit#gid=1403209557 (refer to second tab only)
https://docs.google.com/spreadsheets/d/1qtlq2Kr-izOEedhEplk8UztXtfWwXY7kUqRIX4-hxcA/edit#gid=0
Supplier import doc.xlsx

please see also – example documents on how the item & Supplier pricing needs to be laid out.


Helpful points:

-All items on the ‘Customer Rates for Netsuite’ sheet are all needed (you will see that not all of them items are on the Supplier sheet)
-If they are not showing on ‘Preferred Supplier & Costs’ sheet, they still need to be imported into import sheet as items even if they don’t have any preferred supplier or cost besides
-All items needs to be for all regions, as seen in coloum B on suppliers sheet. So all 95 items need to be listed for each region (about 60 regions)
-The words ‘Hire of’ need to be added in front of all items in coloumn B & C of sheet ‘ Customer Rates for Netsuite’
-On the Customer item rates sheet, it has in coloumn P the perferred supplier. This should match what is in coloum D on the Supplier rates form against the same item name
-The items have to be put into the format (like attached) for importanting. Coloums that will always be the same are D,E,F,M,N,O,P,Q,R,S,T,U (for items) and F,G,H,I,J for suppliers


Make a start and see how you get on

Thanks,
Kirsty.