Child pages
  • ERP Integration - Products
Skip to end of metadata
Go to start of metadata

The Magento ERP integration module includes an extensive set of features related to importing Product data from the ERP-system over to Magento. This is achieved by having the ERP-supplier provide a set of mainly CSV files with relevant product data.

The integration also supports continuous Stock Updates from the ERP-system over to Magento, also by letting the ERP-supplier provide simple CSV-files with the SKUs and its updated Quantity.

Product image import is also supported by simply saving the product images into a defined folder, while making sure the image file names are named the same as the relevant SKUs (Item codes). Multiple product images per product is also supported.

The various supported features:

Create and Update products from ERP to Magento

The ERP Integration extension is able to create both Simple and Configurable (variant) products from the ERP-system over to Magento using the CSV files that the ERP supplier saves to a defined folder on the Windows server running the ERP-system.

How does it work in practice?

The ERP-supplier creates files on a pre-defined Windows-folder (i.e. M:\ERP\Magento\Products\New\), containing one or multiple lines of new or updated products. The recommended filename for the product files is Timestamp (i.e. 20130403125511.csv).

Example 1: Create Simple products

The files a CSV file with semicolon ( ; ) as separator. The bold columns are mandatory.

The following example file consists of a few example products.

skunamedescriptionshort_descriptionpriceqtycategoryconfigurable_skuconfigurable_attributes
BAAF1551Ellingson ChairSome long descriptionSome short description59901212  
SL5Sinclair LampSome long descriptionSome short description1250551   
KF351Longburn FurnitureSome long descriptionSome short description3399512,87,551  

Example 2: Create Configurable (variant) products

When creating configurable products and attaching simple products to a configurable product, you have to specify which attributes should be used for the configurable product. This is specified in the configurable_attributes column.

skunamedescriptionshort_descriptionpriceqtycategoryconfigurable_skuconfigurable_attributescolorsize
LP120BLSBlack Summer JeansSome long descriptionSome short description4491212,2LP120color,sizeBlackSmall
LP120BLMBlack Summer JeansSome long descriptionSome short description44955112,2LP120color,sizeBlackMedium
LP120BLLBlack Summer JeansSome long descriptionSome short description4499512,2LP120color,sizeBlackLarge
LP120WHSBlack Summer JeansSome long descriptionSome short description4495512,2LP120color,sizeWhiteSmall
LP120WHMBlack Summer JeansSome long descriptionSome short description44919012,2LP120color,sizeWhiteMedum
LP120Black Summer JeansSome long descriptionSome long description449 12,2    

Notice

Icon

Please be aware that the configurable product has to be placed after the simple products. (Product with SKU LP120 is placed after all the variants of LP120)

Example 3: Simple products and Configurable products in the same file

When attaching simple products to a configurable product, you have to specify which attributes should be used for the configurable product. This is specified in the configurable_attributes column.

skunamedescriptionshort_descriptionpriceqtycategoryconfigurable_skuconfigurable_attributescolorsize
LP120BLSBlack Summer JeansSome long descriptionSome short description4491212,2LP120color,sizeBlackSmall
LP120BLMBlack Summer JeansSome long descriptionSome short description44955112,2LP120color,sizeBlackMedium
LP120BLLBlack Summer JeansSome long descriptionSome short description4499512,2LP120color,sizeBlackLarge
LP120WHSBlack Summer JeansSome long descriptionSome short description4495512,2LP120color,sizeWhiteSmall
LP120WHMBlack Summer JeansSome long descriptionSome short description44919012,2LP120color,sizeWhiteMedum
LP120Black Summer JeansSome long descriptionSome long description449 12,2    
KF351Longburn FurnitureSome long descriptionSome short description1291012,51,3    
SL5Sinclair LampSome long descriptionSome short description9909266,139    

Notice

Icon

Please be aware that the configurable product has to be placed after simple products. (Product with SKU LP120 is placed after all the variants of LP120)

How do I add additional attributes?

If you want to add additional attributes, just create a new column in the CSV file using the attribute system name in the first row.

