Terminé

AutoIt language Update utility

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

Compétences : Tout va bien

en voir plus : code sys, righ, revision de, new fr, menu update, language processing, change language, autoit, sku updates, menu csv file, csv merge, csv update, system sku, import files folder, csv files processing, revision required, merge source required, price formula, change name autoit, import items csv

Concernant l'employeur :
( 26 commentaires ) United Kingdom

Nº du projet : #2722333

Décerné à:

razib

See private message.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 7 jours
(1 Évaluation)
1.3

2 freelance font une offre moyenne de $39 pour ce travail

websoftlogicvw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0