[Set Items in Side Box (Popular Products)]

Is it possible to set the popular products to display a custom selection of products? The end result I am hoping for is to have an option in the admin area to set a product as a 'special' to display in a side box. The popular products template is close but uses the popularity rating rather than a custom selection. If it is not possible to do this through the admin area I'd also be okay with doing small updates directly to the code.

I'm pretty sure this is the statement in popular products that would have to be modified to cause it to select specific products, but I don't know how to change it.

$db->select("SELECT I.name, I.productId , I.price,I.image, COUNT(I.productId) AS total FROM ".$glob['dbprefix']."CubeCart_order_inv AS O, ".$glob['dbprefix']."CubeCart_inventory AS I, ".$glob['dbprefix']."CubeCart_category AS C WHERE O.productId = I.productId AND C.cat_id = I.cat_id AND C.hide != '1' AND I.disabled != '1' AND I.cat_id > 0 GROUP BY I.name DESC ORDER BY total DESC", $config['noPopularBoxItems']);

Any help would be greatly appreciated.  Thanks!

Hi, you would need to add a new column to the inventory table, something like "custom", or whatever name you like. then edit the admin product edit page to update that field when you save the product. Once that is done, change the SQL line above to this.

Any help would be greatly appreciated. Thanks!

$db->select("SELECT I.name, I.productId , I.price,I.image FROM ".$glob['dbprefix']."CubeCart_inventory AS I, ".$glob['dbprefix']."CubeCart_category AS C WHERE I.custom = '1' AND C.cat_id = I.cat_id AND C.hide != '1' AND I.disabled != '1' AND I.cat_id > 0;

[Configuring the Payment Page CCV4]

Still have this problem. Can't anyone help me? Can anyone tell me where I can find the file and how to remove the codes for the blank stupid radio buttons that do nothing but make the page look unprofessional??

in the admin panel, make sure that the only gateways that are enabled are the ones you want. If a payment gateway is enabled and does not have a description, it will show up as a blank radio button.

thanks

/Goober

[Add Description to Popular Products]

I know that part. What would the line of code be?

Ok, wait.. I might be able to figure it out. If anyone else can help, please do.

Will keep this thread updated.

Thanks!

Hi,

First the line of your code is wrong. the line should be

$box_content->assign("TXT_DESCRIPTION",$randProd[0]['description']);

After you fix that,



add I.description to the $sql = line so it would look like this

$sql	= sprintf("SELECT I.name, I.image, I.productId, I.description FROM %1\$sCubeCart_inventory ...

Good Luck

[Adding fields - Anyone have a general overview?]

rebatch, have you found an answer for this?

I am also a PHP programmer and have looked at the code in /shop/includes/content/ and it looks like the code is open to change.

I tought CC was closed-source and all PHP scripts were encrypted.

Does anyone know if it's an issue adding fields in the databse and the admin section only? The fields I need to add are for internal inventory tracking purposes only.

Thanks!

Hi

CC is not Open Source but that does not mean that you can't view and change 98% of it's code. Only a very small part of it is encrypted, the rest is wide open for you to modify to suit to your needs.

To add additional fields, just add them to the database table and update source code where appropriate.

Good Luck

/Goober

[Category Box Spacing]

Really giving me a headache now! I would imagine it is something simple. Can anyone help?

Edit the categories.tpl in the skins/Classic/stleTemplates/boxes folder

find this line

<br clear="all" />

change it to

<div style="clear: all;"></div>

Good Luck

/Goober

[Show Produts Only To Some Clients]

Is it possible to show some products only to a defined group of clients?

Thanks!

Hi,

You can find a mod for this over at cubecartforums.org site

Thanks

/Goober

[Customer Groups / Wholesale Pricing]

Hi guys,

I know cubecart v3 didnt offer this, but I am struggling to find the information about v4. Can anyone tell me if the new versions offers the ability to give customers different pricing?

Hi,

The new version does not offer this functionality. however, mods can be found on cubecartforums.org that will add this functionality to both v3 and v4 cubecart.

thanks

/Goober

[Coupon Manager Mod by Goober]

would you happen to know why the Coupon Manager Mod (by Goober) that I installed seems to be working incorrectly?

when a customer uses a coupon code for the purchase of a product it works perfectly! However, it appears that the coupon code still is being applied to a whole entire new oder that the customer places.

Hi,

Mods are not supported in these forums. Please PM me and I'll be able to assist.

thanks

/Goober

["You must login to view this page" message after payment mad]

No, I'm paying with a different account, it's just Cubecart seems to log me out after going to Paypal.

Check your global.inc.php file. make sure that the store's url has www in it. and that your paypal return url also has www.

This error usually happens when you access your site with www and return to a url without or viceversa. access your shop without www and return to the url with it.

thanks

/Goober

[Obtain PayPal email account (illegally)]

Hello -

One of my "potential suppliers" from overseas sent me a bill via Paypal before I provided that information, i.e. my PayPal email account; that took me by surprise to say the least. Does anyone know how did they do that? And, what can we do to prevent any risks associated with illegally obtained PayPal email accounts?

Of course, I have been drilling the vendor for the information but so far, I received the 'silent treatment'.

Hi,

There is nothing "illigal" about this. You can use PayPal to send an invoice to ANY email address, whether the email account is a paypal account or not. If you had any email communication with this vendor then they have your email account. All they did was send an invoice, perfectly valid, perfectly legal. If that account just happens to be your paypal account as well then that's just a coincidence.

NEVER give your passwords to anyone. Never click on any links that would take you to PayPal site to login. Always go to paypal site directly and login.

Thanks

/Goober

[Coupons / Gift Certificates]

Unspent funds from a Gift Certificate becomes a special type coupon (is gift certificate).

Does it then have to be re-issued back to the customer, or is this done automaticaly under the old gift certificate code?

Unspent funds remain available until they are used up. The customer must use the same giftcard code until the funds have been depleted. No action by admin are necessary.

Once the funds have been depleted, the code is no longer valid.

/Goober

[Coupons / Gift Certificates]

So, a customer buys a gift certificate, say for £20, and spends £5 of it so far, it will show IN COUPONS?

Yes, there is only one "code" interface. The column "is gift certificate" will indicate that this coupon is actually a giftcard

Great, I just tried this, and it worked. BUT there's still no way of editing the details - Unless you delete it from the cart, and repurchase it.

that's how it is today. you can always request a change or new features via bug tracker.

Once per customer

has not been implemented at this time. you can always request a change or new features via bug tracker.

you can always use a v3.x mod that has all these fetures

/Goober

[Coupons / Gift Certificates]

Right, so we've explained the difference between them, but that leaves some questions unanswered still...

In Coupons, there's a field that says "Is Gift Certificate?" - What is this for?

and

What if a customer wanted to purchase more than one at a time? What if I was a grandparent, and wanted to get all my grandsons a gift voucher at a particular store - Am I expected to place 15 separate orders? I hope not!

and

Also, when I'm in the view basket screen, I can't see a way of editing the gift certificate details - What if I wanted to change the amount of the certificate, or realised I spelt the email address wrong, or worse still, mis-typed my grandson's name wrongly!

and I have another one...

If I wanted to make a promotion to all my customers by emailing them each a coupon for say 25% off a new product I'm launching, how on earth can I achieve this? If I had a customer list of 1000 customers, the only way I can see of doing this is to create 1000 coupons separately, and then export the email list, and individually send the emails.

While the coupons / gift certificates are very welcome, I'm sorry, but from the limited information I have about them, I'd have to say their application has been poorly implemented.

"is gift certificate" identifies a code that is giftcard so the cart maintains remaining value.

You can purchase more than one giftcard per order

you will need to create just one coupon code and send it to 10000 customers. all of these customers will get 25% off their orders.

Coupon is not a giftcard, giftcard is not a coupon. giftcard is store credit, once the value has been spent it's over. The coupon codes have an unlimited use or until the max use number has been reached.

/Goober

[Coupons / Gift Certificates]

Very good questions. I was curious as to the difference between gift certificate and coupon, don't they both work the same in principle?

Hi,

The coupons and gift certificates DO NOT work the same. The "problem", please note the quotes around the word problem, is that they are not differentiated enough, IMHO.

Here's the concept.

The coupons are exactly as they sound and are simple in concept. You create coupon code and choose either % off or $ amount off the order subtotal.

The Giftcards on the other hand are NOT discounts, contrary to the way they are shown in the cart. They are treated as store credit. The giftcard has a $ amount that is maintained by the cart. If the giftcard is valued at $50.00 and the customer spends $23.57 then the giftcard has a balance of $26.43 for the next time the customer comes back to the store. The giftcard code is not generated until the giftcard is paid for and then the code is emailed to the email address specified during purchase.

hope that helps

/Goober

[Funky default store names]

heh, i was wondering how long it'd take you all to realise that!

the full list is....

'Applied Cryogenics', # Futurama

'Blue Sun Corporation', # Firefly

'Colby Enterprises', # Dynasty

'CompuGlobalHyperMegaNet', # Simpsons

'Cyberdyne Systems', # The Terminator

'Dervish and Banges', # Harry Potter

'FrobozzCo International', # Zork

'Hanso Foundation', # Lost

'Jupiter Mining Corporation', # Red Dwarf

'Kaiba Corporation', # Yu-Gi-Oh!

'Magpie Electricals', # Doctor Who - Series 2 "The Idiot's Lantern"

'Megadodo Publications', # The Hitchikers Guide to the Galaxy

'Nakatomi Trading', # Die Hard & Die Hard 2

'Primatech Paper Company', # Heroes - Volume 1: Genesis

'Rekall, Inc', # Total Recall

'Rentaghost', # Rentaghost

'Sparrow and Nightingale', # Doctor Who - Series 3 "Blink"

'The Magic Box', # Buffy the Vampire Slayer

'Wayne Enterprises', # Batman

'Weyland-Yutani', # Alien

'Wolfram and Hart', # Angel

if you want me to add any, reply to this thread, and tell me what it's from (must be a fictional company), and i'll pick the best to go in

Oh man... you took all the fun out it. :wacko:

[3rd Party Modules Link]

No need to call it 3rdParty, is there? It would be nice if there were an area, though, could call it Add-on Modules or just Add-ons ~ That would server both for 3rd party add-ons and any after-market addons that Devellion cared to create and sell.

I agree with markscarts, Add-ons or Add-on modules is also a good idea.

Thanks

/Goober

Go CubeCart!

[Test Payment Gateway for v4.0]

Hi,

I just posted a simple "Test Payment Gateway" mod for CC v4 over at cubecartforums.org. This mod is same as the v3 mod I posted a while back. Just in case any beta testers could use it.

thanks

/Goober

[Hiding prices and product prices...]

I use GBP (£) so I disabled euros and dollars. Set the £ to 1 whole one so that the price will be as I want. Look on the shop great thats fine, click and to basket then it shows in my basket the item at £1???

Also I wish to hide prices from people until they login, this does not happen.

What I think is happening is that it is stuck in sale mode, this may explain the price being displayed like £449.99 and the price being £1. There is no red price below and I want sale mode off, I have selected sale mode off on setttings.

As an after thought I switched off hide prices and it did not work it still seems to be stuck on displaying prices as £449.99????????

What do you peeps think???

That has already been reported as a bug.

/Goober

[3rd Party Modules Link]

I was wondering if a 3rd Party modules link could be added somewhere within the admin panel navigation?

if not, no big deal, just thinking out loud.

This would go a long way in unifying a location within the admin panel where modders can place their add-ons and give the whole modder community a bit recognition.

IMHO, I think this has worked pretty well on v3, even if I do take credit for it

The new admin panel navigation is getting quite busy.

Thanks

/Goober

[Funky default store names]

:) Who came up with all those random funky default store names, Martin?

CompuGlobalHyperMegaNet

is my favorite so far.

Thanks for the funny

/Goober

[Module installation instructions or sample zip needed]

I was wondering if we could get a sample "gateway" or "shipping" module installation zip file to test the module installation process?

Also, what is the proper format and/or layout of a module zip file for installation process?

thanks

/Goober

this will be coming soon, the module installer isnt quite perfected, and it will (probably) be the first module you can test it with, as it's capable of self-installing.

at the moment, the current directory structure inside a module folder is

package.conf.php

[front end scripts]

--admin

----index.inc.php

----[other admin side files]

--language

----default.lang.php

----[locale i.e. en_UK].lang.php

--classes

----[module classes]

like i said, it's not finalised, but it will be well documented

Thanks!

Could I trouble you for a layout or sample of package.conf.php

just being curious.

thanks

/Goober

[Module installation instructions or sample zip needed]

:)

