1. Introduction
Do you want your distributor products assortment always up to date in your shop? Including the daily purchase and sales pricing? With the current stock? Then you need Iceimport! Our service supplies the option to import any distributors assortment into Magento and calculate your sales prices based on your purchase prices (sent by distributor) and your margins or markup on a daily basis.
Look here if your distributor is already connected!
Iceimport imports products from distributors in any format send by any protocol and makes this
compatible with Magento. Each day it imports your products, filters the known errors out of it, calculates your sales prices, optionally replaces the product numbers and categories with standardized product numbers and categories based on Icecat.
Subscribe here for Iceimport services to connect your distributor(s)
2. Installing
Go to Magento Backend Page
Go to menu System -> Magento Connect -> Megento Connect Manager
When you are there, you should see page like:
There you have two ways how to install the extension:
1.Install New Extensions
1.1. Go to page of the extension http://www.magentocommerce.com/magento-connect/iceimport-3950.html
1.2. Press button "Install Now" (you must loggin in to the the extension key)
1.3. Get the key and paste they key to Magento Connect Manager and press button "Install"
1.4. Table with information of the module should be appeared, please press button "Proceed" to finish the installation.
2.Direct package file upload
1.1. Go to our website to download the latest
module http://www.iceshop.nl/index.php/nl/documentatie/cat_view/7-magento-modules
1.2. Upload the package file via Magento Connect Manager Congratulations, you have been installed the module!
3. Configuration
3.1 Product attributes configuration
Go to Catalog -> Attributes -> Manage Attributes
Add new attributes with codes
Attribute name
Attribute code
Scope
Manufacturer product
number
mpn
Global
Brand name
brand_name
Global
Delivery Eta
delivery_eta
Global
European Article Number
ean
Global
Import by Iceimport
is_iceimport
Global
To import short & long summary description add next fields
Short Summary
Description
short_summary_description
Store View
Long Summary Description
long_summary_description
Store View
If you need import images via IceImport you also need change scope view to 'Global' from next attributes:
• image • small_image • thumbnail
Note: You may create attributes as dropdown type. For example brand_name (look at the image
3.2. Module configuration
Go to System -> Configuration and select IceImport in 'CATALOG' sub-menu.
If you see 404 Error Page not found just Log Out from Backend & Log In again.
Settings:
• 'Set to active imported categories' - all new imported categories will be active.
• 'Import product EAN' - if you don't want update product EAN on already exists product in catalog set this option on "No".
• 'Import product MPN' - if you don't want update product MPN on already exists product in catalog set this option on "No".
• 'Import product brand' - if you don't want update product brand on already exists product in catalog set this option on "No".
• 'Import product name' - if you don't want update product name on already exists product in catalog set this option on "No".
• 'Import product short description' - if you don't want update product short description on already exists product in catalog set this option on "No".
• 'Import product description' - if you don't want update product description on already exists product in catalog set this option on "No".
• 'Import product short summary description' - if you don't want update product short summary description on already exists product in catalog set this option on "No".
• 'Import product summary description' - if you don't want update product summary description on already exists product in catalog set this option on "No".
• 'Import product prices' - if you don't want update product prices on already exists product in catalog set this option on "No".
• 'Import product stock' - if you don't want update product stock on already exists product in catalog set this option on "No".
• 'Import product delivery eta' - if you don't want update product delivery eta on already exists product in catalog set this option on "No".
• 'Import product images (via Cron)' - import images (Attention only via cron).
◦ If you want import images earlier, than import should be ran by cron schedule, you may run magento cron manually, for this install additional extension Noovias Cronjob Manager, it will help you manage cronjobs schedule.
◦ After install Noovias Cronjob Manager do next steps:
▪ Go to System -> Noovias - Cronjobs -> Schedule and click on Add new job
▪ There in field "Job code" choose iceimport, and in field "Scheduled At" setup time on one or two minute ahead.
▪ Than run magento cron script by link http://your-shop-adress.com/cron.php
▪ Go to System -> Noovias - Cronjobs -> Schedule and look on status of iceimport cronjob, if it has status pending try to do step 3 again, repeat step 3 until the status should not be changed on "running".
• 'Default tax for product' - select default tax for imported product • Set import settings as you want and press 'Save config' button.
3.3. Import configuration
1.Go to System -> Import/Export -> Dataflow - Profiles 2.Select "Import All Products" and fill settings:
• "Profile Information" section set " Decimal separator " to " . " • "File Information" section
Setting
Value
Data Transfer
Local/Remote Server
Type
Remote FTP
File name
Import file name (ex: products.csv)
Path
Path to file (empty by default)
FTP Host
FTP Host (on example: ftp.iceshop.nl)
User Name
FTP User Name
User Password
FTP User Password
File Mode
BINARY
Passive Mode
Yes
• "Data Format" section:
Setting
Value
Type
CSV/Tab separated
Value Delimiter
\t
Enclose Values In
leave it empty
4. Run import
You are able to run import in two ways: manually and by scheduler (Cron):
4.1. Manually
Select "Run Profile" on left corner and "Run Profile in Popup"
Don't close appeared browser tab while import is not finished.
4.2. Scheduler
1. Edit IceImport config file placed at :
<magento_store>/app/code/community/Iceshop/Iceimport/etc/config.xml
2. Find <importproduct> block, and set <cron_expr> as you want: <importproduct>
<schedule>
<cron_expr>0 7 * * *</cron_expr>
</schedule>
<run>
<model>iceimport/observer::load</model>
</run>
</importproduct>3. Please make sure Cron are configured on your store as service, it's required to get daily update. How to setup magento cron on your server you may read there:
5. Usual problems and usual solutions
1.Products didn't imported - please check if you are correctly created attributes in point 3 2.Products don't update everyday - please check if Cron of your store working correct
3.How to setup Magento Cron - please check official wiki of Magento, there you can find how to setup
Cron system in right wayhttp://www.magentocommerce.com/wiki/1_-_installation_and_configuration/how_to_setup_a_cron_job
4.How can I run Sheduler job manually - very simple, just execute
http://your_store_url.com/cron.phpIf all had been set according to manual, and it still does't work for you, feel free to contact Iceshop support team.
