X-Cart forums - Importing product variants

X-Cart forums (https://forum.x-cart.com/index.php)

- Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)

- - Importing product variants - PHP please help (https://forum.x-cart.com/showthread.php?t=47492)

mrerotic

05-11-2009 04:18 PM

Importing product variants - PHP please help

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

05-11-2009 07:46 PM

Re: Importing product variants - PHP please help

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

mrerotic

05-12-2009 01:14 AM

Re: Importing product variants - PHP please help

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

Victor D

05-12-2009 04:19 AM

Re: Importing product variants - PHP please help

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

Code:

$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

05-12-2009 10:05 AM

Re: Importing product variants - PHP please help

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?

All times are GMT -8. The time now is 07:01 AM.