In order to update website products from Sage product must have their Publish to Web (PTW) checkbox ticked in the web tab of the Product Records as shown below.
To check the PTW status of Sage products we have created a Sage report (Stock Web Publish Status.report) that can be downloaded
here.
The report can be downloaded to any local folder, but if you want to regularly run it from Sage, we suggest be saved to your product reports e.g C:\ProgramData\Sage\Accounts\2023\Company.000\REPORTS\Products\My Products Reports
The C:\ProgramData\Sage\Accounts\2023\Company.000 portion of the file path will vary and can be found under Data Directory in Sage>Help>About.