Wednesday 21 February 2018

Customer expenses formula

Multiplication formula in Excel
To get the customer expenses I decided to use formula which takes =price*quantity, and puts the result to the customer spending cell.
=N3*$O$3

Web design Hull Web design services Freelance web designer web design blog IT specialist Why is the mobile version of the website important? What it's SSL certificate and how it benefits website? The most important features for e-commerce store? Why website does not appear in Google results? Content marketing is a wide field in which our imagination is the only limitation What is the guideline when choosing a hosting for the website? What is worth paying attention to when designing your company's website? The value of blogging in the terms of website design. Freelance web designer - Why do you need affordable website? The ultimate guide how to become freelancer in 2020 6 Features of best UX for web design in 2020 How works Google Assistant. OK Google get started 6 website types which hit the trends in 2020. 10 reasons why CMS need to die in 2020. What is ZCash and how does this modern cryptocurrency work? 5 Best ways to make money online in 2020. How you can make money online - find something adequate to skills The comprehensive guide how to become programer in London - 2020.

DataBase in Excel

I have prepared the pie chart related to my customers Excel Database.

Pie chart clearly shows how much money each customer spent on buying my services.

Also, you can notice total money which all customers spent.

The percentage units are helpful to choose the most valuable client - the biggest pie part represents the client which spent the most money.

Thanks to this data we can estimate future customers expenses.

In customers database we can include lots of customers details such as:
-Customer ID;
-Name, surname;
-Address;
-Phone no.;
-Registration date;
-Purchase date;
-Project/transaction number;
-Quote/product number;
- Customer spending.

The chart is useful for example in situation when we want to present to the others:
-the actions of our company;
-products popularity;
-behaviour and preferences of clients;
-statistics;
-estimation.

Web design Hull Web design services Freelance web designer web design blog IT specialist Why is the mobile version of the website important? What it's SSL certificate and how it benefits website? The most important features for e-commerce store? Why website does not appear in Google results? Content marketing is a wide field in which our imagination is the only limitation What is the guideline when choosing a hosting for the website? What is worth paying attention to when designing your company's website? The value of blogging in the terms of website design. Freelance web designer - Why do you need affordable website? The ultimate guide how to become freelancer in 2020 6 Features of best UX for web design in 2020 How works Google Assistant. OK Google get started 6 website types which hit the trends in 2020. 10 reasons why CMS need to die in 2020. What is ZCash and how does this modern cryptocurrency work? 5 Best ways to make money online in 2020. How you can make money online - find something adequate to skills The comprehensive guide how to become programer in London - 2020.

Thursday 1 February 2018

Own notes:
The screenshot above comes from my own prototype website which is not finished yet.
I am planning to fill up the shopping cart according to the project brief specification and criteria.

Product / Services pages should be attractive to the customer, try to encourage your customer as much as you can, use every way to acquire the potential customer. Do not forget to include the clear and a marketing style written description, photos, videos, the purpose of your products/services, why are they the best deals on the global market?
The good marketing practice is to include the basket on your website, it is a useful tool which makes your customer thinking that they are related to your products within the moment they added it to the basket. Sometimes because of lack of internet connection, electricity - the customer can lose session and lost their shopping progress. Take care of situation of this kind, you will get a guarantee that your customers will back to you, due to the fact that you provide convenience shopping service.

What's a Shopping Cart?

A shopping cart on an online retailer's site is a piece of software that facilitates the purchase of a product or service. It accepts the customer's payment and organizes the distribution of that information to the merchant, payment processor and other parties. Shopping carts bridge the gap between shopping and buying, so having the best shopping cart software is extremely important on your website.

It's likely that those just starting out in the market may be unfamiliar with the concept. Most people, especially those in the ecommerce industry, have likely made a purchase online at some point in their lives. That said, most consumers don't fully realize the need and capability that shopping carts have (besides leading a customer to checkout). A cart typically has three common aspects:

It stores product information
It's a gateway for order, catalog and customer management
It renders product data, categories and site information for user display

Another way to look at things is as follows: The online shopping cart is similar to the tangible ones we use at the supermarket, but it wears many more hats. It's also the shelves, the building, the clearance sign, the cash register and often the credit card machine relaying information back to the bank.

What options are there?

For those seriously considering the e-commerce platform route, it's important to know that there are two basic types of carts:

Hosted shopping carts: A third-party firm "hosts" the solution and is responsible for server backups, maintenance and upgrades. The beauty of a hosted solution is that hosting comes free, which means it doesn't cost anything for the third party to keep your site functional on the Web. The main drawback with hosted solutions is that customers will be directed to another domain for payment processing.
Licensed shopping carts: This type of solution allows business owners to build their own type of cart and customize it to their specific needs. There is much greater flexibility in changing features and functionality, as well as in adding third-party tools if need be. However, the upfront costs are often higher and require more hands-on expertise for troubleshooting issues and technical support.

Hosted solutions are often recommended for those who are beginning their own venture because they require less technical expertise. That's not to say all new online retail store owners aren't adept in IT, but a hosted solution may free up time to focus on other aspects of operations. There are numerous providers of shopping cart software on the market today, and companies must first evaluate their individual needs before making a final decision on which solution is best for them.

