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

No video

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

Рет қаралды 69,776

Күн бұрын

System Design Amazon, eBay, Flipkart, Walmart
System Design Interview, Design Amazon.com, Design eBay, Design walmart.com, Design flipcart.com
how to conduct system design interview, system design interview done right, system design mistake to avoid, System Design interview correct way, Pratiksha Bakrola
#systemdesign #systemdesigninterview #designAmazon #designECommerceWebsite #systemdesignAmazon
#interviewprepration #faanginterview
System Design playlist: • System Design Interviews
Skillshare 30% off: skillshare.eqcm.net/c/5393508...
Connect with me 1-1 : topmate.io/pratikshabakrola
Subscribe to my channel: / @pratikshabakrola
Connect with me on Facebook: / pratikshabakrola
Connect with me on LinkedIn: / amazon system designamazon system design interviewfaang system design interviewsystem design Walmartsystem design amazonsystem design basicssystem design eCommercesystem design eCommerce websitesystem design instagram

Пікірлер: 229

@ChandanArya2002 Жыл бұрын

first time , I am decreasing the speed of videos 😄

@pratikshabakrola Жыл бұрын

Ha ha !

@Jokerbgm123 5 ай бұрын

Qq❤q❤@@pratikshabakrola

@Jokerbgm123 5 ай бұрын

@@pratikshabakrolaqq

@RishiRajxtrim 2 ай бұрын

😎👍

@nomanfaraz786 5 күн бұрын

thats because the uploader increased it before upload?

@heyThereHypocrites 8 ай бұрын

Damn! This is the best tutorial video on KZfaq 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 6 ай бұрын

I am so glad to hear this, thank you!

@WasteMaterial-vr3qe 4 ай бұрын

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

@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

@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.

@maheshramteke2765 2 ай бұрын

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.

@vaibhavdubey2525 10 ай бұрын

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

@ashashankar29 2 ай бұрын

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

@cameliawilliams2312 8 ай бұрын

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

@fatemehrezaei3727 23 күн бұрын

Very concise and to the point. Thanks so much!

@GauthamVenkatesan Ай бұрын

Awesome work Pratkisha. Thanks.

@saicharan8675 3 ай бұрын

Very niceee.... Great one

@divyarajbakrola6395 Жыл бұрын

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

@pratikshabakrola Жыл бұрын

Glad it was helpful!

@bhushan8384 4 ай бұрын

Great content in short time. Keep it up!

@vaibhavdubey2525 11 ай бұрын

I have started watching your videos. Just amazing. Way better than a lot of KZfaqrs. 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 9 ай бұрын

Thank you so much! 😊

@mohnoor94 Жыл бұрын

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

@pratikshabakrola Жыл бұрын

Thanks for sharing this feedback! Appreciate it

@roohitrajj 3 ай бұрын

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

@himanshus_bhardwaj 7 ай бұрын

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

@pratikshabakrola 6 ай бұрын

Thank you :)

@tejeshreddy2933 6 ай бұрын

Best content for hld Please continue with the videos

@pratikshabakrola 3 ай бұрын

Will do! thank you!

@jackanovcasanova 21 күн бұрын

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.

@venkatabora1459 11 ай бұрын

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

@pratikshabakrola 9 ай бұрын

Thank you for the feedback!

@vijaykumarmanchuri8452 2 ай бұрын

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

@shafiulislamjony6851 Жыл бұрын

Your video is absolutely stunning! ❤ Great job!

@pratikshabakrola 9 ай бұрын

Thank you!

@priyanshusinghal373 8 ай бұрын

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

@pratikshabakrola 6 ай бұрын

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

@gnanadeepika9945 Жыл бұрын

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

@pratikshabakrola 9 ай бұрын

Thank you so much! This made my day!

@efoamegnito3546 2 ай бұрын

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

@piyush10vns Жыл бұрын

That was Great video, You are the best .

@pratikshabakrola Жыл бұрын

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

@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!

@mayuragrawal4410 2 ай бұрын

what tool did you use to draw the system?

@ansumandas5749 Ай бұрын

Loved it.

