Product Import Templates

The "sku" column is the only required header for imports to update existing products. Therefore, all other columns may be added to your Basic Product Import template, or managed on a smaller scale using these feature-specific templates.

Unless you are replacing Images or Categories, please use the Import Behavior: Append

Simple Products

Download the csv template here or copy the headers below.

sku	_type	name	description	price	status	qty	visibility	use_config_manage_stock	is_in_stock	manage_stock	tax_class_id	category_ids	image	_media_image
Product1	simple	Simple Product 1	Simple Product 1	10	1	9999	4	1	1	1	2	26,35,57	https://cdn.com/imageA.jpg	https://cdn.com/imageA.jpg

Configurable Products

Download the template here or copy the headers below

sku	_type	name	description	price	status	qty	visibility	is_in_stock	use_config_manage_stock	manage_stock	tax_class_id	weight	category_ids	image	_media_image	color (attribute)	size (attribute)	super_attribute_code	_configurable_skus	use_child_manage_stock	use_child_price	use_child_weight
ABC	configurable	ABC Product	ABC Product's Description	13.5	1		4	1	1	1	2	1.5	26,35,57	https://cdn.com/imageABC.jpg	https://cdn.com/imageABC.jpg			size,color		Yes	Yes	Yes
ABC-Blue-Small	simple	ABC Product-Blue-Small	ABC Product-Blue-Small	13.5	1	9999	1	1	1	1	2	1.5		https://cdn.com/imageA.jpg	https://cdn.com/imageA.jpg	Blue	Small		ABC
ABC-Blue-Med	simple	ABC Product-Blue-Med	ABC Product-Blue-Med	14	1	9999	1	1	1	1	2	1.5		https://cdn.com/imageB.jpg	https://cdn.com/imageB.jpg	Blue	Medium		ABC

Downloadable Products

Download the template here or copy the headers below

sku	_type	name	description	price	status	qty	visibility	use_config_manage_stock	is_in_stock	manage_stock	tax_class_id	category_ids	image	_media_image	links_title	_download_link_title	links_purchased_separately	_download_link_price	_download_link_number_of_downloads	_download_link_is_shareable	_download_link_url	_download_link_sort_order	_download_link_view_not_download	samples_title	_download_sample_title	_download_sample_url	_download_sample_sort_order
D123	downloadable	Download 123	Download 123	0	1	1	4	0	1	0	2	180	https://cdn.hswstatic.com/gif/dictionary.jpg	https://cdn.hswstatic.com/gif/dictionary.jpg	Reference Books	Dictionary	1	25	5	0	https://s3.amazonaws.com/zcom-media/sites/a0iE000000LhWtrIAF/media/mediamanager/largedictionary.pdf	1	0	Sample Reference Books	Sample Dictionary	https://s3.amazonaws.com/zcom-media/sites/a0iE000000LhWtrIAF/media/mediamanager/largedictionary.pdf	1
																Thesaurus	1	25	5	0	https://s3.amazonaws.com/zcom-media/sites/a0iE000000LhWtrIAF/media/mediamanager/RogetsThesaurusofEnglishWordsandPhrasesClassifiedandArrangedSoastoFacilitatetheE_10254687.pdf	2	0		Sample Thesaurus	https://s3.amazonaws.com/zcom-media/sites/a0iE000000LhWtrIAF/media/mediamanager/RogetsThesaurusofEnglishWordsandPhrasesClassifiedandArrangedSoastoFacilitatetheE_10254687.pdf	2

Quantity Increments and Packaging

Download the template here or copy the headers below

sku	qty	is_qty_decimal	use_config_enable_qty_inc	enable_qty_increments	use_config_qty_increments	qty_increments	qty_increments_is_default	zoey_add_to_cart_qty	enable_qty_packaging	qty_increment_label	qty_unit_label	qty_increments_1_value	qty_increments_1_label	qty_increments_1_is_default
Product1	7685	0	0	1	0	6	1	1	Yes	Each	Each	6	Case	0

Customer Group Pricing

Download the template here or copy the headers below

sku	_group_price_Customer Group 1	_group_price_Customer Group 2
Product1	57.99	59

Inventory & Backorder

Download the template here or copy the headers below

sku	qty	is_in_stock	use_config_manage_stock	manage_stock	use_config_backorders	backorders
Product1	9999	1	1	1	0	0
Product2	2	1	0	0	2	1

Minimum / Maximum Quantity Allowed

Download the template here or copy the headers below

sku	min_sale_qty	min_qty_group	use_config_min_sale_qty	max_sale_qty	use_config_max_sale_qty	min_sale_qty_General	min_sale_qty_Wholesale	max_sale_qty_General	max_sale_qty_Wholesale
Product1	1		1	1000	0	5	100

Product Restrictions

Download the template here or copy the headers below

sku	zb2b_product_restricted	zb2b_restricted_prod_groups	customer_permissions	account_permissions	account_location_permissions
Product1	Yes	General, Wholesale	7	4
Product2	Yes	Wholesale	2,11,32	1,12

Related Products

Download the template here or copy the headers below

sku	_links_related_sku	_links_related_position	_links_crosssell_sku	_links_crosssell_position	_links_upsell_sku	_links_upsell_position
Product1	related-sku1	3	cross-sell_sku1	1	up-sell-sku1	1
	related-sku2	1	cross-sell_sku2	3	up-sell-sku2	2
	related-sku3	2	cross-sell_sku3	2	up-sell-sku3	3

Tier Pricing (Volume Discounts)

Download the template here of copy the headers below

sku	_tier_price_customer_group	_tier_price_qty	_tier_price_price	use_child_price	tier_price_group	tier_price_across_variations	apply_tier_price_to_variation
SimpleProduct1	1	10	3.75			Scented Products