194322 Import & Update PHP script

I need a script that can be set as cron job to update my products database field. I use OSCommerce Cart but this can be a standalone script. The feed that is provided to me is thru a link and it's in TAB Delimited TXT file. Supplier feed is updated every day and I would like to have this automated so that I don't have to manual update myself.

What the script need to do before updating to internal products database.

- Look in price_min field and if its greater > than 0 UPDATE products_price field.

- If price_min field is equal == to 0 then MARKUP price field by percentage(%) and UPDATE products_price field.

Supplier feed with 6 fields (I only need to update 4 fields to my database)

1. item_no

2. price

3. price_min

4. quantity

5. qty_backorder

6. qty_transit

Mapping fieldnames to internal fieldnames.

1. item_no = products_model

2. price = products_price (markup by percentage(%)

3. price_min = products_price_min (if not null)

4. quantity = products_quantity

5. qty_backorder = DROP

6. qty_transit = DROP

MySQL Odd Jobs PHP

Project ID: #1940543

About the project