This functional, easy to use application can be used by Flooring Installation Professionals, Contractors, Architects, Engineers and Building Professionals when on the go product, technical and installation information is needed. ARDEX delivers innovation and time tested, consistent solutions to the most complex installation problems while continuing to be…Your Best Choice For Installation Success!

ARDEX Americas Product Calculator on the Android Market Place

Their website: www.championshipchasetv.com

All images are copyrighted to Championship Chase TV

Resloves the following issues

• “Critical – Error uploading file” dialog appears and the “Attaching files” line sort of sits there and spins
• java.io.FileNotFoundException: zimlet description not found: com_zimbra_dnd.xml
• undefined file description after upload

Tested and works under the following browsers versions: Firefox 3.5.x, 3.6.x, 6x, 7x
Works with Zimbra 6.0.14 and may work with other subsequent versions please report.

Install Instructions

download Drag-and-Drop Attachments 1.0.1 otel consulting update

once downloaded go into Zimbra Administration : Configuration > Zimlet

undeploy the old com_zimbra_dnd

click “deploy” and select the updated version of com_zimbra_dnd you just downloaded and make sure you select “Flush zimlet cache” and click deploy

Under the Magento Admin : System > Configuration > Design is where you want to be. You also want to make sure you have the “mCommerce – iPhone theme” or some mobile designed theme to server as your secondary store alternative for your mobile based clients.

Configuration

Depending on how you want to serve up your store depends on what configuration you want.

Option #1 : Show mobile version on Any Mobile Based OS (phone & tablet)

iPhone|iPod|BlackBerry|Pre|Palm|Googlebot-Mobile|mobi|Safari Mobile|Windows Mobile|Android|Opera Mini|mobile

Option #2: Show mobile version to just phone based browser and Display normal desktop version on tablet based devices

(iPhone|iPod|BlackBerry|Pre|Palm|Googlebot-Mobile|mobi|Safari Mobile|Windows Mobile|Android|Opera Mini|mobile)|(!iPad|Xoom|SCH-I800|Tablet)

After you have chosen one of the configurations above go under the Design “Themes” section and add it to the following sections (Template, Skin, Layout, Default) in the “Matched Expression” field.  Then in the values section you should put in “iphone” in the value field. If you have a different mobile theme then your value field should be the theme name. Then click save config.

So just to recap what we did: We are saying hey Magento if the “Browser User-Agent” matches any of the following “Matched Expressions” then change the theme directory to “Value”.  Make sure you test your new configuration on a mobile platform. If you don’t have any mobile devices to test with we recommend using Safari and following this great how-to “Using Safari for iPhone, iPad and iPod Touch Website Testing”

Supported Browsers in this script as of October 2011

Phone Based Browsers:

• iPhone / iPod
• Android
• Palm
• Blackberry
• Windows Mobile

Tablet Based Browsers:

• iPad
• Galaxy Tablet
• Any Android Tablet
• Xoom
• HP WebOS

What many of these services have in common is discounted merchandise. To therefore take advantage of some of these portals, your company may have to mark down its products to compete with the similar discounted items on the site. Alternatively, these services can be good way to sell excess stock at a lower price.
Large-Sized Search Engine Solutions

Google, Yahoo! and Bing all have their own shopping search engines that you can register your products with. They vary from being free to flexible fee-structures, depending on items sold. If just starting out, you may want to focus on a free option. You may also want to focus on a search engine that you don’t get a tremendous amount of traffic, to help build awareness of your brand with a new group of potential customers.

Google Product Search
Google’s product search is a useful way to expose your products to more shoppers on one of the most popular search engines on the web. Your products will appear in the Product Search engine but also may appear on Google’s standard search results depending on the relevance of the product to the search being performed.

Price: Free.

Yahoo! Shopping
Submit your products to Yahoo! Shopping, provide a detailed description, and Yahoo! will do the rest. Each submission will be listed on Yahoo! Shopping in both the general product search and product comparison pages. All you need is a Yahoo! Search Marketing account. For Yahoo! store merchants, use the merchant solutions service to publish your catalog.

