How other vendors in the retail industry are organizing their data in Mitto?

Runner
#1

How other vendors in the retail industry are organizing their data in Mitto and are setting up updates with weekly reporting across multiple retailer reports? Do they have checks in place to validate that all data is included?

Client uploads weekly Excel file with updates to the sales data. They are curious to know how others are doing it.

If they were to use Regex jobs to go through 100-200 files (12 columns by 300 rows) would that impact performance severely?

#2

Great question @dorian!

There are a few facets to this question:

  1. How to structure data in a database when data is coming from multiple sources and/or relates to multiple customers.
  2. How to load multiple flat files worth of data into Mitto on a schedule.
  3. Performance impact of #2.

Here are some threads that address these topics:

As for #3, only new/changed files are processed on subsequent RegEx job runs. The jobs should run fairly quickly due to small data volume.