Data warehouse store procedure copy data sqlроботи

...Converting the existing Android app to a fully functional, native iOS app - Ensuring the iOS version is consistent in its functionality and quality with the Android version - Assistance with publishing the iOS app on the App Store - Any necessary bug fixes or improvements in the process of conversion Ideal skills include: - Strong experience with React Native - Proficiency in iOS app development - Knowledge of Android app development would be a plus - Ability to work with existing codebases - Excellent problem-solving skills and attention to detail - Experience with app store deployments and guidelines. I'm looking for a professional who can deliver a high-quality iOS app that mirrors the current Android app's functionality and quality. Please provide examples...

I'm in need of a skilled CRM Developer to create a custom CRM system with a variety of functionalities and stringent data security measures. Key Functionalities Needed: - Contact Management: The CRM should be able to store and manage client information, including their contact details. - Sales Pipeline Tracking: It should track and monitor the stages of our sales process, helping us identify areas for improvement and potential bottlenecks. - Customer Support Ticketing: The system should provide a platform for our customer support team to manage and resolve client issues efficiently. - Job Sheet Tracking: I also require functionality to track repair/service jobs for various items like phones, PCs, cars, bikes, ACs, etc. Platform and Device Support: - The CRM should be a...

...comprehensive school management software with features like online exams, results management, fee management, and more would require integrating various modules. Here's an outline of how you could structure such a software: User Authentication and Access Control: Allow administrators, teachers, students, and parents to log in with different levels of access. Student Information System (SIS): Store and manage student demographics, academic records, attendance, health information, and conduct records. Teacher/Staff Management: Manage teacher and staff profiles, attendance, timetables, and leave requests. Online Exam Module: Create and manage online exams with customizable parameters (e.g., time limits, question types). Provide tools for question creation, including multip...

I'm looking for an experien...with some pending work on my store. Key Tasks: - Theme Customization: The primary task involves making minor visual tweaks to the store's theme. This includes working on the color scheme, font styles, and button designs. Ideal Candidate: - Proficient in Shopify Theme Customization: Previous experience in customizing Shopify themes is essential. The freelancer should be comfortable working with HTML/CSS and Liquid. - Attention to Detail: The changes required are minor but need to be implemented precisely to maintain the store's aesthetic and functionality. please ping if you are available for 2-3 days to launch it with us the shopify store and working as a freelancer only. ,not company and also ready to work long term , atleast...

I'm in search of a Shopify expert, proficient in troubleshooting ...and I manually enter product details, so I need a professional who can provide a solution to this issue and help boost my product visibility on Google. Key Responsibilities: - Troubleshoot and identify the root cause of the products not appearing in Google search results - Implement solutions to improve product visibility on Google - Provide expert guidance on SEO best practices for Shopify store Skills and Experience: - Extensive experience with Shopify troubleshooting - Proficient in SEO strategies and implementation - Proven track record in improving product visibility on Google - Strong understanding of Shopify product management - Excellent communication skills and ability to explain complex technical...

Dear Mr. Mohsin, Task: Draw the ELV (Electrical, Low Voltage) shop drawing for the hypermarket project as per the architect's CAD file and the comments we have discussed previously. Project Details: The hypermarket consists of 2 floors: Ground floor: Hypermarket & offices First floor: Store The ELV shop drawing should cover the following systems: - CCTV - Network (Data & Phone) - Sound system (Announcement system with multi-zones) - Door Access - Wi-Fi APs - Server Room

...including copy, visuals, and videos, to drive user engagement and conversions. Monitor campaign performance metrics, analyze data, and optimize campaigns to maximize ROI. Implement A/B testing and other optimization techniques to continuously improve campaign effectiveness. Stay informed about the latest trends and best practices in digital advertising, particularly on Facebook and TikTok. Requirements: Proven experience managing successful Facebook Ads and TikTok Ads campaigns, preferably for SaaS companies. In-depth knowledge of digital advertising principles, audience targeting strategies, and ad optimization techniques. Proficiency in creating compelling ad creatives, including copywriting and graphic design skills. Strong analytical skills with the ability to interpr...

