Find content
Male
@bigbird_3156
try using this version of easy populate http://addons.oscommerce.com/info/7725 which works with osc2 3.3, and the larger image option, that comes with osc 2.3.1 onwords
Latest News: (loading..)
Posts I've Made
In Topic: Easy Populate & Products Attributes
26 April 2013 - 04:30 PM
partrade12, on 26 April 2013 - 04:21 PM, said:
Its the 2.8
did a quick test and this worked for me (i have not got SPPC installed on mine)
replace the code below (from line 3443 in easy_populate.php)
// and insert the new record
if ($v_customer_price_1 != ''){
$result = tep_db_query('
INSERT INTO
'.TABLE_PRODUCTS_GROUPS.'
VALUES
(
' . $v_customer_group_id_1 . ',
' . $v_customer_price_1 . ',
' . $v_products_id . '
)'
);
}
if ($v_customer_price_2 != ''){
$result = tep_db_query('
INSERT INTO
'.TABLE_PRODUCTS_GROUPS.'
VALUES
(
' . $v_customer_group_id_2 . ',
' . $v_customer_price_2 . ',
' . $v_products_id . '
)'
);
}
if ($v_customer_price_3 != ''){
$result = tep_db_query('
INSERT INTO
'.TABLE_PRODUCTS_GROUPS.'
VALUES
(
' . $v_customer_group_id_3 . ',
' . $v_customer_price_3 . ',
' . $v_products_id . '
)'
);
}
if ($v_customer_price_4 != ''){
$result = tep_db_query('
INSERT INTO
'.TABLE_PRODUCTS_GROUPS.'
VALUES
(
' . $v_customer_group_id_4 . ',
' . $v_customer_price_4 . ',
' . $v_products_id . '
)'
);
}
with
// and insert the new record
if ($v_customer_price_1 != ''){
$result = tep_db_query(" INSERT INTO " .TABLE_PRODUCTS_GROUPS . " (customers_group_id, customers_group_price, products_id)
VALUES
('"
. $v_customer_group_id_1 . "', '"
. $v_customer_price_1 . "', '"
. $v_products_id
. "')");
}
if ($v_customer_price_2 != ''){
$result = tep_db_query(" INSERT INTO " .TABLE_PRODUCTS_GROUPS . " (customers_group_id, customers_group_price, products_id)
VALUES
('"
. $v_customer_group_id_2 . "', '"
. $v_customer_price_2 . "', '"
. $v_products_id
. "')");
}
if ($v_customer_price_3 != ''){
$result = tep_db_query(" INSERT INTO " .TABLE_PRODUCTS_GROUPS . " (customers_group_id, customers_group_price, products_id)
VALUES
('"
. $v_customer_group_id_3 . "', '"
. $v_customer_price_3 . "', '"
. $v_products_id
. "')");
}
if ($v_customer_price_4 != ''){
$result = tep_db_query(" INSERT INTO " .TABLE_PRODUCTS_GROUPS . " (customers_group_id, customers_group_price, products_id)
VALUES
('"
. $v_customer_group_id_4 . "', '"
. $v_customer_price_4 . "', '"
. $v_products_id
. "')");
}
In Topic: Easy Populate & Products Attributes
26 April 2013 - 03:58 PM
partrade12, on 26 April 2013 - 03:15 PM, said:
I have looked everywhere for this answer but can not find anything, anything will be greatly appreciated. Or point me to a link that will help...
When I load my file to EP i get this error...
1136 - Column count doesn't match value count at row 1
INSERT INTO products_groups VALUES ( 1, 3.45, 217 )
[TEP STOP]
(w00t)Im not sure what im missing Please Help!!!!
When I load my file to EP i get this error...
1136 - Column count doesn't match value count at row 1
INSERT INTO products_groups VALUES ( 1, 3.45, 217 )
[TEP STOP]
(w00t)Im not sure what im missing Please Help!!!!
also which version of easy populate are you using?
