COPING WITH THE CHALLENGE OF SORTING LARGE PRODUCT CATALOGS - - PowerPoint PPT Presentation

▶
coping with the challenge of sorting large product
SMART_READER_LITE
LIVE PREVIEW

COPING WITH THE CHALLENGE OF SORTING LARGE PRODUCT CATALOGS - - PowerPoint PPT Presentation

Jun 01, 2023 294 likes •763 views

Please write title, subtitle and speaker name in all capital letters COPING WITH THE CHALLENGE OF SORTING LARGE PRODUCT CATALOGS ONLINE - SHOP WINDOW ARRANGEMENT CAGDAS SENOL 19-06-2019 Put images in the grey Put images in the grey

slide-1
SLIDE 1

COPING WITH THE CHALLENGE OF SORTING LARGE PRODUCT CATALOGS

ONLINE - SHOP WINDOW ARRANGEMENT

CAGDAS SENOL 19-06-2019 Please write title, subtitle and speaker name in all capital letters

slide-2
SLIDE 2

2

Put images in the grey dotted box "unsupported placeholder" Please write the title in all capital letters

  • Challenges
  • Data Driven Sorting
  • Three Improvements for faster iteration
  • One Open Source Contribution
  • Status Quo
  • Q&A

TABLE OF CONTENTS

Put images in the grey dotted box "unsupported placeholder" Please write the title in all capital letters

slide-3
SLIDE 3

3

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

ZALANDO AT A GLANCE

~ 5.4billion EUR

revenue 2018

> 300 million

visits per month

> 15,500

employees in Europe

> 80%

  • f visits via

mobile devices

> 27

million

active customers

> 400,000

product choices

~ 2,000

brands

17

countries

slide-4
SLIDE 4

4

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

DISCLAIMER

slide-5
SLIDE 5

5

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

Window Dressing

Put images in the grey dotted box "unsupported placeholder" Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

slide-6
SLIDE 6

6

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

“Window dresser

Window dressers arrange displays of goods in shop windows or within a shop itself. Such displays are themselves known as "window dressing". They may work for design companies contracted to work for clients or for department stores, independent retailers, airport or hotel shops.

“

slide-7
SLIDE 7

7

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

DATA DRIVEN SORTING

Put images in the grey dotted box "unsupported placeholder" Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

slide-8
SLIDE 8

8

Please write the title in all capital letters

CHALLENGES

Please write the title in all capital letters

CHALLENGES

4k ups 17 15 400k

slide-9
SLIDE 9

9

Please write the title in all capital letters

slide-10
SLIDE 10

10

Please write the title in all capital letters

Fail fast, Iterate faster

slide-11
SLIDE 11

11

Please write the title in all capital letters

ITERATE FAST

DESIGN A/B TESTS ANALYSIS

slide-12
SLIDE 12

12

Please write the title in all capital letters

Three Improvements

  • Steering
  • Fast Index Updates
  • Sorting with functions
slide-13
SLIDE 13

13

Please write the title in all capital letters

First Improvement: Sort Steering

slide-14
SLIDE 14

14

Please write the title in all capital letters

Sort Steering - SQL Analogy

Id Bucket Popularity sku1 1 0.2332332 sku2 2 0.123233 sku3 1 0.4533 SELECT * FROM articles ORDER BY Bucket Desc, Popularity DESC Sku2 Sku3 Sku1

slide-15
SLIDE 15

15

Please write the title in all capital letters

Sort Steering - SQL Analogy

Id Bucket Popularity Popularity_male sku1 1 0.2332332 0.4 sku2 2 0.123233 0.6 sku3 1 0.4533 0.1 If category_gender == “men” SELECT * FROM articles ORDER BY Bucket DESC, Populartiy_male DESC Else SELECT * FROM articles ORDER BY Bucket DESC, Popularity DESC

slide-16
SLIDE 16

16

Please write the title in all capital letters

Pre-Sort Steering Architecture

slide-17
SLIDE 17

17

Please write the title in all capital letters

Sort Steering Added

slide-18
SLIDE 18

18

Please write the title in all capital letters

Sort Steering - SQL Analogy

Id Bucket Popularity Popularity_male sku1 1 0.2332332 0.4 sku2 2 0.123233 0.6 sku3 1 0.4533 0.1 If category_gender == “men” SELECT * FROM articles ORDER BY Bucket DESC, Populartiy_male DESC Else SELECT * FROM articles ORDER BY Bucket DESC, Popularity DESC

