Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

    Temporary Product Managent & Warehouse System

    5421
    £2.0k(approx. $2.4k)
    • Posted: 15 years ago
    • Proposals: 4
    • Remote
    • #3183
    • Archived
    Mark T.Murli M.Paul W.Momo G. have already sent a proposal.
    • 0
    • 0

    Description

    Experience Level: Expert
    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
    Daviid W.
    Daviid W.
    0% (0)
    Projects Completed
    -
    Freelancers worked with
    -
    Projects awarded
    0%
    Last project
    6 Jun 2023
    United Kingdom

    New Proposal

    Login to your account and send a proposal now to get this project.

    Log in

    Clarification Board Ask a Question

      There are no clarification messages.
    5421
    £2.0k(approx. $2.4k)
    Daviid W.
    Daviid W.
    0% (0)
    Projects Completed
    -
    Freelancers worked with
    -
    Projects awarded
    0%
    Last project
    6 Jun 2023
    United Kingdom

    Related project Searches


    data entry microsoft excel product management ebay order processing process management sales orders and invoices sourcing agent spreadsheets warehouse wholesale

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2023 People Per Hour Ltd
    We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
    Cookie Settings
    Accept All Cookies