Question: We need to be able to filter the products to display by stock category, not by type of product (as some Finished items will be sold online but some not). Some of the Finished items are "Special customer requests", so can't be sold or even advertised on the web.

Answer: The best is to use the sales categories in webERP to include specific products.  In the CARTwebERP set up parameters, indicate which sales categories to show on the cart. The categories are separated by a comma.  Upload pictures for the sales categories and assign stock to categories in webERP.   Make a tree with categories and subcategories and the cart will follow the tree narrowing the part selection.   This solution is best if you have a complicated catalog of products.

Another way is to indicate which stock categories to exclude from the cart. This is set in the CARTwebERP parameters.  You have to know the code of the Stock category/categories to exclude. That can be found in webERP setup programs for stock categories. The categories are separated by a comma.  This is best for simple catalogs with few items. When you use this method, the cart displays a drop down menu of Stock Categories that are sold to narrow stock selection.

Question:  Just downloaded your CARTwebERP, on my development environment WAMP I get:

Already created a menu entry as Cartcatalog. Trying to preview it, I get the error.  Any idea?

Answer: Google found a site that explains that MySQL does not like hyphens, and how to rename the database.  If you have only a few references to this database name elsewhere, you may want to consider changing the name to avoid future integration problems that may arise because of a hyphen.

webERP does not have an issue because it only opens the one database once and they use "`" to resolve the "-" problem.

I found references to the solution of placing ` before and after the database name in the code.  There are hundreds of places in the code where the database is referenced.   You might try placing the tick marks (`) in the database name field of the CARTwebERP parameters before and after the name.  That just might place those ticks where they need to be every time.