Is There a Way to update price and quantity without the item number if I have a customlabel (sku)

[onestopmusicshopinc]

Hi is there way to revise price and quantity in mass through file exchange without the item number and just the customlabel (sku)? My supplier supplies the info and I would like to update it daily but have no way of knowing what item number matches what sku. We are talking 30,000 items so I cannot do it by hand and all the software I tried was horrible. It would take days to update price and quantity when file exchange takes minutes. It would make things worlds easier if I could just update a sku, price, quantity update daily through file exchange. Any help would be greatly appreciated.

[shipscript]

eBay can not update by SKU, however, you can download an "Edit Price and Quantity" revisions report through Seller Hub "Uploads" to get a report that displays the Custom Label (SKU) along with the associated item number.

https://www.ebay.com/sh/reports/uploads

If you are facile with Excel, use the VLOOKUP function to flesh out either your supplier's Price and Quantity with your ItemID or to update your Seller Hub report with your supplier's updated price and quantity. Whichever direction you choose, make sure the column headers are appropriate.

Then upload the merged (File Exchange) Seller Hub revision spreadsheet back to the Uploads screen.

I haven't used the VLOOKUP function myself, but I see there are lots of online tutorials due to it's popularity. It's the most common method for merging values from two spreadsheets.

Here is one example of combining two spreadsheets, but there are many more tutorials out there:

https://kb.wisc.edu/msndata/page.php?id=90851

[onestopmusicshopinc]

Thank you very helpful!!