Jump to content

sean_nerd

Members
  • Content count

    28
  • Joined

  • Last visited

Profile Information

  • Real Name
    sean
  • Location
    Toronto, Ontario, Canada
  • Website
  1. sean_nerd

    [Contribution] STS v4

    Hi folks, I hate to dredge up an old post that works for everyone else but.. it's not working for me! I've gone as far as to remove the first "<?php echo HEADING_TITLE; ?>" completely from the catalog/index.php page in order to prove to myself that i'm in the right place, and still the "Let's see what we have here" shows up when i click on a category link in my catalog. I've also removed the image link in the cell beside it, with the same result. I then decided to be extra-sure and deleted index.php from my site, refreshed the page and got a 404, then uploaded the modified file again and still - "let's see what we have here" shows right up when i'm on a category page (eg: /catalog/index.php?cPath=42) any thoughts on where i'm going wrong? It seems pretty clear below, but by removing these entries I have to believe that the variable is being pulled from somewhere else besides /catalog/index.php. thanks for any insight you might be able to provide, Sean
  2. sean_nerd

    Attribute Product Codes [Contribution]

    It's definitely worth a lot more than "some use" to me! w/o this contrib, I just might have lost a client as well as a couple of weeks' development! Great stuff. BTW you might want to re-check your SQL since there doesn't seem to be a need for the suffix field in the orders_products_attributes table, since it's never been populated on mine. perhaps you had to do that on yours due to a different contribution you're using? thanks again
  3. sean_nerd

    Attribute Product Codes [Contribution]

    It's worth pointing out that the suggested code above to remove the separating slash in the final output works perfectly. thanks, Rochdalemark - great work.
  4. sean_nerd

    Attribute Product Codes [Contribution]

    Sorry for the double post - the Net is dodgy here today. For the record, the above solution fixed my problem 100%, I was mistaken and had edited it in the open instructions file, and not the actual PHP! LOL too funny. The code_suffix still does not populate or seem to get used at all in the orders_products_attributes table. --and it doesn't seem to matter? I don't see why I would need to understand that, but I'm dying to know why. ;) Thanks sean
  5. sean_nerd

    Attribute Product Codes [Contribution]

    Yup that's all there but while going over the install instructions again we noticed this: ############################################################# ********** In catalog/admin/includes/classes/order.php ***************** Find: around line 80 $orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'"); while ($orders_products = tep_db_fetch_array($orders_products_query)) { $this->products[$index] = array('qty' => $orders_products['products_quantity'], 'name' => $orders_products['products_name'], 'model' => $orders_products['products_model'], 'tax' => $orders_products['products_tax'], 'price' => $orders_products['products_price'], 'final_price' => $orders_products['final_price']); Change to: $orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'"); while ($orders_products = tep_db_fetch_array($orders_products_query)) { $this->products[$index] = array('qty' => $orders_products['products_quantity'], 'name' => $orders_products['products_name'], 'model' => $orders_products['products_model'], 'code' => $orders_products['products_code'], 'tax' => $orders_products['products_tax'], 'price' => $orders_products['products_price'], 'final_price' => $orders_products['final_price']); There is no "products_code" statement in the initial query, but there is in the subsequent array. We added it into the query as such: $orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_code, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'"); while ($orders_products = tep_db_fetch_array($orders_products_query)) { $this->products[$index] = array('qty' => $orders_products['products_quantity'], 'name' => $orders_products['products_name'], 'model' => $orders_products['products_model'], 'code' => $orders_products['products_code'], 'tax' => $orders_products['products_tax'], 'price' => $orders_products['products_price'], 'final_price' => $orders_products['final_price']); But unfortunately it hasn't helped yet. We've also found that while my orders_products_attributes table has a "code_suffix" column, there are no code suffixes that have actually made it in there. We're looking for that insert statement now. Just wanted to give an update on the above sql statement while I was still thinking of it. Sean
  6. sean_nerd

    Attribute Product Codes [Contribution]

    Yup that's all there but while going over the install instructions again we noticed this: ############################################################# ********** In catalog/admin/includes/classes/order.php ***************** Find: around line 80 $orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'"); while ($orders_products = tep_db_fetch_array($orders_products_query)) { $this->products[$index] = array('qty' => $orders_products['products_quantity'], 'name' => $orders_products['products_name'], 'model' => $orders_products['products_model'], 'tax' => $orders_products['products_tax'], 'price' => $orders_products['products_price'], 'final_price' => $orders_products['final_price']); Change to: $orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'"); while ($orders_products = tep_db_fetch_array($orders_products_query)) { $this->products[$index] = array('qty' => $orders_products['products_quantity'], 'name' => $orders_products['products_name'], 'model' => $orders_products['products_model'], 'code' => $orders_products['products_code'], 'tax' => $orders_products['products_tax'], 'price' => $orders_products['products_price'], 'final_price' => $orders_products['final_price']); There is no "products_code" statement in the initial query, but there is in the subsequent array. We added it into the query as such: $orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_code, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'"); while ($orders_products = tep_db_fetch_array($orders_products_query)) { $this->products[$index] = array('qty' => $orders_products['products_quantity'], 'name' => $orders_products['products_name'], 'model' => $orders_products['products_model'], 'code' => $orders_products['products_code'], 'tax' => $orders_products['products_tax'], 'price' => $orders_products['products_price'], 'final_price' => $orders_products['final_price']); But unfortunately it hasn't helped yet. We've also found that while my orders_products_attributes table has a "code_suffix" column, there are no code suffixes that have actually made it in there. We're looking for that insert statement now. Just wanted to give an update on the above sql statement while I was still thinking of it. Sean
  7. sean_nerd

    Attribute Product Codes [Contribution]

    Update: Well it seems that I do have a problem. My product codes (model numbers) etc are not showing up in my final invoice or packing slips. Yikes! Will investigate further but if you have any thoughts on why they used to work but no longer work (now that i've added attributes to each product in my inventory) maybe when I return to my desk you will have suggested a good starting point to figure it out! this is a useless post I guess. sorry. will update in a few hrs. sean
  8. sean_nerd

    Attribute Product Codes [Contribution]

    Hi Rochdalemark, I actually don't have any troubles with my test site, was just wondering about the separator. How would you go about "removing" the separator altogether? It seems that it's necessary for your contribution to separate the attributes from the product's base SKU but i'm wondering if some type of regular expression replace PHP trick might work to get it out of the final output to the user, as well as to the store owner. All of her SKU's are set at the manufacturer level, and since her business has been running (offline) for so long, I would hate to have her have to change her system for this. She's willing to live with a dash instead of a slash, but is there an easy trick to get rid of it? While I'm here: How is everyone else dealing with stock levels for specific SKU's? As far as I can tell, I can add stock levels for the "main" sku, but not for each of the sizes that I add with this contribution. Are there plans to add a stock level to this contrib in the future? Thanks for a great contribution! Works like a champ. Sean
  9. sean_nerd

    [Contribution] STS v4

    completely different issue from my $content question: $reviewsbutton$ on a product_info.php.html page is showing the button nicely, but it isn't actually forming a link to the reviews page. Should I be adding my own $reviewsurl$ to the code for it to actually be a proper working link? thanks!! sean
  10. sean_nerd

    Attribute Product Codes [Contribution]

    worked like a champ, thank you! Another question while I'm here: Is it possible to remove the slash in the final output from this contrib? I went over the install text again and it seems to me that the slash is there to let the system separate Product Sku's from Attribute Sku's when you do the final pull from the DB, but i'm not 100% sure. I'd love to remove it altogether, but I will settle for changing it to a dash (-) instead. is this possible? --more importantly how easy is it? ;) I suspect that the code that needs changing is in the "separator" area of the following code, but my store is fragile enough that I'm not willing to try in case it breaks! $specials_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int)$prid . "' and status = '1'"); if (tep_db_num_rows($specials_query)) { $specials = tep_db_fetch_array($specials_query); $products_price = $specials['specials_new_products_price']; } $attribute_code_array = array(); if (is_array($this->contents[$products_id]['attributes'])) { while (list($option, $value) = each($this->contents[$products_id]['attributes'])) { $attribute_code_query = tep_db_query("select code_suffix, suffix_sort_order from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$prid . "' and options_id = '" . (int)$option . "' and options_values_id = '" . (int)$value . "'"); $attribute_code = tep_db_fetch_array($attribute_code_query); if (tep_not_null($attribute_code['code_suffix'])) { $attribute_code_array[(int)$attribute_code['suffix_sort_order']] = $attribute_code['code_suffix']; } } $separator = ''; if (count($attribute_code_array) > 1) { $separator = '-'; } elseif (count($attribute_code_array) == 1) { $separator = '/'; } $products_code = $products['products_model'] . $separator . implode("/", $attribute_code_array); } else { $products_code = $products['products_model']; } $products_array[] = array('id' => $products_id, 'name' => $products['products_name'], 'description' => $products['products_description'], 'model' => $products['products_model'], 'code' => $products_code, 'image' => $products['products_image'], 'price' => $products_price, 'quantity' => $this->contents[$products_id]['qty'], 'weight' => $products['products_weight'], 'final_price' => ($products_price + $this->attributes_price($products_id)), 'tax_class_id' => $products['products_tax_class_id'], 'attributes' => (isset($this->contents[$products_id]['attributes']) ? $this->contents[$products_id]['attributes'] : '')); Any help is most appreciated! thanks sean
  11. sean_nerd

    [Contribution] STS v4

    Thanks for the tip, Bill - but I'm not sure if you're following my question. I'm only assuming this because you mentioned the $content STS tag above. It's the $content that I want to change - for the category view. Maybe I'm not using the right terminology? The page displaying the content I want to change is index.php and it's showing the list of all the products in a given category (cpath=42). I want to change this table, so I figured i had to have an index.php file in the content folder to change the content for this particular page. Putting an index.php_42.html in my root template folder is almost what I want but not really since it doesn't alter the $content for that page, and just forces the template on everything except the content. I suspect my only option is going to be CSS, but I'm hoping that you can tell me I'm wrong! Thanks for your continued assistance! Can't wait to send you a final link when it's done. Sean
  12. sean_nerd

    [Contribution] STS v4

    Hi Bill, this is a great post! One question: I've managed to sort out just about everything but I can't figure out what to name the content page that will show the list of "all products" in a specific category. --you know, the page we're brought to when you click on a category, but before you drill down into any of the specific products. I've tried calling it index.php_42.html (42 is the category cpath) and putting it in the content folder but no luck. Maybe I need a category template before I can have category specific content? (tried this but didn't work either). I'm sure that i'm just confused about the file name. When I do get it to work, should I be using the same variables that I've used for my product_info.php.html template? Everything else works beautifully, I just can't seem to figure out the proper naming for this output. thanks for all your help! Sean
  13. sean_nerd

    [Contribution] STS v4

    I know I'm replying to an old post but it's quite helpful, and I'm almost there! What i'm looking for is how to make a template for the full-up category display. eg: i click on a category link and am presented with a table of all the items in that category. I can't seem to figure out how to alter this output in any way other than css. I'd like to template this page too, but with OSC using index.php for this task, the attempt below is all that I can come up with that suits the usual rules governing the template specifics. I have tried the following: Since my category link is /index.php?cPath=42 I've created an index.php_42.html page in my /sts_templates/mytemplate/content/ folder but this doesn't seem to take. I have also tried putting an index.php_42.html page in the root template directory but of course that's just altering the template and not the $content, so no luck there. I'm sure i'll feel like a dummy after I figure it out - but can anyone help speed up that 'feeling like a dummy' process? Thanks sean
  14. sean_nerd

    Attribute Product Codes [Contribution]

    I have the same issue, but I don't understand your explanation here. Is this an answer or a thought/comment? should I use 0? 1? etc? Sorry, i'm a mysql GUI kind of guy, not too good with syntax just yet. seems to me that int(11) is asking for room for an 11 digit integer - I don't understand how this is a string. either way, this sql is not working and i'd sure love to fix it! thanks
  15. sean_nerd

    [Contribution] STS v4

    Followup to my earlier issue: Unfortunately I am still unable to get any of the included template infoboxes or any that I create to work with the infobox template system. To recap: I've uploaded all new files, and no matter what I do, when I set the "full" template that comes with STS to "true" (infoboxes) the green border around the information box is nowhere to be found. I've done a lot of thinking and poking around and have come to the conclusion that this problem absolutely cannot be: 1) css related -it can't be related to CSS -- the table background for the information infobox template is clearly set to green table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#00FF00" style="border-collapse: collapse" bordercolor="#111111" in the HTML template. I can't even FIND a CSS file that came with the template, so it must be using the default "catalog/stylesheet.css", which would obviously have nothing to do with an STS demo information infobox having a green border. So I have to scratch CSS as the problem, this is very clearly not it. :( 2) my template's problem -It does not work on the "full" included STS template, before I've even turned my template on. So I'm stopped cold before I even get a chance to try my own template - if it doesn't work with the included example, I certainly can't expect it to work with mine! Not being a full blown OSC guru, I'm happy to admit that I may be wrong. Just the same, I have come up with a suggestion that this probably is caused by: 1) me missing one little line in the installation of STS -where can I find the code that is supposed to determine whether the "true" for infoboxes has been set or not? The only conclusion that I can come to now is that i've missed one step on installing STS and that was the step that made this feature work. Obviously everyone else has this working for them - at least those of you who want it working. This comes "built in", right? then what could I have done to prevent this from working, especially when the rest of the template in question (full) works flawlessly? Please, any suggestions would be most appreciated as I am completely stumped here. "It just doesn't work." I haven't made any changes to OSC other than to add in a Canada Post Shipping module, a Moneris CC payment module and a PO#/credit module. no design changes, no code changes other than installing these, and STS of course. Thanks for any suggestions you might have folks, I really really really really don't want to have to go and edit OSC's crazy HTML manually. Isn't that why we all installed STS in the first place? :) sean
×