Mysql query magentoงาน

I'm seeking a skilled data architect for providing consultation and recommendations on a Statement of Work (SOW) that involves data warehousing, ad hoc reporting, complex SQL format...recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills, including complex query formation - Familiarity with streamlining and enhancing data storage - Experience in supporting monthly data integrations Your insights and guidance in this project are crucial for our lon...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

...developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs.  Optimize database performance through indexing, query optimization, and other performance tuning techniques.  Develop and enforce data standards and best practices to ensure data integrity and security.  Provide technical guidance and mentorship to junior developers.  Troubleshoot database issues and provide timely resolution.  Stay up-to-date with the latest trends and technologies in database management and architecture. Ski...

I'm looking for a Magento developer to add new features to my existing Magento website. Key Responsibilities: - Implement new features into the current website. - Ensure the new features are properly integrated and functional. - Provide technical support and troubleshoot as needed. Ideal Candidate: - Proven experience in working with Magento. - Familiarity with ecommerce websites and their specific requirements. - Strong problem-solving skills. - Excellent communication and collaboration skills.

...developer who can build an automated document verification system to simplify the document management procedure in educational institutions. The system must include the following features: - Database Integration: Integrate with MySQL, our preferred database management system, to make document retrieval and management easier. - User Authentication: I want the system to authenticate users via Single Sign-On (SSO) using existing authentication platforms like Google and Facebook. This is to ensure a secure, seamless and user-friendly sign-in process. Proficiency in MySQL, SSO Integration, and system development is required. Prior experience in document management system creation will be preferable. The ideal candidate should understand the intricacies of data security and ...

My existing React Native application, which is supported by NodeJS and backed by a MYSQL database, needs immediate attention. Here's what needs to be done: User Interface Updates: The component related to photos in the application requires significant changes. I also need a feature that shows the GPS route to the specified delivery point. This functionality was not implemented in the initial version of the application. Additionally, changing screen configuration doesn't display corresponding states with their color (only changes upon updating the application). Functionality Improvements: On top of the UI changes, the app needs general functionality improvements to enhance user experience and the app's efficiency. Also, create a button for downloading PDF files; the ...

Website Designer , Php , E Commerce having knowledge of MySQL

I'm looking for someone to work with me on an automated crypto trading bot. It will use Tradingview alerts, (which uses Webhook URL) to ping a script on a server, which then uses an exchange API to execute crypto trades. I will integrate the script into MySQL using php to track the amount traded and set a e.g. a sell price for the crypto just purchased after the alert... I can do that... But I need help with the integration of alerts from Tradingview and the API code to the exchange.

As you know, Magento displays the lowest priced simple product associated with configurable products. we want the price of a specific child product to be shown. There are modules designed for this, known as configurable preselect, but I couldn't get it to work. Although there are settings in the module for category or listing display, the preselect feature that works on the product detail page does not work on the category page. Can you solve this problem?

Project Overview: We are in need of a skilled backend developer to implement the necessary functions for our financial services website. The primary goal is to ensure smooth operation and functionality across various sections of the site. Project Details: Functionality Scope: Implement backend functions to support the frontend interface. Develop APIs ...discussed based on project scope. Timeline: Fastest to complete. Preferred Communication Channel: Freelancer platform messaging system. Additional Notes: Collaborate closely with frontend developers to ensure seamless integration. Prioritize security and data integrity in backend implementation. Skills Required: Node.js RESTful API Development Database Management (e.g., MongoDB, MySQL) Authentication and Authorization Systems

I'm seeking a skilled system administrator to replace my current MariaDB with MySQL 8.0 on a CentOS server. The ideal candidate will be able to: - Completely remove MariaDB ensuring no data loss - Install and configure MySQL 8.0, adhering to: * Default configuration * Custom storage engine Security is a key concern. Remote access to the MySQL installation must be restricted. This is crucial to maintain the integrity and security of the server and its data.

...experienced course creator to develop a comprehensive video tutorial focused on Microsoft Power Query. Key Features: - User-friendly interface - Capabilities to import data from various sources - Customizable course structure The ideal candidate should have the ability to break down complex concepts and make them easily understandable. The course content should cater to beginners and intermediate level learners. Course Duration: Each video course module should be crafted with the target of a total duration amounting to 3-4 hours. This could be composed of several shorter lessons or modules, for easy consumption and better learning experience. Required Skills: - Strong knowledge of Microsoft Power Query - Proven experience in creating video courses - Excellent communi...