I'm seeking a skilled developer to create a digital product ecommerce store. The store will exclusively sell digital products. The aim of the store is to provide a seamless process for customers to purchase and access the products. Key Requirements: - The payment process should involve a manual payment form. Once a user fills in the form, I should receive a notification and manually confirm the payment through an admin panel. - Once the payment is confirmed, the customer should receive an email with a download link to access the product. Ideal Skills and Experience: - Proficiency in ecommerce development, specifically for digital products - Experience with manual payment processing integration - Understanding of email delivery systems for digital product access ...

...on my website even after excluding its scripts and files from my cache plugin, the issue appeared after I deactivated and deleted my old cookie plugin "Cookie Notice & Compliance for GDPR / CCPA" I now want to use a new plugin called "#" but it is not loading at all. I need you to look into why my new plugin is not working and showing my new cookie policy. CLICK AND COLLECT I have an online store that does deliveries according to a time and date you choose, I use a plugin called "WooCommerce Delivery & Pickup Date Time" to achieve this, I now want to implement a click and collect service which the plugin has already but I need custom components added to my website. Firstly I need a custom order status added called "Ready for collecti...

I have a project that requires entering textual data into a plain text format. The data will be sourced from various online sources. Key Requirements: - Textual Data Entry: The task is to precisely gather, copy, and paste textual data from online sources into a plain text format. Ideal Skills: - Fast and Accurate Typing: To ensure efficient data entry. - Attention to Detail: To maintain accuracy in the data entry process. - Internet Research: Ability to navigate and gather data from online sources. Experience with similar projects and positive feedback will be a plus. Please bid with your relevant experience.

I'm looking for a skilled and experienced paid ads specialist to manage ads on Google Ads, Facebook Ads, LinkedIn Ads and Instagram. My business operates in the local and e-commerce sectors as we run an agency, and we need members for our team. Key responsibilities: - Strategize and manage paid ads across Google Ads, Facebook Ads, LinkedIn Ads and Instagram - Optimize ad copy, targeting, and creative to maximize lead generation - Monitor and report on campaign performance, adjust strategies to boost results - Collaborate with me to align ads with our business goals The ideal freelancer will have: - Previous experience of least 1 year in generating leads through paid ads - Proven track record in managing successful campaigns on Google Ads, Facebook Ads, LinkedIn Ads and Instag...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appr...

This is my WordPress website, "bizcurd.com." I want to convert this website to Shopify. So I need a Shopify expert who can convert my website, WordPress, to Shopify. My budget is $10,000, and the completion deadline is 5 days. If you are okay with the budget and time deadline, please PM back. Otherwise, don't waste your and mine precious time. Note: Please read the proposal description, then ping me. Without reading the proposal, don't ping me.

I'm seeking a developer for an iOS application that will have the capability to read and store iMessage messages on a user's device. Key Features and Requirements: - The primary purpose of the app is to collect and store iMessage messages. - The app should only be activated with the user's explicit consent. - Data security is paramount, with the app designed to implement end-to-end encryption. - The application should be user-friendly and intuitive. Ideal Skills and Experience: - Proficiency in iOS app development, with a strong portfolio of previous work. - Experience in implementing data security measures, particularly end-to-end encryption, is a necessity. - A strong focus on user experience and interface design, ensuring the app is intuitiv...

...audience are Andriod users. From scratch to publishing the app. I need a genuine freelancer who should not miss use any of my personal details and payment related details in future..if I come across any problems in future..I will report to the freelancer to take the action... I have attached requirements... I need a complete iOS and andriod mobile app..till publishing the App in Google play store.. I can only pay the above mentioned payment only... I may have more projects in the future..if i like the work..I may hire directly.. Thanks I need a seasoned developer to create a feature-rich e-commerce application for both iOS and Android platforms. Key Features: - Shopping Cart: The app must provide a seamless shopping experience with an interactive shopping cart. - User ...

