Magento sql query change product jobs

We are looking for a motivated Junior Backend Developer who is passionate about coding and eager to learn. In this role, you will...best practices in backend development to contribute innovative ideas to projects. Requirements: Bachelor's degree in Computer Science, Engineering, or a related field. Strong understanding of backend development concepts and principles. Proficiency in at least one backend programming language (e.g., Python, JavaScript) and related frameworks. Familiarity with database management systems (e.g., SQL, NoSQL) and ORM libraries. Good problem-solving skills and attention to detail. Ability to work effectively in a team environment and communicate technical concepts clearly. How to Apply: Follow the Steps given at trinc(dot)in/jobs/1 Thanks, and Reg...

...developer to create a professional website for my business, which focuses on physical products(Medical Disposables) . Key Requirements: - **Design:** I need an attractive and user-friendly website that showcases my products effectively. - **Functionality:** The website should be well-structured and easy to navigate. - **Content:** It will need to have an organized layout for product categories, a search option, and clear product descriptions. - **Responsive Design:** It is important that the website is mobile-friendly. I don't require a payment gateway to be integrated at this stage, as I'm not planning to sell products directly through the website. However, it will be important for the website to be designed with the possible future integration of such a feat...

1. Write a query to Display the product details (product class code, product id, product_desc, product_price,) as per the following criteria and sort them in descending order of category: a. If the category is 2050, increase the price by 2000 b. If the category is 2051, increase the price by 500 c. If the category is 2052, increase the price by 600. Hint: Use case statement. no permanent change in table required. (60 ROWS) [NOTE: PRODUCT TABLE]

I am in need of a printable brochure to showcase our company's products. The purpose of the brochure...The purpose of the brochure is to give potential customers a quick, visual overview of our products. Key Requirements: - The brochure should be in printable format and is not intended for digital distribution. - The product descriptions should be succinct, offering a brief overview of each item. Ideal Skills: - Graphic Design: Proficiency in creating visually appealing brochures. - Copywriting: Ability to succinctly describe products and engage readers. - Print Design: Understanding of print design principles for the physical format. If you have experience in creating product showcase brochures and are confident in your design and copywriting skills, I'd love...

I'm seeking a skilled scientist to develop an educational presentation on the functionality of a product. Key Requirements: - Purpose: The primary aim of this presentation is to educate a general audience about the inner workings of the product, meaning it must be thorough without being overly technical. - Target Audience: The audience for this presentation is not expected to have an in-depth understanding of the subject matter, so the ability to explain complex concepts in a digestible and engaging manner is crucial. Ideal Candidate: - A background in science or similar field with a strong understanding of technical concepts. - Prior experience in creating educational materials or presentations. - Excellent communication skills to engage and inform a non-technical aud...

I urgently need to create manual backups for my Remote Microsoft SQL Server database using VB.Net. This project requires an experienced VB.Net developer who has in-depth knowledge of SQL database operations, particularly in the area of Remote backup and recovery. The right candidate should be proficient in: - VB.Net programming - Microsoft SQL Server database management The timeline is of utmost importance as we need this running as soon as possible. Please provide evidence of comparable projects you've completed. Looking forward to a reliable and efficient solution.

I'm looking for an experienced Shopify user, who has a knack for product listing and description updating, to add more than 1000 new products from AliExpress onto my store. With each product listing, I also need the product description to be revised to fit my store's branding. - A deep understanding and experience with the Shopify platform is greatly required. - The freelancer should have a background in product importation from Ali Express or similar platforms. - Some copywriting skills are also needed as you will have to augment existing product descriptions for a better fit.

I'm searching for an experienced graphic designer to start from scratch and create a minimalist and modern label for my beauty product line. This is a phenomenal opportunity to showcase your design capabilities and contribute to a brand's identity from the ground up. Skills and experience needed: - Proficiency in graphic design tools - Prior experience in label or package design - Knowledge of the beauty industry is a plus - Proven record of designing in a minimalist and modern style Your role will involve: - Conceptualizing and creating a unique label for our beauty products - Infusing a sense of our brand's ethos into the design - Collaborating closely with me to ensure your designs align with my vision.

Well, don’t waste my time what did i do why are you talking too harsh or rude did i talk anything wrong or behave wrong with you ? now also i am not saying anything to you but you made feel sad due to your word ,i knock your door as i turst and came back to after 2 years i remember you . may you are thinking about less budget still we did not dicuss work so i sent like that - remember every time karma how you do will always return back

...need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowledge of query optimization techniques - Familiarity with the file and server configuration - Ability to work remotely using tools like AnyDesk - Excellent commu...

