Magento product sql query jobs

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.

I'm looking for a graphic guru who is able to create mini web banners that will be utilized for promoting a product. bid only if you can start right away

...than $100 use Oracle PL SQL teach me how to free install on my local windows 11 you have 2 days to do use SQL to calculate per day summary for each day for each product for each store for 3 years suggest your columns also more needed columns will be provided simulate tables with store transactions take to account - promotions -store location -state -usa holydays simulate lookup tables for 1 promotion 2 store locations 3 prices changes each 3 months etc at least data simulation may be done in python and then upload to SQL DB (but better in SQL) you provide both sql and python code data for 3 years 100 proudects 20 stores 5 usa stsates randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 tran...

I would like to design a program (bot) that will find a specific product on the website, add the product when it first becomes available in stock, add to the shopping cart, then automatically check out the item with the corresponding profile assigned for billing and shipping information. The drop date for the product is set for the 24th of this Friday as I would need this completed prior to the drop date.

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

I'm aiming to develop a physical product intended for commercial use within the food and beverage industry. A good understanding of wiring circuits and plastic moulding is important for this project. This is a one off design project. Skills and experience required: - Experience in electrical wiring work The success of this product will largely depend on its usability in the retail environment.

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

I am looking for a product designer to enhance the packaging of my packaged drinking water product. The primary goal of this project is to refresh the product's packaging, making it more contemporary, appealing, and user-friendly while maintaining a minimalist and clean style. Key Requirements: - Experience in packaging design, particularly in the consumer goods industry - Proven track record of creating minimalist and clean designs - Familiarity with product packaging for beverages or similar consumer goods is a plus The ideal candidate should be able to understand the essence of minimalism and apply it effectively to the water packaging design. They should also have a strong understanding of the consumer goods market and be able to create a design that stands ...

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

I'm in need of a creative and impactful advertising model tailored to promote a new product targeted towards young adults, aged 18-30. This campaign should gravitate around a compelling call to action - "Buy now and get a discount". Ideal Skills and Experiences: - Proven experience in marketing and advertising strategies - In-depth knowledge of the youth market trends - Strong ability in crafting promotional messages - Creative thinking and attention to detail. This project requires a clear understanding of consumer psychology, particularly within the young adult demographic. Ultimately, the goal is to boost product sales and create a robust customer foundation.

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 in need of a skilled website developer to create an ecommerce site. The website will be focused on selling physical products and will have less than 5 product categories. Key Requirements: - The site should incorporate a clean and user-friendly interface to enhance customer experience. - I require the integration of payment gateways for credit card and bank transfer. Ideal Skills and Experience: - Proven experience in developing ecommerce websites, particularly those focused on physical products. - Proficiency in integrating payment gateways, especially for credit card and bank transfer. - Strong understanding of user interface design to create a visually appealing and easy-to-navigate site.

I'm in need of a marketing specialist to help with a B2B product marketing project. The main objectives for this campaign are: - Increasing brand awareness - Generating leads - Boosting sales Your focus should be on creating an strategy with clear execution steps and compelling content to update the website and also for email and content marketing channels. Experience and skills needed: - Refine the messaging for our company website - Proven track record in B2B product marketing - Expertise in email and content marketing strategies - Strong understanding of optimization for these marketing channels - Ability to create relevant, impactful content that resonates with business clients Your task will be to help me reach businesses effectively and persua...

I'm looking for a talented web designer with a proven track record in creating engaging and effective landing pages. The main purpose of this landing page is to advertise a product/service to a wide audience, including both general consumers and business professionals. Key Requirements: - Engaging Design: The landing page needs to immediately capture the attention of visitors and effectively communicate the value proposition of our product/service. - CTA Optimization: Strong calls-to-action (CTAs) and well-thought-out user flow are essential to encourage conversions. - Mobile Responsiveness: The landing page should be fully responsive and optimized for mobile devices to ensure a seamless user experience across all platforms. - FIGMA - First Design in Figma then implemen...

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 seeking a skilled web designer to create a minimalist-style website devoted to my skin care product. The website will be informational rather than commercial and needs to have three specific pages: 1. Home Page 2. Product Information Page - Needs to highlight detailed information about the product's ingredients, benefits and usage instructions. 3. About Us Page The ideal candidate would have proven experience in minimalist web design and a keen understanding of user-friendliness. Expertise in SEO would be a plus, helping to ensure visibility of the website. Being passionate about skincare and conveying this passion through design would be a bonus. Applicants should have a good grasp of developing engaging content and a refined eye for layout to provide an exce...

