To import a purchase order from a spreadsheet:
- Your spreadsheet for upload needs to contain the following information including column names:
- An identifier to match products: SKU, title, ID, vendor reference, or barcode. (Required)
- Quantity ordered (required)
- Vendor name (optional)
- Received quantity if the ordered products have already arrived and added to inventory. (Optional)
- PO created date (optional)
- PO arrival date (optional)
- Cost price (optional)
- Landing cost price (optional)
- PO number to differentiate purchase orders. If not provided then POs are distinguished by arrival date. (Optional)
- Date format such as yyyy-mm-dd (optional)
2. Go to the Purchase Order section from the left side menu.
3. At the bottom of the screen, click Actions > Import Purchase Order.
4. Attach your saved spreadsheet by clicking on Select File and locating your document.
5. Inventory Planner will match columns with your column names when possible. For other columns of information, you will need to select the correct column title to match the information type for import.
6. When all column names have been matched to their information field, click Upload at the bottom of the screen.