Web Design, Internet Marketing, and SEO News

by seenBEST Web Design in Phoenix, Arizona

RSS feed for seenBEST Web Design news Entries (RSS)
Comments (RSS)
About Us
Log in

Which social network do you use most often?

View Results

Loading ... Loading ...

Posts Tagged ‘status’

Google+ (Google Plus) Directories – Add Your Profile Link and Connect!

Monday, August 8th, 2011
Google+ Directory List

Google+ Directory List

plus.google.com (Google+) is the fastest growing website in history, according to analytics firm comScore. As of July 24, less than one month after the Google plus test site was launched, 25 million invitation-only users are organizing, sharing, and communicating with people through Google’s Circle technology.


Do you need an invitation to Google+? Click here to use on of our 150 available invitations, and add yourself to Google+!


Social networks are only as interesting as the content they provide to the user, that content coming in the way of status updates and posts from users in your network. Google+ has quickly become a major social network, and users are looking for more ways to search for and connect with other Google Plus users. Would you like to find more users to interact with on Google+, increase the usefulness of your network, and fill your stream with news and information that closely matches your own interests? Check out the following Google+ Directories. At the end of this post you’ll have the ability to post your own Google+ profile, where others can find your profile and circle you!


1. Find People On Plus. This Google Plus directory was introduced by Google to make searching on specific Google Plus profiles much easier. You can search not only on names but on all specific profile fields provided on Google Plus. As of August 4, nearly 10 million Google Plus users have been indexed on this site.


You’ll find an indexed list of the most popular Google Plus users on the FindPeopleOnPlus.com home page. On the left sidebar, choose filter parameters in categories such as Relationship, Looking for, Gender, Occupation, and City from the category shortcuts. Click on the People Directory link to surf profiles and track people.


Twitter users can also find out which of their followers and friends are on Google Plus. Go to www.findpeopleonplus.com/twitter2plus/ and type in your Twitter name.


2. GPEEP. GPEEP is a Google Plus search engine where you can search for people on Google Plus. Just type the person’s profile name or other search term in the Find People on G Plus box at the top of the home page. You can circle the profiles you’re interested in, and read, comment on, and share their posts. Or just for fun, click on Google’s famous I Feel Lucky button in the left sidebar and see who you meet!


Make it easy for people to find you, too. Click Add Yourself Now in the upper left hand corner of the page and provide the simple information requested. Be sure to tag yourself with as many search criteria as you can think of. Your profile can be found immediately on GPEEP. You can even let people know what type of product or service or job qualifications you offer by clicking on Add a Pitch or a Deal near the top right of the home page.


3. Google. An easy way to find Google+ users is just to use Google itself. Enter this search term – site:plus.google.com – and any parameter, such as a profession, town, type of business, or even a name. Users who have created public profiles are searchable, as are their updates and posts. Privacy options may protect some user profile information from search results, but most of the data provided on the Google Plus About page and in the profile fields is currently public.


An additional way to use Google+ to connect with other similar minded potential friends is the “Find People” link, located within the Circles tab of Google+. To use this feature, click the “Circles” tab at the top of your Google+ profile. From there, click on the “Find People” link. You will be presented with a list of suggested users, allowing you to drag and drop them into any of your circles, or create a new circle out of recommended users only. Google closely matches the suggested users with interests you’ve listed in your profile, and Sparks, so be sure to fill out your profile and select topics of interests from the Sparks tab in order to benefit the most from this feature.


4. Women of G Plus. The WoG Plus site started as a way for Google Plus women users to connect and share their ideas. Although the designer insists “this is not a women vs. men thing,” it is primarily a networking resource for Google Plus women, who currently comprise 33 percent of Google Plus users. The site provides articles and blogs from Featured Women of Google Plus, and offers tips to “Optimize Your Google Plus Profile” and other Google Plus tutorials and how-tos. If you want to contribute, click on the Want to Be Featured? tab at the top of the page.


Want to read more? Connect with these Google+ profiles for more interesting information in your stream:

