Please note the LCBO is making an enhancement to our SOD data to better serve your analysis by breaking out ecommerce data into its own channel for data tracking purposes. An additional column field will be inserted into options 1a,1b,2,3,4,5 for the new sales channel ECOMM_SQTY.
The ECOMM_SQTY field will provide the sales quantity breakout for each location in the options noted above, grouping together ship to store and pick up in store orders. Previously these sale types were grouped under RG_SQTY with all regular store sales. LCBO ship to home orders will continue to be reported on using LCBO store 974 (ecommerce store) for reference.
Updated record layouts can be found on our SOD Reference Material page. Please note this change will take effect for week 29 reporting onwards. You must update any scripts and record layouts to match the new layouts to ensure your data is properly aligned.
If you have any questions, please contact saleofdata@lcbo.com or visit https://sod.lcbo.com/
Thank you for your ongoing support.