Sql inventory program työt
Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.
Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...
Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
java program ..three ............................................................................................................................................
I have an online pre owned fashion and accessories store and need data entering assistance. Your job will be: - create a title for the listing - create a description for the listing - list on 2 or more marketplace platforms I will provide all the info and photos of the merchandise, give precise instructions on what to put in the description and how to list items. My plan is to do 10-15 listings per day.
I'm in need of a skilled software developer to create an API connection between my Woocommerce-based Wordpress webshop and an inventory management system. The project involves transferring specific order data from the webshop to the inventory system. - The type of data that needs to be transferred includes customer details, product details, and payment information. - I have the necessary documentation or specifications for the API of the inventory management system, which should facilitate this process. The ideal candidate for this job should have: - Proficient experience with API integration, specifically with Woocommerce and inventory management systems. - Ability to work with PHP and Wordpress to implement the required changes. - Good attention to de...
I'm new to the Medium Partnership Program and have been creating primarily creative writing content on a monthly basis. I'm looking to significantly increase my program earnings. - Ideal Skills and Experience: - Proven results in earning through Medium Partnership Program - Familiarity with creative writing on Medium Platform - Strategically increasing posting frequency to maximize earnings The objective here is not just to create more content, but to generate higher-earning content. Thus, if you are adept at understanding Medium's algorithms and reader patterns, that's a great benefit. Proven experience in boosting Medium Partnership Program income is a must-have for this project.
...Responsibilities Include: - Constructing a product catalog and search functionality to allow customers to easily browse and locate items. - Integrating an 'Add to cart and checkout' feature ensuring a simple and smooth transaction process. - Developing order management and inventory tracking system within the admin panel to help me keep track of orders and product stocks. Skills and Experience Required: - Proficient in PHP programming - Experience in developing e-commerce websites - Solid understanding of databases and SQL - Familiarity with different payment solutions Although there is no specific requirement for payment method integration at the moment, the ability to seamlessly add these in the future is essential. My project requires immediate attentio...
...canceling orders. Draft Orders API: Use this API to modify orders before finalizing them, giving flexibility in changes prior to order confirmation. 4. Return Exchange Shopify Admin API: Manage returns and exchanges by modifying order statuses and adjusting inventory. Customer APIs: Allow customers to submit return or exchange requests directly through the app interface. 5. Product Info Shopify Storefront API: Use this API to retrieve detailed product information, including descriptions, images, pricing, and inventory levels. Metafields: Extend product information capabilities by storing additional details in Metafields. 6. FAQ Shopify CMS (Content Management System): Utilize Shopify’s CMS features to manage and display frequently asked ...
I'm in need of a professional who can assist with a PERT analysis for my project scheduling needs. - The focus of this job is on project scheduling - I would require the PERT analysis to be at a small task level; a detailed task breakdown is not necessary - You will need to integrate the PERT analysis with Microsoft Project This project would be most suitable for a freelancer with: - Proficiency in PERT analysis - Experience with project scheduling - Knowledge of Microsoft Project or similar tools
...a highly functional and streamlined tracking spreadsheet for multiple facets of a construction project. Ideal candidates should be well-versed in project tracking/reporting, with a profound understanding of construction processes, including: - Timeline: The ability to articulate project deadlines and various stages of the construction in a clean, easy-to-understand calendar view. - Material Inventory: Significant experience creating systems for tracking material usage, including real-time updates, order monitoring, and being able to predict future needs. - Work Progress: Demonstrate a robust understanding of work progress tracking across multiple work fronts, and be able to visualize the progress in a tangible way for stakeholders to understand. The Spreadsheet should have mult...
As a business with diverse inventory, I am in need of an application to generate unique SKUs, track their usage, and store pertinent SKU information. A distinctive facet of the project will be the creation of a custom format SKU algorithm incorporating department codes, which will ensure efficient identification and organization on our part. As such, a freelancer with a background in inventory management systems or similar projects would be advantageous. This job will require: We have a convention to follow for creation of the SKU IDS. Furthermore I want the ability to add product images at the time of generating the SKU. - Strong knowledge in application development. - Experience with custom format algorithms. - Understanding of department code incorporation. - Skills in S...
Project Title: "Customer Order Management System" for an online retail business in MS Access. Objective: To develop a comprehensive database system that allows for efficient tracking and management of customer orders, inventory, and shipping. Key Features: 1. Customer Management - Store customer information including name, address, email, and phone number. - Track customer order history. - Customer feedback and preferences. 2. Inventory Management - Maintain a detailed list of products, including product ID, name, description, quantity in stock, and reorder levels. - Automated alerts for low stock levels. 3. Order Management - Enable creation of new orders with customer information, order details (product, quantity, price), and shipping method. ...
...product recommendations should be incorporated. - Content: I'd also like a video showcasing the footwear to be included. Product Types: - The store will sell a variety of footwear including sneakers, sandals, innersoles and socks. Prior experience in setting up stores that sell these kinds of products will be an added advantage. Product Inventory: - Initially, the store will have between 50 to 100 products. Experience in handling medium to large inventory on Shopify is required. Ideal Skills & Experience: - Proven track record in designing and setting up successful Shopify stores. - Strong grasp of e-commerce, particularly in the footwear industry. - Experience with product search functionality, product recommendations and video integration on Shopify. If you ...
I am looking for an expert in RFID technology and .NET programming to integrate the RFID into our current weighbridge system. Key Details: - 3rd Party System was developed using .NET and it does support API or external interface connections. - The task will involve programming to fully integrate the system with RFID technology. Skills and Experience: - Proficiency in .NET programming & SQL Database - Previous experience with RFID technology - Knowledge of API integration - Experience with weighbridge systems would be a huge advantage. Your role will be to ensure the smooth functioning of the weighbridge system post-integration and provide us with a user-friendly, effective RFID solution.
I am seeking an expert to help maximize sales for my private label of men's grooming products on Amazon. I am focused on growth and optimization, so your knowledge of Amazon's platform and proven track record in eCommerce will be crucial. Your responsibilities will include: - Setting up product listings - Marketing and advertising strategies - Knowledge of SEO strategies for Amazon - Inventory management Experience in the men's grooming sector is helpful, but not a necessity. Your knowledge of selling private labels and proven Amazon sales results are what I'm primarily looking for.
• Experience with Testing tools Experienced using SQL Advanced experience developing test metrics and reports Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Selenium Automation Unix Finan...
I'm looking for a skilled developer to create a comprehensive, easy-to-use ERP software tailored to the gold and diamond jewellery industry. This system will be integrated with e-commerce and feature several additional modules. Key features required: - Inventory Management: The system should efficiently track our jewellery stock levels. - Sales Tracking: Real-time data on our sales performance. - Customer Management: To maintain a customer database. - Credit Management: Tracking outstanding credit and sending payment reminders. - Finance Management: Tracking income and generating financial reports. - CRM: To maintain good relationships with our customers. - E-commerce Integration: Development of a functional e-commerce website and application. - POS: A point of sale system for...
...browsing, product selection, and checkout. - Select accessories based on Car Make, Model, Varient and Year filters needed. - Inventory Management: I plan to sync my product inventory with a supplier's database. This means the site must be capable of handling automatic updates and stock levels. - Payment Methods: I intend to offer Credit Card Payments, UPI, and Debit Card payment methods on the site. Ideal Skills and Experience: - Proficient in Woocommerce: You should have a strong background in working with the Woocommerce platform, with a focus on e-commerce design and development. - Inventory Management Expertise: Experience in integrating and managing automated inventory systems is a plus, particularly with supplier databases. - Payment Gateway Inte...
I'm in need of a versatile and comprehensive ERP system specifically tailored for a jewellery store. This system will need to be compatible with both Windows and Mac operating systems. Key Features: - Inventory Management: A robust tool to manage my stock of jewellery items, including tracking and updating inventory levels in real-time. - Sales and Order Management: A seamless system to handle the processing of orders and managing sales records effortlessly. - Customer Relationship Management (CRM): A centralized platform to store and manage customer information, with a focus on providing personalized and exceptional customer service. - POS & Credit Management: An integrated point of sale system that also incorporates credit management functionalities. - Finance Man...
I'm looking to have a virtual wardrobe website developed that offers outfit recommendations based on the user's inventory. Key Requirements: - Outfit Suggestions: The website should be able to provide personalized outfit recommendations. This will include suggestions for different occasions and mix and match ideas. - Clothing Inventory Management: The system should allow users to manage their clothing inventory. This may include adding, modifying, and deleting items from their virtual wardrobe. Ideal Skills: - Experience in developing websites with outfit recommendation systems. - Strong background in front-end and back-end development. - Knowledge in database management and integration. I'm open to discussing the specifics of the project with inter...
I'm in need of an expert who can help in developing a relational database using SQL and Python. The project will primarily revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data import/export mechanisms would be advantageous. Moreover, an understan...
More details: What type of integration are you looking for? Product inventory syncing How frequently should the product inventory update occur? Every few hours Are there specific product categories that need to be prioritized in the syncing process? Horse feed
We have a Pos software developed with React.js for front office and using asp.net for back office and need to integrate our system with Shopify and synchronize Orders and inventory between two systems. I need someone who has experienced this integration before. Please type #SHP# in the beginning of your reply and explain what exactly have you done before, what has been sent to Shopify and what has been received to add on Pos to synchronize two systems?
Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.
I'm looking for a professional photographer to help capture our used car inventory. This will be used for our online platform and listings. Key Responsibilities: - Photographing under 50 used cars - Ensuring that the photos are of high quality, showcasing the cars in the best light - Editing the photos to make them suitable for our online inventory Ideal Skills and Experience: - Proven experience in photography, especially with cars or products - Proficiency with photo editing software - Understanding of e-commerce and online inventory needs - Attention to detail and an eye for aesthetics Please provide a portfolio of previous work, especially related to car photography, when applying.
I'm looking for a developer who already has pre-built car rental software. The software should have the following features: - Vehicle inventory management - Online booking system - Payment gateway integration I need to customize this software to cater to the needs of tourists. This includes making the booking system user-friendly and ensuring that the payment gateway is secure and internationally accessible. Ideal candidate will have experience in: - PHP development - Software customization - Familiarity with car rental industry Your understanding of both PHP and the challenges of tourism will be a huge plus. The project requires someone who can hit the ground running and deliver a high-quality, user-friendly solution.
Odoo expert needed Key responsibilities: - Establishing an effective CRM system that is tailored to my retail business needs. - Implementing a robust POS system that can efficiently manage sales, track performance, and generate reports. - Designing an inventory management system that optimizes stock levels and tracks movement. - Creating a customer management system that facilitates targeted marketing and customer relationship building. The platform for all these systems should be on-premises. Hence, the ideal candidate should be proficient with setting up on-premises solutions. If you have experience in a similar retail setup and can provide references, it would be a plus. Please bid only if you have prior experience in setting up these systems in a retail environment.
...creating efficient solutions for inventory management? Krizz Retail is looking for a skilled Software Developer to join our team and lead the development of our inventory management software. As a pivotal member of our technology team, you'll spearhead the design, implementation, and optimization of a robust software solution tailored to our retail operations. Responsibilities: Collaborate with stakeholders to gather requirements and translate them into technical specifications. Design, develop, and deploy scalable and reliable inventory management software. Conduct comprehensive testing to identify and resolve any issues or bugs. Optimize system performance for reliability, scalability, and security. Stay abreast of emerging technologies and industry trends ...
...Predictive Analytics functionalities. Key Requirements: - Proven experience in implementing AI features in Power BI is a must. - Strong background in Natural Language Processing, Machine Learning Models, and Predictive Analytics. - Proficient in working with SQL databases and Online APIs for data integration. - Ability to deliver a dashboard with basic filtering and sorting capabilities. Your main tasks will include: - Integrating the AI functionalities into the Power BI project. - Ensuring seamless communication between Power BI and the SQL databases, Online APIs. - Implementing a user-friendly interface with basic filtering and sorting options. If you are confident in your Power BI and AI skills, and have the technical expertise to deliver such a project, I would love...
I'm looking to have a website built that will serve as a platform to showcase our car inventory. This website is crucial for our business as it will be the central point for potential customers to peruse and get to know the cars we have on offer. Key Features: - The primary function of this platform is to showcase our car inventory. Therefore, the main focus should be on the design that will effectively showcase the cars in the best possible light. - I would like the website to have a user-friendly search and filter option. This is important as it will allow our clients to easily find the car they are looking for. - It's important that the site is designed to be responsive across various devices to ensure potential customers can access it no matter what device t...
I'm looking to develop a sophisticated software for managing the maintenance and service aspects of my heavy-duty truck fleet. The system should be able to accomplish the following: - Maintenance Scheduling: Implement a robust maintenance scheduling system to ensure timely servicing of trucks. Print report of due data - Inventory Management: Inventory control for trucks list, spare parts, ensuring they're available when needed. Warn when low count, - Service Reminders: Automatic reminders for upcoming services and maintenance checks. - Reporting and Analytics: Provide detailed reports and analytics for performance evaluation and decision-making. - User Roles: Multiple user roles - for fleet owners, store manager, service technicians, and drivers. - Parts Management...
I'm looking to have a website built that will serve as a platform to showcase our car inventory. This website is crucial for our business as it will be the central point for potential customers to peruse and get to know the cars we have on offer. Key Features: - The primary function of this platform is to showcase our car inventory. Therefore, the main focus should be on the design that will effectively showcase the cars in the best possible light. - I would like the website to have a user-friendly search and filter option. This is important as it will allow our clients to easily find the car they are looking for. - It's important that the site is designed to be responsive across various devices to ensure potential customers can access it no matter what device t...
...bring Arthwise to life! This isn't your typical job post – it's more of a collaborative side hustle. We'll be building something together that has the potential to change the game in the finance world. What I'm Looking For: Someone who's passionate about building scalable applications. Experience with backend development, RESTful APIs, and microservices. Familiarity with database management (SQL/NOSQL) and cloud services. A creative problem solver with a knack for turning ideas into reality. What You'll Do: Set up the backend architecture. Implement core and advance functionalities. Database Management Monitoring and Performance Optimization and much more If you're up for the challenge and want to be part of something special, let&#...
...JavaScript, and PL-SQL, as well as familiar with Oracle Database, PL-SQL Developer, Oracle SQL Developer, Eclipse. The project involves writing comprehensive tests for a range of technologies including: - Java and JavaScript. - Spring Framework. - Oracle Database. - XML and JSON. - Junit. - Eclipse/Intellij. - PL-SQL Developer. - Utilizing Github and other version control tools. The ideal candidate must have a deep understanding and practical experience with these technologies. The project has an urgent timeline, so the selected candidate must be able to work under pressure and deliver high-quality results quickly. Ideal Skills: - Proficient in Java, Spring Framework, Oracle, XML, JSON, Junit, and JavaScript. - Experienced with Eclipse/Intellij, PL-SQL...
I'm in need of a skilled academic writer who can assist in developing a thesis (skripsi) on Education Research, particularly focusing on Curriculum Development. Requirements: - Knowledge in Education, specifically Elementary and Secondary levels - Skilled in Curriculum Development - Experience in academic writing Your main task will be to: - Create a comprehensive and well-researched thesis on the topic - Use a mixed methods research methodology - Pay attention to detail, ensuring the final product is of high quality and ready for submission. Ideal Skills and Experience: - Proven background in academic writing - Understanding of mixed methods research - Prior knowledge or experience in curriculum development - Education research expertise, especially in Elementary and Secondary ...
...our platform. This is essential to cater to our B2B target audience. - Efficient Inventory Management: Adequate inventory management is crucial to ensure seamless order processing. A Shopify expert who can streamline this process is highly desired. - Payment Gateway Integration: We are looking to integrate a variety of payment gateways to ensure a smooth transaction process for our customers. Ideal Skills and Experience: - Extensive experience with Shopify development, particularly in the area of website redesigns. - Strong understanding of e-commerce and B2B website requirements. - Proven track record of improving user experience and conversion rates. - Familiarity with payment gateway integrations and inventory management. If you have a portfolio that showcases...
...adept at building and managing a Shopify e-commerce platform from beginning to end. This encompasses: 1. **Website Creation**: I need to have a custom, fully functional, user-friendly, and visually pleasing design. 2. **Deployment**: I require someone with experience in efficient website launching processes and managing all technical aspects. 3. **Publishing**: Seamless integration with my inventory for product listing and publishing is vital. 4. **Marketing**: The ideal candidate has expertise in marketing strategies focused on driving traffic to the site and increasing conversions. Ideally, the right fit for this project has extensive Shopify expertise, strong design instincts, and a background in e-commerce. They should understand online consumer behavior and be fam...
I'm seeking an experienced developer to build an e-commerce websi...must be able to select and save multiple products or services before deciding on final purchases. - Product Search: The platform should incorporate a quick and efficient search functionality to help users locate specific products or services. On the management side, I'll be directly overseeing product/service inventory. Therefore, it's crucial that the platform integrates easy-to-use inventory management features. Previous experience in creating such platforms, with integrated inventory management functionality, will greatly be prized. Coding expertise, in-depth understanding of e-commerce functionalities, and a keen eye for detail are a must. Interested freelancers with references to ...
I am looking for an experienced interface developer to create and implement a real-time synchronization system between the Amazon SP API and Google Sheets. Ke...looking for an experienced interface developer to create and implement a real-time synchronization system between the Amazon SP API and Google Sheets. Key Responsibilities: - Create an integration for inventory management, using Amazon SP API and Google Sheets. The candidate must ensure up-to-the-minute data accuracy. - Develop and manage product listing and catalog management on Amazon SP API, synching this with Google Sheets in real time. Skills & Experience: - Proven experience with Amazon SP API - Expertise in Google Sheets and real-time data synchronization - Strong understanding of inventory and catalo...
Input:- You will get an excel file as input. Step1- Sort the Excel file by site name and place data in sheet 1 Step2- Sort the Excel file by site address and place the data in sheet 2 Step3- Sort the Excel file by latlong and place the data in sheet 3. After Sorting and creating 3 different sheet, we need to apply the logic to find exact duplicate and high match. Example - means in sort by site name we will find exact duplicate and high match site(75%) match and print exact duplicate/ partial match. Then for exact duplicate and partially match we are going to compare all row and need to print what is matching like site city, site state, site country etc