I am looking for skilled frontend developer to duplicate an existing website template for my e-commerce store. The old site has performance issues and loads quite slow. There for we have decided to switch from OpenCart to Bagisto store. Responsibilities: - The template needs to match our existing site at least at around 90% ! - No perfection issues at our side - Accepting improvement ideas - There is no need to made it ready for Bagisto, our need is only the CSS and base HTML with dummy content. - Duplicate an existing website to stand alone TailwindCSS template. - Ensure the template is Responsive as our main target is mobiles but desktop as well. - Implement few dummy pages: Homepage, Category, Product, Search, Login / Account. Required Skills and Experience: - Expertise ...

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This pro...will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can be discussed d...

I'm in need of a highly skilled SEO expert to focus primarily on the on-page optimization and backlink building of my Shopify store, which currently suffers from low traffic and conversions. The key objectives include: - Increasing organic traffic - Improving site ranking on search engines - Boosting sales conversions The ideal candidate should: - Have significant experience in on-page optimization and backlink building. - Demonstrate a proven track record in improving traffic and conversion rates. - Possess a deep understanding of Shopify SEO intricacies. A comprehensive strategy targeting both on-page SEO and reputable backlink generation will be imperative in achieving these goals.

I have a printed document that I need copy typed. The main purpose of this is to edit and format it. Key Requirements: - Document is in printed form and needs to be typed into a digital format. - The document should be edited and formatted to adhere to APA style. Ideal Skills: - Proficiency in copy typing, with a strong attention to detail. - Familiarity with APA style formatting. I'm looking for a freelancer who can help me make this document ready for digital archiving.

...designer to develop a clean and minimalist interface for a stock taking application. This UI will be used primarily by our Warehouse staff. Key components of the project include: - UI Design: The primary focus of this project is the design of the user interface. It should be user-friendly, intuitive, and minimalist in style. - Backend Development: The system will be powered by Microsoft Access. The backend should support: - Inventory Tracking: The system should be able to record and update our inventory. - Cost Analysis: The backend should be able to calculate the cost of our stock. - Report Generation: The system should be able to generate detailed reports based on the data entered. The ideal freelancer for this project should have experience in: - UI/UX Design: ...

...information based solely on the information listed in the 【1. Background】【3. Reference Information】 sections (【1】【3】 are for reference only) 【1. Background】 This technology pertains to a system for updating the programs of devices installed in vehicles. Many devices are installed in vehicles, and these devices store programs. It has been proposed that by updating these programs, the functionality of the devices can be improved. In particular, it has been proposed that by receiving data for program updates from an external server via wireless communication, it is possible to update the program without going to a service station or the like. In previous technologies, a specific device functioned as a master device and updated the programs of other slave devices. However, thi...

I'm in need of a digital artist to copy an existing simple design, with minor changes to text only. We have a tote bag that is old and tired now but I would like to remake it. I have included a scan of the current bag, three close up photos and one photo of the overall bag. I would just like a black and white recopy of the original artwork with clean lines which I will print between A4/A3. The final box (lower right side) is currently an advert for the original coffee house (something like "Haasbrock..." but it's faded.. I would like it to say "a yawn is a silent scream for coffee" in the same font as the other boxes but I don't know if it is too long. Fyi - the bag was a from a shop in South Africa which has now closed, so I can't rep...

**NO OR LIMITED EXPERIENCE IS OK - FEEL FREE TO APPLY. DO NOT USE GENERIC BID TEXT (NO COPY PASTING)*** Role is perfect for motivated and learning individuals who are eager for feedback and want to grow skills. Duration is 30 days internship. Those who surpass expectations will receive a serious offer to stay on team with better compensation. Sample tasks and responsibilities include, and are NOT limited to: 1. Research key topics or areas of interest and presenting options for the next steps. -> googling 2. Executing next steps and promptly executing action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed...

