Skip to main content
All Collections3PL
3PL - Outgoing order CSV upload
3PL - Outgoing order CSV upload
Vadim Glushachenko avatar
Written by Vadim Glushachenko
Updated over 11 months ago

Outgoing order CSV upload via CSV in 3PL does not differ much from the non-3PL sales order data upload.

The main difference with a regular CSV product upload file is 2 fields listed below added to the CSV upload file:

AA

merchant_id

Merchant ID, found as described here.

The alias name can be used instead of ID

AB

merchant_channel_id

Merchant channel ID, found as described here.

The alias name can be used instead of ID.

AC

merchant_slug

Merchant Alias, found as described here.

The alias name can be used instead of ID

AD

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 an outgoing order with a CSV file.

Preconditions:

  • Make each SKU exists in PULPO WMS.

  • Make sure order_num does not already exist in the system, i.e. needs to be unique.

  • Make sure the client_code in the outgoing orders CSV belongs to an active customer.

  • If you are going to create outgoing orders with multiple items make sure that client_code, order_num, ship_to, priority. and delivery_date are the same in all the rows that belong to the same order.

Import in frontend

To import in frontend go to the “Outgoing Orders” module → click on the button → click on Upload File → choose a valid CSV file to import

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

Field required?

Data Example

Format

A

order_num

Unique number for the sales order

true

order_123

text - max length 255

B

ship_to_name

Name of the address where the sales order is being shipped.

true

Address1

text - no max length

C

ship_to_phone_number

Phone number associated with the address where the sales order is being shipped.

false

6337223400

text - no max length

D

ship_to_company_name

Company name of the address where the sales order is being shipped.

false

Pulpo

text - no max length

E

ship_to_email_address

Email address of the address where the sales order is being shipped.

false

text - no max length

F

ship_to_city

City of the address where the sales order is being shipped.

true if client_code not included

Hamburg

text - no max length

G

ship_to_country

Country of the address where the sales order is being shipped.

true if client_code not included

Germany

text - no max length

H

ship_to_house_number

House number of the address where the sales order is being shipped.

false

59-61

text - no max length

I

ship_to_state

State of the address where the sales order is being shipped.

false

Hamburg

text - no max length

J

ship_to_street

Street of the address where the sales order is being shipped.

true

Willy-Brandt-Straße

text - no max length

K

ship_to_zip

Zip code of the address where the sales order is being shipped.

false

20095

text - no max length

L

priority

These numbers represents the level of priority for the orders. As greater the number, less priority to be picked (1 top priority)

false

1

integer - 1, 2, 3 or 4

M

notes

Notes for a purchase order. It is a free text.

false

This is a note

text - no max length

N

criterium

Criterium of the sales order

false

Criterium A

text - max length 255

O

channel

Sales channel

false

Channel A

text - max length 255

P

delivery_date

Date in format YYYY-MM-DD

true

2019-12-31

Text with date in format YYYY-MM-DD

Q

sku

Product SKU

true

3775

text - max length 255

R

quantity

Requested quantity

true

10

integer - number greater than 0

S

customer_name

“name” of the customer, use this field just if you want to create a customer

true if client code empty

Pepito

text - max length 255

T

identifier_number

“identifier_number” of the customer, use this field just if you want to create a customer

true if client code empty

111111111

text - max length 255

U

identifier_type

“identifier_type” of the customer, use this field just if you want to create a customer

true if client code empty

CC

text - max length 255

V

email

“email” of the customer, use this field just if you want to create a customer

true if client code empty

text - max length 255

W

shipping_method

Shipping method name

true if included

Shipping method name

text - max length 255

X

split_kit

Splits kit products in components

fales

true

boolean

Y

attributes

Attributes of the sales order separated by comma

false

name1:value1,name2:value2

List of (text:text) separated by comma - no max length

Z

measure_unit

Measure unit to add product’s quantity. By default, single quantity is taken.*

false

box

text - max length 255

AA

merchant_id

Merchant ID

true**

123

Integer number greater than 0

AB

merchant_channel_id

Merchant's sales channel ID

true**

345

Integer number greater than 0

AC

merchant_slug

Merchant Alias

true**

Alias_123

Alias name

AD

merchant_channel_slug

Merchant's sales channel Alias

true**

Channel_alias_345

Alias name

*If weight is entered, the quantity will be divided by the product’s weight to calculate the sales item quantity. If the measure unit of the product is entered, the sales item quantity will be calculated by units_per_sales_package * quantity entered.

** merchant_id and merchant_channel_id have to be entered either with IDs or with slugs in any combination

Did this answer your question?