markThomas

OK, now on to this one... Yes, the customer is taken off the tmadocuments.com site to the myvirtualmerchant.com site to make their payments. I did find some examples of the above mentioned notification in the raw logs from the web server. Not much information in them that I can see. Is there something I should be looking for? Sounds like VirtualMerchant is not sending something back to approve and move the digital download purchase along. ??? M

That was it! Yes, the category name now appears in both baskets, the small and the large. Any chance that access to the Category name will follow to the email confirmation?( I have another thread started on that one. ) Thank you for the double check on the code. This will make some office folks happy.

Good explanation, thank you. I have located everything, made some backups, made the changes discussed above. Unfortunately, not seeing the data. I am seeing the HTML markup, but the containers are empty. I will examine the catalogue.class.php code again to see if I missed something, and post again. M

Check me on this... the previous link said And your last code snippet suggested : Putting things together: Find the function displayProduct(), where $this is assigned. Empty line next paste - $this->getCategoryData($product['cat_id']);$product['cat_name'] = $this->_categoryData['cat_name']; This should give the template code access to : $PRODUCT.cat_name Finally, I did not understand your reference here: The skin template file box.basket.php and content.checkout.php will be using $item for each item in the list. ??? Thank you so much for your expertise on this. It will save a great deal of time getting this to show the category automatically instead of backtracking into all the products and pasting the category name into the product description. M

As I understand it the Main Category is the primary category that the product is assigned to. This is the category that we are trying to show at the basket and in the email confirmations. Currently, only the product is shown in the basket. In the digital downloads, the product is the only item listed. Because the document being downloaded (= product ) belongs to a particular association (= category ), we want to have the product's primary category listed on the line above the product. EX: ----------------------------------- Thank your for your purchase. Gilbert Home Owners Association <- primary category, currently not shown in basket or reciepts Section 2314 Special Assessments document <- product purchased will be available for download .... ------------------------------------- Hope this makes sense. You have provided another link, thank you for that. However, not sure what I am looking for.

Yes, the order is left in the "Pending" state. I see the orders in the admin panel and can change their respective states there. Once I manually set the order to "Completed", the email confirmation and the download notification emails are sent. Documents are downloaded successfully from that point on. Orders are successfully being processed through the gateway ( VirtualMerchant ), we have verification on that point. If I understand you correctly, there is something that is not being sent from the payment processor?

I found some suggestions of this question in the forums, but not an answer. My site is not automatically delivering the paid-for digital downloads. I have to manually go into the orders and mark them completed and then the order confirmations are sent to the customer. I feel like I am missing something here. I have looked through the settings, the orders ... What, where should I be looking for the answer/setting? Thanks in advance. Mark

I searched around, could not find this in the forums... I would like to have the product category show up in the shopping basket, as well as the digital download documents. You would see the category listed above the product for each of the purchases. Is there a way to code this or perhaps a setting? Thanks in advance.

Thanks bsmither... the answer is no to all of the mentioned items. The documents are in pdf form, there are no sales (legal association business), we have not added any brand or manufacture information.

Thanks again for the discussion. I noticed that your last sentence sums up the heart of my clients dilemma - " just gives a false count of the number of items that are at or below the stock warning level." My client's store deals with digital documents only, for a property management company. So the stock level is really a non-issue. I have the stock level warnings turned off. However, all the documents that they provide have to be listed for all the associations, even if they are not needed or have not been created. To address that condition, I changed the "not in stock" text field to "not applicable", identifying docs that were not available, but still listed as per the state regulations. The catch is that the "not applicable" text only works with the stock levels turned on, as far as I can tell. So the stock level control has to be turned back on, creating the long list of system errors. I can not have that log filling up like that, even though the site is still working. My short list of solutions is as follows: Leave stock level controls on - set it to some enormous number. (A bit tedious now, as all the documents would have to be opened and edited.) Turn stock levels off - check the status to disable for those documents that are not available. (Not sure if the state regulations will allow that. Something about all docs must be listed, even if not available.) Leave stock levels off - find code solution to indicate that certain docs are "not applicable", something that a trained assistant could manage as the document status changes. Other - ??? Thanks for reading this far. I am sharing this information with my client to get a better idea of required listing rules. The site url: www.tmadocuments.com

OK, i was receiving the above quoted error, applied the fix as described. The line 576 error is gone and now I have another errot that looks the same, but is referencing a different line. File: [database.class.php] Line: [584] "SELECT COUNT(*) AS Count FROM cc_`cc_CubeCart_inventory` AS `I` LEFT JOIN `cc_CubeCart_option_matrix` AS `M` on `I`.`product_id` = `M`.`product_id` WHERE use_stock_level = 1 AND (((I.stock_warning > 0 AND M.stock_level <= I.stock_warning) OR (I.stock_warning <= 0 AND M.stock_level <= 5)) OR ((I.stock_warning > 0 AND I.stock_level <= I.stock_warning) OR (I.stock_warning <= 0 AND I.stock_level <= 5)));" - 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 'AS `I` LEFT JOIN `cc_CubeCart_option_matrix` AS `M` on `I`.`product_id` = `M`.`p' at line 1 Will check the code changes as described above, but it was pretty easy copy/paste.Any ideas?

Most excellent. I am tracking down the code. You guys are really quite good. Thank you.

We are having some long delays in confirmation/download emails and disappearing basket events. Checking the Sys Log I find this error repeated. Can someone translate and point me in the right direction? Database has not been altered outside of the the administrative panels. Thanks ------ File: [database.class.php] Line: [576] "SELECT COUNT(*) AS Count FROM `cc_`cc_CubeCart_inventory` AS `I` LEFT JOIN `cc_CubeCart_option_matrix` AS `M` on `I`.`product_id` = `M`.`product_id`` WHERE use_stock_level = 1 AND (((I.stock_warning > 0 AND M.stock_level <= I.stock_warning) OR (I.stock_warning <= 0 AND M.stock_level <= 5)) OR ((I.stock_warning > 0 AND I.stock_level <= I.stock_warning) OR (I.stock_warning <= 0 AND I.stock_level <= 5)));" - 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 '` AS `I` LEFT JOIN `cc_CubeCart_option_matrix` AS `M` on `I`.`product_id` = `M`.' at line 1

Great. Thank you for the prompt reply.

Hello, I am working with a real estate documents provider and we need to change the product "out of stock" wording to "not available". This is a semantic change for legal reasons. I thought I saw this someplace in the system set up, but can't locate it now. Is this a control panel change, or a code change? Where might I find the answer? Thanks in advance.