...simple form app for iOS. This app will primarily be used for the inspection of returned products. Key Features: - The app should be compatible with iOS only. - The form is meant to collect information like Name, RMA #, Order #, SKU, SKU quantity, a checkbox "Pass" and a checkbox for "Restocked" (with an option to add multiple SKUs). - The app should also have a drop-down list to select the store name, which will determine the email address the result is sent to. - It should have a section to upload up to 10 images using the phone camera. - Date and time fields need to be automatically populated with the current date and time as default. - There should be a drop-down list to select the person inspecting the returns. Ideal Skills: - Experience in iOS app ...

Update for the app only. Submit new update of the app only

I am in need of an experienced individual with a deep understanding of creating and setting up Shopify stores. Since I haven't decided on the main products or the level of customization needed yet, I'd appreciate someone capable of providing expert advice. Ideal Experience and Skills: - Proven experience in setting up Shopify stores - Ability to suggest the best options for products and customization depending on the store's niche - A keen understanding of UX/UI for e-commerce platforms is a plus What to Include in Your Proposal: - Your relevant experience in setting up Shopify stores - Any added skills or expertise that could make you stand out as the best fit for this job - Do NOT include past work or project proposals, I am particularly interested in your experience ...

I need a certified lawyer to notarize an incumbency certificate from a company in the British Virgin Islands. The notarization involves printing and certifying the true copy with your name, certification, and date. Key Requirements: - Notary services for an incumbency certificate - Capable of printing and certifying the true copy - Name, certification, and date insertion Important Information: - Specific deadline for this task - No additional legal services required Please note that the original documents are still with me, and I will provide them to you through the most convenient means for both of us.

...and enhancing customer engagement. - Full Site Development: Lead full site developments or redesigns to ensure a seamless and robust online presence. Proficiency in various Node.js libraries and microservices is essential. Deep understanding of GitHub and experience with bespoke theme development and creation are required. - Troubleshooting and Optimization: Identify and resolve issues related to store performance, functionality, and customer experience. Implement unit tests for robustness. Requirements: - Proven experience as a Node.js Developer in e-commerce environments. - Strong knowledge of e-commerce infrastructure, theme and API development, and integration. - Proficiency in front-end technologies, including HTML5, SCSS, JavaScript, React, Redux, Tailwind CSS, and MUI. - ...

I need a WordPress website with WooCommerce designed with divi (we have the theme license already) - this is just for reference i...completely ecommerce rather, some products just need the option to send enquiry for the product we are displaying. Mainly three pages to design (home, category and product page) - - I need category pages built on all the categories given on the existing page (basically duplicating after making one) - you should atleast be able to generate generic chat gpt content wherever needed - Should be able to copy paste products from the reference websites as well *if you have understood the details start with word "MOBILITY"on your proposal so that I know you read. I need this project completed as soon as possible. Promptness in delivery is crucia...

I'm looking for a skilled iOS developer who can take my already developed app and deploy it to the Apple Store. - You should be well-versed with the Apple App Store submission process and have experience with deploying apps successfully. - Ensure that the app is fully compliant with Apple's guidelines and handle any necessary modifications before submission. Ideal Skills: - Proficiency in iOS app development. - Experience with Apple App Store submission. - Knowledge of Apple's App Store guidelines. Please bid with a brief overview of your experience with iOS app deployment, and any relevant past work.

Logo for my new business. The company name is "Cedar & Spi...Spirit" this is a holistic business where we connect with the client's inner spirit/self. The vibe I'm going for is healing, holistic, loving and kind. I love the look and softness of the water colour look. The cedar tree is important as it connects us with our inner self, intuition and our higher self... I have attached a few pictures for inspiration... I'd like the files in PDF, PNG, and JPEG. A copy in each: white, black, and colour (all with no background)... I'm open to fonts but please ensure they are readable if they are cursive style. please keep colours to a minimum - using only branding colours. i'd also like to see some sketch drawings... My brand colours are in an image ...

