Amount to build an app on freelancertrabajos

As your client, I'm in need of someone with outstanding SQL skills to assist me in creating and formatting various SQL queries. The job will involve: - Writing data extraction queries based on specific requirements that I will provide. - Assuring SQL syntax is correct and the formats are professional. - Delivering optimized, efficient queries to extract data smoothly. The ideal candidate for this job will be: - Proficient in SQL and comfortable handling different types of queries, particularly data extraction ones. - Experienced in SQL syntax and formatting, assuring that all work done is up to professional standards. - Capable of writing efficient scripts to ensure the least amount of load on our servers and the fastest possible res...

Need to test one script on shopify website if can work or now

...immersed in the IT field, I'm currently in the market for an expert to develop a chatbot that will aid significantly in streamlining our sales and support processes on WhatsApp. Key Functions: • Efficient Lead Generation & Product Recommendations: In order to drive sales growth, identify prospects effectively and recommend our range of IT products to interested buyers. • Comprehensive Order Tracking: The chatbot must facilitate prompt and accurate updates on customer orders, ensuring an optimal buying experience. • Troubleshooting & FAQ handling: To cater to customer queries, the chatbot should be adept at tackling IT-related troubleshooting issues as well as frequent customer questions. &bu...

I need a comprehensive business plan focused on growth strategy in the services industry. The intent here is to appeal to potential clients, underscoring our unique value proposition and key differentiators. - Understand how our service portfolio addresses client needs and objectives - Work experience in the services sector is critical, preferably in strategic planning - Map out an effective growth strategy, including identifying potential areas for expansion and innovation. - Data-driven approach to highlight market opportunities and business potential. Your task essentially sets the course for our future ventures and client-acquisition efforts. 1. **Executive Summary**: Provide an overview of your business idea, including the mission, goals,...

...specifically targeting small businesses. As an eager go-getter, your core responsibility will be to close leads we provide, ultimately increasing our client base and driving the profits of our agency. Key Responsibilities: - Introduce and sell our social media management services to potential clients - Nurture warm leads and effectively convert them into active clients - Maintain professional relationships with clients Ideal Skills & Experience: - Proven sales or client acquisition experience, ideally within the social media management industry - Excellent interpersonal and negotiation skills - Knowledge and understanding of small businesses and their needs - Ability to consistently meet or exceed sales targets The aim is to introduce our...

*** Please bid only if you are keen to work on a "performance based" renumeration scheme. We do pay on conversion basis only. If you are looking for fixed rate payment, this project is not NOT for you. We are looking for a proficient Google Ads specialist, who is confident to increase conversion... - Responsibilities: * create, optimise, and maintain campaigns on an ongoing basis * research/monitor target keywords * create and monitor KPIs, analyze the performance, make continuous improvements * report results on weekly basis, and get paid based on conversion. - Skills and Experience: * Must have proven track record with Google Ads, specifically with search ads. * Good expertise in SEO and keyword re...

...am seeking the expertise of a software developer who can create a data analysis program to serve my needs. The focus of this program will be to help with the analysis of numerical data that I have gathered from personal research. Your skills and background should ideally include: - Prior experience in similar projects involving data analysis program development. - Strong understanding of numerical data, more specifically, personal research data. - Ability to create a user-friendly interface, that makes the process of analyzing the gathered data straightforward and easy to comprehend. The program should be capable of automating tasks related to data analysis and it should display meaningful outputs to help make informed conclusions. This wi...

Hello, On Our website we have 4 submission box where a person should type information, we need to check that the submission boxes work correctly as one of them sometimes shows numbers instead of letters, I just need a freelancer to type information in those boxes for the first task, thank you

I am seeking a skilled and knowledgeable freelancer to create a comprehensive literature review focused on French Literature. This project does not require focus on any specific aspects such as genre studies, specific authors, or historical periods, allowing you free rein to showcase your expertise as it best applies to the review. The target length of the review is still undecided, which will also be clarified as the project progresses. Ideal Skills: - Proficiency in French language - Experience in literature studies - Strong research skills - Ability to synthesize a large amount of information Experience in French literature is strongly desired for this project. Not only should you have a firm grasp of the language, but an...

