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.
I meant to add I need the ability to add or edit items to inventory in a list format or using a screen to add additional items or edit just one item. The main thing I do as an inventory task is adjust an item quantity, so there should also be a fast qty adjust screen that I can just adjust quantity and then save and search for the next item I want to adjust quantity to.
The initial fields for inventory items needs to also have one called ASIN (10 characters)
I also need as part of this project to be able to keep a list of supplier names and emails. I do not need to manage the suppliers further than that. Supplier name needs to be something I can choose in an inventory item / product. I need a section for ordering. Where I can go and choose a supplier and it will show me a list of products connected to that supplier, I can choose one or more of the items and build and email to the supplier as an order. I want to send this email from the same screen. The order needs to be in the email and not as an attachment. If you have already bid before I wrote this note, please adjust your bid if necessary to accept that this is part of this project.
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.