Lingo Import
Paste SKUs/VPNs, pick the channel, and generate Lingo-ready rows from Piro data. Upload today's Lingo export to automatically drop anything already listed there — swap in a new export any time to re-check without regenerating.
Channel
SKUs / VPNs to generate
Paste one per line or comma-separated — same VPN as VendorItem#/ISBN on Lingo. Auto-uppercased as you type.
Latest Lingo export
Upload today's full Lingo export (item-reference.csv) — anything already in it gets dropped from the download below, matched by VendorItem#/ISBN. Drop a newer export any time to replace it.
How this works
ItemDescription comes from Piro's own Description field (falling back to the item Name when Description is blank) — verified against the live Piro table to be the same short, Lingo-style text your uploads actually use, not a regenerated marketing name. So it's left close to the source and made editable above rather than guessed at.
Amazon descriptions are hard-truncated to 30 characters — confirmed against real Amazon Lingo rows, which cut off mid-word at exactly 30 chars. BigCommerce descriptions are never truncated.
Dedup key is VendorItem#/ISBN, matched against whatever Lingo export you uploaded above — case-insensitive, exact match only.
Flags mark SKUs worth a second look before uploading: no description found, no valid UPC (Amazon rows only), or zero on-hand quantity in Piro — flagged because stock is moving to a different source than Piro that isn't wired into this tool yet, so a 0 here shouldn't be trusted as the real count. Flagged rows also show in the "needs review" list above the download button.
Edits you make in the table are session-only — nothing is saved back to the database, so re-generating clears them.