Export ADS Image Extra Information to an Excel file
The Image Extra module by ADS does not come with a stock export utility so I have written instructions to export the Image Extra settings to a file using phpMyAdmin
These instructions assume you have access to your Miva Merchant database via phpMyAdmin.
- Open phpMyAdmin and select your Miva Merchant database
- Select the ‘SQL’ tab
- Copy and paste the following text into the text area (If your store is not ‘s01’ then you should update the query to reflect the correct store). This query checks to see that there is information in the Image1 URL. If there is no data in that field then it will not export the data
- When the results are displayed scroll to the bottom and click ‘export’
- If you use Excel then use the following settings:
- CSV for MS Excel
- Check ‘put field names in the first row
- Check save as file
- Click go
- Save the file to your computer and you can then open it in MS Excel, edit it, then import it using the ADS Image Extra Import utility.
SELECT *
FROM s01_ADS_IEProdImgs,s01_Products
WHERE s01_ADS_IEProdImgs.id = s01_Products.id
and s01_ADS_IEProdImgs.img1 > '0'
New Miva Merchant Referral Program pays 55 dollars plus bonuses
Affiliate Hosting Program Details
Refer someone to us and we will give you the first month’s hosting fees as soon as that site goes live on our servers. We pay referral fees on all of our hosting accounts. Signing up is simple and free.
If you are a web master, developer, or web designer then this is a great way to make extra money. Morditech’s hosting services are fast, secure, and reliable so you can rest assure that the clients you refer will be very happy with the service they receive here. At your request we can even transfer the website files for you and place them all under the same PLESK control panel login.
PCI Compliance Scans Are Flagging Non-compliant Versions Of Miva Merchant
Up until now it seems that even non PCI Compliant versions of Miva Merchant were not getting flagged by some PCI Compliance scannig agencies such as SecurityMetrics. We came across a site that was being flagged as having ‘Possible blind sql injection’ and it was followed by a bunch links to the merchant Miva Merchant store. Often times the PCI Compliance scanners do raise false positives and in fact this is one of those times but simply running the latest streaming update from Miva within the Miva Merchant admin allowed this site to pass the scan. Your other option is to contact your PCI scanning company and alert them that this is a false positive and hopefully they comply. You should check with a Miva specialist to make sure the streaming updates will not conflict with any modules or customization that have been made to your store. It is also good practice to check that your additional modules are updated to the latest versions as well.
ALERT: Security Metrics PCI Compliance Scanning is now picking up on non-compliant versions of Miva Merchant.
SOLUTION: Stream the latest Miva Merchant updates from the Miva Admin (If it has been a while since the last time you ran the updates and your store is customized you may want to check with your web master or Miva Specialist before running the updates).
Problem Summary per Security Metrics:
Possible blind sql injection on http://www.domain.com/Merchant2/merchant.mvc?Category_Code=100&Current_Product_Code=&Store_Code=NTFL&Screen=OINF&Offset=&Attributes=Yes&%3FAction=ADPR style=”display: none;”> wp –bsql “http://www.domain.com/Merchant2/merchant.mvc?Category_Code=100&Current_Product_Code=&Store_Code=NTFL&Screen=OINF&Offset=&Attributes=Yes&%3FAction=ADPR” “http://www.domain.com/Merchant2/merchant.mvc?Category_Code=100&Current_Product_Code=&Store_Code=NTFL&Screen=OINF+and+1%3D1&Offset=&Attributes=Yes&%3FAction=ADPR” “http://www.domain.com/Merchant2/merchant.mvc?Category_Code=100&Current_Product_Code=&Store_Code=NTFL&Screen=OINF+and+1%3D0&Offset=&Attributes=Yes&%3FAction=ADPR” POST cat <<EOF > bsql.sh curl -L -d “Category_Code=100&Current_Product_Code=&Store_Code=NTFL&Screen=OINF&Offset=&Attributes=Yes&%3FAction=ADPR” “http://www.domain.com/Merchant2/merchant
Read the official Google SEO starter guide
Google has a downloadable PDF titled ‘Google’s SEO Starter Guide’. It explains many of the basics and fundamentals that every website owner, web developer, and web designer should know. This is the official Google SEO starter guide by Google and not some SEO firm that claims to have the magic bullet.
Download it print it, grab a cup of coffee sit in a nice comfy chair and read away and of course make sure you apply these principles to your Miva Merchant Store.
Google SEO Starter Guide PDF Download
In case you would like to read this in another language use this link Google SEO Starter Guide in other languages
Support Disaster Relief in Haiti
On January 12, a 7.0 magnitude earthquake struck Haiti. Join recovery efforts mobilizing around the world to assist earthquake victims. Your donation will help disaster victims survive, and rebuild their lives and their communities. With this link you can donate money to appropriate organizations specifically for “Haiti Disaster Relief” Google is also donating $1 million to help organizations provide relief.
This link on CNN gives you a list of organizations that you can send donations to or volunteer.
Please be kind and compassionate to your fellow human beings. This money will go to prevent people from dying RIGHT NOW from simple infections and other preventable causes.
Make Your Miva Merchant Store Extremely SEO Friendly
Finally, there is a list of SEO recommendations to implement on your Miva Merchant store to make it more appealing to search engines when they crawl your site. Miva Merchant is not completely search engine ready straight out of the box. The Miva Merchant SEO recommendations made here are my opinions based on 10 years of experience working with hundreds of Miva Merchant stores. There is no guarantee that implementing these changes on your site will get you top search engine listings because that is mostly dependant on you and your content and of course your competitors but I will guarantee that using these techniques will get you better search engine rankings than you have now. Read more
Add a Miva Search box to any miva page
You can add a search box to virtually any page in Miva Merchant and it is very easy to do. You will have to have a little knowledge of Miva
page templates and a teensy bit of html.
Here are the instructions:
- Figure out where you want to add the search box
- Log into your Miva Admin
- Find and edit the appropriate page or section of Miva that you want to add the search feature
- Add the following code but make sure you do not add this code within a different form:
<form method=”post” action=”&mvt:global:sessionurl;”>
<input type=”hidden” name=”Store_Code” value=”&mvte:store:code;”>
<input type=”hidden” name=”Screen” value=”SRCH”>
<input type=”text” name=”Search” size=”40″ value=”Search Our Products”>
<input name=”" type=”button” value=”Search” />
</form> - You can customize the button value and the search field value to your personal preferences
Enter to win a Free Year of all inclusive Miva Merchant Web hosting with morditech here
2010 New Year Miva Merchant Promotion $12.95 a month Hosting
Now is the time to move your store to a different Miva Merchant web host!
Start off the New Year by saving your company some serious money!
We are offering Miva Merchant store owners 3 months of Miva Merchant hosting at $12.95 each if they allow us to move their store to Morditech. After that the price will be 10% less than our standard rates. You get everything you have now except more of it. Our hosting packages offer more disk space and bandwidth usage than your current web host.
This promotion is valid on new stores and multiple store transfers as well.
There are no setup fees or any other hidden charges. We bill quarterly or annually based on your personal preferences. When you pay annually you get an additional 10% off and we include a private business SSL certificate.
To summarize you only pay $12.95 a month for the first three months. Then you get 10% off of the standard price for the rest of the time you are with Morditech plus we will include and install a private SSL certificate.
Our transfers are hassle free and seamless. We move your store, files, email, databases etc. for you so you do not have to worry about anything and the transfer is seamless. Your customers will not even know anything changed. There are no hidden fees, extra charges.
To find out more information or to sign up for the transfer please click the following link, email us or give us a call.
This account requires 12 month minimum contract.
Miva Merchant SEO Tune UP Service – $399
Great content and keywords alone will not get you top search engine rankings. Your Miva Merchant store must be customized to cater to search engines to get optimal rankings. All the time, effort and money you spent on keyword research to maximize your organic search engine listing may be futile if the search engines cannot decipher your main keywords from your supporting content. If the search engines do not know what the image on your product page is then it will not show up in search engine listings.
The fact is that straight out of the box Miva Merchant is not completely optimized for search engines. For optimal search engine listing results then this service is an absolute must.
We do not use any tricks or information that is not readily available to you. We simply apply SEO basics and fundamentals to your store.
If you have good content but your web pages are still not ranking as well as you believe they should then the problem is most likely the structure of your Miva Merchant store pages. The Miva SEO tune up will make sure your category, product and storefront pages are dynamically generated and displayed with the best possible SEO fundamentals in place. If you already rank well the tune up should help you rank even further.
There are several SEO fundamentals that every web page must have in order to be ranked by top search engines appropriately. The most fundamental and important rule of SEO according to any expert is good, accurate, and unique content. Most of the other SEO fundamentals support the content of the page and is contained within the source code of the page which is why many times it is so hard to pin point why your competitor’s pages come up higher than yours in search engines.
Though we do not guarantee that your search engine results will get better it is very likely
The Miva Merchant SEO Tune Up by Morditech
The following is a summary of everything included with the Miva SEO Tune Up
If you would like to learn more about SEO with Miva Merchant please read this article written by Eric Mandell
- Short Links - We will replace the long Miva Merchant product and category links with short links throughout your entire store. We will also make any and all necessary 301 permanent redirects so any and all pages that are indexed by search engines will not be missed or affected negatively.
- Page Title Tags – We will Format and clean up the page Title Tags to display the category and/or product names or the contents of a custom field.
- H1 Tags – We will make sure your category names and product names on your category and product pages have the appropriate h1 tags at least once on each page
- Alt Tags – We will make sure your product images have the appropriate alt tags on the category and product pages
- www 301 redirect – If your hosting server allows it we will set your store to redirect all traffic from ‘yourdomain.com’ to ‘www.yourdomain.com’ to make sure search engines are not splitting your rank between the two.
- Canonical Links – We will create canonical links on your product and category pages to make sure search engines recognize your original content pages.
- Google Sitemap – We will setup and install the template data feed module so you can create Google sitemaps and submit them to Google. We will show you how to do this as well. We will do the first one for you.
- Google Product Feed – Using the Template Data Feed module we will create a google base product feed and and submit it to google. Although this is not part of SEO it will dramaticall increase your product views and sales.
Tweet up your WordPress Blog
I found a great new plugin for WordPress that allows you to display your latest tweets in your sidebar, post tweets from your sidebar or within the WordPress admin and also automatically tweets your new WordPress posts. It seems to have everything you need for your Twitter and WordPress integration all built in.
The name of the plugin is “Twitter Tools” and you can check it out here: http://alexking.org/projects/wordpress
In addition you can add a twitter “Follow Us” type badge to your blog like the one you see here on the right of the page. I used WP-TwitterBadge but there are several out there that all seem to do the same thing.
Have fun and tweet amongst yourselves!