jeroen123

has anyone already discovered how to upload files with Easypopulate when using quantity price breaks per customer? and when I upload manually; the prises and quantities for mu 'extra' groeps are not saved.. anyone an idea??

Jeroen, Do you see the columns also in products_groups? Perhaps only the first part (adding the columns to the table products) ran and you need to run the second part separately? CODEalter table products_groups add column products_price1 decimal(15,4) not null default 0.0, add column products_price2 decimal(15,4) not null default 0.0, etcetera, etcetera add column products_price8_qty int not null default 0, add column products_qty_blocks int not null default 1; Jan; I added it in a completely new installation and now it works! Thanks anyway!

Jan, When I run it again PHPmyadmin says that there is duplicate fields name, when I look in the tables I see all fields.. SQL-query: ALTER TABLE products ADD COLUMN products_price1 decimal( 15, 4 ) NOT NULL default 0.0, ADD COLUMN products_price2 decimal( 15, 4 ) NOT NULL default 0.0, ADD COLUMN products_price3 decimal( 15, 4 ) NOT NULL default 0.0, ADD COLUMN products_price4 decimal( 15, 4 ) NOT NULL default 0.0, ADD COLUMN products_price5 decimal( 15, 4 ) NOT NULL default 0.0, ADD COLUMN products_price6 decimal( 15, 4 ) NOT NULL default 0.0, ADD COLUMN products_price7 decimal( 15, 4 ) NOT NULL default 0.0, ADD COLUMN products_price8 decimal( 15, 4 ) NOT NULL default 0.0, ADD COLUMN products_price1_qty int NOT NULL default 0, ADD COLUMN products_price2_qty int NOT NULL default 0, ADD COLUMN products_price3_qty int NOT NULL default 0, ADD COLUMN products_price4_qty int NOT NULL default 0, ADD COLUMN products_price5_qty int NOT NULL default 0, ADD COLUMN products_price6_qty int NOT NULL default 0, ADD COLUMN products_price7_qty int NOT NULL default 0, ADD COLUMN products_price8_qty int NOT NULL default 0, ADD COLUMN products_qty_blocks int NOT NULL default 1 Any other suggestions??

After installation of this beautifull looking script: my admin (insert products) look like this: 1054 - Unknown column 'products_price1' in 'field list' select customers_group_id, customers_group_price, products_price1, products_price2, products_price3, products_price4, products_price5, products_price6, products_price7, products_price8, products_price1_qty, products_price2_qty, products_price3_qty, products_price4_qty, products_price5_qty, products_price6_qty, products_price7_qty, products_price8_qty, products_qty_blocks from products_groups where products_id = '' and customers_group_id = '1' order by customers_group_id and I only see the several prices and quantities for the default customer group.. Anyone a solution??