Exporting a List of Products from Sage with Publish To Web (PTW) Status

Exporting a List of Products from Sage with Publish To Web (PTW) Status

The Publish to Web (PTW) checkbox is used by Woosage to identify Sage products that are on the website and we provide a report that can be used to check the status of products' PTW as described in this article and make a note of the file path to your reports folder location.

Once downloaded to your Sage REPORTS folder, the same report can be used to export the list as follows.
  1. In Sage, go to Products and Services and ensure no products are selected.
  2. Select the Report Icon in the ribbon at the top and locate Stock Web Publish Status.Report in the file path noted above.
  3. Use the icons on the right to select Data To Excel
  4. Ensure all stock codes and categories are selected and only active products are selected (Woosage ignores inactive products)
  5. Enter 0 for all records
  6. Click OK

An Excel workbook will open with the data from Sage, which can be saved and used to amend the PTW settings for re-import as described in this article.




    • Related Articles

    • Installation and Setup of Woosage for Sage Accounting

      Woosage for Sage Accounting is intended to be a self-install application and everything you need to do this is contained is right here in just 4 easy steps. Install the Woosage plugin Add your subscription Identifier Authorise Woosage to access your ...

    • Checking the Publish To Web status of Products in Sage

      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 ...

    • What is Woosage for Sage Accounting?

      Woosage is a plugin for your website that will integrate your WooCommerce shop with Sage Accounting (also known as Sage Business Cloud Accounting - formerly Sage One). Woosage Essentials Edition is available and has the following features: Imports ...

    • Create an optional Sage Accounting user for Woosage

      While this step is optional, we we recommend that you add a Woosage user to allow us to access Sage Accounting on your behalf when installing WoosageBCA or providing ongoing support. If you do not add an additional user for Woosage, then we will not ...

    • Creating Variable Website Products from Sage

      WooCommerce has a variable product concept that allows similar products (e.g. different sizes or colour) to be grouped under a single product. Each product within the group is referred to as a variation and each has attributes that are used to ...