AJAX Attribute Manager support
#1181
Posted 31 October 2011, 12:51
#1182
Posted 01 November 2011, 08:24
gfasal, on 11 October 2011, 13:11, said:
http://addons.oscommerce.com/info/4888
cheers!
Sussefully integrated this addon to Ajax attributes!! now i can enter attribute code and store them, save them to templates etc.
INSTALLED:Document Manager / Monthly Sales and Tax Returns / Batch Print Invoices / Ultimate HTML EMAILs / AJAX Attribute Manager / OSC PDF Catalog / Move Bookmarks / Sort Order / Easy Populate / Sales Reports / Low Stock Report / Admin: Model # on Category / Product Administration Screen / Mini images in admin / SLiCK reCaptcha / Google + / Beautiful Breadcrumbs / 2.3.1 - Banner Language Mod / ADD New Page / EASY MAP (google) v.3.0 / Who's Online Enhancement for 2.3.1 / Admin Notes / scrambled order number / remove_unused_images / Quantity Select / Unit Weight / Product Specifions (filter results) / AJAX Product Attributes/ Attribute Codes/ Date & Order No. to Invoice/ O.P.I. 2.0 / Attribute Images / Manual Order Editor / Attributes Clone / Order Editor / Create Order / Company VAT No. / Add customer/ CKEditor 2.3.1 / Page Manager / Default images via admin / Percentage Shipping Price / QTPro / Scroll to Top / PDF Invoice / Featured Products / Product Listing Enhancements / AutoBackups / ..Custom Admin Mods /
#1183
Posted 02 November 2011, 13:10
When I'm editing a product, I select the first option box - the default is the first one in the list - when I click on another option in the list, it quickly shows that it was selected, then it reverts back to the default option. Any thoughts on this? As far as I can see, I'm not able to add any attributes unless I first use the top option - and no Values for the Option show up.
Edited by The Munch, 02 November 2011, 13:12.
----------
Using: OSC 2.3.1, Algozone Template, Jcow 5 Pro, CometChat 4 Premium.
Contributions for OSC-2.3.1: QT Pro 4.6.1, Easy Populate EPv2.77a, Admin Notes, Contribution Tracker, Multi-Product Manager, myQBi Quickbooks Sync, Order Editor 5.0.9, Dynamic Sitemap, Tax ID in Order Editor, Separate Pricing Per Customer v4.2.2 ... etc ...
Contributions for OSC-2.2 I've Modified for OSC-2.3.1: Admin Level Account with Categories 2.3.4, File Logging or Email for Failed Admin Login Attempts, Autologon v1.09, Admin Specials by Categories, CCGV 6.0_1, Hide Categories, How Did You Hear About Us, MSRP Listing, Multiple Sales Per Product, osc as info site, OSC Checkout Security Boost v1.1, Points and Rewards Module, Quick Stock Updater, Quick Updates 292, RMA Returns System 2.6, Show Unit Price, Store Mode, Supplier Admin v1.3, Tell A Friend, Required Customer Details v22rc2a, Admin Change Customers Password v3.3, PDF Invoice & PackingSlip 1.6, Quick Price Updates for SPPC v1.5, Country-State Selector v1.5.5 + Limit Countries v2.2, Contact Us Popup Business Card, No Right Click, Delete Customer Account v1.2, Control Login v2.2, Member Type Control v1.1, .... etc...
#1184
Posted 02 November 2011, 13:25
----------
Using: OSC 2.3.1, Algozone Template, Jcow 5 Pro, CometChat 4 Premium.
Contributions for OSC-2.3.1: QT Pro 4.6.1, Easy Populate EPv2.77a, Admin Notes, Contribution Tracker, Multi-Product Manager, myQBi Quickbooks Sync, Order Editor 5.0.9, Dynamic Sitemap, Tax ID in Order Editor, Separate Pricing Per Customer v4.2.2 ... etc ...
Contributions for OSC-2.2 I've Modified for OSC-2.3.1: Admin Level Account with Categories 2.3.4, File Logging or Email for Failed Admin Login Attempts, Autologon v1.09, Admin Specials by Categories, CCGV 6.0_1, Hide Categories, How Did You Hear About Us, MSRP Listing, Multiple Sales Per Product, osc as info site, OSC Checkout Security Boost v1.1, Points and Rewards Module, Quick Stock Updater, Quick Updates 292, RMA Returns System 2.6, Show Unit Price, Store Mode, Supplier Admin v1.3, Tell A Friend, Required Customer Details v22rc2a, Admin Change Customers Password v3.3, PDF Invoice & PackingSlip 1.6, Quick Price Updates for SPPC v1.5, Country-State Selector v1.5.5 + Limit Countries v2.2, Contact Us Popup Business Card, No Right Click, Delete Customer Account v1.2, Control Login v2.2, Member Type Control v1.1, .... etc...
#1185
Posted 14 November 2011, 15:07
Edited by MikeHill, 14 November 2011, 15:08.
#1186
Posted 14 November 2011, 16:09
If I'm wrong about my assumption, I apologize.
----------
Using: OSC 2.3.1, Algozone Template, Jcow 5 Pro, CometChat 4 Premium.
Contributions for OSC-2.3.1: QT Pro 4.6.1, Easy Populate EPv2.77a, Admin Notes, Contribution Tracker, Multi-Product Manager, myQBi Quickbooks Sync, Order Editor 5.0.9, Dynamic Sitemap, Tax ID in Order Editor, Separate Pricing Per Customer v4.2.2 ... etc ...
Contributions for OSC-2.2 I've Modified for OSC-2.3.1: Admin Level Account with Categories 2.3.4, File Logging or Email for Failed Admin Login Attempts, Autologon v1.09, Admin Specials by Categories, CCGV 6.0_1, Hide Categories, How Did You Hear About Us, MSRP Listing, Multiple Sales Per Product, osc as info site, OSC Checkout Security Boost v1.1, Points and Rewards Module, Quick Stock Updater, Quick Updates 292, RMA Returns System 2.6, Show Unit Price, Store Mode, Supplier Admin v1.3, Tell A Friend, Required Customer Details v22rc2a, Admin Change Customers Password v3.3, PDF Invoice & PackingSlip 1.6, Quick Price Updates for SPPC v1.5, Country-State Selector v1.5.5 + Limit Countries v2.2, Contact Us Popup Business Card, No Right Click, Delete Customer Account v1.2, Control Login v2.2, Member Type Control v1.1, .... etc...
#1187
Posted 14 November 2011, 16:33
(Product) Nightstand in Oak (Price) $200
(Option) Cherry ($300)
(Option) Hickory ($400)
(Option) Maple ($500)
So if I select "nothing" in the Prefix, it changes it to "+" when it is saved. If I go back in and change the "+" back to "nothing" in the Prefix drop down, it takes the option price back to $0.00.
#1188
Posted 17 November 2011, 04:07
Thanks
Garfield
#1189
Posted 14 December 2011, 16:56
#1190
Posted 15 December 2011, 21:05
#1191
Posted 15 December 2011, 21:37
MikeHill, on 14 November 2011, 16:33, said:
(Product) Nightstand in Oak (Price) $200
(Option) Cherry ($300)
(Option) Hickory ($400)
(Option) Maple ($500)
So if I select "nothing" in the Prefix, it changes it to "+" when it is saved. If I go back in and change the "+" back to "nothing" in the Prefix drop down, it takes the option price back to $0.00.
(Product) Nightstand in Oak (Price) $200
(Option) Cherry + 100
(Option) Hickory + 200
(Option) Maple + 300
THEN, if you are using the QTPro contribution and want to display the full item price on drop-down menus to the customer, you can select that option in the configuration menu in the admin section. You will set "Use Actual Price Pull Downs" to "true".
However, this does have a warning stating: "NOTE: This can only be used with a satisfying result if you have only one option per product."
#1192
Posted 15 December 2011, 21:54
MikeHill, on 14 November 2011, 16:33, said:
(Product) Nightstand in Oak (Price) $200
(Option) Cherry ($300)
(Option) Hickory ($400)
(Option) Maple ($500)
So if I select "nothing" in the Prefix, it changes it to "+" when it is saved. If I go back in and change the "+" back to "nothing" in the Prefix drop down, it takes the option price back to $0.00.
Use Actual Attribute Price
Chris
:|: Click Here to learn how I can help you with custom coding, add ons, security and templates :|:
:|: Need an Area Calculator, Pre-Paid Account, Virtual Pin, Auction or Layaway Add on ? Click Here :|:
#1193
Posted 29 December 2011, 12:00
Deprecated: Assigning the return value of new by reference is deprecated in /home/mrhilzhx/public_html/test/backoffice/attributeManager/includes/attributeManagerGeneralFunctions.inc.php on line 38
Deprecated: Assigning the return value of new by reference is deprecated in /home/mrhilzhx/public_html/test/backoffice/attributeManager/includes/attributeManagerGeneralFunctions.inc.php on line 41
Warning: Cannot modify header information - headers already sent by (output started at /home/mrhilzhx/public_html/test/backoffice/attributeManager/includes/attributeManagerGeneralFunctions.inc.php:38) in /home/mrhilzhx/public_html/test/backoffice/attributeManager/attributeManager.php on line 72
Please help!!!
#1194
Posted 05 January 2012, 14:08
MrHilsen, on 29 December 2011, 12:00, said:
Deprecated: Assigning the return value of new by reference is deprecated in /home/mrhilzhx/public_html/test/backoffice/attributeManager/includes/attributeManagerGeneralFunctions.inc.php on line 38
Deprecated: Assigning the return value of new by reference is deprecated in /home/mrhilzhx/public_html/test/backoffice/attributeManager/includes/attributeManagerGeneralFunctions.inc.php on line 41
Warning: Cannot modify header information - headers already sent by (output started at /home/mrhilzhx/public_html/test/backoffice/attributeManager/includes/attributeManagerGeneralFunctions.inc.php:38) in /home/mrhilzhx/public_html/test/backoffice/attributeManager/attributeManager.php on line 72
Please help!!!
Hello,
Open your admin/attributeManager/includes/attributeManagerGeneralFunctions.inc.php file and scroll down to row 38
Change this:
$attributeManager =& new attributeManagerAtomic(amGetSesssionVariable(AM_SESSION_VAR_NAME));to this:
$attributeManager = new attributeManagerAtomic(amGetSesssionVariable(AM_SESSION_VAR_NAME));
And
$attributeManager =& new attributeManagerInstant($_GET['products_id']);
To
$attributeManager = new attributeManagerInstant($_GET['products_id']);
Its the =& operator that that needs to be just =
For some reason this operator is not supported anymore, and what the heck is it?
i know that = & is a assignment by reference but when they are stuck togeteher i dont know... Please some one explain [img]http://forums.oscommerce.com//public/style_emoticons/default/wink.png[/img]
/Janne
Edited by iankil, 05 January 2012, 14:09.
Mindsparx admin for 2.2
Mindsparx admin for 2.3
Mindsparx admin for 3.0
Mindsparx specials 2.2
Starproduct pimped for 2.2
Starproduct pimped for 2.3
Mindsparx template osc Sport 2.2
Mindsparx template Horizon 2.3
+ a few more...
#1195
Posted 11 January 2012, 14:54
redrum, on 02 April 2011, 19:12, said:
So it would be nice with a solution for this.
I had the same problem, and removed the 'products_quantity' from the $sql_data_array.
In my categories.php (heavily modified) it's around line 258.
In admin/categories.php
replace:
$sql_data_array = array('products_quantity' => tep_db_prepare_input($HTTP_POST_VARS['products_quantity']),
'products_model' => tep_db_prepare_input($HTTP_POST_VARS['products_model']),
'products_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price']),
'products_date_available' => $products_date_available,
'products_weight' => tep_db_prepare_input($HTTP_POST_VARS['products_weight']),
'products_status' => tep_db_prepare_input($HTTP_POST_VARS['products_status']),
'products_tax_class_id' => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']),
'manufacturers_id' => tep_db_prepare_input($HTTP_POST_VARS['manufacturers_id']));
with
$sql_data_array = array('products_model' => tep_db_prepare_input($HTTP_POST_VARS['products_model']),
'products_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price']),
'products_date_available' => $products_date_available,
'products_weight' => tep_db_prepare_input($HTTP_POST_VARS['products_weight']),
'products_status' => tep_db_prepare_input($HTTP_POST_VARS['products_status']),
'products_tax_class_id' => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']),
'manufacturers_id' => tep_db_prepare_input($HTTP_POST_VARS['manufacturers_id']));
It works for me!
But please be aware that I'm a PHP newbie, so it might cause problems somewhere else [img]http://forums.oscommerce.com//public/style_emoticons/default/wacko.png[/img]
Kind regards,
Mikael
#1196
Posted 13 January 2012, 15:03
But when I go to change some attribute I get out of this error
1136 - Column count doesn't match value count at row 1 insert into products_attributes values (null, '29', '1', '2', '0', '+') [TEP STOP]
anyone has any idea what could be?
thanks
#1197
Posted 17 January 2012, 03:30
In admin, editing my product, there is much code that popped up ending in the following:
Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\www\osc231\catalog\admin\attributeManager\includes\attributeManagerGeneralFunctions.inc.php on line 55
Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\www\osc231\catalog\admin\attributeManager\includes\attributeManagerGeneralFunctions.inc.php on line 58
Functions.php:
$attributeManager =& new attributeManagerAtomic(amGetSessionVariable(AM_SESSION_VAR_NAME));
}
else
$attributeManager =& new attributeManagerInstant($_GET['products_id']);
***
In the front end, at the products Product Info page is:
Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in C:\wamp\www\osc231\catalog\includes\functions\database.php on line 99
Database.php:
return mysql_fetch_array($db_query, MYSQL_ASSOC);
****
I am searching to try and find a start on what to do. If anyone has a clue I would appreciate it. Thanks.
#1198
Posted 26 January 2012, 18:33
This is a great contribution and I have been using it for while now.
The problem I am having is that a customer cannot select more than one item that has an attribute on it.
It does not allow multiples of an item that has attributes attached. I cannot change the quantity over 1.
If I go in and add another of the same item with a different attribute it just writes over the first one I had with the new attribute.
Has anyone else had this problem? Any ideas for a fix?
I have version v2.8.9.3 installed.
Thank you!
#1199
Posted 09 February 2012, 13:56
I got rid of the deprecated errors but I still have all this code showing, in admin, after the product price.. What have I done wrong?
This is the March 2011 Ajax. install with the Body update.
This as brand new osc installl with this plugin being installed first so I can figure out how to get it working.
***
This will overwrite this products current options and cannot be undone.'); define('AM_AJAX_NEW_TEMPLATE_NAME_HEADER', 'Please enter a new name for the new Template. Or...'); define('AM_AJAX_NEW_NAME', 'New Name:'); define('AM_AJAX_CHOOSE_EXISTING_TEMPLATE_TO_OVERWRITE', ' ...
... Choose an existing one to overwrite'); define('AM_AJAX_CHOOSE_EXISTING_TEMPLATE_TITLE', 'Existing:'); define('AM_AJAX_RENAME_TEMPLATE_ENTER_NEW_NAME', 'Please enter the new name for the %s Template'); define('AM_AJAX_PROMPT_DELETE_TEMPLATE', 'Are you sure you want to delete the %s Template?
This cannot be undone!'); //attributeManager.php define('AM_AJAX_ADDS_ATTRIBUTE_TO_OPTION', 'Adds the selected attribute on the left to the %s option'); define('AM_AJAX_ADDS_NEW_VALUE_TO_OPTION', 'Adds a new value to the %s option'); define('AM_AJAX_PRODUCT_REMOVES_OPTION_AND_ITS_VALUES', 'Removes the option %1$s and the %2$d option value(s) below it from this product'); define('AM_AJAX_CHANGES', 'Changes'); define('AM_AJAX_LOADS_SELECTED_TEMPLATE', 'Loads the selected template'); define('AM_AJAX_SAVES_ATTRIBUTES_AS_A_NEW_TEMPLATE', 'Saves the current attributes as a new template'); define('AM_AJAX_RENAMES_THE_SELECTED_TEMPLATE', 'Renames the selected template'); define('AM_AJAX_DELETES_THE_SELECTED_TEMPLATE', 'Deletes the selected template'); define('AM_AJAX_NAME', 'Name'); define('AM_AJAX_ACTION', 'Action'); define('AM_AJAX_PRODUCT_REMOVES_VALUE_FROM_OPTION', 'Removes %1$s from %2$s, from this product'); define('AM_AJAX_MOVES_VALUE_UP', 'Moves option value up'); define('AM_AJAX_MOVES_VALUE_DOWN', 'Moves option value down'); define('AM_AJAX_ADDS_NEW_OPTION', 'Adds a new option to the list'); define('AM_AJAX_OPTION', 'Option:'); define('AM_AJAX_VALUE', 'Value:'); define('AM_AJAX_PREFIX', 'Prefix:'); define('AM_AJAX_PRICE', 'Price:'); define('AM_AJAX_WEIGHT_PREFIX', 'Wgt.Prefix:'); define('AM_AJAX_WEIGHT', 'Weight:'); define('AM_AJAX_SORT', 'Sort:'); define('AM_AJAX_ADDS_NEW_OPTION_VALUE', 'Adds a new option value to the list'); define('AM_AJAX_ADDS_ATTRIBUTE_TO_PRODUCT', 'Adds the attribute to the current product'); define('AM_AJAX_DELETES_ATTRIBUTE_FROM_PRODUCT', 'Deletes attribute or attribute combination from the current product'); define('AM_AJAX_QUANTITY', 'Quantity:'); define('AM_AJAX_PRODUCT_REMOVE_ATTRIBUTE_COMBINATION_AND_STOCK', 'Removes this attribute combination and stock from this product'); define('AM_AJAX_UPDATE_OR_INSERT_ATTRIBUTE_COMBINATIONBY_QUANTITY', 'Update or Insert the attribute combination with the given quantity'); define('AM_AJAX_UPDATE_PRODUCT_QUANTITY', 'Set the given quantity to the current product'); //attributeManager.class.php define('AM_AJAX_TEMPLATES', '-- Templates --'); //---------------------------- // Change: download attributes for AM // // author: mytool //----------------------------- define('AM_AJAX_FILENAME', 'File'); define('AM_AJAX_FILE_DAYS', 'Days'); define('AM_AJAX_FILE_COUNT', 'Max. downloads'); define('AM_AJAX_DOWLNOAD_EDIT', 'Edit download option'); define('AM_AJAX_DOWLNOAD_ADD_NEW', 'Add download option'); define('AM_AJAX_DOWLNOAD_DELETE', 'Delete download option'); define('AM_AJAX_HEADER_DOWLNOAD_ADD_NEW', 'Add download option for \"%s\"'); define('AM_AJAX_HEADER_DOWLNOAD_EDIT', 'Edit download option for \"%s\"'); define('AM_AJAX_HEADER_DOWLNOAD_DELETE', 'Delete download option from \"%s\"'); define('AM_AJAX_FIRST_SAVE', 'Save Product before adding options'); //---------------------------- // EOF Change: download attributes for AM //----------------------------- define('AM_AJAX_OPTION_NEW_PANEL','New option:'); define('AM_AJAX_SORT_NUMERIC', 'Sort Numerically'); define('AM_AJAX_SORT_ALPHABETIC', 'Sort Alphabetically'); ?> This will overwrite this products current options and cannot be undone.'); define('AM_AJAX_NEW_TEMPLATE_NAME_HEADER', 'Please enter a new name for the new Template. Or...'); define('AM_AJAX_NEW_NAME', 'New Name:'); define('AM_AJAX_CHOOSE_EXISTING_TEMPLATE_TO_OVERWRITE', ' ...
... Choose an existing one to overwrite'); define('AM_AJAX_CHOOSE_EXISTING_TEMPLATE_TITLE', 'Existing:'); define('AM_AJAX_RENAME_TEMPLATE_ENTER_NEW_NAME', 'Please enter the new name for the %s Template'); define('AM_AJAX_PROMPT_DELETE_TEMPLATE', 'Are you sure you want to delete the %s Template?
This cannot be undone!'); //attributeManager.php define('AM_AJAX_ADDS_ATTRIBUTE_TO_OPTION', 'Adds the selected attribute on the left to the %s option'); define('AM_AJAX_ADDS_NEW_VALUE_TO_OPTION', 'Adds a new value to the %s option'); define('AM_AJAX_PRODUCT_REMOVES_OPTION_AND_ITS_VALUES', 'Removes the option %1$s and the %2$d option value(s) below it from this product'); define('AM_AJAX_CHANGES', 'Changes'); define('AM_AJAX_LOADS_SELECTED_TEMPLATE', 'Loads the selected template'); define('AM_AJAX_SAVES_ATTRIBUTES_AS_A_NEW_TEMPLATE', 'Saves the current attributes as a new template'); define('AM_AJAX_RENAMES_THE_SELECTED_TEMPLATE', 'Renames the selected template'); define('AM_AJAX_DELETES_THE_SELECTED_TEMPLATE', 'Deletes the selected template'); define('AM_AJAX_NAME', 'Name'); define('AM_AJAX_ACTION', 'Action'); define('AM_AJAX_PRODUCT_REMOVES_VALUE_FROM_OPTION', 'Removes %1$s from %2$s, from this product'); define('AM_AJAX_MOVES_VALUE_UP', 'Moves option value up'); define('AM_AJAX_MOVES_VALUE_DOWN', 'Moves option value down'); define('AM_AJAX_ADDS_NEW_OPTION', 'Adds a new option to the list'); define('AM_AJAX_OPTION', 'Option:'); define('AM_AJAX_VALUE', 'Value:'); define('AM_AJAX_PREFIX', 'Prefix:'); define('AM_AJAX_PRICE', 'Price:'); define('AM_AJAX_WEIGHT_PREFIX', 'Wgt.Prefix:'); define('AM_AJAX_WEIGHT', 'Weight:'); define('AM_AJAX_SORT', 'Sort:'); define('AM_AJAX_ADDS_NEW_OPTION_VALUE', 'Adds a new option value to the list'); define('AM_AJAX_ADDS_ATTRIBUTE_TO_PRODUCT', 'Adds the attribute to the current product'); define('AM_AJAX_DELETES_ATTRIBUTE_FROM_PRODUCT', 'Deletes attribute or attribute combination from the current product'); define('AM_AJAX_QUANTITY', 'Quantity:'); define('AM_AJAX_PRODUCT_REMOVE_ATTRIBUTE_COMBINATION_AND_STOCK', 'Removes this attribute combination and stock from this product'); define('AM_AJAX_UPDATE_OR_INSERT_ATTRIBUTE_COMBINATIONBY_QUANTITY', 'Update or Insert the attribute combination with the given quantity'); define('AM_AJAX_UPDATE_PRODUCT_QUANTITY', 'Set the given quantity to the current product'); //attributeManager.class.php define('AM_AJAX_TEMPLATES', '-- Templates --'); //---------------------------- // Change: download attributes for AM // // author: mytool //----------------------------- define('AM_AJAX_FILENAME', 'File'); define('AM_AJAX_FILE_DAYS', 'Days'); define('AM_AJAX_FILE_COUNT', 'Max. downloads'); define('AM_AJAX_DOWLNOAD_EDIT', 'Edit download option'); define('AM_AJAX_DOWLNOAD_ADD_NEW', 'Add download option'); define('AM_AJAX_DOWLNOAD_DELETE', 'Delete download option'); define('AM_AJAX_HEADER_DOWLNOAD_ADD_NEW', 'Add download option for \"%s\"'); define('AM_AJAX_HEADER_DOWLNOAD_EDIT', 'Edit download option for \"%s\"'); define('AM_AJAX_HEADER_DOWLNOAD_DELETE', 'Delete download option from \"%s\"'); define('AM_AJAX_FIRST_SAVE', 'Save Product before adding options'); //---------------------------- // EOF Change: download attributes for AM //----------------------------- define('AM_AJAX_OPTION_NEW_PANEL','New option:'); define('AM_AJAX_SORT_NUMERIC', 'Sort Numerically'); define('AM_AJAX_SORT_ALPHABETIC', 'Sort Alphabetically'); ?>
Edited by tonymatt, 09 February 2012, 13:59.
#1200
Posted 09 February 2012, 23:25
http://i171.photobucket.com/albums/u314/afm409/osc231%20sql/1.jpg
http://i171.photobucket.com/albums/u314/afm409/osc231%20sql/2-1.jpg
Edited by tonymatt, 09 February 2012, 23:27.














