Purchase order upload via CSV

This article explains how purchase orders are uploaded using CSV.

Johann Sonnenberger avatar
Written by Johann Sonnenberger
Updated over a week ago

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

  1. Click on Goods receipt

  2. Select the pending goods receipts

  3. Choose the purchase order where you want to attach something

  4. Click on Attachments

  5. Upload the files

Did this answer your question?