Project Detail

Description

Hi.

I need a csv parsing app to create a feed for google base.

The app needs to have functionality to map columns from the input csv and assign them to the appropriate base attribute.

The app should make sure that all required google base fields are filled in, but also give all the options for all available google base fields

http://www.google.com/support/merchants/bin/answer.py?hl=en-uk&answer=160083

The app will have the ability to add extra text to each field when mapping. For example –
Field 10 in the input csv contains the name of the image –

/image1.jpg
The user should have the option to add preceding text to that column for the appropriate input –

www.website.com

output -

www.website.com/image1.jpg

The csv also contains price / special price / tax. The app should ask the user if the price / special price include tax. If not it should then calculate the total price including the tax. This should be calculated on what the value of the entry in the tax column contains compared to the actual value entered by the user. For example, the entry may say ‘TAXABLE GOODS’, in which case the user should be asked what value this is, the answer may be 15%, so the output should be price+15%. If a special price exists in the column for that product, that price should have precedence over normal price.

Attached is a small example of a csv that could be imported. It is important that the app has mapping ability as the format of this csv may change.

It should also allow the user to create a new attribute that is not already contained in google base, this is detailed in the link above.

Budget for this is $30, I could do with it completing today.

Thanks


Additional information submitted:

11/11/2009 at 8:17 EST:
For clarification, the exported file should be in tab delimited format.

Additional files submitted:
example+csv.csv