Automobile online inventory database program jobs
I'm currently experiencing database connection errors on my Wordpress website. Key Requirements: - Fix database connection errors causing website load problems - Ensure the website is running smoothly and all features are fully functional - Full access to the website's hosting account and database for troubleshooting - Clear and timely communication using instant messaging for updates and feedback Ideal Skills and Experience: - Proven experience in resolving database connection errors on Wordpress websites - Strong understanding of database management and troubleshooting in Wordpress - Excellent problem-solving skills and ability to work efficiently - Previous experience in instant messaging for client communication is a plus Had issues lik...
I am looking for Website for B2B and B2C. Data will be reflect to the Admin portal from both B2B and B2C pages. Need to create 5 pages for Website B2B Page Tasks Need to create Query request form on B2B Need to create registration form on B2B Need to create Inventory management page on B2B B2C Pages Need to create registration page using whatsapp, social media and phone Customer can search for the desired result which will be based on the B2B inventory management page In the result page our recommendation will be listed at the top Need to create app for B2B and B2C for android/IOS
...application. This UI will be used primarily by our Warehouse staff. Key components of the project include: - UI Design: The primary focus of this project is the design of the user interface. It should be user-friendly, intuitive, and minimalist in style. - Backend Development: The system will be powered by Microsoft Access. The backend should support: - Inventory Tracking: The system should be able to record and update our inventory. - Cost Analysis: The backend should be able to calculate the cost of our stock. - Report Generation: The system should be able to generate detailed reports based on the data entered. The ideal freelancer for this project should have experience in: - UI/UX Design: A strong background in designing clean and minimalist UIs is a must. - M...
...e-commerce business. This app will need to be fully integrated with WooCommerce, as I don't currently have a website so this will be the primary platform for my products. Key Requirements: - The app needs to have a seamless and intuitive user interface, ensuring a smooth shopping experience for customers. - As I'll be selling physical goods, the app should be capable of handling product listings, inventory management, order processing, and customer notifications. - Integration with a secure and reliable payment gateway is a must, although I'm open to suggestions in this area. I'm seeking a developer with experience in building e-commerce apps, particularly those integrated with WooCommerce. Prior experience in handling payment gateways would be a definite p...
I'm looking for a professional Flask and Python developer to help me implement a user management system for my website. The user management system should have Social Media login integration. Additionally, I would like the selected developer to set up a payment gateway and a MySQL database. Ideal Skills: - Proficient in Flask and Python - Experience in implementing user management systems with social media login integration - Proficient in setting up payment gateways - Proficient in working with MySQL databases
I am looking for a professional web developer to create a sleek and user-friendly online booking system for my massage therapy center. Key Features: - Online Appointment Booking: The website should offer an easy and intuitive way for clients to book their massage therapy appointments online. - No Customer Login Required: I'd prefer the booking to be streamlined and hassle-free, with no mandatory customer login. Ideal Skills and Experience: - Previous experience in creating similar online booking systems is a huge plus. - Proficiency in web development, especially in creating functional and responsive websites. - Understanding of user experience and user interface design to ensure the booking process is seamless for clients.
I am in need of a skilled programmer to create a bot, effectively able to filter out vehicle listings and send them directly to me on whatsapp , twillio etc (any) Key Responsibilities: - The bot should primarily use Craigslist, OfferUp, and...OfferUp, and Facebook Marketplace platforms for sourcing listings. - The bot should filter vehicle category listings exclusively. Vehicle Filtering Criteria: - Vehicle make and model - Year range - Price range - Distance Ideal Skills: - Experience with bot programming and development - Familiarity with Craigslist, OfferUp, and Facebook Marketplace APIs - Understanding of the automobile market, specifically characteristics and identifiers - Proven track record of creating bots that can quickly and effectively filter sear...
● Tailored Solutions: We create custom web applications that meet your specific business needs, enhancing productivity and operational efficiency. ● Versatile Applications: Our solutions range from customer portals to complex inventory management systems, each built to address unique business challenges. ● Technology Stack: Node.js, , Ruby on Rails, Django, Laravel, MongoDB, PostgreSQL, MySQL, AWS, Docker.
...attracting more customers. - **Inventory Management**: I prefer the system to automatically update inventory based on sales. I want a seamless experience for my customers, with accurate information on product availability. & user-friendly login, checkout page Already i have - hosting, domain, Brand logo, Elementary Pro , razor pay payment gateway Ideal applicants for this job should have: - **Ecommerce Website Design Experience**: A solid portfolio showcasing ecommerce websites they have designed will be an advantage. - **Understanding of User Experience**: I'd like to work with someone who understands the importance of user experience in ecommerce. - **Proficiency with Inventory Management Systems**: Experience with setting up and managing automatic ...
...ecommerce consultant to establish my first online store. Your expertise is desired to direct me through each step of setting up the storefront, from selecting a suitable platform to designing an aesthetically pleasing and fully functional website. Your skills are needed to configure the backend and optimize the front end experience for customers. It is also important to me that the site is built with search engine optimization top of mind. Proper implementation of SEO best practices during the development phase, such as appropriate metadata, hyperlinks and responsive design, will help ensure our products are easily discoverable online from launch. User experience must be smooth across all devices. Your guidance on pricing, payment options and inventory management du...
...leans towards a minimalistic and clean design. The site should be elegant and easy to navigate. - Large Inventory: I plan to market and sell more than 100 products on this platform, so the design should accommodate a significant number of listings without compromising user experience. Skills & Experience: - Proficiency in Zoho Commerce: It's essential that you have prior experience with Zoho Commerce and a strong portfolio of successful projects. - UI/UX Design: A keen eye for design is crucial, as is experience in creating intuitive user interfaces. - E-commerce Expertise: Previous experience in designing and building e-commerce websites, especially those with a large product inventory, will be a big advantage. I'm looking for a designer who can bring cre...
I am in need of a technophile with expertise in Microsoft Access databases. Your task will involve: - Populating my database with customer data which includes names, addresses, phone numbers, organisation affiliations, and details of last interactions. - Inputting sales transactions data which include dates, product names, and prices. The ideal freelancer should demonstrate an adept understanding of database management, particularly Microsoft Access, and be able to accurately input data with keen attention to details. Efficiency, accuracy and attention to detail will be paramount for this project.
I'm seeking assistance to install a Laravel Vue JS Inventory script on my local Windows 11 PC. - I need help to install npm and Node.js on my system before proceeding with the script installation. - The script is specifically designed for Laravel with Vue JS, so I require a freelancer with expertise in these technologies. - Familiarity with XAMPP is a plus, as it will be used to run the script on my local server. - The ideal candidate should be able to walk me through the set-up process and provide any necessary troubleshooting support.
I need a talented graphic designer and video editor to assist in the creation of materials for an online training course. The ideal candidate will be well-versed in Canva, capable of translating my vision into content that is both visually appealing and informative. Key Responsibilities: - Create professional presentations: The designer will be responsible for crafting visually engaging and informative slides to be used in the online training. - Design social media graphics: I need a selection of graphics that will be used to promote the training on various social media platforms. - Design printable materials: The designer will also need to create printable materials, such as handouts or flyers, that will be distributed to participants. The Video Editor's Role: - Work ...
I'm in need of a customized Java program. I haven't decided on a specific purpose, but I'm looking for a skilled developer who can deliver a robust, well-structured program. The ideal candidate for this project should have a strong command of Java programming, as well as experience with program development for various purposes. The program may involve extensive data manipulation, network interactions, or other functionalities. Your ability to create clean, efficient code will be a big advantage. Please note that, as I haven't pinned down the exact requirements, being able to adapt and respond to shifting project needs will be crucial. Looking forward to hearing from you.
We are a direct, private money lender, and we need assistance remaking two of our loan program documents. Key Requirements: - Branding: The files should reflect the professionalism of our brand - Design: They should be visually appealing and engaging, suitable for a professional audience - Informative: The documents should be able to convey all of the information in a digestible manner - File Format: I need the final designs in an Adobe or Figma file format. - Output: we should be given two separate files We have included the two files to be remade + the company colors that we use in the contest.
I'm looking for a skilled 3D designer who can modify the existing 3D render of my c...from inside that's hard to tell apart from the rest. I’m thinking a magnet opens a hidden latch - The size of the compartment should be compact, about 25mm increase in the cover height will work but without causing a bulge or noticeable difference. Key Skills: - Knowledge and experience in 3D modeling and design - Attention to detail in rendering modifications - Familiarity with designing automobile parts is not a must but would be a plus. For this project, understanding the balance between functionality and stealth is very important. I look forward to seeing your unique design ideas. I may be able to provide a 3D scan of the cover if that will help or can provide exact dimen...
I'm seeking a skilled online marketer to help promote my psychiatric practice and increase my client base. This will be targeted towards all adults 18 and up. - Goal: Increase my client base significantly. - Target Audience: Adults age 18 and above. - Marketing Strategy: Primary focus on Search Engine Ads. The ideal candidate will have substantial experience in managing and optimizing search engine ads, as well as a deep understanding of adult audience targeting. Familiarity with the healthcare sector, particularly mental health, would also be beneficial. I would also like help in designing a website link for the search engines. I would like to have a presence on search engines such as Psychology Today, US News and World Report, , etc. which would encourage future patients
...try-inventory/id1162606257 Summary of the "Keep Fresh" Grocery Expiry App Project Project Overview "Keep Fresh" is a mobile application designed to help users track the expiry dates of their groceries. The app provides a simple and user-friendly interface for adding grocery items, viewing current inventory, and receiving notifications before items expire. The goal is to create a useful tool with AI features to help enhance user experience Key Features - Using Flutter + Gemini-API User Authentication: Sign in and create new accounts Edit profile and preferences Pantry Management: Display a list of scanned groceries Add new items via a plus button, redirecting to the camera for scanning food receipts or item barcodes Edit and delete existing items Ove...
I'm seeking an experienced professional to help me record online educational video lessons that are primarily targeted at Adult Professionals. These lessons involve frequent interactions such as: - Recording approximately 35 hours of video lessons in MP4 1080x1920 full HD. The tasks include - Shifting between slides. - Clicking on content to reveal additional information. - Uploading and sending the videos over to me. - Note: Recording must be clear of any external noise and unnecessary pauses between slides or content reveals. The challenge is to capture these interactions in one continuous video. I'm seeking someone with: - Proficiency in online video recording - Dedicated to quality and attention to capture all content Note, this isn't about develop...
I need a professional capable of locating online colleges offering a BBA in Marketing. Experience in educational consulting or market research would be ideal for this job. Furthermore: - The college should have global recognition, - Course work must be primarily online, - A background in business education, specifically marketing, would be of immense benefit. - The chosen college should have an AACSB, ACBSP, or IACBE accreditation as per the client's requirements. Only those with proper understanding of business school accreditation and online education should bid. This will ensure that the selected college meets the client's expectations and education standards worldwide.
I need a knowledgeable freelancer to set up the infrastructure for an OCI data warehouse on Oracle Cloud. This platform will be used for data analysis, reporting, and data storage. The scope of the job will include: - Configuring the Oracle Cloud to host the OCI data warehouse - Ensuring the system can handle storing and managing customer information, sales data, and inventory data A background in cloud computing, notably with Oracle Cloud and data warehouses, will be instrumental to the success of this project. Experience in handling similar types of data is a plus. This job requires someone who understands the nuances of OCI data warehousing and can deliver a reliable, efficient system.
I'm in need of a talented math teacher who can deliver engaging online tutorials focused on Algebra to my middle school student. Key Responsibilities: - Design and deliver online tutorials specifically in Algebra, ensuring that the content is engaging and age-appropriate. - Ensure that the student grasps key Algebra concepts, and can apply them in problem-solving scenarios. - Regularly assess student progress and understanding, and adapt teaching methods as necessary. - Create a positive and encouraging online learning environment. Ideal Candidate: - Proven experience teaching math, particularly Algebra, to middle school students. - Strong understanding of online teaching methodologies and tools. - Excellent communication skills, with the ability t...
I'm looking to recruit 10-20 affiliates for my upcoming essay writing competition. My core objectives for this initiative are to bolster participation and increase revenue. I'm seeking a professional who can take charge of tracking and managing the performance of these affiliates. Key Responsibilities: - Recruiting and managing 10-20 affiliates - Ensuring increased participation in the competition - Implementing strategies to generate additional revenue - Outsourcing tracking and management of affiliates Ideal Candidate: - Experience in affiliate recruitment for similar events - Proficient in strategies that enhance participation and drive revenue - Capability to outsource tracking and management efficiently - Excellent communication skills If you're a strategic affilia...
...Requirements: - Integration of Payment Gateways: This will be a fully functioning E-commerce website, so it's crucial that it supports a variety of payment methods. - Customer Reviews: The site should allow users to leave reviews and these reviews should be incentivized - users should earn credit when they write a review or share their experience on Instagram. - Inventory Management: I need a system that allows me to easily manage inventory and stock. - User Photo Upload: I want to enable users to upload their own photos at a specific segment on the website. - International Shipping with Tracking Number: As an E-commerce site, it's important that the website supports international shipping with tracking to ensure customer satisfaction. - User Credit System: The w...
I'm looking to develop a website for my online pizzeria, focusing on a customizable menu for our pizzas. This project will involve: - Developing an intuitive and responsive website design, allowing for easy navigation and a smooth user experience. - Integrating a menu with customizable options, enabling users to build their pizza based on their preferences. Ideal skills for this project: - Proficiency in web design and development - Experience in e-commerce, particularly in the food industry - Strong understanding of user experience (UX) and user interface (UI) design - Familiarity with integrating customizable options in menus The main goal is to provide a seamless and enjoyable user experience to make our customers fall in love with our pizzas.
...prequalifying low-income prospects for our revolutionary no-cost health benefits program. This is an excellent opportunity for individuals who are skilled in high-volume cold calling and have a passion for helping others access essential healthcare services. Responsibilities: -Make outbound cold calls to potential prospects to prequalify them for our no-cost health benefits program. -Conduct approximately 100-200 calls per day with a focus on efficiency and effectiveness. -Engage prospects in a professional and empathetic manner to gather necessary information. -Use qualifying questions to determine eligibility based on income level and current health coverage. -Clearly communicate the benefits of our program and address any questions or concerns prospects may hav...
I'm looking to have a chat feature added to my online tutoring platform to facilitate both one-on-one and group conversations between tutors and students. The primary purpose of this chat function is for instant messaging. Key Features Needed: - Instant Messaging: A real-time chat functionality that allows tutors and students to communicate seamlessly. - Group Conversations: The chat should support group conversations as well as one-on-one chats. - Message Read Receipts: The ability for users to know if their message has been read by the recipient. - Typing Indicators: This feature will show when the other person is typing to enhance real-time communication. - Offline Messaging Capability: The chat should allow users to send messages even when the recipient is offline, which w...
...experienced individual to fill the role of Database Architect/Lead Developer specializing in Netezza and Oracle databases. The ideal candidate will be responsible for designing, implementing, and maintaining database solutions that meet the needs of our organization. This role requires strong technical expertise in both Netezza and Oracle platforms, as well as leadership capabilities to guide a team of developers. Responsibilities Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies. Lead a team of developers in the implementation and maintenance of database systems. Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs. O...
I require a meticulous freelancer to carry out manual data entry from online sources to spreadsheets. Key Responsibilities: - Accurately transfer data from various online sources to spreadsheets - Maintain data integrity and ensure the accuracy of each entry - Organize the data in the spreadsheet according to specific guidelines Required Skills: - Proficiency in data entry - High attention to detail - Familiarity with spreadsheets - Ability to follow instructions carefully Previous experience in data entry or similar projects will be a plus. The ideal candidate will have a proven track record of delivering quality work on time.
I'm looking to create an engaging and comprehensive online training module specifically designed for new employees in the food industry. The training must cover the key aspects of food safety and hygiene, product quality control, food handling and storage, as well as GFSI management systems. The ideal candidate for this project should have a robust knowledge of these themes and wide experience in creating digital training materials. Ability to transform complex ideas into easily digestible content is a must. Fluency in Spanish, as this course will be delivered to a Spanish speaking audience, is a must too.
I have to transfer data and tables from oracle to postgres.
I'm in the process of setting up an e-commerce store on WordPress. The backbone of the site is ready, with a well-structured layout and a comprehensive list of items that need to be uploaded. I'm looking for a skil...the overall design of the site. Ideal skills and experience for the job include: - Proficiency in WordPress: You should have extensive experience in working with WordPress, particularly in the e-commerce context. - E-commerce design: A proven track record in designing e-commerce sites with a modern aesthetic is highly desirable. - Product uploading: Experience in uploading and managing a large inventory of products on e-commerce platforms. - Live chat support integration: Previous experience with implementing live chat support systems on websites will be a si...
I'm looking for a professional English trainer to help me improve my spoken English. I prefer online classes and aim to achieve an intermediate level of proficiency. Key areas I wish to focus on are pronunciation, vocabulary building, and conversational skills. Ideal Skills and Experience: - Proven experience in teaching English, particularly to intermediate-level learners - Proficiency in teaching pronunciation, vocabulary, and conversational English - Previous experience in conducting online classes - Familiarity with effective language learning methodologies. Please share your teaching approach and relevant experience when applying.
I'm in need of a detailed and impactful email marketing campaign targeting 16,000 recent graduates. I will share the Email data. The campaign is designed to promote and generate interest in my upcoming "Training & Internship Program." related Webinar Inviting. I will share the email Content as well. Key Responsibilities: - Develop and execute a strategic email marketing plan - Create compelling content that resonates specifically with this audience, focusing on the benefits and opportunities the program offers - Employ best practices to ensure high open and click-through rates - Monitor campaign performance and make data-driven adjustments as necessary I'm happy to discuss further details about the project with interested freelancers. Looking forwa...
As a media organization, we're seeking a knowledgeable developer to construct an inventory forecasting tool focusing specifically on advertising inventory. Key Requirements: * The tool needs to take into account the number of ad placements, impressions, and duration of ad campaigns as the key factors in its forecasting. * Updates on the forecast should be automated so our team gets fresh data daily. Ideal Candidate: * Experience in designing forecasting tools. * Understanding of the advertising industry, particularly with respect to ad inventory management. * Able to provide an easy-to-use interface with accurate forecasts to help guide our decision-making.
I'm in need of a professional who can set up Zoho CRM and Inventory Management for me. Although I don't currently have a Zoho CRM account, I'm well aware of its capabilities and I believe it could significantly streamline my sales process and improve customer relationship management. I have less than 100 products in my inventory and I'm looking to automate my inventory management. Key Responsibilities: - Set up Zoho CRM from scratch - Implement Zoho Inventory Management - Ensure smooth integration between the two systems - Provide recommendations for streamlining sales process Desired Skills: - Proficiency in Zoho CRM and Inventory Management - Prior experience in setting up Zoho CRM and Inventory - Strong understanding of sa...
I'm seeking an experienced Shopify designer to create an online store for my business. The aim is to provide a seamless shopping experience for customers. Key Requirements: - Design a user-friendly, engaging, and responsive online store - Incorporate essential e-commerce features such as product categorization, search functionality, and a secure checkout process - Ideally, the design should reflect the nature of the industry without sacrificing usability The successful candidate should have: - Proven experience in designing successful e-commerce websites, preferably on the Shopify platform - A keen eye for user experience and an understanding of effective e-commerce practices - Strong communication skills to ensure our vision and brand identity are accurately represent...
I need help with data entry. The task involves typing data from online sources into an Excel spreadsheet. Key Requirements: - Data Entry: The primary task is to accurately enter data from online sources into Excel. Prior experience in data entry is preferred. - Typing Skills: A good typing speed and accuracy are necessary for this task. - Familiarity with Excel: Basic knowledge of Excel is required to ensure the data is entered appropriately into the spreadsheet. - Attention to Detail: The data must be entered without errors or omissions, so attention to detail is crucial. The final deliverable should be an Excel spreadsheet with the data inputted neatly and accurately.
...tester to ensure the quality and functionality of my automobile website. Your responsibilities will include creating and executing test cases, and documenting any issues encountered during the testing process. Key Responsibilities: - Creating comprehensive test cases to cover all necessary aspects of the website - Executing these test cases efficiently - Thoroughly documenting any issues found during the testing process Browser & Device Compatibility: You will be required to test the automobile website on the Chrome and Safari browsers. Please ensure that the website is fully functional and visually appealing on these platforms. Ideal Skills and Experience: - Prior experience in manual testing, especially in the domain of e-commerce or automobile websites - P...
I'm running a small business that sells food products and various maintenance materials. Currently, we're managing our inventory through Excel spreadsheets. It's getting increasingly cumbersome and we're looking to streamline the process with a dedicated inventory management software. Key Features: - I'm interested in a system that will have robust reporting and analytics capabilities. This will help us keep a close eye on our stock levels, sales trends, and overall inventory health. Ideal Skills and Experience: - Experience with developing inventory management software, particularly for food and maintenance materials - Proficiency in building systems with strong reporting and analytics features - Ability to create user-friendly interf...
I have a significant amount of text data from physical documents which I need entered into a database. The ideal candidate will have experience with both data entry and database management. Key Project Requirements: - Data Entry: You will be responsible for accurately transcribing text data from physical documents into a digital format. - Database Management: The entered data needs to be organized correctly in the database. Prior experience in managing databases is essential. Ideal Skills and Experience: - Proficiency in data entry - Strong attention to detail - Experience in database management - Familiarity with data organization techniques I'm looking for someone who can complete this efficiently and accurately.
I'm seeking a proficient and experienced content writer to develop engaging and captivating scenario-based learning modules for a training program. This project will benefit from someone with: - Prior experience and expertise in creating content for various training programs - Deep understanding and knowledge in leadership development and employee engagement - Experience in designing scenario-based learning material which engages the trainees and contributes to better learning outcomes Your key role will be constructing easy to understand, compelling interactive learning scenarios ensuring a high degree of user interactivity that will assist the comprehension of the training programs. It's important not to forget to incorporate elements of fun and engagement within the...
I'm a beginner in coding and I'm trying to understand how pathfinding algorithms, especially greedy algorithms, work. As part of my learning process, I need a professional who can create a maze-solving program for me in the C language. Here's what I need: - The program should be able to tackle mazes of varying sizes. The minimum size should be 7x7, and the maximum size should be 20x20. It's important that the program can handle non-square mazes as well. - The maze should be solved using the greedy algorithm. - The output of the program should be a text-based representation of the solution, showing the path from the start to the end. For this project, I'm specifically looking for someone with experience in coding, particularly with pat...
...looking for someone to create a brand kit to include: - A brand logo with at least 4 variations, all provided as high resolution files - Brand guidelines to include colour palette, fonts and font sizing - Website banners/content - Powerpoint template with a minimum of 6 slide variations - Word template - Email signature - Anything else you think might be useful! About the Company: We are a new online brand providing HR Templates to small and medium sized businesses. We want to be seen as fun, innovative and modern. Our ideal customers are foward thinking business owners who genuinely care and value the contribution of their employees. Current thinking: We're looking for something very simple, text without icon is our current preference although we are open to ideas! Proc...
This project entails the creation of an intuitive mobile application available on both iOS and Android platforms. The app should have distinct features such as: - User login and registration - Push notifications - In-app messaging - Instant task and task status updates - Task-wise inventory functionality - Task completion insights - Features to highlight incentives, with filtering options based on locality Additionally, a functional CRM system is desired for: - Monitoring customer interactions - Generating sales reports - Streamlining contact management, and - Real-time tracking of earnings and redemptions. Ideal candidates for this project should have experience in mobile app development, CRM systems, and a deep understanding of customer operations. Proficiency in develo...
I'm seeking a dynamic digital marketer proficient in advertising across Facebook, Google and Instagram. The priority for this project is to effectively drive website traffic and generate quality leads. Prospective freelancers should have a proven track record tapping into varied target audiences such as millennials, business professionals, and parents. Expertise in tailoring marketing strategies to captivate these demographic groups is essential.
I have a project that requires data entry from various online sources into a document with specific formatting. Key Requirements: - Data Entry: You will need strong typing skills and attention to detail to accurately input the text data provided from online sources. - Data Formatting: The entered data must be organized and formatted appropriately within the document. Ideal Freelancer: - Experience with data entry, preferably with text. - Strong understanding of formatting in documents. - Attention to detail to ensure the accuracy of the entered data. - Good time management skills to meet deadlines.
I need a proficient developer to create a custom inventory management system that directly caters to the needs of supply chain managers. The following details explain my project requirements: Required Features: - The inventory management system should effectively track inventory in real-time - Maintain up-to-date inventory count instantaneously to avoid running out of stock - Implement intermediate level alerts for low stock to enable proactive inventory replenishment Skills and Experience: - Proven experience in developing inventory management systems is crucial - Understanding of supply chain operations will be beneficial - Demonstrable knowledge in establishing real-time tracking and alert systems The main aim is to optimize inventory...
