magento extension :: iceimport (by shop owner) extension :: iceimport (by shop owner) ... go to...

11
Magento extension :: IceImport (by shop owner) System Requirements 1. Introduction 2. Installing 3. Configuration 3.1 Product attributes configuration 3.2. Module configuration Attributes mapping Import Parameters 3.2. Import configuration 4. Run import 4.1. Manually 4.2. Scheduler 5. Usual problems and usual solutions Contacts 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 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. if your distributor is already connected! Look here

Upload: truongdiep

Post on 17-May-2018

218 views

Category:

Documents


2 download

TRANSCRIPT

Page 1: Magento extension :: IceImport (by shop owner) extension :: IceImport (by shop owner) ... Go to System -> Import/Export -> Dataflow ... Sales info@iceshop.nl

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

Page 2: Magento extension :: IceImport (by shop owner) extension :: IceImport (by shop owner) ... Go to System -> Import/Export -> Dataflow ... Sales info@iceshop.nl

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:

Page 3: Magento extension :: IceImport (by shop owner) extension :: IceImport (by shop owner) ... Go to System -> Import/Export -> Dataflow ... Sales info@iceshop.nl

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

Page 4: Magento extension :: IceImport (by shop owner) extension :: IceImport (by shop owner) ... Go to System -> Import/Export -> Dataflow ... Sales info@iceshop.nl

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.

Page 5: Magento extension :: IceImport (by shop owner) extension :: IceImport (by shop owner) ... Go to System -> Import/Export -> Dataflow ... Sales info@iceshop.nl

MPN: 

Needs for import data from "mpn" field (from import file) to   the selected attribute.This value is required and can't be empty.

Page 6: Magento extension :: IceImport (by shop owner) extension :: IceImport (by shop owner) ... Go to System -> Import/Export -> Dataflow ... Sales info@iceshop.nl

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

Page 7: Magento extension :: IceImport (by shop owner) extension :: IceImport (by shop owner) ... Go to System -> Import/Export -> Dataflow ... Sales info@iceshop.nl

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

Page 8: Magento extension :: IceImport (by shop owner) extension :: IceImport (by shop owner) ... Go to System -> Import/Export -> Dataflow ... Sales info@iceshop.nl

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

Page 9: Magento extension :: IceImport (by shop owner) extension :: IceImport (by shop owner) ... Go to System -> Import/Export -> Dataflow ... Sales info@iceshop.nl

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"

Page 10: Magento extension :: IceImport (by shop owner) extension :: IceImport (by shop owner) ... Go to System -> Import/Export -> Dataflow ... Sales info@iceshop.nl

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".

Page 11: Magento extension :: IceImport (by shop owner) extension :: IceImport (by shop owner) ... Go to System -> Import/Export -> Dataflow ... Sales info@iceshop.nl

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