...page that focuses on promoting my product. While I have some branding elements like color schemes and logos, I'm open to creative interpretations within this framework. Key Requirements: - The main objective is to showcase the features of the product in an engaging and visually appealing way. - The landing page should also have a contact form integrated for lead generation and customer inquiries. Ideal Candidate: - Previous experience in creating engaging and conversion-optimized landing pages is crucial. - Strong understanding of user experience and design principles. - Ability to work within existing branding guidelines while adding a creative touch. Please provide examples of your previous landing page designs and any relevant experience in product prom...

As a burgeoning Amazon seller, I'm seeking a virtual assistant with specific skills and experience, primarily around product listing. Key Responsibilities: - Listing Optimization: Your primary role will be to optimize listings, ensuring they are well-crafted and keyword-rich to enhance visibility and sales. - Product Research: Assistance in product research to identify trending products, their competition, and potential for success is a plus. - Inventory Management: Basic inventory management skills are a bonus, but not mandatory at this stage. Ideal Experience: - Amazon Listing Experience: The ideal candidate will have a proven track record of successful Amazon product listings. - E-commerce Knowledge: Familiarity with e-commerce platforms and trends is ...

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.

...freelancer to produce a set of sophisticated image assets for my Amazon product page. These will range from different styles such as product images, lifestyle images, and infographic images. My product falls under the fashion/wellbeing category and the aim is to distinctly communicate its features and benefits. * SKILLS AND EXPERIENCE: - Expertise with photo and image editing tools - Keen understanding of the fashion/wellbeing industry - Prior experience creating Amazon product images The project will greatly benefit from an individual who is highly attuned to style and aesthetics since we're going for a high fashion/wellbeing look and feel. It's essential to me that the images reflect the luxury and quality of the product, alig...

...PowerPoint design geared towards potential customers. This presentation is focused on marketing, specifically promoting our products and engaging our target audience. To make this successful, I'm looking for professionals with relevant expertise and who can capture the essence of our brand, transforming it into a visual story. The key elements within the project include: 1. Product Promotion: Exemplify our product benefits persuasively and compellingly. I need someone who can design slides that make our products stand out. 2. Customer Engagement: Our presentation needs to resonate with potential customers. It should be attention-grabbing, stimulate interest and incite action. Skills and experience ideal for this job: - Expertise in PowerPoint design and pre...

I need help showing on the front end of my website on a product a display of options using a shopify app called VO Product options.

I'm seeking a skilled sales professional to help me expand my customer base in both B2B and B2C markets. Key Responsibilities: - Generating leads and converting them into customers across B2B and B2C segments - Using telemarketing as a primary digital marketing channel to reach potential clients - Developing strategies to penetrate new markets and increase the reach of our vaping products Ideal Skills: - Proven experience in B2B and B2C sales, preferably in the vaping industry - Proficiency in telemarketing and understanding of its efficacy in digital marketing - Strong analytical skills to identify market trends and opportunities for expansion - Excellent communication and negotiation abilities to secure new partnerships and deals If you have a strong sales background and are con...

...for a product demonstration. Key Requirements: - **Slide Count:** The presentation will consist of 10-20 slides, so it's important that the designer can effectively communicate the product's features and benefits within this scope. - **Branding Guidelines:** While I do have specific branding guidelines, they're focused on colors and logos alone. The ideal freelancer will be able to incorporate these elements into the design without compromising the overall quality of the presentation. The ideal candidate will have: - Proven experience in creating professional, high-quality PowerPoint presentations. - An understanding of how to structure a presentation for a product demonstration. - Strong design skills and attention to detail. - Good communication skill...

