Đã Hủy

Database Development

I need to develop a database to act as an inventory/order management program for my online woocommerce shop. I already have a base done in Microsoft access which can be built on fairly easily.

The general idea of the database would be to flow as follows:

- Download the order from woocommerce in the required format such as a .csv file and use that to upload the details of that order into the database. Details including: Order number, order date, client details, products ordered, quantity of products ordered, etc.

- For the order, I will need to be able to mark each individual item in the order as either "to be packed" (default), "packed" or "delivered" in order to track the progress of each item in the order.

- The order as a whole must also be able to be updated to either be in the "processing status" (ie still be packed and delivered) or in the "completed" status in which all the items of the order have been delivered.

- On the other side, I will need to be able to track orders made at suppliers by adding details such as Supplier Name, Order Number, Products ordered, quantity ordered and expected delivery date, etc.

- Additionally the status of the order from supplier would also need to be able to be marked as "pending" (ie order has been emailed but not made), "ordered" or "delivered".

- A Stock Management page that shows per item the stock on hand and stock currently on its way in. The stock on hand will be based on all supplier orders marked as "delivered" and after subtracting all the individual items that are marked as delivered" on the customers orders. Stock currently on its way in will be all supplier orders that are marked as "ordered".

The following reports must be able to be generated:

- List of orders and status of the items in their orders as either "to be packed", "packed" or "delivered". All orders that have been marked as "delivered" in total should not show up on this list.

- List of books to be ordered from suppliers by calculating the difference between the orders currently in "to be packed" + "Packed Status", less the number of books currently in stock + the amount of books currently in "ordered" status from suppliers. Please see base template attached as "Summary".

- A list of all supplier orders that are on their way in and details of those orders. These will be all orders marked as "ordered" form suppliers. Please see base template attached as "Orders En Route"

Ideally i would like a front end in which to edit and update orders and statuses (and which you need to click a information button in order to confirm changes made for the order) and a backed that stores this data and which is protected.

Please let me know if you have any other questions in this regard. I have used Microsoft Access before but am open to any other options.

Kĩ năng: Microsoft Access, PHP, MySQL, Lập trình cơ sở dữ liệu, Quản trị cơ sở dữ liệu

Xem nhiều hơn: jsf database development, database development project management, poker database development, database development php mysql, database development soccer manager, remote database development jobs, database development turbo, poi database development, product database development, database development contests, inpuut output forms database development, airline reservation system database development, database development user profile name address zip country, microsoft access database development vba, hourly rate database development, database development business plan data manipulation web development, best version control system database development, freelance database admin options, facebook database development, outsourcing database development ilance

Về Bên Thuê:
( 0 nhận xét ) Durban, South Africa

ID dự án: #23348940

25 freelancer đang chào giá trung bình $214 cho công việc này

hits

I suggest a web application in PHP and MySql. I have delivered many custom web applications, including inventory management solutions. I have developed many Woocommerce sites also and can look into export of order data Thêm

$1000 USD trong 15 ngày
(973 Nhận xét)
9.0
Friends4it

We have built several ecommerce stores like [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Thêm

$250 USD trong 6 ngày
(320 Nhận xét)
7.8
latatestTech

Hello There, With Freelancer Preferred badge bound to give 100% Quality (Let's Chat) A great team is here for your service!! I read the project description properly, and I agreed to fulfill 100% of all your requiremen Thêm

$155 USD trong 7 ngày
(167 Nhận xét)
8.0
coolguyinus2004

First i dont know whats your budget is But i guess the budget price will be around 800$ for this. SO lets negotiate on price once you see my deal further. 1) This report/order management has to be done in PHP/MYSQL on Thêm

$100 USD trong 7 ngày
(348 Nhận xét)
7.7
branislavm

Hi! Yes, MS Access is still the best tool for this. I will need one of the CSV files in order to start making it. On top of that, I'll add other tables so you can track the orders. Finally, the 3rd part of the app wil Thêm

$250 USD trong 7 ngày
(315 Nhận xét)
7.7
phpdeveloper100

Ready to make complete software for you. Please open Message box so that we discuss it in detail Expertise ================== - PHP - Code Ignator - Laravel - Wordpress - Zen-cart - X-Cart - Website Design - Ajax - H Thêm

$286 USD trong 7 ngày
(80 Nhận xét)
7.3
Prashantskin

[login to view URL]' I have gone through your project requirements and the two pdf files. I will develop your application in Microsoft access I will develop all the data entry screens and reports as per your description and pdf Thêm

$200 USD trong 7 ngày
(556 Nhận xét)
7.3
fanninson45

INTRODUCTION I have studied your 2 attachment. I can develop your database application with the reports. Message me back or request for a demo. I am an experienced Professional with Database Programming and Administrat Thêm

$190 USD trong 17 ngày
(32 Nhận xét)
6.1
zu02

Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VBA. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f and see following screens for : " Thêm

$250 USD trong 7 ngày
(52 Nhận xét)
6.2
shyamvijaywargiy

Hello ,hope are you well there. I have seen your requirement and I am interested in this.I am ready from now to work on your app. i have 7 years of experience in mobile (android / ios ) app development. I will complete Thêm

$100 USD trong 10 ngày
(12 Nhận xét)
5.8
hammabouzazi

Good day knowledge spreader! I'm assuming you're the owner of the book store and looking for a way to make your life easier managing your stock and different daily shores! I'd love to say that I'm happy that the book Thêm

$250 USD trong 5 ngày
(14 Nhận xét)
4.7
nblsoft

Hi sir, I am interested in your project and offer my services. I have skills in PHP and Access including database designing and front end development. I can make you a system in which you can access your woocommerce Thêm

$140 USD trong 7 ngày
(10 Nhận xét)
4.6
tutulsoft

I am suggesting Please do not go with MS Access ... Either MySQL or MS SQL you can select for future major up gradation of your system ... i am 17 Years Software Professional on Database Software Development and Implem Thêm

$250 USD trong 7 ngày
(7 Nhận xét)
4.2
alokes

HI, I AM A SOFTWARE PROFESSIONAL DEVELOPING SOFTWARE IN MS ACCESS WITH VBA FOR LAST 22 YEARS. I WOULD LIKE TO DEVELOP THE DATABASE IN MS ACCESS AS PER YOUR REQUIREMENT AND INPUT PROVIDED BY YOU. THE TASK WILL BE COMPLE Thêm

$100 USD trong 5 ngày
(6 Nhận xét)
3.6
mumarsami

I am senior IT professional with over 15 years of experience with databases and data warehouses. As per your project description I have all the required skills and experience. If you hire me I will be able to do all Thêm

$250 USD trong 7 ngày
(6 Nhận xét)
2.7
Asu2f

I will work in cheap budget, which can be renegotiable, please send me project details.i have experience in web design and database administration.

$30 USD trong 7 ngày
(0 Nhận xét)
0.0
mrlux

Luck smiled at you. I already decide this task. See an example [login to view URL] (user, pass) My professional skills will help you easily analyze a large amount of data on various factors. I can write optimiz Thêm

$250 USD trong 3 ngày
(0 Nhận xét)
0.0
$166 USD trong 3 ngày
(0 Nhận xét)
0.0
$155 USD trong 6 ngày
(0 Nhận xét)
0.0
Tienbk

Hi. I ‘ve been working as software devoloper for more than 9 years and i ‘ve known about Access as well. It ‘ll be glad to help you with this task. Thank you and have a nice day

$105 USD trong 2 ngày
(0 Nhận xét)
0.0