I'm in need of a freelancer who's experienced with Magento to help me update product data on my existing store. We need to update 450 products: Go to: 1) Personalizad option 2) Add Title 3) choose Type of imput 4) choose No 5) Add second title 6) Add Price 7) Add SKU All in one page

...an experienced AWS DevOps specialist to host my business management tool which consists of a React-based front-end, an ASP.NET API and a MySQL database on AWS, specifically using Elastic Compute Cloud (EC2). Key requirements: - Hosting: Set up and manage the hosting environment on AWS EC2, ensuring the site is stable and accessible. - Scalability: Implement strategies to accommodate low traffic, up to 100 users per day. - Security: Ensure the highest level of security and integrity of the data. Ideal candidates should have: - Proven experience in DevOps and cloud hosting, particularly with AWS EC2. - Background or familiarity with React, ASP.NET, and MySQL. - An understanding of best practices for hosting and optimizing web applications. This project is crucial for my b...

I need someone to migrate all my product data from Magento to Woocommerce, including customer data and passwords. The new Woocommerce site should have a fresh, new design and not replicate the current Magento site. It would be great if you have experience with both Magento and Woocommerce. Key responsibilities include: - Transferring all product data from Magento to Woocommerce - Migrating customer data, including passwords - Designing a new look for the Woocommerce site Skills and experience required: - Proficiency in Magento and Woocommerce - Experience with data migration - Design skills to create a new site

??? ?????: ????? ?????? ????????? (????-????, ??????) Salary: up to 4000$ USD/month The ideal candidate will have a passion for algorithmic trading and extensive experience with the NinjaTrader platform software. This is a fully remote position with a flexible schedule, but the candida...Experience with version control and continuous integration tools such as GitHub/GitLab • Knowledge of third-party libraries and APIs • Proficiency in building enterprise web solutions using the MERN stack • Strong proficiency in HTML, CSS, JavaScript, and JavaScript frameworks like Dart, React, and Node • Experience with server-side languages such as Python, PHP, and C# • Knowledge of databases such as MySQL, NoSQL, and GraphQL Ability to accurately forecast and communicate ...

...facilitate data literacy within the organization. Continuous Improvement: Stay updated with the latest Power BI features and healthcare industry trends. Continuously seek ways to improve reporting processes and tools. Qualifications: Proven experience as a Power BI Specialist, preferably in the healthcare industry. Strong proficiency in Microsoft Power BI, including DAX and Power Query. Experience with healthcare data and understanding of healthcare metrics and terminology. Excellent analytical and problem-solving skills. Strong communication skills, with the ability to explain complex data concepts to non-technical stakeholders. Experience with data integration from various sources such as EHR systems, practice management software, and patient feedb...

We have a website developed in PHP & MySQL database. We need to add news section in the home page. The same should be available to be edited from the Admin Section for the user to change contents in the News Section.

I'm searching for a proficient Go coder to develop a software application tailored for the Linux platform. Key requirements include: - Proficiency in the Go programming language - Proven experience in s...requirements include: - Proficiency in the Go programming language - Proven experience in software development - Keen understanding of the Linux operating system - Network programming - Geneve encapsulation - CoreDNS development Looking for Go programmers with strong networking background to write a DNS handler plugin for CoreDNS which can receive Geneve packet from client, decap the underlying DNS query in UDP or TCP or DoH preform DNS resolution as normal through the built in forward plugin. On the response side the plugin must be able to encap back to Geneve and res...

I am currently looking for a professional to help integrate PayPal legacy buttons into my existing shopping cart system. PayPal's documentation for the legacy buttons is not helpful. My add-to-cart button gets information from a mySQL database, but I'm unable to get the add-to-cart and view-cart buttons to work together. These used to work on an older web site. Key Requirements: - The main functionality is to enable my shopping cart to be able to process payments via PayPal. - The integration should direct customers to the PayPal website for payment processing. - I am looking for a manual coding integration, so experience in this is a must. Your Skills: - Proficiency in PayPal integration - Experience in manual coding for shopping carts - Attention to detail to ensure...

Estamos buscando un programador Android Studio para crear una app cuyo funcionamiento es conectarse a una base de datos mysql y consultar datos a partir de escanear un codigo de barras o QR. Buscamos a alguien de Argentina o al menos de America Latina.

