Programming Projects: Python and REST APIs

The main goal for this project is to create a date loader to synchronize inventory and pricing data from suppliers to an ecommerce store. We're looking for students with solid  experience in one or more of the following technology areas  to tackle technology projects on our list of priorities: Python Graph QL and/or REST API Integrations You bring solid technical experience and enthusiasm to code business solutions.  We'll help you  build your portfolio of coding accomplishments  to talk about in future interviews. . We have a pending list of programing projects that we want done and will match candidates to a subset of the following priority projects. FINAL DELIVERABLES The final deliverable will be a program that: executes daily to intake refreshed data from our suppliers does some price and costing calculations and validation on each product line loads the resulting data into our eCommerce store. The program should be documented with in-line comments for easy maintenance together with a one-page overview.. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams, Zoom or other preferred platforms. Timely meeting access and response to questions will be provided, including by text, or on-line communication tools. What tasks will students need to complete to achieve the project goal? The project can be done in teams or broken into individual sub-projects tailored to student interest and aptitude:

Programming Projects: Python, SOLR, REACT, GraphQL/REST APIs

Positions Available: 5 Students We're looking for students with solid experience in one or more of the following technology areas to tackle technology projects on our list of priorities: Python SOLR & SQL Databases Beautiful Soup Graph QL and/or REST API Integrations You bring solid technical experience and enthusiasm to code business solutions. We'll help you build your portfolio of coding accomplishments to talk about in future interviews. . We have a pending list of programing projects that we want done and will match candidates to a subset of the following priority projects. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams, Zoom or other preferred platforms. Timely meeting access and response to questions will be provided, including by text, or on-line communication tools.

Accounting for Small Business - Quickbooks Online - Level UP

What is the main goal for the project? We require a student to bring our online accounting records up to date. This project will give students excellent experience at financial accounting for a small business. This is an 80-hour placement. What tasks will students need to complete to achieve the project goal? Some Transaction Data Entry or update Set up of Recurring Transactions within Quickbooks to save future data entry Bank and Credit Card Processing Account Reconciliation Assist in preparing HST/GST and Provincial Tax Return Data Adjustments to bring books to trial balance for accountant How will you support students in completing the project? We will provide access to all documentation of all transactions and access to our online accounting platform What skills or technologies will help students to complete the project? We use Quickbooks Online. Student should have good understanding of accounting processes and be able to efficiently and correctly complete reconciliations.

Marketing - Influencer & Partnership Business Development -- Level UP

Up To 4 Students The goal of this project is to develop A/B test and improve our influencer marketing and partnership development model. This project is well suited to students wanting to add Business Development/Influencer Marketing to their resume and explore the world of influencer marketing, entrepreneurship and business development.

Website Graphic Images and Website Improvement -Build Your Portfolio - Level UP

3 Positions Available This project will involve updating our website ( https://werrv.ca/ ) to maximize SEO, UX and customer conversions. Project scope will be adapted to applicants' interests and aptitude. but can include one or more of: High Quality graphic home page, collection images and landing page focal points Website layout optimization and navigation Search Engine Optimization (SEO) Small website improvements (CSS/HTML/Liquid) Our mission is to help people enjoy their best life while experiencing the great outdoors - We have some ideas for creative, highly sharable content aligned to our mission and we're looking for students with experience and passion in video creation to help bring it to life. Applicants with a strong interest in Camping and the Outdoors will really enjoy the subject matter. If you love video content and are an aspiring Online Influencer, this project will be a great match.

Blogging about Boating or RVing (Camping) - Build Your Portfolio - Level UP

6 Positions Available This project will involve creation of Blog Posts about Camping, Outdoor, Boating and/or Recreational Vehicles (RVs). You will be able to refer to your work in your resumes/portfolios, so you can build a great portfolio while doing this project. Our mission is to help people enjoy their best life while experiencing the great outdoors - We have some ideas for creative, highly sharable content aligned to our mission and we're looking for students with experience and passion in video creation to help bring it to life. Applicants with a strong interest in Camping and the Outdoors will really enjoy the subject matter. If you love the outdoors and are an aspiring Online Influencer, this project will be a great match.

Marketing Internship (eCommerce Website SEO - Ubersuggest) Level UP

1) On-Boarding and Training - Gain familiarity with the context (company strategy and goals, competitive landscape, industry trends) and update the competitive analysis to reflect recent changes. 2) Behavioral Assessment – Interns will be given access to Werrv's management tools to analyze customer behavioral patterns and identify opportunities to improve conversion rates (CRO) and critique our advertisement campaign focus. Based on recommendations, interns will be given an opportunity to test hypothesize to improve results through A/B testing of content, preparing customer online surveys and other means. 3) SEO Improvement Plan - Review Werrv's existing SEO Improvement Plan for both Domain Authority and Page Authority which will be shared with Interns. Interns will be involved in executing SEO improvements, including content creation in the form of blog posts, buyers guides and SEO meta tags for Collections.

