How to design a successful eCommerce system for Amazon, eBay, FilPCart and Walmart (by Amazon TPM)

[@WasteMaterial-vr3qe]

Was not expecting this much knowledge in span of 10min. Amazing content

[@ChandanArya2002]

first time , I am decreasing the speed of videos 😄

[@pratikshabakrola]

Ha ha !

[@Jokerbgm123]

Qq❤q❤​@@pratikshabakrola

[@Jokerbgm123]

​@@pratikshabakrolaqq

[@RishiRajxtrim]

😎👍

[@nomanfaraz786]

thats because the uploader increased it before upload?

[@heyThereHypocrites]

Damn! This is the best tutorial video on KZbin for system design I have seen so far. You managed to get in the details, draw a sufficiently elaborated system, explained how you should think without actually doing it and still managed to finish it within 11 min. Thanks for your work! 🔥👍

[@pratikshabakrola]

I am so glad to hear this, thank you!

[@sajalagrawal1430]

I work in Amazon , such a detailed and crisp video is hard to find that cover all the core concepts . Thanks again for sharing this valuable information

[@vaibhavdubey2525]

I'll suggest to focus more on How Payment Service, Order Service and Inventory Service interact and how they hold the lock etc

[@himanshus_bhardwaj]

Its so amazing that you completed it in just 10 mins, where other UTUBERS take more than 30. ❣

[@pratikshabakrola]

Thank you :)

[@harshavardhanreddy7996]

Excellent Design covering from requirements, estimation,DataModelling,API's & drawing all service components in detail. Appreciate your effort & its a great content for system design. Keep going!! only suggestion is why cant user client talk to cart service directly and some message queues between services are not needed.

[@priyanshusinghal373]

it looks you just gave me whole idea of system design in one shot

[@pratikshabakrola]

I am glad you found it helpful and really appreciate you sharing this!

[@zifannie8890]

Have to decrease the speed in order to catch up lol. Very good content!

[@AltaiiSinan]

First time for me as well reducing the speed of the video. Really good job at drawing the system design! Thank you!

[@geetesh8539]

I like the flow you captured from the user requirement to the scaling part. Can you come up with more such videos so that we can frame our mindset in solving such HLDs. May be it's better if you could also talk on what these components do exactly & what are there alternatives. Overall, this seems to be a productive one. Thanks for such videos, hoping for more such videos soon

[@macewindont9922]

Great video! The part where you scale all the services was pretty quick and hand wavy. I would have appreciated some explanation as to how the message queues, etc. do what you said. But overall extremely helpful and succinct.

[@prabhupadswain7638]

Hello Ma'am or infact I can say Pratiksha as in IT culture we don't call Sir or Madam anyone. Your video is truly nice & the way you taught and expressed this concept is really great. There are many tutorials and the tutors teaching on YT refer to themselves having experience in top product based companies. But, from your teaching style, I am influenced and your concepts are really strong and it definitely looks like you are working with Amazon and you can really switch between product-based companies.

[@uvyadav8789]

Great content and great skill to deliver great content👏👏

[@AlanKhan-h3e]

how are these valuable information is available for free. You are amazing thank you so much, even if I dont clear my interview (which I am hoping I will), but the knowledge you are sharing here is out of the world. Cant thank you enough! :)

[@sankaryadav3646]

Video is informative. Thanks for sharing the info in quick time. I don't know this happened to me or all Playback speed was fluctuating.

[@pratikshabakrola]

Sorry about the furcation on playback speed. I will pay closer attention to that next time.

[@AnkitDeshmukh-l4g]

@Pratiksha Bakrola , keep up the good work. Very concise, to the point, in fact I like the speed of the videos it helps cram things faster before a system design interview. Much better than many ex fang swe's whose videos I have seen . Appreciate it.

[@melodicamallik5418]

Excellent and crisp explanation.Just a few questions.1. Why do we need a cartDb? As this is a temporary data and will not be required once an order is placed for the cart. It may be redundant in that case. But it will be useful if the user wants to retrieve the cart information later on. In my opinion, we can manage both Cart and Orders using a single DB.Same goes with inventory DB and order DB.We can use a single DB to manage both.And we can manage recommnedations using the search service itself as the source of truth is the search history db managed by Search Service.

[@pratikshabakrola]

When user add items to the cart but doesn’t complete the order and leave the site, you can keep those items in the cart when they revisit. I agree with your suggestion that you could manage that in the order database, by simply adding an additional column to indicate whether the order has been placed or not. I don’t think it’s such a good idea to have one database for inventory as well as orders, they’re essentially two different types of of data. When they’re separate, you can archive historical orders but if you maintain inventory in the same table, design is not as clean.

[@melodicamallik5418]

