By Item
Efficiently retrieve sales data categorized by items with this dedicated job for fetching sales information from Zoho Books.
Add this jobData
Sample Data
Open in new tab -Data headers
| Header | Description |
|---|---|
| item_name | Item name |
| month | Month of the sales data |
| quantity_sold | Quantity of items sold |
| average_price | Average price per item |
| amount | Total sales amount |
| is_combo_product | Indicates whether the item is a combo product |
| item_id | Zoho Books ID used to refer to the item |
Filtration options
This job can restrict the data that is visible in spreadsheets. Use the following parameters to restrict the data.
| Parameter | Options |
|---|---|
| start_date | Select sales transactions with billing date on or after start_date. Format - YYYY-MM-DD |
| end_date | Select sales transactions with billing date on or before end_date. Format - YYYY-MM-DD |
| item_id | Select transactions related to a particular item (item_id) |