CSV File Formatting

This chart outlines the required fields for the CSV file when adding products to Homesome.

See this help article to learn how to add products.

Field Requirement Status	Template Column	Field	Description	Required Format
Optional	A	UPC	Unique identifier for a product	String
Required	B	itemName	Name of product that will appear on the store	Text
Required	C	Category	Product category	Text
Required	D	subCategory	Product subcategory	Text
Required	E	Price	Product price	Number (do not add a dollar sign $)
No longer available	F	Organic	This field is no longer functional, please leave blank
Optional	G	Brand	Links a brand to a product	String
Required	H	Unit	Product quantity unit (count/ lb)	COUNT/LB
Optional	I	sellByQty	Indicates if the product is sold by quantity. If set to TRUE, avgWeight must be greater than 0 or upload will fail	TRUE/FALSE
Optional	J	avgWeight	Average weight of an item that will be used to estimate the cost	Number
Optional	K	Ingredients	Details on the ingredients of a product	String
Optional	L	Disclaimer	Disclaimer for the product	String
Optional	M	bottleFee	Amount charged on product for bottle fee	Number (do not add a dollar sign $)
Required	N	isTaxable	Defines whether a product needs to be taxed	TRUE/FALSE
Optional	O	taxRate	Tax rate if different than sales tax	Enter tax percentage as a decimal rather than a %. For example, 8.7% should be entered as .087
Optional	P	isInStock	If false product will be marked OUT of stock	TRUE/FALSE
Optional	Q	isInactive	If true product will be marked INACTIVE	TRUE/FALSE
Optional	R	minQuantity	Minimum amount required to add to cart	Number
Optional	S	maxQuantity	Max amount allowed to add to cart	Number
Optional	T	isPickupOnly	If TRUE delivery will be DISABLED for this product	TRUE/FALSE