Skip to content

Notes

For Asger:

When did this order come in why did the “new order” webhook not trigger: NWXQVQFSU ()
Need to add order value to order status update webhook & New order webhook
Why did these not come through to Pipedrive:
No Deal in PD
id_order
reference
id_customer
ORG - id_pipedrive_organization
Customer id_pipedrive
Text
33,733
RXKVZWPQN
199
21394
1219
33,750
OHSKBRYZH
2,641
13179
2778
33,793
URKGVKDVK
1,429
20880
4450
33,896
VTVRISVMC
3,980
22125
4851
33,061
VCXMPZDHD
3,988
5106
33,029
YPODKLUHJ
4,852
18968
5244
33,765
MEMOPKQCX
30,829
1890
6176
33,701
KYVUFPPCF
12,796
2224
6834
33,413
BXQRGZZOE
1,375
20912
7104
33,673
IPJTJFZYC
1,470
20855
7330
33,669
CCMOUCQKK
1,452
20866
8146
33,549
EUYSHCOZO
4,705
19068
8527
33,757
FLDWLDHKE
4,705
19068
8527
33,535
NIBIMAGWG
2,740
20186
8716
33,070
KHBSXCGZG
9,040
8764
33,280
MBOCWRPKI
4,694
13071
8841
33,345
JFYHQLRUS
2,693
20214
8961
33,259
QKNOXLJNV
4,980
18877
9690
33,595
IJRUQRPCZ
4,901
18938
9816
33,619
EGNIWYKXU
4,991
10172
33,921
RPZADQGHD
5,250
18772
10861
33,089
JAGSIQKQT
5,838
18610
11419
33,084
OHACRMQAP
5,875
21621
11997
33,553
ASLTYDEPL
5,875
21621
11997
33,141
FJKBSYYFM
6,613
18407
12477
33,607
HKZHJYPZS
6,613
18407
12477
33,728
EWOJLRRKG
6,613
18407
12477
33,836
BLWGATKNN
6,613
18407
12477
33,642
KYYDGMFZS
6,872
18349
13935
33,643
RJRNRBVTE
6,872
18349
13935
33,005
AZHFLREGJ
8,808
17880
13942
33,235
QFDWZGPYQ
9,789
17605
14217
33,748
VMVFDWSPO
7,297
18237
14592
33,125
MMIWEFCHZ
10,130
7142
15056
33,383
WGXEIRQQC
10,130
7142
15056
33,154
XGBSWIRUZ
8,153
18029
15478
33,574
ONAHYHQHV
2,121
13170
17647
33,775
SAPUSATHK
8,891
5491
18140
33,880
YNLOXDEBV
9,048
17817
18390
33,499
FZFBUFVJJ
9,206
17776
18650
33,808
BVZQSAURY
20,810
15073
20997
33,724
KVAAIZNCX
11,089
17178
21621
33,721
JJLDDGEKJ
27,824
23178
22039
33,213
JYVMLZZDJ
11,460
15646
22937
33,063
PAXBUBRGE
11,890
16927
23981
33,390
AXMNRJFVF
12,306
16797
24990
33,953
ZFKBWMBJQ
12,461
25393
33,066
BVUQQFVRB
13,255
24333
25843
33,309
ZNITBWSMD
12,726
16688
25948
33,904
NWVQBNPVA
12,767
16681
26040
33,208
MIOYFVTNO
12,848
16652
26254
33,725
RQTOJQNCU
13,285
13164
26914
33,805
VSUCJORWW
13,285
13164
26914
33,704
JRLTDRANB
13,217
16550
27171
33,571
XUGLURMZQ
13,357
16519
27352
33,784
NSEJMRRBE
13,764
16409
27647
33,884
SXJJGXSTP
14,294
16262
28976
33,350
ZSFCIFKHS
13,999
16340
29156
33,169
PFXOBRWBX
14,391
16230
30108
33,854
CDYEHYZZH
564
12933
30680
33,634
XWMFQUSMW
15,404
15980
32082
33,015
ZSSTODIPC
7,519
18181
33501
33,881
NNSCZLPGW
3,736
33762
33,753
JRRAMHOHT
16,828
15748
34245
33,885
QTMXBAQZN
17,264
15656
34487
33,636
UCVOGDVIN
17,155
22191
34939
33,472
LZNQTQIYX
18,479
15531
35179
33,473
PGMEBVGJX
18,479
15531
35179
33,475
DHEKLEYFM
18,479
15531
35179
33,476
PUNQSNSWZ
18,479
15531
35179
33,478
BDEYUQAIU
18,479
15531
35179
33,482
UJYTEESYT
18,479
15531
35179
33,796
RDDCMAFZI
17,641
15624
35392
33,042
BQWQPBYSP
12,532
8829
35698
33,043
VCBESIBGS
12,532
8829
35698
33,044
SYVFTMBGZ
12,532
8829
35698
33,045
KNPJIGPDD
12,532
8829
35698
33,860
NSBNPHUEQ
17,862
15603
35750
33,727
EXGIUNULF
18,165
15564
36189
33,529
CABTSDWRO
18,963
36404
33,265
TCIFTHZVX
18,465
15532
36505
33,298
NZXMOIFAL
13,993
16342
36764
33,374
RMHTIGXNR
19,042
15429
37587
33,338
KYOUWEISI
19,122
15407
37895
33,055
CCLOOBCST
19,482
15334
38746
33,878
EVHDGQRZC
19,525
38852
33,365
FGUSPRYBS
19,664
15291
39164
33,680
KMYFQDVLS
19,676
15288
39182
33,406
AEVWHLZQP
19,737
15275
39345
33,333
DGNMIETIA
19,750
15271
39370
33,856
HLYJJEDJD
19,750
15271
39370
33,348
EFFSWZRZP
19,985
15216
39486
33,002
YYODLNCSO
19,904
15231
39709
33,761
VBVYKWPRM
20,400
15142
40743
33,233
GKBAZUTIB
20,418
15139
40792
33,786
UYDMTLMVJ
20,918
15062
41736
33,518
BMFRWOEXE
22,516
25172
42828
33,630
PIXFZBGLD
22,516
25172
42828
33,209
HDHPNMYTP
21,679
14920
43140
33,906
FFTZFJXJI
21,679
14920
43140
33,161
FCLHQADQN
21,633
14931
43205
33,952
NUFAQTNVE
22,625
14688
44883
33,957
HKGOSSHDE
22,774
22296
45326
33,301
PTCEXOUZN
22,800
14729
45378
33,311
DXYPXAZWI
22,917
12972
45518
33,631
PCTVTMKKU
23,508
12238
47701
33,794
TVURSPXRF
23,820
48241
33,100
MQMIRAAUW
23,989
24277
48531
33,949
SFWCKVYVU
25,204
14278
48631
33,940
MPMEYNKXH
24,050
14491
48657
33,653
JFZHTRHLE
24,157
14478
48824
33,378
TEZAFMCHY
24,366
14439
49175
33,404
QFJHZSHWU
24,795
14367
49889
33,396
TNRDUTLYU
25,414
50800
33,093
EXPWGIUFG
25,645
51241
33,461
LGUGIYQKZ
25,775
14164
51356
33,165
LTBASLDJX
26,270
14082
52279
33,389
GVBFFMGDM
26,726
14015
52945
33,405
NTOBYKTHG
27,371
13761
53155
33,492
SLFOGWXZZ
27,005
13988
53474
33,206
LBGBCILSK
27,084
22157
53623
33,751
WFXCWKQUX
27,084
22157
53623
33,334
NDDLOUZGW
27,285
24778
53915
33,082
AADJWHTOK
27,298
13290
53920
33,943
AZRCGDJFC
22,726
13347
54058
33,257
QZJQDOOTC
27,489
13355
54071
33,503
VFJSKTEZE
25,313
13366
54086
33,658
ATXATMBWK
25,313
13366
54086
33,762
NERWGTGZC
25,313
13366
54086
33,421
LUKCGJQSX
27,719
13578
54366
33,922
QTXNEZGQJ
31,369
13846
54693
33,102
TJJNBPIFM
28,421
21772
55204
33,484
NQBKBKPRV
28,465
21818
55251
33,684
WPDTGMCCS
28,465
21818
55251
33,799
LJEVCJRDL
28,816
22231
55668
33,391
BQEEMRRER
28,852
22268
55705
33,935
JUPPSODXO
29,210
22430
55992
33,416
FHGAKRGZL
29,145
22458
56021
33,590
PZBGHIKEX
29,383
22715
56300
33,201
WNGQBZGRZ
29,654
23115
56700
33,187
DRJUIJVIR
5,779
24744
56739
33,321
TSJNAZBWP
5,779
24744
56739
33,866
CNXAVPDEN
31,770
26023
56739
33,870
UJQZFJTIK
31,770
26023
56739
33,379
YWSDHVJRK
11,181
17150
56848
33,225
EOAPCTTVS
29,741
23262
56855
33,328
GPNULMFYK
29,761
23309
56911
33,622
TJPVXRGXC
14,397
16227
57112
33,062
NKGMVOKJX
29,937
23568
57154
33,283
KSXWVLIVC
29,378
23665
57262
33,444
ECZEZRZNP
30,091
23776
57364
33,251
XKJICIKDO
30,163
23863
57449
33,344
HYNSZEOZG
30,163
23863
57449
33,555
BFYMIIBMY
30,197
23910
57493
33,326
WQLBRQVEN
30,200
23913
57495
33,560
ABETJKPFK
30,313
24062
57642
33,190
IIXDKZDSK
30,614
24476
58005
33,013
PLDNTAJAQ
30,323
24077
58047
33,496
WGQPVBYWG
30,688
24549
58089
33,262
SPXXCZIQH
30,775
24693
58196
33,377
GVPUVOHSZ
30,775
24693
58196
33,515
CEKEFMEYL
30,949
24890
58434
33,567
CYMRZXSUU
30,956
24898
58449
33,079
RSONUJWGM
31,048
25711
58458
33,419
PKMNGSRHD
31,032
24985
58527
33,454
OWJEPIEVS
31,049
25053
58591
33,493
WTLPSPBFM
31,136
25597
58672
33,532
YYNPKJQBK
27,967
25218
58762
33,561
ONWAWXSYK
31,207
26136
58804
33,650
EOTUEQCAQ
31,376
25495
58984
33,651
SKASZACCB
2,209
13212
58985
33,691
FWVUPKRKM
31,422
25566
59042
33,817
VCVIYJYNI
31,529
25715
59166
33,759
JDTIKOBGD
31,596
25991
59245
33,933
HNIIXWNST
31,702
25926
59376
33,840
LHDIPQSWO
31,710
25938
59390
Deal was updated but then overwritten by: IGEPBJYTZ
33,877
LWJALQLRI
31,751
25987
59438
33,936
TSMLDSIIW
31,882
26160
59535
33,001
DTIRSLGMW
30,307
Nothing in status update or new order
33,012
JWCYSNTHV
30,077
33,025
LWFURITWZ
21,330
33,056
OHKSMPECO
30,368
33,058
DSTUGUWHJ
30,390
33,064
YDUBRVJTI
29,680
33,095
EQXUGXGNS
30,440
Zapier Error
33,098
VRAPNQCJW
30,343
Zapier Error
33,106
TTWNRWIGY
30,506
33,108
NBTXWLYTL
30,508
Zapier Error
33,135
QOJKFLTEG
30,556
Zapier error since fixed
33,170
GVBRJMHDB
29,518
33,196
YPPALAFKS
30,634
33,204
BJTGZKMUJ
29,284
33,224
PHGNSTNTK
30,685
33,229
VNQYZVNOQ
30,412
33,245
ZXUQSFQAE
30,677
33,246
IGRAYGHMH
28,779
33,266
GPPIGNAWL
30,789
33,300
UMWWPHSXB
30,812
33,322
LVUSCVTHR
22,439
33,323
XIMJLYFKO
30,856
33,330
PEMXWNWAP
29,539
33,346
DNVKLTPHM
29,012
33,353
RSRECFSFP
29,435
33,395
RYOIIRJAV
30,958
33,398
VFVWCERZF
30,317
33,403
WCXTEBOOW
30,973
33,407
JPTLENTQW
30,980
33,408
WQJMUXQTH
30,989
33,415
NTGHWOELG
31,029
33,435
RJAKELVWI
31,052
33,450
WDERUVTVM
30,527
33,481
FRJFOBCIO
31,110
33,487
LEJQUCZYZ
31,055
33,498
RUQCOSDJF
31,141
33,501
AQDFCQDVI
31,146
33,504
RHPSPOSES
31,057
33,512
BUOMAVZDQ
31,171
33,523
UWWHJYFNG
31,184
33,524
LZHNLSPPD
31,185
33,525
SXDYVRNAV
31,186
33,530
AEJNNFFGS
31,089
33,531
JPZTWQRMF
31,188
33,554
LAYKXELNI
31,107
33,556
SFUWKWBHX
31,216
33,559
KDWPXOOQS
30,794
33,563
XTBBRIODX
31,060
33,566
RMZPTRERL
31,222
33,589
CUENTMDQK
31,060
33,604
OSOVYIVEF
31,298
33,610
EZHUCSYRG
28,112
33,612
BPVQDXFXX
31,326
33,614
RTFITTWEW
31,333
33,632
KPTGMYTWA
31,353
33,633
ZNLPHQBDA
31,355
33,635
CXVBGBTFP
31,191
33,657
KZEXOOARZ
31,325
33,665
YXXBADUHL
31,397
33,666
XDDBLLBGF
31,401
33,667
BIQSIQVEM
31,251
33,674
VUBWDBFEG
31,418
33,682
EAQWYOURV
31,434
33,694
HYKHOWICO
31,345
33,698
NXXBMBGMG
31,349
33,711
LKLIVGMQC
30,528
33,712
VQTEMMDPB
31,485
33,717
RNWGAMKGM
31,412
33,731
NWXQVQFSU
31,388
33,743
KIOFJJBGJ
31,534
33,746
RNDILOFHF
31,144
33,760
BNGHFTFAZ
31,598
33,764
EAKGMLMMW
31,272
33,770
BHNRMTSQP
31,606
33,820
ERRYQYENT
31,684
33,821
JNCMOWYJS
27,874
33,864
RMXPXGSNN
31,766
33,907
SKIXFMRHP
30,154
33,917
TWSIQFSYH
31,842
33,931
NKMFGWIDO
29,871
There are no rows in this table