Programming Projects: Python, Liquid/CSS/HTML, VBA, APIs - Level UP

12 Positions Available We're looking for students with solid experience in one or more of the following technology areas to tackle technology projects on our list of priorities: Python Liquid/CSS/HTML Visual Basic (VBA/ Advanced Excel Formulas/Marcos) Graph QL and/or REST API Integrations You bring solid technical experience and enthusiasm to code business solutions. We'll help you build your portfolio of coding accomplishments to talk about in future interviews. We have a pending list of interesting programing projects that we want done and will match candidates to a subset of the following priority projects.

Short 60 Second Video Creation - YouTube Shorts & TikTok - Level UP

This project will involve creation of short form Video Content (typically 30 to 60 seconds each) suitable for TikTok, YouTube Shorts and Instagram Reels. Our mission is to help people enjoy their best life while experiencing the great outdoors - We have some ideas for creative, highly sharable content aligned to our mission and we're looking for students with experience and passion in video creation to help bring it to life. Applicants with a strong interest in Camping and the Outdoors will really enjoy the subject matter. If you love video content and are an aspiring Online Influencer, this project will be a great match.

Level UP - Programming Projects:: Python, VBA, GraphQL/REST APIs

Positions Available: 4 Students We're looking for students with solid experience in one or more of the following technology areas to tackle technology projects on our list of priorities: Python Visual Basic (VBA/Excel) Graph QL and/or REST API Integrations Microsoft Power Automate You bring solid technical experience and enthusiasm to code business solutions. We'll help you build your portfolio of coding accomplishments to talk about in future interviews. . We have a pending list of programing projects that we want done and will match candidates to a subset of the following priority projects. Individual Projects 1) A REST API integration between Shopify and our accounting system to create commercial invoices for international orders. 2) An update to our existing GraphQL API integration between WordPress and Shopify. 3) A REST API integration between WordPress and one of our commercial suppliers. 4) An API integration between our supply chain system and Shopify. 5) A Product information analyzer and parser in VBA/Excel. 6) Several Power Automate ( https://powerautomate.microsoft.com/en-ca/ ) routines to automate tacks like shipment tracking , order processing and other tasks. 7) A stand alone website and database to gather and display information about brand consolidation in the industry. Our website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams, Zoom or other preferred platforms. Timely meeting access and response to questions will be provided, including by text, or on-line communication tools.

Blog Writing About Outdoors /Camping/Boating/RVs - Level Up

Positions Available: 4 Students We are looking for students with strong writing skills and an interest in blogging about the outdoors, camping, recreational vehicles and boating. Project Scope Blog Content Prioritization Agree a list of topics to blog about. Key considerations will include: Relevance to Werrv's business and customer interests ( outdoors, camping, recreational vehicles and boating. ) Uniqueness/ Interesting / Topical - There's already a blog post for everything - a unique spin or current update help make the blog interesting. The author's interests and experience. SEO Friendly - we use Yoast ( https://yoast.com/ ) to help ensure our content is focused and easily readable. Promotional - where appropriate, and while remaining tasteful, the content should cross reference relevant store products. Reusable - if the blog content can be posted in small parts to social media posts on Facebook, etc. great. Research and Creation - Approximately 800 word length, Estimate about 4 hours per post, or 20 posts for 80 hours of effort (negotiable) Calendar & Posting – Work with Werrv to position the Blog Post in the schedule. Our website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams, Zoom or other preferred platforms. Timely meeting access and response to questions will be provided, including by text, or on-line communication tools.

Website Refresh & Digital Graphic Content

We have a range of creative projects on our wish list and we're looking to work with creative and ambitious students to reimagine our website presentation and optimize customer engagement and conversion rates. This will involve reviewing customer experience based on actual website data and our customer insights from Lucky Orange and brainstorming optimization techniques and producing relevant, engaging video and graphic content to raise the bar even higher at our website and social media channels. We are modern, ambitious, entrepreneurial and we already employ industry leading marketing tools that you will have a chance to work with during your project Shopify, Klaviyo, Lucky Orange, etc.). Our core business at Werrv ( https://werrv.ca/ ) is selling parts and accessories to Recreational Vehicle (RV) and Boat owners, but don't think it's boring - we are different. We're even on Tik Tok now... Bonus if you're interested in #vanlife . Website redesign should endeavor to use supportable features already available but underutilized. Content may be in the form of Infographics, Videos, Animation, 3D product models and a wide range of Graphic Assets. We are looking for a high quality of content aligned to our brand and helping our customers to make informed buying decisions with a comfortable customer experience. Students may also be able to develop advertising messages and A/B test the results of various content in real time during the project to confirm the optimal fit for our customers. Project Scope 1) Onboarding - We'll share our knowledge - Gain familiarity with our context, including: company goals, competitive landscape, industry trends, our industry leading tools and our content priorities. 2) Prioritize – We'll work together to shortlist a list of recommended website improvements and content from our long list of content priorities considering strategic value, your aptitude and interests, potential level of engagement with our customers, ease of curation/creation from reliable sources, and relevance to target customer personas. We'll categorize by channel/type of content. 3) Optimize Website / Create/Curate Content – Develop the content pieces identified above (written, graphic, video, infographic depending on your area of focus) and recommend a calendar/sequence of release dates for social media channel based content. 4) Live Analysis and Strategy Refinement – As a bonus, there is the opportunity for students to get live feedback/observation of their work based on A/B testing and, for Blog Post items on the Werrv Website we have the "Lucky Orange" App that allows us to replay users' actual interaction with website content, noting things like how quickly they scrolled though content, where they clicked, etc. and the ability to post surveys and gain user feedback. Our website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams, Zoom or other preferred platforms. Timely meeting access and response to questions will be provided, including by text, or on-line communication tools.