@gokarnasuhaan 10 ай бұрын

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

@pratikshabakrola 9 ай бұрын

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

@VinayKumar-sy3oj 3 ай бұрын

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

@pratikshabakrola 3 ай бұрын

Thank you, I will

@kanaiyapatel5691 11 ай бұрын

Awesome

@pratikshabakrola 9 ай бұрын

Thanks

@akadeadahot7067 11 ай бұрын

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 9 ай бұрын

Great to hear!

@tommyck7185 6 ай бұрын

Top Tier explaination, very informative 👍

@pratikshabakrola 4 ай бұрын

Glad you think so!

@travelnlearn 11 ай бұрын

Thank You for this awesome explanation

@pratikshabakrola 9 ай бұрын

Thank you!

@AnjulGoel-h1o 13 күн бұрын

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

@vijaykumarmanchuri8452 2 ай бұрын

awesome video

@sankaryadav3646 11 ай бұрын

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 9 ай бұрын

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

@er.shivamkesarwani6668 Жыл бұрын

nice content

@pratikshabakrola Жыл бұрын

Thank you

@saurav0777 11 ай бұрын

Great explanation in short time .

@pratikshabakrola 9 ай бұрын

Thank you so much!

@sreyas14 2 ай бұрын

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

@amritaroy692 2 ай бұрын

Too Good !

@VrittiRohira 2 ай бұрын

What tool are you using for whiteboarding?

@GidzPaul 5 ай бұрын

Thank you. This was very helpful.

@pratikshabakrola 4 ай бұрын

Glad it was helpful!

@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!

@shineinusa 18 күн бұрын

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

@Barv30 7 ай бұрын

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

@vishalyex 11 ай бұрын

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

@pratikshabakrola 9 ай бұрын

Thank you so much! Appreciate that

@prabhupadswain7638 20 күн бұрын

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.

@bijayalaxmipradhan9808 Жыл бұрын

Great explanation. ❤

@pratikshabakrola Жыл бұрын

Thank you 🙏🏼

@omjavir07 7 ай бұрын

Thank you, really very informative ✅💯

@pratikshabakrola 6 ай бұрын

Glad it was helpful!

@sip360 10 ай бұрын

Very good madam please keep to making these videos

@pratikshabakrola 9 ай бұрын

Thanks, will do! Appreciate your feedback

@gkdaeiaef 23 күн бұрын

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

@erythsea Жыл бұрын

Love this❤ Ty

@pratikshabakrola Жыл бұрын

Thank you too much :)

@metalalive2006 Жыл бұрын

how to deal with potential data loss if nosql db is applied to order service ?

@a_storyy_teller 3 ай бұрын

your explanation is good and to the point

@pratikshabakrola 2 ай бұрын

Thanks!

@KnowledgeGuide859 4 ай бұрын

Which excalidraw library r u using

@AMX0013 3 ай бұрын

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

@parvkaurav7973 Жыл бұрын

Superb explanation.😀

@pratikshabakrola 9 ай бұрын

Thank you 🙏

@samim01 Ай бұрын

Didi tusi great ho

@bvinodmca Жыл бұрын

very nice

@pratikshabakrola Жыл бұрын

Thank you 🙏🏼

@alokkmishra 4 ай бұрын

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

@melodicamallik5418 11 ай бұрын

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 11 ай бұрын

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 11 ай бұрын

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

@iayushch 2 ай бұрын

Gem❤

@ikinataadesanya8108 Ай бұрын

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

@hetsuthar9538 Ай бұрын

Excalidraw, I guess

@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 9 ай бұрын

Thank you so much!

@erythsea Жыл бұрын

Subbed and liked

@pratikshabakrola Жыл бұрын

Thank youuuuuuu so much ! Really appreciate it :)

@Userkazt Жыл бұрын

How you calculated the size of the Description?? in Product storage section

@neetadhavade Ай бұрын

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

@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)

@mayank_singh_43 2 ай бұрын

Awsm content, to the point talk

@pratikshabakrola 2 ай бұрын

Thanks!

@shikharsharma6399 4 ай бұрын

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?

