The Admin Dataset has 6 sheets within the single spreadsheet. Its used to collect data for users, roles, permissions, order ship methods, order statuses, and categories.
Users & Roles
Column Name
Required
Value Type
Description
Example Value
First Name
Yes
Text
First name of user
John
Last Name
Yes
Text
Last name of user
Doe
Email Address
Yes
Text
User email address
johndoe@company.com
Role
Yes
Text
Role within the Aturian workspace
Super Admin
Is Salesperson?
Yes
Yes / No
Is this user able to receive sales commissions?
no
Roles & Permissions
Column Name
Required
Value Type
Description
Example Value
Role Description
Yes
Text
Label of the role
Super Admin
Permissions Descriptions
Yes
Text
General description of what this role has access to within your Aturian workspace
This user has access to everything.
Teams
Column Name
Required
Value Type
Description
Example Value
Team Name
Yes
Text
Name of team
John's Team
User
Yes
Text
User's first and last name
Tim Daniels
Order Ship Via Methods
Column Name
Required
Value Type
Description
Example Value
Ship Via Code
Yes
Number
A short code used to identify the shipping method
1
Description
Yes
Text
A clear, user-friendly name for the shipping method
UPS Ground
SCAC Code
No
Text
The Standard Carrier Alpha Code used to identify transportation companies
UPSN
Carrier Code
Yes
Text
An internal code identifying the carrier
UPS
Operations Statuses (a.k.a. Order Status)
Column Name
Required
Value Type
Description
Example Value
Status Number
Yes
Number
Number used to determine status hierarchy
1
Description
Yes
Text
Full status label
In Production
Short Description
Yes
Text
A shortened status label
IN PROD
Status Color
Yes
Text
Hexadecimal color used in the statuses label/badge
#eb4034
Tooltip
Yes
Text
Quick message about this status telling users what it is and/or how its used.
Order is in production in the warehouse.
Categories
Column Name
Required
Value Type
Description
Example Value
Category Name
Yes
Text
Category used to accurately calculate tax on the product