Skip to content

SmartGrocer 22.1 Release Notes

22.1.12-beta8

CS-22.1.12-beta.8.exe    HQ-22.1.12-beta.8.exe    SS-22.1.12-beta.8.exe

  • NEW
    • Price Batch: 'Distribute' Action
  • CHANGED
    • Price Batch: Add primary supplier id and name to items grid
    • Compare Prices: Add toggle to not hide items priced the same at all stores

22.1.12-beta7

CS-22.1.12-beta.7.exe    HQ-22.1.12-beta.7.exe    SS-22.1.12-beta.7.exe

  • FIXED
    • HostpProcFilter: Handle DELSCHED sections

22.1.12-beta6

CS-22.1.12-beta.6.exe    HQ-22.1.12-beta.6.exe    SS-22.1.12-beta.6.exe

  • CHANGED

    • Supplier: Add option to promote secondary supplier to primary when unlinking items.

  • NEW

    • ImportSwat: Lima SWAT SIL host interface
    • ReclaimFlag: Support Lima Warehouse

22.1.12-beta5

CS-22.1.12-beta.5.exe    HQ-22.1.12-beta.5.exe    SS-22.1.12-beta.5.exe

  • CHANGED
    • Hostproc: Support for burdened costs

22.1.12-beta4

CS-22.1.12-beta.4.exe    HQ-22.1.12-beta.4.exe    SS-22.1.12-beta.4.exe

  • NEW
    • Store Item Maint: Add new action "Assign Location"
  • FIXED
    • Price Batch: Fix crash when "Simplify Batch" if a upc is missing a normal price record
    • Price Batches: Fix not populating pricing when create labels from multiple batches
    • Mass Maint: Don't prompt for POS update after making changes at HQ
    • ReclaimFlag: Fix not updating all possible items
  • CHANGED
    • ExportRosie: Always export TaxF=0
    • DwLoad: Increase query timeouts to 1 hour (was timing out sometimes on slow servers)

22.1.12-beta3

CS-22.1.12-beta.3.exe    HQ-22.1.12-beta.3.exe    SS-22.1.12-beta.3.exe

  • NEW
    • ExportInstacart: Add config file option to enable/disable sale pricing

22.1.12-beta2

CS-22.1.12-beta.2.exe    HQ-22.1.12-beta.2.exe    SS-22.1.12-beta.2.exe

  • NEW
    • File Import
      • Add Department as mappable field
      • Add POS Description as mappable field
    • Price Batches, Price Batch
      • Add 'Simplify Price Changes'
    • Supplier
      • Add 'Unlink Items' button
  • CHANGED
    • Item Maint, Price Batch, Cost Batch, Allowance Batch
      • Paste from clipboard searches for upcs with and without check-digits
    • Mass Maint
      • Change default export format to XLSX
    • Ordering
      • Block ordering LTMO (long term manufacturer out) based on available date (To match Sharp2 behavior)
    • Price Batches
      • Allow HQ to recover deleted instore batches
    • Various Screens
      • Display Costs and Allowance amounts with minimal decimal places. (eg 1.00 instead of 1.0000, 1.234 instead of 1.2340)
  • FIXED
    • File Import
      • Support mapping colums greater than Z (eg AA, AB, etc)

22.1.10

CS-22.1.10.exe    HQ-22.1.10.exe    SS-22.1.10.exe

  • NEW
    • File Import
      • Add new mappable field 'Product Group'

22.1.9

CS-22.1.9.exe    HQ-22.1.9.exe    SS-22.1.9.exe

  • CHANGED
    • Item Maintance
    • Price Batch
    • Cost Batch
    • Allowance Batch
      • Upc check-digit detection disable when pasting upc's from clipboard
  • NEW
    • File Import
      • Add new setting 'Strip Check Digit', off by default

22.1.8

CS-22.1.8.exe    HQ-22.1.8.exe    SS-22.1.8.exe

  • FIXED
    • HQ Item Maintenance
      • Fix Open Clipboard to use upc check-digit detection and look in any field for upc's
    • Price Batch
      • Allow paste from clipboard if Excel data has multiple columns headers with same name
    • Product Groups
      • Assign Item to Group doesn't show empty groups with no items