@@pratikshabakrola Sorry for the typo.I meant same DB for product and inventory.Its not orders.

[@rohigt5745]

Very insightful and densly packed. Thanks👍

[@tejeshreddy2933]

Best content for hld Please continue with the videos

[@pratikshabakrola]

Will do! thank you!

[@annrosethomas846]

Great content! and very clear explanation ! Thank you !!!!

[@maheshramteke2765]

This is really helpful and useful video for system design for beginners. Please add more videos from the above playlist. Your knowledge is really helpful for beginners in the software development.

[@shrijadas9987]

Spot on ! Loved this

[@jackanovcasanova]

Awsome !! Only thing i wished, if I can get the the whole flow chart as an image or pdf. Would have been a great help.

[@bhetobangalijd]

Very Basic design. Most of the time talked about the DB designs. Looking for the how product search is implemented, order transactions which will be interesting for the interviews. You talked about the scalability but didn't about the how you are going to implement via deployment or maintenance point of views

[@pratikshabakrola]

Thanks for taking the time to share your thoughts! Normally, your system design interview will be for one hour. If you remove the initial introduction with your interviewer and last few minutes for Q&A, you will have only about 45 minutes for the actual interview. If you can cover the design , elastic search, transaction processing system, plus deployment and maintenance point of view, Go for it!! But if you take all of that in requirements and don't complete the design, it reflects poorly on time management skills. Also, if you take on too many features, you may not be able to provide in-depth explanations. So, choose wisely!!

[@bhetobangalijd]

@@pratikshabakrola normally, user management is same for all the use cases. In interview, if its specially mentioned about ecommerce then you should focus on ecommerce related topics. Like how you are going to design your product catelog, cart management, order management. Covering only user management for the sake of time killing its not a good idea. 1hr is a huge time, to showcase your skills you should concentrate the other aspects apart from user management. Wisely from an architect POV, interviewers looking for how you are handling scalability, resiliency and how you are bringing out of the box ideas.

[@shineinusa]

most underrated i still wonder how this channel has such low sub count.

[@vaibhavdubey2525]

I have started watching your videos. Just amazing. Way better than a lot of KZbinrs. Specifically, your videos are to the point, and save a lot of time unlike other 1 hour videos. Keep the good work going. Full Support🙂 keep posting such videos

[@pratikshabakrola]

Thank you so much! 😊

[@vishalyex]

How can someone be so effortless. Ireally enjiyed watchubg whole video . Seriiusly❤❤

[@pratikshabakrola]

Thank you so much! Appreciate that

[@fatemehrezaei3727]

Very concise and to the point. Thanks so much!

[@shushriyaswarnkar9591]

Can you please mention the tool that you have used to draw the flow chart?

[@pratikshabakrola]

I am using free version of excalidraw

[@pranaysamrit5169]

@@pratikshabakrola can you tell me which library u used for icons

[@VinayKumar-sy3oj]

Excellent..! Well Articulated. Thanks for sharing. Nice speed flow given me More info in Less time. Please do keep sharing.

[@pratikshabakrola]

Thank you, I will

[@ashashankar29]

crisp and very relevant to interviews. estimations are good again wrt to interviews . thank you

[@akadeadahot7067]

as i randomly searching system design arch for e-commerce website this video is just a perfect match but i think this much type of deep dive is not needed for my product. Really appreciate your efforts and yes i understand how will i suppose to do things before starting actual implementation. 👍👍

[@pratikshabakrola]

Great to hear!

[@Shkkmj6868]

Great content, learned a lot of new things. Thanks a lot

[@jeffreyt999]

Thank you for putting this together. A couple of notes. The video seems sped up at certain parts and normal in others. A little jarring to follow. Personally, I see Search/Cart/Order as separate services. I would expect a direct interaction from User to Order or Cart Service and not through Search Or Reommendation.

[@pratikshabakrola]

Hi, Thank you for taking the time to share this. It usually takes a few hours to film the whole video and i sometimes talk faster(especially when i get tired). I will pay attention to the pace at which I talk. Regarding the Search/Cart/Order service. There are multiple right ways of doing something. So, You can have them as a separate service if you like. My thought process is: You saw a recommended product on your homepage and decided to add it to cart or You want something, you will search for it and add it to the cart from the search results. Hope this helps! Thanks,

[@vivekpaliwal1876]

❤ awsome vedio...can I clear my system design interview by watching all your vedios?

[@jsdurgam]

Could you please discuss the product inventory database please? I'm not clear on the flow and what you're storing to check and update inventory. Thanks

[@tommyck7185]

Top Tier explaination, very informative 👍

[@pratikshabakrola]

Glad you think so!

[@damf9416]