I'm in need of a proficient data entry clerk who is experienced in entering data with special characters. - You will process a medium amount of data that's contained in some book chapters and reports. - Currently, the data that needs to be entered is in handwritten documents. Ideal candidate should: - Have experience in alphanumeric data entry. - Be detail-oriented and accurate when reading and entering data. - Be able to decipher handwritten documents and translate them into digital text. Data entry professionals with prior experience with special characters are highly preferred.

...i have already implemented such solution but for a donation website. the idea is to integrate a paypal button so that the buyer can pay directly our single product. all what we want from him is a wallet address and the amount in $ he wants to invest. once the payment is successful, the script should send a notification to a given email address (admin email address). that#s it. I require a proficient coder to integrate the PayPal "Buy Now" button on my single-product HTML5 webpage. This is an excellent opportunity for individuals with experience in PayPal's API and HTML5. Key requirements include: - Successful implementation of the "Buy Now" button that seamlessly processes transactions and keeps the user on...

I'm in need of a talented videographer/animator to support with a short animated video project. I'm looking for a talented video producer/animator who can create a unique and captivating intro and outro for my YouTube channel and Twitch streams. My content focuses primarily on gaming content, particularly Minecraft, but not exclusively. The aim is to create stronger brand loyalty and high recognition value by conveying fun, excitement and a feeling of community and togetherness. Intro concept: The intro should be approx. 10-15 seconds long and contain the following elements: Starting with a gentle fade-in effect from the dark, with my logo, a drawn figure holding a globe, appearing centrally and briefly lighting up. Transition to a dynamic, ever-cha...

NEEDED: Staking pool for existing NFT marketplace on EVM chain Looking for a web3 dev to build a staking pool and implement into the existing NFT marketplace architecture. Several functions of existing modules can be re-used, but it would be necessary to create a new separate smart contract, context file and front-end of the staking pool. Staking mechanism: The token distribution should have a total fix amount (e.g. 1M tokens per month to all participants in total during 1 year) and proportionally given to its participants. Each participant should have the option to "Add Stake", "Remove Stake", "Compound" and "Withdraw Yield".

I'm on the hunt for an expert designer who can help me create a traditional Hindu style magazine template. This is for a specific purpose - to write shlokas. Key Deliverables: - A magazine template respecting a traditional Hindu aesthetic. - The template needs to be designed to accommodate a compact amount of content, ideally fewer than 5 pages of shlokas per edition. The ideal freelancer for this project should: - Have previous experience in magazine template design. - Have a deep understanding or interest in Hindu culture and tradition, which needs to be reflected in the design. - Have the ability to design a template that's not only visually appealing but also easy to read and navigate for the reader. T...

I needs a PHP developer for a 6-month contract to work on a project with fixes and upgrades. I'll plan to pay a fixed monthly amount, starting slightly lower, decreasing significantly, and becoming negligible by the end of the 6 months. Key Responsibilities: - Custom software development with PHP - Concentrate on creating a functional and user-friendly inventory management system Desired Skills & Experience: - Proficiency in PHP development - Experience in developing business software - Understanding of inventory management systems - Ability to collaborate and deliver on a monthly basis - Innovative thinking and problem-solving capabilities This is an incredible opportunity for a developer looking for a recurring project, ...

Looking for an experienced data scraper to extract and compile data from public sources into a designated Excel spreadsheet format. The spreadsheet has 9 columns comprising of information such as Private Lender, Mailing Address, State, Zip, Site Address, Loan Amount, Transaction Date, and Purchase Price. While the source of the data hasn't been specified, it's understood it will come from public databases. Ideal Freelancer: - Extensive experience in web scraping and data extraction from various sources. - Proficiency in Microsoft Excel for the precise structuring and formatting of data. - Attention to detail, ensuring all data points are accurately covered. - Able to handle unspecified data sources. Note: While skills or tools weren�...

I am looking for a proficient developer to design a payment system for the ESP32 microcontroller. The system should allow payment processing via QR code integration. Key Aspects of the Project: • Integration of a payment method with the ESP32 microcontroller - The selected freelancer should ideally have experience with ESP32 or ESP8266(NodeMCU). • QR Code Integration - The payment system should allow for seamless transactions via QR code scanning. • Payment Methods - As a preferred payment gateway, the system should be able to process transactions via Credit cards. Further methods could be discussed. • API and JSON Usage - You should be conversant with using APIs and JSON for the integration process. Preferred Skills: • Experienced wit...

