Transactions - Submit Bulk

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