{Company-Name} ERP to CIMcloud Integration - Data Mapping Sheet - Version 2 - MM/YYYY

	A	B	C
1	Overview
2
3		This is a Data Mapping Sheet template example that can be used to plan complex integration projects using the CIMcloud API.
4		This document is drafted by the Solution Architect (and then modified and maintained by the Lead Technical Planner and Developers)
5
6	Video Overview / Help Article
7
8		Data Mapping Sheet	https://help.cimcloud.com/help-center/the-data-mapping-sheet/
9		Solution Architect Role	https://help.cimcloud.com/help-center/the-solution-architect/
10
11	Worksheets / Tabs Needed
12
13		This example / template has a few worksheets / tabs already included (just for reference).
14
15		1) You need one worksheet total that lists all of the table-table (data entity to data entity) syncs that will occur.
16		- This is represented by the "erp-cimcloud-sync-tables" worksheet / tab (this might be what an ERP integration with CIMcloud looks like).
17		- This is also represented by the "3P-ecom-cimcloud-sync-tables" (this might be what a Shopify, Magento, Woo Commerce, or Big Commerce integration to CIMcloud looks like).
18
19		2) You need one worksheet for EACH row (data sync) in the above worksheet
20		- This is represented by the "to-cimcloud-accounts" worksheet (this might be what the data sync handles that syncs ERP customers to the CIMcloud accounts table).
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
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