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 [login to view URL])
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 [login to view URL]
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
Dear Sir, I am interested in your project and can be done with your 100% satisfaction. I request you to check your PM for our quality work. Payment in Milestones. Thanks & Regards Webexpertz Team
Hi,
I have checked your requirement. I can get your job done quickly with my highly skills at OSC cause most
of my works are shopping cart,
OSCommerce family supports(OSc, Creloaded, Zencart, OsMax). Please check my reviews & won projects to
make sure I can complete your projects quickly
Hello, this bid is from AvionTechnology, a company with 3+ years of experience in offering IT solutions. We are based out of Schaumburg, US. We have a good eye for perfection because we enjoy taking up several projects like yours where we can demonstrate our penchant for perfection. We have a vast experience and skills in the appropriate technologies to implement the features that you have mentioned and our employees are available 24/7 via phone, email and instant messenger. Based on the information provided we will be able to accomplish your objectives you outlined. Our staff is very well versed in the use of PHP, ASP, .NET, ASP .NET, C #, JavaScript, Ajax, Flash, MYSQL, SQL Server Illustrator and Photo Shop. We look forward to working with you. Please check PMB for more details Regards, AvionTechnology