green
KPCKevin Powell - Community
•Created by green on 1/17/2024 in #back-end
product variants for webshop
Hello! I have been working on a webshop with php and mariadb(mysql). Im working on the product page but im having struggles with product variants.
With product variants i mean that one product could have different variants. for example: one hoodie can be in different colors and sizes. One phone can be in different colors, different ram and storage.
for the database tables, i have a table for just products that i use for the product list and the idea was to make separate tables for variants that's linked to the an product item.
my first idea for the variants was to make 2 tables. variantName and variantValue. they would look like this ish
variantName
-variantName_id (pk)
-product_id(fk)
-variantName_name
variantValue
-variantValue_id(pk)
-variantName_id(fk)
-variantValue_value
VariantName is linked to the product, variantValue is linked to the variantName.
if the product was a hoodie. in variantName i could add color and size and in the variantValue i could add green, blue red and S, M, L. i'd list the names in select tags and the values in option tags
The problem with this idea is that theres no way (so far i know) to link the 2 attributes together. i can select a color, but i cannot check what sizes are available for the selected color. That's where im stuck at right now. I was wondering if someone could give me any tips that could help me out
worth pointing out that the webshop isnt about anything specific so I need it to be a dynamic structure that could work for different attributes for different products.
My other idea was to limit the amount of attributes up to 3 or something, which could make it easier? but i wanted to ask here first, because i rather not set a limit
Thank you for your time :)
26 replies
KPCKevin Powell - Community
•Created by green on 10/2/2023 in #back-end
dynamic meta tags for ecommerce
Hello! im making a webshop with php and mysql(mariadb) for someone. the idea is that the client can add items to the webshop by himself. ofc i will have one product page where the data of one product can be loaded in.
the only thing is that im not sure how to deal with dynamic meta tags. does anyone know a good and/or a common practice to deal with that?
the only thing i can think of is that i either use the product information that is also shown on the product page, but then im missing tags for keywords and likely some other things or i have to make seperate inputs for meta tags when the client adds a new product, but that seems off to me since the client might not know anything about meta tags and seo. if someone has other and/or better ways, id love to know. thanks for reading :)
3 replies
KPCKevin Powell - Community
•Created by green on 8/15/2023 in #os-and-tools
"no bootable device" after creating disk image with clonezilla (debian 12)
Hello :), i made a debian 12 home webserver from my old laptop so i can use it as a work environment. everything worked as i wanted, so i decided to make an image of my system as a backup. i used clonezilla for the image but now my system doesnt want to boot. it says no bootable device. i noticed that my system drive is in the legacy tab and not the uefi tab. i tried debian 12 rescue mode but i dont really understand it. does anyone have some tips how i can fix this by chance?
4 replies