References: https://www.bigcommerce.co.uk/ecommerce-answers/whats-shopping-cart/

Frequently Asked Questions

Screenshot reference: https://anicca.co.uk/about-us/faqs/

FAQ

If you are running a website that is dealing with the general audience or some specific customers, then it is compulsory to have a detailed Frequently Asked Questions (FAQ( section on your website. The FAQ section will provide answers to the common questions that are asked repeatedly. By providing them in one place, you don’t have to answer them multiple times and the users won’t need to ask the questions separately.

As the FAQ section provides a large amount of information on a single page, it is very important to design that page in a friendly, welcoming and organized way. Various websites have adopted different layouts and designs for their FAQ pages. Finding out the ideal solution for your website could be very confusing at times. That’s why we have collected 20 best FAQ pages from all over the internet. Go through them and let us know which ones you like and which ones you don’t. Also, don’t hesitate to let us know if you have a new idea for designing your next FAQ page.

reference: https://dcrazed.com/build-proper-faq-pages-20-examples-explained/

Own notes below:

The frequently asked questions sections are responsible for providing the answers instantly for those people who are looking for them. If you are lucky enough, by preparing the valuable FAQ page you can bring more leads to your e-commerce website. If you contain interesting information, the people who are looking for the answer can come to your website.

It's obvious that you cannot include the answers to the questions like "Who controls the world" or any different type of generic question. Be specific during preparing your FAQ and try to answer the question according to your business. Try to predict what customers will be asking about or check what kind of question the competitors already answered.
By properly prepared FAQ section you improve trustworthy of your company.

Value=more leads.

Returns Policy

Own notes below:
Across my e-commerce website, I plan to sell digital marketing services, so I am going to include the Return/Refund policy which is specific to the digital marketing business. I am willing to give the guarantee of satisfaction for my customers so there would be a chance to get money back If the customer will not be satisfied - obviously, terms and conditions apply ;) so before the query, please check the terms conditions, policies.

What is a Return/Refund Policy

A Return and Refund Policy is the agreement where you inform customers about your policies regarding returns and refunds.

It usually includes the following pieces of information:

How many days they have to return a product
How will they receive the refund (credit or replacement)
If you offer refunds for digital products or in-app purchases
Who pays for shipping to return the product
And so on

Why use a Return/Refund Policy

The “Return and Refund Policy” Generator will create a custom policy for your e-commerce store.

Most e-commerce stores should have a Return or Refund Policy. This includes retail stores as well.

Customers must be informed about their rights to refunds. This “policy” is the page where businesses inform customers about their policy on return and refunds.

The Policy is part of the 3 legal agreements your e-commerce business should have:

The “Return and Refund Policy”. Use this agreement to inform users about your policy on returns and refunds.
The “Privacy Policy” agreement. This is required by law.Use this agreement to inform users about your privacy practices and what kind of personal data you collect from users.
If you collect any kind of personal data from your users (e.g. email addresses, first and last names), you’re required by law to have this agreement.
The “Terms and Conditions” agreement.This is optional but recommended. Use this agreement to set the rules and guidelines for users when they register an account with you.
You could add the Return and Refund Policy in your Terms and Conditions rather than having a separate agreement on returns.

Wikipedia defines “returning” as:

In retail, returning is the process of a customer taking previously purchased merchandise back to the retailer, and in turn, receiving a cash refund, exchange for another item (identical or different), or a store credit.

Most countries industry regulations require stores (even digital stores) to have this kind of policy.

eBay’s help pages mention that stores with return policies published online will sell better. However, eBay requires all stores to have this policy:

We’ve found that items with clear return policies typically sell better than items that don’t.

What to include in Return/Refund Policy

Download Return/Refund Policy template. It’s free.

Your Return Policy or Refund Policy should include at least the following sections:

The numbers of days a customer can notify you for wanting to return an item after they received it
What kind of refund you will give to the customer after the item is returned: another similar product, a store credit, etc.
Who will pay for the return shipping

If you sell digital products, the Policy should include the following sections:

If you offer refunds on digital purchases
If you offer refunds in limited cases, e.g. download link wasn’t working

The best Policy you can have is the simplest one. Here’s what a policy based on the above tips will look like:

If you are not 100% satisfied with your purchase, you can return the product and get a full refund or exchange the product for another one, be it similar or not.

You can return a product for up to 30 days from the date you purchased it.

Any product you return must be in the same condition you received it and in the original packaging. Please keep the receipt.

The U.S. store of Apple has a more detailed return & refund policy:

Screenshot of Apple Return and Refunds Page

It covers these sections, but its full policy on sales and refunds is more detailed:

Standard Return Policy
Ship your item back to Apple
Refunds or Exchange an item
Return a gift or Gift refunds

IKEA says that “It’s ok to change your mind” on their U.S. store return policy:

IKEA’s policy covers:

In Store Purchases
Online or Phone Purchases and Mattresses “Love it or Exchange it”

The Returns & Refunds page of Amazon is more comprehensive as it groups everything into 3 sections: Returns, Refunds and Exchanges.

Screenshot of Amazon Return and Refunds Page

Amazon can connect the account users used to make a purchase to their Refund Status dashboard, users can check their refund status by following a few instructions once they are logged into their account.

Examples of Return and Refund Policies

The “Return and Refund Policy” Generator will create a custom policy for your ecommerce store.

Download Return/Refund Policy template. It’s free.

FiftyThree

FiftyThree’s Pencil has a 30-days refund policy: customers can buy the product, try it and if they are unsatisfied, they can return it within 30 days. FiftyThree will offer either a refund or a replacement.

FiftyThree doesn’t have their Return and Refund Policy named like this, but it’s called a Pencil Guaranteeinstead. It specifies the exact terms in which returns and refunds are processed:

Customers have up to 30 days to ask for a refund
A Return Merchandise Authorization (RMA) must be requested
The serial number of the Pencil must be verified first
FiftyThree will pay for any shipping involved (with exceptions)
Refunds are credited back to customers’ Visa, MasterCard or American Express credit/debit cards

While the 30-days refund policy is available on the Pencil’s product page, the “Pencil Guarantee” page is placed in the footer, but only available if the user clicks on the link named Legal first:

And then clicks on FiftyThree’s Shop Guarantee:

Calm the Ham

Calm the Ham’s policy on returns and refunds is available if the user clicks on the “Shop Policy” link from the footer:

Calm the Ham’s Return and Refund Policy is very simple:

If you are not 100% satisfied with your purchase, simply send it back within 14 days and we’ll refund the full cost of the item minus shipping costs.

Calm the Ham

Greats

Greats places their Return and Exchange Policy in their Terms of Use page, but their footer also has a Returns or Exchanges link that might confuse customers:

Their Return and Exchange Policy details what does a customer must do to return a product within 21 days of purchase:

Greats Returns and Exchange Policy in Terms of Use

ThemeForest

ThemeForest sells digital products and they place their policy on returns and refunds in the “Envato Market Terms” page:

Given the nature of downloadable digital items, we do not generally offer a refund or credit on a purchase unless required under Australian consumer law or other relevant consumer protection laws.

Envato

The Envato Market Terms page is linked from the footer of their website:

Booking.com

The Booking.com iOS mobile app doesn’t have a separate policy on refunds, but their policy on refunds depends on the policy of refunds of each hotel chain that has listed on Booking.com.

Booking.com owns the platform, but the policy on refunds depends on the hotel. This is specified in their Terms and Conditions page:

Sometimes cheaper rates are available on our website for a specific stay at a property, however, these rates made by accommodations providers may carry special restrictions and conditions, for example in respect to cancellation and refund. Please check the room and rate details thoroughly for any such conditions prior to making your reservation.

Booking.com

WizzAir

WizzAir lets you search and buy flight reservations through its mobile app. WizzAir doesn’t have a Return and Refund Policy like most e-commerce stores would, but their General Conditions of Carriage page is informing customers about their rights to refunds.

The “General Conditions of Carriage” document is the agreement that each user must agree to in order to buy a ticket through WizzAir’s mobile app:

User selects the flight’s price and must click I accept in order to continue
If user clicks Read terms, the user can read the linked legal agreements (including its General Conditions of Carriage)
The “General Conditions of Carriage” is embedded from WizzAir’s servers:

Download Return/Refund Policy Template

The “Return and Refund Policy” Generator will create a custom policy for your ecommerce store.

Download the Return & Refund Policy Template as a PDF file or Download the Return & Refund Policy Template as a DOCX file.

You can also download this Return & Refund Template as a Google Document.

This template is free for download. It includes these sections:

Returns. Inform users how many days they have to return the product and in which conditions: same package, and so on.
Refunds. Inform users how will they receive the refund for the product: credit on their credit/debit card or on the same original method of payment they’ve used.
Shipping. Inform users who will pay for shipping.

reference: https://termsfeed.com/blog/sample-return-policy-ecommerce-stores/

Privacy Policy

Updated 10/01/2018

The policy sets out the different areas where user privacy is concerned and outlines the obligations & requirements of the users, the website and website owners.

What personal information do we collect from the people that visit our blog, website or app?

When do we collect information?

Email Campaigns

How do we use your information?

How do we protect your information?

Do we use 'cookies'?

We use cookies to:

External Links

Third-party disclosure

Third-party links

Google

Google's advertising requirements

We have implemented the following on-site:

Social Media Platforms

Shortened Links in Social Media

Opting out:

How does our site handle Do Not Track signals?

Does our site allow third-party behavioural tracking?

We will take the following responsive action, should a data breach occur:

Contacting Us

Own notes below:

I took the liberty to 'Copy&Paste' the sections of the competitor's website which are provided by the competitor. Do not hesitate to have a look at it, consider the purpose why the competitor included those sections? Try to adopt the sections to your business and think about your own paragraphs which may apply to your e-commerce website.

references:https://anicca.co.uk/privacy-policy/