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