slide-19
SLIDE 19

19

Please write the title in all capital letters

slide-20
SLIDE 20

20

Please write the title in all capital letters

2nd Improvement: Decoupled Data Ingestion

slide-21
SLIDE 21

21

Please write the title in all capital letters

Indexing - SQL Analogy

Id Price Stock Size Partner Performance Performance_new_formula sku1 9.99 100 32 false 0.5 0.4 sku1 9.99 100 32 false 0.3 0.6 INSERT INTO articles VALUES(9.99, 100, 32, false, 0.5, 0.4) INSERT INTO articles VALUES(9.99, 100, 32, false, 0.3, 0.6)

slide-22
SLIDE 22

22

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

Intake Architecture

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

slide-23
SLIDE 23

23

Please write the title in all capital letters

Indexing - SQL Analogy

Id Price Stock Size Partner sku1 9.99 100 32 false Id Performance Performance_new_formula sku1 0.5 0.4 sku1 0.3 0.6 Id Price Stock Size Partner Performance Performance_new_formula sku1 9.99 100 32 false 0.3 0.6 JOINS => Elasticsearch

slide-24
SLIDE 24

24

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

Intake Architecture Now

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

slide-25
SLIDE 25

25

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

3rd Improvement: Sorting with Functions

slide-26
SLIDE 26

26

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

Painless Scripts

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

slide-27
SLIDE 27

27

Please write the title in all capital letters

Sorting with Functions - Eliminate Reindexing

Id Price Stock Size Partner clicks sales sku1 9.99 100 32 false 10000 300 SELECT * FROM articles ORDER BY popularity(sales,clicks) popularity(sales, clicks) = sales/clicks

slide-28
SLIDE 28

28

Please write the title in all capital letters

Sorting with Functions - Personalization

Id Price Stock Size Partner popularity article_features sku1 9.99 100 32 false 1.2 [9.99, 100, 32] If known_customer : SELECT * FROM articles ORDER BY dot_product(article_feature, customer_features) Else SELECT * FROM articles ORDER BY popularity

slide-29
SLIDE 29

29

Please write the title in all capital letters

Sorting with Functions - Fulltext Search

Id Price Stock Size Partner clicks sales sku1 9.99 100 32 false 10000 300 If fulltext_search : SELECT * FROM articles ORDER BY f(relevance_score, clicks, sales, customer_features, article_features) Else SELECT * FROM articles ORDER BY g(clicks, bucket, sales, customer_features)

slide-30
SLIDE 30

30

Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box

EXAMPLE SORTING RULES

Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box

slide-31
SLIDE 31

31

Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box

Personalization

Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box

slide-32
SLIDE 32

32

Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box

Query Relevance

Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box

slide-33
SLIDE 33

33

Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box

Inline Popularity Calculation

Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box

slide-34
SLIDE 34

34

Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box

Open Source Contribution

slide-35
SLIDE 35

35

Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box

CODE IN CONFIG ????????

Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box

slide-36
SLIDE 36

36

Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box

TGYHT - Thanks God You Have Tests

Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box

slide-37
SLIDE 37

37

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

Make Painless Script Development Painless

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

  • Painless Lacks Tooling
  • Elasticsearch Painless Execute API
  • https://www.elastic.co/guide/en/elasticsearch/painless/cur

rent/painless-execute-api.html

slide-38
SLIDE 38

38

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

Painless Scripts Development Tool

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

  • https://github.com/csenol/plsd
  • Integrated with CI/CD Pipelines
slide-39
SLIDE 39

39

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

Painless Script Development Environment

slide-40
SLIDE 40

40

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

Painless Script Performance Tests

slide-41
SLIDE 41

41

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

TESTING PAINLESS SCRIPTS/ CI-CD Integration

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

slide-42
SLIDE 42

42

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

Sum up

  • Sort Steering => A/B tests
  • Decoupled Indexing => Data

Enrichment

  • Sorting With Functions => Faster

Implementation + Personalization

slide-43
SLIDE 43

43

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

Notable window dressers[edit]

  • Giorgio Armani, the

fashion designer once worked as a window dresser.[1]

slide-44
SLIDE 44

Please write contact name, department and position in all capital letters

Cagdas Senol

cagdassenol@gmail.com

Please write contact name, department and position in all capital letters

slide-45
SLIDE 45

45

Please write the title in all capital letters Put images in the grey dotted box "unsupported placeholder" Use bullet points to summarize information rather than writing long paragraphs in the text box

Q&A