Data Tables

Video

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.

VERIFY:

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.
Screen Shot 2021-06-03 at 12.12.06 PM.png

In the upper right corner click "Import Table."
Screen Shot 2021-06-03 at 12.19.01 PM.png

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."

Screen Shot 2021-06-03 at 12.21.33 PM.png

The newly created data table will appear in the list.
Screen Shot 2021-06-03 at 12.19.15 PM.png

Click on the table name to verify the information.

Screen Shot 2021-06-03 at 12.19.34 PM.png

From this window,
Click the "Rename" button to rename the table -- this does not modify the table data.
Screen Shot 2021-06-03 at 12.52.53 PM.png

Click "Download" to download a CSV copy of the table for editing.
Screen Shot 2021-06-03 at 12.52.58 PM.png

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.
Screen Shot 2021-06-03 at 12.53.02 PM.png

New columns will be added to the column list. Adjust the data type as needed.

Screen Shot 2021-06-03 at 12.30.06 PM.png

Removed columns will be noted with a warning message in red at the bottom.

Screen Shot 2021-06-03 at 12.30.41 PM.png

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.

Screen Shot 2021-06-03 at 12.35.18 PM.png

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.

Screen Shot 2021-06-03 at 2.03.21 PM.png

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.

Screen Shot 2021-06-03 at 2.06.13 PM.png

Select whether you want the value equal (=) or not equal (!=) to that found in the column.

Screen Shot 2021-06-03 at 2.06.33 PM.png

In the right-hand drop down, select the attribute on the item whose value will be set.
Screen Shot 2021-06-03 at 2.06.26 PM.png

Screen Shot 2021-06-03 at 1.56.22 PM.png

NOTE:

The columns in your table may or may not match the names of your attributes. Name matching is not required.

Click "Done."

Screen Shot 2021-06-03 at 2.10.34 PM.png

Don't forget to "Save Item!"

Screen Shot 2021-06-03 at 2.10.41 PM.png

Test your configurator to ensure the value is properly updating.

Small Medium Large
Screen Shot 2021-06-07 at 9.34.46 AM.png Screen Shot 2021-06-07 at 9.34.59 AM.png Screen Shot 2021-06-07 at 9.34.53 AM.png

 

Video

 

🗑️ Data Tables trash - you can now delete data tables you no longer need.
datatable-delete

You can Go to trash and restore deleted Data Tables:
datatable-restore

Share this