APPLY MAR 3 - LEVEL UP -- Build Your Amazing Portfolio - Video & Graphic Content

Positions Available: 5 Students Any combination of: Graphic Arts and/or Video/Animation Creation and/or Solid Experience in building solid organic presence on Pinterest, Instagram, Tik Tok We want amazing content and you want an amazing portfolio of work you can share at your future interviews - we have a match ... We have a range of creative projects on our wish list and we're looking to work with creative and ambitious students to produce relevant, engaging blog, video and graphic content for our website and social media channels. We are modern, ambitious, entrepreneurial and we already employ industry leading marketing tools that you will have a chance to work with during your project Shopify, Klaviyo, Lucky Orange, etc.). Our core business at Werrv ( https://werrv.ca/ ) is selling parts and accessories to Recreational Vehicle (RV) and Boat owners, but don't think it's boring - we are different. We're even on Tik Tok now... Bonus if you're interested in #vanlife . Content may be in the form of short form social media posts, Infographics, Videos, Animation, 3D product models and a wide range of Graphic Assets. We are looking for a high quality of content aligned to our brand and helping our customers to make informed buying decisions with a comfortable customer experience. Students may also be able to develop advertising messages and A/B test the results of various content in real time during the project to confirm the optimal fit for our customers. Project Scope 1) Onboarding - We'll share our knowledge - Gain familiarity with our context, including: company goals, competitive landscape, industry trends, our industry leading tools and our content priorities. 2) Prioritize – We'll work together to shortlist from our long list of content priorities considering strategic value, your aptitude and interests, potential level of engagement with our customers, ease of curation/creation from reliable sources, and relevance to target customer personas. We'll categorize by channel/type of content. 3) Create/Curate Content – Develop the content pieces identified above (graphic, video, infographic depending on your area of focus) and recommend a calendar/sequence of release dates for social media channel based content. 4) Live Analysis and Strategy Refinement – As a bonus, there is the opportunity for students to get live feedback/observation of their work based on A/B testing and, we have the "Lucky Orange" App that allows us to replay users' actual interaction with website content, noting things like how quickly they scrolled though content, where they clicked, etc. and the ability to post surveys and gain user feedback. Our website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams, Zoom or other preferred platforms. Timely meeting access and response to questions will be provided, including by text, or on-line communication tools.

