{"id":221,"date":"2011-02-27T19:29:46","date_gmt":"2011-02-28T03:29:46","guid":{"rendered":"http:\/\/www.squidskate.com\/artbobo\/?p=221"},"modified":"2011-07-03T12:09:21","modified_gmt":"2011-07-03T19:09:21","slug":"zen-cart-to-bigcommerce-conversion-or-migration","status":"publish","type":"post","link":"https:\/\/www.squidskate.com\/artbobo\/2011\/zen-cart-to-bigcommerce-conversion-or-migration\/","title":{"rendered":"Zen Cart to BigCommerce Conversion or Migration"},"content":{"rendered":"

Here are the steps to migrate your products from Zen Cart to Big Commerce. (This information can probably be used to migrate from OSCommerce as well.)\u00a0 It’s a little tricky to do smoothly. The basic process is to create a CSV file from your Zen Cart database then use the Import Products feature in BigCommerce. The tricky part ,of course, is to create the CSV file properly. It’s best to get your data organized in Zen Cart before creating the CSV file. NOTE: I wrote this for BigCommerce V6. The current V7 does not have a option import feature.<\/em><\/p>\n

1. Product names need to be unique. In Zen Cart, you can have two products with the same name. Big Commerce uses the product name to identify the product.
\nIf you have access to a SQL query tool like PHPmyadmin, you can use the following SQL query to check for duplicate names in Zen Cart:\ufeff<\/p>\n

select * from
\nproducts_description pd,
\n(
\nSELECT products_id, products_name,
\nCOUNT(products_name) AS NumOccurrences
\nFROM products_description
\nGROUP BY products_name
\nHAVING ( COUNT(products_name) > 1 )
\n)x
\nwhere pd.products_name = x.products_name<\/em><\/p>\n

2. All products need SKUs. While SKUs or product model IDs are optional in Zen Cart they are required in the import process by Big Commerce. I find that it’s good to have unique SKUs for products.
\nIf you have access to a SQL query tool like PHPmyadmin, you can use the following SQL query to check for duplicat SKUs in Zen Cart:\ufeff<\/p>\n

select * from
\nproducts p,
\n(
\nSELECT products_id, products_model,
\nCOUNT(products_<\/em>model<\/em>) AS NumOccurrences
\nFROM products
\nGROUP BY products_<\/em>model<\/em>
\nHAVING ( COUNT(products_<\/em>model<\/em>) > 1 )
\n)x
\nwhere p.products_<\/em>model<\/em> = x.products_<\/em>model<\/em><\/p>\n

3. Category names are mandatory for importing to BigCommerce.<\/p>\n

4. Image files are best imported to Big Commerce using the URL of image on the live Zen Cart site. This is a very nifty feature. I first tried importing all images using FTP but it’s a pain and unnecessary.<\/p>\n

Importing Variations. Zen Cart calls them attributes. Big Commerce calls them variations or options in V7.<\/p>\n

I had trouble when I imported the Variation CSV file. I had an option of “None” appear in BC with all products that had a variation. This is because the
\n“Force user to select variation option” checkbox was not checked. Unfortunately there is no way to force this in the import file<\/p>\n

Don’t import variations with only one option. You can but BigCommerce with force you to create another if you try to modify the option later. Use Excel =COUNTIF(A$2:A$9999,A2) to count variations in your CSV file .<\/p>\n

BigCommerce variations import still needs a lot of work.<\/p>\n

 <\/p>\n

–to be continued. This is a work in progress. I’m writing this to help others make an easier transition from Zen Cart to Big Commerce.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Here are the steps to migrate your products from Zen Cart to Big Commerce. (This information can probably be used to migrate from OSCommerce as well.)\u00a0 It’s a little tricky to do smoothly. The basic process is to create a … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-221","post","type-post","status-publish","format-standard","hentry","category-ecommerce"],"_links":{"self":[{"href":"https:\/\/www.squidskate.com\/artbobo\/wp-json\/wp\/v2\/posts\/221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.squidskate.com\/artbobo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.squidskate.com\/artbobo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.squidskate.com\/artbobo\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.squidskate.com\/artbobo\/wp-json\/wp\/v2\/comments?post=221"}],"version-history":[{"count":15,"href":"https:\/\/www.squidskate.com\/artbobo\/wp-json\/wp\/v2\/posts\/221\/revisions"}],"predecessor-version":[{"id":228,"href":"https:\/\/www.squidskate.com\/artbobo\/wp-json\/wp\/v2\/posts\/221\/revisions\/228"}],"wp:attachment":[{"href":"https:\/\/www.squidskate.com\/artbobo\/wp-json\/wp\/v2\/media?parent=221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.squidskate.com\/artbobo\/wp-json\/wp\/v2\/categories?post=221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.squidskate.com\/artbobo\/wp-json\/wp\/v2\/tags?post=221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}