Consultant at SoftwareSupp
Consultant at SoftwareSupp
The Shopify theme development project concerned the online store selling physiotherapy products. A Shopify specialist has been hired to make code corrections and visual changes to optimize the customer website.
Nowadays, updating the website is a must. If we want to follow the latest trends, of course. Updating is also often a security feature.
In an outdated software or website, it is highly probable to find a vulnerability in the code to launch a cyber attack. Shopify updates automatically. In the case of this platform, we aren't exposed to attack caused by outdated software. However, when using WordPress or Magento, it is important to keep your site up-to-date. In the IT industry, a year is all eternity. Many people who exploit vulnerabilities in outdated software use automatic scanners that track the page code - Robin, Shopify Developer
I am a WordPress and Shopify freelance developer and have been working in the field for over 10+ years, and in the last 3-4 years with my current job, I have developed skills of being a support specialist. Years of experience working on various worldwide projects give me the confidence to provide the highest quality service.
The goal of Shopify theme development project implementation:
Optimization of the store in terms of SEO requirements and expanding the functionality of the website
Projects time: 36h
It took about 36 hours to adapt the store to the customer's needs. During this time, the client ordered extra tasks on an ongoing basis. Part of the complementary job resulted from necessity and some from additional preferences. It was the case, for example, with the fixes in the code. It turned out that the code structure needed to be changed.
As data published by Shopify shows, as much as 93% of customers consider visual appearance as a determining factor in a purchasing decision.
The Shopify online store which the project concerned sells products for physiotherapy. The customer wanted to correct and expand some of the website's details and complete the missing information. The changes in the headlines were a task not only for better positioning but also for the content's optimization, which directly influences the reader's impression. It means that the appropriate structure of the website improves the content's readability for users and Google's algorithms. The website user and algorithms have a better understanding of the content that has the appropriate structure. In this project, one of the tasks was to change the headings from H1 to H2. H1 is the headline that titles the entire page. On the other hand, the H2 headers are used for titling the page's content, such as a broad text fragment. A properly designed website contains 1 H1 header and some H2.
The flattening of the webpage structure consisted in editing the code so that all products appear on one page with the possibility of scrolling. This option makes it easier to navigate. The user can find a specific product faster and more comfortably than switching product pages. Checking the linking on the website blog was to verify the problem of hiding links and the lack of highlighting. Expanding the website's functionalities also depended on adding icons for payment methods in the cart and on the product pages.
Shopify theme development focused on supplementing the template in the product with advanced variants. A miniature carousel has been created to open the possibility of choosing the product at different prices, in various colors. The choice of the appropriate variant determines the change of the price and the displayed picture.
A sitemap is a list of URLs that we want to point to the web crawlers. A sitemap helps search engines to index the page correctly and faster. It affects the positioning of the site in searches. This form of communication with the search engine informs which subpages are important and which are less.
With a developer employed at SoftwareSupp, the client carried out various tasks, commissioning them day by day, depending on the needs. In this project we can clearly see the positive aspect of hiring a specialist by the hour. During we work, the developer had to be changed. The change was carried out smoothly and did not cause any delays in the implementation of the project. It is also worth mentioning that the experts made sure that the new web developer has been properly introduced into the course of the project. There are situations when someone cannot finish the work he has started. It is significant in such moments to immediately arrange a suitable replacement. SoftwareSupp made sure that the client received an equally qualified and certified Shopify developer in order to complete the tasks in the project.
Certified Shopify developer
Salesforce is a platform that offers CRM solutions. It is one of the most frequently chosen systems, currently used by over 150,000 companies. According to the data collected by Statista, it manages over 19.5% of the revenues in the CRM application market. The main slogan that distinguishes this system is 'no software'. Why? Because the platform works 100% in the cloud. It means that when using it, you do not need any applications or additional tools, but only a web browser and, of course, access to the internet. The code and other data are stored on Salesforce servers, which gives them an advantage in the platform speed.
According to the research conducted by Salesforce, 72% of entrepreneurs running small businesses, despite the pandemic, have a positive view of the future of their company. By this, we can understand that companies want and will develop to adapt to changing economic conditions.
The project concerned the transfer of data from Salesforce to a CSV file in Google Sheet. The assigned freelancer had to know the SOQL language and the methodology of data export.
I need someone extremely good with Salesforce to proceed with Salesforce data export. I would like to move multidimensional data to a CSV file. The data has different formats, hence the need for a specialist. - client
Project time: 5h (consultation and solution design)
40h is an estimated time for writing scripts and conducting tests to complete the salesforce data export in the required format.
Effect: Designing a salesforce data export solution in the form of Account-Contact - Cases - Notes in order to create a CSV file that will be useful during data import to a new system.
The client was moving his internal system to a new platform, and for that, he needed the Salesforce data export to be conducted in an organized way. The records had to be pulled out of Salesforce and stored in an Excel sheet. CSV files created can directly be used by the new system to import the records.
I have a total experience of five years as a Salesforce developer and worked on multiple projects with companies from various industries. For instance, I have worked on projects related to a legacy system. My job was to move the records from production to the new software and decommission the old one. I have expertise in Salesforce Apex Scripting, Automation, and Data export projects.
The project required proficiency in the use of the Salesforce platform but also experience in data management. As already described by a data management specialist, data migration requires extreme care and attention to detail.
The biggest challenge in this project was meeting the client's requirements in terms of data structure and communication concerning understanding the value of specific information. My experience in a data export, combined with knowledge of Salesforce, enabled me to design export solutions for this company.
As the client is moving his database from a Salesforce to a new CRM, they wanted to capture the records thoughtfully so related contacts and notes can be carried all in one go. We have designed a solution so that information of the Account will have all the cases linked along with the notes attached. The overall goal is to get the connected data in Excel.
Structure of data exported:
Account - Contacts - Cases - Notes
The project was quite challenging as we were operating with multiple objects such as Account - Contacts - Cases - Notes. Working on multidimensional data requires an appropriate action plan. The difficulty was to design a solution that would enable Salesforce data export in a form that would correspond to the required fields of the new system. To get all the records, we could not use the data export tool because of multiple objects. The complexity of the data forces us to write scripts. Apex classes need to be written to capture the results in CSV. After creating a solution, many rounds of testing have to be done. This process has been prepared to verify that none of the information and no field had been omitted.
The major problem is that an Account can have multiple Cases. Each Case has many fields which need to be captured. Each Case has numerous notes attached, and it also should be transferred in an organized format. So linking all the Accounts with their Cases and Notes- thousands of positions could be a time-consuming task.
The client had 3271 accounts, which included 1176 cases. 773 of the cases contained 5026 notes.
In short, it can be assumed that the manual process of data transfer would be as follows:
Transfer of accounts without cases (3271-1176 = 2095 accounts) 2095 accounts x 1 m = 2095 minutes: 60 m = 35 h
Transfer of accounts with cases but without notes (1176-773 = 403)
403 accounts x 2 m = 806 minutes: 60 m= 13.5 hours
Transfer of accounts with cases and with notes 773 x 3 minutes = 2319 minutes: 60m = 37h
The total Salesforce data export done manually to a CSV file could take 35h + 13.5h + 37h = 85.5h
Additionally, we should include the spent time to check the correction of transferred data and the possibility of human error. It is highly probable that some mistakes may appear if you order such a task to be done manually by one person within 85 hours of work - it is almost 11 days of continuous work on one task. Data export performed by the designed developer solution would not only take less time but would also be 100% correct.
Implementation of a software solution would accelerate Salesforce data export by 50% compared to manual data transfer.
The customer was unaware of the difficulties of data portability. It is a common problem and requires proper communication. It is worth providing a comprehensive explanation to the client of project complexity and necessary steps. In this case, the problem of multidimensionality needed to be clarified.- Salesforce data export specialist
Within the five working hours of the project, I have analyzed the objects and created a Sample CSV of one single record. This file presented an initial form of saving information, matching data to appropriate tables. Then, the prepared CSV file has been sent to the client for approval. After the analysis, it turned out that the data could not be transferred using the available exporting tools. This Salesforce data export project requires the appropriate script. It means much more work than expected. Scriptwriting, test execution, and data export were estimated at 40 hours of salesforce developer work.
As the aim of the project was to develop a well-conceived data transfer solution rather than a manual process, we used the Workbench tool. For maintaining the connection between the Account - Cases - Notes, we have used apex classes to fetch the records using multiple SOQL statements to capture the data in CSV format.
Workbench is a visual database design tool. It was used to transfer Account and Cases into a CSV. Whereas Salesforce developer made use of VS Code for scripting to recognize which linked records can be exported. This stage of work was crucial due to the analyzed conclusions. The results of the scripting performed showed not all data can be transferred in the same way. VS code stands for Visual Studio Code. It is Microsoft source-code editor with a multi-language syntax highlighting option. In 2018, it was recognized as the most popular software development tool.
1. Performing the analysis of the transferred data
2. Using VS to check which data can be transferred
3. Application of a workbench tool to transfer data to CSV
4. Create a sample CSV file
5. Consultation with the client and presentation of the designed solution
In summary, open communication with the client and adapting the form of presenting the stages of work are essential in this type of project. It very often happens that a project requires much more complex solutions than it was initially assumed.
The Project board enables transparent communication between the freelancer and the client. The project manager also has access to the project board to control the course of cooperation so that the client receives all the necessary information. The image above shows a detailed description of the situation analyzed by the salesforce developer.
Certified Salesforce Freelancer
UTM (Urchin Tracking Module) indicate what marketing activities generate traffic on the website. Following the principle that a campaign based on the researched effects is a converting campaign. Wisely using the knowledge acquired from indicators helps plan campaigns properly to potential customers' requirements interested in our products or services.
UTM is an indicator used to measure the effectiveness of a campaign. It is a parameter added to the URL that checks the origin of the traffic on the website. The implementation of UTM parameters makes it possible to obtain a large amount of detail about the visitor. Urchin Tracking Module consists of five identifiers:
The use of the indicator during social media marketing campaigns shows the effectiveness of the posts. In short, it informs you which of the published content generated a new lead on our website. With using Urchin Tracking Module acquiring new customers is easier because it allows us to react appropriately to their presence.
As 33Across research published by Yahoo indicate: as much as 82% of the provided content is shared via copy & paste. Among the materials distributed, there were texts, pictures, and URLs. During this research, the impact of information sharing on website traffic was examined. By implementing UTM, you can check where the traffic is coming from on your website, maybe some users copy and paste content on Instagram or Facebook, and thanks to this, you can observe traffic increases.
In the initial part of the project, we have effectively implemented a CRM system from scratch and provided ongoing support for technological development. This client is an example of a regular customer. The cooperation began with the implementation and customization of Pipedrive. After it finished, a customer began to report new tasks to us.
Projects second phase scope:
Effect: Refining the implemented Pipedrive system to meet additional customer requirements and developing a traffic tracking solution based on UTM parameters.
Project time: 20h
Client: A company that offers online programming courses.
The difficulty for the client was to create a solution that would extract information about the source of incoming traffic. A strong emphasis was placed on creating a clear, short-form that include several details such as the source of the traffic, the name of the marketing campaign, etc. - Jarosław Danielak
Jarek is a web developer who is working daily with web applications and the .NET backend. He was responsible for UTM solution development. On the other hand, Paweł was a project manager engaged to contact the client and determine the project's scope.
One of the fascinating challenges was to code a large amount of information in a short form of a 16-character tag. With the client, we have developed a solution that makes it quite legible. Details of the developed method based on UTM parameters are described in this article. - Jarosław Danielak
In order to introduce and outline the topic of the article, I present an example of a tag, based on UTM parameters:
Campaign: Free Java lessons
- Facebook flow corrections
- CF7 -＞ CRM flow change
- Leads management and leads analysis: webinars, Vocare, Callcenter
- Zapier for SalesManago and tags
- CRM support
- Development of a Script saving UTM to local storage
- UTM documentation
In other words, the presented solution collects information about the source of traffic coming to the website based on UTM parameters contained in the query string or the domain from which the redirection was made. The collected information is saved in the form of a short tag, which is sent to Zapier together with the Contact Forms (course scopes, contact details, etc.) and the competency test in Zoho Forms.
When the URL contains parameters such as utm_source, utm_medium, and utm_compaing, the tag consists of:
XXYYZ ... Z, where:
- XX: utm_source parameter (interpreted by the dictionary below). If the value is not contained in the dictionary, parameter is translated as its first letter and the following consonant (TikTok -> TK)
- YY: the value of the utm_medium parameter (interpreted by the dictionary below). If the value is not in the dictionary, it is translated as its first letter and following vowel.
- Z… Z: utm_campaign parameter: value devoid of special characters and cut short to the first letters of the words
Special cases. If there is no UTM information in the URL, the tag will be set to:
- DIRECT, if the user has entered the website directly, by entering the address or selecting the page from the tabs,
- ORGANIC, if the user entered the page through a Google search result,
- RF + the first 14 characters of the redirected domain, if the user visits the page from a link on another website.
Visiting the website through an article on Onet.pl will generate the tag:
Adding hidden fields to forms
WordPress Contact Forms: For each form that is to pass UTM information to Zapier, two hidden fields have to be added, named utm0 and utm1: [hidden utm0] [hidden utm1]
Adding a script to WordPress
The script from the out/UTM-parser.js file from the repository should be used with a plug that allows modifying the <head> tag in the WordPress HTML structure.
1. Install and activate Plug Headers and Footers by WPBeginner (or another plug with the same functionality). https://wordpress.org/plugins/insert-headers and-footers /
2. Copy the entire script from out/UTM-parser.js in the repository.
3. In the plugin settings in the WP admin panel, in the Scripts in Header field, paste the entire copied script, enclosed in the <script> tag.
<script> [file content out / utm-parser.js] </script>
4. Save your changes.
This part of the project consisted of three tasks:
2. Design hidden fields in forms on the WordPress website and create a script that will send the previously generated tag together with the form. A script has been injected into WordPress, which adds tags to specially prepared fields in contact forms.
3. Implementation. After testing the complete solution in the client's test environment, the whole solution was implemented in the production environment. The implementation consisted in injecting the script using a plug-in and adding hidden fields in the Contact Forms configuration.
The client left a great deal of freedom in planning the work. Weekly status meetings were a regular part of my work. However, I was free to divide the entire project into tasks and manage them flexibly- Jarosław Danielak
The project was carried out for our regular client. They took advantage of the possibility of implementing the project by several freelancers. The company hired Paweł- project manager, and Jarek, who implemented the main scope task: implementation of UTM parameters. Freelancers have been selected so that their skills complement each other. Experts with the client's employees created a team to fulfill all assigned tasks. Freelancers worked on one project board, where the client had access to transparent information on the project progress. Additionally, the customer had the opportunity to stay in touch with the freelancers employed via the built-in communicator.
Certified Web developer
Few words about the client
Our client is the Director of Global Sales at a company that offers contract research services to pharmaceutical, biotech, start-up, and academic researchers who need faster, smarter, and cost-effective solutions for drug profiling.
Scope of the project
As a regular customer, he approached us for database design to manage his LinkedIn contacts in an easy way.
Duration of the project
The project was implemented within 1 man-day across one week of agile collaboration with the customer over the entire lifecycle of solution design, implementation, and testing.
Effect: LinkedIn contacts export to Google Sheets integrated with Zapier’s chrome plugin.
Thanks to this implementation, the client can manage the data of his clients much more efficiently. Creating an automated list of people interested in its services helps in faster service and additionally increases the quality of connections. Orderly and systematic activities are essential when building a long-term relationship.
Over the course of my career, I have implemented a large number of databases and integrations of databases with external IT systems, especially around CRM and across the customer journey. For SoftwareSupp for example, I completed a data analytics project using Pipedrive and its dashboard capabilities to set up a management sales cockpit for a green energy start-up.
For this project, the following skills were essential
The initial stage of the project required understanding the client's needs and the expected end-results in combination with the workflows that the client was willing to conduct when operatively filling the database during his daily work.
LinkedIn has been considered as one of the most effective social media for B2B lead generation. According to the information published by Linedlin, 80% of social media B2B leads come from LinkedIn.
During the solution design phase of the project, the following key requirements of the client were elaborated
Based on these requirements, three basic solution-designs were evaluated
We discussed with the client the respective solution designs and mapped these against the client’s requirements and decided for solution 2, a combination of Zapier’s free basic product and a google spreadsheet.
As a general rule, the main project's challenge was the proper identification of the client's needs and direct cooperation. My knowledge and experience allowed me to offer the client three different solutions. During database design, setting the appropriate structure of the uploaded information from the beginning is crucial. Thus, the client can correctly and with ease add consecutive database fields by himself.
By hiring a specialist for Linkedin contacts export, the client saved the whole day of monotonous and manual work. Moreover, the implemented automation will enable the customer to export contacts in the future independently.
Assuming that 1000 contacts were transferred through Zapier automatically, and manual copying of information would take at least 30 sec/contact, it turns out that the client saved over 8 hours of work. This number of hours saved will systematically grow with the transfer of new LinkedIn business contacts.
The implementation of the LinkedIn database consisted of the following steps
The data transfer from the Google Chrome browser to the Google Spreadsheet was implemented as a Zap using Zapier’s Chrome extension which was connected to a google sheets tab containing the data structure of the LinkedIn contacts.
After implementation, the solution was tested with various datasets by the expert and by the client and smaller corrections in the data structure were implemented and tested. Finally, the solution was handed to the client and the client was trained on how to operate and also modify the solution in case additional requirements would come up.
The developed solution allows the client to capture his LinkedIn contacts from a browser, enrich these with additional data manually and immediately transfer the data into a google sheets database. This database can be further enhanced, sorted, filtered, and then also be uploaded into CRM systems like Pipedrive, Salesforce, or Hubspot to further process the LinkedIn contacts export. The solution design developed in this project has the following advantages
The client for whom this project was carried out already took advantage of SoftwareSupp certified freelancers services before. This article briefly describes the work on integrating Pipedrive with Pandadoc. Customer satisfaction about the first project contributed to re-login at SoftwareSupp after a year to improve subsequent internal processes. SoftwareSupp is a platform where you can hire certified freelancers on-demand, hourly, or complete a project. You can request professional software support depending on your needs.
Certified CRM Expert