Project Detail
Oscommerce +Contributions +XML
Oscommerce +Contributions +XML is project number 279716
posted at Freelancer.com. Click here to post your own project.
Status: Cancelled
Selected Providers: -
Budget: min $3000
Created: 06/26/2008 at 19:56 EDT
Bid Count: 73
Average Bid:
$ 5644
08/05/2008 at 19:56 EDT
Project Creator:
MajidB
Employer Rating: (No Feedback Yet)
Description
OsCommerce distributor connector and pluginsThis 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
Additional files submitted:
Icecat.doc
Provider Rating
WHAT IS FREELANCER.COM?
Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!
We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started!
Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.
- Plendo Sweden AB © 2004-2009
- PRIVACY POLICY
- TERMS
- AFFILIATES
- API
- QUOTES
- CONTACT
Freelancer™ is a trademark of Ignition Networks Pty Limited (ACN 134 845 748)
Newly Outsourced Projects fed by 
Follow our Freelance Jobs on Twitter 
Add to your
Google search results
Digital Imaging Software * Webmaster Resources * Webmaster Forum