After update to J4, new products are not shown in product list in backend

[webgras]

We just did an upgrade to J4. The products are not shown in the frontend (not in Casseiopeia and not in Yootheme) I tried to add a new product (simple) in the backend. This is not recognised as product in my J2store product list. I cannot set a price because the variant ID is missing, but I don't have(need) variants.

[angieradtke]

Hi , the same issue here. @webgras we will get no answer here. It must be a database issue. #

[angieradtke]

Solved . Structure of j2store_variants is not updated to the new structure. Column shipping was missing and column params and sold whre old and needless

CREATE TABLE IF NOT EXISTS #__j2store_variants ( j2store_variant_id int(11) NOT NULL AUTO_INCREMENT, product_id int(11) DEFAULT NULL, is_master int(11) DEFAULT NULL, sku varchar(255) DEFAULT NULL, upc varchar(255) DEFAULT NULL, price decimal(15,5) DEFAULT NULL COMMENT 'Regular price of the product', pricing_calculator varchar(255) NOT NULL, shipping int(11) NOT NULL, length decimal(15,5) DEFAULT NULL, width decimal(15,5) DEFAULT NULL, height decimal(15,5) DEFAULT NULL, length_class_id int(11) DEFAULT NULL, weight decimal(15,5) DEFAULT NULL, weight_class_id int(11) DEFAULT NULL,
created_on varchar(255) DEFAULT NULL, created_by int(11) DEFAULT NULL, modified_on varchar(45) DEFAULT NULL, modified_by int(11) DEFAULT NULL, manage_stock int(11) DEFAULT NULL, quantity_restriction int(11) NOT NULL, min_out_qty decimal(15,5) DEFAULT NULL, use_store_config_min_out_qty int(11) DEFAULT NULL, min_sale_qty decimal(15,5) DEFAULT NULL, use_store_config_min_sale_qty int(11) DEFAULT NULL, max_sale_qty decimal(15,5) DEFAULT NULL, use_store_config_max_sale_qty int(11) DEFAULT NULL, notify_qty decimal(15,5) DEFAULT NULL, use_store_config_notify_qty int(11) DEFAULT NULL, availability int(11) DEFAULT NULL, allow_backorder int(11) NOT NULL,
isdefault_variant int(11) NOT NULL, PRIMARY KEY (j2store_variant_id), KEY variant_product_id (product_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[mgopin3]

I appreciate your understanding and patience. Typically, upon installing our J2Store application as mentioned earlier, the table structure remains intact. Upon completion, when accessing your dashboard, a script will be rendered which will subsequently add additional columns to several tables. As a result, upon reaching your dashboard, the "sold," "params," and "upc" columns will be seamlessly integrated into your variants table. This process effectively resolves the issue at hand. Thank you for your cooperation and understanding.

[mgopin3]

@mgopin3 We believe the reported issue has been addressed. Could you please confirm that the problem is resolved on your end? If everything looks good, we'll go ahead and close this issue.

If you have any further questions or if there's anything else you'd like assistance with, please don't hesitate to let us know. We appreciate your feedback!

[twdjo]

@mgopin3 Many thanks for the solution!