X-Cart forums

[Asiaplay]

Hi Again,

Languages for variants are kept in / use the xcart_product_options_lng SQL table.
Basically there is always a language indicator in a table where languages appear e.g. US, GB, DE, FR etc. (this is how the code knows which variable to pull out of the table).

Basically general product descriptions etc. are able to be imported ok and are kept in the xcart_products_lng SQL table... so this is a direct match for importing (not big issue).

For Variants e.g. colour, size etc. there is a huge issue...
Basic problem is that variants are based on the variant ID and Option ID links - namely xcart_variant_items table defines these links (uses 4 SQL tables Option ID, Variant ID, Variant ID links and language version of these links).
Therefore you have to know the Variant ID code & Option ID code for each product variant and match this to the language alternative text for each variant (which is kept in xcart_product_options_lng table.).
This is difficult to do as one change in a choice of the number of variants or options for a product and the Variant ID &/ or Option ID and these codes change their ID number (basically delete say white as a colour option and the Variant IDs are all renumbered automatically).

Basically the result is a nightmare for running variants in Multiple languages.
I could however see how your 1 to 1 relationship would make this much, much easier to run and import the information for.
I think you should also be able to have it such that Option1 becomes one table (option language text another) and Option1 sub-table gives the variant items for that option (and option subtable language text is in another table)
Then you link the option tables similar to how you have done.

What we have done in the past is bypass X-Cart variants and coded for set options (which in turn take their values from language tags we have added e.g. all lbl_z_option1_ items link back into the option1 table... so updating a language tag version of option language variant basically gives a global change... the option is then linked to that option table.

Cheers, Asiaplay

PM me if you want to chat more on yahoo or skype on this.

[Sativo]

Sure, hit me up anytime. My yahoo ID is displayed in my profile -- I'm usually online.

[toltion]

Hi Sativo,

Have you finished this mod? I am very interested in having variants as individual products.

[intel352]

Originally Posted by toltion

I am very interested in having variants as individual products.

Are you looking for variants listed alongside products individually, or something similar to the Variant Chart?

If you're looking for variants listed alongside products, I believe there is a completed custom mod released for free, it was code created by Qualiteam for an X-Cart client that released the code publicly.

I can't find the thread right now, but hopefully someone else will remember and post it. I'll keep searching for it if that's what you're needing.

[toltion]

I'm looking for variants listed alongside products individually. Basically, every product in the store is an individual product, but product "families" can be grouped together on one product page.

I'll look around for that mod too, thanks!

[Sativo]

Yes, it's finished, but I can't offer you any support for it.