hi pratiksha , may i know in which platform were you doing the high level system design . the the entities that you were using were the default ones or were you needed to download some extensions ?

[@neetadhavade]

That was really great, 2.8K is very low on the like count. I wonder why

[@divyarajbakrola6395]

You made it look so easy and understandable! Keep up the good work !

[@pratikshabakrola]

Glad it was helpful!

[@GauthamVenkatesan]

Awesome work Pratkisha. Thanks.

[@GidzPaul]

Thank you. This was very helpful.

[@pratikshabakrola]

Glad it was helpful!

[@gnanadeepika9945]

Wooww! Amazing. This is by far best system design video for amazon! Keep posting :)

[@pratikshabakrola]

Thank you so much! This made my day!

[@jonamep]

I loved that you built the architecture following an ordering of usage (search to order status) and base implementation to improvements (services, DBs and then caching , archives) I just had one concern. Is it good to have one single service touching more than one database ? Also maybe horizontally organizing the system design in layers like web tier, app tier, data tier would improve the readability of the overall architecture by avoiding entanglements in the design. Thanks very much for sharing your knowledge :D Please post more of that content!

[@pratikshabakrola]

There are many ways to optimize the architecture, Thanks for taking the time to call out other considerations! Yes, more videos to come soon!

[@datasciencetoday7127]

single best resource online

[@pratikshabakrola]

Thank you so much!

[@anurag10]

Good work. Thank you. You have forgotten to add address ID as a FK in User table so that you can FK it to address table where Address ID is a PK. Pls check it out or LMK if my understanding is incorrect. Thanks.

[@cameliawilliams2312]

Great video, the structure and information of your presentation are the best, thank you!

[@venkatabora1459]

Useful, Insightful and Thoughtful system design videos before Interviews. Thanks Pratiksha :)

[@pratikshabakrola]

Thank you for the feedback!

[@a_storyy_teller]

your explanation is good and to the point

[@pratikshabakrola]

Thanks!

[@vijaykumarmanchuri8452]

Could you please let me know whats the tool used to do the system design diagram

[@gokarnasuhaan]

Wow , amazing step by step explanation 🎉🎉🎉🎉 subscribed ❤ Keep up the great job !!!!! Cant wait to watch more videos like this

[@pratikshabakrola]

Thank you so much :) :) More videos to come

[@ikinataadesanya8108]

Very informative video...thank you so much. What tool did you use for draw the diagrams?

[@hetsuthar9538]

Excalidraw, I guess

[@shafiulislamjony6851]

Your video is absolutely stunning! ❤ Great job!

[@pratikshabakrola]

Thank you!

[@ronishjariwala8714]

I just wanted to let you know how much I loved your content! It was absolutely fantastic, and I can't wait to see more. Do you think you could upload some more soon? I'm really looking forward to it.

[@pratikshabakrola]

Thank you 🙏🏼 more videos to come soon!

[@vigneshaithal]

Very nice tutorial ma'am. Very helpful. Please make videos like this, it truly helps us.

[@pratikshabakrola]

Thanks for sharing the feedback, more videos to come soon!

[@deepesh259nitk]

Great video on System Design good part of this video it is fast forwarded so to recap it's easier to come back and review, Thanks for creating it. At 5:10 You have opted to use NoSQL DB for order data to avoid 2 tables. Can that approach apply to user data? storing both user details and addresses in one place using NoSQL DB ?

[@pavansbhosle]

I guess you are referring to table when you say database here right ? For example address db, product db etc.

[@gkdaeiaef]

Why are we not using SQL for order database when the requirement states you need high consistency for it?

[@ShaliniToopran]

Great content and very informative. You could have slowed it down a bit, I had to slow the speed and rewatch.

[@pratikshabakrola]

Noted!

[@efoamegnito3546]

Thank you for this video. Please what tool do you use to implement the design?

[@Srikanthpalagani]

Very detailed explanation, by the way, which tool are you using to design?

[@asashish905]

Loved it. ❤

[@Learner-q5m]

Pratiksha, which tool are you using to draw these diagrams/blocks of system design?

[@bhushan8384]

Great content in short time. Keep it up!

[@KyuriousBot]

Perfect for entry level system design rounds!!!! Need more videos, please. 😄

[@pratikshabakrola]

More coming soon! Thanks

[@alexey121288]

Could you please name the icons library you used in excalidraw? It looks perfect.

[@mohnoor94]

This is super simple, neat, and helpful! Thank you!

[@pratikshabakrola]

Thanks for sharing this feedback! Appreciate it

[@jeremyliem2649]

Improvement Points: for Search API -> add query parameters for pagination Do not use verbs on service names - can combine Order Service into one

[@pratikshabakrola]

Excellent call out! Thanks

