Details
-
Type:
Improvement
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 4.11.0-b1
-
Component/s: None
-
Labels:None
-
Epic Link:
Description
Update install/upgrade to add new table order_affiliate_daily_statistics with the following columns:
- affiliate_id INT(10) UNSIGNED NOT NULL
- visits INT(10) UNSIGNED NOT NULL
- sales INT(10) UNSIGNED NOT NULL
- date DATE NOT NULL
Remove columns in the order_affiliates table for visits and sales
Update locations that track visits and sales to use the new table, inserting a record for the current date (in the company's timezone) if it doesn't exist or updating it if it does
