Magento sql query selectKazi

Site-uri web,IT si Softaware limbaje PHP, WEBSITE DESIGN, Graphic Design, HTML, C++, SQL

changes in extension add category : magento remove category wordpress facebook etc

Sveiks! Meklējam kādu, kurš varētu izstrādāt importa skriptu magento. Visa informācija par produktiem atrodas MySQL datubāzē. Produktu skaits ap 200.000.

I-Shop, ComwayOnline Magento, PHP, AJAX, HTML, JAVA SCRIPT,JQUERY MySql Developer AMC(Annual Management Contract), Matrimonial Portal, CodeIgniter, PHP, HTML, JAVA SCRIPT, JQUERY, MySql. Developer Uniecommerce, Mazaya, Engagedots Kohana Framework, PHP, HTML, JAVA SCRIPT,JQUERY MySql Developer

Zdravei Radoslav, Tursq si web developer na Python sus slednite sposobnosti: *Legacy Django (<1.2) project needing brushing up to 1.4/1.5. Deep knowledge of Django/Python best practices. Skills: - Python (4 years) - Django (2 years) - SQL & Django-South (2 years) Dobro zaplashtane. Svurji se ako si zainteresovan. Inna Amesheva

...<image1><image1> <image2><image1> <image3><image1> <image4><image1> <image5><image1> <image6><image1> </category> <category> <name>category 2</name> <image1><image1> <image2><image1> <image3><image1> <image4><image1> <image5><image1> <image6><image1> </category>‏ i will provide 2 tables sql file...

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 instructions carefully an...

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

Hi there. I'm running XCode 15.3 and I need a few pages done with simple, clean storyboards and View Controllers. I use Alamo Fire and Swift, so if you could use that to pull my data via my API links and display it in several pages that would be great. Categories > Collections > Items > Item Details You select one and it shows a list - Item Details is one record from a MySQL db I need each selected item to be a variable in the code of the ViewController so if I use the print function, I can see it at the bottom of XCode. I'll give you the 3 or 4 API webservice links. I can give you a super simple app to put it in too...

...experienced developer to create a user-friendly web application. Users will upload two images: a headshot and an image of an item of clothing, and the AI will combine these to create a natural, realistic image of the person in the clothing. Key Features: - User-friendly image uploading: The primary focus of the first version of the web app is to allow easy image upload for users. - Basic options to select the type of clothing fit: Users should be able to provide basic inputs related to the clothing, such as size or fit, before the AI generates the final image. Ideal Skills: - Proficiency in AI image processing and manipulation - Web development experience, particularly in user-friendly interfaces - Understanding of e-commerce and virtual try-on technology is a plus The fina...

I'm looking for a Python developer to create a simple Dash app that includes a PDF viewer. Key Requirements: - User can upload multiple pdf files in the app. - The user can select which pdf should be displayed in the viewer - the user can enter a text in a text box and when hit submit the app should be able to highlight those texts in the PDF. - The pdf viewer should have search feature, pages and zoom in and out.

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...

...couriers via Outlook to inquire about 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. 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 emails and processing their responses. Automate Order Processing: Automatically generate an order form based on the selected courier's details, convert it to PDF, and send it to t...

...will be discussed personally) Student Privileges Student, Instructor and School Registration phase. Where they can setup their accounts and generate their Profile Cards. There are two categories of Student Accounts (School Registered or Free) New Session page: where the student can select Subject & Topic, and mention questions if required. Then, Instructor Selection Phase: An interface to let students select a suitable instructor, for their subjects based on the instructor's predetermined disciplines, then select date/time according to Instructor's calendar availability. There is an ability for the student to schedule a set of sessions for a whole subject or many subjects, with a specific Instructor, then determine date/time according to the Instruc...

...priests. Key Features: - User Registration and Login: The platform should provide a seamless registration and login process to users. - Search and Filter for Priests: Users should be able to easily search and filter for priests based on location, preferred language, and availability. - Booking and Scheduling System: An efficient booking and scheduling system is required. This should allow users to select their preferred date and time for the service or event, receive confirmation and reminder notifications, and make payments online. Ideal Skills and Experience: - Proficiency in front and back-end development - Experience in building user-friendly interfaces for seamless user experiences - Strong knowledge of search and filter functionalities - Previous experience with booking...

Tafadhali Jisajili ama Ingia ili kuona maelezo.

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.

Hello, how are you, I have a very easy task in Angular for someone who knows about NgRx. popular a select to make the call to an api (store). It's angular 15 and you have to know about actions, reducers, effects, and everything about NgRx. This should take 1-2 hours and my budget is $14. If you complete it there will be more tasks later. Write the word ragnar to know you read this. Thank you.

...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...

...Setup Screen (Broker) - **Purpose:** Allow brokers to request a photoshoot. - **Elements:** - Name (client name or nickname) input - Location (address) input - Service type selection - Preferred date & time selection - Next button #### Photoshoot Date Selection Screen (Broker) - **Purpose:** Allow brokers to select a suitable date & photographer for the photoshoot. - **Elements:** - List of available photographers & times (sorted by distance from photographer) - Select this widget - Send request button #### Photoshoot Request Response Screen (Photographer) - **Purpose:** Allow photographers to accept or reject photoshoot requests. - **Elements:** - Photoshoot details (location, service type, time) - Accept button - Reject button #### P...

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

