Data & Character Limitations
How many custom attributes can I add?
You can add up to 100 custom attributes and unlimited number of metrics. If you need to add more than 100 custom attributes, please let your Customer Success Manager know.
Are there character limitations for an attribute value?
Please see below the character limits for different set of attributes.
Attribute Type | Limit | Examples |
Core Attribute | 255 Characters | Title, External Id |
Custom Attribute | 64 Characters | Color, Size, Division, Department |
Historical Data
How much historical data is needed for validation?
Below are the recommended historical data for validation. This give Toolio enough sample set to iron out the kinks in your data.
Model | Duration |
Sale | 3 months |
Inventory | 3 months |
Purchase Order | 6 months (based on PO create date) |
Product | Full |
How much historical data is needed for initial data import?
We recommend importing all the historical data that will be helpful to your future decisions. We suggest loading the following data durations into Toolio.
Model | Duration |
Sale | 3 years |
Inventory | 3 years |
Purchase Order | 3 years |
Product | Full |
Data Update Frequency
When and how frequently will the data be updated?
Data update frequency will depend on the needs of the business, but our suggested approach is sending data once a week, after the last day of the week on your retail calendar. For example, if you are on NRF 4-5-4, your week is most likely ending on Saturday, so sharing the data feed on Sunday morning would be ideal.
When you are updating data, you only need to send the relevant data, i.e. you don’t need to send a full data dump every week. Below are some rules of thumb on how much data to send every week.
Model | Data Span | Comments |
Sale | Trailing 8 weeks | Sales information can change for a few weeks after the transaction. So please send the trailing 8 weeks |
Inventory | Trailing 8 weeks |
|
Purchase Order | Created or updated in the last 4 weeks |
|
Product | Created or updated in the last 4 weeks |
|
What is a good time in the day for the integrations (or data sync) to be triggered at?
We recommend having the integrations or data feeds to be synced as early as possible within the day at a time after which you know the sources of record (e.g. ERP or Data Warehouse) are fully updated. A typical recommendation would be some time between 1-4AM in your organization local time.
Let's say that you have set up your data warehouse to be the source of truth for your Toolio integration. Review with your tech team, when your data warehouse is typically updated. We typically see the update process starting at midnight and taking a few hours. Accordingly, set the Toolio integration trigger time to be 30-60 mins after the time your database would be updated.