Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

spannerman

Members
  • Content count

    60
  • Joined

  • Last visited

About spannerman

  • Birthday 05/25/1968

Profile Information

  1. spannerman

    OSC-Affiliate

    Hi folks, me again. I'm having major issues with OSC_Affiliate 2.8. Basically it's not working. It was mentioned in an earlier post that the affiliate reference is not being retained when a new customer registers on the site, having followed an affiliates link (which are only showing as text links, not banners as per my earlier post). Therefore, the sale isn't being recorded against the affiliate. I have double checked the install, the codes are correct, the database has all the tables. I've applied a couple of the fixes which have resolved some of the previously posted issues except this and the banners. I notice there haven't been a lot of answers posted to this thread recently, I do hope someone can help. Regards Simon
  2. spannerman

    OSC-Affiliate

    Hi folks, I have installed OSC_Affiliate 2.8 but I can't get banners to display their images. I have read through the posts about other banner issues, but haven't found a solution - most of them refer to earlier versions of the mod. When viewing a test html page I see text links, even for the ones that should have images. If i right click and hit "Show Image" I get PHP Notice: Undefined variable: HTTP_GET_VARS in C:\Domains\osc22.co.uk\wwwroot\catalog\affiliate_show_banner.php on line 90 PHP Notice: Undefined variable: HTTP_POST_VARS in C:\Domains\osc22.co.uk\wwwroot\catalog\affiliate_show_banner.php on line 91 PHP Notice: Undefined variable: HTTP_GET_VARS in C:\Domains\osc22.co.uk\wwwroot\catalog\affiliate_show_banner.php on line 93 PHP Notice: Undefined variable: HTTP_POST_VARS in C:\Domains\osc22.co.uk\wwwroot\catalog\affiliate_show_banner.php on line 94 PHP Notice: Undefined variable: HTTP_GET_VARS in C:\Domains\osc22.co.uk\wwwroot\catalog\affiliate_show_banner.php on line 95 PHP Notice: Undefined variable: HTTP_POST_VARS in C:\Domains\osc22.co.uk\wwwroot\catalog\affiliate_show_banner.php on line 96 PHP Notice: Undefined variable: banner_id in C:\Domains\osc22.co.uk\wwwroot\catalog\affiliate_show_banner.php on line 101 PHP Notice: Undefined variable: prod_banner_id in C:\Domains\osc22.co.uk\wwwroot\catalog\affiliate_show_banner.php on line 110 PHP Notice: Undefined variable: sql in C:\Domains\osc22.co.uk\wwwroot\catalog\affiliate_show_banner.php on line 121 PHP Notice: Use of undefined constant DIR_WS_CATALOG - assumed 'DIR_WS_CATALOG' in C:\Domains\osc22.co.uk\wwwroot\catalog\affiliate_show_banner.php on line 67 I have turned on debugging but don't even get the debug code. Anyone have any ideas? Regards, Simon
  3. spannerman

    Seperate Pricing Per Customer v3.5

    Many thanks. Am merging the code now, will let you know if I get it right! Regards, Simon
  4. spannerman

    Seperate Pricing Per Customer v3.5

    Hey Jan, Thanks for the reply, most helpful, but just to clarify the theory since there are quite a few files with this sort of conflict (and to help others with the same situation); I am to use the $_Session lines from SPPC 4.2.0 to test the status of the logged in user but use the queries from the Hide Products contrib, that check for whether the user is in a group that the product is hidden from. I must also ensure that the $_Session lines are above the query, otherwise the session info can't be used by the query - correct? Once again, many thanks for your input. Regards, Simon
  5. spannerman

    Seperate Pricing Per Customer v3.5

    Hi folks, Have just installed SPPC4.2 on rc1 but having issues installing Hide products & categories 2.0.2. The Hide Products mod seems to be built on ms2 files and am getting rather confused, even though the SPPC 4.2 has some code (which I have merged) ready done to support the Hide Products contrib. Has anyone installed both of these on rc1 (a clean install, not an upgrade) successfully and if so what do I need to watch out for? Any help greatly accepted. I know this is a little vague so here are some code snippets to illustrate: This is the code at the top of Product_info with SPPC 4.2 installed: require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO); $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_check = tep_db_fetch_array($product_check_query); // BOF Separate Pricing per Customer if (isset($_SESSION['sppc_customer_group_id']) && $_SESSION['sppc_customer_group_id'] != '0') { $customer_group_id = $_SESSION['sppc_customer_group_id']; } else { $customer_group_id = '0'; } // EOF Separate Pricing per Customer ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> and this is the code for the Hide Products for SPPC contrib: require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO); // BOF Separate Pricing Per Customer, hide products and categories from groups if(!tep_session_is_registered('sppc_customer_group_id')) { $customer_group_id = '0'; } else { $customer_group_id = $sppc_customer_group_id; } $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0"); $product_check = tep_db_fetch_array($product_check_query); // EOF Separate Pricing Per Customer, hide products and categories from groups ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> Do I need to use the lines that have the Left Join SQL code or do I use the code from the SPPC 4.2 for rc1? I also have QTPro and the OSCAffiliates contribs installed and plan on using some logic to tie them all together once they are installed and working. Once again, all help appreciated! Regards, Simon
  6. spannerman

    excel-import

    It looks like you do need Easy Populate for that particular contrib. I use Excel, but save the file as CSV and use phpMyAdmin to import the CSV file directly into the database. Takes a little getting used to but here's my method and a couple of things to watch out for: 1) Export the table as CSV from within phpMyAdmin, choosing to include the field headings as top row - that way you get the structure you need to fill in 2) Open the exported file in Excel & fill in the values you require:- Points to watch for during this: dates need to be cell formatted as yyyy-mm-dd. if it says NULL in the table add NULL to corresponding rows, don't just leave it blank. if you're doing an update to add to the table make sure that the first column starts with the next number in the Auto_update sequence or you'll get duplicate index problems. if your text (product descriptions for example) contains commas or quotes they need to be "escaped" - precede each with a \ ( eg don\'t ) for two reasons i) a comma will make the import think there are more fields than there really are. ii) an unescaped apostrophe where there shouldn't be one breaks the PHP code, since it's used to enclose elements of that PHP. It will import but you'll have problems! 3) Save the file as xls as a backup - you may have made mistakes regarding syntax etc which will throw errors when you try to import. 4) Delete the top row completely, don't just empty it. 5) Save the file as CSV (I save as Products_attributes_import.csv for example, so I don't import the file I've just exported!) - comma separated value for those that may not know. Each value (eg product) is on a single row with all the fields separated by commas - Excel will warn you about this format but click ok. 6) In phpMyAdmin go to Import and choose the file you saved to import. Select CSV and more options will appear. Tick "Replace Table Data With File" if you wish to overwrite all the contents of the table, if it's an update you're doing then don't. Change "Fields Terminated By" to a comma Hit Go! You should be presented with a statement at the top of the page saying Success and how many rows were updated. If you get an error then go back to the CSV file and fix it. Don't know if you'll use this method, but there it is! I have a heavily modified shop so this works for me, you may well find that installing Easy Populate does the job! Regards, Simon
  7. I have just uploaded changes and files required for rc1. Installed and tested on a clean installation of rc1. I have also included a New News button for the Affiliate admin area. Instructions are included but the path info got a bit confused in the post. For reference: Upload affiliates_summary.php to admin\includes\modules\index folder. Make currency code change to index.php as listed in the Instructions file - INSTALL_ENG_22RC1.txt No other changes needed to index.php As an aside I've made a New News button as well, since it seems to be missing from the contrib. This needs to be uploaded to catalog\admin\includes\languages\english\images\buttons I only did an English version I'm afraid! Hopefully this will help folks out using rc1. Regards, Simon (I meant to add this to the OSCAffiliate thread - my bad! If an admin could move it to where it belongs please!)
  8. Hi folks, Anyone had this problem? I installed CCGV(Trad) ages ago and never used it. Folks just haven't bought gift vouchers from us! We have just sent out a newsletter with a discount code and visitors to the site are using the code as intended, but, the totals are working on the base product price rather than the final price when attributes that + or - the base price are used. For example: Base price is £15. Kids T-Shirts are base - £2 @ £13, Hoodies are base + £10 @ £25 etc etc. A 5 garment order of mixed items is discounting 5 x £15, rather than the attribute adjusted "final_price" values. As I ask, has anyone else had this problem? I do have a very heavily modded cart (it's been online nearly 5 years now) and it's very possible it's something unrelated to CCGV, but I thought I'd ask the question anyway. TIA, Regards, Simon
  9. spannerman

    Wishlist 3.0 Support Thread

    Quick PS since I can't edit the above post anymore! Must also add that I have a VERY heavily modded site - it's been online over 3 years now - 30+ mods plus hand hacking by me! (I can't call it coding coz I'm a script butcher!) , so it's possible that conflict with another mod caused the original problem that the fixes in the thread didn't sort out!
  10. spannerman

    Wishlist 3.0 Support Thread

    Hi Dennis and all other Wishlist users! Had a problem with the "call to member function on non-object" issue, even after replacing the Step 11 install code and changing all the L's to l's and any other fixes listed here in this thread. Happened when I called the Wishlist box in column_left.php (I don't have a column_right on my site!) with the original code. This happened when I followed the link supplied in a Wishlist email. Prior attempts seemed to be working ok, but I now put that down to page caching, existing sessions etc etc. Fixed it as below in column_left.php (or in column_right.php - depends where you call the infobox up), by simply commenting out the call to the function but still 'requiring' the Wishlist box :- // Wish List 3.5 Start //if($wishlist->count_wishlist() != '0') { //require(DIR_WS_BOXES . 'wishlist.php'); //} require(DIR_WS_BOXES . 'wishlist.php'); // Wish List 3.5 End This makes the Wishlist box show on the page below the shopping cart info box, whether the user is logged in or not and whether the user has anything on the wishlist or not. Shows '0' items if the user is new or not logged in, but I feel that is a reminder to users that they can use the Wishlist! I know it's a workaround and not the way Dennis wrote the code to work, but if it helps...... Respect to all the folk that actually write these contribs!
  11. spannerman

    Category Discount

    Hi Amanda, Lori and all other Discounters! A great contrib that has solved a particular problem that I've been struggling with for ages! I'm using the QVB version, working fine in the main cart, but am having problems getting the Shopping Cart Infobox addon to work. I've been through the posts and have been trying to work out what code goes where, without much success. The discount does appear right at the top of the Shopping Cart IB but the info box changes to full with with Times New Roman at 10 or 12 point font. This obviously isn't right. I also have Amanda's great CCGV(Trad) installed. Could there be a conflict? The posts mention a change in Application_top, but what change is this exactly since I haven't applied that? My shop is heavily modded so if anyone needs to see any of the files please let me know. Any help much appreciated. Regards Simon
  12. spannerman

    Easy Discount

    Hello Amanda and all others who use Easy Discount, I wonder if you could possibly help me with a few pointers as to where to start with the logic required to give the discount I need on my store. The case is this: Have installed Happy Hour Specials mod which allows an item to be discounted by setting a specials price on a timed schedule. I am going to load the HHS table with 313 items, each to be discounted for 24 hrs (48 in the case of a weekend). The site will then set the "Design of the Day" as a Special, automatically discounted by £2. All our products have a base price of £15, with ordinary osC modifiers for variations in price. What I also require is that if a customer buys the "Design of the Day" (valid only on that day of course) they get another £2 off 1 other item added to their cart. Reading through this thread I feel that the logic would be along the lines below but how to start writing the code for it? I apologise, but I'm not a programmer, I'm a script butcher! I can cut 'n paste with the best of them! Logic: 1) Check if there's anything in the cart. 2) See if what is in the cart is a "Special" - read from HHS Table and checked for date - set a variable saying "DOTD Purchased" = True 3) Check for other items in cart - "If $cart count > 1" 4) Apply £2 Discount via ED to subtotal. "If DOTD Purchased" = True then apply discount. I would also assume that I need the code for steps 1, 2 & 3 in application_top so it's always evaluated, since they can add the Special to the cart at any time during their visit, then the code for step 4 in Shopping_Cart.php to apply the discount. Am I on the right lines for this and where do I start?? We show all prices including Tax so Tax calculation not required. We offer free shipping within the UK, and fixed price shipping addition to ROTW so that is not an issue either. We also offer Volume discount and Customer Loyalty discount but since the discount I want to offer is a fixed £2 and not a percentage, that shouldn't be an issue either. Any help much appreciated. Simon
  13. If anyone is following this particular line of modification I started the process the other night and have found it's far more complicated than I originally thought! Problem lies with where QTPro checks for attributes - basically it does the lookup several times through the checkout process and telling the system that it's Product_ID (x) for quantity etc but attributes from Product_ID (0) is turning into a nightmare. One thing it does is change from products_attributes to orders_products_attributes at some point, where exactly I'm trying to find at the moment. If anyone can shed light on the sequence of events in OSC so I can see where to look to make the changes I'd appreciate it.
  14. Hi Ralph and other QT Pro experts! Happy New Year to one and all and thanks to Ralph for a great contrib! I've been using QTPro for quite a while now, it solved a problem I originally had but I've been thinking about the way it works. My issue is that we have 2500 designs that can be printed onto any of 10 garments, some of which come in 12 colours and a range of 8 sizes - 58 attribute combinations! The way the Store is built, each of the designs is a product, with the size, colour and garment type as attributes. Basically there are 826 combinations for each of 2500 designs - this creates a products_stock table of about 1.7 million records! I populate this with about 50 csv files with 30,000 rows each. Although I have a macro that writes the csv's, the actual population and control of products_stock is quite an epic, as you may well understand. Now, my thoughts on this are : Since the stock control and indeed attributes for each of the 2500 products is identical, is there a way of populating products_attributes and the related tables with 1 set of attributes - say for product_id = 0, and then do the same for products_stock, again for product_id = 0. Then, could the code be changed to call the attributes for product_id = 0 and therefore the related stock listing for product_id = 0 from products_stock? This would reduce my attributes table and products_stock table drastically!! Any thoughts on whether this would work and how to do it - where in the QT Pro mod I would need to change "products_id = products_id" to "products_id = 0" (hardcoded) etc would be most appreciated! Regards, Simon
  15. spannerman

    Mod to make attributes depend on each other?

    QT Professional mod works very well
×