This website requires JavaScript.
d90e9b51dc
Add combined scripts
Matt
2025-02-11 15:02:58 -05:00
98e2e4073a
Exclude calculate history table from resets
Matt
2025-02-11 14:31:01 -05:00
23c2085f1c
Remove duplicate table creates
Matt
2025-02-11 14:12:12 -05:00
2a6a0d0a87
Fixed calculations for frontend (likely still wrong but they display) + related regressions to calculate script
Matt
2025-02-05 00:02:06 -05:00
ebffb8f912
Enhance calculate scripts to deal with times and counts + fix regressions
Matt
2025-02-03 22:21:39 -05:00
5676e9094d
Add calculate time tracking
Matt
2025-02-02 21:22:46 -05:00
b926aba9ff
Add calculate history tracking
Matt
2025-02-02 20:41:23 -05:00
e62c6ac8ee
Fix issues with change tracking
Matt
2025-02-02 20:24:23 -05:00
18f4970059
Set up change tracking in core tables
Matt
2025-02-02 19:12:39 -05:00
12cab7473a
Fix calculate script regressions
Matt
2025-02-02 09:27:06 -05:00
06b0f1251e
Fix import script regressions
Matt
2025-02-02 01:40:05 -05:00
8a43da502a
Fix (probably) discrepancies and errors in import/calculate scripts
Matt
2025-02-02 00:01:46 -05:00
bd5bcdd548
Fix calculate errors
Matt
2025-02-01 23:38:13 -05:00
0a51328da2
Add a bunch of untested calculations enhancements based on import script changes
Matt
2025-02-01 14:46:17 -05:00
b2d7744cc5
Merge branch 'Improve-data-import'
Matt
2025-02-01 14:09:34 -05:00
8124fc9add
Update gitignore
Matt
2025-02-01 14:09:25 -05:00
9e1989ac66
Cleanup
Matt
2025-02-01 14:08:27 -05:00
5bfd6f6d04
Fix import script order count issues
Matt
2025-02-01 12:54:33 -05:00
1003ff3cf2
More incremental import fixes
Matt
2025-02-01 11:42:51 -05:00
2d0089dc52
Incremental import order fixes
Matt
2025-02-01 11:03:42 -05:00
50b86d6d8a
Fix/add data to PO script
Matt
2025-02-01 10:51:47 -05:00
07f14c0017
Fix/add data to orders script and fix other import errors
Matt
2025-02-01 01:06:45 -05:00
e77b488cd4
Fix/add data to products script
Matt
2025-01-31 18:44:11 -05:00
d57239c40c
Finish up import script incremental and reliability updates
Matt
2025-01-31 16:01:21 -05:00
1c932e0df5
More import script updates and fixes, better import_history tracking
Matt
2025-01-31 13:12:43 -05:00
a867117c3c
Import script incremental fixes
Matt
2025-01-31 11:12:38 -05:00
996d3d36af
Streamline incremental imports
Matt
2025-01-31 10:01:50 -05:00
d0abe9d9a2
- Modify import scripts to handle edge cases with empty arrays and null conditions - Improve parameter handling in incremental update queries for purchase orders and products
Matt
2025-01-31 01:50:21 -05:00
5e4d1c3bd8
Improve import scripts with enhanced incremental update tracking and performance
Matt
2025-01-31 01:39:48 -05:00
1be97d6610
Enhance purchase order import with advanced receiving tracking and fulfillment logic
Matt
2025-01-31 01:25:48 -05:00
b506f89dd7
Optimize order and product import scripts with improved performance and incremental update handling
Matt
2025-01-30 21:13:53 -05:00
c433f1aae8
Enhance import scripts with incremental update support and improved error handling
Matt
2025-01-30 15:49:47 -05:00
31d4011902
Add back product-category import and product time estimates
Matt
2025-01-30 00:00:30 -05:00
6c5f119ee5
Import fixes/optimizations
Matt
2025-01-29 21:48:56 -05:00
3c5fb9e435
Optimize product import with dynamic batching and memory management
Matt
2025-01-29 19:14:58 -05:00
2b329a55a4
Increase product import batch size
Matt
2025-01-29 18:51:55 -05:00
0d377466aa
Optimize database import queries with improved index selection
Matt
2025-01-29 18:42:29 -05:00
fb5bf4a144
Optimize order import with improved tax info retrieval and performance
Matt
2025-01-29 18:21:31 -05:00
4d8a677c5b
Remove import history tracking from purchase orders import script
Matt
2025-01-29 16:33:37 -05:00
655c071960
Limit order and purchase order imports to last 5 years
Matt
2025-01-29 16:25:24 -05:00
d2a2dbc812
Add incremental import support and tracking for database synchronization
Matt
2025-01-29 16:22:00 -05:00
d60b2d4fae
Refactor import scripts with improved progress tracking and time formatting
Matt
2025-01-29 13:47:33 -05:00
81a724db9d
Fix elapsed time calculation in import scripts
Matt
2025-01-29 13:40:01 -05:00
84baa7e7d3
Break up prod import script into pieces and move csv scripts into folder
Matt
2025-01-29 13:23:32 -05:00
814d5d1a84
Break up prod import script into pieces and move csv scripts into folder
Matt
2025-01-29 00:18:04 -05:00
b578549763
Remove CSV scripts from frontend
Matt
2025-01-29 00:04:47 -05:00
d56f1e1437
Move sales seasonality table to config schema and finish up standardizing scripts
Matt
2025-01-28 23:57:09 -05:00
ebebd37f11
Improve metrics reset script with robust table management and error handling
Matt
2025-01-28 22:12:24 -05:00
9c34e24909
Enhance metrics calculation scripts with improved progress tracking and cancellation support
Matt
2025-01-28 20:54:05 -05:00
a1e3803ca3
Clean up linter errors
Matt
2025-01-28 20:32:08 -05:00
a661b6a11e
Misc frontend fixes
Matt
2025-01-28 20:30:26 -05:00
1410dc5571
Frontend fixes - categories, deal with new hierarchy, misc fixes
Matt
2025-01-28 17:02:11 -05:00
b1f252bea8
Frontend fixes - dashboard, products, forecasting
Matt
2025-01-28 14:26:44 -05:00
7e341a152c
Update frontend to match part 4 - dashboard
Matt
2025-01-28 13:57:44 -05:00
25a0bc8d4c
Update frontend to match part 3
Matt
2025-01-28 13:40:28 -05:00
57b0e9a120
Update frontend to match part 2
Matt
2025-01-28 01:43:45 -05:00
64d9ab2f83
Update frontend to match part 1
Matt
2025-01-28 01:30:48 -05:00
8323ae7703
Optimize and fix calculate scripts
Matt
2025-01-27 13:16:21 -05:00
5781b45f37
Update calculate script to account for import changes
Matt
2025-01-27 10:41:18 -05:00
44d9ae2aad
Fix imports on calculate scripts
Matt
2025-01-26 23:42:38 -05:00
ff1de4a37d
Track import time
Matt
2025-01-26 23:39:01 -05:00
7c7c27a71c
Sync up POs with receivings, fix and optimize PO import, show total time
Matt
2025-01-26 22:31:32 -05:00
5cbc2152a1
Finish getting POs working
Matt
2025-01-26 17:34:46 -05:00
48f09095c4
Get orders working correctly
Matt
2025-01-26 16:52:53 -05:00
cdce12e9fb
Get orders import started, get all needed products imported
Matt
2025-01-25 21:43:31 -05:00
b1a5671531
Get product_categories inserting and product import fully running
Matt
2025-01-25 17:32:09 -05:00
2d52d7a63e
Get product import started
Matt
2025-01-25 15:44:52 -05:00
c1cf78973d
Product import fixes, more category import fixes
Matt
2025-01-25 15:24:51 -05:00
1694562947
Fix category import
Matt
2025-01-25 14:11:38 -05:00
e1174b8e63
Add route and frontend button to run import from prod script
Matt
2025-01-25 10:01:39 -05:00
353ae4540e
Update schemas with new fields, create initial import from prod script
Matt
2025-01-25 09:45:50 -05:00
31e1568868
Set up test prod db connection
Matt
2025-01-23 11:15:15 -05:00
85d7df45c5
Add acot schema
Matt
2025-01-22 13:15:12 -05:00
d6e2523adc
Remove unused files
Matt
2025-01-21 22:15:27 -05:00
9c1bcba1a3
Flatten calculate file structure a bit
Matt
2025-01-21 22:07:46 -05:00
fa8e2fa33b
Split up calculate script into useable pieces
Matt
2025-01-21 20:00:43 -05:00
94ac097f42
Merge branch 'Redo-dashboard'
Matt
2025-01-18 10:37:12 -05:00
a642790028
Rename sales component
Matt
2025-01-18 10:36:12 -05:00
b5a354a1de
Fix and restyle salesmetrics component
Matt
2025-01-18 01:12:44 -05:00
9003300d0d
Fix and update bestsellers component
Matt
2025-01-18 01:01:37 -05:00
1b4447f886
Fix and restyle overstockmetrics and topoverstockedproducts, link products to backend
Matt
2025-01-18 00:43:57 -05:00
9759bac94f
Fix and restyle forecast component
Matt
2025-01-17 23:44:13 -05:00
5987b7173d
Update topreplenishproducts component
Matt
2025-01-17 21:46:46 -05:00
d85d387c1a
Fix and restyle replenishmentmetrics component
Matt
2025-01-17 21:41:43 -05:00
b6e95aada9
More tweaks to stock and purchases components
Matt
2025-01-17 21:30:30 -05:00
f38174ca2a
Fix and restyle stock and purchases components
Matt
2025-01-17 21:10:35 -05:00
de5bd785c1
Switch to daterangepicker for forecast and sales
Matt
2025-01-17 20:35:53 -05:00
0727529edf
Move pie chart labels to middle
Matt
2025-01-17 20:06:09 -05:00
7a3a6fdb52
Rearrange component contents to match IP
Matt
2025-01-17 20:01:47 -05:00
c412822881
Rearrange dashboard to match IP
Matt
2025-01-17 18:56:17 -05:00
6b7a62ffaf
Fix some backend issues, get dashboard loading without crashing
Matt
2025-01-17 17:09:26 -05:00
118344b730
Add backend routes
Matt
2025-01-17 16:07:31 -05:00
48c7ab9134
Add new frontend dashboard components and update scripts/schema
Matt
2025-01-17 15:21:19 -05:00
609490895b
Fix build errors
Matt
2025-01-17 14:25:13 -05:00
494518152b
Fix build errors
Matt
2025-01-17 13:27:09 -05:00
61abe32c0c
Rearrange sidebar
Matt
2025-01-17 01:02:10 -05:00
88d1189da0
Change filter sort to client side for vendors/cats
Matt
2025-01-17 00:59:11 -05:00
2235121761
Rearrange vendors and purchase orders page content, fix pagination
Matt
2025-01-17 00:53:58 -05:00
0ba7d9f533
Align badges and fix search
Matt
2025-01-17 00:12:34 -05:00
3f966ceac3
Fix vendor and category page loading issues
Matt
2025-01-16 19:53:47 -05:00
Matt