Rss Feed Tweeter button Facebook button Technorati button Reddit button Myspace button Delicious button Digg button

New Pets: Introducing cats to dogs.

April 29, 2011

Just this morning I collected a pair of rescue cats from Cats Protection and now have the task of settling them in and introducing them to my dog ( in a few days).

There is much literature written about this task and, although the cats are an unknown quantity, I do know my dog is fine with cats.

The cats are currently confined to one room with the dog taking an occasional look through the glass paneled door – all seems fine so far.

I will keep this updated and hope everything is as straightforward as cat experts suggest.

How to Restrict Quantity of Items in Magento

April 16, 2011

I have been looking at how to stop checkout of maximum quantities in Magento for one product category e.g. one per transaction or one per customer only.

The short answer: it’s not possible (unless you want to pay for a commercial extension).

The workaround

Scenario: I am starting a penny sale – simply pay for postage and packaging and buy something for 1p, or add a penny item to your order.

Orders from the penny sale category will be restricted to one per transaction. As this is not possible I have decided on a surcharge instead.

This has the benefit of allowing customers to decide if they wish to purchase more than one and allows the retailer to use existing Magento tools.

We are going to use Shopping Cart Price Rules (under the promotions tab from the dashboard). If the customer purchases more than one item from the category then £1 will be added for the second and each additional item in the shoppping cart.

By default a surcharge (or negative discount) is not allowed in Magento so we need to change a few lines of code to enable it:

1. Go to app/code/core/Mage/Rule/Model/Rule.php

Find the line:

//check if discount amount > 0
if ((int)$this->getDiscountAmount() < 0) {
Mage::throwException(Mage::helper(‘rule’)->__(‘Invalid discount amount.’));
}

Just add some bars // to comment the code:

//check if discount amount > 0
//if ((int)$this->getDiscountAmount() < 0) {
//Mage::throwException(Mage::helper(‘rule’)->__(‘Invalid discount amount.’));
//}

2. Now go to: app/code/core/Mage/Adminhtml/Block/Promo/Quote/Edit/Tab/Actions.php

Look for:

$fieldset->addField(‘discount_amount’, ‘text’, array(
‘name’ => ‘discount_amount’,
‘required’ => true,
‘class’ => ‘validate-not-negative-number’,
‘label’ => Mage::helper(’salesrule’)->__(‘Discount amount’),

And again comment like this:

$fieldset->addField(‘discount_amount’, ‘text’, array(
‘name’ => ‘discount_amount’,
‘required’ => true,
// ‘class’ => ‘validate-not-negative-number’,
‘label’ => Mage::helper(’salesrule’)->__(‘Discount amount’),

3. Translate the discount word.

Go to app/locale/en_US

Find a file called Mage_Sales.csv. Inside look for the word discount you will find something like:

“Discount (%s)”,”Discount (%s)”
Change the text to what ever you like, e.g.:
“Discount (%s)”,”Extra Fee (%s)”

The above section comes from: http://php.quicoto.com/extra-fee-shopping-cart-price-rules-magento/

 

Next we need to create the shopping cart rule by setting the conditions:

My sale catgegory is 55 so I want to activate the rule when more than one item from category 55 is added to the cart.

 

Then we need to create the actions rule to tell Magento what to do when the above conditions are met:

You will notice I have added an extra condition in the actions section. This is to ensure only items in category 55 attract the £1 surcharge – without it £1 would be added for every item in the shopping cart.

It is not quite how I wanted it to work as it add £1 for every item in the basket if rather than only for the second one, third one etc, but it will have to do.

Whilest it is unfortunate that the rules in Magento are not more flexible or easier to customise, after hours or research this is the simplest and quickest workaround I have found.

Change Magento Category Image Size

April 12, 2011

For some reason category images were being expanded to fit the column size.

Instead of a 100px picture customers would see it expanded to 520px.

To fix it, edit the style sheet:

/skin/frontend/default/YOURTEMPLATENAME/css/styles.css

Look for the value category-image.

I made the following changes to mine:

  • change the alignment to left at the end of the first line – previously it was center
  • delete the end of the second line – previously it was width 100%

.category-image { width:100%; overflow:hidden; margin:0 0 10px; text-align:left; }
.category-image img

Magento Read timed out after 10 seconds

April 11, 2011

Getting this error for google base? It is intermittent and frustrating.

Edit the following file on your server:  /lib/Zend/Http/Client.php

Locate the following line:
‘timeout’ => 10

Change the value 10 to 30.

Double Standards of Customer Service at Amazon.

December 29, 2010

From a buyers point of view, there seems to be a double standard of service at Amazon – one standard for their sellers and (a lower) one for themselves.

Over the Christmas period and suffering from poor weather conditions it was inevitable some items would not arrive on time or be lost. How that was dealt with by companies can be illuminating.

On Amazon when you purchase from third parties they give you a contact seller and file a claim button. This makes it easy to notify a seller about a problem and obtain a refund – it is not so easy to do this with an Amazon purchase.

After wading through help pages and clicking through previous orders one at a time I finally manged to contact Amazon CS about an item not received. Hardly a one click process and the first time i tried the help pages were down and unable to display previous orders so had to try again later.

After a day or two I received a stock reply from Amazon asking me to wait a week before doing anything as they did not have enough staff to answer emails. I then had to contact them again and ask for a refund which was done about 3 days later – with no contact in between. Judging by Amazon’s own forums there were many unimpressed with this.

Amazon set targets for their third party sellers and mark them on performance levels including timely responses and the number of returns and refunds.

Why can’t Amazon work to the standards they set for others?

eBay: Poor Customer Service = Poor Value? Is it worth it?

November 9, 2010

eBay have a reputation for poor customer service. Ask them a question and they merely copy and paste something from the help pages which may or may not relate to the question you asked. Complain and they ignore you, close your account and they don’t care – a new seller will be along soon.

Yes, they get buyers to their website but with eBay’s appalling customer service and their I don’t care attitude does it really represent good value for money?

I had a few difficult “buyers” recently. I’m not complaining about them. Online or in a shop, there will always be cheats and thieves: a sad part of doing business in Britain.  Sure you should have polices in place to avoid these people as much as possible but don’t treat everyone as if they are out to rip you off – it should not be a race to the bottom. A business should NEVER be run to the lowest common denominator: a mistake many eBayers make.

I believe the majority of people are honest and want to enter into a transaction of mutual benefit and appreciation. Supply a good product, appreciate their custom, offer a good service and the customer will reciprocate.

In these difficult economic times, just like consumers, businesses need to spend their money wisely, making every pound work hard for them. When problems arise and eBay give their usual I don’t care attitude I  stop and wonder what am I paying them for? Hundreds of pounds a month for that? Is that really good value?

After all, I am paying their wages, those eBay employees who copy and paste nonsense, who take no pride in their work and give completely contradictory answers delivered in their usual I don’t care way. Is this a wise way to spend my money?

I have to conclude the answer is no. I wouldn’t expect consumers to put up with that, so I will close my eBay shop. With the new allgiftsdirect Magento website up and running it makes more sense to invest in that.

 

If you’re looking to improve your customer service skills, Click Here!

Magento Remove Back to School and The Dog

September 10, 2010

Those pointless and annoying callouts in Magento! Back to School and the Dog call us on (555) 555-0123. Every Magento user is familiar with these side boxes.

I found the simplest way to remove them is to rename the call out files so their functions no longer exist.

/app/design/frontend/base/default/template/callouts

rename the two files by putting something in front of them e.g.:

STOPleft_col.phtml

STOPright_col.phtml

Pointless call-outs gone!

Importing Customers Into Magento From ZenCart

August 19, 2010

Once again we use a CSV file to import existing customers into our new Magento shop.

Firstly create a test customer and add an address for them.

Export the file. This we will use as our template.

ZenCart doesn’t have a CSV file for customer details but it does have similar fields in the database and this can be accessed through your server. I go through cPanel and select phyMyAdmin.

The two fields you need are address_book and customers. Select your database then, at the top of the screen select export.  Select address_book, check the CSV  option (or CSV for excel) and save the file. Repeat for customers.

You now have two separate files with all the necessary information to be able to compile a Magento customer file ready for importing.

It is then a case of copy and pasting from the zencart customers into your Magento CSV template. To do this faster combined the two files into one.

Open your address files then select the first blank cell at the end of the data – mine was M1.  Then select data, from other text, your customers file and insert as comma separated into your worksheet starting at the first blank cell (M1 in my case).

Now read across and the customers details should more or less match. Basically name, address, email and password login.

For those lines that do not match I delete the first few cells on a row (A-L) and shift them up. Usually that realigns them. Doing it this way every line will need to be checked carefully for the correct customers details but it will save time copying and pasting later on as we can now do entire columns in one go.

Once finished delete the CSV files as this is information that, while secure on a host, is not secure on a personal computer.