I am looking for an experienced professional to assist in a Windows server to Apache server project. The exact purpose of the project is not specified, hence requires... - Understanding of both Windows and Apache servers for possible tasks including migration, integration or replacement - Ability to suggest and implement the best possible solutions based on the provided scenario Without any specific functionalities outlined initially, the freelancer should still possess skills in... - Hosting websites using Apache - Running web applications on Apache - Apache server's database management There are 2 domains that use ms access to store the sites data, along with asp and asp.net pages. Theses two domains will need moved to...

...urgently in need of an IT specialist with a deep understanding of MYOB AO Classic and AO. Unfortunately, I'm not certain which version I'm currently using, so your ability to work comfortably across multiple versions is essential. My aim is to migrate my existing MYOB AO Classic and AO systems to a cloud-based solution, however, I'm not completely sure how to accomplish this, or even if this would be the best plan for my business. As such, I will value your expertise and guidance. Moreover, the amount of data I need to migrate hasn't been decided, so it is crucial that you can handle any volume of data, from less than a year to multiple years' worth. Key Competences: - Proficient in MYOB AO Classic and ...

I have a delivery site with backend in laravel and frontend in flutter. All was ok until i add a new field on product page that is the field pizza_flavor. After add the pizza_flavor in the delivery site i face this error when i try place the order: [{"errorInfo":["42S22",1054,"Unknown column 'pizza_flavor' in 'field list'"]}]

...seeking a competent freelancer to assist me in setting up XML for advanced payment invoices generated in ERPNext, geared towards ZATCA compliance. My system is already integrated for normal invoices, but requires a seamless transition to encompass advance payment invoices. Important information that I require included in the XML for these invoices are: - Invoice number - Customer details - Item details - Advance payment references, using unique identifiers based on customer details - VAT Calculation and Payable calculation inclusive of the VAT amount in the total payable amount The ideal candidate for this position should have extensive skills and experience in dealing with XML, ERPNext system, and ZATCA compliance requirements. Experience wit...

1. input - 2 fields: front a...front and back of the card. Text and numbers 2. Card shows front. On tap it flips to show the back. Have to be Reverse mode: show back first.(or duplicate cards mode to show front first and back first) 3. Cards shuffle mode 4. After the card flipped there have to be 5 buttons: show in 01min; show in 15 min; in 2hrs; in 1day; in 4 days Card won't show within specified period. 5. Ability to create Folders. 6. Folder have to show: - amount of cards in it. - when studied last time - list of cards with both sides of the cards seen - how many cards ready to study 7. Have to be an option to move cards from one folder to another 8. Cards Upload and download No member are...

Title: Seeking a Freelancer for Guidance and Assistance in Writing a Detailed Business Plan for a Residential Container Housing Project Description: I am in search of a skilled freelancer who can provide expert guidance on structuring and writing a comprehensive business plan for a residential container housing project. I have gathered all the necessary information, and with the help of GPT, I am confident the content creation process will be efficient. However, I need someone to ensure that all critical points required in a business plan are thoroughly addressed. Key Responsibilities: Collaborate with me to understand the project's scope and objectives thoroughly. Guide me through the process of structuring a detailed business plan, ensuring all...

I am in need of a proficient ind...entry tasks and assist me in organizing my Online sales data into an Excel file. Here are the essential project details: - The role primarily revolves around data entry and organization. - The required information to be entered and organized pertains to sales data. - The specific sales data details that need to be entered include the product sold, the sales date, and the sales amount. - An additional critical detail is the conversion of the currency to ILS (Israeli Shekel). The ideal freelancer for this job would have experience with: - Data entry tasks and Excel management. - Familiarity with sales data, specifically within the E-commerce platform. - Currency conversion within Excel or similar ...

**Freelancer Wanted: Laravel Backend Developer** Looking for a skilled freelancer proficient in Laravel to assist with backend changes and feature additions on our job description website. If you have expertise in Laravel and are available for short-term projects, we want to hear from you! Contact us now to discuss further.

I'm currently utilizing Excel 2016 in which I've integrated a substantial amount of customer data. The project requires the expertise of an individual with in-depth knowledge of Excel formula creation. Key responsibilities will include: - Crafting customized Excel formulas to efficiently process and analyze a wide variety of customer data Skillset and Experience: - Proficiency in Excel 2016 is mandatory - Proven experience with crafting Excel formulas - Proficiency in managing customer data effectively and efficiently for better analysis Please note that error fixing and optimization tasks are not part of the project. I solely need you to focus on creating unique and efficient formulas tailored to my needs and dataset.

