Characteristics, Variants, and Product ID's

  • Posts: 14
  • Thank you received: 0
12 years 11 months ago #33978

Hi.
I had to cheat and put my characteristics and variables directly into the database.
(I'm moving an existing site over and that's just a bunch of products.)
So I built up the hikashop_characteristics and hikashop_variables tables after seeing what hand inputting the variants in. I also made new product ids for each characteristic id.

Now, I get no descriptions on my product pages until I go in and save each characteristic in the product portion of hikashop.
It also seems to only hold the last entered (highest id). It even removes the new products.

When I input them in manage variants, its looks exactly the same in the data base. and then my product descriptions reappear.

Any idea's what I'm doing wrong?
Its way to many to input each part of the pull down menu 1 at a time.

Please Log in or Create an account to join the conversation.

  • Posts: 82909
  • Thank you received: 13379
  • MODERATOR
12 years 11 months ago #34024

Hi,

If you have to save each variant so that it works properly it's because some of your data is not correct.

Make sure that in your product table you have one entry for the product and one for each variant of the product (combination of characteristics values). Then, make sure that for each one of these entries (even for the product itself) of the product table, that you have an entry for each characteristic of the product in the variant table and that it links to a value of a characteristic. Also, the main product entry will have an additional entry in the variant table linking it to each characteristic.

Please Log in or Create an account to join the conversation.

Time to create page: 0.058 seconds
Powered by Kunena Forum