Home | How it works | Projects archive | Contact Us
Air Compressor Bot
 
The Career Path of Freelance Programming Jobs 

   Oscommerce +Contributions +XML

Bidding Time:
26/06/2008 19:56 - 05/08/2008 00:00
Budget:
min$3000
Status:
Closed

Buy Pool Tables with Free Delivery from Argos Sports
Job Type:
PHP, Website Design, XML, Ajax, OsCommerce
Description:



Paying too much for web hosting?

OsCommerce distributor connector and plugins
This Project is intended to automate product import from multiple distributors
into a osCommerce environment.
Project planning
1. Distributor automated imports
1.1 Mapping interface (manufacturers/categories)
1.2 Import interfaces
1.2.1 Ingram
1.2.2 TechData
1.2.3 Synnex
1.2.4 D&H
1.2.5 ASI
1.3 Distributeurs import dashboard
1.4 Distributor selector
1.4.1 Backoffice: setting up rules for distributor selection
1.4.2 Import system: finding the best match across distributors
2. Content import from ICEcat
2.1 XML import of product datasheet
2.2 Sync mechanism to update product data
2.3 Product comparison functionality
2.4 Product lookup functionality
3. End-user price calculation module
3.1 Price rules interface
3.2 Price calculation mechanism
4. Real-Time stock & price check
4.1 Distributeur interfaces for real-time P&A
4.1.1 Ingram
4.1.2 TechData
4.1.3 Synnex
4.1.4 ASI
4.2 FrontOffice P&A check integration (AJAX driven, no pop-ups)
5. Initial environment setup
5.1. Custom look&feel design
5.2. Implementation in osCommerce
6. Moneris + PayPal + Google checkout implementation
7. eShipper integration




Basic points
Offers automated import
The purpose is to fully automate product offers import from distributors.
Further extension of imports with adding new distributor should be simple
enough.
Import will need to have some mapping capabilities, which should be interfaced
in the backoffice of the osCommerce. ICEcat can provide a categorization advise
in most cases, but we have to be compatible with ICEcat category structure,
which is multilevel and derived from UNSPSC. The same stands for manufacturers
list.
Interface/screens required:
- Map vendors (from distributors data into standard vendor)
- Map categories (from distributors data into standard category)
- Distributors import status screen (import dashboard)
Distributors selector module
In case of multiple distributors connected, this module will be needed to
resolve ambiguities in product assortment and optimize product coverage in shop.
It will create a best products selection, based on distributors selection rules.
Rules can sounds like:
- Find the best price among [SELECTION] offers
Where [SELECTION] could be defined by parameters:
- Manufacturer / Any manufacturer
- Category / Any category
- Partnumber

Assortment in the environment will be refreshed after every successful import
job and / or in the end of batch session timeframe. Batch session timeframe =
time when assortment updates in shop isn't significant, e.g. from 01:00 till
07:00. This is to lower the server load.
Interface required:
- Distributors selector rules input





ICEcat content import module
Content import module will import content from ICEcat XML repository. It will
put it into a local database, and data will be shown on product details page.
Data to be imported are:
- Product names / descriptions
- Images / gallery / multimedia
- Specification
- Related products (x-selling / up-selling data)
Currently no backoffice interface is supposed for this data management, existing
data storage tables should be used as much as possible.
Data will be stored in local database in a well-structured form, suitable for
lookup and product comparison.
In the frontoffice there should be a possibility to compare selected products
(in one category) and to find products matching certain criterias.
As soon as no backoffice for data management is supposed, all search settings
are to be re-used as they are setup in ICEcat (ICEcat provides certain defaults,
as you can see in www.icecat.biz)
The search will be filter-based – a user will have possibility to create a
product filter based on:
- manufacturer
- stock (yes/no)
- price breaks
- Specification (search breaks will be based on ICEcat searchable features)

End-User Pricing
End user price is calculated on “Purchase price + Margin” model.
Margin could be calculated by a rules, which are defined in a backoffice. Rules
format is
- If [CONDITION] then marge = [MARGE DEFINED]
Where a [CONDITION] is a combination of:
- Purchase price condition ( purchase price between A and B)
- Vendor = [A | Any]
- Category = [ A | Any]
- Product code = [A | None]
“A” is a parameter, as defined in rules setup. Rules are to be managed from a
backoffice.