I need a concise and informative PowerPoint presentation done on the Disabled Facilities Grant (DFG) in the UK. This will be presented in PPT and should run for 8 minutes, no AI: MAIN QUERY OF TASK: "The DFG team currently has a large backlog of cases, both children and adults, that need to be dealt with and processed promptly and efficiently. We will be undertaking a process review to enable us to achieve eliminate the backlog. What suggestion would you have to update the process, and the service, ensure HBC compliance, and ultimately customer satisfaction? Key Task: - Conduct Research: The main focus of this presentation will be the process review of the DFG application process in the UK. The ideal candidate should have a strong background in thorough research and experienc...

I am in need of an expert React Native developer to upgrade my existing app running v0.59.9 and bring it up to date with the latest version of React Native v7.0+ In addition to the platform upgrade also need to: - Upgrade Facebook SDK for FB login to continue working - Adjust query in 'My Activities' to only show activities created in the past, while 'Latest Activities' should only show future activities from all users within radius Skills and Experience: - Proficient in React Native - Experienced in upgrading apps to support multiple platforms - Familiar with the latest version of React Native

I'm seeking a skilled developer to build a professional and user-friendly dashboard using NextJS Ideal Skills: - Proficiency in NextJS for building feature-rich, responsive dashboards. - Experience with Paddle API integration, particularly for subscription management. - Strong knowledge of MySQL for robust database functionality. - A keen eye for UX design to ensure the dashboard is intuitive and user-friendly. - Ability to work efficiently and communicate effectively throughout the development process.

I'm currently looking for a skilled and experienced developer for backend CMS development. Key responsibilities: - Develop a Content Management System using PHP, Laravel, MySQL, and Python. - Design, implement and maintain python-based backend application. Essential Skills: - Proficient in PHP, Laravel, MySQL, Python. - Extensive experience in backend development. - Knowledge in CMS development and implementation. - Strong understanding of data structures and algorithms. Your analysis skills will also be put to good use to solve complex problems in this role. As an experienced backend CMS developer, you can expect to work closely with me to deliver a robust, performant, and scalable system.

I have a Wordpress plugin called Sales Agents B2B and I'm looking for a skilled Wordpress developer to make 4 small customizations to it. The customiz...subagents created by agents in their account - Showing the assigned sales agent in the list view of users - Modifying existing features: - Ensuring sales agent visibility in the list view of users The ideal candidate should have experience in: - Expertise in Wordpress plugin development - Understanding of user roles and permissions - Proficiency in PHP and MySQL for plugin customization - Previous experience in CRM system integration would be a plus Please only apply if you have relevant experience and can deliver quality work within a reasonable timeframe. I'm looking forward to hearing from you.

I am seeking a skilled PHP developer to create a distance calculating sript for me. This script will be responsible for calculating the distance between multiple coordinates stored in a MySQL database. No user interface required as the coordinates will be retrieved from the database directly. Key requirements for the project include: - Create a script that can fetch the coordinates from a MySQL database - Calculating the distance between these multiple coordinates accurately If you're a developer with experience in MySQL PHP and distance calculations, I would love to hear from you.

We using o365, copilot studio, Azure ai applied. We need to create a chatbot in teams and webpage using copilot studio which can be use azure ai feature and able to seach the internal SharePoint site documents. 1,Azure ai chat bot(suppot continue query), 2,documents lookup and learning from SharePoint documents, 3,can be acces from website (sso login required), 4,can integrate in team chatbot

Perfect english is needed. You need to be able to teach and tutor me in relational data bases and sql. You must...answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database system is a must. The complexity level of the project is intermediate, focusing on tasks like joins and subqueries. Ideal candidates will have: - Extensive experience with MySQL databases - Strong SQL querying, schema design and query optimization skills - Proficiency in working with relational databases - Experi...

App Developers Query - Template Hi, We're currently seeking a talented app developer who shares our vision and passion for creating a platform helping users improve productivity to achieve their hobbies. If you have experience in start up app development and interested in collaborating with us bringing Hobbi to life, we would love to hear from you! About Hobbi: Hobbi's an innovative solution designed to assist time management enabling maximum productivity to achieve desired goals of hobbies. Our app aims to revolutionise the way our customers interact with their hobbies and self-development. We believe that there is a gap in the market for a comprehensive, user-friendly application that offers a way of planning, tracking and sharing achievements of your hobbies. Key Fe...