For Vilde:

Value Auto Field in person > Can we delete ?
—Everyone needs to approve the automation and turn it on (COLD) & ILY - so we have lots but we should have more 🤔
ILY : the dates are populated only for those with A/AA (but if this changes they will still be populated) **** > Even if they downgrade they should be called for ILY, if you enter as AA > then you follow post sales process.
I want to delete all activities without a deal - can I? - NO: 🟠
When deals are created manually then the automation will: Will be renamed: (value) - person - org because we dont have product. Is that ok? Or should I add a custom field for product. IF order reference exists then it will do value - ref - org name
Order Number required in certain phases and when marked won/lost?
To make sure we are not counting deals twice i.e. created by presta won by presta, created by bob won by bob same order > counted twice. Order number MUST BE ADDED!
Insights - no order number not counted in insights
What is happening in this situation: ✅
No Organisation by has reference ID:
NO ORG
deal ID
22,664
24,327
25,532
29,376
29,526
29,666
29,771
30,086
30,092
31,487
31,989
32,135
32,476
32,647
33,436
33,466
34,158
34,493
34,710
34,711
There are no rows in this table

For Emily:

Two org fields called Labels with the same values ✅
If there is no org value when an open deal is found then you need to add one. eg. () ✅
Add create deal if none found step to order status updated zap ✅
If the ORDER number exists create new deal ✅
MAke B& C Activity Control Centre ✅.
REmove products from deal entry ✅
AA/A
AA
A
B/C
B
C
Post Sales
Activities graph - activity types need to be same order
reorder Statuses in PrestaShop Statuses
Apps Script: Checkbox > Make Activity format order ref - heading ✔️
updated Activity in Pipedrive> Date Changed > Update sheet Col D with new date ✔️
Empty data fields visible in graphs!!
Only one order number should exist at a time
Cancelled orders > Lost
Cold Sequence Loom for team

For Dashboard:

We dont have deal values on the deals! Bulk import needed
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.