Categories
eCommerce Internet News

Facebook and how you can use it to make money

How to use Facebook to Make Money

Facebook PictureFacebook is big, Facebook is popular and Facebook is something you should be thinking about if you want to generate money.

They say that finding new customers is hard, and I can sympathies with that feeling. However in the case of social networking, facebook appears to be doing very well for itsself. Considering that they have managed to build a commercial success around what is essentially a brain dump onto a website is very impressive.

As a company however, why should you want to ignore Facebook? Would you ignore Google in your marketing strategy? I didn’t think so.

Statistics speak for them self, around 250 million people are logged into Facebook in any given day. With around 500million users considered to be active. As a business you want to make use of this huge amount of users. But you dont know how to go about it do you?

Facebook Pages

Lets get started by setting up a Facebook page. You need to set up one if you have not already. This is certainly the first place to start your Facebook marketing strategy from.  This is the starting point, you should be actively marketing it – have staff posting on it, link from your existing website to it. “like” it and share it.

Generating Likes

The key to developing a commercial strategy on Facebook is to have fans that like your products. Putting your products onto Facebook is important and there are a number of strategies that can be done to make this happen. E-Commerce developers can develop your website so that products are integrated to Facebook. You could even have your own full shop in place.  Integrating a shop into Facebook allows you to start accepting Facebook Credits as a payment method.

Custom Landing Page

Why not consider setting up a custom landing page? Redbull and Coca Cola have done it and done it rather well. Your custom page would make you stand out from that of your competitors.

Special Offers

Promote on Facebook only special discounts Dominos are very good at doing this giving special offers which are larger than through other channels.

What you can get out of it is that with an average user having 100 friends, if they comment on your special offer, or share it, and we assume that you have generated 100 fans of your page, then that a huge 10000 people are going to see your product or service. How much would it cost you to send a mail shot to 10,000 people daily? I’d wager it’ll cost more than spending a good few hours setting up a good Facebook campaign.

Employing this strategy will see a growth in your business, an inactive Facebook account has reportedly generated some of the big firms 60K site visits a month. Becoming active they could easily see that figure double.

Categories
eCommerce

Processing card payments should be straight forwards

House built from £20 notesMoney makes the world go round treat it with respect.

I have been working in my current position for nearly a year now. I have seen clients ask for strange things, insist we spend stupidly long amounts of time moving things just for them to say we don’t want it there anyway.

The one thing that I find that consistently causes loss of payments comes down to the money part.

Recently we tried to acquire some new software for the business, being a UK business we have a UK Issued Debit Card, many Europeans will have similar types of card. These are not recognised by payment systems as being credit cards, so when we found the company did not actually accept payments on anything other than a credit card, we were forced to re-evaluate our purchase. They lost the sale.

I just attempted to pay my partner’s phone bill online, he is with orange, and one of the reasons I recently moved away from Orange (there was more than just not having the phone I wanted), I discovered not too much to my surprise as I have experienced it many times as an Orange customer: The classic “There has been a problem, your error has been logged”. My error? Trying to give those guys money? So Orange are left without money.

I recently tried to update my Self Assessment online – well, what should have been a 5 minute job (including finding the log in details) turned into a 3 month trek. They finally got it sorted last week.

(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = “//connect.facebook.net/en_US/all.js#xfbml=1&appId=181089105257561”;
fjs vente generique cialis.parentNode.insertBefore(js, fjs);
}(document, “script”, “facebook-jssdk”));

Categories
Magento

Magento Delete Products and Categories

Magento LogoThe database structure used in Magento can be very complex to new starts – hence why recently I outsourced a major database manipulation project.

Part of this project involves wiping the database of products and categories frequently. So I decided to put this post into place – not because its nesessary original discovered or particuarily interesting. I created it simply so I can easily come back to the information I need when I am cleaning the database on test runs I got bored having to google each time and as you’ll see this is not exactly easy to remember.

Delete Categories:


TRUNCATE TABLE `catalog_product_bundle_option`;
TRUNCATE TABLE `catalog_product_bundle_option_value`;
TRUNCATE TABLE `catalog_product_bundle_selection`;
TRUNCATE TABLE `catalog_product_entity_datetime`;
TRUNCATE TABLE `catalog_product_entity_decimal`;
TRUNCATE TABLE `catalog_product_entity_gallery`;
TRUNCATE TABLE `catalog_product_entity_int`;
TRUNCATE TABLE `catalog_product_entity_media_gallery`;
TRUNCATE TABLE `catalog_product_entity_media_gallery_value`;
TRUNCATE TABLE `catalog_product_entity_text`;
TRUNCATE TABLE `catalog_product_entity_tier_price`;
TRUNCATE TABLE `catalog_product_entity_varchar`;
TRUNCATE TABLE `catalog_product_link`;
TRUNCATE TABLE `catalog_product_link_attribute`;
TRUNCATE TABLE `catalog_product_link_attribute_decimal`;
TRUNCATE TABLE `catalog_product_link_attribute_int`;
TRUNCATE TABLE `catalog_product_link_attribute_varchar`;
TRUNCATE TABLE `catalog_product_link_type`;
TRUNCATE TABLE `catalog_product_option`;
TRUNCATE TABLE `catalog_product_option_price`;
TRUNCATE TABLE `catalog_product_option_title`;
TRUNCATE TABLE `catalog_product_option_type_price`;
TRUNCATE TABLE `catalog_product_option_type_title`;
TRUNCATE TABLE `catalog_product_option_type_value`;
TRUNCATE TABLE `catalog_product_super_attribute`;
TRUNCATE TABLE `catalog_product_super_attribute_label`;
TRUNCATE TABLE `catalog_product_super_attribute_pricing`;
TRUNCATE TABLE `catalog_product_super_link`;
TRUNCATE TABLE `catalog_product_enabled_index`;
TRUNCATE TABLE `catalog_product_website`;
TRUNCATE TABLE `catalog_product_entity`;

TRUNCATE TABLE `cataloginventory_stock`;
TRUNCATE TABLE `cataloginventory_stock_item`;
TRUNCATE TABLE `cataloginventory_stock_status`;

insert  into `catalog_product_link_type`(`link_type_id`,`code`) values (1,'relation'),(2,'bundle'),(3,'super'),(4,'up_sell'),(5,'cross_sell');
insert  into `catalog_product_link_attribute`(`product_link_attribute_id`,`link_type_id`,`product_link_attribute_code`,`data_type`) values (1,2,'qty','decimal'),(2,1,'position','int'),(3,4,'position','int'),(4,5,'position','int'),(6,1,'qty','decimal'),(7,3,'position','int'),(8,3,'qty','decimal');
insert  into `cataloginventory_stock`(`stock_id`,`stock_name`) values (1,'Default');
Delete Categories:

TRUNCATE TABLE `catalog_category_entity`;
TRUNCATE TABLE `catalog_category_entity_datetime`;
TRUNCATE TABLE `catalog_category_entity_decimal`;
TRUNCATE TABLE `catalog_category_entity_int`;
TRUNCATE TABLE `catalog_category_entity_text`;
TRUNCATE TABLE `catalog_category_entity_varchar`;
TRUNCATE TABLE `catalog_category_product`;
TRUNCATE TABLE `catalog_category_product_index`;

insert  into `catalog_category_entity`(`entity_id`,`entity_type_id`,`attribute_set_id`,`parent_id`,`created_at`,`updated_at`,`path`,`position`,`level`,`children_count`) values (1,3,0,0,'0000-00-00 00:00:00','2009-02-20 00:25:34','1',1,0,1),(2,3,3,0,'2009-02-20 00:25:34','2009-02-20 00:25:34','1/2',1,1,0);
insert  into `catalog_category_entity_int`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) values (1,3,32,0,2,1),(2,3,32,1,2,1);
insert  into `catalog_category_entity_varchar`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) values (1,3,31,0,1,'Root Catalog'),(2,3,33,0,1,'root-catalog'),(3,3,31,0,2,'Default Category'),(4,3,39,0,2,'PRODUCTS'),(5,3,33,0,2,'default-category');
Categories
eCommerce Magento

The One Page Checkout.

Over the last three weeks I have been developing a onepage checkout for Magento for our client. Today I am happy that the biggest problem seems to possibilly be done. I just placed an order with it and got a sucess page.

The Requirements:

  • Card Storage Capability
  • Verification of Card CV2 on using stored card
  • Add new Card
  • Integration with SagePay

The Problems

  • Shipping Methods are not availible
  • Format of data for Sage Pay
  • Built in Card Form not sutible for workign with payment storage
  • PCI-DSS as we’ll store the card information.
  • Magento fighting with us.

The strategy taken was to load each block from the standard one page checkout into the new single page one page checkout and display those all at the same time. Then for processing the order just reuse the built in continue button function calls. This of course did have its own unique set of issues.

For example, the saving of the payment sees the card number as being empty when we use a stored one so we need to get around that. Not to forget we can display the full card information either. So have to overwrite the checks on the card form to allow partly submitted form (display CV2 request but not main form).

I think today we will finally be able to call this project complete.