CSV/Excel Template

Both CSV and Excel templates are processed the same way, by the same code.

Template:

Schema:

* mandatory fields

Field Name	Field Description	Field Example	Field Requirements
`barcode`*	Barcode/APN/EAN/UPN/GTIN	9300201820775	Maximum 16, minimum 6 numbers with no duplicates
`item_code`*	Item Code/Supplier Code/Reorder Code	345893541	Maximum 13 characters, alphanumeric, dots and dashes
`description`*	Product/Item name	Panadol Pain Relief Tablets 100	Maximum 80 characters
`cost_exc_gst`*	Unit cost price excluding GST	9.75	Must be a positive numeric value
`retail_inc_gst`*	Unit RRP including GST	15.5	Must be a positive numeric value
`gst`*	GST status (Yes/No/Free)	Y	Must contain Y, N or F
`units`	Minimum order threshold for the cost price	12	Must be a positive numeric value
`available_date`	Start Date for the cost price	11/01/2023	Must be a date
`discontinued`	Discontinued status for the cost price (Y/N)	N	Must contain Y or N
`discontinued_date`	End Date for the cost price	21/12/2023	Must be a date
`department`	Department/Category name	Medicine
`sub_department`	Subdepartment/Subcategory name	Pain Relief
`brand`	Brand Name for the item	Panadol
`order_multiple`	Multiples the item needs to be ordered in	0	Must be a positive numeric value
`minimum_order_qty`	Minimum number of units that needs to be ordered	12	Must be a positive numeric value
`shelf_pack`	Number of units contained within the shelf pack	12	Must be a positive numeric value
`items_per_box`	Number of items contained within the box	100	Must be a positive numeric value
`manufacturer_name`	Manufacturer Name for the item	Panadol
`schedule_code`	Schedule Code for the item	S01
`availability`	Availability of the item at the warehouse	InStock	Must contain `InStock`, `BackOrder`, `PreOrder`, `OutOfStock` or `NotAvailable`
`product_image`	Url of the front facing primary product image	http://via.placeholder.com/900x900	Must be a valid URI, preferably with the file extension visible. In either png, jpg or gif. Accepted pixel size is between 900x900 and 2400x2400. Must be square.
`innerpack_gtin`	Barcode on the pack. Where pack is defined as: Intermediate package of multiples of the same trade item. Example: four jars of jam.	29300201820775	A valid ITF-14 code.
`innerpack_size`	The quantity of saleable items in the above inner pack. Example: four jars of jam. innerpack_size = 4. Require if `innerpack_gtin` is supplied.	4	A valid positive integer.
`case_gtin`	Barcode on the case. Where a case is defined as: A standard shipping unit that contains “eaches” (packaged either individually or grouped as an inner pack). All of the items in a case must have the same GTIN. Example: Example: a case containing 8 jars of strawberry jam.	39300201820775	A valid ITF-14 code.
`case_size`	The quantity of saleable items in the above case. Example: Example: a case containing 8 jars of strawberry jam. case_size = 8. Required if `case_gtin` is supplied.	8	A valid positive integer.