Project title: Oscommerce /Magento distribution connector with ICEcat.biz ( i have attached the details in word doc)
This is the basic description. We would like to download all products details from ICEcat.biz site, which offers FREE products content. We are a company in France and we want you to install and configure all this on our server. We have not any e-commerce application running yet, so this can be a setup from scratch.
this is how we want…
from our supplier we will have our XML custom price feed which include, the followings:
* SKU#
* MPN#
* Manufacturer
* product title
* category
* short description
* Images
from ICEcat.biz we want the following:
* Product Specification
* Full descriptions
* UPC code
* Images
The Description from ICEcat will be presented in the description tab
The images from ICEcat will be presented in the description tab
The Specification from ICEcat will be presented in the Specification tab
The product reviews from ICEcat will be presented in the reviews Tab.
(if available on ICEcat)
I don’t want to download duplicate products, meaning I want the same product from my supplier and then that product details, specification, images from ICEcat.
I would like to upload new products from a distributor data feed
At the end of the project I expect to receive a data feed in TXT or CSV format
Purposes
This Project is intended to automate product import from multiple distributors into a Magento / Oscommerce / environment.
Project planning
1. Distributor automated imports
1.1 Mapping interface (manufacturers/categories)
1.2 Import interfaces
1.2.1 Tech DATA
1.2.2 Ingram
1.3 Distri 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 & Sync mechanism to update product data
2.2 Product comparison functionality
2.3 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 Distri interfaces for real-time P&A
4.1.1 Tech DATA
4.1.2 Ingram
4.2 FrontOffice P&A check integration (AJAX driven, no pop-ups)
4.3 BackOffice P&A check integration into Purchase Advice
5. Purchase Advice Module
5.1 Create & save purchase advices
5.2 Consolidated purchase advices
6. Electronic ordering at distributors
6.1 Generic ordering mechanism
6.1.1 Tech DATA
6.2.2.1 Order
6.2.2.2 Status feedback and shipping advice
6.1.2 Ingram
6.2.2.1 Order
6.2.2.2 Status feedback and shipping advice
7. Initial environment setup
7.1. Custom look&feel design
7.2. Implementation in Magento
8. SEO optimization
8.1 URL Rewrites
8.2 Titles, meta tags (incl description and keyword) optimization
Basic points
Offers automated import
The purpose is to fully automate product offers import from distributors. Further extension of imports with adding new distris should be simple enough.
Import will need to have some mapping capabilities, which should be interfaced in the backoffice of the Magento. ICEcat can provide a categorization advise in most cases, but you 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 distri data into standard vendor)
– Map categories (from distri data into standard category)
– Distri import status screen (import dashboard)
Distri 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 distri 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:
- Distri 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