Purchase Order Import

This document provides detailed instructions for filling out the Purchase Order CSV import templates based on the actual system implementation and V3 API specifications.

Overview

The PO Import system supports CSV file uploads that get processed into JSON format for the V3 Purchase Orders API. Each CSV row represents one line item with its packaging details, and multiple rows can belong to the same Purchase Order (grouped by Po_Number).

Template Types Available

• Finished Goods PO Template: For finished goods and products
• Material PO: For raw materials and components

Finished Goods PO Template - Field Guide

Purchase Order Information

Field Name	Required?	What to Enter	Example
Po_Number	Required	Your original PO number from your system	PO-250901
OPO_Number	Optional	OPO_Number is another field used to apply unique identifiers for Purchase Orders. Normally it is different from PO_Number. This is an optional field and can be left empty. If not empty, make sure it is unique for each PO number. It can be both numbers and/or text.	opo_123
Total_Order_Quantity	Optional	The value to display PO total quantity	100
Total_Order_Quantity_Uom	Optional	The value to display PO total quantity UOM Code	m
Po_Type	Optional	Purchase order type from pre-configured list	po_type_1
Po_Source	Optional	Source of materials (domestic/international)	domestic
Po_Status	Optional	Status (only "canceled" is supported)	canceled
PO_ClientCreatedDate	Optional	Creation date from your system (YYYY-MM-DD)	2023-02-10
Delivery_Date	Optional	Delivery/shipment start date (YYYY-MM-DD)	2021-05-23
Ship_End_Date	Optional	Shipment end date (YYYY-MM-DDTHH:MM:SSZ)	2021-05-30T00:00:00
In_Store_Date	Optional	In store date (YYYY-MM-DDTHH:MM:SSZ)	2021-06-01T00:00:00
PO_EventName	Optional	Corresponding event name from your system	Event 1
Data_Provider	Optional	Local Custom ID of Data Provider organization. Let it empty will be using the current import org.	Provider-01
Client_Id	Optional	Local Custom ID of Brand/Retailer organization.	client_1
Factory_Custom_Id	Optional	Local Custom ID of Factory organization.	factory_1
Vendor_Custom_Id	Optional	Local Custom ID of Supplier organization (min 1 char).	vendor_1
Commit_Id	Optional	Commit ID of the purchase order	commit_id_1
Commit_Po_Sequence	Optional	Commit PO sequence	commit_po_sequence_1
Share_To_Ids	Optional	Comma-seperated shared organization IDs	sub_org_1,sub_org_2

Tips for Items Template:

• If your item already exists in the system, you may only need custom_id
• For new items, include color and size for better identification
• Each PO must have at least one line and one packing detail
• Use "solid" packing for individual items, "assortment" for mixed packs

Line Items Information (Manual Items)

Add one row for each item in your Purchase Order. Each line represents one item with its details.

Field Name	Required?	What to Enter	Example
Item_ID	Required	Custom identifier for the product/item	item_123
Style_Id	Optional	Style identifier	style_123
Style_Name	Optional	Style name/description	Classic T-Shirt
Line_Product_Category_Id	Optional	Custom ID of product category	cat_123
Line_Product_Line_Id	Optional	Custom ID of product line	line_123
Department_Id	Optional	Custom ID of department	dept_123
Class_Id	Optional	Custom ID of class category	class_123
Brand_Id	Optional	Custom ID of brand category	brand_123
Color	Conditional*	Item color (required for new items)	Blue
Line_Size	Conditional*	Item size (required for new items)	M

Line Items Information (Linked Items)

Create with linked items. Which in the Item Management page.

Field Name	Required?	What to Enter	Example
Item_ID	Required	Custom identifier for the product/item	item_123

Items Packing Details

Each Purchase Order must have at least one packing detail. Choose between solid or assortment packing.

Field Name	Required?	What to Enter	Example
Packaging_Type	Required	solid for single items or assortment for mixed packs	solid
Packaging_Carton_Quantity	Conditional*	Number of cartons/boxes (min 1). ((***required for assortment)	20
Packaging_Assortment_Id	Conditional*	Assortment ID (**required for assortment type)	assort_123
Packaging_Case_Pack_Qty	Conditional*	Units per carton (***required for assortment type)	5
Order_Quantity	Conditional*	The packing quantity (min 1). (***required for solid type)	100
Order_Quantity_Uom	Optional	The packing quantity UOM Code	kg

Tips for Items Template:

• If your item already exists in the system, you may only need Item_ID
• For new items, include Color and Line_Size for better identification
• Each PO must have at least one line and one packing detail
• Use "solid" packing for individual items, "assortment" for mixed packs

Material PO Template - Field Guide

Purchase Order Information

Field Name	Required?	What to Enter	Example
Po_Number	Required	Your original PO number from your system	PO-250901
OPO_Number	Required	OPO_Number is another field used to apply unique identifiers for Purchase Orders. Normally it is different from PO_Number. If not empty, make sure it is unique for each PO number. It can be both numbers and/or text.	opo_123
Total_Order_Quantity	Optional	The value to display PO total quantity	100
Total_Order_Quantity_Uom	Optional	The value to display PO total quantity UOM Code	m
Po_Type	Optional	Purchase order type from pre-configured list	po_type_1
Po_Source	Optional	Source of materials (domestic/international)	domestic
Po_Status	Optional	Status (only "canceled" is supported)	canceled
PO_ClientCreatedDate	Optional	Creation date from your system (YYYY-MM-DD)	2023-02-10
Delivery_Date	Optional	Delivery/shipment start date (YYYY-MM-DD)	2021-05-23
Ship_End_Date	Optional	Shipment end date (YYYY-MM-DDTHH:MM:SSZ)	2021-05-30T00:00:00
In_Store_Date	Optional	In store date (YYYY-MM-DDTHH:MM:SSZ)	2021-06-01T00:00:00
PO_EventName	Optional	Corresponding event name from your system	Event 1
Data_Provider	Optional	Local Custom ID of Data Provider organization. Let it empty will be using the current import org.	Provider-01
Client_Id	Optional	Local Custom ID of Brand/Retailer organization.	client_1
Factory_Custom_Id	Optional	Local Custom ID of Factory organization.	factory_1
Vendor_Custom_Id	Optional	Local Custom ID of Supplier organization (min 1 char).	vendor_1
Material_Supplier_Custom_Id	Optional	Local Custom ID of Material Supplier organization.	material_supplier_1
Commit_Id	Optional	Commit ID of the purchase order	commit_id_1
Commit_Po_Sequence	Optional	Commit PO sequence	commit_po_sequence_1
Share_To_Ids	Optional	Comma-seperated shared organization IDs	sub_org_1,sub_org_2

Material Line Details

Add one row for each material in your Purchase Order.

Field Name	Required?	What to Enter	Example
Item_ID	Required	Material ID in Material management page	cotton_001
Style_Id	Optional	Style identifier	style_123
Style_Name	Optional	Style name/description	Classic T-Shirt
Department_Id	Optional	Custom ID of department	dept_123
Class_Id	Optional	Custom ID of class category	class_123
Brand_Id	Optional	Custom ID of brand category	brand_123
Color	Optional	Material color	Blue

Material Packing Details

Field Name	Required?	What to Enter	Example
Order_Quantity	Required	The packing quantity (min 1)	100
Order_Quantity_Uom	Required	The packing quantity UOM Code	kg

Additional Attributes (Optional)

The last other fields when using the download template, they are custom attributes for Purchase Order, which defined by the Data Provider, these columns will be auto-generate based on current active PO custom attributes. You can input the value (can be string, number, or list(Comma-seperated)) based on the definition of these fields.