X-Cart forums

[mrerotic]

I have a script built that will work perfectly, but im stuck on the product variants now. I don't know how I can do the following:

--------------------
Colors & sizes :
1) Red - Sizes available: S M L
2) Blue - Sizes: L XL
3) White - Sizes: S L

My script will import the colors, and the sizes with out an issue, but how do you add exclusions instantly since your importing one item at a time through a loop? Since items arent available in every size..

How can I give variant option exclusions on import?

ANY HELP WOULD BE GREAT

[cflsystems]

Well you can add options/variant to a product and exceptions and then export to see how the files are structured

[mrerotic]

yea i have already done this, doesnt help trust me.

[Victor D]

Why just not to look into modules/Product_Options/import_ex.php

$mrow = func_query("SELECT $sql_tbl[class_options].optionid, $sql_tbl[classes].class, $sql_tbl[class_options].option_name as 'option', $sql_tbl[product_options_ex].exceptionid FROM $sql_tbl[classes], $sql_tbl[products], $sql_tbl[class_options], $sql_tbl[product_options_ex] WHERE $sql_tbl[classes].classid = $sql_tbl[class_options].classid AND $sql_tbl[class_options].optionid = $sql_tbl[product_options_ex].optionid AND $sql_tbl[classes].productid = $sql_tbl[products].productid AND $sql_tbl[classes].productid = '$id'".(empty($provider_sql) ? "" : " AND $sql_tbl[products].provider = '$provider_sql'")." ORDER BY $sql_tbl[product_options_ex].exceptionid");

[mrerotic]

Victor - I'm sorry, but im still lost here. I found that line, but if im inserting one product at a time via a custom import script and each product had multiple colors and sizes, I have a loop created to insert each color and size while importing each product, but how can I loop yet again to give the exceptions?