I have manually installed this contribution (newish install and also has AusPOST contribution), and it *appears* to be working fine in all forms, etc.
However, when I try to run sppc_v42_install.sql, I get the following error:
Error
SQL query:
ALTER TABLE `customers` ADD customers_group_id smallint UNSIGNED NOT NULL default '0',
ADD customers_group_ra enum( '0', '1' ) NOT NULL ,
ADD customers_payment_allowed varchar( 255 ) NOT NULL default '',
ADD customers_shipment_allowed varchar( 255 ) NOT NULL default '',
ADD customers_specific_taxes_exempt varchar( 255 ) NOT NULL default '',
ADD entry_company_tax_id VARCHAR( 32 ) DEFAULT NULL ;
MySQL said:
#1060 - Duplicate column name 'customers_group_id'
When I test the SPPC and log in as a wholesale customer, it ignores the wholesale price and uses the retail price. I assume this error I am receiving is mostly to blame as MySQL does not have a table listing for wholesale price.
Any ideas would be gratefully received!
Thanks you.