Start with the order file from Ingram iPage
Export the order from Ingram iPage and import it into book by book. You can export as CSV or Excel, whichever you prefer.
Pro tip: make sure the order name includes the Ingram PO number. That gives you a reliable way to find the order later when the shipment arrives.
Don't update Square yet if the books haven't arrived
If the shipment is still in transit, stop after the import. This keeps Square from getting ahead of reality.
The order can sit in book by book until you have the physical shipment in front of you and can confirm what actually showed up.
When the shipment arrives, search by PO number
Once the books are in hand, go back to book by book and locate the order by searching for the Ingram PO number.
That is the fastest way to pull up the exact order you imported earlier, especially if you have several open orders at once.
Pro tip: If you only have your phone available, scan the barcode on one of the books in the shipment to find orders containing that book.
Compare the shipment against the order
Before sending anything to Square, double check the physical shipment against the order in book by book.
If any titles are missing from the shipment, remove them from the order or adjust their quantities before you continue. The goal is to avoid pushing an inaccurate picture of your inventory to Square.
Update Square once everything matches
After you've confirmed the shipment contents and cleaned up any missing books, update Square.
At that point, the catalog and inventory changes reflect the books that truly arrived, which keeps your receiving process accurate and avoids cleanup later.
Wrapping it up
The finished workflow is simple: import the order from Ingram iPage, make sure the order name includes the PO number, and then wait to update Square until the shipment arrives. Once the books are in hand, find the order by PO number, remove any books that were missing from the shipment, and then update Square.