...can create an interactive point and figure chart for my custom-built website. Here are the key functionalities I'm looking for: - Interactive chart: Users should be able to interact with the chart, dive into data points, and better understand the PNG chart patterns. - Customizable parameters: I want the ability for parameters such as box size and reversal amount to be adjustable. - Real-time data updates: The data feeding the chart will come from a CSV file, which gets updated frequently. I require the chart to reflect any changes in real time. My website is custom-built, so it is important that you're able to work comfortably in this sort of environment. It has been developed in PHP/Laravel so experience with this programming l...

I need 100,000 members in my telegram group can you please do this please as fast as possible make sure to not get the telegram account blocked or the group blocked. You have a limited amount of time. Must be from cryptocurrency groups. I can supply the tool you can use.

Dont ask me how much the budget bid your amount if i send message means your bid is Okay by me. the work should be done maximum 7 days no extended. Check the attachment also User profile update 1. The program should be connected to active Directory (AD) 2. I need similar program on this photo below made on .net latest The program should not be close by alt+F4 or minimize the program can be close only on special key. 3. The program should identify who is the user login to find in AD 4. Account to connect to AD will be added 5. The system should generate CSV/or any file to identify who is the user update there profile with date and time

I'm aiming to greatly improve my professional profile. To do this effectively, I need to complete a substantial quantity of data with LinkedIn profile URLs. - Specific data needed: I need the profile URLs specifically. No other information is required from the LinkedIn profiles. - Quantity: A significant number of profiles are needed. More precisely, the amount is greater than 100. Therefore, I'm looking for a freelancer with experience in data collection and familiarity with LinkedIn as a platform. A keen eye for detail and a high level of accuracy are also crucial for this task.

I'm in need of a proficient Excel expert to design a Point of Sale (POS) system with comprehensive features. These include: 1. Sales Tracking: The system should accurately note each sale's date and time, product names with their respective quantities, as well as the total sale amount and payment method. 2. Inventory Management: Real-time inventory updates are a necessity. I also need the ability to introduce new products into the system. 3. Customer Ledger: This is another essential feature. Ideal candidates should have extensive experience with Excel, have knowledge in POS systems, and understand sales and inventory management systems. It's important that you're detail-oriented and able to adhere to deadlines.

...am looking for a skilled App Developer who is adept at working with both iOS and Android platforms. The service needed is for the creation of a fully-featured, cross-platform application. Key Features: - User Account Creation - Social Media Integration - GPS Integration - Real-time Updates and Messaging - Admin Dashboard - Role-Specific Manager Dashboard Additionally, the app must include the following third-party integrations: - Push Notification Service - GPS - Custom Built Backend (in NodeJS or Golang) Ideal Candidate Skillset: a thorough understanding of app development for both iOS and Android. Familiarity with creating features such as user account creation, social media, and GPS functionalities, as well as incorporating real-time updates and messaging. ...

I'm looking for an expert in mobile app development to create an app focused on simplifying personal savings. The main features of the app should include: 1. Expense Tracking: The app should allow for manual entry of expenses, synchronize with the user's bank account for automatic tracking, and even scan receipts for addition to the expenses under tracking. 2. Goal Setting: The app should enable users to set personalized saving goals. This could be in terms of a specific amount of money or a percentage of their income they aim to save within a certain timeline. 3. Automatic Savings: This feature should automatically calculate the sum to be saved based on the user's se...

...are looking for an Individual Full time Freelancer Sr. Front-End developer having 8+ years of experience to help us with upgrading angular version 11 to angular 16, along with other frontEnd workload. You should know progressive app principles and the rest with knowledge of React.js. Currently we have one Full stack Sr. Developer working on the project from offshore & one Sr. Developer working from onsite. The project will have upto 30 - 40 hours of effort for 1 month to start with. This can go up depending upon the performance. Please you need to be ready to have technical interview and sign the NDA. You should have basic knowledge of JIRA, MSTeams, Git. The Sr. developer will be assigning the tasks to selecte...

I'm looking for a skilled developer to create a trading copying bot for the Binance platform. This bot should be capable of: - Placing buy/sell orders based on the actions of specific traders - Automatically setting appropriate stop loss and take profit levels -The idea is to build a program that allows the user to trade multiple accounts the same way(every account will execute same orders) at the same time ,this way user will trade multiple accounts simultaneously, saving a lot of time. -Program will handle both futures and spot trades(this means it will be possible to use any possible order type available on the exchange , in any available asset,in example,set sell stop loss limit order for a given % amount of a certain asse...