22.1.7

CS-22.1.7.exe    HQ-22.1.7.exe    SS-22.1.7.exe

  • FIXED
    • File Import
      • Safely handle input files with duplicate upcs
        • Only first instance is imported
        • Other instances are reported out as warnings
    • UPC Check-Digit Detections
      • Skip check-digit detection for plu codes (5 digits or shorter)
  • CHANGED
    • ExportDoorDash
      • Small tweaks to be compatible with the DoorDash SFTP server configuration

22.1.6

CS-22.1.6.exe    HQ-22.1.6.exe    SS-22.1.6.exe

  • NEW
    • File Import
      • Add 'Scale Flag' mappable field
      • Add 'Deposit Code' mappable field
  • FIXED
    • File Import
      • Retain template upc display brand/descritption if input file has blank brand/description
      • Retain template upc size if importing Size+Uom and input file doens't have size
      • Uppercase uom codes when lower-case in input file
      • Reduce warning when mapped fields in input file are blank
    • HQ Item Movement
      • Fix NullReferenceException if using price batch dates for movement dates and price batch has no end date

22.1.5

CS-22.1.5.exe    HQ-22.1.5.exe    SS-22.1.5.exe

  • NEW
    • Purge
      • Add support for ProductAudit table
      • Add support for Audit table
  • CHANGED
    • Label Batches
      • Change default to *.CSV when importing from file
  • FIXED
    • File Import
      • Fix crash if input file has blank item description
      • Fix crash if input file has product size > 99999.99

22.1.4

CS-22.1.4.exe    HQ-22.1.4.exe    SS-22.1.4.exe

  • FIXED
    • Allowances
      • Fix error save net cost allowances > 99.99
      • Fix quick entry not always selecting price field contents when focused
    • Upc Checkdigit not detected if length < 12 in these screens:
      • Item Maint "Open Clipboard
      • Price Batch, Allow Batch, Cost Batch paste from clipboard
      • File Import
    • Security: File Imports->File Import not nested correctly

22.1.2

CS-22.1.2.exe    HQ-22.1.2.exe    SS-22.1.2.exe

  • NEW

    • ExportDoorDash

  • FIXED

    • ChangeStoreId: Fix crash renaming FPRICE batches because SqlConnection closed prematurely
    • DbSetup: Not creating daily_sales_fact_2021,2022 tables in fresh datawarehouse database

22.1.1

CS-22.1.1.exe    HQ-22.1.1.exe    SS-22.1.1.exe

  • CHANGED

    • DbUpdate: Include stored procedures for ExportShopHero so they don't have to be manually installed
    • ExportFreshop: Create export files even if FTP configurtion not set
    • ExportInstacart: Create export files even if FTP configurtion not set

  • FIXED

    • DSD Receiving: Fix database error saving return invoice for the first time with a receive-by-weight item
    • Item Import: Fix logging incorrect ending row if 'End Row' setting is configured
    • Supplier: Dont' all creating new cost/allow batches for an inactive vendor
    • Supplier Compare: Fix Upc hyperlink to work with single-click
    • HqExport: Fix HQ change triggers to send correct item changes to CS

22.1-beta12

CS-22.1.0-beta.12.exe    HQ-22.1.0-beta.12.exe    SS-22.1.0-beta.12.exe

  • NEW

    • Item Import
      • Display total of change+add counts
      • Display which fields will be changed on updated items
      • Enable saving edits to input document
      • Enable adding/removing rows/columns to input document
      • Enable filtering input document
      • Add 'End Row' import setting to allow importing a limited section of the input document
      • Simplify logging of new upc's created so that output can be used in Item Maintenance 'Open Clipboard' search
      • Fix template upc not expanded before using
      • Fix not validating that template upc actually exists
      • Fix jumping to wrong row when double-click row in result grid
      • Fix reading numeric input formatted as 'General' and displayed as scientific notation

  • CHANGED

    • Catgegory Picker: Make fonts bigger
    • ChangeStoreId: replace storeid in price batch descriptions

  • FIXED

    • Price Batch: Fix error when clear batch end date with 'Clear' button in date picker
    • Receiving Profitability Report: Fix gm% calculations

22.1-beta11

CS-22.1.0-beta.11.exe    HQ-22.1.0-beta.11.exe    SS-22.1.0-beta.11.exe

  • NEW

    • Settings: Add health check parameters

  • CHANGED

    • Supplier Edit: Add index to database to speed up populating list of allowance batches

  • FIXED

    • Supplier Edit: Fix chopped-off display of some fields when running in RDP session
    • HostprocFilter: Fix skipping last section in file

21.1-beta10

CS-21.1.0-beta.10.exe    HQ-21.1.0-beta.10.exe    SS-21.1.0-beta.10.exe

  • CHANGED

    • Settings: Don't display 'AM/PM' when editing timespan values
    • File Import: Make number of retail changes more prominent

  • FIXED

    • Allowance Batch: Fix not focusing correct grid column for allowance amount vs net cost
    • Fiscal Calendar
      • Fix incorrect warning for 13 period years where extra period in Q4
      • Accomodate 8th day in a week to change Fates #286 to start week on Monday's in 2022
    • Supplier Compare: Fix not always using yellow background color to indicate primary supplier values
    • AllowRecalc: Fix rare case where program sleeps forever and stops processing new tasks
    • ExportFreshop: Use same item selection logic in ad file as item file

21.1-beta9

CS-21.1.0-beta.9.exe    HQ-21.1.0-beta.9.exe    SS-21.1.0-beta.9.exe

  • NEW

    • Ordering: Recover deleted orders

  • CHANGED

    • Store Item Main: Add check-digit detection when searching based on clipboard data, no matter what column the UPC is in

  • FIXED

    • ExportInstacart: Don't round zero retails up to 0.05
    • File Import: Fix crash if importing a 'SizeUom' field with invalid input
    • Price Batch: Fix more places where blank/zero price mult could appear in grid
    • RTI Export: Fix always reporting "file in use" and never writing out LABEL000.TXT
    • Store Item Maint: Fix swapped Open Special for online shopping flag "Always" and "Yes If Mvmt"
    • Supplier Compare: Fix incorrect yellow highlight of primary supplier data

21.1-beta8

CS-21.1.0-beta.8.exe    HQ-21.1.0-beta.8.exe    SS-21.1.0-beta.8.exe

  • NEW

    • Import
      • New field mapping for "Multiple+Price" (requires separate "Multiple" and "Price" to be unmapped)
      • New column mappings for "Split Upc 1" and "Split Upc 2" (requires "Upc" to be unmapped)

  • CHANGED

    • Mass Maint: Offer to update POS after making changes
    • User Login Setup: Simplify pre-save validation logic and improve ease of use

21.1-beta7

CS-21.1.0-beta.7.exe    HQ-21.1.0-beta.7.exe    SS-21.1.0-beta.7.exe

  • NEW

    • Import
      • New field mapping for "Size+Uom" (requires separate Size and Uom fields to be unmapped)
      • New column mapping for "UnitCost" (requires "Case Pack" to be mapped, requires "Case Cost" to be unmapped)

  • FIXED

    • ExportInstacart: Fix Divide-by-zero error if item in a price batch has a multiple of "0"

  • CHANGED

    • HH Ordering: Default "Prompt on Reclaim Flag" to off

21.1-beta5

CS-21.1.0-beta.5.exe    HQ-21.1.0-beta.5.exe    SS-21.1.0-beta.5.exe

  • FIXED
    • ExportShopHero: Fix exporting files twice

21.1-beta4

CS-21.1.0-beta.4.exe    HQ-21.1.0-beta.4.exe    SS-21.1.0-beta.4.exe

  • NEW

    • HQ and Store Item Maint: Open Special by Online Shopping Flag

  • FIXED

    • CS/HQ: Make StoreImport/HqImport work with very large price batches (over 100k items)

21.1-beta3

CS-21.1.0-beta.3.exe    HQ-21.1.0-beta.3.exe    SS-21.1.0-beta.3.exe

  • FIXED
    • CS/HQ/SS: Fix unable to print from generic lookup window via 'Print' button

21.1-beta2

CS-21.1.0-beta.2.exe    HQ-21.1.0-beta.2.exe    SS-21.1.0-beta.2.exe

  • CHANGED
    • StoreImport: Include 19.1.x fix for StoreImport clearing user-generated label requests

21.1-beta1

CS-21.1.0-beta.1.exe    HQ-21.1.0-beta.1.exe    SS-21.1.0-beta.1.exe

  • NEW

    • Handheld: Allow scanning Code39, Code128 symbologies
    • Item Movement Report: Add Supplier Id and Name
    • Label Request: Improve auditing when user clears requests

  • FIXED

    • DbSetup: Make compatible with SQL 2008
    • Item Maintenance: Fix mouse pointer being incorrectly positioned in Supplier lookup when linking new supplier

20.1-beta9

CS-20.1.0-beta.9.exe    HQ-20.1.0-beta.9.exe    SS-20.1.0-beta.9.exe

  • NEW

    • Vendor Compare Report

  • FIXED

    • ExportInstacart
      • Was not respecting 'Always' flag to export item
    • ExportShopHero
      • Was not respecting 'Always' flag to export item

20.1-beta8

CS-20.1.0-beta.8.exe    HQ-20.1.0-beta.8.exe    SS-20.1.0-beta.8.exe

  • NEW

    • File Import Total Re-Write
    • Hourly Sales
    • User Preferences: Allow user to configure how grid exports open (Always,Never,Prompt)

  • CHANGED

    • Fiscal Calendar
      • Allow putting extra week in any quarter when using 13 periods
      • Show quarter/period start and end dates
    • Inventory Batch
      • Add PosValid column to grid
    • Item Maintenance
      • Change online shopping flag to Yes If Mvmt, No, Always
      • Change Y/N auto-filter sequence to Checked,Unchecked,Unfiltered
    • Mass Maint
      • Add label tab fields for filter/update
    • Ordering
      • Copy any order to a new order
    • Supplier
      • New suppliers default to Active=Yes
      • Remove Active/All filter, show inactive with red text
    • Connection Setup
      • Warn when saving connection if app db doesn't have StoreConfig table and if dw db doesn't have store_dim table
    • Grid Exports
      • Default export format to XLSX
      • Add CSV as export format

  • FIXED

    • Allowance Batch
      • Prevent error if user set allowance amount to "" and then save
    • Fiscal Calendar
      • Prevent creating a new year if it already exists
      • Prevent changing first day of year when creating an year except the first year

20.1-beta7

CS-20.1.0-beta.7.exe    HQ-20.1.0-beta.7.exe    SS-20.1.0-beta.7.exe

  • CHANGED
    • HQ Item Maint: Allow set primary supplier on an item that doesn't have one
    • Setup: Auto-configure Settings.Shared.StoreNumber upon very first login to new database
  • FIXED
    • Item Maint: Ensure there is a primary supplier when creating new item and the model upc has a non-dsd supplier set as primary
    • Login: Fix crash at startup if userstate.json is zero bytes or corrupt
    • Security: Don't crash if try to add user that already exists
    • Hostproc: Respect setting HostFeed_StoreOwned when create FPRICE batch
    • HostprocFilter: Add support for REMOVEMDSECL section as unfiltered

20.1-beta6

CS-20.1.0-beta.6.exe    HQ-20.1.0-beta.6.exe    SS-20.1.0-beta.6.exe

  • NEW
    • SgCli health check command
  • CHANGED
    • RTI Export: don't log errors if RTI batch file not found, just show a warning message
    • ExportInstacart: Export multiple stores in same file
    • ExportPivotal: Upload status file if all stores tlogs not processed for current day
  • FIXED
    • HQ Item Maint
      • Prevent error if focus to search result item that was deleted by a different user
      • Trim display description to 50-chars when copying from main item description during save
    • Order: detect if order deleted by other user before refreshing data
    • Price Batch:
      • Save 1 instead of 0 for price mult if grid field cleared and then save
      • Save 1 instead of 0 when pasting clipboard data
    • Receiving: Don't crash when re-printing DSD invoice after one of its items has been unlinked from supplier
    • Sales Reports: Prevent error if attempt to scroll past the last possible week
    • HqExport: Stop sending unnecessary price batch deletes more than once
    • Inventory Batch: Fix InvalidCastException if clear retail/cost and then save
    • SgClean: Only purge HQ batches at HQ and CS batches at CS
    • Label Batches:
      • Limit input field lengths of fields that can be saved back to 'Labels' tab in item maintenance
      • Gracefully handle invalid upc code when importing from file
      • Remove .CSV import option in file picker
    • Label & Sign Printing:
      • Add DevExpress.XtraRichEdit dll to installer so scripts can be edited
      • Eliminate need to write script to make 12-digit upc code scan correctly

