Update magento inventory using sql jobs
I am seeking a talented ...The main focus of the website will be the product catalog, so it needs to be well-structured and easy to browse. - The site should have a clean and professional design that not only showcases the products but also reflects the brand image. - As I have an existing inventory system, I would like the products to be integrated seamlessly into the website. Ideal skills and experience: - Proven experience in designing and developing e-commerce websites, particularly with a strong focus on product catalog design. - Knowledge of inventory management systems and experience in integrating them with websites. - Excellent graphic design skills to create a visually appealing interface. - Ability to understand and translate the brand's message and customer ...
...sheet should offer an easy interface with dropdown menu options for hassle-free data inputs and editing. - Linking Stock and Sales: The sheet should be designed in such a way where the inventory updates automatically from sales data. So, a keen understanding of Excel's data integration and interconnection capabilities is necessary. - Essential Data Fields: My Excel sheet needs to include specific data fields like stock name, quantity, and cost price for seamless inventory and ledger management. This project requires an excellent grasp of Excel functions, automation, and data management. Experience in inventory management systems is a big plus. Skilled in creating user-friendly, efficient, and interconnected Excel systems, you should be able to tailor an Excel ...
...a Python developer to create a bespoke frontend for a warehouse management system. The system should primarily focus on Inventory management and Warehouse overview. Essential Functionalities: - Inventory Management: The system should allow for the easy management of inventory. - Warehouse Overview: An overview of warehouse status and stock levels should be clearly available. User Interface Design: - List View: I envision the inventory management interface as a list view with search and filter options for easy access and manipulation of data. Ideal Skills and Experience: - Proven experience in Python frontend development - Strong understanding and experience in Inventory management systems - Proficiency in creating user-friendly UIs with search and f...
The ebay app synchronises ebay products with magento with all the details including photos, name and Quantity. We like the App to only synchronise the Quantity !
I'm in immediate need of an experienced designer who can create a proficient and eye-catching email template in Klaviyo. Here are the details: Ideal skills and experience for the job: - Knowledge and experience using the Klaviyo platform for designing email templates - Familiarity with various email client requirements to ensure compatibility - Strong communication to update progress and make any adjustments swiftly Please attach any similar email template projects you have worked on in your proposal. I look forward to working with you.
I am in need of a robust and efficient inventory management system made in Excel. This project requires: - Tracking of product quantities and managing stock levels to ensure seamless operation - Cataloguing of each product's relevant information including its name, SKU/Part number, quantity, batch number and expiry date - Methods of updating system quantities should be manual entry and bar code scanning. Knowledge in these methods is required. Ideal candidates should have extensive experience in Excel and inventory management system creation, preferably with a sound understanding of retail or related sectors. They should also be adept at implementing bar code scanning into Excel systems. Sharp attention to detail and ability to optimize for efficiency and usability i...
...product uploads and inventory tracking. Efficient management and organization of products is crucial. - **Payment Gateway Integration**: Aspects of this job include setting up secure and seamless payment options for customers, ensuring their transactions are secure. - **Theme Customization**: The store should exude professionalism and corporate appeal. The ideal candidate will be sensitive to the need for a clean, minimalist design. The ideal freelancer for this project: - Proficient in Shopify store creation and management. - Proven experience in integrating a range of payment gateways. - Skilled in theme customization with a keen sense for professional and corporate aesthetics. - Previous experience with product catalog management, including bulk product uploads and inven...
...media links etc. I have attached a basic pdf document of what the app should look like. Will need UI improvements in it too. Key Responsibilities: - Develop an Android application that dynamically displays data from certain cells in Google Sheets. - The app should be designed to pull updates in real time, refreshing every minute. - It should provide a manual refresh data option for immediate update. Ideal Skills: - Extensive Android app development - Knowledge and experience with Google Sheets API - Real-time data synchronization and management. Only apply if you have had experience in similar app development projects and can deliver high quality work within the agreed timeline. I am aiming for an efficient and seamless user experience. I imagine that experience in real-...
I'm seeking a skilled web developer to UPLIFT an eCommerce store via SQUARESPACE for selling physical products. This store will sell customizable jewelry. The website is already created but we need to: 1. Update the style/colour/formatting and design of the front end. I am not happy with my colour schemes and font choice. Please help me improve the design. 2. Optimise my website for mobile 3. Improve functionality, spacing, and formatting using code. There is ~25 design and functionality changes that need to be changed e.g. Add pop up at checkout for ring size guide. Logo, media, text etc will all be provided.
...updates on a weekly basis. Here are the project specifications: * There are currently less than 5 Excel sheets that need to be interconnected. * The primary intent of this interconnection is the cross-referencing of information. * The exchange of data to be implemented includes Inventory data, Financial data, and Sales data. The ideal candidate should possess advanced Excel skills, including knowledge and experience in cross-referencing various types of data across multiple sheets. Familiarity with business inventory, financials, and sales data is highly desirable. Please ensure your bid reflects your ability to fulfill these requirements. Thank you in advance for time and efforts....
I'm looking to revamp and update content on my WordPress based website, www.Maiyuri.com. The work involves several tasks such as: - Text Changes: This would involve editing the 'About Us' page, updating our product descriptions, and modifying our contact information. It is important that the words and language used captures our brand voice and aligns with our business goal. - Image Updates: We need some fresh images to appeal to our audience. Appropriate creativity to make the website more appealing is appreciated. For the product descriptions, I want you to create the new content based on the information currently present on the site. It should be more detailed and compelling to the site visitors. Looking for a freelancer with a strong background in content c...
I'm in need of an expert to set up SQL Server 2019 on a Windows-based virtual machine. The system will be used to support website and desktop applications. Key Responsibilities: - Configuration of SQL Server 2019 on a Windows virtual machine - Ensuring secure and optimal performance of the system - Testing the setup to confirm seamless connectivity with website and desktop apps Ideal Skills: - Extensive experience in managing SQL Server 2019 - Expertise in Windows OS and virtual machines - Should have strong troubleshooting skills on SQL server - Familiarity with website and desktop app integrations.
Excited to work with an experienced ASP.Net webforms developer, who will bring their skills to facilitate the Database integration aspect of our project. Key Responsibilities: - Integrate SQL Server with our existing ASP.Net project. - Create smooth and efficient functionality. - Ensure system robustness and efficiency. Skills and Experience: - Strong proficiency with ASP.Net Webforms. - Knowledge and hands-on experience working with SQL Server. - Excellent troubleshooting capabilities. It is not necessary for this project to migrate data from an existing database to SQL Server. However, the capability to do so may be beneficial in the future. If you are an experienced developer with the aforementioned skills, I would love to have you on board for this project....
I'm actively looking for a talented website developer to craft a cutting-edge B2C ecommerce platform from scratch. Due to certain preferences, no specific platform is required although experience with popular platforms like Shopify, Magento, and WooCommerce is advantageous. Key Requirements: - Proficient with developing B2C ecommerce websites - 100 products listing - Post sevice support - Open to utilizing any established ecommerce platforms - Ability to integrate multiple payment gateways, specifically debit/credit card and Google Pay options Ideal Skills and Experience: - Prior experience in ecommerce website development - Familiarity with a variety of ecommerce platforms - Proven track record in integrating diverse payment gateways.
...seasoned e-commerce website developer who can handle a project of substantial scale. The ideal candidate will have: - A strong background in e-commerce website development. - The capability to deal with large inventories, as I need to feature more than 500 products on the website. - Flexibility with web development platforms, given I haven't yet decided on a specific one (i.e., WordPress, Shopify, Magento). Your primary task will be to create a user-friendly, engaging, and visually appealing website that encourages smooth navigation and secure purchasing. The end goal is to provide a seamless and optimized online shopping experience for my customers. Please, when making your bid, provide examples of similar e-commerce projects you have undertaken in the past. Looking f...
I'm looking for an accomplished WordPress expert to revamp my website (). Key focus areas are speed optimization, SEO friendliness and design update. The goal is to enhance my site's online presence significantly, increase sales, and improve our brand awareness. Here's what I'm seeking: - WordPress speed optimization: Fast-loading sites are crucial for higher conversion rates and improved user experience. - SEO-friendly updates: It's essential to make our site appear on top of search engine results. Possessing SEO skills is critical. - Design changes: I'm open to a new layout, color scheme, and font selection ideas that can make our site more appealing and user-friendly. Also, my website must: - Generate leads: The design and content should be engagi...
I'm looking for an experienced website developer to create an online store for an unspecified range of products. Key functionalities required include: - A reliable payment gateway to facilitate customer purchases. The professional handling this project should be proficient in integrating proven and secure payment systems for smooth transa...handling this project should be proficient in integrating proven and secure payment systems for smooth transactions. Considering the client might not have disclosed what products will be sold, skills in setting up versatile eCommerce platforms will be beneficial. Also, the developer should be flexible to incorporate additional functionalities such as customer reviews, product recommendations or inventory management if required later. QR C...
We are looking for an experienced supporter who can manage and update our Typo3 installation with different webpages: Please also have good knowledge about Typo3 updates to the latest versions (v13).
The fonts listed, when selected, the "Sample Text" should change to show the appropriate look of the selected 'font style' please fix and update with the font names shown in their font style (as now, only "Pacifico" font works properly) >>> Please use all font listed at <<< for font list
I have a simple one page website at that has three bugs: 1) The footer's color is not working. The CSS attempts to set the footer color, but it shows up as white all the time. Could be a...to set the footer color, but it shows up as white all the time. Could be a html tag issue or a css issue. 2) The Dark Mode / Light Mode selector in the footer mostly works, but the CSS based animation of the toggle switch no longer works. This stopped working the same time bug number one appeared, so they are probably the same bug. 3) Clicking the Dark Mode / Light Mode selector does not always update the cat gif image. Sometimes it works, sometimes it doesn't work. Probably a JS issue. I would like to get these three bugs fixed now. Please only bid if you can fix these right now.
I'm in need of an experienced Flutter Developer who can craft a comprehensive mobile application. The app should be compatible with both Android and iOS systems. Requirements: - Develop a logistics and delivery app: The project focuses on creating a comprehensive software that can manage delivery services. It should include features such as route optimization, real-time tracking, delivery scheduling, and scanning capabilities. Skills & Experience: - Proficiency in Flutter: The candidate should be well-versed in Flutter development to ensure a seamless and efficient app. - Previous Experience: An ideal candidate should have a strong track record of developing similar applications. - Strong understanding of logistics: Knowledge of logistics and delivery processes is a plus as it w...
I require an expert in Excel to build a comprehensive tracking file. This task involves: - Establishing a data entry form to easily input inventory and project progress details. Knowledge of creating user-friendly interfaces within Excel is beneficial. - Implementing automated calculations to streamline the data analysis process. Strong mathematical and analytical skills are essential. - Creating a graphical representation of data to facilitate understanding. Experience in data visualization is a must. The spreadsheet will track fewer than 10 types of inventory data and project progress data. Your familiarity with inventory management processes and project tracking would be highly valuable. This assignment calls for you to use Excel's capabilities optimally to ...
I'm seeking a proficient developer to build a comprehensive demo or starter code integrating Snowflake and Kafka using AWS cloud. The ideal candidate should have deep understanding of concepts such as: - Data ingestion - Data transformation - Data storage and retrieval The code should ensure: - Optimal performance - Scalability - Security The code can be written in Python or Java. In-depth knowledge of these languages, as well as experience with Snowflake and Kafka integration, is a necessity for a successful bid on this project.
I'm seeking a WordPress and Elementor specialist to undertake a content update on my website. Your responsibilities will primarily be: 1. Homepage Setup: The homepage requires a professional touch. However, the user skipped the question about their preference for layout and design. Flexibility and a knack for enhancing site appeal are crucial. 2. Campaign Banner Update: A thorough update or replacement of the existing campaign banner is required. Your creativity and eye for detail will be essential here. 3. Countdown Timer Update: The timer isn't fully responsive across all devices and needs fixing. Experience in creating and managing responsive site designs will be crucial. Ideal skills and experience: • Expertise in WordPress and Elemento...
I have a small business and am seeking a skilled web designer to cre...for me. I've chosen a color scheme (blue and white) and know exactly what I want on the page. The main function of this landing page is to display my business information. It should be clean, simple, and easy to navigate. I'm looking for a design that's professional and has a modern touch. I'd like the landing page to include: - A brief description of my business - Just use random text I will update it - A color scheme that's mainly blue and white I really appreciate a freelancer who has experience working with Wordpress and is skilled in creating effective, eye-catching landing pages. A good eye for design and attention to detail are key. I'm open to discussing any other suggest...
...ETL development, data modeling, metadata management and data quality Strong knowledge of SQL running on SQL Server, MySQL, and Snowflake including but not limited to: extensive experience working with complex stored procedures, table definitions, and a proven track-record of performance optimizations and troubleshooting of SQL logic. Proficient at C# running on .NET Core and/or other similar .NET frameworks including but not limited to: writing Unit Tests and implementing algorithms and data structures Strong hands on experience in Microservices, RESTful webservices development in Java (Spring Boot or equivalent framework) Proficient at building intelligent solutions to complex problems. Experience using source control tools such as GIT Proficient at Performa...
After the latest WordPress update, my website has been plagued with various issues that impede its functionality and user experience. Key Responsibilities: - Rectify the broken links and error messages - Ensure the proper functionality of pictures and sliders - Install an SSL certificate to bolster site security If you're adept at mitigating such post-update problems and are knowledgeable in SSL installation, please bid. Deep understanding of WordPress and experience dealing with similar issues is highly advantageous.
I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.
...skillful PHP/Laravel developer with proven proficiency in , Vite, and Tailwind CSS, and Github I'm seeking a professional to assist in the creation of a high-performing Payment Portal Management System with a deadline of May 14, 2024. Candidate must be competent in Github and have fluent communication skills in either English or Chinese. All user and transaction data will be generated using random data for development purposes. The existing database structure and design are mostly completed, and the current source code will be provided to facilitate seamless continuation of development. Project Details: Payment Management Portal The project entails the development of a comprehensive payment management portal with three key roles: User: Users can have multiple companies, a...
I'm looking to create an application using NoCode development tools, specifically Bubble and FlutterFlow. The core features I need developed are: - User Authentication: This will be based on an email and password login system. The focus should be on ensuring user credentials are securely handled and stored. Experience with implementing this in a NoCode environment is a must. - Database Integration: The project will make use of an SQL Server. The freelancer should be able to efficiently integrate and manage an SQL Server database with the NoCode tools. Previous experience with SQL Server is required. - We need to integrate some process, after all, we need to implement the solution in Azure. In summary, I'm looking for a freelancer who is skille...
I'm seeking a proficient Etsy sales manager to help me with my shop. Key Responsibilities: - Product Optimization: Focusing on Seo and how to get the product sold as well as the correct pricing. - Inventory Management: Managing stock levels, ensuring timely restocking, and helping to forecast demand. - SEO & Digital Marketing: You should have a strong understanding of SEO and digital marketing strategies, particularly as they relate to Etsy, in order to drive sales. Ideal Candidate: - Proven experience in managing Etsy shops and generating sales. - Strong understanding of SEO and digital marketing strategies, particularly in the context of e-commerce platforms. - Experience with product listing, and a track record of optimization that has led to improved sales. - Excell...
I'm experiencing an issue with my email that was linked to Google Wo...working. Now whenever I try to send an email, even though Google permits my login, I'm encountered with an error message (This is the message i receive now: 550 5.1.1 : Recipient address rejected: undeliverable address: host [private/dovecot-lmtp] said: 550 5.1.1 User doesn't exist: xxx@xxx (in reply to RCPT TO command) I don't know how to verify if my DNS settings update is aligned with the new website hosting. I need urgent assistance from an experienced individual to amend this issue. Ideal Skills: - Experience in troubleshooting Google Workspace email issues. - Proficiency in DNS settings and have experience in website transfer. - Experience in diagnosing and fixing email sending erro...
I'm looking for an experienced iOS developer to create a straightforward app for me. There will be several simple features that need to be implemented: - Manual Signal Updating: The app should allow me to manually update the signals for 7 fx pairs, Bitcoin and the SPY. - Signal Icons Display: The app should have different icons (e.g., arrow up, arrow down) for each type of signal (buy, sell, NA). - Custom Photo Integration: I have some photos I'd like to incorporate into the app, either as decoration or background. Your role will be primarily focused on the development and implementation of these features. The design of the app should be minimalistic, with the photos I provide integrated seamlessly. Ideal skills for this project include: - Proficiency in iOS developme...
I'm looking to set up an online store where I can sell unique physical goods. I will not need to manage inventory as each item is distinct. The website should be equipped to handle credit card and PayPal transactions. Key requirements: - Develop an e-commerce website that can handle unique, physical products. - Implement a user-friendly interface for easy browsing and purchase. - Ensure secure payment gateways for credit card and PayPal transactions. Ideal skills for this project include: - Proficiency in e-commerce website development. - Experience with unique inventory management systems. - Knowledge of secure payment gateway integration.
I want to create a quiz that can be embedded into a website page builder using their embed feature. The quiz should be manageable from my dashboard, the script will be on it's own domain. Key Aspects: - Creation: The plugin should enable the user to create quizzes. Please advise on the best quiz type to use. - Embedding: The plugin should allow for easy embedding into website pages or blog posts. Being able to place the quiz in a sidebar widget would be a bonus. - Interaction: I am open to different ways for users to interact with the quiz, either by clicking on options, typing answers, or selecting from dropdown menus. Your insights on the most user-friendly option are welcome. - Management: The plugin should provide an interface to manage the quizzes. Ideal Skills and Ex...
...Webflow. Not interested in migrating into WooCommerce. The new website should share one backend with a shared inventory, but the two should cater to two different websites each with - own branding - own URL - own mailing list (mail chimp or native to platform) Key tasks include: - Migrating existing sites built on Shopify and Woocommerce into one site - either Shopify or Webflow - Implementing a shared backend inventory across the two storefronts, supplemented by individual branding and mailing lists. - We want option to select which products will be displayed in which store. (most of the products will be visible in both stores, but certain products only on one store). - The inventory should be shared between both stores, so that if ProductA in sold in ShopA, the...
I'm in search of a seasoned Magento professional to assist our agency across a range of projects. The majority of our development team is based in India so we are seeking an additional person to assist during AU business hours from 9am - 2pm AEST. Key Responsibilities: - Resolving website crashes: Websites occasionally crash and need immediate fixes to ensure smooth operation. - Performance optimisation: - Security updates: Ideal Skills/Experience: - Proficiency in Magento: A deep understanding of Magento platform and its various versions is crucial. - Bug Fixing: Proven track record in resolving bugs and troubleshooting related issues efficiently. - Performance Optimization: Experience in enhancing performance and addressing slow page load times. - Security: ...
Are you passionate about crafting exceptional ecommerce platforms using GO lang and React JS/Next JS? Project Description: We are in need of an expert developer to create a dynamic ecommerce platform focusing on digital goods and services. The project entails building three main sectors: Front-end Development: Implement user authentication, service listing, and seamless communication with the backend via API. Supplier Backend: Develop functionalities for suppliers to manage products, process orders, and handle cancellations efficiently. Admin Backend: Construct a robust admin panel to oversee order processing, site settings, and overall platform management. System Overview: Showcase popular services through a slider on the front end, adjustable by the admin. ...
I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Ex...experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel,...
I am looking for a skilled web developer who can help me with customizing the Motors Theme in a way that will enhance the user's experience, particularly with the payment process. Your main tasks will include updating the Payments page and journeys. The specific focus of the payment changes should be to simplify the checkout process. Key tasks: - Update the payment process steps to simplify the checkout process Ideal skills: - Proficient in working with Wordpress themes, particularly Motors Theme by Stylemix - Experience in customizing payment gateways and checkout processes - Able to enhance user experience through design and functionality This project is perfect for you if you have a knack for web development and are keen on improving user experiences. Please include ex...
I require an experienced TradingView developer to update an existing indicator. The task involves adding multiple lines to the indicator in a specific manner. These lines should be plotted above or below the existing lines. Ideal candidates for this project should have: - Strong experience in TradingView indicator development - Proficiency in Pine Script - A keen eye for detail to ensure accurate line placement - Previous experience with custom line plotting in TradingView Please include your previous work and any experience related to this project in your proposal.
I am looking for a skilled web develope...create an informational website targeted towards businesses. This project requires a website that can easily be updated with regular product/service updates, since it'll be a platform to educate our audience about our offerings. Key requirements for this job: - Comprehensive web design and development expertise - Proven experience integrating a content management system (CMS) for easy content update - Knowledge in creating a user-friendly layout for businesses - Strong understanding of SEO strategies to help us reach our target audience effectively Please provide samples of similar websites you have developed, especially ones targeted towards businesses. Candidates with previous experience in building informational websites will hav...
I am seeking an experienced .NET developer to build a highly dynamic REST API using the .NET 8 framework. The API will be designed to manage interactions with a database using a single, generic controller capable of handling all database tables. This project will involve implementing advanced features such as column selection, filtering, sorting, pagination, and complex table relationships like aggregations and master-detail references. Core Requirements: 1. API Framework: The API should be developed using .NET 8. I am open to using either OData or GraphQL for the API architecture, depending on what the developer finds most suitable for the project requirements. Alternative suggestions are welcome for discussion. 2. Generic Controller: The API should feature a...
For my current project, I require an expert who's proficient in DOMO Beast Mode and SQL. The tasks will primarily involve: - Producing calculated fields: You will need to execute both complex mathematical calculations, as well as intricate string manipulations. A good grasp of mathematical principles and string handling in SQL is a must. - Transforming data: This job will further entail the aggregation of data. Being adept in grouping and managing datasets of diverse sizes will be crucial. Your comfort in working with DOMO, SQL, and data manipulation will be the key to successfully accomplishing this task. If you routinely perform these tasks and understand the underlying processes, I would love to connect and discuss the project further.
...excellent telephone manner, and perfect spoken French. Italian also highly desirable as second language. - A strong and verifiable track record of generating leads and working to targets. - Excellent communication and persuasion skills. Your task will be to introduce the business/service to potential leads, record information accurately and keep a comprehensive database of contacts, which you will update on our shared worksheets. There is potential to make this an ongoing job for the right Freelancer that can achieve daily and weekly targets. Daily minimum goal is to deliver 20 high quality qualified leads (name, email address, direct contact number) The job pays €60 per day in arrears on delivery and verification of leads. PLEASE NOTE THAT THE JOB IS TO DELIVER A MINIMUM...
I'm looking for a skilled website designer and developer to help me revamp my existing site. The main goals are to: - Redesign the layout: The site needs a fresh look that is both modern and user-friendly. Aesthetics are important, but so is functionality. - Update the content: The website's content is outdated and needs to be refreshed. This includes text, images, videos, and any other media. - Improve the navigation: The site's navigation is currently not as intuitive as I'd like. I want visitors to easily find what they need. The main purpose of the website is to showcase my products/services. Therefore, the redesign should be tailored towards this end. Also, I prefer a color scheme that is warm and welcoming, in line with the type of products and services...
I am seeking an experienced developer who is well-versed in React JS and Node JS for the development of an e-commerce platform. This platform will be designed to support a range of e-commerce functions, with the main focus being on product search and filter options. Key responsibilities & requirements: - Proficiency in React JS for front-end development - Experience with Node JS for back-end development - Strong understanding of e-commerce structures and functionalities - Ability to integrate user-friendly product search and filter options The ideal candidate should be someone who has not only the technical expertise, but also the vision and creativity to enhance the user experience through these key functionalities. A portfolio showcasing previous e-commerce projects would be a s...
