The Annual Investment Calculator is a simple project to calculate your future outcomes. Input your desired annual investment amount, the anticipated average interest rate, and the investment duration for compounding interest. Optionally, include a principal amount for initial investment, or solely calculate based on the principal by setting the annual investment to zero.

This is a demo app that allows you to manage products (add and delete products) using separate front-end and back-end.

The front-end is created using HTML/CSS/JavaScript and is accessible from the index.html page

The front-end calls a simple rest API which was created in PHP, with two end-points: get and saveApi. When index.html page is loaded, it hits the get endpoint which reatrieves all the products in the database.

When Add is clicked, it loads the addproduct.html page which is a form that ads a new product. When saved is clicked, it hits the saveApi endpoint with an object created from the form. The saveApi endpoint gets the product data and saves it to the database.

Starting an online business might seem easy but it's not, it involves a lot of hard work and patience, as you will probably start over a couple of times until is working.

Fortunately, there are a lot of tools today that help you with that. One of those tools is Shopify.

Crysia.com is a baby clothes and baby care products online store build on the Shopify platform. It uses the basic Dawn theme (wich is free) with a couple customizations.

Most of the work I did in this project was bulk image optimization, bulk product upload and writting the text descriptions.

Since most of the product descriptions we got from our suppliers where poor and already used by other businesses, we had to rewrite all product descriptions. I discovered that doing this for almost 300 products might be quite challenging.

Fortunately, Excel is great for managing a lot of products. My previous experience with the Product Management Component surely helped with crysia.com project, as Shopify platform uses the same .csv file type which is organized kindly in the same way as I organized the Product Management Component, with title, description and metafields in different fields and with every product item in a different row.

To make the process of creating product descriptions easier and faster, I created an Excel file where I used field concatenation to create phrases based on common product features. AI writers such us Ubbersugest (wich I think is the best for generating product descriptions) and Chat GPT helped a little to generate some product descriptions that served as a guide of how it should be organized.

I also used a lot of Find and Replace, both in Excel and plain text editors to improve the descriptions and eliminate errors. Find and Replace was also great when dealing with website translations. Crysia.com was first published in English and then translated into Romanian and German. For both languages we used Shopify's autotranslation feature, wich is a great tool. For romanian language, since is the main market for Crysia.com, I used Excel to further improve the text descriptions, as the translations where often very weird.

Next, I had to take care of how the website is organized and make a SEO strategy, as well as a marketing strategy.

Sales Channels are very important for any online shop. I used Facebook, Instagram, Google and Pinterest Channels to publish the products. Shopify offers apps that may be easily integrated with all those channels. However, you still have to meet the requirements of each channel, such as having detailed product descriptions, EAN codes, shipping policy, return policy, s.o. I successfully listed crysia.com products on every channel. I also created ad campaings on Facebook/Instagram, Google and Pinterest.

• Everything needed to start an online store from skcratch using Shopify Platform
• Bulk image optimization
• Bulk produt description generation
• Bulk product upload
• Translation management
• Shopify store management
• Basic {% Liquid %} development

Product Management Component

I organized and designed a new way of managing products technical specifications (500+ items) by developing a multi-language component for the company's website (PHP/MySQL) that uses .csv files to import all the products specifications on the website (in a MySQL db as JSON data), .csv file that is also in Indesign, where the data is used to generate catalogs and brochures.

Working with technology products that have many technical specifications may be challenging for people in marketing or R&D, especially when the company has 500+ medical devices with lots of precise specifications, and where a few millimeters is the only difference between one product and another.

In this cases, having all the specifications for all the products in one place and getting all the data for both marketing and R&D from the same source is crucial in eliminating any human error and any miscorrelations between various marketing materials and documents, like having a diameter of 1.5mm showing on a product leafleat, 1.4mm showing in the paper datasheet and 1.6mm showing on the website.

This component allows multiple products to be imported and exported as a .csv file in the MYSQl database. Each product was stored in a row in the table and each specification was added as label and value field in that row. The .csv file was used as a common source for both online media, such as website products page or various landing pages, and for offline media, such as printed datasheets, brochures, product catalog, s.o.

The csv type of file was choosed because it's easy to use with Adobe Indesign, wich is a widely used software for the design of documents, catalogs and brochures.

Adobe Indesign has a function called Data Merge that allows you to use a csv or a text file as a source for the data you add in the document. You then create a template of the document, where you add the field name in the template and Indesign will generate separate design files, images or pdfs for each row in the csv file.

REST API technology is implemented to allow multiple landing pages and partner websites to get the product data and display the same specifications on their website.

This component is currently redesigned and will be available in 2023 as a Joomla Component and as a plain MVC project.

Data Acquisition Device Interface

Creation of the interface as well as the demo version for XpertVal64 Data Acquisition System (HTML/CSS/JavaScript), a touchscreen device that collects data from various sensors (T°, RH, Pressure, CO2, Voltage) and creates studies, reports and charts based on the data collected.

Affiliate Tracking System

I created and implemented an affiliate tracking system that allows the sales team and distributors to track the visits and quote requests on our website through their own affiliate link.

This system was developed as a Joomla Component and Plugin, using Joomla classes, and allows each user which is included in a certain users group (let's say "Affiliates") to have their own affiliate url, something like "example.com/?uid=affiliateusernaem"

The affiliate has access to o special section where he can login and see their statistics, which include visits on their link, unique visitors, quote requests, inquiries and sales made in various time frames (day, month, year, custom).

This component is currently under redesign and a new version will be launched this year (2023).

• PHP
• MYSQL
• JavaScript

Project Manager Demo

Project Management App created as a JavaScript/HTML/CSS demo project. It allows adding emmployees, projects and assigning employess to different projects.

Training Component

Application (JavaScript/PHP/MySQL) that manages the courses and trainings of the sales team. The Training Component allows the company to add, edit and delete courses, sections or pages, and the users to see dedicated courses which are available for their user level. It tracks and shows the progress of each user during the course and it shows badges and certifications when specific sections are completed.

Office Management Component

A component created using PHP/MySQL and JavaScript to manage our offices and distributors world wide. It’s a simple component that uses a separate MySQL table to store the user id, public name, latitude, longitude and contact details, joins the table with other user data and shows the offices on a map, with full details and links.