Customer order Microsoft template

I am using Microsoft template to manage orders on my website. This template allows me to see the total price with tax that user need to pay.

This formula sums up price in exact row when conditions are made. If cell A18 is not equal 0, formula multiplies cell A18 which is quantity of product by price in cell E18 and if the condition is made it shows sum in cell G18. If the condition is not made cell G18 shows just blank space. Formula is the same for cells from A18 to G37.

The cell G39 sum up every value in cells G18 to G37 if condition is made. Again, if value in any cell between G18 and G37 is bigger than 0, then cell G39 shows sum of all values greater than 0. If there is no value greater than 0 then this cell shows blank space.

This cell is again conditional cell. If the sum of cell G39 is greater than 0, then this cell multiplies value of cell G39 by tax rate in cell G40 to get total sum of all product with tax rate. If tax rate in cell G40 is equal 0 or null, then total value is equal the same value as it is in cell G39. Else if Subtotal value in cell G39 is equal to 0, then total sum in cell G41 shows blank space.

Comments

Product DB

This is how my Product Database on WIX look like. I am using a wix database from template to store my products. Database on my website is used to keep inventory of my products. In few words database can store price, product name, unique ID to recognise product, boolean values to tell user if product is available or no, and there is many more features when using a database on website.

Product ordering

To purchase cryptocurrency on my website we have to do following steps: 1. Go to OpenMarket 2. Select cryptocurrency that we are interested in buying 3. Add selected product to basket 4. After we select all the product that we are interested in, we can proceed to see the card 5. To make transaction we have to click one of checkout buttons 6. At this moment we should be able to finalise transaction by writing our card details, however, because I am using free version of wix we are not able to finalise our transaction.

SEO

SEO (Search Engines Optimisation) - It is about optimising web pages for the search engine to be as high in search engine as possible. To optimise web page we have to use correct tags, words, web page structure, link to partners and social media. In order to do SEO on the page correctly we have to know how exactly the SEO works. SEO is used to make websites visible in the search engine on the highest position. Optimisation is also used to have high Click Through Rate (CTR) to monetise websites.

Patryk's W LIPC

Search This Blog