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

    • 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 described in this article. To check the PTW status of Sage products we have created a Sage report ...

    • Creation of new website products from Sage

      Woosage has a feature that allows you to create new product in WooCommerce from Sage. However, as WooCommerce has comprehensive product presentation features that are not present on Sage, such as short & long descriptions, attributes and variations, ...

    • Bundled and Composite Products

      Overview Bundles Product are groups of products that can be purchased together, usually at a discounted rate.  Composite Products are similar, but present different components (product options) based on customer selections. When the customer adds ...

    • Creating a Sage Price List as a duplicate of Selling Prices

      Why might this be required? This may be a requirement in the following scenario. Your trade or wholesale prices are held in Sage in the Sage Selling Prices and you want to make these available to trade customers when they login to your website, via ...

    • Product Update Considerations for Variable Products with Woosage50

      Variable products can be seen as a hierarchy, with the Variable Product as the parent and the Product Variations as the children. Within WooCommerce each element (i.e. the parent variable product and each child variation) has a SKU and a number of ...