194322 Import & Update PHP script
N/A
Betalt ved levering
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
Projekt ID: #1940543