Marketing - Competitor and Market Analysis

Project Scope 1) On-Boarding and Context Setting - Gain familiarity with the context (company strategy and goals, competitive landscape, industry trends). Subject to a non-disclosure agreement, team members will be given a number of resources, including a high-level internal competitor analysis prepared in 2020, Werrv's customer behavior and survey platform ( https://www.luckyorange.com/ ) and Werrv's Social Media Strategy. Other resources will be provided as required. 2) Competitor and Market Assessment - Scan the market to shortlist leading competitors and perform an in-depth analysis of their marketing strategies, including brand positioning, key messages, advertising focus, appeals, social media presence, affiliate/influencer support, etc. ; If applicable, research beyond direct retail competitors to identify brand messages and appeals used by leading product manufacturers that may help to identify and validate winning strategies. 3) Assessment of Consumer Interest - For the major Customer Personas, identify interest, conversion drivers and appeals that most influence purchasing decisions and brand affinity: Retirees – Empty nesters who are still active, enjoying nature and travel; includes snowbirds who head south during the coldest months of the year. Lifetime RVers – Dedicated campers and boaters who are passionate about the lifestyle and spend some portion of every year in their RV. This includes seasonal site campers who leave their unit parked at a trailer park/campground long term. Families – Families with children who spend some of their vacations and seasonal weekends every year in their RV – some travel, some stay at a favorite site/park. Millennials & Centennials – A wide range of personas from those with families who have more in common with the group above, to “Van Life” advocates. This group is a meaningful and growing segment. 4) Werrv Assessment and Opportunities Identification - Evaluate Werrv's current brand positioning, advertising, social media and identify opportunities to appeal to customers and differentiate it's brand in the marketplace. The Team may be able to engage retail customers virtually in on-line surveys, A/B testing and behavioral observation by testing messages and validating appeals through Werrv's survey platform. 5) Final Deliverables include: Identify where competitors' product or service offerings are positioned to meets the needs of customers Who are the competitors to watch and An analysis of advertisements, web site information and any promotional materials that support the brands. An overview of how each brand uses consumer appeals Specific recommendations on ways to effectively appeal to consumers and/or gain competitive advantage against competitors supported by consumer-based insights. Our retail website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams, Zoom or other preferred platforms. Timely meeting access and response to questions will be provided, including by text, or on-line communication tools.

Accounting Internship - CFO-like Experience in a Cash-Flow-Positive Startup