Real-Time stock & price check
As distributors provide interface for real-time Price and Availability (P&A)
check, it could be implemented in front-office and backoffice to provide the
real-time info on request.
In front office it will be integrated via a link, which will start AJAX request
for an update. Server will perform the parallelized requests to distributors and
return the result to user page. No popups here, only a stock quantity will be
updated and during a check there will be an indicdation that the request is
currently in progress.
Initial environment setup
This involves creation of own look & feel design and customization of
standard OsCommerce templates to your own branded look & feel.
That includes custom look & feel graphical mockups creation. They will be
approved, and then frontpage look and feel will be adjusted to match the
mockups.
Frontpage look & feel will include as well filters functionality, as
discussed in “ICEcat content import module”, so filters mechanism, product page
with a rich content etc.
Automatically optimizes the page title, meta tags, alt text and URL of every
page and items (Product, Category, Subcategory and Brand Pages :Title
enhancement, Keywords, Description)
Automatic URL Rewriting, generates SEO friendly URLs that include relevant
keyword.
Automatically Check for broken links and Redirect Dead URLs With 301.
Automatically generates a Google Sitemap page.
Bilingual: French English
Web Based POP 3 Email Accounts
Email Notification to Customer: For Registration, Placing an Order, Order
Shipped
Email Notification to Reseller: For Orders Placed, Quote Requested, Cancellation
Layered / Faceted Navigation for filtering of products
Paremetric Searching,
Product Comparison
Accept Purchase Orders
Table rates for weight and destination
One-Page Checkout
Foreseen checkout procedure
SSL security support for orders on both front-end and back-end
Option to create account at beginning of checkout
Saved Shopping Carts with configurable expiration time
Recently Viewed Products
Does Not Require Cookies
Ship Only to Billing Address
Merchant Check-out Javascript
Order Transfer into QuickBooks
Oscommerce contributions
Add 'in-stock' only filter
AJAX Quick Search
AJAX Shopping Cart
Attribute Search
Browse Categories by Mfg / Mini-Store
Canada Taxes Order Total Module
Category & Manufacturers name in Product_Info Page
Category/Product Name in Page Title
Compare Products Side-By-Side
Credit Card Fraud Detection Service - Maxmind
Credit Card with CVV2
Dynamic Meta Tags
E-Mail Address Confirmation Field
Enhanced Quick Search
eShipper integration module by WayToShip. Ship by Fedex, Canada Post, UPS,
Purolator and DHL with one account only
Export universel
fast easy checkout
Featured Products
Google Analytics E-Commerce Analysis
Google Checkout module for osCommerce
Handling Fee
ICEcat connector 1.0
Image_Resize 1.0
Increase your Google Page Rank, add an XML Sitemap (FREE)
Independent invoice number
Independent SEO URL Validation (for ULTIMATE SEO URLs)
Individual Item Status v 1.00
In-Stock Quantity Display
Login and Return to same page
Meta Tags On The Fly
Multiple Images for Products
Never See Credit Card v1
Optional Related Products 1.0
Orders Fraud Screen for osCommerce
Order Editor
orders_tracking
Paypal Customer Not returning Basket Lookup
PayPal Express Checkout Module
PayPal Payment Page Automatic Language Selection
Paypal Verfied and Information Footer
Pc Pro Creator
Product Availability Column
Product Serial Numbers
Product Sort By Price
Purchase Without Account
Recently Viewed Products(sales optimized)
Reflection On Images Like Apple.com
Report Missing and Unassignes Images
RMA Returns system
SEO Assistant
SEO-G
Seperate Pricing Per Customer
Show Subcategories when Category has Products
Statistic Search Keywords
Subcategory textboxes
Tell a Friend Button on Product Information Page
Throw em out - IP banning system
Ultimate SEO URLs
WAP-enable
Who's Online Enhancement
Wishlist 2.0


Start your work-at-home career for $7.00. Get direct access to thousands of freelance and home-based jobs. Click here to find work now.

Related Projects:
How-to Articles 10 In 15 Hours
Edit Templatemonster Templates
Wengo Installation
Captcha Round The clock
Phpmyadmin

This project is the proprietary information of . Click here to remove this project from OUR database.
Operating System:
Linux
Database System:
MySQL
<<< back

Recent Projects Archive:

Friday - Thursday - Wednesday - Tuesday - Monday - Sunday - Saturday

View all freelance web projects

 
Home | Projects archive | RSS | Resources | Links | Contact Us © 2004-2008 ProjectsList.biz /5.668