...processes. I just think it would be fun to share them however have no clue how to or use TikTok like at all. I know that there is an audience that loves meat smoking. I was one of them. So I sold everything I had, bought a pretty full on amount of equipment, got a commercial kitchen and by trial and error created a business kind of hidden away from real life lol.. I’m not trying to sell anything, just disprove some theories and share my experience as I smoke a couple hundred kilos of brisket now every week. I have worked in restaurants my whole life, so I understand the importance of being interesting and relevant. I can supply fresh content easily, just need someone to edit, help me upload and tell me what they’d like t...

1. Payments not summing up 2. Amount due not updating or calculating automatically; received amount not showing 3. Modify the booking formula to 20% for the Elegance project only 4. Two buyers are not displaying 5. Set rows limit to 25 only 6. Clients claim not receiving emails sent to them 7. Inconsistency in deal representation across various Zoho accounts 8. Change email addresses containing "chaimaa avenue" as it is a project, not a company email 9. Closing this month not updating; still showing 2020 10. Deals by stage combining all projects 11. Unable to retrieve information for an existing contact while adding new deals for Elegance 12. CRM not sending payment reminders 13. Manual update required for payment information 14. C...

I am in need of a professional who can assist in the design of a steel footbridge intended for a region that experiences harsh winter conditions. The footbridge will need to sustain a moderate amount of foot traffic. Key Skills & Experience Required: - Expertise in civil or structural engineering - Proven experience with steel construction design - Understanding of climate influences (specifically harsh winters) on structural integrity - Ability to optimize for moderate foot traffic conditions Expectations: - Design a structurally sound footbridge made of steel - Ensure the design can withstand harsh winter effects - Optimally manage moderate foot traffic load in your design - Provide detailed drawings, specifications, and cost estimates. Please pro...

...marketing industries. The ideal freelancer for this project should be experienced in: - Full application submission: Completing job applications on my behalf with attention to detail and time efficiency. - Crafting tailored cover letters: Capable of producing engaging, industry-specific cover letters that sell and align my resume with the exact requirements of the job. - Resume Optimization: Able to revamp my existing resume, emphasizing skills and experiences relevant to the target industries and improving its visibility in applicant tracking systems. This task requires a person with excellent written skills and prior experience in recruitment or career consultation. A deep understanding of the mentioned industries will be a significant advantage. No...

...marketing industries. The ideal freelancer for this project should be experienced in: - Full application submission: Completing job applications on my behalf with attention to detail and time efficiency. - Crafting tailored cover letters: Capable of producing engaging, industry-specific cover letters that sell and align my resume with the exact requirements of the job. - Resume Optimization: Able to revamp my existing resume, emphasizing skills and experiences relevant to the target industries and improving its visibility in applicant tracking systems. This task requires a person with excellent written skills and prior experience in recruitment or career consultation. A deep understanding of the mentioned industries will be a significant advantage. No...

I'm looking for a skilled Flutter developer who can convert my Figma UI into Flutter. I only need you to work on the front end. you don't need to work with API or backend logics. I just need it to be an interactive UI. you are free to use any UI tools. please bid the amount you can work with and my budget is 30 euros

...FOR MORE MONEY LATER In this project, I need an organized, detail-oriented freelancer to manually convert data from four disordered xlsx files into a single, clean CSV file with four columns compatible for upload to Xero. What You'll Do: - Extract customer Date, 2 x sales amount columns (Debit & Credit into 1 column), description and Balance from the supplied xlsx files. - Carefully organize extracted data into a well-structured, 4-column CSV output. The workload is small, consisting of a few hundred records. However, there are 2 fields for the amount$. One is Debit and one is Credit, they need to be combined ointo 1 column. Debt needs to be a minus symbol so using brackets will create this in accounting terms (50.00)...

In this project, I need an organized, detail-oriented freelancer to manually convert data from four disordered xlsx files into a single, clean CSV file with four columns compatible for upload to Xero. What You'll Do: - Extract customer information, sales transactions, and inventory items from the supplied xlsx files. - Carefully organize extracted data into a well-structured, 4-column CSV output. The workload is small, consisting of a few hundred records. However, there are 2 fields for the amount$. One is Debit and one is Credit, they need to be combined ointo 1 column. Debt needs to be a minus symbol so using brackets will create this in accounting terms (50.00) will show as... -50.00 on the csv Ideal Skills: - Data entry...

