Magento sql query products jobs
I would need a script written in nodejs where a USB NFC reader (specifically the ACR122U or the ACR125U) wait for a NTAG424 DNA tag. Once an NFC tag is tapped write a URL data into the tag as well as encryption keys. Make sure the URL contains query parameters which are mirrored uid, counter, and cmac that are all encrypted. Part of this is to write a nodejs script to validate the above parameters from the URL and decrypt the uid/counter (or some Rust that can do the same)
I need a professional developer to assist with creating a Shopify template. The design is based on a Magento template from my another shop. Key requirements for this project include: - Creating a Shopify template that closely mirrors the design of an existing Magento template, incl. graphics and layout I am looking for someone with the following skills: - Proficient in Shopify and Magento, with the ability to translate designs between the two platforms
...---------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was added and create a new one called Booking Category. This will need look up the `11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes/gamico/template-parts/project/ to show the Booknetic category based on the game.
I'm looking for a highly experienced e-commerce website developer, capable of creating an interactive and user-friendly website for marketing my physical products. Key Requirements: - Able to develop a site accommodating more than 50 product categories. - Payment gateway integration is essential in facilitating transactions. Desirable Experience and Skills: - Extensive experience in e-commerce website development, specifically those selling physical products. - Proficiency in integrating payment gateway systems. - Proven experience in organizing a vast collection of items facilitating easy navigation.
As an entrepreneur keen on selling physical products to adults aged 25-45, I am in need of a proficient Shopify store designer. Your creative skills are crucial to deliver a design that reflects a simple and intuitive user experience. Key Responsibilities: - Develop a Shopify store to sell a variety of physical products targeting Adults (25-45). - Create a simple, user-friendly platform to facilitate a seamless shopping experience. Skills and Experience: - Proven experience in Shopify store design - Strong UI/UX skills to create a user-friendly environment - Understanding of target audience shopping behaviours - An eye for clean, intuitive design to cater to a mature audience I am seeking a professional with a firm grasp of these skills to engage precisely with my proj...
...Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Cloud Memorystore): Log Redis operations. - Collect and store logs centrally using GCP's Stackdriver Logging. - Set up log rotation and retention policies. 3. HTTPS Domain...
As a clothing brand store, I'm looking to develop a digital storefront primarily dedicated to men's casual/streetwear clothing...record to help with this project. The task will entail: • Building an intuitive, user-friendly store layout • Implementing functionality for a size chart, color options, and customer reviews Ideal freelancer or team should have: • Experience in e-commerce website development • A clear understanding of user interface and user experience principles • Proficient in platforms such as Shopify, Magento, or WooCommerce • Knowledge of the fashion industry, especially men's casual/streetwear Your main task will be to turn my vision into a functional, attractive e-commerce store that is easy to navigate and provides ...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for...
I am looking for someone to Add Products to our laced store.
We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 3...
I'm looking for a content writer who can create engaging and info...for a content writer who can create engaging and informative content focusing on tech products. - Your primary goal will be to provide readers with knowledge about various tech products, helping tech enthusiasts get a deeper understanding of what's available on the market. - The ideal candidate will have expertise in tech-related content creation and a deep understanding of the tech industry. - A strong grasp of the English language and ability to write in a clear, concise, and engaging manner is required. - A knack for making complex tech concepts digestible for the tech-savvy reader is also crucial. Your writing should captivate tech enthusiasts, keeping them informed about the latest tech...
...ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication should be straightforward, requiring only an email and password for access. Ideal Skills and Experience: - Proficient in Laravel - Experience in creating admin dash...
We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.
Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.
...4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. API Integration: Connect the backend with the frontend using APIs. The APIs should be well-documented, secure, and efficient, allowing seamless communication between the backend and frontend. Requirements: Proven experience with CodeIgniter 3 and 4. Strong knowledge of SQL query optimization. Expertise in identifyin...
About Us: We offer custom software solutions for online shops and help businesses optimize and automate their sales and shipping processes. We are looking for an experienced freelancer to develop plugins and interfaces for various e-commerce platforms. Here are the Plattforms we are seraching Freelancers for: Wix Ikas JTL-Shop Magento BigCommerce WooCommerce Gambio PrestaShop OpenCart Analyze and understand the specific requirements and integration possibilities of the listed platforms. Implement secure and efficient interfaces between the plugin and the respective e-commerce platforms. Ensure the plugin's compatibility with the latest versions of the platforms. Perform testing and debugg...
looks like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from S...
I'm looking to establish a Shopify store primarily aimed at women in their 20s to 50s. This online space will be packed with physical products and needs to reflect an elegant and sophisticated aesthetic. Requirements: - Building a Shopify store with an elegant, and sophisticated design - Knowledge on Shopify tools to effectively present physical products - Understanding the preferences of the targeted demographic (women in their 20s to 50s) - Prior experience with creating online stores targeting a similar audience is preferred Skills: - Proficient with Shopify platform - Strong understanding of e-commerce UX best practices - Excellent visual design skills - Experience in CSS/HTML - Knowledge about product presentation in an online setting - Able to accomplish an &#...
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm in need of a proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.
As the owner of a Magento 2 website, I am facing a set of challenges requiring urgent attention. Primary Issues: - Checkout process errors: Our sales are dropping and people complained they can't pay. I found one solution: if we revert configurations from the backup that should be resolved. We sold last yesterday at 7 pm and there are no sales after that even though we can monitor customers who are going on the checkout page but aren't able to shop. This never occurred! Ideal Candidate: I am looking for a freelancer with extensive experience in Magento 2 who can accurately diagnose and resolve these issues. This project will be done through anydesk as we can't share access and please bid if you can fix these issues in a couple of hours. Thank you
Hi, I am looking for expert to connect SQL database togoogle looker studio so we can analise data and creat reports, it is a long term coopartion. Please provide implementation cost and hourly charge. Best.
As a growing online business, I need a freelancer to assist with the revamp of my Magento-based ecommerce website. The project will encompass: - Website Design: Your eye for design will help ensure a captivating and user-friendly website experience for our online shoppers. - Product Uploading: We have approximately 100 - 500 products to be uploaded. Efficiency and attention to detail are key. - Payment Gateway Integration: Ability to integrate PayPal as a payment gateway is essential. Ideally, you should bring strong Magento experience, familiarity with PayPal integration, and a proven track record in designing user-friendly ecommerce websites. Your knack for a clean, appealing aesthetic is a huge plus!
...programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation fro...
We are seeking an experienced freelance developer to design and develop an online service booking platform targeted at legal professionals. The project includes creating both a web application and a mobile application for service providers. Responsibilities:Design and develop an intuitive user int...booking system with calendar and availability management. Implement secure payment systems and automatic notification features. Ensure compatibility between the web and mobile to best practices for security and data protection. Required Skills:Proven experience in web and mobile in front-end and back-end technologies (e.g., React, Node.js).Experience with SQL or NoSQL understanding of UX/UI design to meet deadlines.
...standards of code quality and push for continuous improvement. **What You Need:** - BS/MS in Computer Science, Engineering, or related field. - 2-3 years of full-stack development experience, with significant focus on mobile apps. - Strong proficiency in Flutter or similar, front-end technologies (HTML5, CSS3, JavaScript), and backend development (Node.js, Django). - Experience with databases (SQL & NoSQL), cloud services (AWS, Google Cloud, Azure), and versioning tools like Git. **Why Join Us?** - Flexible working hours and a chance to work in a dynamic, fast-paced environment. - Continuous learning and professional development opportunities. ? **Apply Now!** Send your resume, a cover letter, and work samples/portfolio demonstrating your expertise relevant to the role. ...
I'm in need of an experienced web developer proficient in Python or PHP, specifically with expertise in Laravel. React.js. The project involves creating a customized e-commerce website, which requires several key features: - Product Catalog: The website must be able to showcase a wide range of products, organized in a user-friendly and visually appealing way. - Shopping Cart & Checkout Process: A seamless and secure shopping experience for users is paramount. This involves a smooth cart functionality and a secure checkout process. - User Registration & Login: The site should enable users to create accounts and log in, allowing for personalized shopping experiences and order tracking. - Super fast load time at least 93 score in google load time. - Booking Platform with ...
...user login/signup, in-app messaging, push notifications, photo and file upload. Advanced features should also include GEO Fencing, QRCODE/Barcode scanning and face recognition. The app should be supported by SQL and allow user details to be saved and retrieved from a database. Furthermore, the app needs to integrate with Google services like Maps and Calendar. The design of the app should be minimalistic but seamless for easy user interface. Therefore, a developer with design skills would be perfect for this task. - ESSENTIAL SKILLS: - Android app development - Knowledge of SQL - Minimalistic app design - Experience in GEO Fencing, QRCODE/Barcode scanning, Face Recognition - API integration with Google services This project will require rigorous testing to...
I'm in need of a skilled developer with strong experience in NodeJS, React, and Next/NestJS. The p...Search Functionality: The application will have a search feature that allows users to find specific content or items efficiently. This will require robust search algorithms and user-friendly interfaces. - Payment Gateway Integration: The application needs to support payment processing. You'll need to integrate a payment gateway to handle transactions securely and seamlessly. Your experience in SQL will also be valuable to ensure efficient data management and integration with the web application. Please provide examples of your past work that demonstrate your expertise in these areas. I'm looking for a reliable, communicative individual who can deliver a high-quality...
...diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database design and SQL - Experience with ER diagram creation - A...
We are looking for a programmer to create the search engine for our magento 2.4.6 with Proto Theme website using Algolia search. The programmer has to implement the algolia search engine using his own code following the guidelines published by Aloglia to use it in the main page and in the search results page. It must include the following Filtering by attributes ( brands, specific attributes, color, etc) Keyword filtering Filtering by categories The search results should be displayed in a js block on the home page and in the search results. The theme used in magento 2.4.3 is "Fatest by codazon". Please only serious people, we don't want people who spend half as much time searching as doing the work on stackoverflow. Some examples of how we would like t...
I am an exporter in need of a proactive sourcing agent to help me establish connections with potential buyers in the United States, European Union, and UAE. My focus lies in the exportation of: - Basmati rice (1121) - Guar gum powder Both products are under the category of less than 100 metric tons export quantity. The responsibilities of the agent should include: - Identification and procurement of potential buyers - Market research regarding the demand for these products - Effective communication with buyers regarding product specifications and negotiation of pricing The ideal candidate should have: - Prior experience in sourcing and exporting goods, ideally within the specified regions. - Excellent communication and negotiation skills - An extensive network of contac...
I'm looking for a seasoned AWS Data Engineer with over 8 years of experience to support me in handling data extraction and transformation tasks. Key Responsibilities: - Data Extraction: The engineer will be responsible for extracting structured data held in SQL databases. - Data Transformation: You will be required to transform the extracted data into a usable format for our analytics and reporting. Skills and Experience: - 8+ years of experience as an AWS Data Engineer. - Proficient in working with structured data, in particular, SQL databases. - Extensive experience in data transformation. - Expertise in AWS services, especially Amazon S3 and Glue. Your support will be essential in ensuring the smooth flow of our data processes. Please provide examples of your past ...
I'm in need of a skilled freelancer who can help me implement schema markup for my WordPress website's individual product pages. Key Requirements: - Schema Markup: You should have a solid understanding of schema markup, particularly for physical products. The markup should follow best practices and be properly structured for SEO benefits. - WordPress Proficiency: Given the website's platform, expertise in WordPress is a must. This includes the ability to efficiently navigate and modify the website's codebase. Your Responsibilities: - Implementation: Your primary task will be to implement the schema markup for the individual product pages. This includes ensuring that the markup is correctly placed and configured for maximum visibility and performance. - Testing...
I need a skilled professional to manually upload 1000 products from our online eBay store to our Magento 2 website. Requirements: - The products will include information such as title number, description, images, sku number, and prices. - You need to ensure that the listings are accurately and completely transferred from eBay to Magento 2. - There's no need to optimize images for web before uploading. Simply uploading as is will suffice. - Please use the existing product descriptions. Ideal Skills and Experience: - Proficiency in using Magento 2, including product management. - Experience in data entry and manual product uploads. - Attention to detail to ensure that all product information is accurately transferred. - Ability to follow instruction...
I'm looking for a professional Magento developer who can upload and configure a Magento theme for my new e-commerce website. The website is currently hosted with a provider and runs on Magento 2. We will provide the theme, so there's no need for customizations. Key Responsibilities: - Installing the Magento theme onto our server - Configuring the theme to ensure it works smoothly on our website - Ensuring the website looks consistent with the theme's design Ideal Skills and Experience: - Proven experience working with Magento - Expertise in theme installation and configuration - Good understanding of e-commerce website design - Ability to work with minimal supervision - Strong attention to detail and ability to match design styles
I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration ...be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are high...
i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it
[NO AUTO GENERATED APPLICATIONS… WILL BE DELETED] I need someone familiar with affiliate marketing programs and sites. Someone that can find me some good affiliate products for me to ask. I'm hoping you can find impressive products that have potential to go viral. Tell me some good affiliate products into Instagram. You will search programs like Clickbank, Sharesale, etc. In your application tell me about some products that you have found for clients. Have you ever sold affiliate products through Instagram?
I'm looking...an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...
...availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen courier to confirm the shipment. Automate File Transfer Based on Client and Project: Implement a system that automatically transfers the transport query from one file to another in the local drive based on the client and the current project folders. Project Goals: Automate Courier Selection: Develop a way to automatically select suitable couriers from the database based on predefined criteria (distance, size, location). Automate Communication: Automate the process of contacting couriers via Outlook, including sending inquiry emai...
I'm looking for an Affiliate Marketing professional who can aid in boosting sales conversions through my content marketing blog site. This will involve promoting a variety of digital products such as eBooks and courses. Key Responsibilities: - Manage all aspects of the affiliate marketing program - Identify and implement strategies to increase sales conversions - Monitor blog content's performance and make necessary adjustments Ideal Candidate: - Proven experience in affiliate marketing, particularly in content marketing and conversion optimization - Strong understanding of the Digital Products sector - Demonstrated ability to achieve sales targets - Ability to analyze performance data and implement improvements - Strong communication and collaboration skills
We need an experienced Magento developer to assist with updating third-party extensions when conflicts arise due to newer php/mysql versions. Timeline: Start on the first project on 20th May using remote desktop tools like UltraViewer or AnyDesk for real-time collaboration. Bidders must be highly proficient in Magento 2.4x.
...Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL and Database Monitoring Skills - Experience with WYSIWYG Template Management - Previous experience in PDF generation applications - Knowledge of Windows Application Development Additional Notes: a. application will need to determine which template to use based on a query b. Must be able to create, edit templates in an easy wysiwyg way. c. naming convention based on db record. d. Ability to add an option password to the PDF required. e. The resulting PDF must be stored in up to 2 locations (one maybe a unc path with username and password required) f. must be able to use multipl...
I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused
A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...
