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.
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
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.
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.