[Category Products - default sort order by `in stock`, then `popularity]

Hi all,

 

Just in the process of developing my new Cubecart 5 store.

 

In my old v4 store I order category products, showing those that are in stock first. The "in stock products" are then sorted by popularity.

 

I am attempting to do this in v5.

 

I have the following query in the getCategoryProducts function (clas/catalogue.class.php):

$newQuery = 'SELECT `I`.`product_id`,
         `I`.`stock_level` 
      FROM `CubeCart_inventory` AS `I`
        INNER JOIN `CubeCart_category_index` AS `C` 
            ON (`I`.`product_id` = `C`.`product_id`)
        INNER JOIN `CubeCart_category` AS `CAT`
            ON (`C`.`cat_id` = `CAT`.`cat_id`)
      WHERE  
       `I`.`status` =1 
    	 AND (`C`.`cat_id` ='.$category_id.'
    	 OR `CAT`.`cat_parent_id` ='.$category_id.')
      GROUP BY `I`.`product_id` ORDER BY `I`.`stock_level`=0,`I`.`popularity` DESC';

This gets the products sorted correctly - in mysql - but they are then being "resorted" by Cubecart.

 

I am struggling to find where to override CubeCart's sorting function to leave this order intact!

 

I have tried removing numerous lines from getProductData() and getCategoryProducts() but no joy so far.

 

Any help would be appreciated.

 

Regards,

Chris

 

 

 

 

 

[Added To Basket message/notifcation]

The <span> has saved in the code snippet but doesn't get printed out in the gui message (viewed the page source and it is not there).

 

I am not going to worry too much about that though.

[Added To Basket message/notifcation]

Many thanks. Wouldn't have figured that one out myself!

 

It still won't allow the <span> part but the link was the main thing.

[Added To Basket message/notifcation]

Sorry, still on this subject, does anyone know if (or how) you can include html in the setNotify message?

 

Everytime I include html in the code snippet it get's stripped back out.

 

e.g. (this is want I would like):

{php}

if (isset($_POST['buyproduct'])){
  	
$GLOBALS['smarty']->assign('ADDED', "Product added to <a href='basket'>basket <span class='glyphicon glyphicon-cart'></span></a>");

}
{/php}

[Retail Electronic Point of Sale system - tie-in with Cubecart?]

The web API would basically do the "talking" between CubeCart and your Epos software, to ensure everything is in sync.

 

I am currently building something similar with a Microsoft Access till/management system. (I have just managed to get it to download the sales at a click of a button)

 

Would be interested to hear if you find any good software "off-the-shelf" though.

[Need Different Metadata for ?page=all]

Would the best option be to change the canonical urls for each category page to either the first page or the view all page?

 

I am addressing this in my new Cubecart 5 store now.

[Added To Basket message/notifcation]

Thank you. I just added this snippet (with the trigger: class.cart.add.preredirect):

{php}

$message ="Product added to your basket.";

$GLOBALS['gui']->setNotify($message);

{/php}

All works and means no modifcation of the Cubecart code either, which is good.

 

Another job ticked off my list. Lots to go though!

[Added To Basket message/notifcation]

Cheers Bsmither for the clarification.

 

The skin is a custom one I am building for my own shop. In my old store, the add to basket message appeared at the top of the central column (when a product is added to basket on the product or category pages).

 

In my new store - built on Bootstrap - I will either have a pop-up modal box (like ModsIndex has done) or a dismissable alert across the top of the page.

 

Had a quick play around tonight and got it to work instantly!

1. I commented out the redirect parts of the add() function in cart.class.php - approx. lines 421, 423, 428 and 431.
2. I gave the buy button on the content.product.php template the name "buyproduct"
3. I created this small code snippet (with class.cubecart.display_product as the trigger): 

{php}

if (isset($_POST['buyproduct'])){
  	
$GLOBALS['smarty']->assign('ADDED', "Product added to basket");

}
{/php}

4. Then in product template:

{if isset($ADDED)}
    <p>{$ADDED}</p>
  {/if}
//will improve on this once working!

Do you see any issues with removing the re-directs? Everything appears to work from my end!

 

Cheers,

 

Chris

[need seo option in manufacturer]

I am currently working on something similar for CubeCart 5.... I think.

 

For my old Cubecart 4 store I created URLS like: http://www.caravanaccessoryshop.co.uk/brand/Kampa

 

Is this the kind of thing you are trying to achieve?

 

If so, I can keep you posted on what I come up with in the next week or two.

[Added To Basket message/notifcation]

Hi all,

 

Just upgrading from Cubecart 4 to Cubecart 5.

 

On my old store I have an added to basket message which displays when "added=1" is present in the url e.g. product/jockey-wheel-clamp-34mm/4599?added=1

 

My old code was:

if (isset($_GET['added'])) {
 $view_prod->assign("TXT_ADDED_TO_BASKET", "<div class='txtAdded'><h3>Thank you for adding the ".validHTML($prodArray[0]['name'])." to your <a href='/index.php?_g=co&_a=cart'>basket</a>.</h3></div>");
}

My new code is:

{php}
  	
$GLOBALS['smarty']->assign('ADDED', "Product added to basket");

{/php}

Which trigger should I use to action the new version of this code?

 

I have tried class.cart.add.save, class.cart.add.update and others to no avail so far.

 

Any help would be greatly appreciated.

 

Chris,

[Error when assigning a variable from a display_category code snippet]

Oops.. spoke to soon.

 

There is still a problem with the sql and getting the category id in to it. When I substitute:

 

'.$category['cat_id'].'

 

for:

 

217

 

(for example) it works.

 

Can $category['cat_id'] be used in display_category triggers?

[Error when assigning a variable from a display_category code snippet]

Hi bsmither,

 

Your advice pointed me in the right direction.

 

The php error message related to a different code snippet (which I had deleted from admin but was still in the includes/extra folder).

 

Once I realised there was no error caused by the snippet I looked more closely at the output code and realised I had typed it in to a section which is only visible if the category has no image!

 

Three hours wasted but another few CubeCart 5 lessons learned!

 

Regards,

Chris

[Error when assigning a variable from a display_category code snippet]

Hi all,

 

I have created a simple mysql table (related_articles) and a simple code snippet (code below) which has the display_category trigger:

{php}

if ($related_articles = $GLOBALS['db']->query('SELECT `id` AS articleId, `description` AS articleDescription, `url` AS articleUrl, `type` AS articleType  FROM `related_articles` WHERE `type` = "cat" AND item_id = '.$category['cat_id'].' ORDER BY `id` DESC')) {
	
  foreach ($related_articles as $related_article) {
		$related_article_vars[]	= $related_article;
	}
  	
$GLOBALS['smarty']->assign('RELATED_ARTICLES', $related_article_vars);

}

{/php}

However, I am getting this error message in my logs:

PHP Fatal error: Call to a member function assign() on a non-object in /includes/extra/snippet_1679091c5a880faf6fb5e6087eb1b2dc.php on line 15

It appears the $GLOBALS['smarty']->assign() is not working as it should. All the sql is fine.

 

I have been battling with this for a few hours now so hopefully someone can point out an obvious error!

 

Kind regards,

 

Chris

 

 

[Zend Optimizer]

I have the same problem.

Can anyone help?

[Big Problems - is it my server or have I been hacked?]

Was a problem with my web host which they have just fixed for me.

Was a bit worrying for a moment.

[Big Problems - is it my server or have I been hacked?]

Hi all,

My site has been up and running successfully for a couple of years.

Suddenly I can't access the site though. I am faced with a list of errors regarding the ini.inc.php file and also MySQL errors.

Here is my site: www.caravanaccessoryshop.co.uk

Can anyone suggest whether it is problems regarding my web host or have I been hacked?

Cheers,

Chris

[Cubecart search engine just not working right]

Finally cracked it.

Have been searching for a solution to this for years!

I edited the fullTextIndex in the inventory table of the databse. I replaced the description field with the metaKeyWords field and now I have a very effective search! Woo hoo!

[Not Adding Products to Basket when Ordering]

Since upgrading to CubeCart 4 I have had several customers who have said they have been unable to place an order.

I have not been able to replicate their problem.

I know there is a bug which makes ordering a product from search results not possible - has this been reported/fixed in versions after 4.1?

Chris.

[CC4 Search engine problem]

I had an idea to search just the title and keywords of each product (i.e not the description). Ihave been through and added keywords to every product.

I am struggling for a way to implement this though.

Any advice - anyone??

Cheers,

Chris

[Protecting Images]

Hi,

You've taken that picture off the homepage. Forgot to say I've only protected images on product pages.

There are still lots of ways to copy the images but they take a lot longer than a simple right-click or drag to the tab bar.

Cheers,

Chris

[Protecting Images]

Just cracked it!

I'm using KitaBlue skin and replaced line 14 in styleTemplates/content/viewProd.tpl with:

<div style="background-image: url({IMG_SRC}); background-repeat: no-repeat; background-position: center; width:300px; height:300px; vertical-align:middle; margin:0 auto;"><img src="images/general/px.gif" alt="{TXT_PRODTITLE}" width="300px" height="300px" title="{TXT_PRODTITLE}"></div>

See it in action on my website: Caravan Accessory Shop

If someone really wants to steal an image they will but this makes it a little harder for someone to go and take every image.

[Add Fields to Packing Slip]

The billing address codes are the same the delivery address ones but without "_d" at the end.

For example:

$result[0]['name_d']

becomes...

$result[0]['name']

Just copy everything inside <div class="deliveryAddress">

Find and replace the "_d"s and you'll be sorted.

[CC4 Search engine problem]

I'm with you on this.

The search is pretty useless.

On my website:

A search for "propane regulator" does not result in a propane regulator being top of the list!

A search for "inner tent" results in several other products - many not containing the word "inner" - above an actual inner tent!

I have desperately tried to edit the way the search works but am having no luck at all.

[Protecting Images]

I am trying to protect images on my website as I have spent a lot of time taking them and editing them.

I know that if they are on the web you can't prevent them being copied but you can make it a little harder for people to do so.

I disabled right-clicking for a while but I find sites that do that very annoying - and with a bit of know-how it doesn't take long to get round it.

I've seen sites that put a transparent gif over each image - that is what I'm trying to incorporate but don't know really where to start.

Can anyone help?

Cheers,

Chris

[Notes to send to customer field]

Hi,

I managed to fix this by adding:

"COMMENTS" => $this->orderSum['comments'],

in to the classes/cart/order.php file - after:

$macroArray = array(

on line 260.

Then I added:

{COMMENTS}

around line 39 in langauge/en/email.inc.php - after:

'order_breakdown_1' => "Dear {RECIP_NAME},

Thank you for your order no: {ORDER_ID} placed on {ORDER_DATE} at: {STORE_URL}.

I also added the date that the order was shipped in the same way.

Cheers,

Chris