bsmither

In the file /language/en/lang.inc.php, at about line 1585, find: 'admin_email_body_1' => "Dear CubeCart Store Administrator, That line and the next 30 or so is the string for the main part of the e-mail sent to the store administrator. If you don't want the email that is sent to the store administrator to start with "Dear Store Administrator," this is what you need to edit. Do NOT change the number of %s variable place holders.

You said, "When I search for the product from Admin, it doesn't come up." Might you be using the filter box labeled "containing the text"? You said, "Yes [to having made the change to the SQL] and nothing shows up." By "nothing" I hope you mean that there is, in fact, a list of products displayed in the Administrative (View Products) Product Inventory page, except that you can't seem to find your "Stars & Stripes Suspender Teddy" (Product Code: EM-7137, Product ID: 1036) when paging through the list. How did you determine that the rhinestone bikini had a primary category?

Did you modify the file as suggested above. I ran some experiments and the Product Inventory will show ALL products in the inventory database (prior to any pre-filtering via the selection boxes at the top) regardless of anything else. After this change to the SQL statement, my experiments would suggest that if a product is showing up anywhere on your site AND still not showing in the Product Inventory page, then it might be getting imported from a different database.

How did you get "Sale Items" in the "Other Products" box?

in the file, /includes/content/gateway.inc.php, at about line 215, find: ######################################### ## Admin E-Mail Fix by Sir William -- http://www.swscripts.com/ // notify shop owner of new order Continue scanning the lines of code until you see at about line 269: $mail->setText($text); // uncomment the following two lines to have the order message come from customer // $mail->setReturnPath($ccUserData[0]['email']); // $mail->setFrom($ccUserData[0]['firstName']." ".$ccUserData[0]['lastName'].' <'.$ccUserData[0]['email'].'>'); // uncomment the following two lines to have the order message come from store admin $mail->setReturnPath($config['masterEmail']); $mail->setFrom($config['masterName'].' <'.$config['masterEmail'].'>'); This is what you need to change. Put a pair of slashes (//) in front of the bottom two lines of code that begin with $mail and remove the pair of slashes from the two lines near the top that begin with //$mail.

You know... I got to thinking. This Mysty person seems to have all the screws tight between the headsets, and would have looked at the Product Inventory pages already. So what else could be the problem? I've just discovered that the Admin, Product Inventory page will also not display products that are not assigned a primary category. In the file, /admin/products/index.php, find: if(isset($_GET['category']) && $_GET['category']>0){ if(isset($like)){ $whereClause .= " AND "; } else { $whereClause .= " WHERE "; } $whereClause .= $glob['dbprefix']."CubeCart_inventory.cat_id = ".$_GET['category']; } $query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_inventory INNER JOIN ".$glob['dbprefix']."CubeCart_category on ".$glob['dbprefix']."CubeCart_inventory.cat_id = ".$glob['dbprefix']."CubeCart_category.cat_id ".$whereClause." ORDER BY ".$orderBy; } Change the "INNER JOIN" to "LEFT OUTER JOIN". That should return all products and give a NULL category to those with no assigned category. See what happens.

