Preconditions:
Make sure the SKUs in the CSV do already exist as products in PULPO WMS.
Make sure order_num does not exist already, i.e. is unique
Make sure each supplier_code in the CSV belongs to an active supplier.
If you are going to create purchase orders with multiple products make sure that supplier_code, order_num, notes, and delivery date are the same for every product.
For uploading the CSV go to menu item Incoming Goods and then to tab Purchase Orders (1). Add a new order (2) and upload the CSV file (3).
Here you can find the template.
Make sure to use exactly the format specified in the template for each entry and separate the values by ",".
Note: If using Excel, be sure to save every CSV file you edit in UTF-8 format before uploading.
Upload template details:
Column | Field | Description | Required? | Mandatory / not empty | Data example | Format |
A | supplier_code | Identifier number | Corresponds to “identifier number” in Third Party | true | 4567 | text, max length 255 |
B | order_num | Purchase order number | Unique number fo every order | true | MASS_OR_1 | text, max length 255 |
C | notes | Notes | Notes for a purchase order. It is a free text. Can be an empty field | false | This is a note | text, max length 255 |
D | delivery_date | Delivery date | Date in format YYYY-MM-DD HH:MM:SS | true | 2019-12-31 23:59:59 | date time format (YYYY-MM-DD HH:MM:SS) |
E | sku | entered in add products | Product SKU | true | 3775 | text, max length 255 |
F | requested_quantity | Quantity | Requested quantity | true | 10 | integer number greater than 0 |
G | criterium | Criterium of the purchase order | false | false | Criterium A | text - max length 255 |
Upload attachments for incoming goods
In Pulpo WMS we have the option of attaching files to the goods receipt.
We do this very simply by
Click on Goods receipt
Select the pending goods receipts
Choose the purchase order where you want to attach something
Click on Attachments
Upload the files
