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

$30-250 USD

Closed

Posted

almost 10 years ago

$30-250 USD

Paid on delivery

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

Project ID: 6222285

About the project

9 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

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

9 freelancers are bidding on average $126 USD for this job

@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 in 0 day

4.9

(207 reviews)

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 in 3 days

4.9

(90 reviews)

6.3

@RajHeartbeat

A proposal has not yet been provided

$155 USD in 3 days

5.0

(53 reviews)

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 in 5 days

5.0

(35 reviews)

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 in 3 days

5.0

(13 reviews)

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 in 1 day

4.9

(7 reviews)

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 in 3 days

4.9

(20 reviews)

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 in 2 days

5.0

(2 reviews)

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 in 2 days