[@KiranMungekar-m6d]

Hi Pratiksha, Great explanation.... just one question, why does Search service and Recommendation service needs to interact with Add-to-cart service ? add-to-cart service can be directly called with productId and userID to store in db.... any specific reason for that communication ? because for as it is a microservice, it should be highly cohesive, also these services requires high availability then why un-necessary increase the work load?

[@AnjulGoel-h1o]

Could you explain why did you add messageQ, won't the search and add to cart operations by synchronous ?

[@roohitrajj]

well explained .. need to watch couple of time. thanks

[@mayuragrawal4410]

what tool did you use to draw the system?

[@AMX0013]

Great content!! Where can I find the draw tool and the library of images for each component? That would be greatly beneficial !

[@kanaiyapatel5691]

Awesome

[@pratikshabakrola]

Thanks

[@omjavir07]

Thank you, really very informative ✅💯

[@pratikshabakrola]

Glad it was helpful!

[@sip360]

Very good madam please keep to making these videos

[@pratikshabakrola]

Thanks, will do! Appreciate your feedback

[@ankd18]

Thank you for creating such an awesome video that helps to learn about System Design based on real-life product. Could you please share downloadable links or images of the System Design (non-scaled and scaled) that were shown in this video?

[@pratikshabakrola]

Thanks for sharing the feedback, i am working downloadable links.

[@nithishgolla7610]

Can you please tell me about the tool used for system design diagrams

[@arivkannagi]

I see you have recomondationDB -> But we have millions of active users -> It will not be scalable if we are stroing user specific recomondations right ?

[@nehasingh-ld7bn]

How and when is the Product inventory DB getting populated? And once an order is placed, shouldn't it decrease the number of items from product DB as well as Elastic search cluster?

[@mayank_singh_43]

Awsm content, to the point talk

[@pratikshabakrola]

Thanks!

[@Barv30]

thanks for your video. can you explain please the usage of MQ for the search service and addToCart service? I'm not sure I get the idea why to use it instead of Rest API

[@Nayaan_ai]

could you please mention the name of library you used for drawing in Excalidraw ?

[@KnowledgeGuide859]

+1 Same question

[@saurav0777]

Great explanation in short time .

[@pratikshabakrola]

Thank you so much!

[@krishnakumarramachandran5888]

Hi Pratiksha, Thanks for this video. I have two doubts, 1. what is the use of message queue in search service and get recommendation service? 2. You have mentioned everything as db, so are they maintaining everything in separate db as product db, search history db, recommendation db, and product inventory db?

[@hetsuthar9538]

❓Question - Why do we need to pass UserId to every api call param as we can extract it from the api session itself? (Assuming APIs are accessible post to user login)

[@VrittiRohira]

What tool are you using for whiteboarding?

[@utkarshgupta2909]

Nice video. Which tool is used to make the system design diagram?

[@hetsuthar9538]

You can use excalidraw

[@ansumandas5749]

Loved it.

[@travelnlearn]

Thank You for this awesome explanation

[@pratikshabakrola]

Thank you!

[@piyush10vns]

That was Great video, You are the best .

[@pratikshabakrola]

@piyush10vns, Thank you 🙏 You made my day ! :)

[@saicharan8675]

Very niceee.... Great one

[@shikharsharma6399]

When to use SQL vs NoSQl is clear. But how do you decide between documentDB vs keyValue in this case? Like why did you use KeyValue in the customer reviews and not document DB?

[@RaviKumar-kl3vq]

Very informative and concised video. Thanks a lot for that. Please keep making such videos. Also can you please let us know about the tool you are using to make the designs ?

[@pratikshabakrola]

Hello RaviKumar, Thank you for the feedback! I am using Excalidraw for drawing. You can find more about it in 'How to Ace System Design Interview' video around 11 minute mark.

[@pratikshabakrola]

kzbin.info/www/bejne/nXnWoGWojNRreKc

[@MiteshBDesai]

Nice. Whcih tool did you use for the block daigram ?

[@pratikshabakrola]

The tool is called Excalidraw. I am using the free version with System design libraries.

[@eXtrem1s]

The video is very easy to understand. Kudos on that. May I know what software do you use to make these systems?

[@pratikshabakrola]

I am glad you found this helpful! The tool is called Excalidraw. I am using the free version with system design libraries.

[@brijeshyadavmp14]

Thanks @ Pratiksha Bakrola for the awesome explanation in very short video. Could you please mention the tool name used for system design creation?

[@pratikshabakrola]

Thank you so much! The tool is called Excalidraw. I am using the free version with System design libraries.

[@sreyas14]

May i know the tool you have used to draw the design

[@alokkmishra]

Could you please create a video for the database design of Swiggy or Zomato?