Transaction

Order Entity <order>

Name	Type	Required	Valid value / Description	Example
timezoneGmt	integer		Timezone GMT. CDP stores Date value in GMT-0. If your date value is in the different GMT (ex: +7), You should send this value to PangoCDP.	7
Custom Fields			All Custom Field
systemName	String		Your System name	POS
internalCompanyId	String		If your system has multiple companies, put it for each request
orderId	String	Yes	Order Id	ORDER00001
orderStatus	String	Yes	Order Status	PaymentAbandoment
orderDate	Timestamp		Order Date (milliseconds)	1584483275000
customerId	String	Yes	Customer ID	CUS010012212
customerName	String	Yes	Customer Name	John
customerEmail	String	Yes	Customer Email	[email protected]
customerPhone	String	Customer Phone	03263262525
createdBy	String		Created by	user1
createdAt	Timestamp		Time of creation (milliseconds)	1584483275000
updatedBy	String		Updated by	user1
updatedAt	Timestamp		Time of Update (milliseconds)	1584483275000
deliveryMethod	String		Delivery method
deliveryDate	Timestamp		Date of delivery (milliseconds)	1584483275000
deliveryStatus	String		Delivery status
shippingCost	Double		Shipping cost	35000
paymentMethod	String		Payment Method
paymentStatus	String		Payment Status
vatCost	Double		VAT Cost	25000
vatPercent	Float		VAT Percent	10
discount	Double		Discount value	58000
discountPercent	Float		Discount percent	8.2
totalProductCost	Double		Total product cost = Amount	530000
totalCost	Double		Total cost = Original Cost without discount	560000
totalCostWithVat	Double		Total cost including VAT
recordStatus	String		Record Status: Active, Deleted	Active
items	Object	Yes	List of Items in Order	[ Order Item Entity ]
Order Item Entity
Custom Fields			All Custom Field
productSku	String	Yes	Product SKU	SKU001
productName	String	Yes	Product Name	Coffee Bee
price	Double		Product Price	50000
price4Sale	Double		Price is applied in this Order	45000
imageLink	String		Image Link of the product
productLink	String		Product Link
quantity	Integer		Quantity	2
unit	String		Unit of Product	Package
discount	Double		Discount value	35000
discountPercent	Float		Discount percent	5
totalProductCost	Double		Total product cost = Amount Quantity * Price for Sale	530000
totalCost	Double		Total cost = Original Cost without discount	560000
addedAt	Timestamp		Time of creation (milliseconds)	1584483275000
updatedAt	Timestamp		Time of Update (milliseconds)	1584483275000
recordStatus	String		Record Status: Active, Deleted	Active

Shopping Cart Entity <shopping-cart>

Name	Type	Required	Valid value / Description	Example
timezoneGmt	integer		Timezone GMT. CDP stores Date value in GMT-0. If your date value is in the different GMT (ex: +7), You should send this value to PangoCDP.	7
Custom Fields			All Custom Field
systemName	String		Your System name	POS
internalCompanyId	String		If your system has multiple companies, put it for each request
cartId	String	Yes	Cart Id	CART00001
cartStatus	String	Yes	Cart Status
customerId	String	Yes	Customer ID	C01001001
customerName	String	Yes	Customer Name	Lee Nguyen
customerEmail	String	Yes	Customer Email	[email protected]
customerPhone	String		Customer Phone	098685xxxx
createdAt	Timestamp		Time of creation (milliseconds)	1584483275000
updatedAt	Timestamp		Time of Update (milliseconds)	1584483275000
vatCost	Double		VAT Cost	25000
vatPercent	Float		VAT Percent	10
discount	Double		Discount value	58000
discountPercent	Float		Discount percent	8
totalProductCost	Double		Total product cost = Amount Quantity * Price for Sale	530000
totalCost	Double		Total cost = Original Cost without discount	560000
totalCostWithVat	Double		Total cost including VAT
recordStatus	String		Record Status: Active, Deleted	Active
items	Object	Yes	List of Items in Shopping Cart	[Cart Item Entity]
Shopping Cart Item Entity
Custom Fields			All Custom Field
productSku	String	Yes	Product SKU	SKU001
productName	String	Yes	Product Name	Product 1
price	Double		Product Price	50000
price4Sale	Double		Price is applied in this Order	45000
imageLink	String		Product Image Link	https://domain.com/media/pic1.png
productLink	String		Product Link	https://domain.com/p1
quantity	Integer		Quantity	2
unit	String		Unit of Product	Package
discount	Double		Discount value	35000
discountPercent	Float		Discount percent	5
totalProductCost	Double		Total product cost = Amount Quantity * Price for Sale	530000
totalCost	Double		Total cost = Original Cost without discount	560000
addedAt	Timestamp		Time of creation (milliseconds)	1584483275000
updatedAt	Timestamp		Time of Update (milliseconds)	1584483275000
recordStatus	String		Record Status: Active, Deleted	Active

