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