...skilled freelancer to assist with a data entry project. The scope of the project encompasses a variety of data types, and the exact number of entries to be processed will be discussed further with the selected freelancer. This project requires prompt attention and accuracy. **Key Requirements:** - Proficiency in entering textual, numerical, and categorical data - Ability to handle a large volume of records efficiently - Attention to detail to ensure data accuracy **Ideal Candidate:** - Has a strong background in data entry projects - Can provide examples of past work or detailed project proposals - Is available to begin work immediately and can deliver results in a timely manner **Objective:** My goal is to find a reli...

I'm seeking a skilled Excel VBA expert to assist with automating data entry for my business. The main task would involve creating a system for automatic invoice generation based on the amount paid to suppliers. Key Responsibilities: - Develop a VBA script to automate the generation of invoices. - Ensure the system is adequately designed to eliminate manual data input. Ideal Skills and Experience: - Advanced knowledge of Excel VBA. - Proven experience in automating data entry and creating custom functions. - Familiarity with financial data, specifically pertaining to invoicing, is a crucial prerequisite for this job. Please note: This project involves working with sensitive financial data. Therefore, a high level of accuracy and acut...

Are you a passionate and independent Full Stack Developer looking for an opportunity to be part of a new project? I am a serial entrepreneur with a successful track record in the realm of cybersecurity applications and company development. I'm seeking a brilliant, efficient, and success-driven developer to be part of the project he/she develops. What I Offer: Dynamic Participation: Unlike conventional roles, you'll have the unique chance to participate in the app's success, combined with the flexibility of being paid on an hourly or monthly basis, with the addition of success-based incentives. Long-term Commitment: I am looking for someone who is interested in a lasting engagement,. Tech Stack & Skills: Python, DB, Process Que...

...skilled freelancer to assist with a data entry project. The scope of the project encompasses a variety of data types, and the exact number of entries to be processed will be discussed further with the selected freelancer. This project requires prompt attention and accuracy. **Key Requirements:** - Proficiency in entering textual, numerical, and categorical data - Ability to handle a large volume of records efficiently - Attention to detail to ensure data accuracy **Ideal Candidate:** - Has a strong background in data entry projects - Can provide examples of past work or detailed project proposals - Is available to begin work immediately and can deliver results in a timely manner **Objective:** My goal is to find a reli...

I'm in need of an expert PHP developer to craft a complex data query. The project revolves around extracting specific columns from multiple tables (User data tables, Transaction data tables, Customers data tables and Suppliers data table) into a single query. Key Requirements: - Expertise in PHP - Strong experience with SQL and database interactions Brief: I have created four tables named users, customers and suppliers and transactions. In users I have column named uid, name, email, mobile. Here users register themselves for login purpose. In customers table I have column named id, uid, name, mobile, email (here uid is the uid of user who is adding customers and name, mobile, email are the customer’s details). In suppliers table I have column named id, uid...

Need a data entry person to make files i can upload to XERO accounting software easily unfortunately the crap bank, Commonwealth Bank only provides XERO compatible data in CSV format fro 2 yrs I need a data entry person to convert my 4 FILES (ALREADY converted pdf to xlsx files) no w i need the 4 xlsx files into 1 clean CSV file with 4 columns only. DATE. |. AMOUNT. |. DESCRIPTION. |. BALANCE There are 2 columns in the files for AMOUNT if the cost is in the Debit column you will need to add brackets to make it a minus amount eg: $52.17 by adding ($52.17) it will show as -$52.17 both Debit & Credit columns must be combined into 1, Credits don't change but Debits need ( $ amount in brackets) to make m...

...site search functionality on the site (the search icon should be in the header (can be popout or dropdown view). I need an option on the products where they cannot actually purchase the product, instead it prompts them (instead of add to cart) to find a local dealer, screen shot provided. This needs to be done using plugin features (not custom coded).We need to be able to select this as an option as needed (new products launching, etc). I need a way to filter out products that are on sale and page that shows the products on sale. This should look identically to the other product pages just filters only products on sale. PLEASE NOTE: The ENTIRE purpose of this project is to remo...