Oscommerce +Contributions +XML

This project received 73 bids from talented freelancers with an average bid price of $5644 USD.

Get free quotes for a project like this
Employer working
Project Budget
Total Bids
Project Description

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 [url removed, login to view])

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 [url removed, login to view]

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


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 [url removed, login to view]

Report Missing and Unassignes Images

RMA Returns system

SEO Assistant


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


Who's Online Enhancement

Wishlist 2.0

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online