E-commerce Site

An e-commerce website that integrates with my physical fireworks store. The project is enhancements to CRELoaded and is to run on Linux. Olla Cart is currently used to integrate the physical store with the Zen-Cart database and provide cash register type functionality. You may chose to enhance Olla Cart or replicate it’s (rather simple) functionality. I will retain ownership of all source code and graphic element deliverables. I will supply all video, flash animation and product images. Payment of 15% of the bid amount will be made after a detailed specification is delivered and agreed to. The most important aspect of this project is that the website is secure and stable. The next most important element is the design, layout and usability, especially the shopping cart. Price is less important if you can provide a high quality, secure, attractive solution. You will receive on-going work if the first project is good. ## Deliverables 1. Introduction This e-commerce website must be integrated with my existing physical store. The name of the e-commerce web site is “[login to view URL]? which is different from the name of the physical store. 2. Hosting, E-Commerce Engine and Technology I will contract the hosting company since I want it to be in North America. The cost of hosting should not be included in the bid. The videos will be hosted by the website. Enhancements will be made to CRELoaded professional ??" a variant of osCommerce. I will pay the licence fee. You may have to perform the installation of CRELoaded on the site. I will upload the product descriptions, photos and videos to the completed web site. If you wish I can provide a few samples for your work. Php/mySQL, JavaScripts/AJAX or similar technology and Flash or equivalent technologies are acceptable. However, Java _cannot_ be used. Olla Cart (or equivalent) will be used to provide simple cash register (point of sale - POS) type functionality. This product is designed to integrate osCommerce type e-commerce sites with physical stores. However, some of the features described below will have to be integrated with Olla Cart and you may find it simpler to replace Olla Cart’s POS functionality than to enhance Olla Cart. For example, many of the specials and discounts will be applied using the cash register interface. An Olla Cart demo can be found below: <[login to view URL]> Note that I will not be using the reports provided with Olla Cart. 3. Web Site User Interface *The shopping cart contents will be visible everywhere in the website in a box either on the right or the left of the page. The shopping cart will be updated using AJAX or similar technology so adding or deleting products will not cause the entire page to re-draw.* The main page will have four links as follows: · Product Catalog. · Specials and Discounts · Video Library Learning Centre · Shipment Tracking The main page will also display a scrolling best sellers listing “Contact Us?? and common CRELoaded/eCommerce content. 3.1. Product Catalog Page The Product Catalog link will lead to a list of the categories, eight in all. These categories have a total of 113 products in all. *The existing CRELoaded product and category pages must be enhanced to include zero or one or two links to the video library. * The product description will include a photo, a description and an “in-stock?? indicator, all basic features of CRELoaded. I will be responsible for loading the product descriptions and I will supply all of the product photos. I currently have the products photographed on a black background but I could have them photographed on a different coloured background if required. 3.2. Specials and Discounts Page The Specials and Discounts page lists currently available specials. This will include discounted products, free shipping and so on. Some discounts are applied automatically and are listed for information. Others have a link so that the customer may add the product or products to his shopping cart. Some examples are: * *Free Air Bomb when you bring in this coupon (in-store only)* * *Free product Sparklers any purchase over $10 until December 24. (in-store only)* * *$50 of free products for every $500 cumulative amount spent. Thus this special is available after $500 is spent, $1000 is spent, $1500 spent (in store or on-line add up together)* * Product usually sold for $39.99 is now discounted to $35.99. * Free shipping within Alberta with order over $100. * Free shipping within Western Canada with order over $200. * Free shipping within Canada with order over $500. *A facility to create various kinds of “one per customer?? specials has to be added to the admin pages. Each of these specials will have a name and a description of the criteria, possibly a start and end date for applicability. Once a customer has taken advantage of an offer, this will be noted in the system. When the total cost of the order is calculated, the special offer will be used to adjust the order. * 3.3. Video Library Learning Centre *The video library learning centre is an inter-linked and searchable by title and keyword set of videos and flash animations. The videos and flash animations may have links to one or more products. Clicking on the link will add the product to the shopping cart. Additions and modifications to the video library learning centre will be done through an administrative function. * *Videos and flash animations in the video learning library have the date added, an optional title, an optional image and an optional description.* *It will be possible to search the titles/descriptions. There will be a feature to list new videos/flash animations.* 3.4. Shipment Tracking Link The shipment tracking link will just be a link to DHL’s shipment page. 4. Inventory Enhancements 4.1. Inventory Levels *For each product it is necessary to maintain a desired stock level. That is, how many of each product should be stocked. This will be a separate value for each product.* *For each product it is necessary to maintain the number of items to order when ordering. This is sometimes known as the case size or case amount. * These inventory management values will not be displayed to the customers using the web site. 4.2. Order Received Page *Orders of many products are received in shipments. An employee must verify the number of products received and when he is satisfied that he has counted the entire order correctly, he must update the CRELoaded database. This will be done through a new admin page called “Order Received??.* *When using this Order Received page the employee will scan bar codes. This will show a small picture of the product and the product name. The employee will then type in the number of products received in the shipment. The employee will continue to scan products and enter number of products, building up a list of products received in the order.* *The products will remain in the order they are scanned unless the employee decides to sort them by product number or product description.* *When the employee has satisfied himself that the entire order has been correctly entered then he will have the order applied to the product counts stored in CRELoaded. If the employee does not apply the order then he has the option to discard it.* * * *This broadcast message was sent to all bidders on Monday Nov 17, 2008 11:53:35 PM: I have updated the requirements description and extended the deadline until February 19. Thank you for your interest and continued patience. ## Platform The platform is CRELoaded running on LINUX.