Purchase History Entity <purchase-history>

Name	Type	Required	Valid value / Description	Example
timezoneGmt	integer		Timezone GMT. CDP stores Date value in GMT-0. If your date value is in the different GMT (ex: +7), You should send this value to PangoCDP.	7
Custom Fields			All Custom Field
systemName	String		Your System name	POS
internalCompanyId	String		If your system has multiple companies, put it for each request
transactionId	String	Yes	Transaction ID	TXN0000000001
receiptId	String		Receipt Id	R102921
storeId	String		Store ID	STORE001
storeName	String		Store Name	Happy Store
storeCity	String		Store City	HCM
storeDistrict	String		Store District	Tan Phu
customerId	String	Yes	Customer ID	user1
customerName	String	Yes	Customer Name	Nguyen Van A
customerPhone	String	Yes	Phone Required if Email is missing	098685xxxx
customerEmail	String		Email Required if Phone is missing	[email protected]
transactionDate	Timestamp	Yes	Date of Transaction (milliseconds)	1584483275000
transactionAt	Timestamp	Yes	Time of Transaction (milliseconds)	1584483275000
transactionUpdatedAt	Timestamp		Time of Update (milliseconds)	1584483275000
paymentMethod	String		Payment Method: Cash, Transfer	cash
payment1	Double		Paid amount 1	560000
payment2	Double		Paid amount 2	530000
payment3	Double		Paid amount 3	25000
payment4	Double		Paid amount 4	35000
payment5	Double		Paid amount 5	50000
payment6	Double		Paid amount 6	50000
vatCost	Double		VAT amount	25000
vatPercent	Float		VAT percent	10
discount	Double		Discount value	58000
discountPercent	Float		Discount percent	15
totalProductCost	Double		Total product cost = Quantity * Selling Price	530000
totalCost	Double		Total Cost = Original Cost without discount	560000
totalCostWithVat	Double		Total cost including VAT
totalItem	Long		Total Items	3
totalQuantity	Long		Total Quantity	15
recordStatus	String		Record Status: Active, Deleted	Active
items	Object	Yes	List of Item	[Purchase History Item Entity]
Purchase History Item Entity
Custom Fields			All Custom Field
itemId	String	Yes	Item SKU	SKU001
itemName	String	Yes	Item Name	Product 1
price	Double		Product Price	50000
price4Sale	Double		Price is applied in this Order	45000
productLink	String		Product Link	https://domain.com/p1
imageLink	String		Product Image Link	https://domain.com/media/product1.png
brand	String		Brand	BrandX
groupBrand	String		Group Brand	G10921
groupCategory	String		Group Category	HANDBAGS & PURSES
categoryId	String		Category ID	CAT0011
categoryName	String		Category Name	SHOP SCARVES
quantity	Long		Quantity	65000
unit	String		Unit of Product	Piece
discount	Double		Discount Value	5000
discountPercent	Float		Discount Percent	10
totalProductCost	Double		Total Product Cost	100000
totalCost	Double		Total Cost	65000
recordStatus	String		Record Status: Active, Deleted	Active

Order Payment Entity <order-payment>

Name	Type	Required	Valid value / Description	Example
timezoneGmt	integer		Timezone GMT. CDP stores Date value in GMT-0. If your date value is in the different GMT (ex: +7), You should send this value to PangoCDP.	7
Custom Fields			All Custom Field
systemName	String		Your System name	POS
internalCompanyId	String		If your system has multiple companies, put it for each request
paymentId	String	Yes	Payment Id	P1928A11231
storeId	String		Store Id	STORE001
transactionId	String		Transaction Id	TX19290210012
invoiceCode	String		Invoice Code	BD/20E
invoiceNumber	String		Invoice Number	0013682
invoiceTaxCode	String		Invoice Tax Code	0325236xxx32
paymentType	String		Payment Type: Cash, Transfer,..	Cash
invoiceDate	Timestamp		Date of invoice (milliseconds)	1584483275000
transferName	String		Transfer Name
transferDate	Timestamp		Transfer Date (milliseconds)	1584483275000
refund	Boolean		Refund: true/false	false
refundReason	String		Reason of refund
companyName	String		Company Name
companyTaxCode	String		Company Tax Code
companyAddress	String		Company Address
adjustAmount	Double		Adjust amount
receiptId	String		Receipt Id
fullNameCardOwner	String		Card Owner Full Name
customerId	String	Yes	Customer ID	user1
customerName	String		Customer Name	Nguyen Van A
customerPhone	String		Phone	098685xxxx
customerEmail	String		Email	[email protected]
note	String		Notes
updatedAt	Timestamp		Modified time	1584483275000
updatedBy	Timestamp		Modified by	user1
items	Object	Yes	List of Item	[Order Payment Item Entity]
Order Payment Item Entity
Custom Fields			All Custom Field
paymentDetailId	String	Yes	Payment Item Id
typeFee	String	Yes	Fee type
paymentItemName	String	Yes	Item name
lineQty	Long		Line quantity	2
itemPrice	Double		Item Price	5000000
linePaymentAmount	Double		Total amount	10000000
lineVATPercent	Float		% VAT	10
createdAt	Timestamp		Time of Creation (milliseconds)	1584483275000
updatedAt	Timestamp		Time of Modification (milliseconds)	1584483275000
recordStatus	String		Record Status: Active, Deleted	Active

