Finding Zen Cart products with no default attribute set

A client called me and told me that someone had added a $0 product to their order!  When I looked at the product, I noticed that it was priced by attributes, but didn’t have a default setting for the attribute which priced it.  So the attributes, which were radio buttons, looked like this:

no_set

See how none of the radio buttons are selected?

Now this is easy enough to fix – go to Zen Admin, to Catalog->Attributes Controller, select the product, and then edit the attribute that you want to be the default, and set the  Default Attribute
to be Marked Selected:
radio button at the bottom of the page in the Attribute Flags.  But how do we determine how many products have this problem?

There’s a SQL query you can use in PHPMyAdmin to figure this out:

SELECT p.products_id FROM `zen_products_attributes` p where 1=1 and NOT EXISTS (SELECT products_id from zen_products_attributes p2 where p2.products_id = p.products_id and p2.attributes_default = 1) group by products_id;
Posted in That Software Guy, Zen Cart | Comments Off

Interesting application for Zen Cart Better Together Admin and Checkbox Cross Sell

A client wanted to use Better Together Admin for Zen Cart to configure cross sells, and wanted to use Checkbox Cross Sell for Zen Cart to display them.  Easy enough – but here’s the twist: he wanted any cross sell to be applied to all products (rather than configuring each product with the same cross sells).

This kind of thing can be done with just a little custom programming.  On my Advanced Discount Configuration for Zen Cart page, I show how to do it (see example 11).

Posted in Uncategorized | Comments Off

Minor changes to Zen Cart Better Together Admin and Combination Discounts Admin

Both these modules got tweaked yesterday after an install test – I noticed that Better Together Admin for Zen Cart did not work when run from a non-superuser account, and that there was a bug in Combination Discounts Admin for Zen Cart which was introduced in the last update (the Set Inactive button wasn’t working).

Posted in That Software Guy, Zen Cart | Comments Off

Updates to Checkbox Cross Sell for Zen Cart

The folks at LightupUK wanted to use Checkbox Cross Sell for Zen Cart with some of the optional features which are commented out enabled, and they reported a small bug (the optional link to the product in the Better Together marketing text wasn’t working), so I have updated this module.

Posted in Uncategorized | Comments Off

How to Unfollow someone on LinkedIn

If you see a post you enjoy on LinkedIn, you might be tempted to click the Follow button to see  more posts from that person.  But what if they’re *too* chatty?

Unfollowing someone is a bit tricky, but here are the steps I use:

  • Hover over the flag on the upper right, then click their name in one of their posts.
  • Scroll down below the picture on the post and click their name again – this will bring you to their profile page.
  • Scroll to the Posts box on their profile page, and click See More.
  • Click the Unfollow button on the right hand side of that page.
Posted in Social Networking | Comments Off

How can I set a price for a group of items in Zen Cart?

You have a couple of options here:

a) With Zen Cart Table Discounts, you can provide a final price for specific bulk quantities (quantity discounts) of certain items or groups of items.  It’s a good option if you have multiple specific price points for quantity purchases.

Example: Category 1: Buy 10 for $35; buy 20 for $50, buy 40 for $80.

b) With Zen Cart Free Gift Chooser, you can provide a final price on a package (a collection of items) where certain quantities of items should be chosen from specific categories. (This is sometimes called a kit discount.)

Example: Buy an item from each of category 1, category 2, and category 3, get them all for $20.  Choose any 5 items from category 1 or category 2 for $30.

Table Discounts and Free Gift Chooser do not actually lower the prices of the items; they create a discount so that the final price of the items is what you have configured.   So for example, here’s Free Gift Chooser (with the discount shown on the Shopping Cart page by Discount Preview):

(Table Discounts looks the same – the discount is a line item on the shopping cart page if you have Discount Preview, and a line item on the Checkout Payment page and the Checkout Confirmation Page.)

Posted in That Software Guy, Zen Cart | Comments Off

Updates to Zen Cart Checkbox Cross Sell

Checkbox Cross Sell for Zen Cart now displays the Better Together marketing text within the cross sell block.   This allows you to display the discounts your customers will get when they buy your cross-sold items.  Here’s a screenshot; you can see the marketing text at the bottom of the image.

ccs_plus_bt_mktg

Posted in That Software Guy, Zen Cart | Comments Off

Jose’s new Mobile-Friendly Zen Cart 1.5.3 Template

It’s ready!  Take a look: http://www.demos.ultimatezencart.com/0701M/

Looks good on both mobile devices and a desktop computer.

Posted in Zen Cart | Comments Off

Zen Cart Free Gift Chooser / NoChex Payment Module interoperability fix

  • If you are using Free Gift Chooser 1.3 or lower, with a payment module which has its own application_top file (such as Nochex), please move
    includes/extra_configures/free_gift_chooser_tables.php
    

    to

    includes/extra_datafiles/free_gift_chooser_tables.php
    

    (The symptom you will see is that customer checkouts will fail to complete.)

Posted in That Software Guy, Zen Cart | Comments Off

Zen Cart on Mobile Platforms

I wrote about this a couple of months back on my Zen Cart newsletter:

Two folks I work with have created templates which work well on mobile devices – take a look and see for yourself.

Here is Delia Wilson’s template (1.5.x version):

http://www.zencartdelia.com/zen-cart-store/index.php?main_page=product_info&cPath=10&products_id=47

Here are Jose Carrillo’s templates:
http://ultimatezencart.com/index.php?main_page=index&cPath=3_21

Delia’s approach is to replicate the site under a separate directory so that two complete sites are maintained (one for mobile and one for the desktop).  Jose uses a single template which works on both mobile and desktop devices.  I recommend both of them.

 

Posted in That Software Guy, Zen Cart | Comments Off