Dear Zen Masters and Zen Padawans,
I was wondering if/how EasyPopulate could handle the data from Cross Sell... It would save a tremendous amount of time to so many of us if we could set the Cross Sell via Excel / EasyPopulate.
I figured how to add extra data in EasyPopulate, such as the Master Category ID...
I thought I had it for "xsell_id" and "sort_order", needed for the Cross Sell, but it ain't working...
I got about 0 php skills but here was my idea:
in admin/easypopulate.php i had:
Around line 384:
// langer - specials added below
$header_array = array(
'v_specials_price' => $iii++,
'v_specials_date_avail' => $iii++,
'v_specials_expires_date' => $iii++,
'v_products_price' => $iii++,
'v_products_price_w' => $iii++,
'v_products_weight' => $iii++,
'v_xsell_id' => $iii++,
'v_sort_order' => $iii++,
'v_master_categories_id' => $iii++,
'v_date_avail' => $iii++,
'v_date_added' => $iii++,
'v_products_quantity' => $iii++,
);
Around line 467:
$filelayout_sql = "SELECT
p.products_id as v_products_id,
p.products_model as v_products_model,
p.products_image as v_products_image,
p.products_price as v_products_price,
p.products_price_w as v_products_price_w,
p.products_weight as v_products_weight,
xsell.xsell_id as v_xsell_id,
xsell.sort_order as v_sort_order,
p.master_categories_id as v_master_categories_id,
p.products_date_available as v_date_avail,
p.products_date_added as v_date_added,
p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.manufacturers_id as v_manufacturers_id,
subc.categories_id as v_categories_id,
p.products_status as v_status
FROM
".TABLE_PRODUCTS." as p,
".TABLE_PRODUCTS_XSELL." as xsell,
WHERE
p.products_id = xsell.product_id
".TABLE_CATEGORIES." as subc,
".TABLE_PRODUCTS_TO_CATEGORIES." as ptoc
WHERE
p.products_id = ptoc.products_id AND
ptoc.categories_id = subc.categories_id
";
Around line 1335:
// langer - why not qry products table and use result array??
$default_these = array(
'v_products_image',
// redundant image mods removed
'v_categories_id',
'v_products_price',
'v_products_price_w',
'v_products_quantity',
'v_products_weight',
'v_xsell_id',
'v_sort_order',
'v_master_categories_id',
'v_date_added',
'v_date_avail',
'v_instock',
'v_tax_class_title',
'v_manufacturers_name',
'v_manufacturers_id',
'v_products_dim_type',
'v_products_length',
'v_products_width',
'v_products_height'
);
Around line 1488:
// now do a query to get the record's current contents
$sql = "SELECT
p.products_id as v_products_id,
p.products_model as v_products_model,
p.products_image as v_products_image,
p.products_price as v_products_price,
p.products_price_w as v_products_price_w,
p.products_weight as v_products_weight,
xsell.xsell_id as v_xsell_id,
xsell.sort_order as v_sort_order,
p.master_categories_id as v_master_categories_id,
p.products_date_added as v_date_added,
p.products_date_available as v_date_avail,
p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.manufacturers_id as v_manufacturers_id,
subc.categories_id as v_categories_id
FROM
".TABLE_PRODUCTS." as p,
".TABLE_CATEGORIES." as subc,
".TABLE_PRODUCTS_XSELL." as xsell,
WHERE
p.products_id = xsell.product_id
".TABLE_PRODUCTS_TO_CATEGORIES." as ptoc
WHERE
p.products_id = ptoc.products_id AND
p.products_model = '" . zen_db_input($items[$filelayout['v_products_model']]) . "' AND
ptoc.categories_id = subc.categories_id
";
Around line 1984:
$query .="'".zen_db_input($v_products_model)."',
'".zen_db_input($v_products_price)."',
'".zen_db_input($v_products_price_w)."',
'".zen_db_input($v_db_status)."',
CURRENT_TIMESTAMP,
$v_date_added,
$v_date_avail,
'".zen_db_input($v_tax_class_id)."',
'".zen_db_input($v_products_weight)."',
'".zen_db_input($v_xsell_id)."',
'".zen_db_input($v_sort_order)."',
'".zen_db_input($v_master_categories_id)."',
'".zen_db_input($v_products_quantity)."',
'$v_manufacturer_id')
";
and finally around line 2029:
$query .= '", products_weight="'.zen_db_input($v_products_weight) .
'", xsell_id="'.zen_db_input($v_xsell_id) .
'", sort_order="'.zen_db_input($v_sort_order) .
'", master_categories_id="'.zen_db_input($v_master_categories_id) .
'", products_tax_class_id="'.zen_db_input($v_tax_class_id) .
'", products_date_available= ' . $v_date_avail .
', products_date_added= ' . $v_date_added .
', products_last_modified=CURRENT_TIMESTAMP' .
', products_quantity="' . zen_db_input($v_products_quantity) .
'" ,manufacturers_id=' . $v_manufacturer_id .
' , products_status=' . zen_db_input($v_db_status) . '
WHERE
(products_id = "'. $v_products_id . '")';
Obviously I'm off somewhere... (probably way off...)
Please php Gurus, don't laugh :blush:
Any help would be greatly appreciated.
Damien