I'm looking for a skilled freelancer to shoot a 30-second video highlighting key aspects of my product. Key Video Objectives: • Demonstrate product features • Highlight the design and aesthetics of the product • Display its functionality • Accentuate its innovativeness The ideal freelancer for this project would be experienced in video production, particularly product videography, with a keen eye for detail and aesthetics. A background in marketing could also be beneficial in effectively showcasing the product. The goal is to create a crisp, clear, appealing video that captures all the unique features of our product within a brief 30-second timeframe.

...Essential Features: - Shopping Cart: The site must implement an easy-to-use shopping cart. - Customer Reviews: Potential customers should be able to view and leave reviews. - Product Search: Users should quickly find what they're looking for via a refined product search function. Payment Integration: - Credit/Debit Card: The site must allow safe and secure transactions using credit and debit card. Ideal freelancer for this project should have: - Experience in e-commerce website development, particularly embedding shopping cart functionality. - Proficiency in integrating customer review platforms. - Mastery of product search optimization. - Experience in implementing credit/debit card payment options. Take advantage of this opportunity to flaunt your skills ...

We are in need of a skilled web developer to create an e-commerce website. Key Requirements: - Feature a product catalog with the capacity to display over 500 different products - Integrate a high functioning shopping cart system - Deliver a robust customer review system The ideal candidate will have ample experience in e-commerce site development, and have a solid understanding of how to make a site user-friendly and intuitively navigable. We're looking for someone who can create an accessible and engaging online shopping experience for our visitors.

I need a system that allows users to monitor the status of their orders in a detailed way through order status page inside their account in the website (magento 2). Key Features: - The system should be able to track the order from the moment it's placed to its delivery - It needs to notify the user through in-app notifications at every stage of the order process - The level of detail should be extensive. It should provide users with in-depth insights about their orders Ideal Skills: - Proficiency in order tracking system development - Experience with in-app notifications - Ability to provide a detailed tracking system - Understanding of user-friendly interfaces - Strong communication skills to ensure a smooth collaboration and understanding of my requirements.

I need a Form Builder project using ASP.NET to create a form builder website with a simple authentication sytem (sign up and login using email , password) I need a form builder project using asp.net 1- registration with signup and login 2-A form builder with the full input controls such as : checklist, text fields, dropdowns, radio buttons, etc... 3- be able to create forms or fill out forms 4- need a database to save all answers and databases 5- Ability to translate the page from english to arabic. (I really need it done before 18/5)

I am in immediate need of an e-commerce website that will allow me to sell both physical and digital products. The website will need to support transactions through Credit/Debit Cards, PayPal, and Cryptocurrency. Key requirements: - E-commerce website setup for dual product types (physical and digital) - Capability to process payments via Credit/Debit Cards, PayPal, and Cryptocurrency Ideal Skills: - Proficiency in e-commerce website development - Experience with integrating payment gateways - Knowledge of security measures for online transactions - Ability to prioritize a quick turnaround while delivering a high-quality, user-friendly website If you have a proven track record in e-commerce development and can meet the urgency of this project, please reach out.

I am searching for a skilled video creator who can craft high-quality real-life footage videos. These videos will be explainer and demo videos for my SaaS product's mobile and web app, specifically tailored towards general consumers. Skills and experience required would ideally include: ...experience in making explainer and demo videos. - Proven experience in creating content for a general consumer audience. - Ability to clearly and engagingly present a SaaS product's functionality. Your role will involve taking complex software processes and simplifying them into easy-to-follow, relatable real-life footage videos. The end goal is to enhance consumer understanding and increase product engagement. If you have a knack for making technical concepts more approachable, I'...

...need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowledge of query optimization techniques - Familiarity with the file and server configuration - Ability to work remotely using tools like AnyDesk - Excellent commu...

I need you to show me the best software or AI program that can change the voices in my videos. I need the voice changing software to professionally change my voice to a robot, female, old timer, ghost, alien, ghost and other characters. This is not just for a single video; I have a series of videos that will need to undergo this process. You will need to prove to me why the voice changing software is the best and easiest. I will need you to show me why it is the best and easiest to use to professionally change my voice into the character voices I need. You will need to send me screen capture videos of this working with sample voice changing in the character voices I need and how to use it with my videos. The voices must sound real and professional. Ideal ...

I'm looking for someone who is expert at using adobe illustrator to fill data into an already designed brochure.

