GAP Ticket Parser — Number PO / EU Format

Paste ticket table pages → get BR142-style Excel-ready tab-separated output

Database LPN Color replacement: This parser searches saved LPN Color records by the last 6 digits of the copied style number. If a stored full LPN Color matches the copied partial color, the output COLOR DESC is replaced with the database LPN Color.

How to use

Enter conversion details for database recording
Open the ticket PDF and go to the ticket table page(s)
Select All (Ctrl+A) and Copy (Ctrl+C)
Paste below — you can paste multiple pages or PDFs at once
Click Parse — the TSV result appears below
Click Copy to Clipboard, then paste directly into Excel / Google Sheets

Conversion details

Date

WFX PO#

Type

Season

Merchant

Required Date

Have number PO's *

Yes No

Paste PDF text here

Include the full page text (header + table). Multiple pages and PDFs can be pasted together.
Size prefix such as M93- is stripped automatically. Barcode is used for both UPC fields. P/T and LPN quantities use the added quantity formulas.