I am in need of a PrestaShop expert to assist with the specific task of importing products via cvs into my PrestaShop store. The ideal freelancer for this project should: - Have proven e...via cvs into my PrestaShop store. The ideal freelancer for this project should: - Have proven experience in working with PrestaShop - Be highly proficient in importing products via cvs into PrestaShop - Be well-versed with the complexities of ecommerce product data The product data that needs to be imported is relatively simple, including basic details like product name, price, and category. In your application, please include your experience working with PrestaShop and specifically with product imports. Your experience in managing product data in e-commerce plat...

I need a new online form integrated into my website specifically for ordering physical products. The form will serve as a basic order form for the products I offer. I would also like to add pictures to my carousel. Key Requirements - The form should support ordering of physical products only, no digital products or services. - It should be designed in a way that is user-friendly and easy to navigate. - The form should work seamlessly, with no bugs or technical issues. - The form will not include any payment integration as I will be handling payments separately at this time. Ideal Skills - Web development experience, especially with forms and e-commerce. - Proficiency in HTML, CSS, and JavaScript. - Experience with integrating forms into websites. - Attention to detail to ensure a ...

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

...developer who also has experience managing eCommerce platforms such as Flipkart and Amazon. The primary task is creating a website from scratch intended for product sales, with clear and appealing design, optimised for conversions and customer ease of use. Key Tasks: - Design and construct a new website for product sales from scratch. - Optimize for user-friendly navigation, SEO, and product presentation. The ideal freelancer for this job will have: - Proven experience in creating successful eCommerce websites. - Strong knowledge of site design, user experience, and SEO principles. - Previous experience managing Flipkart or Amazon product listings is beneficial. - Understanding of inventory management on eCommerce platforms. Make your bid if you are pas...

I'm in need of a Shopify expert to enhance my store's theme with new sections and features, particularly incorporating custom product options. Key Tasks: - Enhance and extend theme: I need a professional to not only customize my theme but also add new sections and features to it. - Custom product options: I'd like to integrate custom product options to my store. These options should allow my customers to personalize their purchase as they wish. Ideal Skills: - Extensive Shopify experience: I'm looking for someone who has a deep understanding of Shopify and has previously worked on enhancing and extending Shopify themes. - Strong grasp of product management: The freelancer should be adept at setting up and managing products on Shopify wit...

We require our assembly video redoing as we have had to make some alterations to the product. I have attached our current video which we basically want the same thing but using the new footage. Please mo silly nods and I would like to see examples of similar videos you have done. Thank you

[NO AUTO GENERATED APPLICATIONS… WILL BE DELETED] I need someone familiar with affiliate marketing networks 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. REQUIRED: In your application tell me about some products that you have found for previous clients. Also name the affiliate networks that you have worked with.

I am in need of a meticulously-crafted, compelling PowerPoint presentation for showcasing our products/services. The presentation is not aimed at just giving information, but to attract and retain the audience's attention. Key Attributes: -I require slides with animations and transitions to keep the audience engaged. -The presentation needs to be professional, yet visually appealing. Ideal Candidate: -Fluent in English -Extensive experience in creating PowerPoint presentations -Detailed knowledge of PowerPoint animations and transitions -A knack for creative graphic design would be beneficial. -Taste for aesthetics and knowledgeable in the latest presentation trends. Your role would be all-encompassing - from creating the slide layout, choosing the right graphics, and inserting an...

I am looking for a professional photographer/graphic designer to create engaging and high-quality product images for my Amazon listing. I require the following: - Product Images: - Pure white background. - Infographic Images: - Focus on high-quality material. Ideal candidates should have experience with product photography and infographic design, particularly for e-commerce platforms like Amazon. Kindly share your portfolio in your bid.

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.