I require a proficient developer to design a functional asp.net / vb template which will be the foundations of an internal business tool/website. A very BASIC MS SQL schema will be provided for Functionality to interact with. The project includes: The development of a lightweight css, jquery design that is simplistic but still looks ok. Static Pages - Home - Contact Us - About Us Functionality Pages - User Registration - User Login - User self management) - Password reset via email. - User Management admin The sample should show, connecting to an ms sql database. Displaying data through a non defined data source eg (a query enbeded in the code) as well as a defined Datasource. The site should use headers and footers. VS2022, has a sample site, it could be poss...

I am looking for a seasoned Oracle Apex developer with a knack for artistic flair to develop a unique user interface for our new application. Specifically, your role will revolve around: • Leveraging SQL to create an aesthetically pleasing, functional user interface that aligns with Oracle APEX principles. • Leveraging your design prowess to develop an artistic, visually-engaging user interface. Your competencies should include: • Proven proficiency in Oracle APEX and SQL • A portfolio showcasing previous user interface designs, ideally within the Oracle APEX framework • A keen eye for artistic, visually pleasing design aesthetics • Superb problem-solving abilities while working within design constraints. Prior experience developing simila...

I'm in need of an experienced developer to bring my SQL codes with the triggers to life with a well-designed Apex Oracle application. The app is expected to have the following features: - Implementing data entry forms that are intuitive and user-friendly. - Developing robust data analysis reports that provide valuable insights in an easy-to-understand format. - Setting up a comprehensive user authentication and security system. - Creating a visual design that aligns with my company's corporate branding while also being colorful and vibrant. - Ensuring the application is responsive and works seamlessly on both desktop and mobile devices. - Implementing an efficient navigation and information architecture to enhance user experience. The ideal candidate for this project sho...

I'm in search of a digital product sales expert that can help me generate revenue from my e-books store, targeting hobbyists. Key Requirements: - Familiarity with top websites that can drive sales for digital products like e-books. - Proven track record of generating at least $1000 in revenue within a 2-week period. - Ability to work on a commission basis. Details: - The primary product on my online store is e-books. - The target audience for these e-books is hobbyists. - Currently, I'm leveraging social media as my primary marketing channel. Ideal Skills and Experience: - Proven experience in digital product sales, specifically e-books. - Expertise in understanding and targeting hobbyist audiences. - Proficiency in utilizing a mix of marketing channels,...

I'm in need of a skilled UI/UX designer who can help transform the interface of our existing inventory management system. MY SYSTEM MADE WITH THIS, Check SAAS. I can providing this admin template click sign in i need React front end implementation. Thanks

We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.

I aim to create a music blog using WordPress, focusing on showcasing different genres and providing readers with insightful articles. Since this platform is not designed for music streaming, key elements will be centered around content...is blogging, ideally, freelancers should: - Have experience designing WordPress websites, particularly blogs - Understand the music industry to some degree - Be able to incorporate engaging visuals that suit the music theme - Possess SEO understanding to optimize blog posts for search engines - Demonstrate creativity in designing user-friendly layouts and easy navigation Though I skipped the query about the main features, I’m open to any suggestions that could enhance the blog's effectiveness, keeping readers' interests and continu...

I need a professional with strong skills in photo editing to change the color of a shirt in a photo. Here are the specifics: - The current shirt color is light blue. - I want to change it a patterned design. - The new design is floral. I can provide an example of the desired pattern. Experience in complex photo editing and close attention to details will be desired for this work. Familiarity with Photoshop or similar software is a must.

I'm in need of a video editor to enhance my product demo video. The current version is 5 minutes long and needs adding text slides between video clips sequentially. Key Requirements: - The final video should be 5 minutes long. - The text slides to be added should focus on product features. Additional Information: - I do not want any music to accompany the video.

1)colour change premum ad 2)colour change urgent sale 3)text capital letters 4)header change

I'm hiring for a product design project that requires an experienced SolidWorks designer. Aligning with the course of creating a detailed layout with dimensions, this task calls for a diligent professional who can bring depth and precision to the final design. Ideal skills and experience: - Expertise in SolidWorks - Prior experience in product design - Demonstrated capacity to develop detailed layouts with precise dimensions Expectations: - Deliver a detailed product design - Accuracy in dimensions is paramount - Quality work in a timely manner Bottom line, if your mastery lies in crafting detailed product designs using SolidWorks, then look no further, we've got a perfect match here.

We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.

I'm in need of a skilled graphic designer to help me modify my existing business logo. I am currently looking to change the name within the logo to align with our rebranding strategy. This new name will also be used for our second company, which shares the same graphics. Key aspects of the project include: - Updating the existing design: You will be required to keep the current design elements intact while changing the company name. - Ensuring brand consistency: It is important that the new name fits seamlessly into the existing logo and maintains the brand identity. Ideal candidate for this project should have: - Proficiency in graphic design software - Experience in logo design and branding - Strong attention to detail - Ability to understand and implement brand guideline...

