|UPDATE: Data Tables is now a sub-menu item of Catalog. For more information, please see the release note here.|
What are Data Tables?
Data tables are CSV files uploaded to Threekit and converted into a database.
Data tables are useful for storing all data for the configurator, logic, and so forth within the Threekit system, eliminating the need for external tools or connections.
Your CSV file must be of a "UTF-8 CSV" type to import properly.
Adding a Data Table
Ensure the top row of your CSV file is the column header information before uploading.
Click "Data tables" in the left-hand menu.
In the upper right corner click "Import Table."
Select the proper file from the popup window. In the new table window, name the table and select the appropriate data type for each column. Click "Create."
The newly created data table will appear in the list.
Click on the table name to verify the information.
From this window,
Click the "Rename" button to rename the table -- this does not modify the table data.
Click "Download" to download a CSV copy of the table for editing.
Click "Update" to upload a new file with adjusted information. NOTE: Any file may be used to update information, the file name does not need to match that of the previously uploaded file.
New columns will be added to the column list. Adjust the data type as needed.
Removed columns will be noted with a warning message in red at the bottom.
Click update when finished.
Using Data Tables in Catalog
In the catalog item edit screen, rules may use data table values as a source for attribute values.
Add a rule to pull information from the database into the attribute value.
Set the rule name and conditions as usual. Click the "+" to add a "set attribute" action.
Select the desired attribute from the drop down menu. (In this case SKU).
Select "Database query."
Select the desired data table.
In "Select the first value from" choose the column name from the data table.
Click "+ Add parameter." for each attribute whose value will originate from the data table.
Choose the desired column from the data table in the left-hand drop down.
Select whether you want the value equal (=) or not equal (!=) to that found in the column.
In the right-hand drop down, select the attribute on the item whose value will be set.
The columns in your table may or may not match the names of your attributes. Name matching is not required.
Don't forget to "Save Item!"
Test your configurator to ensure the value is properly updating.
🗑️ Data Tables trash - you can now delete data tables you no longer need.
Go to trash and restore deleted Data Tables: