Since the Last Update

This month we we did a lot more work on API’s and infrastructure. We also delivered improvements in the POS, website, customer orders and deals.

Improvements

        • DB optimisations
          • Improved indexes on the product_categories table #172674280
        • Matrix products
          • Added a feature flag to hide matrix product functions as they are not needed by most stores and can cause issues. #173489679
        • Settings
          • Create a site settings page for Internal Services #173543200
        • APIs
          • Setup ProductSync Fetcher Service in Sale Order API #173522355
          • Create a delayed job for ProductSyncService and apply on Cart API #173676716
          • Create feature flag and site settings for ProductFetcherService #173522105
          • APIs/OpenID] Allow “Sign up” to return to the token flow when sign up is completed #172868770
          • Remove/hide User consenting/granting access #173209779
          • APIs] Transform API Client into ProductSyncService #173522248
          • Allow Cart API to receive and handle items barcodes instead of ids #173490356
          • Feature flag ProductEventsWatcher #173489912
          • Setup ProductSync Fetcher Service in Cart API #173522311
          • Allow Sale Order API to receive and handle items barcodes instead of ids #173490202
          • Add cart_item_link item presence and uniqueness validation and add related Cart API specs #173653126
          • Add billing_address_id and shipping_address_id to SaleOrder params on API #173653165
          • Add addresses validations to Sale Order APIs. #173739814
          • Make ProductUpserter update only blank product’s model attributes #173743022
          • Create a mini documentation for Product Sync and Product Events on Internal Services page #173188712
        • Speed
          • PO Cart (EDI) Rails4 PO Cart Checkout is slow compared to Rails3 when EDI is used – made it faster. #172521905
        • Customer Orders
          • Adjust picking list to display only items that can be picked #173506444
          • Create an action to change the state of order items back to remaining in order and remove the back ordered state. #173578070
        • time stamps
          • Removed the ability to disable “timestamps” #173528208
        • Infrastructure/Sys Admin
          • Completed the first step of a major data base upgrade. The database reads are now going to a google cloud DB service. We will keep an eye on this for a week and then switch writes over.
          • Fix migrations for an improved admin system that is being created. #173958287
          • Configure Rails 3 Production and Beta 3 to use Prod ProxySQL #173823476
          • Move /root/clean_up_cron_job.sql from frogger to config/clockwork.rb #173826015
          • Change MySQL Configuration on frogger #173785581
          • Update workers-watcher to watch sidekiq. This alerts when there are issues. #171482996
          • Automatic prod4 deployment #173676696
          • Create prod4 (workers) #173619903
          • Create first step of automatic prod4 deployment #173637091
          • Add option to the select box of Circle ENV for /sites #173634526
          • Second step of automatic prod4 deployment #173676696
          • Move code check to Circle CI #173697400
          • Configure Rails 3 and Rails 4 Alpha environments to use ProxySQL #173842989
          • Change migrations to be compatible with Rails 4 & 6 #173788482
        • SEO
          • Update Availability tag in metadata html to improve website search engine optimization. #170166833
        • Label printing
          • Fixed an issue in the label EPL code where labels with custom barcodes starting with ‘CIR’ at the start would not scan. #172970535
        • Deals
          • Add a 3rd ‘date loaded’ sort option and have this as the default sort with most recent at the top. #173807312
          • Add the ability to sort deals by name and expiry date. #173436974
        • File loads
          • Added a function that enables users cancel uploads #173050556
        • POS
          • Refactor TillController post_transaction removed old unused code to improve performance in r4.
          • Add a hotkey (F5) to force back office search to fix the situation where you can’t find a customer because someone with the same name is in the local POS cache. #163996060 (download from test builds to try this improvement) drive.google.com/drive/u/1/fold
        • Website Checkout
          • Create a new payment options checkout stage #172711132

New things currently being worked on

  • Database optimization
  • APIs
  • System and infrastructure upgrades
  • Website checkout improvements and order fulfillment improvements.