Note that the attribute itself needs to be created manually in Magento before it can be imported into the system. Attribute values (i.e. Blue, Green, etc. in the color attribute) will be automatically created by the system.

Can I POST product updates directly towards Magento?

Yes. POST your CSV files to http://www.yourstore.com/navimage/product/import/ or for the update-only files use http://www.yourstore.com/navimage/product/update.

If you are running a Linux/Unix operating system with CURL at hand, you can run the following command to POST the files to Magento:

 

curl -sv --header 'Content-type: text/csv' --data-binary @itemsproducts.csv http://www.yourstore.com/navimage/product/import

 

How can I disable or change the status of a product in Magento?

Add a column product_status with one of the following allowed values:

Value
Details
1Active, i.e the product is Enabled in Magento
2Disabled, i.e the product is Disabled in Magento

Note that the status does not affect the product Visibility in Magento, however when a product is Disabled it will not be visible.

Also note that "physical" deleting (full removal) of products is not allowed through the integration, as this can cause serious troubles if used wrong. In order to delete products, you need to contact the support team or delete the products directly towards the built-in API in Magento.

Stock and Price update from ERP to Magento

Continuous Stock and Price updates shall be issued as a separated file. The files are in the CSV-format with semicolon ( ; ) as separator.

 

curl -sv --header 'Content-type: text/csv' --data-binary @stocks.csv http://www.yourstore.com/navimage/product/update

 

How does it work in practice?

The ERP-supplier creates files in the pre-defined Windows folder (i.e M:\ERP\Magento\mage_product_update\) with as many lines as wanted. The recommended filename of these files is Timestamp, i.e 20130210112404.csv).

Example

sku
qty
price
GA32594444.90
B730OO120159.90
NS243299

The header is optional.

Reserved / Special columns

Column Name
Description
skuUnique identifier of the product. This is what is used to look up and check if the product already exists.
qtyStock quantity. The number here will replace the current quantity in the store
priceProduct price
special_priceProduct Special Price
special_from_dateProduct Special Price From Date (format: DD-MM-YYYY), i.e. 18-01-2014 means from January 18th 2014 00:00
special_to_dateProduct Special Price To Date (format: DD-MM-YYYY), i.e. 18-01-2014 means from January 18th 2014 23:59
configurable_skuUsed to create/attach the current product to a new or existing configurable product. The column configurable_attributes must also exist (see below)
configurable_attributeComma separated list of attributes used when creating a configurable product
ext_categoryExternal category ID. All the Categories can be tagged with an external category ID and this ID can be referred to in this column. This can be a comma separated list
categoryList of Magento category ID's. Product will be placed into these categories.
product_statusSet status of the product. 1 = Enabled, 2 = Disabled
product_visibilitySet product visibility. 1 = Not visible, 2 = In catalog, 3 = In search, 4 = In catalog and search
product_taxclassMagento tax class ID.
attributesetID of the Magento Attribute set
product_crosssaleComma separated list with SKUs for the products to be attached as cross-sells
product_relatedComma separated list with SKUs for the products to be attached as related products
product_upsellComma separated list with SKUs for the products to be attached as up-sells
is_qty_decimalIndicate if the quantity is a decimal number. 0 = Not decimal (Default) 1 = Is a decimal
qty_incrementsQuantity increment for a product.

 

Image import from ERP to Magento

If the ERP-system contains high quality images per product, then these can be saved into a pre-defined Windows folder (i.e. M:\ERP\Magento\ImageImport\), where each image is saved with the filename the same as the SKU/Itemcode.

For products with multiple images, a "_x" can be added in the end of each filename, i.e. "MYSKU_1.jpg", "MYSKU_2.jpg", etc.

The Magento ERP integration reads the folder continuously and fetches and imports all product images, including creating three Magento image variations per original image. By default, the images are removed from the Windows-folder after being successfully imported.

The integration supports JPG, PNG and GIF files. Recommended file size is 100-500kB, with an image width of 800-1000px.

Category import

Categories can also be imported.

  • No labels