20.1-beta4

CS-20.1.0-beta.4.exe    HQ-20.1.0-beta.4.exe    SS-20.1.0-beta.4.exe

  • FIXED
    • Price Batch: Fix ArgumentOutOfRangeException if re-load price batch clipboard data with smaller # of columns after selecting upc/sku key
    • HqImport: HqImport won't import DSD invoices with large values
    • StoreImport :creating empty pos update batches for price batch changes without any item deletes from batch

20.1-beta3

CS-20.1.0-beta.3.exe    HQ-20.1.0-beta.3.exe    SS-20.1.0-beta.3.exe

  • NEW
    • Indicate temp unvail in HH ordering
    • User activity auditing (login, logout, failed login, lock/unlock/quit, module opened)
  • CHANGED
    • Increase all StoreTlogProc query timeouts to 5-min to prevent errors while nightly backups running
  • FIXED
    • Fix crash in SS/CS item maintenance when clear audit start/end dates then refresh audit data

20.1-beta2

CS-20.1.0-beta.2.exe    HQ-20.1.0-beta.2.exe    SS-20.1.0-beta.2.exe

  • FIXED
    • Disable paste into allowance/cost batch as CS
    • Fix a few more places product size is displayed to use new format

20.1-beta1

CS-20.1.0-beta.1.exe    HQ-20.1.0-beta.1.exe    SS-20.1.0-beta.1.exe

  • NEW
    • Net Cost Allowances
    • Paste into allowance batch from clipboard
    • Paste into cost batch from clipboard
    • HH Ordering Allow temporary disable prompt to make items PosValid
    • HH and Desktop Ordering display availability dates for temp unavail items
    • Allow ‘Add by search’ in ordering, works with supplier ‘Can Order From’
    • New Item List ‘PosValid Enabled from Ordering’
    • Instacart Export
  • CHANGED
    • Main Menu Tab
      • Visual indicator when fiscal calendar runs out in < 31 days
      • Alert when fiscal calendar runs out in < 7 days
    • Global
      • Standardize product size formatting to show minimum digits required (1 EA, 0.5 LT, 1.2 OZ, etc)
    • Allowance Batch
      • Make quick entry a draggable form instead of a fixed pop-up panel
      • Focus to allowance amount if try to add item that already exists in batch
    • Cost Batch
      • Add ‘CPI’ column to cost batch detail grid
      • Focus to cost if try to add item that already exists in batch
    • DSD Invoice
      • Add net cost to printed invoice
    • Item Maintenance
      • Open clipboard works if upcs on clipboard contain check digits
    • Label/Sign Batches
      • Substitute normal brand/description if display brand/description is empty.
    • Price Batch
      • Write to price batch audit when export RCP
      • Allow RCP Export from CS if enabled via setting
      • Prevent undelete HQ owned price batch at CS
      • Paste into price batch works if upcs on clipboard contain check digits
    • Product Audit Report
      • Allow brand/descr/size/uom columns to be added to product audit report
    • Shelf Label & Sign Batches
      • If display brand/description are not set, just use item’s regular brand & description
    • Settings
      • Remove unused settings for connection and query timeouts
    • Suppliers
      • Make ‘Items’ first tab in suppliers screen, don’t show store drop-down as CS,SS
  • FIXED
    • Fix infrequent ‘Cannot insert the value NULL...’ error when generating label batch
    • Fix infrequent error if try to add upc to label batch but the upc was deleted by another user
    • Fix error if start then cancel add item to invoice batch
    • Fix infrequent NullReferenceException in SS/CS item maint