Product does not get added to the system when doing a Product Refresh

Product does not get added to the system when doing a Product Refresh

Symptoms

After performing a Product Refresh in Product Manager to add a new product the product is not added. When looking in the Event Log the following error is listed:

The product 'xxx' from the product file 'yyy' could not be added. More information to follow.

Incorrect syntax near ','. (-2147217900)

Cause

This is caused by missing data in the product properties portion of the product database. This can occur when a product is upgraded from previous versions.

Resolution

To fix this problem the product properties must be re-saved.

  1. Run Product Designer.
  2. Click File, Open.
  3. Select the product that is not getting added to Product Manager and click Open.
  4. From the File menu, click Product Properties.
  5. Without making any changes, click OK.
  6. Close Product Designer.
  7. The product should now get added to the product list in Product Manager during the next Product Refresh.

Status

Solatech has confirmed this to be a problem with the software listed at the end of this article. As more information becomes available this article will be updated.

Applies To:

  • Solatech Window Covering Software 4.2

    • Related Articles

    • How the Fast Refresh option works

      Summary This article explains how the Fast Refresh option works when refreshing products in the Product Manager. More Information When the Solatech Window Covering Software accesses product files, for example when they are using in Order Entry, they ...

    • How to Check for Product Updates in SalesPro

      Summary This article will describe how to check for product updates from SalesPRO. Please note that this requires internet access. Instructions To check for product updates, navigate to the Maintenance tab. Click Product Updates. In the Product ...

    • How to Create a New Product

      Summary This article details how to create a new product database. Basic knowledge of database principles is required. The use of Product Designer is required. This article describes how to create a retail product. Creation of a fabricated product is ...

    • Unusual data is getting added to QuickBooks Desktop

      Overview When reviewing your QuickBooks Desktop (QBD) company you may see data such as accounts, items, vendors, etc. that you don't recognize. This article will explain where some of these items may come from if you're importing SalesPRO data into ...

    • Roaming synchronization issues when Product information, options or Styles have been modified on the main system

      Summary This article explains the conflicts when a product is modified and a roaming workstation sends Quotes or Orders to the main system with a non-updated product. If a product option is modified, (i.e. a color from a list is deleted) in a product ...