Test Cases For Shopping Website In Excel

Test Cases For Shopping Websites In Excel: In this article, we discuss test cases for shopping websites 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 flow of shopping. However, despite having different flows, there are a few common things among them. So for simplicity’s sake, let’s 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 Websites

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

If it’s not Amazon, 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. 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 also see the product’s total price on this cart page. Here you can click on the pay now button. In some cases, you may find the page has a check-out button.

On the next page, you can 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 or add a new one. 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 can 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 payment flow 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 to get an idea of what you can test. If you want more deep tests, you may have to pick a specific website and cover the scenarios. 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 could let freshers know about this website.