I am looking for a freelancer who can help me with Web Scraping. We have a list of websites that we would like to scrape specific data from, and have them put into a set of MySQL Databases (or maybe something else). The website that we would like to scrape data from each contain thousands of articles, and we would also want other metadata, such as Author name, article date, number of views, or any other metadata that we can take from the pages. Please bid, and we can discuss the first website, you can tell us how long you think it'll take to write the scraper. There are maybe 50 websites to begin with that we would like to do this for, in this one project, and we also have another couple of similar projects. Ideally, the scraper will run form a program, so that we can run it...

I'm looking for an experienced developer to create a custom payment gateway so that I can offer it to other websites or merchant. This gateway will only be given to websites and not apps. Key Features: - The payment gatew...payments effectively. Skills and Experience: - Proficiency in payment gateway development - Experience in creating gateways for websites - Understanding of international payment processing - Strong security implementation for financial transactions - Ability to create a user-friendly interface for customers Optional: - Integration with popular e-commerce platforms such as Shopify, WooCommerce, or Magento would be a bonus. If you have a solid track record in building payment gateways and can deliver a secure, efficient, and user-friendly solution, pleas...

I need a professional NextJS dashboard created that integrates Paddle for subscription management and MySQL as database Key requirements: - Create a NextJS dashboard: The design needs to be clean and professional. I'm not looking for something overly complex, but rather a streamlined and user-friendly interface. - Integrate Paddle for Subscription Management: This functionality is crucial for the success of my project. I need the dashboard to seamlessly handle subscription management through Paddle. Ideal skills and experience: - Proficiency in NextJS: You should have a good understanding and experience working with NextJS. - Experience with E-commerce integrations: Ideally, you have previously worked on projects that involved integrating billing systems like Paddle. - Desig...

...developer who can assist in diagnosing and rectifying the issues we're currently facing with our PWA. Requirements: - Understanding of Progressive Web Apps - Understanding of Magento 2.4 We had a PWA built for our ecommerce site, however its never worked properly and actually impacts on even simple daily tasks - the freelancer who developed this for us is unwilling to assist correcting the problems. Customers are now identifying that the app is not working and they are walking ie we are loosing customers, orders and money. Freelancers bidding on this project will be expected to show evidence of PWA running from Magento. The chosen freelancer will be hired on an hourly fee basis and expected to completely remove the existing PWA and build a new system - using fun...

I'm currently in need of a proficient backend developer who specializes in Node.js. Key responsibilities include: - Developing user authentication - Integrating the database - API Development The chosen candidate will preferably be experienced in and MySQL, although this isn't obligatory. knowledge is a bonus. In light of a tight deadline, applicants who can start as soon as possible will be prioritized.

...for the pre and post development area for the roof of 205sqm. 3. Please include calculations demonstrating how the stormwater discharge will be restricted to pre development rates for the 205sqm. Note: The pre development roof area of the existing building is 90sqm pre renovation Engineering for the area has been submitted and was thought to be finalised though they came back with the further query above. Happy to supply all existing calculations and stormwater management plans Thanks for your help!...

Disponemos de un software de gestión desarrollado en CakePHP 2.10 + MySql. Necesitamos ampliar algunas funcionalidades y realizar algunas refactorizaciones.

I'm going to build auth login page using the react , tailwind css, express Mysql DB. Also we have to join with google acc , facebook acc, apple acc.

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

...student data collection, storage, and retrieval, along with student-related functionalities. * Improvement of Attendance Tracking module, allowing real-time tracking and management of student attendance. * Development and implementation of a functional Gradebook module, enabling easy, efficient tracking, storage, and retrieval of student grades. As for the technology stack, we work with Laravel, MySQL, and HTML/CSS. These are the tools you'll be using to modify and improve the functionalities. Finally, our project strives towards a modern and minimalist design approach. We believe in sophistication and elegance over extravagance. Experience with the aforementioned technology stack and a knack for minimalist design is highly appreciated. Join us and be part of an ever-evo...

I'm looking for a skilled developer in CodeIgniter and MySQL to help me enhance a school grading system. Please note, developers who can communicate in Spanish are particularly welcome. Key Upgrades Needed: - **New Features**: Primarily, I want to introduce online grade submission for teachers and a parent portal for keeping track of students' progress. These features will significantly elevate the utility of the existing system. - **Optimization**: It's crucial that the performance of the system is optimized during these upgrades to ensure it remains fast and responsive. Specific Design Requirements: - **Modern and Sleek Design**: The new features should be incorporated into a modern-looking interface. - **Simple and Intuitive Layout**: The design should be user-fr...

