1

I have been assigned the task of automating entering of supplier prices and inventory based on our master google sheet.

I have limited programming knowledge, but so far I have made code that can create an order sheet and send it via E-mail.

The problem I'm facing now is that the prices are based on pdf/xlsx files we receive from our suppliers, and each file has its own way of naming the same item, not to mention the format.

Right now I'm having to manually convert pdf tables to excel, then copy the data into a google sheet, then run a code I made for each supplier that searches and copy the price to the proper location on our spreadsheet. It's definitely not optimal but still a lot quicker than hand typing them in.

Is there a better way to update the prices?

Revali Senai
  • 29

1 Answers1

4

First, I would try to ask your suppliers if they are able to send you the data in a standardized, machine-readable format. An Excel sheet may be fine as long as you can identify the columns correctly. There are dozens of ways to automate the reading of data from Excel sheets, so that should be a good starting point for automatization. Note that your suppliers will most probably generate their price table PDFs from a spreadsheet document by themselves, so I guess most of them could you send the data in a better format if they just want to.

If your suppliers do not cooperate and insist on sending you PDFs , someone has to do the hard work and convert the PDFs into a spreadsheet (again). OCR software might be of use here, but that still will be a semi-automatic process.

Doc Brown
  • 218,378