Create a data flow profile for Magento to import bundle products from excel file

Project
Using an excel file that we use to upload bundled products to Amazon.fr (Derived from TemplateType=ToysBaby),created a script or dataflow profile to import the same products into Magento AS BUNDLE PRODUCTS with the following criteria.

An example of the excel file is attached.

If you do not yet have access to our back office or ftp, and require this before quoting for the work please email me.

The New product settings for each item should be: Attribute Set= Default, Product type = Bundle Product.
In the General tab
The name = Column B
The SKU value should be set to ‘Fixed’ & mapped from column A in excel file.
Weight = Column AK
Status should be set to ‘Enabled’
Visibility should be set to ‘Catalog, Search’.
In feed should be set to ‘Yes’.
ISBN= Column C

In the Prices tab
The Price value value should be set to ‘Fixed’ & mapped from column L in excel file.
The cost price should be set to half the selling price (L/2).

Meta Information tab
Meta Title = Column B
Meta Keywords = Column AZ,BA,BB,BC,BD
Meta description = Column AS


In the Images tab
The thumbnail, Small & Base image should be mapped from column BK
Other images should also be mapped from columns BL, BM, BN, BO & BP if available.
Note: As the images are already on our server they should not be re-imported!

In the Description tab
Description = Column B
Short description = Column AS ( then line break) Column AT, ( then line break) Column AU, ( then line break) Column AV, ( then line break) Column AW.


Inventory tab
Manage Stock should be set to ‘No’.

Websites tab
Only ‘Jonglerie’ should be selected.

Catagories tab
Attribute product to the Root ‘Jonglerie.fr’

Bundle Items tab
Bundle items = the simple product SKU from columns FQ onwards.
Column FR has default qty of the first SKU from column FQ.
The second simple product and default qty comes from FS & FT etc.

The default Title for each item should be ‘Titre’
Input type, select ‘Drop-down’
Is required, select ‘Yes’
Default Qty = 1 (unless other value in ‘qty SKU #’ from excel file)
User Defined Qty, select ‘ No’
Default, tick box.



Any question please email me. This job is urgent.
Please note column FQ to GZ have yet to be populated apart from 1st item.
More products will be added when data flow profile is created.