@krishnakumarramachandran5888 7 ай бұрын

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?

@eng-mahmoudali874 Жыл бұрын

Thank you very very much

@pratikshabakrola Жыл бұрын

Glad it helped!

@ankd18 10 ай бұрын

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 9 ай бұрын

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

@shushriyaswarnkar9591 4 ай бұрын

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

@pratikshabakrola 3 ай бұрын

I am using free version of excalidraw

@Nayaan_ai 5 ай бұрын

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

@KnowledgeGuide859 4 ай бұрын

+1 Same question

@santosh_bhat 10 ай бұрын

Nice video, can you please share the excalidraw libraries you used to get the wodgets ?

@pratikshabakrola 9 ай бұрын

I am using : System Design Components by @Rohan Pithadiya

@deepesh259nitk 5 ай бұрын

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 ?

@utkarshgupta2909 Ай бұрын

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

@hetsuthar9538 Ай бұрын

You can use excalidraw

@MeteorGarden8 Жыл бұрын

How did you tackle the high consistency requirement?

@MiteshBDesai 7 ай бұрын

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

@pratikshabakrola 6 ай бұрын

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

@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 Жыл бұрын

kzfaq.info/get/bejne/na6jopWjvNWccnk.html

@user-fc1wb2ii5w 4 ай бұрын

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

@pratikshabakrola 3 ай бұрын

Noted!

@williamm200 Жыл бұрын

i can pitch to compete with amazon ohhhh this is really good :D

@pratikshabakrola Жыл бұрын

Thank you 🙏🏼

@aftabalam7103 10 ай бұрын

Thanks for making this so easy to understand. Can you tell what tool are you using for this design diagram?

@pratikshabakrola 9 ай бұрын

Thank you so much! I am using Excalidraw. It's a great collaboration tool, you should totally check it out.

@jeffreyt999 8 ай бұрын

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 6 ай бұрын

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,

@ankitjain6437 6 ай бұрын

Hey can you share the tool you used to create the system design ???

@pratikshabakrola 6 ай бұрын

I am using Excalidraw with system design libraries for quick graphics.

@RishiRajxtrim 2 ай бұрын

👍

@thoughtsbyaish Жыл бұрын

Wont orderID be the output of the placeorder function? we wont know the order ID until it is placed, correct?

@pratikshabakrola Жыл бұрын

I made this video while ago, let me go over it again and get back to you! Thanks for the question!

@bhetobangalijd 8 ай бұрын

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 6 ай бұрын

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 6 ай бұрын

@@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.

@deadlyecho Жыл бұрын

Can you recommend a course or a book to help me develop and enhance my system design skills ? I struggle a little bit, when it comes to choosing the database paradigms, different technologies, etc.

@pratikshabakrola Жыл бұрын

+Echo Sound sure, ‘System Design Interview by Alex Xu’ is one of the best resources I have found, I don’t think it focuses on different type of databases. For that I had used bunch of different sources (blogs, courses etc.) check out my ‘crack system Design interviews’ video, at the end of the video I have shared all the resources! All the best :)

@deadlyecho Жыл бұрын

@@pratikshabakrola Thanks 😊 🙏

@eXtrem1s 8 ай бұрын

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

@pratikshabakrola 6 ай бұрын

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

@TheWrituraj Жыл бұрын

Very nice video and learned a lot. Awesome. Can you speak a little slowly so understanding is better. Thanks.

@pratikshabakrola 9 ай бұрын

Hi, Thank you for the feedback! Sorry if the speed threw you off! You can reduce the speed in KZfaq settings.

@sudeepkaushik652 6 ай бұрын

What diagramming tool was used in this video?

@pratikshabakrola 6 ай бұрын

I am using free version of excalidraw.

@ashishsaiwal218 11 ай бұрын

The video is really helpfull. I have understand how to design a system in more detail using this video. Hey Can you provide Excalidraw library for this ?

@yzc1128 11 ай бұрын

search for System Design Components

@pratikshabakrola 9 ай бұрын

I am using : System Design Components by @Rohan Pithadiya