Jump to content

thewitt

Members
  • Content count

    85
  • Joined

  • Last visited

Everything posted by thewitt

  1. thewitt

    USPS Domestic Shipping Troubles

    It has not fixed itself. It's still working like it did yesterday. International works fine, it's domestic that's messed up. -t
  2. thewitt

    All Customers Report

    What did you do to fix this problem, exactly? -t
  3. thewitt

    Setting a default payment option?

    Is there any way to set one of the payment options to automatically be selected when you go to the payment screen. Specifically I would like the Authorize.net option to be the default and be selected unless they pick something else. I have a fairly high number of customers who actually enter their credit card infomation and don't check the button and so we don't get their credit card info and have to contact them for payment information. Very frustrating. Options? Thanks, -t
  4. thewitt

    Setting a default payment option?

    Thanks Glenn, I'll play around with this and see what I can break. -t
  5. thewitt

    Setting a default payment option?

    So I take it there is no way to set a default payment option - either that or no one else has the problem with people getting an option they didn't want... -t
  6. thewitt

    Bank Wire Transfer Fee

    Did you get anywhere here? I have the same need and am going to hack something together to do this. I'm not sure which funds transfer module to start with though. -t
  7. thewitt

    Automatically send data feed to Froogle

    Thanks for the suggestion Dylan. I decided to simply sort the output by the product name and then as I walk the result rows, I queue them if I find a duplicate product name and then throw out all but one of them. I keep the one in a parent category if possible. If there isn't one in just a parent, I keep a random child. Froogle is happy now. -t
  8. I have a need to store the customer's credit card information, as well as use Authorize.net to AUTH_ONLY the transaction. I have the authorize.net piece working fine now - though it took quite a bit of fiddling on my end. We use the AUTH_ONLY mode in authorize.net to pre-authorize a credit card, then manually capture the sale when we ship. There are many reasons we do this, but one is that the final price of many of our items is not the same as the list price. The problem we have with the current model is that we cannot charge MORE than what we have pre-authorized without running the card through again. With the current authorize.net modules, we no longer know what the credit card number is, so we have to contact the customer again and get his card number. Not very professional. Has anyone integrated the cc.php module with the authorize.net module so that they store the credit card as well as automate the authorization of the transaction? -t
  9. thewitt

    Automatically send data feed to Froogle

    How would I modify the SQL query to ignore duplicate products? The other thing that Froogle does not like is products that are in multiple categories. I have a bunch of categories that also have child categories. I sell golf clubs, and an example of this is: Irons Irons -> Left Handed Irons -> Left Handed -> Kids Clubs In this case, the same product is in all three categories - linked of course so it's really only one product record. I have many of these, and have to "choose" the top category to report them from. I'm not really sure how to approach this one yet - whether it makes sense to try to modify the SQL to only pull out unique product names, or to post process the data and discard all the products that are duplicates. Of course, I also have valid subcategories that have products in them that are NOT in a parent, so I can't simply drop everything that is in a subcategory either. Any suggestions? -t
  10. thewitt

    Multi-Stores Multiple Shops Support

    I am goin glive today - just for your information. I've have a shared shopping cart, and am integrated with the SEC contribution which has meant that I'm not fully running the multi-store modules, and I've kept the same source code base through the use of the unix LN command. All in all this has been very helpful. www.myostrichgolf.com Live later this afternoon. I have a fairly high number of daily visitors in my present store, so it will definately get a workout... -t
  11. thewitt

    Multi-Stores Multiple Shops Support

    Manufacturers really need to be store specific. As I'm getting ready to take my split store live, one of the things that still glares out as missing are store specific manufacturers. I have roughly 100 manufacturers. 80 have products in Store 1. 20 have products in Store 2. I really do need to split them out. I think that the only place they need to be split is in the manufacturers pull-down, and then have an "assignment to store" option in the admin. -t
  12. thewitt

    Multi-Stores Multiple Shops Support

    Just a note on implementation strategies. I have a split shop running now, using all the same program files except for a few files for language changes and look and feel. No duplication of files needed. I have two shops: http://myurl/proshop http://myurl/clubmakers These are simply directories at the top of my web heirarchy. I have a splash page outside that allows people to decide what shop they want to enter. The files all live in "proshop" (the 'catalog' directory) except for those that needed specific changes for the "clubmakers" shop. What I did was to use the unix "ln -s" command to LINK the files from the proshop directories to the clubmakers directories. Where I needed to mofify any one file, I then simply removed the link to that file and copied the original over to the clubmakers directory and edited it. I did NOT use the configuration table in the database for "STORES_ID" either. I simply defined it in "configure.php" uniquely for each store. It seems to be working very well so far. It's only a partial implementation, and it's integrated with the SEC contribution. I've kept the same shopping cart common across both virtual stores, etc. Thanks for your work. It was a great base to build on. It would be nice to have an admin function that would show you any products that are not associated with a store. I've "lost" a few products so far during the definition stages by not assigning them to anything! -t
  13. thewitt

    Multi-Stores Multiple Shops Support

    Thanks. I worked through it last night (till almost 4 this morning...) and was going to report the store image bug this morning too :). I have been integrating only pieces as you know, as I wand to have the same accounts and shopping carts. It's been working fine. I'm also doing the integration with SEC from Linda - which is really a great set of contributions - so I've had to manually install most of the fixes. I'm playing with soft links (the ln -s command) in unix to see if I can reduce the number of files that I actually have to duplicate. It does not appear that I need many to change the pieces that need to be changed. I appreciate your work. I think it would be nice to have the store selector on the actual product creation page though - I seem to keep forgetting to put the products in a store up front since it's an extra step outside the product creation process. Just a leaning curve I guess. -t
  14. thewitt

    Multi-Stores Multiple Shops Support

    Just another note. The contribution is missing: catalog/specials.php I've already upgraded mine, but my specials.php is already modified so I can't really apply the changes to the contribution yet. I'll do so when I finish the whole thing if it's not been done yet. -t
  15. thewitt

    Multi-Stores Multiple Shops Support

    Is the implementation plan then to copy all the files in catalog to a new directory and that then becomes the second store? I've been integrating just the pieces needed to have separate products in each store and keep the same customer base, shopping cart etc. It's going fine, but I thought I could use the same phsical store and simply switch products displayed in each category. The problem I'm having at the moment is setting STORE_ID. Since STORE_ID is stored in the STORES table along with the URL, why not set it from there by comparing the URL with the stores URL, also stored in the STORES table. By removing the STORE_ID values from the CONFIGURATION table, you could then really use the same code base by simply creating a link to the catalog directory from store 2, rather than duplicating all the files - which makes maintenance a little more complex (change one file, copy to all the stores, etc). Does this make any sense? Am I missing something else here? -t
  16. thewitt

    USPSMethods 2.6 Parcel Post incorrect

    It's a bug. If you search here you'll find the posted fix. If you can't find it, holler and I'll check my files for the fix for you - I'm not where I can see them right now. -t
  17. I found one more little annoyance. If you grant access to a category of functions, and then don't grant access to the first file in that category, you get a permission error when you select the category. Example: Give access to the Tools menu item, but not the Backup option - only Send Email and Newsletter Manager. If you log in as that user now and go to the Tools selection then, you will get an access violation that is not clear to the end user what he is trying to do that he's not permitted access to do. The Tools select "pulls up" the backup option by default, and since the user does not have access to backup, he gets the Forbidden message... -t
  18. TEXT_INFO_HEADING_EDIT_GROUP and TEXT_INFO_EDIT_GROUP_INTRO do not appear to be defined anywhere. I've installed this and applied the patches in this thread - and so far this is the only error I still see. -t
  19. Does anyone have experience with the following contribution? Attributes option type selection v.2.0 Here is the description: I've modified osCommerce's option system so that it's now possible to select (in admin) the option type of a product (select, checkbox, radio, select multiple). New features in version 2.0: - use of attribute for: special offer on product (3x2,4x2,...) minimum order quantity price levels: qty < n1 price1 n1 <= qty <n2 price2 ... - new text attribute option - conditional option (option1 linked with option2, if you select option1, option2 is automatically selected) - order of attribute ---------------- I've just installed AttributeSorterv4.0, and this contribution also appears to also have attribute sorting built into it. I've been waiting to put a store online until I had text attributes, and this looks like it adds those for me as well. Anyone have experience with it they wish to share? Thanks, -t
  20. thewitt

    JUST RELEASED! Printable Catalog

    In looking over the SQL query, I don't think this is possible today. You will have a product printed for each time it's in a new catetory, but there is nothing in the catalog query that even cares about attributes. If you are getting duplicates based on attributes, you are running something other than BirdBrain's contribution. -t
  21. thewitt

    JUST RELEASED! Printable Catalog

    I have a question about the SQL query in the Printable Catalog contribution. Here's the query: select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, cd.categories_name, m.manufacturers_name from products p left join products_to_categories p2c on p.products_id=p2c.products_id left join categories c on p2c.categories_id=c.categories_id left join categories_description cd on c.parent_id='0' and c.categories_id=cd.categories_id left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where products_status = '1' order by cd.categories_name, c.parent_id, c.sort_order, c.categories_id, pd.products_name and when I run it, I get a mixed up list of products, where the first several hundred have a NULL cd.categories_name field. There are no categories with a NULL name field in the datbase. There are many products that are linked into multiple categories and sub-categories however. What's the intended purpose of the c.parent_id='0' portion of the line: left join categories_description cd on c.parent_id='0' and c.categories_id=cd.categories_id Thanks, -t
  22. thewitt

    Quantity Discount & Attributes

    We've tried using the comment box for additions to the order, but it's really not very successful. They don't know that it comes after they have completed the checkout, they don't say what we need them to say in the comment box - often not even tying their comment to a particular item they ordered on a large order - so we end up calling them and delaying their order, and then they often put things that we cannot do in that box - since they are not selecting from a predefined list. The same would be true for a text "attribute" box. If we ever get a supported text attribute, it will need to come with validation capabilities to be really useful. Free form text is only marginally helpful for this type of problem. -t
  23. thewitt

    Quantity Discount & Attributes

    Here's the example I'm facing. I sell golf clubs. Here's an example of how they are priced. If you buy an individual club, it's $30. If you buy 5 or more clubs of the same model, the individual club price is $25. These are the same model club, but different attributes ie 3 iron, 4 iron. It makes no sense having these as different "models" or products, since the description is exactly the same for all the clubs in the set with the exception of the individual club loft. The individual clubs within the model type are differentiated by attributes. In addition, attributes can add costs to a given club - for instance if they order a graphite shaft instead of a steel shaft, or a different grip than what comes standard, there is usually an increased cost. These would still qualify as multple clubs within the same model, so the discount would apply. In this case, they would still get a $5 reduction in the cost per club, but the cost would be higher. In this pricing model, I'm basically lowering my labor costs as they buy more clubs within one model. It's cheaper for me to assemble 5 or more clubs of the same model in assembly-line fashion than it is to build them one at a time. I pass these savings along to the customer. There is no way to do this in the online store today. I do it in the physical store, but the OSC store does not give me this option for Internet sales. I've been looking at your discount module as a place to start here, but it seems that it comes up short as well. -t
  24. I did not have any problem getting the contribution to install - though I had to modify a bunch of files for the 11/11/02 snapshot. The problem I had was the text attribute is simply static text and not editable. I'm not sure what a static attribute is worth, but I'm sure there was a reason for it in the first place. I'm going to play with making it an editable attribute... -t
  25. Though I have not tested exhaustively, yes the shipping does seem to get added in correctly. I'd be happy to share my integrated files with you if you would like them. I've offered them to the module author as well with hopes that he'll actually do a formal update soon. I've looked at the other contribution you mentioned, and I believe it requires a manual database update using phpMyAdmin to add text attributes to the store. I have a store administrator who is not technical so I really need to have all the features supported directly in the admin interface. Perhaps I'll learn how to add things to the admin interface and do this part as a contribution. -t
×