For my online store specializing in custom trailers, I need a web designer experienced in building advanced e-commerce functionality. The main feature desired is that visitors will be able to customize a trailer modularly in 3d with parts colors, sizes tied to services and parts as offered by my business. Possibly webGL or anything applicable to an interactive 3d feature for the customization Key Deliverables: - An e-commerce platform to showcase my custom trailers - Advanced product customization options to enhance user experience Ideal Skills: - E-commerce website design expertise. - Experience in advanced product customization systems. - Familiarity with the automotive or trailer industry is a plus.

I have full code flutter app I want using firebase database 1 -Experience https://console.agora. video and call streaming Also 2- Update app to stores Apple store Android store

I'm launching a new clothing store targeting teens and young adults and need an expert to establish my online presence. This project involves two key deliverables: - **Social Media Setup:** I require assistance in setting up and optimizing my business Facebook page and Instagram account. The goal is to create a cohesive brand image and establish a platform for engaging with my target audience. - **Logo Design:** As a modern and minimalist brand targeting teens and young adults, I need a logo that reflects this aesthetic. The logo should be simple yet memorable, with a design that resonates with my target audience. Ideal freelancers for this project should have experience in: - Social media setup and optimization, preferably for clothing or retail businesses - Graphic desig...

I'm looking for someone to set up a Shopify account for me. I plan to sell digital products, and I won't be offering any ...sell digital products, and I won't be offering any subscription-based services. Your main responsibilities would include: - Creating a user-friendly and engaging Shopify store - Integrating the necessary payment gateways - Implementing a digital product delivery system Your expertise in setting up Shopify accounts, particularly for digital products and knowledge in e-commerce would be crucial to the success of this project. The ideal candidate should also be able to suggest any additional features that would improve user experience and increase sales. Please bid only if you have a history of successful Shopify store setups and can pro...

I've attached two drawings which is what I would like professionally replicated so I can eventually print across say 3 x A3 sheets and display on an easel. I have attached a photo of what the old building looks like which is what one of these two drawings will replace.

...SwiftUI. Implement UI components such as progress bars, buttons, and status indicators. - Implement Core Functionalities: Use Alamofire for handling firmware downloads. Utilize libimobiledevice for interacting with iOS devices to enter recovery mode, DFU mode, and perform restores. Use Core Data or SQLite for storing downloaded firmware files and application data. - Integrate Reactive Programming: Use Combine to manage asynchronous tasks and data binding. Update UI elements in real-time based on data changes and user interactions. - Leverage Machine Learning: Implement Core ML models to predict device issues and suggest solutions. Use NLP to develop an AI-powered assistant for user guidance. - Ensure Robust Error Handling and Logging: Implement comprehens...

Need a logo for my business. The business name is "Brenda Torre" but MUST INCLUDE Hair & Makeup Artistry in the logo. Do not use any make up tools in the logo, but be creative and we want it to be modern and fresh. Open to any color pallet, but the logo must look good in any color. Id like to also incorporate "fleurdelys" which is attached BUT do overkill i...INCLUDE Hair & Makeup Artistry in the logo. Do not use any make up tools in the logo, but be creative and we want it to be modern and fresh. Open to any color pallet, but the logo must look good in any color. Id like to also incorporate "fleurdelys" which is attached BUT do overkill it. Open to other ideas as well that dont need to incorporate it but want to see new and fresh ideas....

I need a freelancer to copy and paste video links from YouTube, and organize them by upload date. Ideal Skills and Experience: - Proficient in navigating YouTube - Basic understanding of video content - The project involves copying and pasting video links from YouTube - The links need to be organized according to their upload date - The freelancer will need to work with a large volume of links, so attention to detail is critical - Previous experience with data entry or content organization would be beneficial Please go through the document Links that need to be attached and apply only if you can do the job completely. Thanks