I haven't looked at "fixcatcount" yet, but by the sound of its filename, I think it's not designed to fix this problem. Let's compare the two SQL statements. We need to find the reason why a product not assigned to a category is showing in that category, and then why, when clicking on it's link, the product page tells us that it doesn't exist. __View Category__ SELECT CubeCart_cats_idx.cat_id, CubeCart_cats_idx.productId, productCode, quantity, description, image, price, name, popularity, sale_price, stock_level, useStockLevel FROM CubeCart_cats_idx INNER JOIN CubeCart_inventory ON CubeCart_cats_idx.productId = CubeCart_inventory.productId WHERE CubeCart_cats_idx.cat_id = $catId; In the Category page, we are asking for a set of records where, for a specific category, only those products whose productId is found in 'cats_idx'. You can have your product belong to more than one category. So, product 1769 can belong to categories 78 and a primary category (the number of which is difficult to discern from rendered pages). __View Product__ SELECT productId, productCode, quantity, name, description, image, noImages, price, popularity, sale_price, stock_level, useStockLevel, digital, digitalDir, CubeCart_inventory.cat_id, cat_father_id, cat_name, cat_image, per_ship, item_ship, item_int_ship, per_int_ship, noProducts FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId = $productId; In the Product page, we are asking for a set of records where, for a specific product, only those products whose primary category is found in 'category'. Suppose the primary category doesn't exist? Product not found! By primary category, I mean that category the product was assigned to when it was created or changed to when the product is edited. So, odds are likely that product 1769 exists in the 'inventory' table, but there is no corresponding primary category in the 'category' table. As my store does not show this behavior, the following is a good guess as to how to fix it without manually editing the database tables directly: Find the product in the Admin, View Products page. From there, in the Master category column, observe whether a category is listed. Then click the "Manage Categories" link. In the window that pops up, click the "Remove" link for any and all categories you do not want the product to appear in. If I'm right, category 78, "Sexy Costumes," will be listed with an action to Remove. Do so. Now, back at the Product Inventory page, in the Action column, click the Edit link and assign it to its appropriate primary category. Let us know how it turns out. Oh, by the way, there are a couple of other products on that same category page that have the same problem. So, on the Admin, Product Inventory page, if other products do not list a primary category, fix those, too.

Testing on a local computer? Do you have a static IP? A domain name? I don't know if that makes any difference, though.

Are you subscribing to PayPal using an other than straightforward eCommerce account? (I'm just making a stab in the dark as I'm not familiar with the actual gateways themselves.) What company is hosting the space for your store? GoDaddy?

Probably _blocker and _spambot. But I'm not 100% sure. My answer is based on threads I've read here about various MySQL errors popping up after an improper upgrade to 3.0.15+.

Ok, so the left column needs to look differently than the right column? In the file /skins/Legend/styleSheets/layout.css, there are sets of CSS selectors that are grouped together: .boxTitleLeft, .boxTitleRight .boxContentLeft, .boxContentRight You will need to split these apart and style each as desired. Also look at .colLeft and .colRight for dimensions and stuff.

In /includes/content/gateway.inc.php, there is code that will send the shop owner an email just as the customer enters step 5. In /includes/orderSuccess.inc.php, there is code that will send the customer an email if the gateway says the order was transacted successfully.

Google for "Email Template System" by Alon Kobets. I use it and it's great.

