DavidR Posted September 27, 2006 Share Posted September 27, 2006 Well I haven't figured out the category issue yet, but I did notice that the correct sale price is only listed in the export file if the sale expire date is set. I haven't found anything in the code yet that would make sense of this or help me fix it. Has this been addressed before? Also, Google didn't mention it but I noticed that "expected" items are also listed in the file before the date they are expected. I'm surprised they didn't catch it, as I know they require that all items listed be available for sale. I can sympathize with the 11 hour days!!! I realize I am trying to work with an older, patched up version but I'm against a deadline with this feature so this is what I have to work with :'( If you have any suggestions, I will be happy to try to track them down. Thanks. left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) This statement seems to evaluate to true only if there is a date in specials.expires_date (and it is later than today). For products where there is not specials.expires_date (null) and specials.status = 1, it still shows the regular price. Does this need to be rewritten, perhaps the "and" and "or" are getting tripped up. I'm not that good with SQL but I know there is a trap there sometimes. Anyone know? Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.