[Module installation instructions or sample zip needed]

I was wondering if we could get a sample "gateway" or "shipping" module installation zip file to test the module installation process?

Also, what is the proper format and/or layout of a module zip file for installation process?

thanks

/Goober

[Empty Cart....]

Looks like it happens a lot, I'm thinking its a server/general setting that is not setup correctly with the cookies. Whenever you go back to the home page form any link it takes all the stuff out of your cart like its not there. Refreshing page does not work. Clicking on another catagory brings it back.

Ideas?

Hi,

Make sure that $glob['storeURL'] has www in it. Sometime you get "Empty Cart" errors when your store is accessed without www and when viewing cart www appears in the url.

thanks

/Goober

[How to edit left menu on step 4 page]

Hi all,

I would like to remove one of the links in the "Useful Menu" left side nav on step 4 of the checkout

process...I don't want to remove the whole menu, just one of the links...can anyone tell me where I can do that?

I've already read here that part of the structure of the page is located at /skins/xx/styleTemplates/boxes/cartNavi.tpl, and I've opened that, but I cannot seem to figure out where to go from there...

<!-- BEGIN: links -->

<div class="boxTitleLeft">{LANG_LINKS}</div>

<div class="boxContentLeft">

<ul>

<!-- BEGIN: repeat_region -->

<li class="bullet" style="list-style: none;"><a href="{VAL_LINK}" class="txtDefault">{TXT_LINK}</a></li>

<!-- END: repeat_region -->

</ul>

</div>

<!-- END: links -->

I guess I need to know where {VAL_LINK} is located?

Thanks for any help:

H

You should be able to make changes in the includes\boxes\cartNavi.inc.php file.

Thanks

/Goober