Price: Submitting products is free; Search Marketing plans vary from free to a one-time $99 fee; Additional fees for purchases on Yahoo! Shopping also apply, including its bidding service, which affects the placement of the product in-search.

TheFind
TheFind is a powerful comparison shopping service and has probably already found your store’s products with its search bot, but merchants can play a much more active role by setting up a merchant account with The Find. Once you are registered, you can submit a comprehensive product feed to the service of all products available, update that feed as often as desired, and control your store’s brand and logo as seen from TheFind. You can also pay to have your products featured and increase traffic to your own site.

Price: Free – $299.

Bing Shopping
A free service from Microsoft that gives access to your products to one of most widely used search engines on the web. You have to contact a Microsoft Advertising representative to get started and once you sign up, all you have to do is send your Bing Shopping data feed to Microsoft.

Price: Free.

Comparison Shopping and Shopping Directories

These are shopping destination sites that offer thousands of popular brands and products, usually at a discounted price. I’ve tried to focus on general and popular shopping sites and comparison sites. If you are interested in the dozens of niche online marketplaces, check out my previous article, “How To Set Up Shop on Niche Online Marketplaces,” for more information on that process.

Amazon
It’s one of the most costly sites to list your products, but it is also has high traffic and could be worth the cost for the right merchant.

Price: Structure varies on amount of items sold – 40 items or less monthly, $.99 per sale plus 15 percent referral fee and variable closing fee per item starting at $.45 to $.05 per pound; 40 items or more monthly, flat $39.99 for unlimited sales plus the same referral and closing fees.

PriceGrabber
A price comparison search engine, PriceGrabber gets roughly 24 million unique visitors monthly looking for deals. Merchants can list their products for free and then only pay when a shopper clicks on their product. The merchant then pays a cost-per-click fee. The nice thing here is that once the shopper clicks through on PriceGrabber, the shopper finalizes the sale on the merchant’s website.

Price: $.35 – $.90 per item clicked, depending on category of product.

PriceScan
Any merchant can list a product here, but you need extremely competitive prices or PriceScan will not list your product if it is higher than the similar products that it already lists.

Price: Free.

Shop.com
Another shopping comparison directory that merchants can list products on with two payment options: Cost-Per-Order (CPO) and Cost-Per-Click (CPC). CPO means merchants pay a negotiated commission to Shop.com and comes with some additional benefits when selling with them. CPC is a per-click fee program with varying rates that depend on the product and category.

Price: Varies with product and product listing program in use.

Shopping.com
Owned by eBay, Shopping.com has a large following in the comparison-shopping world with an average of 20 million unique visitors monthly.

Price: $.05 – $.90 per item clicked, depending on category of product.

ShopWiki
A shopping search engine that crawls for products and stores and lists them in their search results. If your store is not already listed, you can simply type in your store’s URL and add it to ShopWiki’s index. Once your URL has been added, your products should start appearing in ShopWiki’s search results within 3 to 4 weeks.

Price: Free.

ShopZilla
A widely used shopping comparison directory that merchants can take advantage of. Shopzilla is free to register and list products on, but it uses a similar cost-per-click (CPC) fee structure as many other comparison sites. Register a Shopzilla merchant account and pay a minimum of $50, which will all go towards the CPC fee for each item purchased through ShopZilla.

Price: $.05-$.90 per item clicked, depending on category of product.

QR stands for “quick response” and this strange-looking little square is a barcode that holds encoded information, commonly URLs. By downloading a QR reader app, smartphone users can take a picture of the code and have it read and decoded. If you try your app on the above code, you’ll be directed to our company website. The codes can be generated for free on a number of websites. Our favorite is QRstuff.com generator with its high resolution downloads and easy to configure this makes things very user / designer friendly!

Becoming inventive with where and how to use them is our specialty. QR Codes have used for Posters, Magazine Ad, A Video about your Company or Service, Coupon, Competition, T-Shirts & Promotional Products. But the possibilities are pretty much endless.

In our next article “coupling QR codes with Google analytic” we will talk about how you can turn a simple print ad into a statistical marketing platform and find out what types of customers are interested in your ad.