Positions Available: 1 Background Werrv ( https://werrv.ca/ ) is a start-up, incorporated in January 2021, with quarterly HST filings and a first fiscal year-end of of December 31, 2021. We have come a long way in 9 months, signing suppliers, creating an on-line store, offering a targeted set of products in the recreationally vehicle industry, attracting over 25,000 visitors to date and selling in the $10's of thousands of dollars in the past few months. We have ambitious plans, which can only be shared with successful finalists under an NDA, for obvious reasons. We sell on-line using Shopify (the world leader in on-line sales platforms at over 5% of the internet). Our accounting system is Quickbooks (Multi-currency) on-line (the most common accounting system for growing businesses). We have commercial contracts in place with some of North America's largest manufacturers, distributors, shippers and suppliers, so naturally, we have a lot of transactions. More than 95% of our transactions are automated under processing rules, but we still have 5% that need some TLC. Our books are in good shape, but, they need a solid review, we have quarterly sales taxes to file, and we are growing our business in the USA. This internship provides a unique opportunity to work with the founder, experience entrepreneurship from the front seat, gain a "whole company" view of an organization from Shareholder Accounting to supplier agreements compliance, to best-practice automation of routine transactions and, when that is all humming even better, the chance to be part of a very exciting new growth opportunity. Fun - yup; Reference building - hell ya;; A chance to position yourself for future global domination --- absolutely. Project Scope ( the bullet point summary) Review and Assess Accounting Current State - recommend any updates to Chart of Account, Rules, etc. Improve automation rules if applicable Review sales tax attribution and participate in quarterly tax filing Review and recommend updates to Shareholder Accounting, if Applicable Reconcile Accounts Monthly Participate in review of US tax accounting and reporting as part of US expansion Identify and execute Management Accounting for Shipping and other core areas of management interest. Experiment with customs self-declaration for cross-border transactions. MORE (But, we can't tell you unless you are under NDA 😊 ) This is a great assignment for an ambitious student (or small team) with solid accounting skills who wants a real-world referenceable project to practice full oversight of accounting in a North American context so they can take a more senior role in a fast growing start-up, be part of a n new entrepreneurial venture or provide accounting services to a large group of clients in on-line sales (a huge market). More details will be provided to shortlisted applicants.

Administrative Excellence Internship (Marketing)

Positions Available: 1-4 Students, individually or as a team Project Scope (Can be Adjusted Based on Individual Learning Objectives) 1) On-Boarding - Participate in initial presentation to gain familiarity with the context (company strategy and goals, competitive landscape, industry trends). Review initial assignment and ask questions to ensure objectives are well understood. 3) Marketing Improvement Plan - Werrv is an authorized dealer for over 200 product brands, but, we have not consistently registered our dealership alliances with all of our suppliers. Interns will be given a list of key manufacturers and will execute an outreach program to have Werrv added as a registered dealer on manufacturer's websites and internal dealer lists. In most cases, this can be achieved by researching the manufacturer's website, determining if Werrv is already listed in the Dealer directory, if Werrv isn't listed or the listing needs updating, then finding the Contact e-mail and e-mailing the manufacturer with listing information. The intern will be welcome to try different messages, trying phone call in place of e-mail if they prefer, or using other techniques to persuade manufacturers to complete the addition in a timely manner. (Key Business Skills Learned: Project Management, Organization and Tracking of Status/Results, Influence and Persuasion, as required to make it a priority, Business judgement and inquiry (if a Manufacturer requires additional information), Teamwork and process improvement through innovating the workflow. Having fun at work, Handover/opalization (at the end of the project, turn over a spreadsheet of results, including registrations completed, pending or that may require a follow-up). Interns will be permitted to reference their results, which will be publicly available on the internet in future job references. 4) Social Media – If time permits, and, Social Media is of interest, research the same manufacturer's social media accounts and assess quality and frequency of posts that might be well suited for Werrv to share, re-tweet, etc. Prioritize the best opportunities for Facebook, Instagram, YouTube, Twitter, Linked In, Pinterest and possibly TikTok. If Intern is interested and time permits, the intern may be granted access to Social Media accounts to text/executing their recommendations posting, sharing, re-tweeting, etc. of manufacturer's posts. 4) Other – Depending on interests and learning objectives, Interns may choose to participate in other projects underway at Werrv.

Marketing Improvement Project (SEO, Social Media, Behavioral Analysis)

This project will involve Programming in Python, Accessing APIs from Data Tools like https://dataforseo.com/ and performing data analytics. 1) SEO Analytics - Werrv has an existing SEO Improvement Plan for both Domain Authority and Page Authority which will be shared with Interns. Over the duration of the internship Interns will be involved in executing SEO improvements and assessing results through https://search.google.com/search-console/about and industry leading SEO tools. 4) Social Media – Assess traffic patterns related to similar brands and topics of interest from social media platforms (refer to separate Social Media Strategy document and identify the best opportunities to engage our target audiences. Prioritize the best opportunities for Facebook, Instagram, YouTube, Twitter, Linked In, Pinterest and possibly TikTok. Produce interesting content pieces to improve engagement.

Expand Market Through Spanish, Portuguese and Italian Websites

