Please enable JavaScript.
Coggle requires JavaScript to display documents.
HOW VIP product hunting work?, ROADMAP, COPY DATASET => 2 SETS - Coggle…
HOW VIP product hunting work?
2 colume
without outstanding
outstanding qty = item not shipped, shipped in progress, await f
or receiving
outstanding qty will be deduct from the forecasting value
column F/G/H
B098VTPK6Q
B094PV5T3Y
B000KKCVUM
B08WZ4ML2L
B08C21DHHP
B081X61J8F
B081XB79YQ
B081WT4GP3
B08DH914F6
B07KGW8QXL
B001TXMDZM
B007UTR7F0
B0000BWE8W
B00E8MAWNQ
B01MSBREL3
B00X9NRSPK
B016YKN2P4
B0000AZ8QG
B00X9O1G4I
B08C27ZW8G
B08C268TJZ
B089SGCNCD
B089SGVJ7Q
B00X9NQJHI
B007BQVFCS
B010F5QS82
B07SNW82V3
B078H74BVG
B07VQJ8WPW
B07RRDZHZP
B000N9PXD2
B09CTLJ856
B07WRST7DK
B07NM4LMW4
B07HDQDNM7
B005PCRGDC
B00EXFT7I4
B00YG2AHGU
B01H9DPM3U
B07FF933QC
B06XGVMR45
B00N4WNNZK
B008YWFWU4
B08Q54J4HY
B06XT8F5H5
B003W0ZKYG
B08ZFVZPHM
B095KJ6GXM
B09DL6RP61
B00COPWCTG
B095GB9CSV
B011KM46ZQ
B08WYDQ48L
B00X9NVY2S
B00MYS42XW
B00KE5OW32
B00MYT7E54
B09JXZCD7K
B08PN5QXRY
B01MRHWYIR
B083GCZP55
B00X0X5JWI
B07FQGY4XD
B00MYSO23W
B011KK3K1Y
B00LAHEWCO
B00K3U07GY
B089SNXMXC
B08C2DB4YS
B08C26R8JB
B00DNB7D7Q
B00MYSXB1G
B00MYSZHHW
B00X0WS4MG
B00144AEQG
B00MYSO9X0
B00FS8B74M
B09333624C
B011KL8IQK
B011LNG5FS
B011LMX408
B011KJYSUC
B012FIO9L0
B00283PODU
B00MYSOPVQ
B001DRVNVY
B00MYSOL4W
B07G86W484
B07D8FRNVH
B011KK0KJE
B07DCPJNMS
B00X9O8WVI
B08C2BF847
B00J4Y38BG
B00X0X5PJK
B002MY2CO4
B00SG7IX0S
B00MYT4OK2
B00KE5OW32
B0108LGOZ0
B00MAQAN8Q
B09966F3JY
B00CHXRZ6U
B00X9O9L6S
B00KNBA47U
B00X9O9GMM
B00MYTJ5YW
B00LXPDO8G
B00CV4EDME
B07G8GN637
B00AOB0QAO
B0055OKI3A
B00A8ORLX2
B004O0FP16
B00MYT2MTM
B011LNG3PA
B07DFFT31W
B08C1ZR25L
B011KKNKL4
B011KJZQ08
B00MYSWFVI
B011KL1RP4
B011LMT3UI
B00X0WTT0C
B00X0WTQ4Q
B00JGUA1KO
B000JM275A
B000IHD5AC
B00JBA5AQY
B002OM2O56
B005Z89KVM
B004TTNC5I
B002OLWIKS
B00MYSLD2K
B011LNFBGW
B00X0X0806
B098VZW6V5
B011LMU99W
B00865MGT4
B0975G1GW5
B00GA574P8
B011LO7OFM
B012DXZF42
B00EDJAMKW
B012DZ2GGK
B00MYSVX4I
B00I2WDCC6
B011LN6K8U
B00AH5U33C
B011KLCJJW
B011KLAUZ2
B001446RSK
B000XBEO4O
B000XBB6Y0
B08HX8CJRC
B00MYSNO7C
B001448IQ4
B00MYSTQCY
B011LODM3A
B00KOEWDHK
B00MYSR298
B011KLJQ9S
B011KJQE9K
B0044UMHY4
B011LO6WPK
B002MJDTSM
B0032FVB7Q
B00MYSIY2W
B00MYS8K44
B08C2CZ1ZK
B002IKHIBE
B00MYS7QR6
B07DHW27C7
B08CN7P7WD
B00MYSULZK
B00X9NSDK4
B002MJH20I
B005IXVEDQ
B00KIQFD9O
B00MYS62C6
B00X9NQQYY
B005IXVZM6
B00X9NV4IC
B084FRCFLY
B00X9NPZB4
B00MYS9EBW
B08KRNKP37
B08KRP76WJ
B07DLF79JN
B002HO9PNK
B00A8ONLX6
B00H52LXSO
B00MYS77E8
B00R9U5I6A
B07DHVGD9Z
B00KOEFJ8A
B00X9NZDZM
B00X9O071Q
B00X9NZZBO
B00X9NZVP4
B00X9O0U68
B00X9O1KXA
B00X9O0Y5K
B00X9O036U
B004TTXYIS
B011LMRN2I
B011LMRSOG
B005F2276S
B003Z3II6M
B07D2M9HLC
B00MYSP87G
B007RDC1K0
B00MYSPKUG
B002MXWBAU
B00MYSKQ14
B07DCPQKF1
B002MHOFGY
B011LOGAXO
B00LAHKMTQ
B004AQYYU2
B00283FV1U
B00283MIQG
B00283RBT0
B00283NR4S
B00283RBUY
B00283POFI
B00MYSOPHU
B000YN1WZK
B08HZQQK6D
B011LOC6AA
B0017LPHEA
B00DOE58HY
B00GOFX958
B011LN59XC
B08NQ317N7
B08NQ4QZRG
B08NQ5BKJQ
B08NQ3BPC7
B08NQ21LV4
B08NQ1W1JL
B08NQ1S7HW
B08NQ27W42
B08NQ4GHYR
B08NQ1R33N
B00E8MV22G
B07DF8MPS4
B01N6ZI6IF
B0799VL18D
B09CKYQGNH
B06W9F4G58
B06WCZMNRQ
B002IZJAKG
B01MFC4FCC
B01MAZKVG7
B01NGYJRNL
B00KU7AGU2
B000NA01CO
B00KU79A4K
B078X7XJ22
B081H24132
with outstanding
The purpose of the project
if we can drop 20% of COGs, VIP SKU is the SKU that have a value more than a certain threshold
we can also ho by the brand and go for the brand that has highest volume of aggregated COGs
stratrgy
Focus on total cost because this served better the interest of Distributor and Brand.
2 scenario
Bargain for cost decrease
Distributor normally can't help much about the price
The qty we want is normally too low for distributor or brand
qty challenge
Secure the item in the inventory
Column DQ SVC master SKU
search in Netsuite
Rejected by Supervisor
figure out why
Rate is higher than expected
Negotiate the price across vendor
Engineering Perspective
1 Barrier / 2 Cases
NEED TO USE NETSUITE
Check Conditions
2 Types
Green Conditions
We need to increase order fill rate
Loop for 1st row w/ received quantity = 0
If ( Order Status == Closed ) OR ( Order Status == Rejected by Supervisor)
Document Date of PO
1 more item...
Yellow Conditions
We need to negotiate
Loop for 1st row w/ received quantity > 0
If Cogs of SKU from dataset > Recent Rate on NetSuite
Document Recent Rate
1 more item...
Document Recent Supplier Name
1 more item...
ONLY DATA SORT
Sort by Brand, then find brand with highest SVC Total Cost
Also Sort by Total SVC Cost and Total SVC Profit, find 10 highest
COGS = Adjusted Supplier Rate
IMPORT COND
ROADMAP
FROM CONDITIONS
PHASE 1 | CREATE GOAL
What are we trying to achive?
Create automated system using NetSuite SQL API to automatically generate cases from conditions below
Use automated system to develop application that can be used to optimize search for items that need to be negotiated
What is the end goal?
PHASE 2 | PLANNING EXEC
FRONTEND
DATASET DOWNLOADED/IMPORTED FROM DATACRUNCH
APP RECEIVING FILES
BACKEND
NETSUITE
CHECK CONDITIONS
IF TRUE FOR COND/ GET DATA
RETURN SORTED DATASET
COPY DATASET => 2 SETS
Get top 10 Items
Call item data from NetSuite
SQL QUERY
Sort for top brands as TB
w/ highest item count*
Get items from TB