400-500 Series parts list in text or spreadsheet format?

[davem1111 2,030]

So, I have an upcoming opportunity to inventory a bunch of WH/Toro OEM parts in original bags or boxes, and was hoping to find a parts list in text or spreadsheet format so I can scan the barcodes and look them up in the list using a formula. I think I only need the 400-500 series, and I know the IPL's are in the manuals section but in PDF format. I probably could copy those lists from the PDF's and import them into a spreadsheet, but that would take a while. So I thought there might be a chance that someone already has such a list. Mostly interested in small parts - any big ones I can just look up manually if I need to.

 

Anyone have such a thing?  Some of this stuff will likely end up for sale here on the forum, so this would help ease the process of making these parts available for purchase.  Thanks!

[ebinmaine 67,641]

@gwest_ca

@Sparky

@nylyon

 

Thoughts from you folks?

 

[Sparky-(Admin) 21,338]

1 hour ago, ebinmaine said:

@gwest_ca

@Sparky

@nylyon

 

Thoughts from you folks?

 

I don’t have anything.

[Handy Don 12,237]

My thought would be a collaboration with one of the site’s parts vendors who already have inventory systems in place.

In particular, https://www.wheelhorseforum.com/forum/169-a-z-tractor/ and https://www.wheelhorseforum.com/forum/177-kb-horse-parts/

[gwest_ca-(File Mod) 11,048]

5 hours ago, ebinmaine said:

@gwest_ca

@Sparky

@nylyon

 

Thoughts from you folks?

 

I don't have anything.

[ineedanother 1,369]

20 hours ago, davem1111 said:

So, I have an upcoming opportunity to inventory a bunch of WH/Toro OEM parts in original bags or boxes, and was hoping to find a parts list in text or spreadsheet format so I can scan the barcodes and look them up in the list using a formula. I think I only need the 400-500 series, and I know the IPL's are in the manuals section but in PDF format. I probably could copy those lists from the PDF's and import them into a spreadsheet, but that would take a while. So I thought there might be a chance that someone already has such a list. Mostly interested in small parts - any big ones I can just look up manually if I need to.

 

Anyone have such a thing?  Some of this stuff will likely end up for sale here on the forum, so this would help ease the process of making these parts available for purchase.  Thanks!

You can export from adobe directly to MS Word, Excel, and .ppt but I think you might need Adobe DC. If you're going to do a bunch and don't have an alternative, getting DC might be worth it.

[davem1111 2,030]

On 8/18/2023 at 5:30 PM, ineedanother said:

You can export from adobe directly to MS Word, Excel, and .ppt but I think you might need Adobe DC. If you're going to do a bunch and don't have an alternative, getting DC might be worth it.

 

So, yeah, the "free" Acrobat Reader takes you to an Adobe account login page if you try to export.  However, the "Save as text" option worked, it just took me a little while to clean up that data so I could put it in a spreadsheet with the part number in column A and the description in column B.  In another tab, I have a sheet with a lookup formula in column B. If I drop a part number into column A, it populates column B with the description.  I guess if I have more than one of something, I'll just manually update a quantity field, or maybe just allow duplicate lines.

 

With any luck, a few weeks from now I'll be dropping a list of available parts into the Classifieds.  Oh, guess I need a "Price" column also. That's another task I guess, at least for the bigger stuff. I'll be checking FleaBay and pricing stuff at least somewhat less than what's available out there. I may leave some in a "Make offer" state, and if I get an offer then I can check to see if it's reasonable.