Find Jobs
Hire Freelancers

AutoIt language Update utility

$30-50 USD

Completed
Posted about 12 years ago

$30-50 USD

Paid on delivery
Update to Utility that runs on start up / minimised to system tray. Will import source file csv file (from default folder in its settings- can therefore be changed) import file has 2 columns SKU / Price (Startprice) it will output 3 text files (the source file can have 250000 items) This is a revision to the 3rd text file to be exported. Source code available. Thanks Norman ## Deliverables THIS IS WHAT PROGRAMME WAS DESIGNED TO DO. Utility runs on start up / minimised to system tray. Will import source file csv file (from default folder in its settings- can therefore be changed) import file has 2 columns SKU / Price (Startprice) it will output 3 text files (the source file can have 250000 items) e.g Sku Price XCF 5 XFG 7 Export1 File Name = SurplusSurplus{datestamp}[Ending name as on source file] which will be saved to another path in settings - path can therefore be changed. The file will have 2 columns sku price (where price = The startprice +- ?X (in settings surplusurpluprice = ) so if setting is -3 The columns will be: Sku Price XCF 2 XFG 4 Export2 File Name = TradeSurplusUk {datestamp} [Ending name as on source file] which will be saved to another path in settings - path can therefore be changed. The file will have 2 columns sku price (where price = The startprice +- ?X (in settings surplusurpluprice = ) so if setting is =2 In this example the columns will be: Sku Price XCF 7 XFG 9 Export 3 It does not take all the skus from the source file. In the source file some of the SKU's start SAGB (we only use SKU's beginning SAGB - these will change) For example: SAGB278 SAGB279 SAGB281 SAGB282 (GB stands for Great Britan) It will take all sku's beginning SAGB and create file Sku SADE278 SADE279 SADE281 SADE282 SAFR278 SAFR279 SAFR281 SAFR282 (NO SAGB in this file) It does not take all the skus from the source file. In the source file some of the SKU's start SAGB (we only use SKU's beginning SAGB - these will change) For example: SAGB278 SAGB279 SAGB281 SAGB282 (GB stands for Great Britan) It will take all sku's beginning SAGB and create file Sku SADE278 SADE279 SADE281 SADE282 SAFR278 SAFR279 SAFR281 SAFR282 (NO SAGB in this file) Note same SKUS X 2 (SADE278 SAFR278) but DE (Germany) and FR (France) The price in the output file will be Folder 3 price formula which includes a conversion rate to EUROS Note same SKUS X 2 (SADE278 SAFR278) but DE (Germany) and FR (France) The price in the output file will be Folder 3 price formula Name 3rd export file SAEXPORT-{datestamp} NEXT It will then archive source source file (prompt first) To explain on one site I sell for ?5 free shipping (source file Merge) To explain on one site I sell for ?4 ?1 shipping (output file 1) To explain on one site I sell for ?3 ?2 free shipping (output file 2) I want files to show this. UPDATE REQUIRED IS TO EXPORT FILE 3 I want to do an update of this software. 1. Remove Start Processing fromn righ click menu in sys tray. 2. Folder 3 only I want to add if source file SKU not like 'SAGB%' e.g SKU IS AAAA1111 then create 2 x new skus in end file SADEAAAA1111 SAFRAAAA1111 (this the full sku with SAFR and SADE in front of it) BUT if it is SAGB11111 then as now simply replace GB with DE and FR and The price in the output file for each item use Folder 3 price formula so if source file SAGB11111 SAGB22222 AAAA1111 then output file will be SADE11111 SAFR11111 SADE22222 SAFR22222 SADEAAAA1111 SAFRAAAA1111 with the formula applied to the prices. The person awarded the project will be prepared to do Support, updates and changes at reasonable prices to be agreed. Source code available. Thanks Norman
Project ID: 2722333

About the project

2 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$42.50 USD in 7 days
5.0 (1 review)
1.3
1.3
2 freelancers are bidding on average $39 USD for this job
User Avatar
See private message.
$35.70 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
United Kingdom
5.0
26
Member since Jul 30, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.