Oscommerce +Contributions +XML

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