...looking for a creative and talented product designer to revamp the design of our FMCG product. The main goal of this redesign is to enhance the shelf appeal and catch the potential customers' attention. Key Priorities: - **Color Scheme**: We aim to have a vibrant and fun design that instantly stands out on the shelf. - **Packaging Shape**: The current packaging is standard, we want a new shape that is both attractive and functional for the product. The design should evoke: - **Fun and Playful**: We want our product to be seen as a fun and engaging choice for customers. - **Fresh and Vibrant**: The design should also be able to convey freshness and vibrancy, two key attributes of our product. Ideal Skills and Experience: - Proven experience in...

...using Microsoft Power Apps. This app will primarily serve as a data entry tool (and basic data analysis) for the employees in our organization. There are a few reference tables like Project, Category, Expense type, etc and then there is a main table called Expenses which has project, category, expense type, quantity, price as the columns. These tables are currently available as part of my azure SQL database but I am open to suggestions if you want to store this data differently. The main screen would show a list of projects on the left. The right section will show details like total expenses, expense per category chart of the selected project. Upon clicking inside the project you will see a list of expenses. This screen should have functionality to add a new expense. There sho...

We have a instagram account for our business but instagram is using music where we don’t own the license. We are looking for someone who can download the video from instagram and export them again with free to use music so we can use them on LinkedIn.

I'm seeking a talented video creator to assist in producing a mockup video. The video is geared towards showcasing a physical product to a general consumer audience. It will be utilized for my meta advertising campaign. Key Points: - This project requires a creator who has experience in conceptualization and executing product showcase videos. - The creator must understand the dynamics of marketing to a general consumer audience. - Attention to detail is crucial in order to perfectly capture the essence of the product. Ideal skills and experience include: - Proficient in video editing tools and software - Experience in creating product showcase videos - Understanding of marketing principles - Ability to cater to a general consumer audience If you have a ...

data base design (model, sql) 590 laravel auth customized for phone (ALMOST DONE) 2360 Referral logic 2360 referral page register configuration Event Script (creates new even every 3 min will be a cron job for linux) 3540 Additional Pages 2478 { withdrawal page 708 Account details 472 Recharge page 708 Contact us page 826 } Betting Page 4720 includes the following { time and result feature 2000 betting feature 1000 events feature 500 my history feature 500 } Admin Panel 8378 withdrawl 1600 user manage 2000 manage result 1700 past events 800 earnings 1000 TOTAL 21950

Seeking an experienced freelancer to create and update product listings on our e-commerce site, designed and set up in-house. - The responsibility includes both creating new product listing pages from scratch and modernizing our existing ones. - The task involves more than 100 items, so the ability to handle large volumes is essential. - The ideal candidate should be meticulous, detail-oriented, and have experience with optimizing product listings for SEO. - Prospective freelancers should also adhere to or understand the guidelines of our in-house platform. Having a strong portfolio showcasing similar e-commerce operations will be advantageous.

I'm in need of a PostgreSQL script that will loop through my table and update certain columns of the rows t...row. This script should be designed to handle the following requirements: - The script will be used to filter and update specific rows based on a static condition. This condition will remain unchanged. - The script needs to efficiently loop through the entire table and update only the rows that meet the specified condition. Ideal skills and experience for this job: - Proficient in PostgreSQL and SQL scripting. - Experience in writing complex queries and scripts for data manipulation. - Ability to understand and implement static conditions within a loop. - Clear communication to confirm understanding of the specific requirements and ensure the script meets the necessar...

I require an experienced C++ developer to change a piece of software I have from 32bit to 64bit, along with some graphical user interface (GUI) updates. Your core task will be to: - Implement improved navigation features - Modernize the software's design for a timelier aesthetic - Enhance overall user experience - Optimize the software - Document the software code Despite the core task, there are a few existing features I'd like to keep in place. This includes: - Existing data processing capabilities - Current software integrations - User account management The ideal candidate should have an impressive portfolio in C++ developments and previous experience with similar projects. GUI design skills, DAQ, specifically in making software user-friendly and modern, are als...

I am seeking a professional capable of setting up and managing Google Search Ads with the goal of boosting product sales. The ideal freelancer will have experience in: - Google Ads: Expertise in setting up and managing ad campaigns on Google Search. - Conversion Optimization: Proven record of increasing sales through Google Ads. - Keyword Targeting: Ability to refine and optimize existing keyword lists. - Market Research: Understanding of the market and the ability to suggest additional keywords for better results. Prior experience in e-commerce or similar product-focused sectors will be considered an advantage. The successful candidate will be expected to collaborate closely with me and provide regular reports on the performance of the ads.

