Rss Feed Tweeter button Facebook button Technorati button Reddit button Myspace button Delicious button Digg button

Export ZenCart products, Import Magento products: Summary

Here is a summary of the CSV file downloaded from ZenCart, edited then uploaded to Magento.

If you are new to Magento you may wish to read first my previous posts on importing basic products into Magento from ZenCart, configuring the Magento CSV file and importing categories and images.

Overview:

Creating a Magento product CSV from a ZenCart file is straightforward and easy.

I open a sample Magento file and then copy and paste the Zen-cart columns, deleting the column when it is copied over to keep track.

Then simply bulk copy and paste the remaining Magento specific rows – it only takes about 4 copy and pastes. Change the image details then sort out the categories. Upload and done.

Magento Headings    Information Required               ZenCart Equivalent

store                            default: admin

websites                    name of every website using this product

eg myweb1, myweb 2 (comma separated)

attribute                    Default

type                             simple

category_ids           the number of the category     v_categories_name_2

simply find and replace to convert them

sku                               model number/stock code       v_products_model

has_options             0

name                            product name                          v_products_name_1

meta_title  meta_description   url_key url_path page_layout options_container

I leave all these blank although you could copy and paste them from your ZenCart database if you wanted.

gift_message_available  default: Use config

price                            cost for buyers                                    v_products_price

special_price  /  cost    I leave these 2 blank

weight                         weight for shipping purposes  v_products_weight

status                          Enabled           ensure this is set for all products else they do not show

tax_class_id            Taxable Goods

is_recurring             No

visibility                   Catalog, Search

enable_googlecheckout           set all to Yes or No if you want to use Google checkout

description              product description                 v_products_description_1

short_description     either copy in description again or leave blank (I leave it blank)

meta_keyword custom_layout_update  special_from_date   special_to_date news_from_date news_to_date            custom_design_from  custom_design_to

I leave all these blank

qty                              number in stock                       v_products_quantity

The following depend on your set up. Most will be 0 or 1. Below is mine:

min_qty                    0

use_config               1

is_qty_decimal       0

backorders              0

use_config_backorders           1

min_sale_qty         1

use_config_min_sale_qty       1

max_sale_qty        0

use_config_max_sale_qty       1

is_in_stock              1

low_stock_date     ( I leave this blank)

notify_stock_qty     0

use_config_             1

manage_stock        0

use_config_manage_stock      1

stock_status_changed_automatically 0

use_config_qty_increments    1

qty_increments     0

use_config_enable_qty_increments    1

enable_qty_increments           0

product_name             I don’t know why this appears again copy  and paste column H name

store_id                     1

product_type_id   simple

product_status_changed         I leave this blank

product_changed_websites    I leave this blank

image                          /image.jpg        v_products_image

Use the image name with the / and ensure jpg is lower case.  If you have directoryname/image.jpg then simply find and replace all directoryname/ with / to leave /image.jpg

Copy all the image files to /media/import and ensure permission on the files is 777.

small_image            copy and paste column from image

thumbnail                 copy and paste column from image

Moving to Magento

Your competitor has a new website with a modern, individual look and many useful functions. You have an open source 2 or 3 column standard layout that looks like any other shopping site available and offers only basis functions  Which website is a customer going to browse?

While osCommerce and ZenCart are not difficult to use or to understand how they work, are they rather dated and unable to do what customers require of a modern shopping website? I think its time to move on and I have chosen Magento.

It is a challenge. Magento works very differently and offers many more functions  with more ways to customise than either ZenCart or osCommerce could hope to offer. The downside? It’s complicated.

Rather than go live, I have installed it at home on my own server in order to test and understand how to manage the front and admin side.

My aim: to run 3 websites using one installation of Magento with one database, offering a selection of products through sites that look and feel different.

I am starting with the free 1.4.1 version and I’ll keep you updated on how i get on. Hopefully if you are a Magento beginner like me it will help you too.

In addition, the importance of SEO cannot be emphasised enough for any website. As well as marketing and promoting your online store, your cart software has to have great SEO compatibility and I think Magento is over and above ZenCart and OsCommerce.

Welcome

I considered for some time reasons for starting this, mainly focusing on time, commitment and content and have finally been motivated to get on and do it by reading the posts on the UK Business Forums so thanks to all the contributors there.

My blog will cover three main areas:

AllGiftsDirect news, products launches, promotions, discounts and other information.

Zen Cart Software – I have quite a bit of experience in running Zen Cart and find I can set up a site and be online with listed stock quite quickly. While not an expert I began with no knowledge of PHP or CSS and others starting out from a similar situation may be interested to pick up tips and shortcuts. I keep my own websites updated to the latest version and will post here what needs changing and how to do it.

E-commerce. Having spent years in the retail industry working in both small and large shops from independents to international chains, I have plenty of customer service experience. Although not strictly customer facing, customer service is still paramount to any business, on-line or not. Here I wish to reflect on e-commerce, eBay, Amazon and business in general.