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
POLL QUESTION:  

Which social network do you use most often?

View Results

Loading ... Loading ...

Posts Tagged ‘details’

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.

Enjoy!


>> Did you like this article? Ping it!

 



seenBEST Web Design

Leave Your Competition in the Dust.

Thursday, September 9th, 2010

For a couple of years now I have watched beautiful things happen to a business that has put together an effective web design, coupled with a solid SEO and online marketing plan. There are tools that we use in the industry to track traffic, and you can literally watch traffic climb higher and higher with every passing day. Comparing the traffic reports of company websites, before they began focusing on going after online business, and after, is a real eye opener. If you haven’t already seen it for yourself you would be amazed at the difference in traffic between a top ranked page and one that falls further down the list, several pages deep.

Guess what all of this traffic results in? More sales, more phone calls, more opportunities. I shudder when I find a client that tells me they can’t afford to spend as little as $80 promoting their website. First, because it’s not really spending. You are investing in your business – the goal is to recover those costs, and a whole lot more, via increased business. Second, because it’s so affordable. I’ve seen clients waste thousands of dollars on marketing that doesn’t work – like yellow page ads, printing up fliers, etc. then turn around and tell me that they can’t afford an $80 online marketing plan. It’s nuts!

I’m not saying that people don’t have valid reasons for not wanting to spend money. There are so many people out to scam businesses in our industry. You see spam email every day of SEO providers that promise results. Some people have come to us after being taken by these companies and tell us – well, I’ve done that, it didn’t work. Guess what? It didn’t work because the people took your money and didn’t deliver! That’s the toughest thing about working in this industry, there’s a constant need to prove your worth, prove that you can deliver what you say you can, because other people have placed doubt into the minds of many. In this regards, online marketing and SEO is a lot like automobile repair. Sure, there are a lot of people out to rip you off – they take advantage of the fact that you don’t really know the details of what they are selling you, so you can’t verify that you’re getting anything in return. But the flip side to that is, every once in a while, you find an honest mechanic. Just like auto repair, there are honest companies out there that can and will work wonders for your traffic and sales.

Leaving your competition in the dust

(PS, if you live in the Phoenix area and you need an honest mechanic that does great work, let me know. My friend owns a business called Mile Auto Repair in Tempe. Always honest service!)

Anyways, back to the point. Investing (not spending) a little extra money to build your business base through SEO and online marketing is worth it in every way. Simply adding your business link to a few online directories and making a Facebook page is not enough to expect results. You need to engage in a serious effort to get found, with strategy and planning that will put your products and services in front of the people that are ready to buy from you. It all starts with a keyword analysis and a consultation to determine exactly who your ideal target client is, and the best ways to reach them. There are multiple tools that get called into play to help do research and isolate important keyword phrases that will help your website perform its best. At the end of the day, your website shows up and the competition does not.

Soon you will see more people asking you for business. If you’re not doing this right now, you’re being beaten by companies who are. If you’re trying and you’re not seeing results, you’re being beaten by competition who is. Building your website for higher traffic and positions is like leaving your competition in the dust. The higher your ranking, the better response from new customers, and the further behind your competitors will fall to your trail. Remember, it’s called the information SUPER highway for a reason. Online search is the future of all business transacted and if you’re driving along in an old, beat-up pinto – sooner or later you’re going to break down.


>> 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

NAME:*
EMAIL:*
PHONE:*
MESSAGE:*
CAPTCHA*