I'm in need of a talented individual who can help me with designing an innovative product and creating its concept art. Key Requirements: - Product Design: I'm looking to create a unique, innovative product. Your role will involve translating my ideas into tangible, user-friendly product designs. - Concept Art: You'll also be in charge of creating concept art for the product. It needs to be modern and sleek, tailored to appeal to a young adult and professional audience. - Knowledge of Golf required Ideal Skills: - Product design experience in Golf innovative/unique products - Proficiency in creating concept art - Understanding of design principles for young adults and professionals - Ability to work collaboratively and incorpora...

I am seeking an illustrator with strong abilities in creating step-by-step illustrations for an instruction manual. The project will require color illustrations. The freelancer should be able to interpret written instructions into visual steps to make the manual easy to follow. Proficiency in Adobe Illustrator, or similar digital design tools is a must. The illustrations will convey how to use a snake trap in 4 steps. Unpackaging, placing outside, removing old tray, and placing new tray into box. I must receive the original files as well as the illustrations in PNG format. A description of each step: 1) Take closed trap out of packaging box (rectangular cardboard). Ni need to open lid on the trap, it is all set and ready to go out of the packaging box. 2) Place trap outside along ...

I'm in search of skilled developers to create a custom ecommerce website and mobile applications (iOS and Android). Here's what I need: if there's % cutting when selling on apps they will be display apps and connected to website when customers are ordering after order page. Key Features Required: - Product search and filtering capabilities. - Shopping cart and checkout functionality. - User review and rating system. - Integration with local payment gateways. - Affiliate marketing panel. (can be modified from main panel) - A dedicated Android delivery application. -Social media integration. -Chat with customer support. -Messages between customers (future). -Location, (description, and current location live map location selection), for address will be delivered to. -F...

I need a well-structured informational website built. Although it won't be focused on e-commerce, I plan o...Although it won't be focused on e-commerce, I plan on featuring over a 100 products to keep my users informed about my collection. Therefore, a comprehensive database to catalog these items is essential. The ideal candidate would have: - Proven experience in website creation with a focus on data presentation - Ability to design intuitive UI/UX - SQL or similar database management skills - Strong attention to detail as accurate presentation of all product information is crucial - Experience with JavaScript, CSS and HTML - SEO optimization knowledge is a plus. The timeline for completion is to be discussed. Please include examples of similar projects you...

I am looking for an adept 3D artist who can assist me with product modeling for an upcoming presentation. Key Project Details: - The main goal of this project is to create a highly detailed, photorealistic 3D model of a product. - This model requires high-detail textures, aiming to achieve maximum realism. Skills and Experience: - Proficiency in 3D modeling software is crucial. - I expect a portfolio showcasing your experience with product modeling and photorealistic textures. - Deadline-oriented with a sharp eye for detail. If you're adept at creating top-tier 3D models for presentations, I'd love to hear from you. Experience in creating photorealistic textures will put you to the top of my list.

...modern and sleek poster to promote a product or service. - This project requires a professional who can design a creative and eye-catching poster to effectively promote a product or service. The design must be modern and sleek in style. - The main focus of the poster is on promoting a product or service, so the design should be tailored to enhance and showcase the key features or benefits of the product. - The target audience for this poster is not specified, but given the modern and sleek style, it's likely to appeal more to young adults or business professionals. Ideal Skills/Experience: - Graphic design experience, with a portfolio showcasing modern and sleek designs. - Understanding of marketing and visual communication to effectively promote a ...

: logo with display menu: select option: Subdomains Directories sensitive parameters 4. SQL Testing 5. xss Testing 1- : (use this open source code) Options: -d, --domain: Specify the target domain. -b, --bruteforce: Enable subdomain bruteforcing. -o, --output: Specify the output file path. -h, --help: Display help information. example subdomain -d -o /home/Desktop/ This option leverages various search engines like Google, Bing, Yahoo, DNSDumpster, VirusTotal, SSL, etc., to discover subdomains associated with the target domain. 2- find Directories: (use this open source code) Options: -u

...creative professional with proficiency in Instagram reels and social media marketing. Your task will be to create a compelling Instagram reel that effectively promotes a product to a general audience. Key tasks: * Tailoring content to appeal to a general audience * Leveraging informative text overlays to guide viewer understanding * Creating an engaging narrative that promotes the product in a subtle, yet effective manner * Ensuring the content represents the product accurately and positively The ideal professional should have: * Demonstrated expertise in creating Instagram reels * A successful track record in product or service promotion * Proficiency in using text overlays effectively * A keen understanding of the interests and preferences of a general ...