...have an idea. You don't need to include this logo in the ad...but just the rainbow element as a design image in the background or something that looks beautiful.) All the same contact information should be included (Instagram, email, website). Also in the ad it should say that the tours are available in English & German. The deadline for the final ad is Friday morning our time. Here is the copy for the ad: Uncover the Secrets of San Francisco With Your Private Tour Guide Frank From hidden gems to iconic landmarks, discover the city like a local. Come with me on a journey of history, music, people, stories and beautiful views in vibrant neighborhoods like the Castro or Haight Ashbury. My private tours are tailored to your interests and guaranteed to leave you wit...

I'm seeking detailed market research and feasibility analysis on basmati rice in the Toronto region. My aim is to understand the following key areas: - Market Demand: Analyze interest levels in the region among restauran...consumer. Specifically, explore primary relationships between producers, wholesalers, retailers, and consumers. - Market Selling Price: Analysis of the current selling price for basmati rice, understanding the different price points between wholesale and retail, as well as variances between online and in-store. The ideal candidate for this job would have a background in market research, demonstrated understanding of the Canadian grocery market, and an excellent ability to collate and interpret data. Previous experience with feasibility studies would...

I seek guidance from an experienced ecommerce consultant to establish my first online store. Your expertise is desired to direct me through each step of setting up the storefront, from selecting a suitable platform to designing an aesthetically pleasing and fully functional website. Your skills are needed to configure the backend and optimize the front end experience for customers. It is also important to me that the site is built with search engine optimization top of mind. Proper implementation of SEO best practices during the development phase, such as appropriate metadata, hyperlinks and responsive design, will help ensure our products are easily discoverable online from launch. User experience must be smooth across all devices. Your guidance on pricing, payment options and inve...

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySp...

I need a new website that will serve as a platform for selling products or services. Specifically, I'm looking for a professional who can: I want to be ale to sync this with my other website, ebay store, shopify - Develop a user-friendly website with basic customization on a standard platform - Integrate an online payment system including digital wallets (e.g., PayPal, Apple Pay) Ideal Skills and Experience: - Proficient in e-commerce website development - Experienced in integrating online payment systems, especially digital wallets - Skilled in basic customization on standard platforms, ensuring the website aligns with our brand and user experience expectations. Please provide examples of similar projects you've worked on.

**NO OR LIMITED EXPERIENCE IS OK - FEEL FREE TO APPLY. DO NOT USE GENERIC BID TEXT (NO COPY PASTING)*** Role is perfect for motivated and learning individuals who are eager for feedback and want to grow skills. Duration is 30 days internship. Those who surpass expectations will receive a serious offer to stay on team with better compensation. Sample tasks and responsibilities include, and are NOT limited to: 1. Research key topics or areas of interest and presenting options for the next steps. -> googling 2. Executing next steps and promptly executing action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed...

Proposal for publication calendar with copy writing and hashtags. Content feedback meetings. Editing of story format content. Creation of feed pieces (images, reels, videos, carousels) Creation of a TRELLO board to manage the calendar and approve the pieces. Content scheduling and publication. Design and feed proposal (includes color palette, font, tone, emojis). Contribution and content ideas suggestions. Benchmark, investigation of the competition.

Proposal for publication calendar with copy writing and hashtags. Content feedback meetings. Editing of story format content. Creation of feed pieces (images, reels, videos, carousels) Creation of a TRELLO board to manage the calendar and approve the pieces. Content scheduling and publication. Design and feed proposal (includes color palette, font, tone, emojis). Contribution and content ideas suggestions.

...within the realm of cross-platform apps. - Proficiency in NextJS is a must as one of the projects involves its usage. - A good understanding of user experience and user interface design will be an added advantage. The app will link to our software The flow chart attached explains most of the features. You need to expand it to view it properly. Unfortunately that is the only copy we have so you will have to make the most of the quality. In addition to the features on the flowchart we require:- To be able to input menus for restaurants & takeaways. Customers can place an order which goes through to the specific restaurant / takeaway. Also the food outlet can take payments from their payment facilities so will need to link with API's. Flowchart Link: