Knowledgebase

Question

When I go to create a new product, there should be three options for Product Type:

- Single price
- Multiple product 'versions
- Assign to option groups

...but my store is missing one or more of these. Why is this and how can I fix it?

Answer

We have seen this happen to several stores. It appears to be that somehow certain versions end up tagged as belonging to a product with ID of zero (i.e. a product that does not exist).

To clear the issue, go to the 'execute query' page in the back end and run this code to check for such versions:

SELECT * FROM tblCactuShop1Versions WHERE V_ProductID = 0

To delete these versions and clear the problem (in MS Access), you can run this code:

DELETE * FROM tblCactuShop1Versions WHERE V_ProductID = 0

(note that in MS SQL and MySQL you will need to alter the above query to use DELETE FROM instead of DELETE * FROM).

Can't find the answer you need? Click here to open a support ticket.