I sell online in several marketplaces. Although they offer inventory, I don't accurately depend on the quantities, as I often want to keep the item for sale as I can usually quickly get more stock. Because of this I also keep lists of all my items in Excel sheets, so I can see exactly how much of each item and the values that I am holding.
What I want is a solution that I can host online, on the could be easily customizable and accessed by multiple users from any location. So it seems to me that the right idea might be a PHP script backed by a MySQL database.
I need a script written with further coding provided as needed at an hourly rate later. I would like your bid to be able to produce the basics I will detail next and then let me know what your hourly rate will be to further customize the script as I need it moving forward.
Your bid for this project needs for you to write and install a script to give me the following:
Login screen, support for multiple users.
Ability to search for item by keyword of item title, supplier or SKU and other customizable fields
To be able to add or remove inventory items
To be able to upload a photo of an inventory item and that will be displayed with the item. Photo must be changeable & removable.
Inventory item fields to begin with should be TITLE (50+ characters), SUPPLIER CODE (20+ characters), SUPPLIER NAME (30+ characters), SKU (10+characters), QTY (5 characters), COST EACH, TOTAL COST OF QTY ON HAND,
To be able to add additional customizable fields to have in inventory items.
To be able to import a CSV file in to the inventory by category
To be able to export a CSV out of the inventory to show which fields you wish to export
To be able to set a customizable par level that when a product falls lower taht an email is sent, email to be configurable. Par must be settable by category.
To have a report to see all products in system.
To have a report to see all products below par set (that need ordering)
An easy to use menu system
An easy to use screen to search for a product and then update the quantity.
An easy to use screen to add new products.
An automated zipped backup of the database to a specified folder, configurable in the script, keeping a rolling 7 days of backups only.
A button that will allow me to export the SQL manually for download in text.
Other items you can suggest I might not have mentioned, but please confirm with me about them first, I do not want what I won't need.
I do NOT need customer names or addresses or invoicing management.
I do NOT need supplier addresses or management, I just need the supplier name and their product code with each product.
I do NOT need receiving or issuing.
I want to see a demo of this running as a mock up on YOUR server before will the project will end and I want to be able to have you make adjustments until it is right for me. I think it is a simple project for a good script writer.
We only have a little business so we only need this style script, we also do not want to pay for more than we need. Customizable is the key and your willingness so offer further help later as needed.
If you bid please give me at least one URL to see a similar script you have written, with a login. Please do NOT bid without giving me this I must be able to see your work.
7 freelanceria on tarjonnut keskimäärin 689 $ tähän työhön
Dear sir, I have already built solution which will serve u very well. Minor changes are required. Please let me know if u r interested. I will prepare a demo n show u how it works. Regards,
I have extensive experience with such applications. At this point I already have a web application in production: gestplu. For much more details see PM.