Temporary Product Managent & Warehouse System

Please read through our project below. We are currently having a much larger system built although this is not going to be ready for 5 months so we need a smaller temporary system built to tie us over until then.

The person who we choose to carry out this project must be able to come and visit us at our office in Chelmsford, Essex in order to discuss the temporary system in full so that we can be sure that you understand what is fully required.

Ideally we would like this system completed in 2 weeks, however we understand that this is not possible for some developers so please quote your soonest completion time.

Our company buys items from either a UK Wholesaler or a Chinese Supplier and sells the items on eBay.

We need a web based system built which is going to manage the whole process from ordering from these suppliers through to listing the product on eBay through to reordering when low on stock.

Please check out the 2 links below. These are basic incomplete versions (what we currently use) of what we need the temporary systems to be like:

www.packetpostuk.com/ukwholesale
www.packetpostuk.com/chinese

The process of how we buy from Chinese Suppliers and UK Wholesalers is slightly different, hence the need for 2 systems, or 2 systems built into 1. The temporary system will not need to control all of this for now.

Below I have outlined the 2 processes which are undertaken for the 2 different systems.

UK Wholesale Process:

We search a UK Wholesale Supplier such as www.delboyswholesale.co.uk
We order a product or number of products from that supplier
Order is delivered to our warehouse
Delivered products are arranged into correct position in warehouse
Products are listed on eBay
Products are sold and dispatched
When low on stock products are reordered


Chinese Process
1. Our company buys a product from eBay with the intention of getting it copied in China to resell on eBay ourselves
2. We decide what price we are willing to pay for multiples of the product to be produced in China (target price)
3. The product is delivered to our UK warehouse
4. The product is sent to our sourcing agent in China
5. Our sourcing agent receives the product
6. Our sourcing agent contacts factories and finds the lowest price to produce multiple copies of the product
7. Our sourcing agent lets us know what the lowest price to make multiple copies of the product is
8. If we are happy with the price and MOQ we request an invoice from our sourcing agent
9. We send the payment to our sourcing agent in China
10. The sourcing agent marks the order as payment received
11. Production begins
12. Production finishes
13. The finished products are sent from the Chinese factory to our sourcing agent
14. The products are sent from our Chinese sourcing agent to our UK warehouse
15. The product is received in our warehouse
16. The product is listed on eBay
17. When the product is low on stock we reorder more from our sourcing agent
18. The process begins again


If you see our current systems we need some sort of spreadsheet layout like shown, but now the spreadsheets should be split into sections with tabs at the top.

These sections will all look the same as the current spreadsheets and will have tabs at the top just like on 'Microsoft Excel' to switch between the views. The tabs should also indicate the quantity of items in the sections like this:
/ Products to Order (12) / Ordered - Due for Delivery (45) / Current Line Stock (345) /


Other Parts
There are 2 other parts which will need to be on the temporary systems. These 2 parts should be joint to both systems.

Warehouse Location Section
Please see http://www.packetpostuk.com/edittemplate/warehouseShelvingPlan.php

Basically each product we enter into this sytem (from the point it is ordered) needs a warehouse location. We need to be able to add and remove these locations and easily be able to move warehouse locations around and even assign 2 locations to one product.

When a new product is entered into the system the default warehouse location must be the first available location in alphabetical order

Postage Calculator Section
Basically when we add a product into the system we need to state whether it is a 'Large Letter' or 'Packet' sized item. When we also enter the weight of the product the Royal Mail postage cost should automatically be entered from using the data from an excel spreadsheet.

Additional
When a NEW PRODUCT comes into stock a shelving label must be printed out. We will require an option whereby once an item has been added on eBay we are able to print out shelving labels. We want to have 2 labels per A4 sheet (landscape view). These are then laminated and atached to the crates in the warehouse. The label should show the product image and by the side of that, the custom label and eBay item title.

I look forward to hearing fro you,

Paul Brown