Find Jobs
Hire Freelancers

Develop a Purchase Order/Supplier/Commercial Invoice & B3/Order Completion Application

min $5000 USD

Closed
Posted almost 10 years ago

min $5000 USD

Paid on delivery
There are 3 modules to this product. Module 1: Purchase Order System Current shopping cart software being used is Opencart, and using MySQL database. I require a purchase order system to be created based on the orders placed within the system. We have hundreds of suppliers we purchase from. We want to be able to import the suppliers spreadsheets into the po system and have the system be able to update the pricing on a regular basis. We want to have a one to many relationship with each product (ie. Product 1 may be available from Supplier 1, Supplier 3 and Supplier 4, and have it show all the prices. The system will pick the cheapest price by default, and also allow for an override option. Selling price will also be defined by markup and exchange rate, rounded to .99. Sales price will also be able to be overridden. The opencart database will receive the sales price, cost and supplier part number. Purchase orders will be created on a status basis (ie. only orders in Processing and Partial status). Purchase order will not be complete until the purchase order is created. Purchase orders will have optional fields for account information, shipping address, billing address, etc. Purchase orders will be able to be sent via email or fax. We currently have a similar system setup with our Zencart store, but would now like one developed for our Opencart Store. When receiving products against the purchase order, we just want a screen with an option to enter the part number and quantity received, and have the system associated the part number with the purchase order. A report will be generated that will allow us to see any products that have not been satisfied. The PO system will show all products in a processing state, and only hi-light the ones with an inventory less than the threshold ( which would be set in the PO system). We will also need a field for minimum quantity to order (as we get discounts on ordering in quantity). Also, when receiving the product we want the system to be able to print labels to a Dymo labelwriter. The label will have product name, part number with barcode, person who generated the code, and bin location. Module 2: Commercial Invoice & B3 We need a module to create a commercial invoice for products that we sell from our US company to our Canadian company. We would have an input screen where we put the part number and quantity in. When ready we would generate an invoice that would have the part number, cost + 5%, and total, along with totals by Country of Origin and Tarrif code (all information would be housed in PO system above). We generate these invoices on a daily basis. Once complete the system would generate a B3 form that would put the various information on a sheet for importing the goods into Canada. (a sample is attached [login to view URL]) Module 3: Order Completion Application We have hundreds of invoices that are completed with products in 2 warehouses. We want to be able to have a screen that allows us to see all the orders that are not fulfilled and how many products are required to complete the order. In location A, the staff punches the invoice number in, then they scan each product that they have (for example 3 of 9 products) ... the screen would then display the order number and then 3/9. Then location B would do the same, and say they have 3 more products, the screen would then show the invoice number and 6/9. We would also want the screen to display an aging status (business days and calendar days) and change colors based on a certain threshold, ie. green for 1-5 days, yellow for 6-10 days and red for 11+ days. The system would check to see if the order is shipped, and when it is, would be removed from the screen. We would like to have this available for view on a computer screen, and a large TV monitor in a warehouse.
Project ID: 5806481

About the project

34 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
34 freelancers are bidding on average $6,013 USD for this job
User Avatar
A proposal has not yet been provided
$5,154 USD in 30 days
5.0 (173 reviews)
9.4
9.4
User Avatar
Warm Greetings We have mentioned a place holder bid to initiate a discussion . Do let us know your availability on chat for us to discuss the project in more detail before finalising the bid. Look forward to hearing from you soon Thankyou Sam ============== About ESolz: 1. We are into this business for over 10 years 2. We have expertise in web and mobile based application and site development
$8,247 USD in 70 days
4.8 (330 reviews)
9.9
9.9
User Avatar
Dear Sir, I have read your Project Description and understand the overall requirements of all the modules. In fact, I have also checked the attached PDF but this kind of project really need in depth meeting to discuss everything before giving you our final/firm estimate, as for now our bid is just a placeholder. So, this initial message is just a formal confirmation that we are interested in this Project & technically there are no hurdles, as we have experienced team (40 + developers & few Designers) but for the price/time-line and overall process of work, we can discuss, once you drop me a message thru' Freelancer message board, as our first message to you is not formatted in a proper paragraph & also limitation of characters. Secondly, I wanted to ask you, if we can use PHP instead of Python? Look forward to hearing from you and talking to you further thru' Freelancer message board. Regards, YK LEADconcept
$5,154 USD in 60 days
5.0 (111 reviews)
9.1
9.1
User Avatar
Hello There We are the team of web professionals and we are very confident in Web based field to do anything we know to implement the design and development with fully functional website according to your needs. We have done various complex projects for our partners and we are very expert in providing best services on time with reasonable price so give us a chance to the Worlds Development Company as our main focus on Webs. We do take part in End to End development, start from the conceptualization of ideas and bringing that on paper (Analysis, requirement gathering, Documentation, Modular development, module testing, integration, regression) to final delivery (UAT and Post delivery support). I would be able to sign the NDA/Contract to get some more information about the details of this assignment and discussion. Waiting for prompt response and you will get reply instantly. Kind Regards Vikky
$7,216 USD in 45 days
4.9 (133 reviews)
8.8
8.8
User Avatar
Hello, My name is Adrian. I represent a software development company and we are looking for a long term relationship with you. I read the full description and I understand what you are after. We can do everything described here. I estimate that it will take us 2-2.5 months of work plus 1-2 weeks of testing to do everything. I have some questions, maybe we can schedule a time to have a conference? If you need to know any information about my company, about the programmers, about our portfolio or previous clients please let me know and I will answer asap. Best regards, Adrian, CEO, Lead Soft.
$10,105 USD in 90 days
5.0 (48 reviews)
8.2
8.2
User Avatar
Hello, Thanks for inviting me I have read the details in all these 3 modules and happy to do the customization needed. I propose to built a solution where before importing any Excel/ CSV, we will auto-backup the related table (s) so in case of any crash or errors, we can recover the latest data within seconds. We can actually do it in many ways and I would like to discuss it once you are ready. I also propose to automate the processes as much as possible - especially the invoicing part. Based on scheduled jobs on fixed timings or based on transactions. This will ensure the database queries dont slow the server what so ever. My final proposal will be to keep it secure and filtered. so in case if the excel/ csv data is corrupted, it will not effect our database in anyways. I am very confident about this project and would like to start immediately. Please feel free to ask any questions that you want to discuss or want me to answer. Thanks, Bipul
$5,154 USD in 30 days
4.8 (111 reviews)
8.1
8.1
User Avatar
Hello Sri Technocrat will provide fully interactive website for your project. As per the detail, Sri Technocrat will provide three template functional schemes and sample pages to make your choice for layout. It will be developed as per your requirement document. We would invite your feedback and suggestions on the selected format so as to make it exactly as per your requirements. The timeline for development is stated along with the bid. During development period, the site would be visible on one of our test servers. At the time of transfer of complete application to your control, we will send you complete code and documentation. We will provide a copy of complete site management manual. The total cost of the development is stated along with the bid. Sri Technocrat takes services of professionals in the fields of graphic designer, site management and programming. In order to provide best performance and in time, we accept milestone payment along with contract. We transfer all source codes, security protocols and password management to the client. We carryout site development in a modular form, so that and additional feature / facility can be added without disturbing the existing site. Thanking you for considering Sri Technocrat as a partner in development. With regards, Sri Technocrat
$5,263 USD in 30 days
4.8 (82 reviews)
7.7
7.7
User Avatar
A proposal has not yet been provided
$5,154 USD in 30 days
4.9 (150 reviews)
7.2
7.2
User Avatar
**********************.. YOUR SEARCH ENDS HERE .. ********************** GET IT DONE RIGHT THE FIRST TIME! My clients are first and communication is very important. Hello Sir/Ma'am, yes indeed I read descriptions however, I have 1 chance to make a first impression. I want to ensure you that I have the skill-set needed to complete your project. Once you message me, I will send more past work examples your way and more detailed info. Please note: I do Not have a dozen projects in progress. The system works in such a way that even if the projects are very old & they we're paid a different way, possibly before the new milestone setup.. that is how it looks (as ongoing). I am ready to work. I look forward to talking to you further and getting started. I've been working in simple and extensive Website Coding (PHP, MYSQL, WORDPRESS, JOOMLA, JAVASCRIPT, CSS, HTML), Website Designing and Graphic Design for ***over 10 years now. After working as a ***top sales and marketing representative for Sears, I began to independently pursue my career. I have experience in do-it-yourself CMS, Logos with flare and flash design to name a few. I went to college for business and marketing so ***I know what it takes to sell. Get it done professionally and get it done right THE FIRST TIME! Some people like to know who they are working with on the personal side. If you are one of the types of people, please watch my short video at www.blissent.net. You'll see a big reason why I work! Thank you, Timothy
$6,288 USD in 25 days
4.7 (38 reviews)
7.4
7.4
User Avatar
A proposal has not yet been provided
$6,666 USD in 65 days
4.7 (64 reviews)
6.8
6.8
User Avatar
Hello Sir, I have good experiences in these kind of work. I can do this job for you ASAP. Please check my feedback and award me the project. Thanks.
$5,555 USD in 30 days
5.0 (44 reviews)
6.2
6.2
User Avatar
Hi. I studied your job post carefully. I can handle your requirements perfectly and I would like to discuss in detail. You can check my profile for previous work results. Thanks
$14,432 USD in 90 days
5.0 (10 reviews)
5.8
5.8
User Avatar
DO NOT PAY TILL PROJECT IS COMPLETE! Hi I am Brian, I am from Cyboticx a leading Digital Agency specializing in product + brand development and lead generation optimization. Before getting into more details lets put the following out there, we do not charge before work is complete. We are able to provide references from some of the largest companies in America that we have worked with. We have several branch offices (LA, San Jose, Chicago, and NJ) so you can reach us anytime. We have worked with both large enterprises as well as small mom and pop shops and we value each client equally. Let me know if you would like us to start working on a proper technical document and proposal for your project! You can view our portfolio at https://www.freelancer.com/u/cyboticx.html
$5,670 USD in 30 days
5.0 (2 reviews)
0.7
0.7
User Avatar
Understand their project needs. Explain how your skills and experience make you the right freelancer for the job. Outline ho
$5,555 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I have a team of designer & developer so our company can set your entire requirement in short time with new ideas & also fix your other problems too. We done so many international projects but just start working with freelancer .com thanks
$5,000 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi , Hope you are doing well. I have almost 4 year of experience in web development in different technology including php,html,css,javascripts,jquery etc. and working as a individual freelancer so also I have other experienced web developer and designer. I can provide you solution for your requirement and also we can offer you further support, maintenance and enhancement for this, if required on estimated effective cost. We believe in out quality working and support and will provide you best service in minimal cost in the market. We have dedicated team members possessing different skills and creativity. It will be my pleasure to work with you. Looking forward to have a good professional relation between us.
$5,000 USD in 45 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I had some questions but because I am new to this site, I could not ask them in the public forum (it is restricted for new people for some reason). 1. Does the B-3 need to be output/archived in a PDF format....i.e. other than just rendered digitally per request .....for legal or other reasons. 2. How does the Dymo label writer receive jobs. I have used UPS thermal writers in the past and they have their own drivers and formatting that isn't similar to a standard printer. As for my qualifications, I actually wrote a complete ERP/CRM System for a company I founded and then sold called Dive N Dog which made stainless steel marine products. We ran three warehouses in two different countries and had very similar functionality in what we called our "Shipping Queue" which showed very similar information to what you are talking about. We had the ability to partially ship orders from any of the warehouses and the other warehouses were aware of the "outstanding" items as well as what was left after all three warehouses reviewed which was shows as "Backorders". Anyway, I feel like I have some good context to help you solve this problem!! If you have any questions, please ask! 239-465-1866 scott
$5,555 USD in 45 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Canada
0.0
0
Payment method verified
Member since Jan 30, 2014

Client Verification

Other jobs from this client

Catalog Design
$1500-3000 USD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.