...a new power electronics product for industrial use. The current stage of development is in the prototype phase. For this project, I need a skilled professional who can help me with the following: - PCB Prototyping: I require assistance with the creation of the PCB for this new product. This includes the manufacturing of the board itself. - Creation of Test Plans: I need an expert who can help me create comprehensive test plans for this new product. This includes both hardware and software testing. Experience in creating test plans for electronics, would be highly beneficial. - Final Testing & Validation: Once the PCBs are produced and the test plans are in place, I would need a professional who can assist me in the final testing and validation of this new ...

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

I need an expert in navigation on Team Tailor who can implement a prompt redirection feature on my website. The following requirements should be met: 1. Redirection: As soon as users land on the particular Team Tailor page, they should be instantly redirected to a specific product page on the existing website without any necessary user action. 2. Destination URL: The target of this redirect system is a specific product page URL. The exact URL will be shared during project discussion. The ideal freelancer should be an experienced web developer with expertise in website navigation and redirection. Prior work with Team Tailor would be a bonus. I am looking for a quick and seamless implementation.

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.

I need a packaging designer for several upcoming beauty products. The focus is on creating a design that's eco-friendly and natural, while still being aesthetically pleasing and functional. Key Requirements: - A good, cool designer. Experience doesn’t matter - Understanding of the beauty product packaging market - Ability to create a design that appeals to a broad audience - Knowledge of materials that are both eco-friendly and durable It'll be great if you can provide me with a portfolio of similar work you've done in the past. Thanks!

I require a proficient graphic designer for a minimalist packaging design of a beauty product. This project involves creating an aesthetically appealing and clean design that embodies simplicity and modernism. Key Elements: - Include the Company Logo - Incorporate Nutritional information - Insert Barcode on the package. Ideal candidate: - A good designer, experience doesn’t matter - Has a good understanding of beauty product branding - Keen attention to detail - Ability to create engaging and aesthetic designs.

...start with less than 50 products, focusing on the clothing and accessories niche. Key Responsibilities: - Categorizing the products effectively - Uploading the products to the Shopify platform - Crafting enticing product descriptions that can stimulate sales - Ensuring a consistent and appealing layout across the site The ideal candidate for this role should have: - Profound experience in setting up and managing Shopify online stores - Prior experience with product management, preferably in the clothing and accessories domain - Excellent writing skills to create compelling product descriptions - An eye for detail to ensure the store looks professional and engaging This project will require precision, creativity, and a deep understanding of eCommerce best practic...

... pillow cases, cushion covers, table covers, and mats. - The photography should be done in a studio setting. - The photos will require color correction, but background removal is not necessary. Ideal skills and experience for this job include: - Prior experience with product photography - Proficiency in studio photography - Strong understanding and experience in color correction techniques - An understanding of e-commerce photography standards - Attention to detail and creative flair for achieving appealing product shots. This project is a great opportunity for a photographer looking to expand their portfolio with professional level home decor images. P.S: refer attached document for the kind of images we want. Please contact only after you've understood the ...

...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 data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.

I'm currently in the process of settin...now, the products haven't been categorized by any specific attributes, so I am seeking assistance to systematically categorize and list these items on my site. - Briefly, the task requires setting up categories and adding products. - I have product mockups ready, but they lack comprehensive descriptions, so part of the task will include creating engaging, detailed product descriptions. A perfect fit for this task would be a freelancer with: 1. Proven experience in eCommerce product categorization. 2. Strong writing skills to craft compelling product descriptions. 3. An eye for detail and merchandising to help create an intuitive shopping experience. 4. The ability to work independently with minimal supervisi...

I'm looking for someone with experience in WooCommerce to address a product image issue on my website. - The problem: Currently, the product images on the site are not displaying. This is likely due to a technical problem that's causing the images to not load correctly. - Desired solution: I would like the freelancer to investigate and fix the existing images, ensuring they display properly. - Attention to detail: It is important that the images are fixed without compromising the quality of the website. Ideal skills and experience: - Proven experience with WooCommerce and fixing similar issues. - Strong attention to detail and problem-solving skills. - Excellent communication to keep me updated on the progress of the project.