Purchase order upload via CSV for 3PL does not differ much from the non-3PL purchase order data upload.
The main difference with a regular CSV product upload file is 2 fields listed below added to the CSV upload file:
H | merchant_id | Merchant ID, found as described here. The alias name can be used instead of ID |
I | merchant_channel_id | Merchant channel ID, found as described here. The alias name can be used instead of ID. |
J | merchant_slug | Merchant Alias, found as described here. The alias name can be used instead of ID |
K | merchant_channel_slug | Merchant channel Alias, found as described here. The alias name can be used instead of ID. |
Any combination of these values can be used to upload a product with a CSV file.
Preconditions:
Make sure the SKUs in the CSV 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 the menu item Incoming Goods and then to the 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 | Explanation | 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 |
H | merchant_id | Merchant ID | Merchant Alias, found as described here | true* | 123 | Integer number greater than 0 |
I | merchant_channel_id | Merchant's sales channel ID | Merchant channel id, found as described here | true* | 124 | Integer number greater than 0 |
J | merchant_slug | Merchant Alias | Merchant Alias, found as described here | true* | Merchant_123 | Alias name |
K | merchant_channel_slug | Merchant's sales channel Alias | Merchant channel Alias, found as described here | true* | Channel_124 | Alias name |
* merchant_id and merchant_channel_id have to be entered either with IDs or with slugs in any combination