Saturday, 7 January 2017

Keep Track on Online Shopping By Google Sheets

 

I recently have placed an order for some tops and accessories on various sites. There were huge discounts and I couldn't help. What I observed was that nowadays the sites don't send all the products you've ordered at one go, but send them individually. That's because it has different sellers/stores selling on one website. It's great when we put 10 items in the cart, but do you know if you've received all those 10? Are you sure you haven't missed out on anything?

I had shared a printable two days back. It was to keep a track on online shopping. But, in case you're not good with the papers, here's yet another clever way to check whether you've received 'em all.

Go to Google Drive and create a new Google Sheet. Just like you work in Excel, work there. Here's what my sheet includes:

NAME
Name of the product. This is just a general idea of what the product is.

FROM
Name of the website/seller.

UNITS
If you've purchased two similar lipsticks (one for you and one for best friend), then write 2 here, otherwise, 1.

ONE UNIT COST
If the lipstick costs ₹400, write 400.

TOTAL COST
If you have purchased two similar lipsticks, write the total of two. In our example, write 800.

ORDER DATE
The order date is important. A valid point to argue with the company in case they haven't shipped/delivered your product yet.

ESTIMATED DELIVERY
Write the calculated estimated date.

SHIPPED
You often get the message when your item is shipped. Write YES or No accordingly.

RECEIVED
Write YES or NO if you have or not received the item.

EXCHANGED/RETURNED
In case you've sent the item for exchange or have completely returned it, wait until the complete process is done and then write COMPLETE. In case you've not exchanged/returned anything, put a dash (-).

You can try this on an Excel sheet too, but the Google Sheet will keep all your data with you, as it will stay online. You won't shop every now and then, right? You'll place a huge order once in three months. So even if you're too busy, I think you can take out some time to keep a check on whether you've received something that you've paid a bomb for.

How do you keep a track?
xoxo