magento extension :: iceimport (by shop owner) extension :: iceimport (by shop owner) ... go to...
TRANSCRIPT
Magento extension :: IceImport (by shop owner)System Requirements1. Introduction2. Installing3. Configuration
3.1 Product attributes configuration3.2. Module configurationAttributes mappingImport Parameters3.2. Import configuration
4. Run import4.1. Manually4.2. Scheduler
5. Usual problems and usual solutionsContacts
System Requirements
Software:
PHP Version: >= 5.3.0
MySQL Version: >= 4.1.20
Packages: , , , , , , , , , curl dom gd hash iconv mcrypt pcre pdo pdo_mysql simplexml
:Settigns
Safe Mode: Disabled
allow_url_fopen Enabled
Memory Limit: >= 512M
Max. Execution Time: 0 OR >= 360 sec.
Access for installation:
Magento admin with permissions for:
Magento Connect Manager (musthave for install the extension);FTP access to shop folder or access to cron (musthave for setup cron);attributes control (musthave for install the extension);manage Products (musthave for install the extension);import/export control (musthave for install the extension);enable\disable the extension (musthave for checking\testing extension).
Access for checking\fixing problems:
Magento admin with permissions from "Access for installation" list
Plus additional permissions:SSH (it's desirable) or FTP access;
access to logs of web service (apache, nginx etc);access to enable logs in magento;access to log files of magento (magento-home/var/log)access to display proccess list of server, related to magento.
cron control (if has on shop; for testing extemsion);cache control (for testing);reindex control (for testing);access to database (checking of DB structure and that data is correct).
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 currentstock? Then you need Iceimport! Our service supplies the option to import any distributors assortment into Magento and calculate your salesprices based on your purchase prices (sent by distributor) and your margins or markup on a daily basis.
if your distributor is already connected!Look here
Iceimport imports products from distributors in any format send by any protocol and makes this compatible with Magento. Each day it imports yourproducts, filters the known errors out of it, calculates your sales prices, optionally replaces the product numbers and categories with standardizedproduct numbers and categories based on Icecat.
for Iceimport services to connect your distributor(s)Subscribe here
2. Installing
Go to Magento Backend PageGo to menu System -> Magento Connect -> Megento Connect ManagerUse login and password of your admin account to loggin to Magento Connect Manager
When you are there, you shouldsee page like:
1.
2.
There you have two ways how to install the extension:
Install New Extensions1.1. Go to page of the extension http://www.magentocommerce.com/magento-connect/iceimport-3950.html1.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.
Direct package file upload1.1. Go to our website to download the latest module http://www.iceshop.nl/index.php/nl/documentatie/cat_view/7-magento-modules1.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) mpn* Global
Brand name brand_name* Global
GTIN ean* Global
Delivery ETA delivery_eta* Global
Is Iceimport is_iceimport Global
.* Attributes code for "mpn", "brand_name" , "delivery_eta", "ean" can be changed in depend of settings in in "Attributes mapping" section
If you need import images via IceImport you also need change scope view to 'Global' from next attributes:
imagesmall_imagethumbnail
Now you need to add created attributes to “Default” attribute set into “General” group:
Go to , Magento Backend Page->Catalog->Attributes->Manage Attributes Sets Choose attribute set named “Default” and simply drag'n'drop newly created attributes (“mpn”, “brand_name”, “ean”, delivery_eta, is_iceimport) from “Unassigned Attributes” to “General” in “Groups” section. Press “Save Attribute Set”.
3.2. Module configuration
Go to System -> Configuration and select in 'CATALOG' sub-menu. IceImport
If you see 404 Error Page not found just Log Out from Backend & Log In again.
MPN:
Needs for import data from "mpn" field (from import file) to the selected attribute.This value is required and can't be empty.
Brand:
Needs for import data from "brand_name" field (from import file) to the selected .attributeThis value is required and can't be empty.
GTIN:
Needs for import data from "ean" field (from import file) to the selected .attributeThis value is required and can't be empty.
Delivery ETA:
Needs for import data from "delivery_eta" field (from import file) to the selected .attribute
Description of modules settings. Click here to expand...
Setting's name Description Defaultvalue
Note
Content Settings
Update GTIN Update attribute if set "Yes" Yes
Update MPN Update attribute if set "Yes" Yes
Update Brand Update attribute if set "Yes" Yes
Update name Update attribute if set "Yes" Yes
Update short description Update attribute if set "Yes" Yes
Update description Update attribute if set "Yes" Yes
Update prices Update attribute if set "Yes" Yes
Update stock Update attribute if set "Yes" Yes
All the settings in this section are valid and used only for existing products, for new products the value is Yes and it can't be changed
1. 2.
Update Delivery ETA Update attribute if set "Yes" Yes
Update products category Update attribute if set "Yes" Yes
Update status Update attribute if set "Yes" Yes
Update visibility Update attribute if set "Yes" Yes
Update stock availability Update attribute if set "Yes" Yes
Update URL key Update attribute if set "Yes" Yes
Import product images (viaCron)
If setting is enabled then image will be added to the queue for downloading Yes
Re-index Required Run re-index of all the content after finishing the import process Yes
Attributes mapping
MPN This value is required and can't be empty.
Brand This value is required and can't be empty.
GTIN This value is required and can't be empty.
Delivery ETA This value is required and can't be empty.
Import Parameters
Batch size This setting is responsing for the count of products that can be added per query 100
Import new products Add products from import file
if they aren't presented in shop's assortment.
Yes
Remove old products Remove products marked as "is_iceimport"
and not presented in import file.
Yes
Tolerance of difference (%) Indicator of removing old products (products in the store but doesn't exist any more in an importfile). If percentage of "old" products in store more than this value - in this case the removing process willbe canceled. If less - old products will be deleted (this process takes effect only to products imported viaIceShop Iceimport,
).any custom products that were created by yourself, won't be deleted
25
Set to active importedcategories
All new imported categories will be active Yes
Sort categories in ASC order If setting is enabled then sort order for categories changed
in depend of category name
Yes
Hide empty category Yes
Default tax for product You can select taxes from dropdown menu. This taxes was set for all imported products. None
ImagesQueueProcessingonly
If - all images will be downloaded automatically at the end of next import process.YESif - will be added only links for images, and customer wants - he can download them manuallyNO
from Iceimport Information Dashboard > Images Statistics.
No
3.2. Import configuration
Go to System -> Import/Export -> Dataflow - ProfilesSelect "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
Original Magento attribute names in first row Yes
Your settings page should look like
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"
1. 2. 3.
4. 5.
Don't close appeared browser tabwhile 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>importproduct/observer::load</model> </run></importproduct>
3. Please make sure Cron are configured on your store as service, it's required to get daily update.
5. Usual problems and usual solutions
Products didn't imported - please check if you are correctly created attributes in point 3Products don't update everyday - please check if Cron of your store working correctHow 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_jobHow can I run Sheduler job manually - very simple, just execute http://your_store_url.com/cron.phpIf you have an the store (categories which do not contain products) or unintentional (the ones that you want to hide),empty categories in you can make it through the Magento admin panel. For this you need to go (Catalog=>Manage Categories). Next, select a category from the list on the left and in the right panel, than selectin dropdown list "Is Active" => "No" and press button "Save category".
5.
If all had been set according to manual, and it still does't work for you, feel free to contact Iceshop support team.
Contacts
Tel +31 (0)30 273 5486 ICEshop BVDe Liesbosch 12D3439 LC NieuwegeinRoute
Fax +31 (0)30 276 0926
Support [email protected]
Sales [email protected]
Site www.iceshop.biz