Jump to content

dimports

Members
  • Content count

    215
  • Joined

  • Last visited

Everything posted by dimports

  1. I get a lot of orders thru phone or in person. Most of the time the prices and shipping are all custom done on the spot. I think there should be a way to log into admin, then into 'point-of-sale' and fill out the customers order with custom shipping and price. This will create a product with the appropiate price and shipping in a hidden category and email the link the customer to pay thru the shopping cart. I think the Step-by-Step Manual Order contribution would be a good start. This would also utilize Individual Shipping contribution for the custom shipping price. You would probably need a hidden category contribution too to hide all those manual orders from coming up in searches. An automatic task to delete all custom-made products in that hidden category every 10 days would be a nice little bonus. If anybody knows how to do this, let me know and I'm sure we can gather enough donations for this even if it's just for me. Thx.
  2. dimports

    Multi-Stores Multiple Shops Support

    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.
  3. dimports

    Multi-Stores Multiple Shops Support

    Is it possible to assign group discounts. Such as all "wholesalers" are assigned 20% discount off prices.
  4. dimports

    Multi-Stores Multiple Shops Support

    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?
  5. By the way, I have a multi-store contribution installed.. Do you have the same contribution installed? Perhaps this is the case?
  6. I get the same exact error. I even made sure the permissions on my temp folder is 777.
  7. dimports

    Multi-Stores Multiple Shops Support

    I installed successfully.. GREAT CONTRIBUTION!! One question so far, whats the point of "Distributors".. What's it for? Thanks
  8. dimports

    MOECTOE Suite public BETA 1 Support

    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?!
  9. 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.
  10. 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.
  11. dimports

    Product Image if No Image Found

    Can someone please give an updated link on this solution? The link provided is not in the forums anymore. Any solutions?
  12. dimports

    MOECTOE Suite public BETA 1 Support

    Any word on when BETA 2 will be released??
  13. dimports

    MOECTOE Suite public BETA 1 Support

    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?
  14. 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.
  15. dimports

    Multi-Stores Multiple Shops Support

    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. :)
  16. 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?
  17. dimports

    Multi-Stores Multiple Shops Support

    I just finished installing this contribution and it seems great. I just can't get it to work properly. When I assign a category to a store, it's viewed under that store fine. But if it so happens that a category has subcategories, the store says theres no products in that subcategory. I tried checking the box for enableing products for all subcategories and products under the admin category screen. But no success. Anyone experience this or have an idea what this is from?
  18. dimports

    Current AUctions V2.0

    Great contribution! Can someone advise as to how to make pages for these auctions? It take a bunch of time to load all 200 auctions on the same page. I've been trying to take the snippet of code from the prodct listing file. Perhaps someone may tackle it with more success? $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'p.products_id'); if ( ($listing_split->number_of_rows > 0) && ( (PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3') ) ) { ?> ... ... if ($listing_split->number_of_rows > 0) { $row = 0; $col = 0; ... ... $col ++; if ($col > PRODUCT_LIST_COL_NUM-1) { $col = 0; $row ++; } }
  19. dimports

    OSC-Affiliate

    Here's a suggestion I'm brain storming for: Each affiliate can assign what price bracket their customer's will see. So all people who go to www.yoursite.com?ref=1, will see prices their referrer set. This will of course would probably effect his commision rate. Let me know if anyone has any ideas on this..
  20. Hey all. I am trying to pass custom pricing and shipping for certain items. Does anyone know of a contribution or have any suggestions as to how I would pass a price and shipping cost into the shoppping cart for a certain item. This of course would entail the shopping cart to ignore the products SQL table's references to the particular product's prices and would also have the shopping cart ignore the shipping modules and just pass a constant number for the shipping. I'd assume that there has to be a new class created for the shopping cart. Please help!!
  21. thanks for the reply. but more specifically, the problem is that the contribution will not generate a thumbnail on the fly if the image resides in a subfolder. It just ignores it.
  22. this doesn't work when images are in subfolders. It only works when images are just in the images folder. Anybody see why this would be happening?
  23. i wish it were that easy. for some reason it insists on only creating thumbnails only if the folder is a subfolder. its a weird thing, but if anyone has any idea, please let me know.
  24. I have many stores that pull the pics out of one images folder, like a consolidated images folder. It seems this contribution only works if the images folder is the subfolder of the catalogue (../catalog/images). Can this be modified so that images are create on the fly no matter where the images folder is located?
  25. dimports

    OSC-Affiliate

    Also is there a way to make it so that anyone who makes a purchase in the future from the affiliate, gets credit for it? In this case, cookies would not be sufficient in tracking this. I would like to make it so that any time a customer registers an account, he can put down the referrer and this referrer is stored under the customers database. So anytime the customer places an order, it is credited to that referrer. Is this possible? A good solution?
×