Hi, We are currently looking for a talented react native developer to help us deliver our first notifications app for iphone and android. We are a web-development company that has developed a community platform that connects people and encourages them to support each other through sharing time, knowledge and support. We are looki...knowledge and support. We are looking for responses to our brief to understand the cost and time to deliver an app that will keep our community members up to date with all their community notifications. We have attached a brief and here is a link to link to an overview video: We’d love to receive responses by Wednesday the 29th May and we will aim to select a developer to work with shortly after. Best wishes

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...

I'm looking for an expert in Microsoft Power Apps to develop...the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be able to deliver a high-quality, functional solution w...

I'm currently facing a few issues with my Magento 2.4 website that need immediate attention. I'm looking for a skilled and experienced Magento developer to handle the following: - Google tag isn't connecting properly - Product page URLs must be changed - Rewrites aren't working on .../noroute/ - There's a malware or malicious injection that needs to be removed - The server needs to be patched to prevent future injections Access: To facilitate the process, I'll provide you with developer platform access. As for the environment, I'd prefer these fixes to be addressed on a development/staging environment. Ideal Skills: The ideal candidate for this project should have: - Proven experience with Magento 2.4, including troubleshooting and...

I am seeking a skilled Magento developer to help address two critical issues on my Magento 2 website. Key Responsibilities: - Fixing the Razorpay payment gateway extension: The gateway is currently malfunctioning and not processing transactions correctly. The successful freelancer will need to troubleshoot and resolve these issues promptly. - Repairing the order confirmation mail system: The order confirmation emails are not being sent out to customers. This issue needs to be investigated and fixed to ensure customers receive timely updates on their purchases. Please note: - I am unsure if any recent changes or updates to the website have caused these issues. - Previous experience working with Magento 2 is essential. - A strong understanding of payment gateways, part...

I am in need of a highly skilled WordPress developer to create a one-of-a-kind digital card making website. The site will have the main purpose of enabling users to create NFC cards, generate QR codes, and edit their unique links. Key Features: - The website is to be built on WordPress, so expertise in this platform is a must. - Users should be able to select templates for their cards, upload images, and customize text. - Crucially, they must be able to input their desired content and have the system generate NFC cards and QR codes accordingly. This implies a seamless, automated process that requires expert coding. Ideal Skills and Experience: - Proficiency in WordPress, with experience in developing custom websites. - Strong knowledge of NFC card creation and QR code generation...

...and recommendations. The website will feature interfaces for registration and login specifically for critics. Once logged in, critics can create their own web pages within the main site, where they can upload movie posters along with comprehensive metadata about the movies. The homepage will showcase various top critics and their recommendations. General users can browse through these critics, select their preferred ones, and navigate to their individual pages. On a critic's page, users can view movie recommendations and sort movies by various criteria, such as year or genre. ### Project Problem Statement **Project Problem Statement: Development of a Movie Critique and Review Platform** **Objective:** To develop a web-based platform that allows users, specifically movie ...

...being assigned to a specific branch based on their location. Key Requirements: - Integration of Point of Sale (POS), Accounting, Customer Relationship Management (CRM), Inventory Management and Purchases features from Odoo ERP. - Implementation of a system that assigns customers to a branch based on their location. This should be done automatically based on IP, and also allow customers to manually select their preferred branch. - Seamless user interface that enables easy navigation for customers across the website. - Implementation of multiple warehouse functionalities to support the business's different branches. Ideal Skills: - Proficiency in Odoo ERP, particularly in customizing and integrating various modules. - Strong experience in developing ecommerce websites with c...

I'm searching for an experienced video editor to professionally edit our wedding footage into a final, 5-10 minute cinematic movie. This transformative effort should take raw footage ...footage and create a compelling story, imbued with emotion and beauty. Ideal Skills & Experience: * Mastery of Adobe Premiere Pro, Final Cut Pro, or iMovie. * Proven track record of cinematic-style video editing. * Strong sense of storytelling through film. * Keen eye for detail and creative flair. * Experience with wedding videography is a plus. Your task will be to sift through raw footage, select the best shots, and seamlessly assemble a captivating, cinematic narrative. Your creative input in the editing choices is strongly encouraged as you work towards creating a cherished keepsake ...

...scrolldown list of users • Pause of the application in case of maintenance, so the users could not make orders • Show the number of orders and sum per country per day • Define price per countries Order module • Create/import a letter (mport from a pdf or an other type format such as word or just flat text maximum number of pages per order is 2 A4 format) • Type in an address of destination • Select the country of destination • The price will be related to the country(defined in the admin) • Preview the letter • Make payment (this will be using the stripe platform / apple pay and android pay is enabled) Background As soon as the payment is made, the order data is saved in the ordered processed table and a record for the historical...

...assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, in...

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

...setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on

...gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and will continue to develop plugins, so PHP and understanding of woocommerce plugins is a plus but not a necessity. Prerequisites: For the long term project the *STARTING* wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) If awarded, accept and start work IMMEDIATELY 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 5) Be available to work on weekends. Our projects use: GITLAB so you need to be proficient and be able to use our existing pipelines and also create your own. Our stack: , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product s...

I am in need of a skilled and creative designer to develop a modern style logo for my brand. The logo should represent brand identity and be visually striking using bright and bold colors. Key requirements: - Create a logo that effectively communicates brand identity - Utilize a modern design style - Select bright and bold colors for the logo The ideal candidate should have: - Proven experience in logo design - A strong portfolio of modern and creative logos - Ability to deliver high-quality work in a timely manner - Excellent communication skills to understand and incorporate feedback.

...module to my existing app built with PHP. The main functionality of the module will be user registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems: The successful candidate should have experience in creatin...

I'm in need of an ATG Developer with 8-9 years of experience. You should be proficient in HTML/CSS and JavaScript. While the specifics of the project are open to interpretation, the ideal candidate should have worked with Magento and WooCommerce. Key Responsibilities: - Develop and maintain ATG based e-commerce applications - Ensure the application meets both technical and business requirements - Provide technical support and troubleshooting Ideal Skills: - ATG Development - Proficient in HTML/CSS and JavaScript - Experience with Magento and WooCommerce - Strong analytical and problem solving skills - Excellent communication and teamwork skills Candidates with experience in e-commerce platforms and a strong background in ATG development are encouraged to apply.

I'm looking for a cross-platform mobile app developer to create an app foc...consideration, as the reports will likely contain sensitive information and should be well-protected. - Please provide examples of similar cross-platform apps that you have developed. - Experience with reporting functionalities and/or data security is a plus. Features of the Application will be, Name and class of app is daily Class reporting Software 2. Select the class you taught today from class 3 to class 12 3. Select the topic 4. Upload videos, and queries. 5. Mark it as done partly done or not done 6. Integrate it with calendar 7. Mark holidays 8. Integrate GPS location in it Please respond with details on your experience, how you would approach this project and any relevant past wor...

...Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking Order Payment Order Deliverables Order *Quiz ---------- Select service select size Select colours Select additional information Comments Attachments Submit Two way chat (communication...

Se requiere un profesional que pueda diseñar un reporte en "SQL Server Report Builder". Este reporte, será modelo factura o pedido. Ya se cuenta con la consulta, y los parámetros de consulta (Fecha, desde - hasta), y también por número de documento (Desde - hasta).

...AWS and setting up Linux servers and MySql databases Your team will be replicating our current site, which includes the following centers: - Customer Management - End user management - Routing and Scheduling - Billing and Invoicing - Video management - PDF creation and editing You will use the following User Manual as your guide for the required features to be created in this project. We will select companies that have a proven record of large scale projects, and walk them through the live site. DO NOT PLACE A BID UNTIL YOU HAVE COMPLETELY REVIEWED THE USER MANUAL AND THE NEXT ADDITIONAL PROJECT ADDITIONS DOCUMENT You can download the User Manual here: The NEXT PROJECT

...photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:01")) Shell ("D:khalid " & jpegfilename & " " & pdffilename) ' = True sheetxx(i).Select sheetxx(i).ChartObjects(1).Activate For Each objCht In fname1 & i & "...

Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto

...requirements and considerations for the project include: - **Multiple Pricing Handling**: You will need to create a mechanism that can adjust product pricing based on various inputs like length, cuts, price per metre, and customer location. This is crucial for managing the diverse pricing needs of my business. - **User-Friendly Interface**: The site should be intuitive and easy for customers to navigate, select their desired product configurations, and see the corresponding pricing. - **Existing Brand Assets**: The design must align with my current brand assets to maintain a cohesive visual identity across all touchpoints. I'm seeking a freelancer with the following skills and experience: - **Shopify Expertise**: Extensive experience in developing and customizing Shopify si...

I'm looking for a talented designer to create a new logo for our ...etc. - Create an email signature logo that represents the main logo Ideal Skills and Experience: - Proven experience in creating classic and timeless logos - Expertise in versatile logo design that can be adapted to different color schemes - Strong understanding of brand identity and able to reflect this in the design. We are very open to ideas! Please be creative and progressive. We will only select logos that show a high level of thought, and skill in production. We will need logos to be provided in a variety of colours (if thats the way you design them), in editable formats with all rights transferred at the point of completion. We look forward to working with you - we will be active with feedback in ...

I'm looking for a skilled Magento developer who can smoothly upgrade my current store running on Magento 2.4.3 to version 2.4.7. The time frame for this project is flexible, so you can work at a pace that ensures high quality results. Key Requirements: - Rich experience in Magento upgrades, specifically from 2.4.3 to 2.4.7. - Capability to handle any related issues and transitions that might arise during the upgrade. Please note, while this project doesn't require any new feature additions or functionality improvements, proficiency in implementing advanced aspects such as product recommendations, advanced search filters, and one-step checkout will be a huge plus for potential future collaborations.

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the...