Test Cases For Shopping Website In Excel

Test Cases For Shopping Website In Excel: In this article, we discuss about test cases for shopping website in excel, and in the last post, we discussed the Notepad test case. Recently we had one request where the user wanted to know how the process of book shopping online is tested.

Now there are plenty of book selling websites. And almost every one of them has its own flow of shopping. However, despite having a different flow, there are a few common things among them. So for the sake of simplicity let’s take a look at the generalized flow of book shopping and test its steps.

Post On:	Test Cases For Shopping Website In Excel
Post Type:	Test Case Template
Published On:	www.softwaretestingo.com
Applicable For:	Freshers & Experience
Join Here:	Telegram Group Link

Excel Test Cases For Online Shopping Website

Let’s assume the user lands on the webpage through the search engine. You can also say the user landed through a bookmark or any other means. After landing on the shopping website. User checks on the website if there is his specified book available on the front page. If not, then he’ll naturally search for the book by typing its name. If the bookshop is something like Amazon then the user may get a search recommendation.

If it’s not Amazon then he may need to hit the search button. And this way he goes to the search results page. Here a user can find the specified book. And then that book can be clicked for more information. And in this step, the user lands on the dedicated page for the book. Here a user can choose the “buy now” option by clicking on it. Some websites may have the “Buy” button. There is also going to be an option for quantity.

And in some cases, you may find “Add to wishlist” and “Add to favorites”. Let’s discard those nonbuyer options. And now that book is added to the “shopping cart”. Let’s proceed with the flow of the payment.

Online Book Shopping Flow of Payment

Online Book ShoppingWhen your product is added to the cart. In this case, the product is a book. That book will show its price and also the quantity. You can see the total price of the product on this cart page too. Here you can click on the pay now button. In some cases, you may find the page has the check-out button.

On the next page, you get the option to choose the payment method. In the case of the payment gateway, you may find different payout methods.

Test Case For Online Book Shopping

• Confirm if the item is added to the cart.
• Confirm if the quantity is as expected for the order.
• Confirm if the delivery charges are added to the cart page.
• Check the amount payable is correct.
• Check if the cart has the place order and continue shopping buttons.
• Check if the shopping cart shows the total savings amount.
• Check the delivery date of the item.

After you continue the process on this page, your order goes to the delivery page. And here, you have to either use your existing address of yours or add a new address. This way, you can allow the website to deliver your product.

Amazon Shopping Cart Test Cases for Delivery Address

• Check if the delivery address page shows your address properly.
• Check if the delivery address page has the option to add or remove your address.
• Check if the delivery options include different prices for different dates.

After confirmation from this delivery address page, you’d be prompted for the payment options. Depending on your site, you’d get different options. In my case, the payment page has the following options.

Online Book Shopping Test Scenarios for Payment options

• Check if the payment option phone, credit card, debit card, and net banking is given.
• Check if the phone pe option allows UPI or balance option.
• Check if the EMI option is enabled or disabled.
• Check if the cash-on-delivery option is available or not.
• Check if the bank offers are accepted in this process.
• Check if the process allows you to add a gift card code to this.

Conclusion

After this step, you can find the process moves to the final stage where you’re supposed to pay. And here, the testing options are different. But you get an idea of the flow of the payment and other options. Your options for managing the payment will be different.

The scenarios for the test will vary depending on the site under the test. So I have given mostly the generic scenarios so that you can get an idea of what you can test. If you want more deep tests, then you may have to pick a specific website and then cover the scenarios, respectively. You may want to check out test cases for the payment gateway.

I hope you found the information above useful. You can let me know if you have any questions, and if you found any missed test cases, then you can comment on that in the comment section of software Testingo. You can share the URL of this article on Facebook groups and with friends. I’d appreciate it if you can let freshers know about this website.