CBIS New Product Setup in MP-Ver1.1.xlsx

	A	B	C	D
1	Field	Value		Example:

2
3	Product Type			Online, Print sub, Online Sub, Print, Downloadable - see notes below
4
5	Product Type	# Product Codes Needed	Single/Multi Issue	Notes for product codes
6	Subscription
7	Online	1	M	X*******
8	Print	1	M
9	Training pass	1	M	WB**TP ( ** is for library like ASSN, GRAN etc.)
10	Print Product	1	S	Refer Print\|PDF Products sheet for product code guidelines.
11	eBook/PDF downloads	1	S	Refer Print\|PDF Products sheet for product code guidelines.
12	Online
13	Webinars	Multiple based on available types (Live, OnDemand, CD, Package, Seried, Certificates)		Refer webinars sheet for product code guidelines
14	Events	Multiple based on different types (single, table, workshop, combo etc)	S	YYMM***E (For events occuring every year like salute, CFO we have different code. Refer Events sheet for guidelines for yearly events.)
15	Trends Events Sponsorship/Adversitements	1	S	****SYY (e.g. TCBES12, TFBES15 etc )
16	E-learning	1	S	EL******
17
18	YYMM is for year and month and * is for the characters in name of the product
19
20	New Product Code(s): (8 char max; each)			XATND, NTPA11, DCSSPP16
21
22	Short Description (40 characters):			Trends News Delivery Subscription
23	if more then one product add additional titles to right
24	Product Title Line 1 (50 characters):			2016 Salary Survey of Nonprofit Organizations in
25	if more then one product add additional titles to right
26	Product Title Line 2 (50 characters):			the DC Metro-Area: Participant Rate
27
28	Library code			ASSN, GR, APC, MTGS
29
30	Reporting Product Group			Refer Reporting Groups sheet for available options
31
32	COPY From product			Copy from which existing product? Generally we should use product of previous year for same type but if completely new product, need ot know from which product we can copy the setup, GL etc configuration in MP.
33
34	Delivery Method			Refer Delivery Method\|Category sheet for available options
35
36	Category			Refer Delivery Method\|Category sheet for available options
37
38	New Order Price(s):			$449.00
39
40	Conversion Renewal Order Price(s)			$419, If multi issue product
41
42	Non-Conversion Renewal Order Price(s)			$419, If multi issue product
43
44	Early Bird Price			$319, If applicable
45
46	Early Bird Cuttoff date			07/01/17, If applicable
47
48	Standing Order Available?
49
50	Standing Order Price			$319, If applicable
51
52	Taxable?
53
54	S&H:			$10, If shippable product
55
56	Setup Product as Non-Shipping or Shipping:			Ready for fulfillment
57
58	Anticipated Avaliabilty Date for Publication:			4/11/2013
59
60	Anticipated Start Date for Marketing:			4/11/2013
61
62	Update Schedule:			Monthly
63
64	Bundled Product?:			No
65
66	List product for Bundle products
67
68	Date Request Entered:			1/11/2013
69
70	Requestor's Name:			Jamie Herring
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100