Create 1 Cross Reference based on MPN, Brand, MSRP from 5 suppliers

$30-250 USD

Κλειστή

Αναρτήθηκε

περίπου 10 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση

I'm looking for a qualified provider to Create a cross reference table based on MPN & Brand with data verification on MSRP . Data includes of 800,000 +/- individual SKU's from 5 separate suppliers. The end result would be MPN, Brand, & MSRP all matched to 5 Suppliers Part Number/Sku. All three must be matched exactly with the exception of MSRP being within 5% +/- MSRP. Any sku's that fall in the exception must be flagged for manual review. See attachment of example required. Finished product needs to be .csv Project would be reoccurring monthly or as new data is available.

Data Processing

Excel

Ταυτότητα εργασίας: 6222285

Σχετικά με την εργασία

9 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 10 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

9 freelancers δίνουν μια μέση προσφορά $126 USD για αυτή τη δουλειά

@Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$200 USD σε 0 ημέρα

4,9

(207 αξιολογήσεις)

6,9

@seaanddream

Hi, thank you for the invitaiton. I am expertt with excel and vba coding, so I believe I can deliver you the best quality at a reasonable price. awaiting yours...thank you,

$150 USD σε 3 ημέρες

4,9

(90 αξιολογήσεις)

6,3

@RajHeartbeat

A proposal has not yet been provided

$155 USD σε 3 ημέρες

5,0

(53 αξιολογήσεις)

5,8

@roomitech

Thanks for the invite.. Actually i need all the files before saying anything.. I need to check them and then i will reply to you in detail. Thanks

$100 USD σε 5 ημέρες

5,0

(35 αξιολογήσεις)

5,5

@sawangupta

Hi, I can help you with your requirement. I understand there are 800k items which need to be mapped with 5 suppliers data. Regards Sawan

$94 USD σε 3 ημέρες

5,0

(13 αξιολογήσεις)

4,8

@rsdsoftsl

Hello. I specialize in data processing/parsing etc. Could you clarify the format of input data? Is it some kind of table? Could you attach the sample of input data? Regards, Vladimir

$155 USD σε 1 ημέρα

4,9

(7 αξιολογήσεις)

4,6

@hdlong66

Hello. I'll create master list which contains all SKU from 5 separate suppliers with relevant info as MPN, Brand, & MSRP. Tolerance +/- 5% would be flagged using excel function. Wait for your response and your source file to be processed. Thank you and Best regards

$90 USD σε 3 ημέρες

4,9

(20 αξιολογήσεις)

3,9

@jake550

Hello, This doesn't sound like a very rough project, it would just contain a lot of reference data. I do not understand where some of it is coming from. You have a list of 800,000 SKU's.. what else is tied to those numbers in your reference data? MSRP? That seems like the missing link here.. you would provide MPN and Brand, then something searches the SKU's and averages out the MSRP? This may not even require any VBA macro coding, but we'll see what would be the more efficient approach when some of these things get clarified. Let me know, Jake

$133 USD σε 2 ημέρες

5,0

(2 αξιολογήσεις)

2,8

@iFL

Hello, I can create an Excel template with VBA codes to do the job. The template can cater to new data. This means you do not have to post reoccurring projects here. It will save your time and money. Creating a cross reference table is simply a process of searching and matching in the source data tables. VBA is ideal for such a task and it gives you confidence in the accuracy of the result. I hope that you are interested in my proposal. If you have any doubt, please message me.

$55 USD σε 2 ημέρες