{
   "objectType": "order-payment",
   "source": "POS",
   "entries": [
       {
           "systemName": "POS",
           "internalCompanyId": "ORG912101",
           "paymentId": "payment0001",
           "storeId": "luybanbich-store",
           "transactionId": "transaction-012525",
           "invoiceCode": "INV09238923",
           "invoiceNumber": "1354654654",
           "invoiceTaxCode": "89898989-Tax",
           "paymentType": "Cash",
           "invoiceDate": 1620232433000,
           "transferName": "Nguyen Minh Dien",
           "transferDate": 1620115201000,
           "refund": false,
           "refundReason": null,
           "companyName": "Your Company Name",
           "companyTaxCode": "companyTaxCode-565",
           "companyAddress": "Binh Thanh, HCM",
           "adjustAmount": 150000,
           "receiptId": "REC-121212",
           "fullNameCardOwner": "NGUYEN MINH DIEN",
           "customerId": "CUS09093093",
           "customerName": "Dee Nguyen",
           "customerPhone": null,
           "customerEmail": null,
           "note": "This is a Note",
           "updatedAt": 1620028801000,
           "updatedBy": "system",
           "recordStatus": "Active",
           "items": [
               {
                   "paymentDetailId": "PAY-ITEM-01",
                   "typeFee": "Implement Fee",
                   "paymentItemName": "CDP X-Dossier",
                   "lineQty": 2,
                   "itemPrice": 150000000,
                   "linePaymentAmount": 300000000,
                   "lineVATPercent": 5000000,
                   "createdAt": 1620075601000,
                   "updatedAt": 1620093668000
               }
           ]
       }
   ]
}

Product Entity <product>

Name	Type	Required	Valid value / Description	Example
timezoneGmt	integer		Timezone GMT. CDP stores Date value in GMT-0. If your date value is in the different GMT (ex: +7), You should send this value to PangoCDP.	7
Custom Fields			All Custom Field
systemName	String		Your System name	ERP
internalCompanyId	String		If your system has multiple companies, put it for each request
source	String		Source of the Product	Online
productId	String	Yes	Product Id	9112912
sku	String	Yes	SKU Id	SKU001
name	String		Name of Product	iPhone 12
description	String		Description of Product
price	Double		Product price	25000000
productLink	String		Link of product	https://domain/p/iphone12.html
reviewLink	String		Link of reviewing
imageLink	String		Image Link of Product	image_link1
imageLinks	List		List of Image Links of Product. If your product has more than one link, put all links into this fields	[image_link1, image2_link2]
color	String		Color of Product
unit	String		Unit	Piece
brand	String		Brand name	Apple
groupBrand	String		Group brand name
groupCategory	String		Group category
category	String		Category Id
categoryName	String		Category Name
recordStatus	String		Record Status: Active, Deleted	Active

{
   "objectType": "product",
   "source": "ERP-Online",
   "entries": [
       {
           "systemName": "ERP",
           "internalCompanyId": "ORG1918729",
           "productId": "9112912",
           "sku": "SKU001",
           "name": "iPhone S",
           "description": "Iphone",
           "price": 25000000,
           "productLink": "https://domain/ipad-10-2-inch-2020.html",
           "imageLink": "https://cdn.cellphones.com.vn/media/catalog/product/cache/7/image/9df78eab33525d08d6e5fb8d27136e95/s/a/samsung-galaxy-a12_2_.jpg",
           "imageLinks": ["https://cdn.cellphones.com.vn/media/catalog/product/cache/7/image/1000x/040ec09b1e35df139433887a97daa66f/s/a/samsung-galaxy-a12_1_.jpg"],
           "color": "Black",
           "unit": "Piece",
           "brand": "Apple",
           "groupBrand": "Apple XYZ",
           "groupCategory": "Device",
           "category": "mobile",
           "categoryName": "Mobile",
           "recordStatus": "Active"
       }
   ]
}