For high level clarity here is how we have things set up
5 scripts total
3 Customer & Products
• Customers + Ship-to (Run nightly)
• Customer Contact (Run nightly)
• Products (weekly Saturday)
2 pricing (pricing can take multiple hours to run)
• Pulls all pricing (run once or twice a month Saturday)(based on edge case we may need to run this nightly)
• Pulls only updated pricing (run nightly)
If anything needs to be rerun before nightly update we can run something manually if it is urgent or needed. We can continue optimizing after Hard Launch.
We also think that having two different servers preferably on AWS would be the best configuration and want to discuss this with the team today. It may be a little more expensive, but we would have one for data and background processes and one that runs the site.
Website Pricing:
There is a hierarchy to pricing: Contracts then the specific library and then the Calderon Default Pricing Library.
The script that updates the website pulls by Contracts first. If the item is in a contract multiple times, it looks for most recent effective date.
Then Libraries in sequence order and books within the library by sequence order. If the item is in a book multiple times, then looks for most recent effective date.