Bottom Line is QR codes make the electronic connection with Print media and the End Users smart phone.

In reference to the following article “valorcorp.com API – Getting Stock Status” at the companies blog site they had a ASP solution in place to get the real time stock level with the Valorcorp Inventory API. All we need to do was convert that to PHP and feed it into magento.

function Valor_GetCurrentStock($APIkey, $ItemNumber){
	$ch = curl_init();
	curl_setopt($ch, CURLOPT_URL, 'https://www.valorcorp.com/api/stock_status2.0.asp');
	curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
	curl_setopt($ch, CURLOPT_TIMEOUT, 4);
	curl_setopt($ch, CURLOPT_SSL_VERIFYPEER , false );
	curl_setopt($ch, CURLOPT_SSL_VERIFYHOST , false );
	curl_setopt($ch, CURLOPT_POSTFIELDS, "key=$APIkey&item=$ItemNumber");
	$result = curl_exec($ch);
	curl_close($ch); 
 
	#Match Item Number
	if(preg_match("/(.*)<\/item_number>/i", $result, $Matches)){
		$RTNarray['itemnumber'] = trim($Matches[1]);
	}
 
	#Match Stock
	if(preg_match("/(.*)<\/in_stock>/i", $result, $Matches)){
		$RTNarray['stock'] = trim($Matches[1]);
	}
 
	#Match Description
	if(preg_match("/(.*)<\/short_description>/i", $result, $Matches)){
		$RTNarray['description'] = trim($Matches[1]);
	}	
 
	if(!is_nan($RTNarray['stock']))
		return $RTNarray;
	else
		return false;
}

$ArrValorStock = Valor_GetCurrentStock("YOUR-API-KEY-HERE", "Valor Item Number");

The function listed above will return an array of the information based on the Valor Corp Item ID. With magento you can setup up a custom attribute per items to make the relation between your item number and the valor corp item number. Which can then be used to update the stock levels in Magento.

Reference for what is returned from the function:
Valor Corp Item Number : $ArrValorStock['itemnumber']
Valor Corp Stock Level Number : $ArrValorStock['stock']
Valor Corp Description : $ArrValorStock['description']

If you need help doing this for your Magento Store or Any other Shopping Cart System please contact Otel Consulting

First you want to go to TheFind and register as a merchant. Once you’ve setup your account go to your TheFind Merchant Center Dashboard for your store.

On TheFind Merchant Center Go to Product Info > Product Feed Setup.

Settings
URL: Your store URL. (ie: http://www.mystore.com/)
Feed Format: TheFind
File Type: .txt
Notification: Any option will do but for the first setup i would recommend on every import then you can always change it.

After you have completed that step TheFind will make you create your FTP account.
Write down your username & password.

Now for the Magento Part

In the Magento Admin go to System > Configuration > TheFind > Feed

Settings
FTP Server: ftp.thefind.com
FTP Path: /
FTP User: Your TheFind FTP username
TheFind Feed Filename: anyname.txt
FTP Password: Your TheFind FTP password
Update TheFind Item when Product is Updated: Yes
Cron Frequency: I set mine to daily.  According to TheFind, at minimum it must be updated every 7 days.
Cron Hour: anyone will do just fine.

Next step will actually be configuring the mapping of Magento Data to TheFind Data.

In the Magento Admin, go to Catalog > TheFind Feed > Manage attributes
You’ll need five attributes, at minimum, to get your product to appear on TheFind.
Click on “Add new” at the top and match the following attributes:

Finally Add your items!

In the Magento Admin, go to Catalog > TheFind Feed > Manage Items

Pick the items you want to add and click publish from the action drop down in the top right corner of the grid.

TheFind says it can take 24-72 hours before your items appear but mine appeared instantly.

How to Test to see if you’re publishing?

You can log into TheFind’s FTP server with your given username and password you used in the step above and see if your txt file is in the root directory.
Then after a couple days search your company name on TheFind and see if your items are there.

If you need help doing this for your Magento Store please contact Otel Consulting