Setting up integration with Magento

1. Introduction
2. setting up magento and control option
3. setting up category
4. import products from Magento.
5. import Debtor from Magento.
6. update Products in Magento.
7. Repopulate Products in Magento.
8. download orders from Magento.

Introduction

This is a document , which design to guild through the integration process step by step.

Setting up magento and control option

the first step for the integration, is to set up the control options. without the options setup correctly, all the following will not work. there are three places ,needed to be set up.

1, coaad page 2, need to run contrl

• Enable update to odbc data files = 'Y'
• Online Store use Cscart/Magento/None = 'M'

• Lasted downloaded Online order id = "an order number in magento , which and order <= will not get downloaded to control"

2, braad Sales tag, need to run brctrl

• Webshopper data source -- the xmlrpc interface of magento ,e.g.http://dev.daleandwaters.com.au/api/xmlrpc/

• webshop login user name -- the user name used to login to magento xmlrpc service, hosting company will need to give us this.
• webshopper login user password -- provided by the hosting company.
• Default online Saleperson -- pick any control operator
• default online customer -- pick any control customer

3, magento side * go to manage attribute sets and create a new set.

• assign three attributes to the set which contain all color , size and subsize.

4, configure gencont page 3

• Location for Webshop 1 = "the branch just been configured"
• default Magento attribute set = "the attribute just set up in magento", this field is a pick list , will only allow you select available set in magento. all item created from control will appear in magento belong to this set. Note that this is not Category.
• default Magento color attribute = "the attribute which contain all color in magento" is a pick list again, will only allow to pick the attribute belong to the selected set.
• default Magento size attribute = "the attribute which contain all size in magento"
• default Magento subsize attribute = "the attribute which contain all subsize in magento"

Setting up Category

we do not support , download of category from magento to control , or the other way , the category configuration has to be done manually. there are two way to do this

1. by impcamin, we need to put in the online_id of magento's category in the column "online_id", the online id of the category can be found in magento admin page , manage Category.
2. or by caaad when , creating a new category in caaad, user can enter the online_id, this field is only editable in creation time, no alteration is allowed after that.

Import products from magento

We need to get a csv file from magento, the csv can be obtained in magento admin page, system->Import/Export->profile->exprot_all_product. In case of ftp outbound not working, need to contact the hosting company, for the file.

after that , need to remove use less column in the header , and sort the csv in ascending order according to the SKU field

here is an example of what the original csv will look like.

here is an example of what the csv look like after the change.

then we will need to run

impmagstmin

select the updated csv file , it may take some time , depending on the size of the csv,

following points are very important , please make sure it is carried out

• please , make sure when running impmagstmin , the connection has been setup, (thes option in coaad , braad, gencont)

• please , run this program in the branch , specified in the gencont as webshop location 1, the program is will not choose it for you, you need to do a manual conset.

Importing customer from magento