Hello,
I have a similar situation in my shop: one product with two variants.
The customer is supposed to pay a different price and get a different file accordingly.
How do I configure this?
This is what I tried:
1- Create a product
2- In the product form, I clicked on "Manage Variants". I then got the message: "Before configuring the variant of your product, you need to first create one or several characteristics with the menu Products->Characteristics, and then add one or several characteristics to your product"
3- Ok, that means "Characteristics" = "Variants of the file". I go to Products - > Characterics and create those two
4- Go back again to the product form and now I'm able to cick again in the "Manage Variants" button.
5- It doesn't make much sense, but now I created two variants with the same names as the Characteristics and give each a price and upload a different file.
6- Save and go back to the product page on the frontend and see the message: "THE DEFAULT VALUE OF ONE OF THE CHARACTERISTICS OF THAT PRODUCT ISN'T AVAILABLE AS A VARIANT. PLEASE CHECK THE CHARACTERISTICS AND VARIANTS OF THAT PRODUCT"
And now I'm lost.
In the backend again, I clicked "Manage Variants" and get the message:
An error has occurred.
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE p.product_id IN (2,3)' at line 1 SQL=INSERT IGNORE INTO j30_hikashop_product (product_code, product_parent_id, product_created, product_modified, product_hit, product_last_seen_date, product_name, product_description, product_quantity, product_published, product_sale_start, product_sale_end, product_delay_id, product_tax_id, product_type, product_vendor_id, product_manufacturer_id, product_url, product_weight, product_keywords, product_weight_unit, product_meta_description, product_dimension_unit, product_width, product_length, product_height, product_max_per_order, product_access, product_group_after_purchase, product_min_per_order, product_contact, product_display_quantity_field, product_sales, product_waitlist, product_layout, product_average_score, product_total_vote, product_page_title, product_alias, product_price_percentage, product_msrp, product_canonical, product_warehouse_id, product_quantity_layout) SELECT p.product_code, '_' AS c_product_code, p.product_id, 1432923374, 1432923374, 0, 0, product_name, product_description, product_quantity, product_published, product_sale_start, product_sale_end, product_delay_id, product_tax_id, product_type, product_vendor_id, product_manufacturer_id, product_url, product_weight, product_keywords, product_weight_unit, product_meta_description, product_dimension_unit, product_width, product_length, product_height, product_max_per_order, product_access, product_group_after_purchase, product_min_per_order, product_contact, product_display_quantity_field, product_sales, product_waitlist, product_layout, product_average_score, product_total_vote, product_page_title, product_alias, product_price_percentage, product_msrp, product_canonical, product_warehouse_id, product_quantity_layout FROM j30_hikashop_product AS p, WHERE p.product_id IN (2,3)
Appreciate any help. Thank You!