hey not sure if this is a repost but I just had an issue w/ a site that had the dual pricing added after the site had been running for a while, and not all the products had been given whole sale pricong and there for had a database value of '' (not null but just empty.) this Meant that all those itmes came up as $0 for people w/ whole sale access. To correct this I simply ran the below SQL in the zen cart sql paches program.
Code:
UPDATE products SET products_price_w = 0 WHERE products_price_w = ''
Bookmarks