Build shopping cart sqlроботи

Доброго дня! Шукаю фрілансера, хто міг би допомогти час від часу писати коди SQL запитів для SAP B1.

...Супроводження процесу впровадження. Вимоги: • Досвід роботи – від 2-х років. • C++11, STL, GCC/CLang, GDB/LLDB, GNU Make, CMake, Bash. • Знання STL — контейнерів та алгоритмів. • Знання файлового вводу/виводу у стандарті POSIX. • Знання POSIX Threads —нитки, м’ютекси, умовні змінні. • Вміння користуватися системою контроля версій Git. • Вміння користуватися командним рядком Linux. • Реляциійні БД, SQL. • Основи функціонування комп’ютерних мереж, протоколи TCP и HTTP. Знання HTTP/1.1. Знанння архитектури REST. • Багатопоточність. Буде плюсом: • C++14, 17, 20. • Qt. • Boost. • Засоби статичного і и динамічного анализа коду (cppcheck, clang-tidy, clazy, valgrind, gprof, &helli...

Нужен специалист который может перенести сайт с open cart на Shopify. Настроить, сделать чтобы он был практичен в пользовании и продаваем. Ищу человека у которого есть опыт с Shopify. Оплата обсуждаемая.

... Шукає Unity розробника для створення багатокористувацької браузерної 3D гри, Unity за допомогою WebGL. Обов'язкові навички: Вміння працювати в Unity і знання мови C#. Плюсом буде додаткові знання: JS, HTML 5. І back end розробника для написання серверної частини на ASP.NET Core. Обов'язкові навички: ASP.NET Core Entity framework core SQL С кидайте свої резьуме на: business@ або проджект менеджеру проекту: viktorstor@ KICKOOS GAMES - це молода outsourc GameDev компанія, що з недавна почала розробляти і внутрішні проекти. Друзі компанія зараз розширюється і влітку планує відкрити офіс в Україні, тому долучайтеся до нашої спільноти у телеграмі, де публікуются відкриті вакансії на різні позиції.

Необхідно розробити jquery плагін, що буде дозволяти дінам...існуючого скрипта () або розробка нового. Обговорюється. У разі швидкого успішного виконання можлива постіна співпраця на довготривалому проекті. We need and jquery plugin, that will allow a dynamic changing of pruduct options (look) and its description with sending the result to db (add to cart, separate button). You can update the existing script ([login to view URL]) or write the new one. It's a matter of discuss. It's possible to get a long term deal if this project will be finished well and fast.

Потрібно зробити легкі лабораторні роботи, терміново! Файли прикріпив, за потребою скину методичку.

Я маю довгострокову роботу, яка пов'язана з нашим попереднім проектом 'Change Framework CMS from Shopify to Prestashop - PHP, HTML, CMS, SQL'

Build a Creative Multilangual Website Menu Stucture: English / Azerbaijan / Russian 1. Home 2. Services -Web Design -Web Site Create -Hosting -HDD Hosting -SSD Hosting -Server -HDD Server -SSD Server -Domain -SSL Certificate -Antivirus -CMS License -Programming -SEO -SMM -Reklam (Ads) -Payment Gateway -Tools -PR Checker -ТИЦ Checker -SEO Checker -SMM Checker -Site cost 3. Portfolio 4. Partners -Our Partners -Affiliat...

1. Потрібно існуючий інтернет магазин перевести на CMS (CS-Cart) новішої версії + натягнути шаблон готового інтернет магазину + адаптувати цей шаблон під наші потреби (поміняти кольорову гаму і розміщення блоків). 2. Доробка функціоналу: налаштувати під наші потреби фільтри товарів 3. Зробити/доробити або інтегрувати Живий пошук 4. + купа інших дрібних доробок

I'm in need of a comprehensive, ready-to-deploy online grocery and delivery application, with full support for deployment and maintenance. Key Requirements: - The application should be a complete package, designed to be user-friendly and efficient, streamlining the grocery shopping and delivery process. - Integration with PayPal and a European payment gateway is necessary. - The inventory management system must be integrated with WooCommerce. Support and Deployment: - Your role will extend beyond development; you'll be required to provide detailed support to my in-house tech team for deployment and maintenance. - The final product should be fully functional and ready for use. Skills and Experience: - Proficiency in full-stack development, with experience in creating and...

exactly similar to this f-system

...---------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was added and create a new one called Booking Category. This will need look up the `11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes/gamico/template-parts/project/ to show the Booknetic category based on the game.

...customization options, abandoned cart recovery, social media integration, or any other features that can enhance the user experience and increase conversions. - Product Volume: The number of products I'm planning to sell is unspecified. You should be comfortable working with a range of products, from small to large inventories. - Design: While I haven't decided on a theme or design for the store yet, it would be a plus if you have a good eye for design and can offer suggestions to make the store visually appealing and functional. Ideal Skills and Experience: - Proven experience as a Shopify developer with a deep understanding of its features and capabilities. - Experience in implementing key features such as product customization options, abandoned cart reco...

...allows us to do minor modifications inhouse- no programming expertise). Along with the web site, suggest name (search on net and proposed office locations), design logo and compose tagline. All copy by client. Topics covered: Vision, mission, contact, FAQ, terms & Conditions, Returns, Refunds, Shopping from a catalog, Live+Chatbot, order processing, confirmation, tracking, cancellation, payment processing, credit, debit, digital wallets, EFT, (No COD, No Checks)Shipping choices and info, Shopping cart, Days to delivery, Visitor, customer mailing list, Loyalty program, Social media accounts, FB, Whatsapp, Youtube, Instagram, Twitter. Email newletter banners (Relevant occasions, seasons). Digital marketing activities, SEO, Selection of categories and merchandise b...

I'm seeking a skilled mobile developer to craft an e-commerce application similar to the Vinted App for both iOS and Android platforms. Key Requirements: Development for both iOS and Android platforms. Robust e-commerce functionality with a strong emphasis on user experience and security. A streamlined and intuitive shopping experience with a mobile-friendly interface. Scalability to handle a large number of users and transactions efficiently. Experience: Proven track record of successfully launching cross-platform mobile applications. Experience in developing e-commerce apps is highly desirable. Strong understanding of mobile development with a focus on user experience, performance, and security. If you're confident in your ability to develop a scalable, user-friendly,...

As an entrepreneur keen on selling physical products to ...store designer. Your creative skills are crucial to deliver a design that reflects a simple and intuitive user experience. Key Responsibilities: - Develop a Shopify store to sell a variety of physical products targeting Adults (25-45). - Create a simple, user-friendly platform to facilitate a seamless shopping experience. Skills and Experience: - Proven experience in Shopify store design - Strong UI/UX skills to create a user-friendly environment - Understanding of target audience shopping behaviours - An eye for clean, intuitive design to cater to a mature audience I am seeking a professional with a firm grasp of these skills to engage precisely with my project's needs and execute it with finesse. Looking...

...Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Cloud Memorystore): Log Redis operations. - Collect and store logs centrally using GCP's Stackdriver Logging. - Set up log rotation and retention policies. 3. HTTPS Domain...

I'm in need of a professional website designer to help create an e-commerce website for my business. The website should include key features such as: - Product pages: individual pages for each of my products, showcasing pictures, descriptions and pricing. - Shopping cart: an easy-to-use shopping cart for customers to make purchases directly from the website. - Customer reviews: a feature for customers to leave and view reviews for each product. In terms of payment methods, I'd like the website to support Credit Card, PayPal, and UPI transactions. Ideal skills and experience for this job would include a demonstrated proficiency in e-commerce website development, understanding of payment gateway integration, and experience in designing user-friendly ...

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for 30% randoml...

...skilled web developer to create an engaging e-commerce website that possesses the following features: - Product Search and Filtering: A strong, user-friendly search and filter system is crucial to help customers swiftly locate products of their interest. - Customer Reviews: A platform for customers to leave reviews on our products. This feedback is vital for our business growth. - Shopping Cart: An easy-to-use shopping cart feature for customer convenience. For the payment options, we'll discuss this aspect later as I'm still considering the best choices for my customers. Hence, the web developer should have the ability to incorporate different payment options. Ideal candidates should have solid experience in e-commerce platforms, great attention...

...e-commerce best practices, and who is adaptable as the project progresses. Bring your WooCommerce expertise, project management prowess, and a sense of flair to make this e-commerce site shine. About Us: We are a new e-commerce company specializing in dropshipping, poised to disrupt the market with our innovative platform featuring millions of products. Our mission is to deliver unparalleled shopping experiences to customers worldwide. The Opportunity: We're seeking an experienced Freelance E-commerce Development Lead to spearhead the development of our large-scale dropshipping platform. This is a unique opportunity to play a key role in shaping our future, with potential sweat equity options as a testament to our commitment to rewarding exceptional talent. Key Responsibi...

I am in need of a skilled website developer to help create an e-commerce platform for my company. The primary goal of the website is to facilitate online selling, making it convenient for my customers to purchase my products. K...website developer to help create an e-commerce platform for my company. The primary goal of the website is to facilitate online selling, making it convenient for my customers to purchase my products. Key Requirements: - Develop an e-commerce website with a user-friendly interface. - Implement a shopping cart feature that simplifies the purchasing process for customers. Ideal Skills & Experience: - Proficient in website development, particularly e-commerce platforms. - Experience in implementing shopping cart features. - Adept at...

...Product Titles, Descriptions, and Prices: It's crucial that all product information is accurately transferred to Shopify, ensuring consistency and accuracy. - Product Images and Stock Levels: Images play a key role in attracting customers and stock levels need to be correctly maintained for each product. - Categories, Tags, and SEO Data: Proper categorization and tagging are essential for a smooth shopping experience. Also, SEO data should be transferred to ensure my products maintain their visibility on search engines. Additionally, the migration should also include: - Variations and Attributes: Some of my products have variations and unique attributes, which should be meticulously transferred to Shopify. - Customer Reviews and Ratings: Maintaining customer reviews and ra...

...am looking for an experienced Flutter developer to build a comprehensive e-commerce application. Key Features: - The primary feature of the app will be a well-organized product catalog. The app should be able to display and categorize products effectively, making it easy for users to navigate and find what they're looking for. Platform Support: - The application should be designed to support both Android and iOS platforms. It should be optimized for both mobile devices and tablets across both systems. Ideal Skills: - Proficiency in Flutter development is a must. I expect a polished, user-friendly interface that is consistent across both platforms. - Previous experience with e-commerce applications is a plus. Familiarity with shopping cart and payment integr...

I'm looking for a skilled web designer who can create a high-end e-commerce website. Key features should include: - A product gallery to showcase items - Seamless and functional shopping cart for easy checkout - Integration of a customer review system While I'm not certain about the exact color scheme or branding guidelines just yet, I'd appreciate it if you could provide advice or examples of effective designs. Proven expertise in designing e-commerce sites is crucial to fully understand and meet the needs of this project. Your portfolio showcasing similar projects would be immensely helpful.

We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78,...

...primary focus will be selling Cannabises accessories. It should offer a dynamic online shopping experience that leverages 3D technology to visually display and interact with our products. Specifically, the requirements are as follows: - Expertise in 3D modeling, rendering and website design. - Experience in eCommerce, specifically dealing with clothing and accessories. - Ability to create a user-friendly interface for customers to seamlessly explore, select and purchase products. - Knowledge in the integration of payment systems and shopping carts. - A knack for creativity and an eye for aesthetically pleasing design schemes. My ultimate goal is for potential customers to have an immersive shopping experience, almost as if they're physically in a b...

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 looking for an experienced web developer to create a cross-platform e-commerce website. Key Requirements and Deliverables: - Create a user-friendly e-commerce website that functions seamlessly on both iOS and Android platforms - The website should have a clean and modern design, conducive to a positive shopping experience - Implement essential e-commerce features, such as product listings, shopping cart, secure payment gateways, and customer account management Skills and Experience: - Proven expertise in website development, particularly in e-commerce - Experienced in creating cross-platform websites for both iOS and Android - Strong understanding of user experience and responsive design principles - Familiarity with integrating payment gateways and other e...

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.

I'm in need of a skilled developer to create an online store using WordPress. The store will specifically cater to digital products, hence, appropriate plugins and features will need to be implemented. Key Project Requirements: - Implement a shopping cart system - Integrate a payment gateway: Stripe along with p24, blik, sofort, skrill, giro, and ideal - The store will exclusively sell digital products The ideal candidate for this project should be adept in WordPress, have previous experience in building online stores, particularly for digital products, and have proven experience in integrating Stripe and other specified payment gateways.

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

I need a proficient web designer to develop an e-commerce website for book sales, integrated with a blog page. Key requirements include: - Creating an intuitive and user-friendly platform that allows customers to browse and purchase books online. - Incorporating a blog page where users can read, interact through a comment section, and share posts on social m...a comment section, and share posts on social media. - The entire project must be completed as soon as possible. Ideal skills for this project include: - Proficiency in e-commerce web design. - Experience with blog implementation. - Fast-paced work ethic without compromising on quality. This project presents an opportunity to create a dynamic, interactive platform that integrates online shopping with valuable literar...

I'm seeking a proficient data analyst to decode my online shopping platform's sales data. The primary task is to accurately identify prevailing sales trends. Your role will encompass: - Cleaning and preparing raw sales data from the online shopping platform - Utilizing advanced statistical methods to analyze the data - Identifying significant sales trends - Providing a detailed report on the findings Ideal Skills: - Proven experience in data analytics, particularly sales data - Proficiency in statistical software like Python, R or SAS - Ability to interpret complex data and communicate findings effectively - Prior experience working with online shopping platform data will be advantageous. Your detailed understanding of sales trends will inform our strateg...

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 looking for a proficient web designer to create my online store using Wix. The store will primarily focus on selling physical products. ...platforms. Here are some specifics about the project: - Design Style: I have a preference for a minimalistic design. A clean, simple, and contemporary look is what I'm going for. - Product Display: The site should be able to effectively display physical products in an easily accessible and SEO-friendly manner. - User Interface: The UI should be designed with ease-of-use in mind, streamlining the shopping experience for our customers. Skills and Experience Preferrable: - Proficiency in Wix website design - Prior experience in e-commerce website development - Experience with minimalistic UI/UX design - Knowledge of SEO best practice...

...talented web designer with experience in building dynamic websites I want this website to feel exclusive and dynamic. The project is to develop a website for a subscription box service targeting young millennial and GenZ consumers. - Key Features: - Customizable Subscriptions: The website must allow selected users to customise their subscription box - Easy Checkout Process: The online shopping experience should be seamless with a user-friendly checkout process many be gamified. - Integration with Payment Gateways: The site must be secure and seamlessly integrated with various payment portals Ideal Skills & Experience: - Proficiency in modern web development technologies - Experience building subscription-based e-commerce websites - Understanding of UX principles...

We are seeking a professional and experienced development team to build a comprehensive online marketplace for collectibles. The platform will include both web and mobile applications, providing users with the ability to buy, sell, trade, showcase their collections, and interact with other collectors. The project encompasses advanced features such as live sales, image recognition, and a robust community engagement system. Project Overview: Key Requirements: User Accounts and Profiles: Secure user registration and login Profile management with collection tracking and wishlists Customizable user profiles Product Listings: User-submitted items with high-resolution images, detailed descriptions, prices, and availability Categories and subcategories for easy navigation Advanced searc...

...patient's name should be sent automatically via email and available to direct download. - The website need to be simple for the customer and easy to buy with a few steps. -The website need to have a page of "about us", "Medical information", "Exam page categories with a subcategories of exam, sorted by different spect of the customer, the customer can select wich exam they want to buy (to add to the cart) and need to have a bottom for contact us by form for special requeriments of exams. Also we need a bottom on the inicial page to get partnership with companies. We also want to have an information filling form like the one in this website: to help customers who didn't know what they need. -The website needs to be compatible to website by cell...

I'm looking for an experienced mobile app developer who can build a feature-rich e-commerce app that will work seamlessly on both Android and iOS. The app will cater to a WordPress-based online shop, ensuring customers have a smooth shopping experience with access to unique features. Key Features & Functionalities: - User Registration & Login: A seamless and secure process for users to create accounts and log in. - Push Notifications: Utilizing notifications to engage with users and keep them updated with the latest offers, deals, and more. - Connected to WordPress Shop: The app should effectively fetch and display product data from the existing WordPress shop, ensuring real-time updates of the product catalog. - Custom Stock Management: Admin should have the ca...

...looking for developers who are proficient in WooCommerce and Google Sheet API to help with our ongoing project to improve some of it's functionalities and features. Key Responsibilities: - Assist in setting up WooCommerce functionalities on a website, including product catalog, shopping cart, and payment gateway integration. - Implement integration with Google Sheet API for specific data processing & syncing requirements. Ideal Candidate: - Proficient in WooCommerce, including setting up product catalog, shopping cart, and payment gateway integration. - Experienced in integrating external APIs, specifically Google Sheet API, App Scripts Programming. - A good understanding of data processing and how to leverage Google Sheet for such purposes. The p...

I'm looking for a skilled developer who can create a unique shopping experience marketplace application. The application should be versatile and functional on both web and mobile (iOS/Android). Key Features: - The primary focus of the application is to provide seamless product search filter options & a unique and new way of shopping with AI ,AR Features etc. the interface should be user-friendly and efficient - The Application will have a dashboard for sellers, for buyers and for us - The whole idea is to create friends while shopping so the application will have a community section where three will be soon million of members active where everyone can communicate and make friendships Payment Integration: - The application must be able to accept UPI payme...

I'm looking for a skilled web developer to create an e-commerce website for my business. The website's main purpose is to provide an online platform for customers to purchase my products. Key Requirements: - Full E-commerce Functionality: The website should have all the necessary features for an e-commerce platform, including a shopping cart, product pages, checkout and more. - Multi-Payment Integration: I'd like all types of payment methods to be integrated, including credit card, PayPal, bank transfer, etc. - Product Management: As I plan to sell less than 100 products, the website should be easy to manage in terms of product listings, descriptions, and images. Ideal Skills & Experience: - Proficient in E-commerce Development: Experience in creating ...

I am searching for a proficient web 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 websi...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 passionate about creating top-notch online shopping experiences and have experience in the areas...

I need Ecwid expert who can help me to customise shopping form and should be did work on ecwid. Make sure they know ecwid and customizing. If not experienced in ecwid them please don't bid, I I'll simply refuse those bids are blinding loaded.

...which should be incorporated across the store Key Areas for Lilac Color Integration: - Header and navigation: These sections need to be engaging and intuitive for users. - Product images and descriptions: The Lilac color should be used to present the products in an appealing manner. - Call-to-action buttons: These are vital for guiding user actions, and should be designed to enhance the overall shopping experience. Skills and Experience: - Proven track record in Shopify store design - Proficiency in color psychology and UI/UX design - Prior experience in creating engaging and visually appealing online stores - Strong communication skills to understand and translate my vision into reality If you have a keen eye for design, a good understanding of e-commerce, and a creative appr...