Positions Available: 1-3 Student We are looking to work with a creative and ambitious student who is fluently bilingual/trilingual with excellent Spanish and Italian language writing skills and solid English language skills to oversee and quality check a project that extends our services at Werrv ( https://werrv.com/ ) to Spanish and Italian and, possibly Portuguese. We already have our website in English and French ( https://werrv.ca/fr ). Our goal is to serve a broader international audience lives at reasonable prices. Relax, the job is not as daunting as you might think, because of our technology solutions, but, it can be very fun and a great learning opportunity.. Project Scope 1) Research - Gain familiarity with the context (company goals, competitive landscape, industry trends) and identify potential translation challenges, if applicable, such as Brand name conventions in key markets. 2) Assessment – Assess optimization around language variants - Spanish, versus Mexican Spanish versus Caribbean Spanish, etc. and recommend which translator to use and implement it in a test store to do quality assurance testing of a sample of translations. Identify and document residual gaps/weaknesses for business risk/impact assessment. 3) Implementation – Subject to satisfactory QA results in test, validation implement the automated translations in the store and oversee the automated translation of all products. Most work will be completed automatically using our existing technology solutions. A primary focus is on final QA sampling of results to ensure overall quality is maintained. Once the store is translated, some additional translation will be required for marketing e-mails and then you will be able to admire your work in action as we take the site live for customers. 4) Bonus - Social Media – Time permitting, implement a French instance of Facebook and Instagram to be maintained on an ongoing basis by the company. Our website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams and other preferred platforms. Timely access and response to questions will be provided, including by text, or on-line communication tools and online meetings.

APPLY MAR 3 - Level Up: Marketing Internship (SEO, Social Media)

Positions Available: 5 Students, individually or as a team working collaboratively Project Scope 1) On-Boarding and Training - Gain familiarity with the context (company strategy and goals, competitive landscape, industry trends) and update the competitive analysis to reflect recent changes. 2) Behavioral Assessment – Interns will be given access to Werrv's management tools (including https://get.luckyorange.com/ , Google Analytics and https://www.klaviyo.com/ to analyze customer behavioral patterns and identify opportunities to improve conversion rates (CRO) and critique our advertisement campaign focus. Based on recommendations, interns will be given an opportunity to test hypothesize to improve results through A/B testing of content, preparing customer online surveys and other means. 3) SEO Improvement Plan - Review Werrv's existing SEO Improvement Plan for both Domain Authority and Page Authority which will be shared with Interns. Over the duration of the internship Interns will be involved in executing SEO improvements, including content creation in the form of blog posts, buyers guides and SEO meta tags for Collections. 4) Social Media – Assess current use and voice of Social media platforms (refer to separate Social Media Strategy document and identify the best opportunities to engage our target audiences. Prioritize the best opportunities for Facebook, Instagram, YouTube, Twitter, Pinterest and most recently, TikTok. Produce interesting content pieces to improve engagement. Our retail website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams, Zoom or other preferred platforms. Timely meeting access and response to questions will be provided, including by text, or on-line communication tools.

Integrate and Transform Supply Chain Data Automatically Phase 2

We are looking to work with a creative and ambitious student or group of students to automate the extract, transform and load (ETL) of our supply chain data from multiple sources. At completion, the result will be automatic ETL of data from our distributors, including inventory and product updates and feeding cleaned data into the backend of our Shopify store. Ideally, the process can be automated so that it runs several times a day automatically. If time permits, merging data with manufacturers data sources will also be done. The work is continuing the work completed in Phase 1. Project Scope 1) Data Mapping – recommended data mapping has already been documented but should be confirmed based on first hand assessment. 2) Development - Using Power Query or suitable mutually agreed alternative, create a robust and supportable ETL program that transforms data and merge it from multiple sources into normalized, high valued information ready for loading into the store. 3) Bonus - The student will be given the opportunity to work with Shopify’s GraphQL API to load the data into the store backend. Our website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams, Zoom or other preferred platforms. Timely meeting access and response to questions will be provided, including by text, or on-line communication tools.

Business Partner Sales Campaign