...student data collection, storage, and retrieval, along with student-related functionalities. * Improvement of Attendance Tracking module, allowing real-time tracking and management of student attendance. * Development and implementation of a functional Gradebook module, enabling easy, efficient tracking, storage, and retrieval of student grades. As for the technology stack, we work with Laravel, MySQL, and HTML/CSS. These are the tools you'll be using to modify and improve the functionalities. Finally, our project strives towards a modern and minimalist design approach. We believe in sophistication and elegance over extravagance. Experience with the aforementioned technology stack and a knack for minimalist design is highly appreciated. Join us and be part of an ever-evo...

...documentation and basic training on the usage of the customized system. Requirements: - Proven experience in web development with a strong portfolio showcasing similar projects. - Previous experience with UltimatePOS customization is highly preferred. - Expertise in PHP, Laravel, and frontend technologies (HTML, CSS, JavaScript). - Strong understanding of database management, preferably with experience in MySQL. - Knowledge of best practices in security and data protection. Budget and Timeline: - Budget: $150 - Timeline: Completion within 2 weeks from the start date. Deliverables: - A fully customized UltimatePOS system tailored to the needs of a mobile wholesaler. - Source code and all related documentation. - Deployment on the specified hosting environment and basic user tra...

A. give users interfaces that would allow them to do the following: 1. Build unlimited number of customized questionnaires, by adding all common form elements, plus Conditional fields. 2 build unlimited customized search/ query screens by adding same common form elements as their questionnaire. 3. Build customized output/ report screens to present search results. B. All of the above are build on a 100% normalized MySql database, which will become the centralized database for all future data collection, search, and report generation for third party or custom made plugins/apps.

Project Duration: 1 Hour Project Type: PHP & MySQL Server Type: Linux Ubuntu PHP Type: 8.2 & Above Number of Improvements: 4 Project Overview: We would like some modification made to two existing PHP files that: 1) Fixes a bug stopping one of the files from inserting new records into our database 2) Inserts additional data into a new db field 5* FEEDBACK WILL BE LEFT FOR YOU

...primarily for the use of employees who will be responsible for carrying out the tasks listed on the job cards and the managers/administrators who oversee these tasks. Employees will need access to all past completed and active jobs. Managers will need to have access to send the completed job to QuickBooks, add / remove employee names and set an hourly labour rate. Ideal Skills: - Proficient in PHP and MySQL - Experience in developing web-based forms - Knowledge of job management systems - UX/UI Design capabilities for a user-friendly interface Open to all options: The creation of a new system, use of a Wordpress modification, use of Office 365 Forms and Zapier to link to QuickBooks. We have a server to run SQL with Apache, PHP and FTP. Please consider the functionalities I&#...

...APIs, web scraping, and web page reengineering processes to extract information and structure it in the expected format. The system should generate a record of each query made, indicating whether results were obtained, no results were obtained, or if the source was not available. A document detailing all the sources of information from which data should be extracted will be provided. Main Features: 1. Automatic Querying of External Sources: Perform queries to multiple external sources according to the provided specifications. 2. Data Structuring: Process the obtained information and structure it in the required format. 3. Query Log Generation: Create a detailed log of all queries made and their results. 4. Response Handling: Identify and record whether results were obtain...

AI Chatbot Saas of existing with only rebranding (colors, logos, fonts etc.) The existing can be found at 7 Days support included after delivery for any query . Duration 5-7 days.

I'm seeking a talented web developer to create a robust e-commerce clothing website. The selected freelancer should have significant experience in both front-end and back-end development, with a specific focus on creating user-friendly...shopping component is a must. Implementation of shopping cart and checkout systems will be necessary. - The site should support credit card payments. Fluency in payment gateway integration, specifically for credit card transactions, will be essential. Ideal Skills and Experience: - Proficient in front-end technologies (HTML, CSS, JavaScript) - Familiarity with e-commerce platforms such as Shopify, Magento, or WooCommerce - Experience with payment gateway integration. Please submit your bids indicating your proposed strategy and timeframe fo...

As a client, I'm seeking an experienced Node.js developer for full-time work. The primary t...experienced Node.js developer for full-time work. The primary tasks for the job will include: - Backend Development: You'll be responsible for building and maintaining the server-side of our application. - Frontend Development: You'll also need to work on the application's client-side. The ideal candidate should be proficient in working with: - Backend: - Frontend: React.js - Database: MySQL A solid understanding of these technologies is crucial. Experience in additional areas like API integration and database management will be a plus. Please bear in mind that this is a full-time position, so time dedication and commitment are paramount. Look forward to hearing from ...