seenBEST Web Design

Importing a CSV of products to Magento

Thursday, September 16th, 2010

We have recently designed a highly functional new online store for a client of ours using the advanced Magento shopping cart, taking eCommerce for this business to an entirely new level! We ran into a small snag during the initial stages of development as the client has a proprietary database system that stores detailed information for several hundred products. Their database software held everything from product name, pricing information, description. The client did not have the time to recreate all of the product information in the back-end of Magento using the built in tools. So, the challenge: How do we extract this information from their locally installed database information in a way that could be easily imported and put to work in Magento?

Fortunately, the database storing the client product details provides a mechanism to export product information to a CSV file. While it wasn’t pretty, the data was all there on the export. Sorting through 30 fields of data we didn’t need, we found fields for product name, model, color, asking price, category, and photo name. The trick now was figuring out how to map and then import this data into Magento.

The trick that helps you with a Magento import is knowing what’s absolutely necessary to import, and supplying that data in your own custom xls file. To do that, we added a product manually through the Magento interface. Here’s how:

  • Click on catalog/manage products
  • Click on Add Product
  • Click through to enter a name, description, short description, sku, weight, status (enabled), and set visibility.
  • Go to prices, enter a price, and tax class
  • Click to the inventory area and set an initial quantity, then change stock availability to in stock
  • Click to the category area and assign the new product to a category

Now save your product. If everything went according to plan, you will see your new product listed in your store under the selected category you selected previously. Great! Now that we have a functional product to work with, one that appears in the store, it’s time to export that data to a CSV file.

Exporting Magento items:

  • Go to system, import/export, profiles from the admin panel
  • Click on export all products
  • The default values are fine, CSV/Tab Separated, attribute names, all fields
  • Click on run profile to generate your CSV file

Now look in your Magento directory on your server, and find the var/export folder. The file export_all_products.csv will be on your server, download this to your local computer and open it in your favorite spreadsheet program (Excel works well!).

Now comes the tricky part. View export_all_products.csv side by side with a CSV of the data from your other database product. You are going to need to make the data from your previous database match the Magento data. I don’t want to tell you exactly how to do it, there are many different paths you can take to get to the same result. Find the fastest way that works for you. For me, it was as easy as deleting all of the columns from the old database CSV that weren’t used in Magento, renaming the column names to match similar columns in Magento, then creating columns that Magento needed that did NOT exist in the old data and pre-populating it with standard info. The fill function in Excel is extremely useful for this.

At the very least, you will want to make sure you have these columns:

  • store
  • websites
  • attribute
  • type
  • category
  • sku
  • name
  • url_key
  • url_path
  • price
  • weight
  • description
  • short description
  • status
  • tax_class_id
  • visibility
  • enable
  • qty
  • product_name
  • product_type_id

Try to be as complete as possible, and include as many (if not all) of the fields from the original Magento export as you can in your new set of data to import. Leaving out something important could result in a botched import!

When you’re all finished and, depending on the size of data you’re dealing with, several minutes/hours/days/weeks later, you will have a new XLS file that you can save, ready for import to Magento. Go to System, Import, Profiles. Import all products. Be sure to increase the “number of records” to a higher value, like 3, if you’ve already modified and improved your Magento memory settings. I also like to import using the MS Excel XML (save to this format first) as it’s less prone to data errors caused by improper characters in the data stream. Save the file as XML Spreadsheet 2003, change the data type, then use the upload file tool to upload your XML file.

The process CAN take a long time, so be sure you leave the import window up during the process. With a little luck, all of your products have been imported! There is a way to do this while including images, but it gets a little complicated. With the method I’ve discussed, you will need to go in and manually upload images to each item. While that can be somewhat labor intensive, I like having Magento create proper names and file sizes for me for each product.


>> Did you like this article? Ping it!


seenBEST Web Design

Need a digital presence for your business?
Piece of cake! Call Us Now (480) 256-9010

Request a Free Quote