We are looking to work with creative and ambitious students who would like real-world experience at prospecting clients, conveying a conveying value proposition and A/B testing messaging to improve sales conversion. Werrv is launching an affiliate marketing program, soliciting win-win partnerships with businesses that sell complementary services to our key client demographic. Our goal is to serve all Canadians from coast to coast with products that enhance their lives at reasonable prices. Project Scope 1) Research - Gain familiarity with the context (company goals, competitive landscape, industry trends) using research provided by Werrv and augmenting it with additional research. 2) Ideation – Brainstorming and testing go-to-market messages in real time with on-line survey and A/B test messaging to real prospects through e-mail campaigns and Linked -In. Interested prospects will be guided through an automated workflow to a secure partner portal register as affiliate markets so no direct client contact is required. 3) Prospect Matching – Based on the assessment result, the students will review a list of prospective businesses partners gathered from Scotts Directory, industry contact lists and other sources to target the program. Realtime results can be monitored to confirm that mail campaigns are getting satisfactory conversion and onboarding. 4) Final Report – a brief final (less than 5 pages) report should be provided, summarizing key findings and recommending next steps in enhancing the sales process. Our website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams and other preferred platforms. Timely access and response to questions will be provided, including by text, or on-line communication tools and online meetings.

Level Up - Expand Market Through French Website

Positions Available: 1 Student We are looking to work with a creative and ambitious student who is fluently bilingual with excellent French language writing skills and at least reasonable English language skills to manage a project that extends our services to French speaking Canadians. Our goal is to serve all Canadians from coast to coast with products that enhance their lives at reasonable prices. Project Scope 1) Research - Gain familiarity with the context (company goals, competitive landscape, industry trends). 2) Assessment – Assess Shopify Apps for automated language translation, including, but not limited to, leading contenders like https://apps.shopify.com/content-translation and https://apps.shopify.com/translate-my-store . Recommend which translator to use and implement it in a test store to do quality assurance testing of a sample of translations. Identify and document residual gaps/weaknesses for business risk/impact assessment. 3) Implementation – Subject to satisfactory QA results in test, implement the automated translation software in the store and oversee the automated translation of all products. Most work will be completed automatically, requiring a final sampling of results to ensure QA is maintained. 4) Bonus - Social Media – Time permitting, implement a French instance of Facebook and Instagram to be maintained on an ongoing basis by the company. Our website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams and other preferred platforms. Timely access and response to questions will be provided, including by text, or on-line communication tools and online meetings.

Build a WordPress Secure Client Portal

Positions Available: 1 Student We are looking to work with a creative and ambitious student who has extensive experience with WordPress and wants to try something new. WordPress is an amazing front facing website development environment, but what we want is a Secure Client Portal ( https://wpbuffs.com/wordpress-client-portal-plugins/ ) for our business partners to engage with us in a private way. Uses of the private portal include setting up promotions, exchanging files, displaying private dashboards, accessing content not intended for public presentation, running online training programs and many more secure and private uses. Project Scope 1) Context & Goal Setting – The project is to develop a secure Business-to-Business Client Portal in WordPress to perform a range of functions like those noted above. Specifics are considered business secrets and will be provided at commencement of the project, together with some brainstorming and goal setting. You will play an instrumental role in bringing your WordPress experience to the table and helping to choose the best path forward. 2) Development – set up sandbox, staging and production WordPress environments at the appropriate times. Play in the sandbox to test tool and plug-ins and finalize the optimal configuration to achieve the business goals agreed in step 1. Build a staging environment and work to QA the system with user feedback. Refine and tweak in an agile fashion to implement production grade version 1.0 of the portal. 3) Bonus - If time permits, the student is familiar with Shopify’s GraphQL API, or wants to learn, they may be given the opportunity to work with to load of data into the Werrv store backend. Our website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams, Zoom or other preferred platforms. Timely meeting access and response to questions will be provided, including by text, or on-line communication tools.

Integrate and Transform Supply Chain Data Automatically

Positions Available: 2 Students We are looking to work with a creative and ambitious student or group of students to automate the extract, transform and load (ETL) of our supply chain data from multiple sources. At completion, the result will be automatic ETL of data from our distributors, including inventory and product updates and feeding cleaned data into the backend of our Shopify store. Ideally, the process can be automated so that it runs several times a day automatically. If time permits, merging data with manufacturers data sources will also be done. Project Scope 1) Context Setting - Gain familiarity with the information technology ecosystem of Werrv’s supply chain, specifically including the dataflows from distributors and manufacturers and Werrv’s storefront on Shopify. 2) Data Mapping – recommended data mapping has already been documented but should be confirmed based on first hand assessment. 3) Development - Using Power Query or suitable mutually agreed alternative, create a robust and supportable ETL program that transforms data and merge it from multiple sources into normalized, high valued information ready for loading into the store. 4) Bonus - If time permits, the student will be given the opportunity to work with Shopify’s GraphQL API to load the data into the store backend. Our website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams, Zoom or other preferred platforms. Timely meeting access and response to questions will be provided, including by text, or on-line communication tools.

