Dealer file compare and update

Anulowany Opublikowano Sep 16, 2014 Płatność przy odbiorze
Anulowany Płatność przy odbiorze

Scope of Work

First off let me say that I am looking for something that is very easy to use and does not require a lot of setup on the computer to run as it may be used on several different computers. It MUST run on a MAC.

I do not want to manually convert files. I want everything to be automated.

These variables change so I need to be able to set them first.

1 USD is how much in CAD?

Shipping cost is how much in CAD? (default is 2)

CAD_SELLING = ? x CAD_COST (default is 1.2)

Select [url removed, login to view] file Location

Select [url removed, login to view] file Location

Select [url removed, login to view] file Location

Select [url removed, login to view] file Location

Select [url removed, login to view] file Location

Select [url removed, login to view] file Location

Submit

List of Files

[url removed, login to view] is the new txx file that needs to be compared to the XLS file

[url removed, login to view] This is the final XLS file created after your program is run

[url removed, login to view] List of Category Numbers

Categories_info Description of categories

[url removed, login to view] List of Manufacturers

Manufacturers_info Description of Manufactuers

I download a file called [url removed, login to view] on a weekly basis. This file must be compared to an existing XLS file and update it. There is a key field that is a part number. If the item exists in the XLS file then update the cost field.

If the item does not exist then Add it to the XLS file and populate the fields from the corresponding [url removed, login to view] file. There are also some other fields that are the same for all the records that would need to be populated for any item added to the XLS file.

Each record has a manufacturer and a category field. If either of these do not exist then a new manufacturer and number or category and number is to be created and add to the category and manufacturers files.

The [url removed, login to view] file includes a URL for 3 different picture fields. These need to be renamed to mydirectory/[url removed, login to view]

The image URL cannot be more than 50 characters, so they may need to be truncated. The actual name of the file must also be renamed in the images directory to match.

When all is said and done you should have created 5 new files.

[url removed, login to view] This is the final XLS file created after your program is run

[url removed, login to view] List of Category Numbers

Categories_info Description of categories

[url removed, login to view] List of Manufacturers

Manufacturers_info Description of Manufactures

When you quote me I want to know what Language you will be using to write this in. I want you to confirm that this will work on a MAC. I also want to know before awarded what setup will be required on the MAC for your program to work.

If easier all files can be in xls format.

Dealer.txt Final.xls
SKU Prod_Model (B)
Product NAme Product Name (H)
Manufacturer Manufacturer(I)
ProdDescription1 ProductDescription1(K)
ProdDescription2 Not Used
SubModelDescription Not Used
MainImage URL Images (L) \med\ (M) \lrg\
Shipping Weight Weight (O)
Caliber Caliber(Q)
Velocity Velocity(S)
Parentage Not Used
Parent SKU Not Used
MSRP Not Used
MAP Not Used
In stock Date Not Used
InStockQuantity InStockQuantity (T)
QBitem Not Used
Wnet Wnet(U)
SmallImageURL SmallIMAGE(AB) \sm\
Category Prod_category(AC)
UPC Not Used
ButbuttonDisabled Not Used


Other fields in Final.xls

(A) Increments by 1
(C)0 (D)0 (E)1(F)0(G)1 are always the same and have to be generated for new
(J) has to be looked up against Manafacturers_iinfo.csv
(L-N) all use same name but different directory
(L) Has to be \img
ame.jpg
(M)Has to be \mename.jpg
(N) Has to be \lrg
ame.jpg
(P) is always 4316
(R)is always 4317
(v) Calculated by input USD Value i.e 1.1095 * (U) = (V)
(w) = (V)*.05
(X)=((V)+(W))*6.5%
(y)=Input given i.e 2.75
(Z)=(Z)*input given I.e (z)=(z)*1.22
(AB) Has to be renamed to \sm
ame_sm.jpg
(AD) name of (ac has to be looed up and then put in the number (AD)


Finally My shipping cart has a limit on the record size of the images field. It cannot be more than 50 characters. I have all 4000+ images in 1 directory. They need to be renamed or only the ones too large renamed . But they must match the name of the file and the name in the spreadsheet.

Wprowadzanie danych Excel

Numer ID Projektu: #6465489

O projekcie

9 ofert Zdalny projekt Aktywny Sep 19, 2014

9 freelancerów złożyło ofertę za $137 w tym projekcie

sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this reg Więcej

$150 USD w ciągu 5 dni
(80 Oceny)
6.0
sawangupta

Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. Please provide more details to help you better. Regards Sawan

$155 USD w ciągu 3 dni
(17 Oceny)
5.0
MasterExcel

I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high Więcej

$30 USD w ciągu 3 dni
(12 Oceny)
3.2
cracken

I am a well equip professional whose knowledgeable either UNIX or LINUX flatform. Highly technical in System Administration and experts in commandline Terminal command. By the way, let me introduce myself. I am a profe Więcej

$166 USD w ciągu 7 dni
(1 Ocena)
1.1
ravichauhan1990

A proposal has not yet been provided

$155 USD w ciągu 3 dni
(0 Oceny)
0.0
moaarif101

I am very experienced person of excel and ms office and internet work i can do this work very easily in accurate manner.

$155 USD w ciągu 3 dni
(0 Oceny)
0.0
Buddhika200

A proposal has not yet been provided

$155 USD w ciągu 3 dni
(0 Oceny)
0.0
LeslieChip

Még nem kapott javaslatot

$111 USD w ciągu 2 dni
(0 Oceny)
0.0
rosyhelal77

A proposal has not yet been provided

$155 USD w ciągu 3 dni
(0 Oceny)
0.0