Zoho Inventory Sales Order Import and Zoho Books Sales Order Entry from Customer Purchase Order PDFs

How wholesale purchase orders get into Zoho Inventory without typing

Zoho Inventory brings sales orders in through a file import. Open the Sales Orders tab, click the menu icon in the top right corner and choose Import Sales Orders. Zoho then asks for the file, the character encoding (UTF-8 by default), and whether it should auto-generate the sales order number. It maps the columns it recognizes, lets you fix the rest, and shows a preview with the rows ready to import, the rows it will skip and any unmapped fields before anything is written. That screen is quick once the file exists. The slow part is the file itself. A brand selling through retailers, distributors and independent stores gets purchase orders as PDFs out of each buyer system, and none of them arrive as rows. Someone reads each PDF and types it, and that is the step this page covers.

PurchaseOrders handles that step. Upload the customer PO and the AI returns the header and every line as a spreadsheet, one row per line with the PO number, order date, customer and ship-to repeated beside each. You line those columns up with the sample file Zoho offers on the import page, save as CSV and run the import. A 40 line order that took twenty minutes to key becomes a few minutes of checking. If your books run in QuickBooks instead of Zoho, the same output feeds the QuickBooks sales order import.

File rules that trip up a first import

Three rules from the Zoho Inventory help center decide whether a file loads. First, the format: Zoho Inventory imports sales orders from CSV or TSV only. It exports to XLS, which is why people try to import an XLSX back and get stuck. Save as CSV. Second, the size: the maximum file size is 1 MB. That is plenty for a day of orders, but a migration or a seasonal backlog needs to be split into several files. Third, the layout: download the sample file from the import page before you build anything and copy its column order and the way it lays out the lines of one order. Zoho maps similar column names on its own, and you can save the mapping, so after the first import the same columns map the same way every time.

Zoho Books sales order import works a little differently

Many teams run Zoho Books next to Zoho Inventory or on its own. Zoho Books has its own Import Sales Orders option under Sales, Sales Orders, More, and the Sales Orders module has to be switched on first in Settings under General. Zoho Books accepts CSV, TSV or XLS, lets you pick the delimiter, and offers the same choice to auto-generate the sales order number and save the field mapping. When Zoho Inventory and Zoho Books are linked, Zoho states that imports and changes made in one are reflected in the other, so import in one place only. Importing the same batch into both creates duplicates you then have to clean up. Teams that also bring supplier documents into Books can use the purchase order to Zoho Books route for the buying side.

Sales order numbers, auto numbering and the customer PO number

Decide early whose number goes where. Your sales order number is yours, and the simplest setup is to tick auto-generate on import and let Zoho number the orders in sequence. The customer purchase order number is theirs, and it is the number a retail buyer quotes when they call about a late shipment or dispute an invoice. Keep it on the order in the Reference field, which most teams use for exactly that, and it will carry through to the package, the shipment and the invoice. Extraction gives you the PO number in its own column, so mapping it to Reference is one choice in the import screen rather than a field someone types.

Customers and items have to match what is already in Zoho

Every order line has to land on an item that exists in your Zoho Inventory, or the order will not tie to stock and cannot be packed and shipped against it. Buyers do not order by your item names. A retail chain prints its own vendor item number and a short description, so the value on the PDF is rarely the name or SKU in your item list. Users in the Zoho community have also reported sales order imports matching items by name rather than by SKU, which makes small naming differences matter. The fix is a mapping step before the import: keep a sheet per buyer that turns their item code into your exact Zoho item name, and run the extracted part column through it. Do the same for the customer, so every order lands on the existing customer record instead of a near-duplicate. Test with a two line order first and open it in Zoho to confirm both lines show stock.

The API route for higher volume

Teams that outgrow the import screen post orders through the Zoho Inventory API. Creating a sales order is a POST to the salesorders endpoint with your organization ID, under the ZohoInventory.salesorders.CREATE scope. The body needs a customer_id and line_items, and each line refers to an item_id. Those are Zoho internal IDs, not the names or codes printed on a purchase order, so any script needs a lookup from the buyer values to your Zoho IDs before it can post. The extracted JSON from the purchase order API gives that script clean header and line values to look up, which is the hard part of the job. PurchaseOrders does not connect to Zoho or post orders itself.

Multi-location ship-to and drop ship orders

A single retail PO often ships to one distribution center, but some buyers send one PO per store or a PO with a ship-to per line. Because the ship-to block comes back as separate fields, you can filter by location in the spreadsheet and split one document into several Zoho sales orders when your process needs one order per destination. If you fulfill from more than one warehouse, set the location on the order before you confirm it so packages are created in the right place. Notes printed on the PO, such as a dock appointment, a routing guide reference or a must-ship-by date, come back as text you can paste into the order notes.

When the volume makes this worth paying for

The math is simple for a brand or distributor on Zoho Inventory. If the order desk keys 15 wholesale POs a day at 12 lines each, that is 180 lines typed by hand, every one a chance to transpose a quantity or pick the wrong item. Extraction does not remove review, but it turns typing into checking. Teams with a morning pile of attachments use bulk purchase order upload to clear up to 50 files at once. The same workflow on other systems is on the Fishbowl sales order import and Odoo sales order import pages, and the wider picture is on sales order entry automation.