Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

dimports

Archived
  • Posts

    215
  • Joined

  • Last visited

Profile Information

  • Real Name
    Basem

dimports's Achievements

  1. Thats pretty much the point of the contribution. You will probably want to set a demo catalog and demo SQL table and test it out.
  2. Is it possible to assign group discounts. Such as all "wholesalers" are assigned 20% discount off prices.
  3. Thanks so much. Do all new contributions have to modified to work with the multi-store system (such as adding '.. where stores_id = ' . STORES_ID)? My auctionblox and easypopulate stopped working. I saw my last question in the FAQ :) , but I think this is important to address in there. Just want to tell you again this is amazing work. I do anticipate with you on osCommerce's template system (if it'll ever come out). But perhaps we can integrate a template system in there in the meantime, such as assigning templates to stores?
  4. By the way, I have a multi-store contribution installed.. Do you have the same contribution installed? Perhaps this is the case?
  5. I get the same exact error. I even made sure the permissions on my temp folder is 777.
  6. I installed successfully.. GREAT CONTRIBUTION!! One question so far, whats the point of "Distributors".. What's it for? Thanks
  7. I love the whole idea of this contribution. In reality though, it doesn't work 100% correctly.. making it beta of course. Who do we have to pay to get this to work 100%? I am a technology director, but I just dont have time to do it.. time being the keyword. Let me know what we can do about this. Even if we each tackle one problem individually and bring it back to the table. Who's with me?!
  8. I would love to see a 'not' option in the search module. Only 'and' and 'or' and parenthesis. I'm trying to hack the search file to include 'not'. As now, when i search for lion, results of stallion also mixes in my search result. So I want to do 'lion not stallion' to get only lions. This is the section I think the hack takes place in advance_search_result.php: for ($i=0, $n=sizeof($search_keywords); $i<$n; $i++ ) { switch ($search_keywords[$i]) { case '(': case ')': case 'and': case 'or': $where_str .= " " . $search_keywords[$i] . " "; break; case 'not': $where_str .= " " . $search_keywords[$i] . " "; break; default: $keyword = tep_db_prepare_input($search_keywords[$i]); $where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'"; if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == '1')) $where_str .= " or pd.products_description like '%" . tep_db_input($keyword) . "%'"; $where_str .= ")"; break; } } $where_str .= ")"; } If you notice, I copied the 'or' section and just replaced it with 'not'. This is the problem I get: 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and (pd.products_name like '%stallion%' or p.products_model lik select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%lion%' or p.products_model like '%lion%' or m.manufacturers_name like '%lion%') and not and (pd.products_name like '%stallion%' or p.products_model like '%stallion%' or m.manufacturers_name like '%stallion%')) Why does it automatically put an 'and' before not and after it. It doesn't do that with the 'or'. I know that in the keywords, spaces are converted to 'and', but these ands are out of place. Please help because its driving me nuts! Thanks in advance to all.
  9. I am very suprised that oscommerce didnt come with a 'not' option in the search module. Only 'and' and 'or' and parenthesis. I'm trying to hack the search file to include 'not'. As now, when i search for lion, results of stallion also mixes in my search result. So I want to do 'lion not stallion' to get only lions. This is the section I think the hack takes place in advance_search_result.php: ? ?for ($i=0, $n=sizeof($search_keywords); $i<$n; $i++ ) { ? ? ?switch ($search_keywords[$i]) { ? ? ? ?case '(': ? ? ? ?case ')': ? ? ? ?case 'and': ? ? ? ?case 'or': ? ? ? ? ?$where_str .= " " . $search_keywords[$i] . " "; ? ? ? ? ?break; ? ? ? ?case 'not': ? ? ? ? ?$where_str .= " " . $search_keywords[$i] . " "; ? ? ? ? ?break; ? ? ? ?default: ? ? ? ? ?$keyword = tep_db_prepare_input($search_keywords[$i]); ? ? ? ? ?$where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'"; ? ? ? ? ?if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == '1')) $where_str .= " or pd.products_description like '%" . tep_db_input($keyword) . "%'"; ? ? ? ? ?$where_str .= ")"; ? ? ? ? ?break; ? ? ?} ? ?} ? ?$where_str .= ")"; ?} If you notice, I copied the 'or' section and just replaced it with 'not'. This is the problem I get: 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and (pd.products_name like '%stallion%' or p.products_model lik select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%lion%' or p.products_model like '%lion%' or m.manufacturers_name like '%lion%') and not and (pd.products_name like '%stallion%' or p.products_model like '%stallion%' or m.manufacturers_name like '%stallion%')) Why does it automatically put an 'and' before not and after it. It doesn't do that with the 'or'. I know that in the keywords, spaces are converted to 'and', but these ands are out of place. Please help because its driving me nuts! Thanks in advance to all.
  10. Can someone please give an updated link on this solution? The link provided is not in the forums anymore. Any solutions?
  11. I get an error: Fatal error: Cannot redeclare class currencies in /home/dakabei/public_html/catalog/includes/classes/currencies.php on line 16 I haven't changed any of the MOECTOE files.. I just uploaded them. Anybody experience this?
  12. I've been trying to get invoices to be viewable to customers by adding an invoice.php file under the catalog/ directory using this contribution, but it doesn't work. It just gives me a blank page. Anybody know what could be the problem? I've searched thru the forums but no solutions.
  13. I love this contribution, but there are quite a few bugs especially regarding categories being added and removed from stores. I just cannot get it to work properly. Some cateogries will add ok, others will not. Some can be removed from a store, other cannot. I wish it was a consistent bug so I can pinpoint it, but random bugs are the worst. Zilla, you are the man. I'd say this is probably on the top 5 best contributions for osCommerce by far. I'm really looking forward to v1.7. Will this version be easy to update from v1.4, or will this require complete uninstall and reinstall of v1.7 due to different framework in place? I'm hoping it will be an easy update so I can begin using 1.7 soon after its release. If you need help devising an installation, please let the board know and I'm sure someone will help. You can PM me too if you'd like. Thanks again for your contribution and further successing the business of us all. :)
  14. I don't like using instant payment with credit cards in case something isn't in stock or shipping calculations isn't provided. So I review all orders before charging the card, then log into Authorize.net and manually enter everything to be charged. I see it beneficial if there was a button while viewing pending credit card orders that would charge the card from the admin side. Of course, it would be a one-time use so multiple charging doesn't occur. Anyone know if this is possible?
×
×
  • Create New...