Zencart - upload from a file into mySQL db


this is NO longterm project - Budget for this programming work would be approx 250USD.

Purpose of the project:

I am looking for somebody who is able to program an easy and userfriendly upload facility from a modified file into a Zencart Webshop.

Background info:

I get a daily text file with some 35000 articles - out of them i only need 2000 which are important to me.

Processing via Excel or Access....

1) Macro which article groups can be deleted and what is left

2) Calculate net price + transport fee + handling fee + VAT to get a

gross price.

Can be done via formula.

3) Any coding language to upload or update (delete, insert, amend

product) into Zencart.

4) Download function also from Zencart DB into Excel - for analyses.

5) Automatisation should be as much as possible.

6) Script/Macro should be userfriendly, easy to handly and possible

for future changes.

Only place bid if you are


b)a real expert in this field and

c)you could do it from A to Z.

Implementation could be done in up to 3 weeks.

Details will be provided later.

Good luck

Added a sample file for your info.

The columns are as follows :

article nr - Manufacturor article nr - manufacturor - EAN - description - availibility – price (net) - advised selling price - product category - product family - product group - EOL - weight - approx next delivery

commas are seperated via a dot “.” Price is in EURO, weight is in kilo.

Now out of this approx 35000 articles i only need approx 2000 which are important to me:

like Display TFT or Notebooks or Digitalcameras or printer/copy machines (drucker/kopierer) or PC’s – they can be in either product category or family or group so the

module must be flexible. I am not selling each and every cable or ink…..

What I definitly do not need is product category: Verbrauchsmaterialien, Software, Netzwerk/Netzwerk-Software, Telekommunikation. They can be all deleted to shorten the list.

For example we maintain all the TFT monitors :

Calculate net price + transport fee + handling fee + VAT to get a gross price.

default values but ablility to maintain by me:

transport fee would be 9 EUR for each article (what I have to pay to get it)

handling fee (what I add on price plus transport , ie price is 100 plus 9 => 109 is the basis) - plus 10 EUR or 5-9% (input from my side and applible for all)

VAT – in Austria 20% - comes on top of above ie. 100 plus 9 plus 10 EUR plus 20% would be 142.80 EUR selling price

Would assume that manufacturor article nr is the key criteria what is already there or not:

should be loaded under my category ie monitors

a) Add – when article is not yet existing

(description, gross price, manufactorer, manufacturor article nr, weight)

b) Amend price when gross price has changed

c) Amend availibility when availibility has been changed

d) possibility to flag and report when articles are on homepage but not on file???? Eg TFT monitor 1234 is on homepage but not on list?

This upload should be easy to handly and to understand and also be flexible for future changes.

Also download function from my homepage with all articles into Excel - for analyses – crossfunction what I have on Homepage and what I get on the daily file and if there is a difference.

Evner: Dataindførsel, Databehandling, PHP, Script Installering

Se mere: what is a programming language, what is a function in programming, programming from, processing programming language, price file, php coding language, mysql db, macro programming in excel, is net a programming language, i get programming language, get into programming, formula it, file excel expert, excel expert up, excel and access programming, excel access programming, what is macro in excel, vat fee, expert excel programming, excel programming language

Om arbejdsgiveren:
( 7 bedømmelser ) is private plz, Austria

Projekt ID: #75332