Communications - Engaging Content Creation and Curation

We are looking to work with creative and ambitious students to create relevant, engaging blog and social media content related to our core business of selling parts and accessories to Recreational Vehicle (RV) and Boat owners. Content may be in the form of Blog Posts, short form social media posts and Infographics. Tools will be funded as required to support creation of unique content. Students may also be able to develop advertising messages and A/B test the results of various ads in real time during the project. Project Scope 1) Research & Initial Strategic Hypothesis - Gain familiarity with the context for a half day (company goals, competitive landscape, industry trends) and the current state and topical issues of content 2) Prioritize – identify a list of topics to develop content around, prioritizing topics of most interest/level of engagement, ease of curation/creation from reliable sources, and relevance to target customer personas. Categorize by channel/type of content. 3) Create/Curate Content – Write content pieces identified above and recommend a calendar/sequence of release dates. 4) Live Analysis and Strategy Refinement – As a bonus, there is the opportunity for students to get live feedback/observation of their work based on A/B testing and, for Blog Post items on the Werrv Website we have the "Lucky Orange" App that allows us to replay users' actual interaction with website content, noting things like how quickly they scrolled though content, where they clicked, etc. and the ability to post surveys and gain user feedback. Our website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams, Zoom or other preferred platforms. Timely meeting access and response to questions will be provided, including by text, or on-line communication tools.

SEO and Social Media Marketing Improvement Plan

Positions Available: 2-3 Students Project Scope 1) Research - Gain familiarity with the context (company goals, competitive landscape, industry trends) 2) Assessment – using SEO tools, current best practices with Google’s latest changes, and assessment of Werrv;’s current website, provide an assessment of strengths and weaknesses of current techniques and recommend most valuable path to improvement to achieve both improved search results and customer satisfaction. 3) SEO Improvement Plan - Over the duration of the project, starting from assessment and working through experimentation, implementation, validation, provide a written plan, including recommended tools to use techniques to targets cost effectively. 4) Social Media – Assess which are the best social media platforms, beyond Facebook to engage our target audiences with prioritization around the best value for effort for Instagram, YouTube, Twitter, Linked In, Pinterest, TikTok and possibly others. Recommend a “voice” and “style” to target key customer personas (see background notes for persona descriptions in the RV industry. Our website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams, Zoom or other preferred platforms. Timely meeting access and response to questions will be provided, including by text, or on-line communication tools.

Brand Identity and Graphic Design

We are looking to work with one or more ambitious, creative student(s) to update our brand style and improve our web presence at werrv.ca, including website graphic design, colour palette and graphic content, as well as alignment of social media properties to the new brand style guide you will create. Project Scope 1) Research - Gain familiarity with the context for 2-4 hours (company goals, competitive landscape, industry trends) 2) Brand Style Guide - Produce a Brand Style Guide (including colour schema) iteratively over the duration of the project, starting from concepts and working through experimentation, implementation, validation to a final Version 1.0 Brand Style Guide and accompanying library of reusable assets. 3) Wordmark - Design a company Wordmark (conveying WERRVs message that “We Are RVs”). 4) Website - Update WERRVs Website (wordmark, complete colour palette, layout, graphic & video assets) to create an attractive, intuitive, fast loading, mission focused, mobile responsive website. 5) Social Media - Create and install brand aligned graphics theme for social media properties – Facebook, Instagram, YouTube, Twitter, Linked In, Pinterest and possibly TokTok? 6) Other Assets - Apply the brand to a PowerPoint template; Apply the brand to an MS-Word template for letterhead, etc. 7) Possible (if time permits) extra graphic assets, such as “Gold, Silver, Bronze award medallions”, IOS and Android App Icons, etc. Our website platform is Shopify and we will give you access to the website and other organizational assets to support this project. Work can be completed remotely and online brainstorming and update meetings can be done via Microsoft Teams, Zoom or other preferred platforms. Timely meeting access and response to questions will be provided, including by text, or on-line communication tools.