Mass Actions Add Product Variants

Hi,

You need three things to add variants to a product:
- add the variants entries in the hikashop_table. I can see this is done with your second INSERT query
- add entries in the hikashop_variant table linking the default values in hikahop_characteristic and the main product entry in hikashop_product. I can see this is done with your first INSERT query.
- add entries in the hikashop_variant table linking each variant in hikashop_product to their corresponding values in hikashop_characteristic. I don't see this query in your txt file.
So I suppose you're missing the third query and that's why it behaves incorrectly.

Note that the goal of variants is to allow the customer to select several values on the product page so that they can choose among several variants of the same product, and based on what is selected the price/stock/image/etc can be different.
That's what is shown here: demo.hikashop.com/index.php/en/hikashop/...with-characteristics
I can see that you only have one variant for each product which means the selection on the product page is meaningless.
In that case, I would recommend to use custom fields of the table "product" instead of characteristics, like we did with the "specifications" page here: demo.hikashop.com/index.php/en/hikashop/.../with-specifications
A custom field of the table "product" will add a corresponding column in the hikashop_product table.
You can use the type "single dropdown" so that in the custom field "values" section, you can enter the different values allowed.
And then in each product you can select the value you want in the custom field.
And you can link a filter to that custom field so that it will use the values of the custom field to filter the product.
Another nice thing if doing it like that is that you can easily set the value of the custom field for a bunch of products with a simple query:

UPDATE #__hikashop_product SET xxx = 'yyy' WHERE product_name LIKE "%i5%";

Hi,

1. I'm not sure what you're asking. If you have set the characteristics/variants with the same data as custom product fields, then switching the filters to use the custom fields instead of the characteristics is really easy. You just have to edit each filter and change the "apply on" to use custom fields instead of characteristics and select the corresponding custom field.

2. With a bit of customization you can allow the display of the add to cart button on the listing, even if the product has variants/options. However, this means that you'll add the main product to the cart when you click on the button.
You need to edit the add_to_cart_ajax.php view file via the menu Display>Views.
There, you have this line:

$has_options = !empty($this->row->has_options) || (!$display_fields && $has_required_fields);

$has_options = false;