Toolio - Core Data Models

	B	C	D	E
1
2
3
4
5	Core Data Models
6
7	Each tab in this document represents a data feed and the core columns for each model. Note that only a subset of the core columns are required. Custom columns can be added by referencing the respective display name.
8
9	Version	1.1.0
10
11	Core Models
12	Model	Comments	Required	Scope
13	Product	Variant (SKU) level product meta data along with all the required attributes. Attributes from the Product feed will be automatically used to enrich data from the other seeds.	TRUE	ALL
14	Sale	Sales and returns information that is aggregated over a specific time unit, such as day or week. If desired, data can also be shared in the order / transaction level granularity.	TRUE	ALL
15	Inventory	SKU level inventory information by location over time. By default we request ending inventory, along with its Cost, Retail and Ticket value for each timestamp.	TRUE	ALL
16	Purchase Orders	SKU level purchase order information. This feed is used to calculate On Order metrics.	TRUE	ALL
17	Receipts	SKU level receipts. This feed is used to calculate Receipts metrics. Receipts feed in against the Purchase Orders to update On Order metrics.	TRUE	ALL
18	Location	Locations including all selling and inventory locations. Can be used to represent wholesale customers accounts	TRUE	ALL
19	Transfer Order (Allocation Only)	Required for Allocation Module only. SKU level transfer order information. This feed is used to calculate In Transit metrics.	FALSE	Allocation
20	Transfer Receipt (Allocation Only)	Required for Allocation Module only. SKU level transfer receipt information. This feed is used to calculate Transfer Receipt metics.	FALSE	Allocation
21	Merchandise Plan (optional)	Import feed for merchandise plans created outside of Toolio. Plan feed is NOT required for the core Toolio integration. Plans are stored per attribute combination over time.	FALSE	Importing Existing Plans
22	Assortment Plan Item (optional)	Import feed to add assortment line plans you have created outside of Toolio. Assortment Plan Item is NOT required for the core Toolio integration.	FALSE	Importing Existing Plans
23	Booking (optional)	Bookings feed for capturing whoelsale orders. Booking feed is NOT required for the core Toolio integration.	FALSE	Wholesale
24
25	References
26	Video Guide	A quick video guide that goes over the core data models, attributes and custom attributes.
27	Integration Guide	High level overview of data feeds and handling of custom attributes.
28	Sample Data Feed	Please review this spreadsheet to see what sample data feeds could look like
29	Pre-Import Data Validation	Input your data csv files into the Toolio Pre-Import Data Validation Template in your Google Drive folder to ensure data format accuracy
30
31	Have Questions?
32	If you have questions on how to fill this, we are here to help. Please ask your account manager or reach out to us on Slack or success@toolio.com
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