Marketing Solutions

is a UK company specialising in Website Design
Probably you already are a happy user of Store Manager for Zen Cart. Or maybe you've just started using it or consider this. You probably look for more detailed information about this software and its functionality. Than this article is what you're looking for. We will talk about product import - one of the complicated procedures in Store Manager.

This feature is for advanced Store Manager users. Import/Export wizard of Store Manager for Zen Cart allows you to import your data from any .csv file into Store Manager. Carefully follow the instructions given in Zen Cart Import Wizard on every page as you proceed with product import. Import is rather complicated procedure and it may be destructive if performed incorrectly. Thus, you have to create database backup before products import, especially if you do it for the first time.
Before you start Import/Export Wizard first thing you need to do is to prepare .csv file for import. You have to make sure it contains all necessary fields and all data you are going to import is listed in tables. After your csv file is ready choose import from the options available in Import/Expord wizard. Then specify the .csv file path and name or use browse button to select one. You can also load import settings to avoid configuring it each time you want to import products from a .csv file.
If everything is correct you can proceed to Source file preview which shows a part of .csv file selected to import. Here you should pay special attention to delimiters and enclosure. It's enough to look through the first line of the file to see whether some words are enclosed in quotes (") and are separated by comma (,) symbol. You will need these details in the next step.

Select fields delimiter and quote character. Delimiter character is used to separate one column from another. If incorrect delimiter is specified, file will not be parsed properly and products will not be imported. Quote string values delimiter will be used to separate strings in .csv file. If none are used, it can be disabled. Category delimiter character is used to separate category names and specify full category tree path for given category. Please note that if you specify the wrong values import may not work.

Link columns from .csv file to appropriate database fields. Tick the check box if the first row of your .csv file contains not values but field names. Select the appropriate Products Identification Method - import wizard will search for a product using selected method of identification. If the products is found it will be modified, if not - new product will be added.
Please note that it is recommended to use Product Name + Model to identify your products. Here are two panes: "Database fields" and ".csv File Columns". "Database Fields" pane displays the list of fields in your database that can receive import data. It is required to assign .csv columns to key fields. In order to do that you should select a field at the left pane and then click a column at the right pane.
You can set correspondence automatically for all fields using "Auto set..." option. But this option will work only if .csv column name is the same as database field name.

Next step - Base Formats and Separators. This step enables you to convert text values from .csv file to numerical and date values. You can easily set default values using the corresponding button. Import Preview allows you to see how .csv file was processed using import settings, which you specified at previous steps. Columns which were not assigned will not be imported due to the fact that empty values will overwrite existing.

Import Options settings may influence import results if not chosen correctly. It enables you to: choose import method, save import settings for future reference, etc. After you've got everything set and ready - press Import to start. When import process is completed you can view database details and errors which took place during product import (if there were any).
This might seem a bit complicated but each step of the wizard has very detailed description and instructions. If you follow them carefully your Zen Cart product import will be sucessfull.

Services we offer

Website Hosting

Standard Hosting Package

monthly (+vat)
 Domains - 1
 Disk Storage 3 GB
MySQL - 5 Databases
Bandwidth - 2048mb
Email Accounts - Unlimited
Control Panel - cPanel

Advanced Hosting Package

monthly + (vat)
Domains - 4
Disk Storage 4 GB
MySQL - 10 Databases
Bandwidth - 4096mb
Email Accounts - Unlimited
Control Panel - cPanel

Business Hosting Package

monthly (+vat)
Domains - 8
Disk Storage 8 GB
MySQL - 20 Databases
Bandwidth - 8192mb
Email Accounts - Unlimited
Control Panel - cPanel

We consistently deliver results through evolving marketing techniques, new developments and accredited partners.

sagepay approved partner
Google AdWords
Bing Ads
Zen Cart Shopping Cart
We are a UK Company specialising in website design

We will build you a website tailored to your specific requirements, some clients start from a scribble on a note pad and we help them and you maintain and develop the site as it grows and changes over time.

As everyone knows, design is very subjective and what one person may like, another might hate. Our designers and programmers are vastly experienced in all aspects of website design and development and we have hundreds of satisfied clients to prove it!
We are an honest company that strongly believes that we can create a great site for you which both looks and functions to the highest standards. Not only will we do this, but we will also only charge a fraction of the amount that you might expect to pay. Our prices for the quality of workmanship are hugely competitive.

Do you require a professional web designer to create a quality professional web design for your site? or are you looking for your site to be updated? If so you have come to the right place. Take a look through our site to see what we can do for you.

Website Design Company based in Northumberland.


Lev Cribb - Marketing Consultant & Managing Director at INBND Growth Marketing Consultancy

I love it when people exceed my expectations, especially in terms of turn-around times, skill-set and by being proactive. These are three of many reasons why I love working with Stuart. He is reliable and my first choice when it comes to HMTL design and webcasting management capabilities and where I have presented Stuart with […]

Read More
Krissy Rerucha, The Lewin Group

Thank you for stepping into the role of Webcast Manager for the last two days of the Lewin CCTP Learning Session 3 last week. We really appreciated the seamless transition between Martyn and yourself. I had been worried that we would have to spend time onboarding you with the logistics for each session, however you […]

Read More
Howard Greenland - Sash Window Revival

A Huge thank you to Stuart Perkins and team for my great new website and the continued support. Marketing Solutions created a brilliant website for my partners business so it made perfect sense to use them revamping my image with a new site. I found the pricing very fair, the communication excellent and the patience which […]

Read More

Contact Details

01670 708 200

Test Ring Me

Marketing Solutions
17 Saxilby Close
St Nicholas Manor
NE23 1AZ

Considering Marketing Solutions for your next project?
Get a free quote 
Simply Business

Business insurance provided through Simply Business.

View our insurance details