It's not a real category in the sense that you can't "assign" a product to it. It appears when 1) you have a product that has been given a "Sale Mode" price, and 2) the store is in "Sale Mode". That 'category' page looks no different than any other category page (except for the "Featured Item" box - it is switched off). Where do you want this text that is to appear only on the "Sale Items" page? In the file: /includes/content/viewCat.inc.php, at around line 156: } elseif($_GET['catId']=="saleItems" && $config['saleMode']>0) { ... } else { Within this section, add: $view_cat->assign("MY_CUSTOM_TEXT",your text or something from the $lang arrays); Then in the file: /skins/Your_Skin/styleTemplates/content/viewCat.tpl, try to figure out where you want the text to be and add {MY_CUSTOM_TEXT}.

Regarding the filesizes of the images that are currently attached to products versus the filesizes of the images that won't attach, how do they compare?

Did you add that picture into the database manually, or did you just coincidentally add it while you added the description on the Product Edit page and it worked? If the former, now we need to figure out why the image isn't getting added to the database from the Edit page.

Depending on the skin: For Legend, the columns float in the file: /skins/Legend/styleTemplates/global/index.tpl <div class="colLeft"> {CATEGORIES}{RANDOM_PROD}{INFORMATION} {CURRENCY}{LANGUAGE}</div> <div class="colMid"> {PAGE_CONTENT}</div> <div class="colRight"> {SHOPPING_CART}{POPULAR_PRODUCTS} {SALE_ITEMS}{MAIL_LIST}</div> For Killer, the columns are in a table in the file: /skins/Killer/styleTemplates/global/index.tpl <table><tr><td width="175"> {SHOPPING_CART}{INFORMATION} {CURRENCY}{LANGUAGE}</td> <td>{PAGE_CONTENT}</td> <td width="175"> {RANDOM_PROD}{POPULAR_PRODUCTS} {SALE_ITEMS}{MAIL_LIST}</td> </tr></table> Just move all the placeholders into the left/right column, then delete the column you don't need.

I also see there is no description for PW-1. If you add one (and update the product edit page), then take another look at this table, is the description added to the table? Then, allow me to ask, what are some of the filenames that you have FTP'd to the upload folder? Do any have spaces in the names? Do any have international characters? And what happens if you manually add an image's filename into the database via phpMyAdmin?

For the Killer skin, isn't that where they are by default? In the file \skins\Killer\styleTemplates\global\index.tpl of a stock distribution of CCv3, the placeholder {SITE_DOCS} should be located between the last two </div> tags.

I would ask that you look at the whole and complete table, not a report that lists "Distinct Values". I need for you to see that for a specific product that there exists in that same record a filename in the image column. So, for example, a product whose productId is 4, and the productCode is RM, and the quantility is 100, and the description is "a bag of 100 red marbles", and the image is "redmarbles.jpg". I need for you to see all that, for all your products, in the inventory table.

You upload them via FTP to the "images/upload/" folder. Good. But then, in the Product Edit page, you need to assign or attach one of those images to the product. The message "Failed to update" is bit harsher than it needs to be. It actually means, "You did not make any changes that required MySQL to effect an update to a record(s)." That is, whatever you thought you had changed, it still didn't require MySQL to modify any data in a resultant recordset. Either the WHERE clause returned a zero-count recordset, or a recordset was returned but no data actually changed from what it was before. In your database, inventory table, image column, are there any filenames here?

Find the epoch time number for the current time (I think time(); will return that number). Then, you or your client should log in to the admin section. That will log an admin access in the database. Then examine the database, 'admin_sessions' table. If there are less than 250 entries, look for the last and compare the value in the time column. It should differ by only a few.

Take a look at your actual database, at the inventory table. Are there any filenames in the 'image' column? Hint: use phpMyAdmin to view your database unless you know how to use another method. The viewProd code makes a simple test: if there is something in this field (not empty), then use that as the path/file to show as an image: "images/uploads/name_of_picture_in_database" The test for empty may be a bit more than expected: -a zero-length string -the integer value zero -the string "0" (ASCII 0x30) -the value NULL -the value FALSE -an array with zero elements What are some of the image names as found in the 'image' column of your inventory database?

If you can find the array of options, you can insert the array into the php "natural sort" function: natsort($optionArray); It will get you what you want.

It seems the RandomProd box will pull a random product from all products assigned to the primary category that is equal to the category of the page you are viewing. So, for example, "Natural Baby" is catId=27. When I click on the product "Natural Baby Comforter - Zmooz", I get to that product's page, and the breadcrumbs say, "/Baby Comforters/Baby Comforters - Organic", which is catId=5. Since there are no products whose primary category is catId=27, there is nothing to show in the box, and the box is not deployed. If you don't care from which (primary) category a "We Love" product is displayed, change in the file: \includes\boxes\randomProd.inc.php if(isset($_GET['catId'])){ $whereClause = "WHERE cat_id=".$db->mySQLSafe($_GET['catId']); } else { $whereClause = ""; } to // if(isset($_GET['catId'])){ // $whereClause = "WHERE cat_id=".$db->mySQLSafe($_GET['catId']); // } else { $whereClause = ""; // } You might have an Extra Categories mod and if so, you will need to contact the author to determine if a piece of that mod should have affected the randomProd content box.