dannylee Posted January 11, 2007 Share Posted January 11, 2007 Hi Guys, I know i'm relatively new on this forum and I dont often get many replies but If someone could help me with this please...I can't work it out. Is there anyway that EasyPopulate can fetch and update the price break data held in the products database for the Quantity Price Breaks Per Product contribution. Below is the table info that I inserted into the database: alter table products add column products_price1 decimal(15,4) not null default 0.0; alter table products add column products_price2 decimal(15,4) not null default 0.0; alter table products add column products_price3 decimal(15,4) not null default 0.0; alter table products add column products_price4 decimal(15,4) not null default 0.0; alter table products add column products_price5 decimal(15,4) not null default 0.0; alter table products add column products_price6 decimal(15,4) not null default 0.0; alter table products add column products_price7 decimal(15,4) not null default 0.0; alter table products add column products_price8 decimal(15,4) not null default 0.0; alter table products add column products_price1_qty int not null default 0; alter table products add column products_price2_qty int not null default 0; alter table products add column products_price3_qty int not null default 0; alter table products add column products_price4_qty int not null default 0; alter table products add column products_price5_qty int not null default 0; alter table products add column products_price6_qty int not null default 0; alter table products add column products_price7_qty int not null default 0; alter table products add column products_price8_qty int not null default 0; alter table products add column products_qty_blocks int not null default 1; If someone could help me i'd really appreciate it. Link to comment Share on other sites More sharing options...
dannylee Posted January 11, 2007 Author Share Posted January 11, 2007 Anyone? :( Link to comment Share on other sites More sharing options...
dannylee Posted January 11, 2007 Author Share Posted January 11, 2007 Is it cus am a newbie?! :) Link to comment Share on other sites More sharing options...
dannylee Posted January 15, 2007 Author Share Posted January 15, 2007 Can anyone help me with this?! I'd really appreciate it!? Link to comment Share on other sites More sharing options...
Guest Posted January 15, 2007 Share Posted January 15, 2007 yes you can do that. But you need to either write your own code or ask in the EP thread in case someone already did that. If you do your own code, you could follow the products_price in easypopulate.php and see how it is done. Do the coding initially just for one field till it works, before adding every QPBPP product field for processing. Link to comment Share on other sites More sharing options...
chrisjat Posted January 15, 2007 Share Posted January 15, 2007 Is it cus am a newbie?! :) I am pretty sure no one here would ignore you or anyone just because they are a newbie. Link to comment Share on other sites More sharing options...
dannylee Posted January 15, 2007 Author Share Posted January 15, 2007 I hope not, I just really want to find a solution around this :( Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.