Columns

Description

store_code

Required

Code of the store where transaction took place

invoice_number

Required

Unique reference number to identify transactions.

If the same value is repeated then it will be ignored or updated based on configuration

invoice_date

Required

Date and time of transaction in format:
YYYY-MM-DD HH:MM:SS

invoice_amount

Required

Bill Amount

invoice_source

Optional

Source of the transaction. Can be any value

invoice_payment_mode_names

Required

Pipe separated names of payment modes.

Use “froogal_loyalty” to mark any payment done by loyalty redemption.

invoice_payment_mode_amounts

Required

Pipe separated amounts of each respective payment modes mentioned above

customer_name

Optional

Name of the customer

customer_phone_number

Required

Mobile number of customer

customer_email

Optional

Email ID of the customer

product_sku

Required

Product code / SKU

product_name

Required

Name of the product

product_sub_category

Optional

Subcategory of the product

product_category

Required

Category of the product

product_comments

Optional

Item Comments/Instructions

product_rate

Required

Rate of each product

product_rate_includes_tax

Required

1 or 0 basis on if the rate is inclusive of tax or tax is extra

product_quantity

Required

Quantity purchased

product_quantity_uom

Optional

Unit of Measurement of the quantity purchased

product_discount_amount

Required

Discount given (if any)

product_net_amount

Required

Net amount for the product, after applying discount

product_tax_names

Optional

Pipe separated names of taxes applicable on the product.

(E.g. “StateVAT|CentralVAT”)

product_tax_rates

Optional

Pipe separated tax rates respective to above mentioned taxes

product_tax_amounts

Optional

Pipe separated tax amounts respective to above mentioned taxes

Columns		Description
store_code	Required	Code of the store where transaction took place
invoice_number	Required	Unique reference number to identify transactions. If the same value is repeated then it will be ignored or updated based on configuration
invoice_date	Required	Date and time of transaction in format: YYYY-MM-DD HH:MM:SS
invoice_amount	Required	Bill Amount
invoice_source	Optional	Source of the transaction. Can be any value
invoice_payment_mode_names	Required	Pipe separated names of payment modes. Use “froogal_loyalty” to mark any payment done by loyalty redemption.
invoice_payment_mode_amounts	Required	Pipe separated amounts of each respective payment modes mentioned above
customer_name	Optional	Name of the customer
customer_phone_number	Required	Mobile number of customer
customer_email	Optional	Email ID of the customer
product_sku	Required	Product code / SKU
product_name	Required	Name of the product
product_sub_category	Optional	Subcategory of the product
product_category	Required	Category of the product
product_comments	Optional	Item Comments/Instructions
product_rate	Required	Rate of each product
product_rate_includes_tax	Required	1 or 0 basis on if the rate is inclusive of tax or tax is extra
product_quantity	Required	Quantity purchased
product_quantity_uom	Optional	Unit of Measurement of the quantity purchased
product_discount_amount	Required	Discount given (if any)
product_net_amount	Required	Net amount for the product, after applying discount
product_tax_names	Optional	Pipe separated names of taxes applicable on the product. (E.g. “StateVAT\|CentralVAT”)
product_tax_rates	Optional	Pipe separated tax rates respective to above mentioned taxes
product_tax_amounts	Optional	Pipe separated tax amounts respective to above mentioned taxes